SUMMARY:

• 5+ years of experience in Designing, Developing, Maintaining and Building large business applications such as Data Migration, Integration, Conversion, Data Warehouse and Testing.
• Experience in all phases of Software Development Life Cycle (SDLC) Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in Data Warehousing, ETL Architecture. Experience in working with various versions of Informatica PowerCenter 8.6/8.5 Client and Server tools.
• Knowledge in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs. Experience in integration of various data sources like SQL Server, Oracle, Flat Files,
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping. Involved in writing Unit test cases for complex scenarios.
• Expert in developing slowly changing dimensions Type1 Type 2 and Type 3 SCD
• Knowledge in Oracle, Toad
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

WORK EXPERIENCE:

Confidential,BIRMINGHAM, AL JAN’10 - JUN’11

INFORMATICA DEVELOPER

Project: Customer Analytics

Description: Confidential, is a leading U.S. banking franchise with operations throughout the Sunbelt Region and ranks among the top 20 largest U.S. commercial banks based on deposit market share. We operate 716 branches in Alabama, Arizona, California, Colorado, Florida, New Mexico and Texas. In this project, I was involved in Requirement Gathering, Requirement Analysis, ETL Design and Development of the Data Model.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the PowerCenter.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions. Developed Slowly Changing Dimension for Type 1, Type 2, Type 3 SCD.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, Worklets and Workflows.
• Written procedures, Queries to retrieve data from DWH and implemented in DM.
• Responsible for submitting DBA requests, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the signoff’s for the production,
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS Excel. Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were Tracked, Reviewed and Analyzed.
• Made use of Mapping parameters and variables in the transformations within a mapping.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Confidential,ROCKVILLE, MD OCT’08- DEC’09

INFORMATICA DEVELOPER

Project: Wealth Management

Description: Confidential,is the world\'s leading source of intelligent information for businesses and professionals. We combine industry expertise with innovative technology to deliver critical information to leading decision makers in the financial, legal, tax and accounting, intellectual property, science and media markets, powered by the world\'s most trusted news organization. In this project, I was involved in gathering market data like shares and stock, build reports to analyze accounts and load the data in to the Datawarehouse System.

• Involved in Requirement Gathering and identifying the report set to be produced.
• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs and regularly reported update to the management.
• Analyzed Business requirement document and developed Test plans and Test strategies
• Prepared detailed test cases by understanding the business logic and user requirements for manual and automated testing.
• Involved in creating and executing test scenarios based on User or Functional requirements.
• Involved in all stages of Software Testing Life Cycle and Waterfall Model of Software Development Life Cycle (SDLC).
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse. Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed. Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified sources, targets, mappings and sessions and tuned them to improve performance. Actively participated in data base testing like checking the constraints, correctness of the data, field size validation, etc

Confidential,CAMBRIDGE, MA FEB’07 - SEPT’08

ETL DEVELOPER

Description: Biogen Inc. is a research-based company engaged in the discovery, development, manufacturing and marketing of pharmaceutical products worldwide. The project primarily dealt with building Sales Data Warehouse, Creating Sales Reports.

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse (including transformations, mapplets, mappings, sessions, and batches) so as to facilitate the personnel to understand the process and incorporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger. Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing)with user community

Confidential,INDIA JUN’07 - JAN’08

INFORMATICA DEVELOPER

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Developed mappings to extract data from SQL Server, Oracle, Flat Files, DB2, Mainframes and load into Data warehouse using the PowerCenter, power exchange.
• Developed common routine mappings using different transformationslike Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Made use of mapping variables, mapping parameters and variable functions.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Export/Import data from different data bases, flat files bydefining source and target.
• Written SQL Queries to apply and maintain the Business Rules. Checked performance tuning/debugging at different levels like workflows, mappings, database etc
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc. Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows. Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Requested Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.

Confidential, INDIA JUN’06-MAY’07
ETL DEVELOPER

Description: Confidential, is one of the leading financial institutions in India. Worked in Term Deposit/ Savings System

• Used Informatica Workflow Manager to Create, Schedule, Execute and Monitor Sessions, Worklets and Workflows. Created new mappings according to business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance. Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources. Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable Mapplets and Worklets to reduce the redundancy.
• Developed robust Informatica mappings and fine-tuned them to process lot of input records.