OBJECTIVE:

Over Twenty Three years of progressive experience in IT field which includes more than Twelve years in Datawarehousing specializing in Extract Transform and Load (ETL) and Ten years of Pharmaceutical Industry experience and over 5 years of Financial industry experience. More than Ten years of experience working with Onsite - offshore Projects. Has Pharmaceutical, Manufacturing, healthcare, Insurance, Space Systems, Utility and Banking industry experience.

SUMMARY:

• Have over Twenty Three years of progressive experience in the IT field which includes more than Twelve years in data warehousing and specializing in Extract Transform and Load (ETL) and Ten years of Pharmaceutical industry experience.
• Worked extensively with Informatica Power Center over Fifteen years.
• Worked with Informatica as an ETL tool for the extraction of data from various sources like Oracle, flat files, Db2, Sap R3, Cobol files, XML files, etc.
• Worked with Kimball's SLDC technology and has a very good knowledge of dimensional models.
• Created ETL mappings, mapping documents, mapplets, reusable transformations, sessions, mapplets, workflows, and scheduling of ETL process.
• Written PL/SQL procedures, worked on performance tuning of ETL mappings, debugged mappings and mapplets, written Unix scripts, worked on production support, worked with the modeling tool ERwin, created test cases and test plans, and moved objects from development to test and test to production environments.
• Created workflows, worklets, session tasks and other tasks, and reports using Business Objects.
• Worked on data extraction from SAP system and data load to SAP using Informatica and also worked with the customer master MRM tool Siperian.
• Deep knowledge of data warehouse concepts and slowly changing dimensions. Some hand on experience with SAP BW development and Reporting in BI 7.0.
• Performed different roles such as Senior ETL developer, ETL Architect, ETL Support and Team Lead in the datawarehouse and Data Migration projects.
• Has extensive experience in managing teams, motivating people to get the deliverables on time and ahead of time.

EXPERIENCE:

ETL Informatica Architect

Confidential, NC

Environment: Informatica 9.6.1/ Informatica 10.x, DB2, Unix, SQL, SAP BW, ECC, Toad Analyser, ESP Scheduler, Sharepoint, HP ALM.

Responsibilities:

• Created Business Requirement Documents, Functional Specification documents and the Technical Specification documents.
• Participated on the meetings with the SME's to get understanding the source systems and the requirements on the target data load.
• Performed Data Analysis, Data Validation and Data verification.
• Created the Data migration plan and Informatica Code Migration Checklist.
• Created implementation plan for the ETL objects migration into the higher environments including Production.
• Created the documents for the ESP job submission request.
• Worked with the banks Financial Transactional data and Statistical data.
• Designed and developed Informatica Process to extract the data from the source systems and load into DB2, SAP BW and SAP ECC.
• Performed the activities of the Lead ETL Architect.
• Conducted code reviews on the new ETL process and the updated ETL Processes.
• Motivated the team, provided necessary Knowledge Transfer to bring them upto speed.
• Worked with the ALM tool to run the SIT and UAT test scripts.
• Expert on working with Change Requests, Defects and incidents.
• Performed the Informatica Administration tasks to support the team.
• Work with the DRM’s Master Data management and loaded the master data (Hierarchical data into the Mart and into BW).
• Worked with Onsite ETL resources and offshore ETL resources.
• Worked on the Post Production Support on the ETL applications.
• Worked with Job scheduling tool ESP.
• Worked on the Informatica Upgrade from 9.5.1 to 9.6.1.

Confidential

Solution Architect

Environment: Informatica 9.1, Informatica Data Quality 9.x, Oracle 11g, Unix, SQL, PL/SQL, SQL Developer, VMS Files, SQL Loader, Sharepoint, MIDAS. Informatica B2B

Responsibilities:

• Extracted the pre clinical data from various source systems and load into the target database.
• Participated on the meetings with the SME's to get understanding the source systems.
• Performed Data Analysis, Data Validation and Data verification.
• Designed the Data migration plan.
• Worked with SQL Loader to load the data form source Files into the Oracle tables.
• Designed and developed Informatica Process to extract the data from the source systems.
• Performed the activities of the Lead ETL Architect.
• Worked on import and export of the Oracle databases.
• Worked with the data quality tool Informatica Developer.
• Performed the Informatica Administration tasks to support the team.
• Work on Confidential ’s SDLC activities and solid knowledge on SDLC process.
• Leading a team of 2 on shore and 6 off shore developers.
• Worked on the Migration from Power center 8.1 to 9.1.
• Worked with Java to parse the VMS records and load them into the Oracle tables.
• Worked with Informatica B2B, parsers, serializer, mapper and other components of B2B.

Confidential

Principal Consultant

Environment: Informatica 7.1/8.6/9.1, Ascential Datastage 7.x/8.x, Oracle 9i/10g/11g, Unix, SQL, PL/SQL, Ez Sql, DB visualize, Toad, PLSQL Developer, Siperian, Win Scp, Mainframe Cobol files. DB2, Quality Center, Tivoli, Control M, autosys.

Responsibilities:

• Worked as ETL Architect and as Team lead on the projects.
• Worked with offshore teams on the projects located at India, Vietnam.
• Extensive experience on Data Analysis, Data Validation and Data Profiling.
• Extensive experience with Customer Master & Product master.
• Created data analysis, validation, profiling documents.
• Worked with the data validation and data profiling tools like Informatica Data Explorer, Informatica Data Quality, Quality Stage.
• Worked with Informatica Power Exchange.
• Worked as a Senior ETL developer.
• Worked with Healthcare’s claims and Members data.
• Worked with the MDM tool Siperian, loaded data into staging, base Object tables.
• Familiar with manual merge, auto merge and consolidation of data with the MDM tool Siperian.
• Lead teams of 6 to 10 Informatica developers in various projects.
• Worked on Upgrading different versions of Informatica from 5.1 to 6.1 & 7.1.1 to 8.6.
• Extensive experience in working with the ETL tool Informatica.
• Experience in Designing Parallel Jobs with Datastage.
• Designed Server Jobs, Job sequencers and batch Jobs in Datastage 8.1.2 and 8.5.
• Designed the ETL process using the components in Informatica.
• Worked with the data migration projects.
• Worked on various dataware house projects.
• Worked with XML sources and Targets.
• Designed data models using ERWIN and Oracle Datamodeler.
• Worked with Star schema, Snow flake schemas.
• Worked on multi terra byte datawarehouse environments.
• Has experience in working with the Off shore - onsite teams.
• Developed complex Informatica Mappings, worked on tuning the mappings.
• Worked on the Administration of Informatica.
• Created workflows, worklets, sessions and various tasks.
• Created folders, users, user groups and assigned previleges to the users in Informatica.
• Worked as a Informatica Admin and Installed informatica in different environments. Created backups and restore of Informatica environment.
• Designed technical documents to develop the Informatica Objects.
• Worked with different job scheduling tools like Autosys, Control M.
• Worked with IMS data health care organizations data, Health care professionals data, Sales and marketing data (Xponent data)
• Worked with the JMS (Java Messaging Service)
• Extracted data from SAP tables and loaded into flat files as well as Oracle tables.
• Extracted data from various SAP sources MM, QM, PM, PS, EHS, STC, RTP, MMSTR, BP, FIN etc.
• Solid knowledge on the SAP data on the modules MM, QM, PM, PS, EHS, STC, RTP, MMSTR, BP, FIN etc.

Confidential, FL

Environment: Informatica Powercenter 6.2, Oracle, PL/SQL, Erwin, Unix, Sql Navigator, Sap/R/3,Idocs, Power Connect for Sap/R3.

Responsibilities:

• Created the mapping documents based on the business rules.
• Created Informatica mappings to create flat file outputs to feed the SAP/R3 system.
• Created Informatica mappings to create IDOCS.
• Extracted data from SAP and loaded the cross reference tables.
• Involved in requirement gathering and project planning.
• Tested and executed the Informatica Mappings and resolved the issues within the mappings.
• Created Workflows, Session Tasks, worklets, executed them and monitored them from workflow monitor.
• Written the PL/SQL procedures.
• Involved in analysis of data in various modules of the project.

Confidential, NJ

Environment: Informatica Powercenter 6.2, Oracle 8I/9I, PL/SQL, Erwin,Unix,Shell Scripting,Sql Navigator.

Responsibilities:

• Created the mapping documents based on the data model and the client requirements.
• Created Informatica mappings to load Clinical trial data into the patient table, visit table and the Data point table for various protocols as per client requirements.
• Created Informatica mappings to load Mercks Confidential data into the warehouse target tables.
• Involved in requirement gathering and project planning.
• Worked on production support .
• Tested and executed the Informatica Mappings and resolved the issues within the mappings.
• Created Workflows, Sessions, Tasks, worklets, executed them and monitored them from workflow monitor.
• Written the PL/SQL procedures for loading data into the Warehouse.
• Responsible for testing of ETL maps
• Prepared test cases and test plans.
• Worked on performance tuning.
• Involved in analysis of data in various modules of the project.
• Worked with the data modeling tool Erwin.
• Written Unix Shell scripting for job scheduling.
• Worked with MS-Excel spreadsheet and MS-Word for Documentation.

Confidential, IN

Environment: Informatica Powercenter 5.1/6.1, Oracle 8I, PL/SQL, Erwin,Teradata,Unix,Shell Scripting,Business Objects,Trillium,Toad,Sql Plus.

Responsibilities:

• Created the mapping documents based on the data model and the client requirements.
• Worked with the Clinical trial data(Drug vs Patient) to load the data Into the warehouse for various studies.
• Developed Informatica Mappings as per the documents.
• Written the PL/SQL procedures for loading data into the Warehouse.
• Responsible for testing and migration of ETL maps from the development to production environment.
• Tested and executed the Informatica Mappings and resolved the issues within the mappings.
• Worked with the data analysts and SME’s to get to know the business rules and Implemented the rules in the source to target mapping.
• Prepared test cases and test plans.
• Loaded data from Teradata into the datawarehouse.
• Worked on performance tuning.
• Used power connect for SAP for pulling the data.
• Involved in analysis of data in various modules of the project.
• Worked with the data modeling tool Erwin
• Written Unix Shell scripting.
• Worked with the data cleansing tool Trillium
• Worked with MS-Excel spreadsheet and MS-Word for Documentation.

Confidential, Roche, NJ

Environment: Informatica Powercenter 5.0, Oracle 8I, PL/SQL,UDB,Teradata,Sql Navigator,Sql Plus,Erwin, Unix,AIX,Shell Scripting,Business Objects.

Responsibilities:

• Created the mapping documents based on the data model and the client requirements.
• Developed Informatica Mappings as per the documents.
• Written the PL/SQL procedures for loading data into the Warehouse.
• Responsible for testing and migration of ETL maps from the development to production environment.
• Worked on performance tuning.
• Prepared test cases and test plans.
• Loading the EDI data received from the wholesalers and the distributors which are lying in the Unix box into the datawarehouse in daily and weekly basis.
• Worked with Pharmaceutical Sales and Marketing data
• Worked with power connect for SAP.
• Loaded data from Teradata into the datawarehouse.
• Worked with SMG data,XPONENT data,CUSTOMER MASTER