Experience Summary

• Over 9 years of experience in data warehouse development lifecycle management projects.
• Worked in Utilities, Telecom, Healthcare, Banking related Data Warehouse domains with Clients
• JPMC USA , Healthnet USA , Duke Energy and USA and Vodafone Germany respectively.
• Experience in working with business analysts to identify study and understand requirements and
• translate them into ETL design.
• Specialized in ETL Solution Design.
• Experience in Agile, Waterfall methodology
• Strong Data Modeling experience and Entity-Relationship design modeling, Dimensional/Hierarchical
• data modeling, Star and Snowflake schema data modeling.
• Strong skills in the evaluation and recommendation of ETL best practices to various technical groups
• including data modelers and developers.
• Experience in writing, testing and implementation of PL/SQL stored procedures, triggers, functions,
• packages using Oracle and stored procedures and triggers using SQL Server.
• Worked on Teradata data sources and targets for very large data marts.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Created UNIX shell scripts to automate and implement workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of
• the data warehouse infrastructure.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Excellent analytical/communication skills and good team player.
• Worked in Informatica ETL tool for more than 5 years.

Relevant Project Experience:

Confidential

Technology: Informatica, Teradata,Unix,DB2,Control

One of the primary goals of this project is to ensure that the end users have the similar experience in the ICDW environment as they did in the EDW environment.

• The first release will be limited with Deposit and some Channel scope for staging only
• Subsequent releases will include both Staging and the Lightly Modeled layer with views.

Sr. Informatica Developer /Teradata Developer

• Gathered requirements from users / Functional Team for Design, Development, Testing and Deployment stages.
• Prepared technical specification document for the development of Informatica ETL mappings to load data into various target tables and defining ETL standards.
• Define and implement ETL development standards and procedures coding guidelines, best-practices, naming convention .
• Development of ETL using Informatica and Teradata.
• Release Management.
• Post Production Support
• Co-ordinate with Off-Shore team in INDIA.

Confidential

Technology: Informatica, ORACLE, UNIX, DB2, TeraData

Informatica developer/DB2 Developer.

• Development of ETL using Informatica, Oracle and DB2.
• Preparation of Technical Design Document for PLMR.
• Preparing test cases and unit testing of developed ETL's.
• Data Profiling.
• Worked in DB2 Stored procedures.
• Written Unix Shell Script.
• Release Management.
• Post Production Support

Confidential

Technology: Informatica, ORACLE

Lead ETL Solution Designer / Informatica developer.

• Designing of Aggregate Tables from Fact and Dimension by understanding the requirement of KPI Reports.
• Development of ETL using Informatica and Oracle.
• Handling daily status and issue call with client along with Team.
• Preparation of Technical Design Document for KPI's and Membership Extract Module.
• Preparing test cases and unit testing of developed ETL's.
• Leading Membership module understanding the requirement from Solution's onshore team.
• Data Profiling.
• Preparation of TSD and delegating the task to junior team members.

Confidential

Technology: Informatica, ORACLE

Lead ETL Solution Designer / Informatica developer.

• Module Lead for project module Business Objects Replacement
• Direct communication with client team to understand the requirements for designing end to end ETL's
• Development of ETL using Informatica
• Preparing test cases and unit testing of developed ETL's
• Handling defects/change request during system test and Mock
• Delegation of day to day work to the team members
• Consolidating the day to day status from the team and sending it to the client Team
• Scheduling and monitoring the sessions in development environment
• Handling daily status and issue call with client along with Team
• Preparation of migration check list and checking all the ETL's are as per the migration check list

Confidential

Technology: Informatica, ORACLE, UNIX

Informatica Developer

• Understanding requirements and translation of functional requirements to technical specifications
• Designing and reviewing of Informatica mappings and Technical design documents
• Developing of mappings to load the data in fact and dimension tables
• Developer and tester of Informatica ETL jobs
• Bug fixing and post Go-live support
• Documenting each phase and learning's, for future use in Release 2
• As the Code migration manager for the team, I was responsible for Code movement activates among various environments

Confidential

Technology: SSIS, Sql Server 2005

Informatica Developer

• Development of ETL codes using SSIS.
• Understanding of Requirement of Client.
• Testing of all the jobs to meet their corresponding business requirements and first day run support to Production Support Team.

Confidential

Technology: SSIS, Sql Server 2005,

Informatica Developer

• Development of ETL codes using SSIS.
• Understanding of Requirement of Client.
• Testing of all the jobs to meet their corresponding business requirements and first day run support to Production Support Team.

Confidential

Technology: Oracle 9i, Oracle Forms Reports 6i

• Designing of Forms and Reports.
• Writing Back-end Batch Procedures, Triggers, Sql scripts.
• Interaction with the Onsite Coordinator Client for requirement analysis.

Confidential

Technology: Oracle 9i, Oracle Forms Reports 6i

The applications in Mainframe were developed using CSP-CROSS SYSTEM PRODUCTS, CICS-COBOL for online screens and batch processing scripts. These so called online screens are mapped into ORACLE D2K FORMS/REPORTS and Batch applications are mapped into PL/SQL Codes Procedure, Functions, and Packages responsibility. The Main Modules for which I am responsible are: ITAX, PAYCAL, POST PAYCAL, COINS.

• Designing of Forms and Reports
• Writing Back-end Procedures, Triggers, SQL Scripts.
• Interaction with users for requirement analysis