SUMMARY:

• 10+ Years of experience in IT industry which includes Analysis, Design, Development, Testing and Implementation of applications on Informatica and Microsoft SSIS, Talend 5.5.1.
• Analytical and solutions - oriented Senior IT Consultant and Technical lead with experience guiding teams through the SDLC and agile methodologies to improve efficiency of state-of-art-systems on time and under budget.
• Proposed and implemented enterprise encryption strategy for sensitive data conversion at Assurant HR and Finanace datamart's.
• Certified Power Center Data Integration 9.x:Developer Specialist.
• Experienced in the installation of informatica software in various environments.
• Propose and built data marts/data warehouse as per business needs for end user extracts and reporting purposes.
• Extensive experience in Healthcare domain and certified by AHIP with PAHM (Professional academy of HealthCare Management).
• Completed HealthRules training in 2013 and certified by HealthEdge.
• Have hands on experience on creating logical and physical data models using ERWIN/ER Studio.
• Experience in working on slowly changing dimension SCD type I and type II to fast ETL Mappings.
• Excellent experience in designing the Star and snowflake models for Data Warehouse, have good knowledge of data warehouse concepts like Inmon and Kimball methodologies.
• Experience in designing complex mappings using transformations like Expressions, Aggregators, Routers, Joiners, Rank, Sorter, Stored Procedure, Lookups, Sequence Generator and Update Strategy, webservice and HTTP transformations.
• Experience in designing of Dimension modeling using star schema and snowflake schema
• Experience on performing Testing and tuning database
• Good in preparing documentation and test plans, unit testing experiences.
• Experience in integration of various data sources like Oracle, SQL Server, MS-Access, Flat Files and XML Files into data warehouse.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. Excellent communication skills, management and leadership qualities.

TECHNICAL SKILLS:

Primary Skills: Informatica power center V9.6.1,Microsoft SSIS 2014, Talend 5.5, Informatica MDM, IDQ 8.6, power exchange.

Operating Systems: UNIX, MVS, Windows NT/XP/ 2000/2003/ 2007

Data Warehouse: Star Schema, Snowflake Schema, EDW, Data Marts.

Data modeling tools: Erwin, ER Studio

Languages: Fourth Gen - DB2 SQL, Oracle SQL, Microsoft SQL, PL/SQL, UNIX Shell scripting, HDFS, C, JAVA.

Development Tools: Informatica power center 9.X, Microsoft SSIS, Informatica cloud

Version Control: SVN, Endeavor,TFS, Panvalet

Jobs Scheduling: CA-7, Tivoli, Control-M, UC4(Automic)

Test: HP ALM

Databases: Oracle DB2, Mainframe DB2 5.6 and Microsoft SQL.

Configuration Tools: SCM configuration tool, Informatica version control, Dimensions, Team track, TODD, Putty, Ultra edit, Reflection FTP client

Domain Knowledge: Health Insurance, Pharmaceutical, P&C.

PROFESSIONAL EXPERIENCE:

ETL Informatica Sr developer/Architect

Confidential, MN

Responsibilities:

• Understand existing ESPP and EquityComp ETL code
• Create technical specification documents and review with business team for any enhancements.
• Create Talend jobs to read data from Oracle tables and create ESPP, EquityComp extracts.
• Work with EFT team to setup internal/external FTP mailboxes and in corporate in UC4 jobs.
• Unit test the results and support business team in system test phase.
• Create deployment plan and review with team.
• Create RFC’s to migrate code to production and schedule UC4 jobs as per business provided schedule.
• Work with business team to get better understanding of requirements.
• Involved in project design meetings with ADP to design payroll Datamart.
• Design Payroll Datamart from HRDW and Lawson data warehouse using star schema.
• Design logical and physical model of HRDW ADP Payroll datamart with dimension and fact tables.
• Work with DBA’s to build table structures in payroll Datamart.
• Create ETL mappings/workflows based on ETL specifications to send payroll extracts to ADP.
• Design/build staging tables for the inbound/outbound operations.
• Work with connect enterprise team to setup ftp process to send/receive files from ADP.
• Unit test the results in Dev environment and migrate the code to Model environment.
• Support user acceptance testing and generate extracts as per business needs.
• Create deployment documents and setup jobs in UC4 Model environment.
• Involve in project initiation/technical discussion meetings to understand requirements.
• Implemented automated process to extract quarterly date ranges based on job schedule date.
• Implemented process to truncate if PwC process is schedule to run repetitively in the same quarter else insert data.
• Created new SSIS packages as per existing Informatica logic in mappings/workflows.
• Unit test PwC files and work with business in system testing area.
• Work with EFT team to setup mailbox to FTP PwC files.
• Create deployment documents and setup jobs in UC4 environment.
• Work with business team to get better understanding of requirements.
• Create ETL technical specifications document and review with team.
• Extract eligible employee, spouse/domestic partners and COBRA eligible employee’s details from HRDW and LAWSON tables.
• Generate limeade extract with required columns from HRDW as per Limeade accepted format.
• Created reusable mapplet to decrypt employee social security information while generating Limeade extract.
• Unit test the results in Dev environment and migrate the code to Model environment.
• Support user acceptance testing and generate extracts as per business needs.
• Create deployment documents and setup jobs in UC4 Model environment.

ETL Informatica Lead

Confidential, IL

Responsibilities:

• Worked on enhancements to existing ETL code as per business identified BSR's.
• Create scenario's and work with team to execute and capture the results.
• Work with business team with identified issues and explain complexity of the BSR or PSR.
• Create reports and invoices based on claims inclusion and exclusion rules and communicate with SAP and RPS as part of unit testing.
• Create design documents for the proposed code fixes and review with business to get approvals.
• Work with business team to gather scenarios and execute in the unit testing phase.
• Setup unit test results review meeting and get approvals for SIT and UAT migration.
• Provide support to QA and business teams while performing testing in SIT and UAT regions.
• Trigger batch process from JAVA screens based on scenario's and capture results.

ETL Informatica Developer

Confidential, MN

Responsibilities:

• Worked with Data Architect to understand the business requirements and Convert business requirements in technical requirements.
• Worked on end to end ETL design of the project.
• Created ETL process to source data from IDM and create output file as per Aarete standards.
• Worked with automic scheduling to automate job schedule.
• Worked with cleo team to setup MFT process to FTP the files to Aarete on a daily basis.
• Version the code and deploy the code in QA and PROD.
• Worked with Data Architect to understand the business requirements and Convert business requirements in technical requirements.
• Worked on end to end ETL design of the project.
• Created ETL process to source data from IDM and cleanse data using Informatica DQ standards to create output file as per Emdeon standards.
• Worked with automic scheduling to automate job schedule.
• Worked with cleo team to setup MFT process to FTP the files to Emdeon on a daily basis.
• Version the code and deploy the code in QA and PROD.
• Responsible for working with Data Architect to understand the business requirements and Convert business requirements in technical requirements.
• Responsible for creation of landing zone tables for facility and practitioner once XML files are received from Midlands.
• Worked on ETL build for loading data from LZ to practitioner and facility stage tables as per business requirements.
• Worked on unit testing of LZ and STG tables after data load.
• Provide support to QA while performing paired testing and QA validation.
• Version the code and deploy the code in QA and PROD.
• Responsible for working with Data Architect to understand the business requirements and Convert business requirements in technical requirements.
• Responsible for end to end ETL design of the project.
• Responsible for creating ETL build to source data from IDM and create output files as per OPTUM standards.
• Developed MEDICAL and Pharmacy claims files as per requirements specified in s2t’s and created UNIX scripts to move files from UNIX server to Cleo.
• Version the code and deploy the code in QA and PROD.

ETL Informatica Lead/Architect

Confidential, MD

Responsibilities:

• Responsible for working with Data and Governance team to understand the business requirements and Convert business requirements in technical requirements.
• Design/build MLR tactical data store schema and build tables.
• Responsible for end to end ETL design of the project and mentoring the team members.
• Share the work with offshore team and capture the status to update to client.
• Responsible for creating the restart ability for ETL code.
• Implemented complex mappings to build MLR Tactical Data Store to store all the employer group size, paid claim and revenue data of NASCO and FACETS.
• Implemented mappings to load group and subscriber rebates data as per MLR rules in to group and subscriber tables. Involved in groups and subscribers rebates distribution process from 2011, 2012 and 2013 as per MLR mandates.
• Worked on performance improvement of MLR workflows by fine tuning the code, which drastically reduced the workflow execution time.
• Implemented process to create experience report in each quarter for analysis of the data by actuarial team.
• Implemented mappings to create XML files to feed HP Extream process to generate checks, EOHB and EOP’s.
• Created complex shell scripts to FTP files from UNIX to shared drives and import from shared drive to UNIX.
• Responsible for implementing Audit, Control and Balancing.

ETL Informatica Lead

Confidential, MD

Responsibilities:

• Created Informatica mappings to move data from FACETS to FACETS DA layer using power center process
• Involved in the process of exchanging data between environments using power exchange process.
• Created ABC (Audit Balance and Control) scripts to improve quality of workflows.
• Implemented filter logic to control dental data to flow from FACETS to FACETS DA, FACETS DA to EDM and EDM to CBI.
• Parameterized the code and created parameter files to automate workflows for every month.

Informatica Developer

Confidential, MD

Responsibilities:

• Gathering all technical and business requirements.
• Design the end to end solution of loading data in data acquisition layer (Staging Area ) and Claims Canonical.
• Design the end to end process to capture Audit, Balance and control information of the end to end project.
• Responsible for design, development of End to End ETL solution
• Create Informatica ETL mappings to extract data from VSAM files and load into staging area.
• Creation of Informatica mappings to read data from different staging areas apply all business rules and load in claims canonical.
• Experience in Design and Development ETL mappings.
• Creation of Mainframe JCL’s to run informatica workflows and used job schedulers like CA7.
• Used Constraint based load technique (CBL) as advance transformations.
• Working experience with multiple targets and performance tuning experience.
• Creation of Shell Scripts to ftp the files from different servers and also to parse session logs.