SUMMARY:

• Over seventeen years of experience in system analysis, design, coding and testing including AGILE methodologies of various business applications in Client Server systems.
• Strong experience in Dimension Modelling, Database Design using Star Schema/Snowflake modeling, Ralph Kimball methodology, designing FACT & Dimension tables.
• Expertise in complete SDLC (Software Development Life Cycle) on various application domain involving different technologies varying from open systems to Data warehousing on AIX and Win NT platforms. This involves working with the client for requirement gathering, collaborating with support, Testing team at different locations.
• Over twelve years of experience in designing and implementing Data Warehousing applications and Transformation processes using Informatica Power Center 9.6/9.1/8.6.1/7.1.1/6 x/5x /IDQ 9.6.1 (Repository Manager, Server manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer).
• Experienced in Client interaction, Requirement analysis and conversion of the same to high - level & low-level technical design.
• Exposure on Mongo DB; Big Data
• Certified in Informatica PowerCenter 7.1.1
• Expertise in RDBMS and experienced with Database administration, Design & modeling and experience in PL/SQL and Performance Tuning of application in Oracle.
• Experience in Open Systems, Pro*C and Unix Shell Scripting.
• Experience in Data Quality processes.
• Exposure in Informatica MDM
• Experience in developing .jil scripts for Autosys
• Proficiency in the areas of Technical Documentation.

COMPUTER SKILL SUMMARY:

ETL Tools: Informatica Power Center 8.6.1/8.6.1/8.1.1/7.1.1 / 6.2 ; IDQ 9.6.1

Database: Oracle 11g/9i/8.x, SQL Server 2008, Teradata13.11, Sybase

Languages: PL/SQL (8.X), SQL*Plus, Pro*C and UNIX Shell Scripting

Reporting Tools: Business Objects

Other tools: Rapid SQL, MS Office, MS Project/Visio, MS PowerPoint, Putty

Operating Systems: UNIX, Windows 7 / XP / NT

Version Control: Perforce, Clear Case, Visual Source Safe

Scheduling Tools: Autosys, Control M

WORK EXPERIENCE:

Confidential, NYC

ETL/Informatica Lead

Responsibilities:

• Responsible for leading team for DB Feeds applications which primary takes care of Finance, TLM and platform support.
• Shared Services Support for 40+ applications.
• Used Informatica PowerCenter 9.6 for Bug Fixes from various OLTP databases and other applications to the data mart and downstream applications .
• Executed all the life cycles of Re-engineering (Analysis, Problem Detection, and Problem Resolution).
• Worked on Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Analyzed complex Informatica mappings with extensive use of lookups Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic .
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Expertise in using different tasks ( Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait, Control ).
• Developing UNIX scripts and used them to automate the scheduling process
• Performing Unit/Integration/User acceptance/Production parallel testing .
• Documenting the changes for .

Confidential, NJ

ETL/Informatica Development

Responsibilities:

• Requirement gathering, analysis, High Level/ Low Level design of system.
• Used Informatica PowerCenter 9.6 for migrating data from various OLTP databases and other applications to the data mart .
• Executed all the life cycles of Re-engineering (Analysis, Problem Detection, and Problem Resolution).
• Worked with different sources like Relational, Mainframe (COBOL), XML and flat files (CSV).
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Created complex Informatica mappings with extensive use of lookups Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic .
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Expertise in using different tasks ( Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait, Control ).
• Exposure in Master Data Management concepts and Methodologies.
• Developing UNIX scripts and used them to automate the scheduling process
• Performing Unit/Integration/User acceptance/Production parallel testing .

Confidential, Manhattan, NY

ETL/Informatica Analyst

Responsibilities:

• Data Masking highly sensitive data from Prod to Non Prod environments.
• Requirement gathering, analysis, High Level/ Low Level design of system.
• Used Informatica PowerCenter 9.6 for migrating data from various OLTP databases and other applications to the data mart .
• Executed all the life cycles of Re-engineering (Analysis, Problem Detection, and Problem Resolution).
• Worked with different sources like Relational, Mainframe (COBOL), XML and flat files (CSV).
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Created complex Informatica mappings with extensive use of lookups Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic .
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Developing UNIX scripts and used them to automate the scheduling process
• Performing Unit/Integration/User acceptance/Production parallel testing .
• Weekly/Daily scrum call meeting with the client and across the various group in multiple locations

Confidential, Whippany, NJ

ETL/Informatica Analyst

Responsibilities:

• Requirement gathering, analysis, High Level/ Low Level design of system.
• Involved in the design, development and implementation of the on-boarding Convertible Bonds feeds for trade surveillance.
• Involved in working on POC for using Mongo DB using Informatica
• Used Informatica PowerCenter 9.6.1 for migrating data from various OLTP databases and other applications to the data mart .
• Executed all the life cycles of Re-engineering (Analysis, Problem Detection, and Problem Resolution).
• Worked with different sources like Relational, Mainframe (COBOL), XML and flat files (CSV).
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Worked on Ralph Kimball methodology, Star Schema modeling, Snowflake modeling to design FACT and Dimension tables.
• Created complex Informatica mappings with extensive use of lookups Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic .
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Expertise in using different tasks ( Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait, Control ).
• Developing UNIX scripts and used them to automate the scheduling process
• Performing Unit/Integration/User acceptance/Production parallel testing .
• Weekly/Daily scrum call meeting with the client and across the various group in multiple locations
• Documenting the changes for .

Confidential, Morristown, NJ

Lead ETL/Informatica Analyst

Responsibilities:

• Work with the TPA Client/Users and the Business Analysts Team to gather the Requirements & Specifications about the Client’s Insurance Claims and Polices data
• Analyses the Functional Aspects and translate them into Mapping Design documents between Client and MRAM interfaces adhere to MRACIS standard .
• Data Modeling and Database Planning & Design.
• Packages, Stored Procedures & Functions, Triggers and Views were created to perform Error Handling & Validation.
• Design & Develop Informatica Mappings & Workflows, Oracle Stored Functions, Oracle Views to integrate the Multiple/Heterogeneous Sources , both External & Internal to the Organization.
• Automate Workflows, create Pre- & Post- Session Commands , run the scheduled jobs using UNIX Shell Scripting.
• Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations .
• Extensively used PL/SQL for creation of stored procedures.
• Performed Performance tuning of targets, sources, mappings and session and performed pipeline partitioning.
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Performing Unit/Integration/User acceptance/Production parallel testing .

Confidential, Stamford, CT

Lead ETL/Informatica Analyst

Responsibilities:

• Requirement gathering, analysis, High Level/ Low Level design of system.
• Involved in the design, development and implementation of the Performance and Attribution (P and A) and building Total Return Data Mart.
• Used Informatica PowerCenter 7.1.1 for migrating data from various OLTP databases and other applications to the data mart .
• Executed all the life cycles of Re-engineering (Analysis, Problem Detection, and Problem Resolution).
• Worked on Ralph Kimball methodology, Star Schema modeling, Snowflake modeling to design FACT and Dimension tables.
• Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Joiner, Sequence generator transformations.
• Extensively used PL/SQL for creation of stored procedures .
• Performed Performance tuning of targets, sources, mappings and session and performed pipeline partitioning .
• Performed unit testing to validate mappings and populate the database
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Involved in UNIX scripts and used them to automate the scheduling process
• Performing Unit/Integration/User acceptance/Production parallel testing .

Confidential, Danbury, CT

ETL Analyst

Responsibilities:

• Analyzed the data movement (ETL) process and procedures for manufacturing data. Identified and assessed external data sources as well as internal and external data interfaces.
• Developed Informatica mappings to move data from various databases to Data warehouse (Reporting Database).
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations, and Mapplets in Mappings.
• Designed, Developed and Maintained of PL/SQL procedures, functions that were used along with Informatica mappings to populate Oracle Tables.
• Used TOAD to work with database.
• Extensively worked on tuning the mappings and workflows.
• Responsible for user defined partitioning to improve the session performance.
• Involved in Files FTP directly to the Informatica Server and stage them on a local directory for the session run.

Confidential

ETL Analyst

Responsibilities:

• Developed strategies on ETL designing for data modifications and flow.
• Developed mappings in Informatica to create data flow logic.
• Coding for Pro*C batches to create data flow logic.
• Create shell scripts to automate jobs and other processes.
• Developed Stored procedures and other SQL queries required for the project.