An IT professional with 6.8 years of experience in software solution design, development, maintenance, testing and implementing solutions on Business Intelligence/Data warehousing applications. Having good experience in all phases of the SDLC. Acts as technology advisor to the BI and Analytics platform Product/Development Management Experienced in providing solutions for data integration of disparate data sources like Siebel CRM, Salesforce CRM, Oracle11g, Sybase, Teradata, Microsoft SQL Server, EPIC(EMR) and Flat files into the target tables using Informatica Powercenter 9.x as well as Informatica Cloud. Knowledge on Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. Experienced in creating various mappings, sessions and workflows in Informatica Powercenter. Experienced in creating various cloud tasks and mappings in Informatica Cloud. Experienced in performance tuning of various Informatica mappings using Pushdown Optimization. Knowledge in creating Logical/Physical data models using Erwin. Managing a team of 4 members at offshore. Experienced in writing basic UNIX shell scripts and job scheduling tools such as TWS & Control-M. Good knowledge in statistical analysis using R. Excellent problem solving and analytical skills. Having good communication skills and proficiency of grasping new technical concepts quickly and utilize the same in a productive manner. Having good domain knowledge in Healthcare (Payer/Provider) as well as Banking & Financial Services.
Senior Data Integration Analyst, Accenture
Dec 2014 to Present
• Interacted with business analysts and translate business requirements into technical specifications. • Preparation of TDD (Technical Design Document). • Designing and developing complex ETL Informatica mappings including Informatica Could jobs. • Created sessions and workflows based on the requirements. • Created various reports/dashboards as per business requirements. • Writing test Cases and preparing the test results for Unit testing. • To schedule the jobs in Tivoli/Control-M in test region for system and Integration testing. • To monitor the jobs and fix the issues/failures within the SLA in PROD Application Coordinator for Epic Modules – Bridges, Tapestry AP Claims & Contracts, Reporti ng work bench(RWB). Supporting Application migration from Diamond Xcelys to Epic Tapestry & Bridges for North West, Huawei, Mid Atlantic, SCAL, NCAL regions. Monitor ETL, Bridges (Interface) jobs across the system from Epic to KPCC Database, ETL Servers. Provider service support if job fails. Analyzing the Interface error and remediation. Preparing the EDI Summary reports using the Cache Routines in Lookiit Prompt. EDI Error report extraction on daily basis. Supporting new Bridges interface creation, deployment & down time support. Epic Upgrades & down time support. Continuous Improvement, Identifying and automating the manual tasks. Support the job scheduling activities for Epic Bridges and Tapestry modules. Support the Pre-Implementation and Go- Live activities. Worked on changes in Test and migrated them to Prod using Data Courier.
IT Analyst, Tata Consultancy Services
Apr 2010 to Jan 2015
ETL Informatica Consultant
B.E/ECE, Anna University
Jul 2005 to Apr 2009