SUMMARY

• Over EIGHT years of IT experience in analysis, design, development and implementation of Data warehousing technologies.
• Experience in all phases of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post implementation review.
• Over EIGHT years of extensive experience in Informatica PowerCenter with Strong Business Understanding Knowledge of Health Care/Retail projects.
• Over EIGHT years of Database experience using DB2, Oracle 10g/9i, Teradata, MS SQL Server
• Knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, Data Marts, Kimball Methodology used In Relational, Dimensional and Multidimensional Modeling.
• Extensively worked in tuning and troubleshooting the Informatica mappings to perform maximum efficiency and performance.
• Extensive experience in UNIX Operating System and Perl scripting.
• Experience in advanced Informatica concepts like PDO and data quality analysis skills.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Quick learner and adaptive to new and challenging technological environments.
• Experience in working with offshore teams to co-ordinate tasks.

TECHNICAL SKILLS

Operating Systems: UNIX AIX 5.2/5.3, Windows 98/2000/XP/NT 4.0.

ETL Tools: Informatica Power Center 7.1.3/8.1/8.6/9. x, IDQ.

Data Modeling Tools: Erwin 7.3.

Scheduling Tools: Unicenter Workload Manager, Control-M.

Other Tools: IBM Rational Clear Case Versioning Tool.

Databases: Teradata 13.10, Oracle 10g/9i, IBM DB2 UDB, MS SQL Server 2003/2005, MS Access.

GUI: Teradata SQL Assistant version 13.10, TOAD, IBM Data Studio, DB Visualizer.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl Scripting and C.

PROFESSIONAL EXPERIENCE

Confidential, Wallingford, CT

Onsite ETL Technical lead

Responsibilities:

• Requirement Gathering
• Cascading requirements to offshore
• Interacting with client and provide business solutions.
• Design ETL processes, load strategy
• Data profiling/extensive analysis
• Documenting technical design, provide design walkthrough to Architects and finalize the design.
• Peer reviews and Quality Assurance of deliverables
• Interacting with all the downstream consumers
• Work with Data Integration team for all the Informatica admin related works.
• Handling all the Pre Staging/Staging related ETL works

Environment: Informatica 9.1.1, IDQ, IBM DB2 UDB, IBM Initiate, UNIX, Control M, IBM Rational Clear Case, IBM Data Studio.

Confidential, North Haven, CT

Responsibilities:

• As a technical Lead/Onsite coordinator, Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Involved in requirement gathering creation of use cases, usage scenarios and solution architecture.
• Performed data analysis based on the business rules.
• Created customizable mapping by passing parameters at session level.
• Interacted with the customer and provide the business solutions.
• Providing regular project update and hosted status report meetings with client.
• Providing the training to the team members and also the knowledge sharing.

Environment: Informatica Power Center 8.1.1, IBM DB2, Trillium, UNIX Shell Scripting, IBM Rational Clear Case.

Confidential, Round Rock, TX

ETL technical onsite lead

Responsibilities:

• Gathering reporting requirements, data quality analysis.
• Onsite - Offshore coordination
• Understanding the data warehouse architecture, ETL design as per client standards.
• Data cleansing logic implementation
• Frequent interaction with Teradata DBA/Infa Admin’s

Environment: Informatica Power Center 8.6.1, TOAD, Nexus, TD SQL Assistant, SQL Server Management studio and Control-M Job scheduler, TD loader utilities - FEXP, Fast Load, Multi Load, Tpump.

Confidential, Round Rock, TX

Technical lead/Onsite coordinator

Responsibilities:

• Gathering migration requirements.
• Performed data quality analysis based on the business rules.
• Understanding the data warehouse architecture, ETL design as per client standards.
• Designing and developed Informatica mappings and Sessions based on user requirements and business rules.
• Teradata admin tasks like create tables, collect stats, creating indexes, and grant access, TD utilities (FastLoad, Mload, Fast Export, Tpump) setup.
• Involved in data cleansing and analysis of DTS packages.

Environment: Informatica Power Center 8.6.1,Teradata, Oracle, SQL Server, TOAD, Nexus, TD SQL Assistant, SQL Server Management studio and Control-M Job scheduler.

Confidential, Thousand Oaks, CA

Offshore Lead

Responsibilities:

• Played role as Offshore Lead in the initial phase of the project and later joined as onsite ETL lead.
• Lead team of 8 informatica developers
• Gathering migration requirements.
• Performed data quality analysis based on the business rules.
• Understanding the data warehouse architecture, ETL design as per client standards.
• Designing and developed Informatica mappings and Sessions based on user requirements and business rules.
• Documenting the mapping specifications.
• Preparation of test cases and executing the test cases.
• Involved in Unit and Integration Testing.

Environment: Informatica Power Center 8.1.1, Oracle 10g, IBM DB2 and TOAD.

Confidential

Module Lead

Responsibilities:

• Analyzing the requirements.
• Involved in coding/testing and debugging of the code developed.
• Module task allocation for team members.
• Involved in Unit testing and Integration testing.

Environment: Informatica Power Center 8.1.1/8.6.1 , Mainframes, Oracle 10g and TOAD.

Confidential

Informatica Developer

Responsibilities:

• Designed and developed Informatica mappings and sessions based on user requirements and business rules.
• Performance tuning of the Informatica mappings.
• Analyzing the business requirements.
• Identifying and providing the solutions of the issues.
• Created the test cases and execution of test cases.

Environment: Informatica Power Center 7.1.3/8.1.1 , Mainframes, Oracle 10g and TOAD.