SUMMARY

• More than 6+ years of Software experience in System Analysis, Design, Development, Implementation and Testing of Client/Server and Web applications and this includes Insurance and Financial Domains.
• Experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center/ Informatica Data Quality.
• Expertise in data warehousing, ETL architecture, Informatica Powercenter Client,Server tools and power exchange.
• Strong ETL data integration experience using Informatica PowerCenter 9.1/8.6, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Knowledge of Metadata Manager, Informatica Data Quality, B2B - Data Transformation, Data Exchange, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer, Task View, Gantt Chart View, Mapplets, Shortcuts, Informatica Power Connect for SAP/Siebel, and ETL.
• Solid experience in Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables.
• Experience using Informatica Cloud Services, Metadata Manager, Power Exchange Sales force.
• Knowledge of exploring Informatica B2B, Data Validation,IDQ
• Excellent experience using Oracle 10g/9i,PL/SQL, SQL*Plus.
• Excellent interpersonal skills.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g/9i, SQL Server 2005, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.

TECHNICAL SKILLS

ETL Informatica: Informatica PowerCenter 9.1/8.6, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Knowledge of Metadata Manager, Informatica Data Quality, B2B-Data Transformation, Data Exchange Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer.

Data Warehousing: Data Warehouse, Data Mart, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 10g/9i/8i, MS SQL Server 2005,Teradata, MS Access 7.0/2000,SQL, PL/SQL

Job Scheduling: Autosys, DAC, Control M,Informatica Scheduler

Environment: UNIX, Windows XP

Others: Microsoft Office, XML, JavaScript, HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, NYC

Informatica Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed ETL mappings based on the Functional Requirements
• Extracted data from Oracle, SQL Server and Sybase database tables, generated Position and Balance files dynamically and Fatted to Prime View for report generation
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Created Informatica Data Quality Plans for data validations.
• Worked with various active and passive transformations in Informatica PowerCenter
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Developed UNIX shell scripts to run the workflows and automated the scripts to run daily loads using Control-M scheduler
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re-usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Extensively worked with the Debugger for handling the data errors in the mapping designer

Environment: Informatica PowerCenter 9.1, Data quality, Oracle 10g, SQL Server 2005, Sybase, Flat Files, Control-M, Rapid SQL, Quality Center, UNIX, Windows XP

Confidential, Bridgewater,NJ

Informatica Developer

Responsibilities:

• Extensively used Informatica PowerCenter 8.6.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using Informatica PowerCenter 8.6.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator
• Created complex Cognos reports using calculated data items, multiple lists in a single report. Prepared functional and technical documentation of the reports created for future references.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using BusinessObjects and Web Intelligence.

Environment: Informatica PowerCenter 8.6, Oracle 10g/9i,PL/SQL, TOAD, SQL*Plus,Windows, UNIX HP UX, Control M.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle, Sybase, and Flat files
• Responsible for the Data Cleansing of Source Data
• Responsible for Performance Tuning in Informatica PowerCenter
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, Std Deviation in the Aggregator Transformation
• Extensively made use of sorted input option for the performance tuning of aggregator transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Worked with Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE

Environment: Informatica PowerCenter 8.6.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer,Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer),Oracle 10g, SQL, PL/SQL, Teradata, Flat Files, Autosys, Star Team, UNIX, Windows XP

Confidential

Responsibilities:

• Understand the existing flow to process the files of various clients and corresponding distributors and resellers.
• Understand the existing pain areas of their flow of processing Sales and Inventory data.
• Came up with a good design to avoid their pain areas like reporting format changes also the file should process, without changing any code provided the configurable file to process the file even if there are any changes also.
• Came up with a good design to avoid the rework, lot of man power and Cost saving.
• ETL Spec Creations and Test strategies and perform the Unit Testing and Integration Testing.
• Created mappings and workflows to pull data into backend with ETL Operations using INFORMATICA.
• Involved the Project deployment activities from DEV to QA to UAT and then to PROD.
• Available for the team always to make the project successful in the on time and with productive results.

Environment: Informatica Power Center 8.6.1, SQL,UNIX and Windows XP