Experience Summary:

• 7 Plus years of experience in Information Technology with a strong background of ETL Tool Informatica and Testing.
• Exposed to various domains of Data Warehouses like Insurance, Finance and Retail Industry.
• 5 years of experience in design, development and maintaining Data Warehousing systems and data marts using Informatica 8.6.1/7.1/6.2, Power Exchange, IBM UDB DB2, Oracle, SQL Server 2005, Toad, Erwin.
• 3 years of experience using Informatica Power Exchange creating data maps.
• Extensively worked on Data Extraction, Transformation and Loading(ETL) from disparate Data sources like Multiple Relational Databases Oracle, SQL Server,DB2,Mainframe,SAP R/3 and Flat files using Informatica
• Experience in creating, modification and testing of Informatica mappings (Type 1, Type2 and Type 3) and Session (Sequence and concurrent) and workflows.
• Worked extensively with informatica to create complex mappings using expressions, routers lookups and aggregator to develop and to move to multiple databases.
• Extensive experience in debugging and performance tuning of the ETL process which includes tuning of Informatica mappings, session, source and Targets.
• Strong knowledge in Data Warehouse Concepts and extensive experience in Data Warehouse applications.
• Involved in OLAP data modeling for both Star and Snowflake schema.
• Created logical and physical models using Erwin data modeling tool.
• Have knowledge of Business Objects and Cognos tools for reporting purpose.
• Expertise at enterprise Data base Integration and management among MS SQL, Oracle, Sybase, DB2 and MS access.
• Strong expertise using SQL, PL/SQL functions, procedures, Triggers and Packages.
• Used the concepts of source and target bottlenecks in informatica to increase the performance using Hints and Explain Plan and other concepts for query optimization in Oracle.
• Experience in UNIX Shell Scripts to support Data Warehousing tasks.
• Worked closely with admin to migrate informatica and database objects from one environment to another like Dev to systems test or systems test to QA or QA to Production.
• Used to give production support on rotation basis with in the team.
• Effective communication skills (verbal and written) for both highly technical and business personnel.
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things quickly.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.

Technical Skills:

ETL

Informatica Power Center 8.6.1/7.1/6.2 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager and knowledge about Informatica Administration), PowerMart 6.2.1 Power Connect for Mainframe (Detail Navigator), Power Exchange.

Reporting

Cognos, Business Objects, Sql*Plus, SQL *Loader, Power Analyzer.

Data Modeling Tools and others

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), ER Diagrams, ERwin 4.0/3.5.2. Cron Job, Maestro, Quest TOAD, PL/SQL Loader, XML.

Databases

Oracle 11g/10g/9i/8i, SQL Server 2005, Sybase, MS Access, UDB DB2

Languages

C, C++, SQL, PL/SQL, VB, Java.

Operating Systems

UNIX (Sun Solaris, AIX), Windows 2003/2000/XP/98.

Education:

• Bachelors in Electronics and Communication Engineering

Professional Experience:

Client & Location: Confidential,Springfield, MA (Feb’08 to Till Date)
Tittle: Sr. Informatica Developer

Project Name 1: Life Information Factory Description: Project Scope: Mass Mutual Financial Group is a Fortune 100 company which mainly deals with Investments, Insurance and Retirement Services. The USIG Division of Mass Mutual is implementing two of its large programs DSP and LSP under the Legacy Modernization umbrella. The Life Information Factory will be the enterprise level data warehouse. The purpose of the project LIF is to take advantage of the new admin system for better management and timely administration of product lines. The current systems will be replaced by new SAP system. The current systems will be retired as each product is moved to the new platform. The conversion will take place in four phases.

Project Name2: Xpressions Letters, Reports and Statements

Description:
The new Vantage-1 TRAD platform requires certain correspondence letters, reports and statements to print based on business events. Some of the letters and reports printed are LAPSE, LISR, GIR, Secondary Address, Annual Statements, Conservation Report, PS58 Report, Loan Confirms and Policy Print. All business events are written to Output Management db2 tables. Data will be extracted from these tables (OM Extractor), data enrichment will occur (Correspondence Pre Processor), and a feed to Informatica for transformations will then take place. Informatica will feed XML files to xPressions for correspondence print. An FAC control record in the standard format will be built as a trailer record in the file. Only record count is needed as a balance.
Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development.
• Extensively used Informatica to load data from Flat Files to DB2, Flat Files to SQL Server, DB2 to XML files, Mainframe to DB2 Flat Files to Oracle, Flat File to Mainframe, Mainframe to Flat Files
• Extensively used PowerExchange for creating Data Maps with the cobol copybooks.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
• Created one time mappings and workflows for better understanding and easy to use.
• Worked on Informatica 8.6.1/7.1.3 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Developed UNIX Shell Scripts.
• Created logical and physical data models and maintained relationships between tables using Erwin. Well versed with reverse engineering processes in Erwin.
• Used Maestro to schedule jobs/job streams for informatica mapping and UNIX scripts.
• Used for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions. Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.
• Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.

Environment:
Informatica-PowerCenter 8.6.1/7.1.3 (Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor), PowerExchange Datamaps, SQL Server 2005, DB2, Oracle 11g, Maestro Scheduling Tool, UNIX, SQL, Mainframe COBOL.

Client & Location:Confidential,Emeryville, CA (Feb’07 to Jan’08)
Tittle: Data Warehouse Developer

Project name: Leap Frog Data Warehouse

Description:
As a Senior ETL Engineer, worked on Supply Chain, POS, Forecast. Sales Analysis, Scorecards and GL subject areas of the Enterprise Data Warehouse. Worked on the customer data integration (CDI) part of the data warehouse. A new one time Data Warehouse has been created with oracle database. The new Data Warehouse was designed based on the snowflake schema. It has three area’s Staging, Data Warehouse and Datamarts. The data was loaded using Informatica ETL tool. The data was coming from Oracle ERP and Flat files. Reports were created from data in the data mart using Cognos reporting tool. Responsible for Business Analysis, Requirements Collection and Designing Technical Specification.
Responsibilities:

• Extensively Used Informatica as an ETL tool to extract data from source systems to Target system.
• Developedvarious Mappings, using transformations like connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Stored procedure, Sequence Generator, Update strategy, Union and Joiner etc.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Migrated mappings from Development to Test folders
• Tuned Sources, Targets, Mappings and Sessions to improve the performance.
• Developed mappings that incorporated logic needed to handle inserts and updates to the existing targets
• Developed design documents, technical specifications for Mappings and Sessions based on user requirements
• Involved in implementing error handling Process
• Created Forecast Data Mart – Data Model, physical tables, mappings
• Gathered user requirement, designed technical specification
• Created mapping to load Staging and Data Warehouse and to Data Mart.
• Performed Unit Testing and Integration Testing and tuned the SQL using Hints, Indexes and clusters, Explain Plan and Tracing concepts for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.
• Extensively used mapping variables and mapping parameters in various mappings.
• Implemented Query Optimization for performance enhancements

Environment:
Informatica Power Center 8.1.1, Windows NT, Erwin 4.0. Toad, Cognos 7 v2, Oracle 10g, UNIX, Sun Solaris.

Client & Location: Confidential, Springfield, MA (Jan’05 to Jan’07)
Tittle:Informatica Developer

Project name: Agent Valuation

Description:
There has been a need for a comprehensive Agent Valuation system since the MassMutual / Connecticut merger. A new system would provide commission projections over 15 policy years for all of the core products – Life, Tier 1 Annuity (including IMG), DI, and LTC.
ETL will process 2 mainframe Agent Validation files into a set of 4 staging tables and from the staging tables load the new Agent Valuation database. This database will consist of a series of detail and summary schemas. There will be cleanup processing that will be done on the fact tables to retain only 2 years of data after the load processing is complete for each year. Cognos was used for generating Reports.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development.
• Extensively used Informatica to load data from Flat Files to DB2, DB2 to Flat Files and Mainframe to DB2 using Power Exchange by creating Data Maps.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
• Created one time mappings and workflows for better understanding and easy to use.
• Worked on Informatica Power Center 6.2.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created Data Maps using PowerExchange which is used for transferring data from Mainframes to DB2.
• Used tables from SAP BW/R3 as source and lookup tables to load into DB2 tables and then to files for downstream systems.
• Involved in developing UNIX shell scripts.
• Used for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.
• Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.

Environment:
Informatica-PowerCenter/PowerMart 7.1.3/6.2.2 (Data warehousing designer, Mapping Designer, Workflow Manager, Workflow monitor), PowerExchange, DB2, SAP BW/R3Maestro Scheduling Tool, UNIX,SQL.

Client & Location: Confidential,Hyderabad, India (Jan’03 to Dec’04)
Responsibilities:

• Developed test plans, preparing test strategies, test cases for web pages depending on the project requirements and system specifications.
• Tested the entire functionality of the application on different browsers and operating systems.
• Reviewed the Functional Specs of the Activities of the Business Stream and Interfaces and to write the Test Cases respectively
• Tested various links of Global Navigation Bar, the text-hyperlinks and image-hyperlinks of Home Page and different Feature pages.
• Responsible for managing the project schedule and project plan.
• Analyzed business requirements.
• Interfacing with Project management, Software engineering, Software configuration management, and the Software process organization.
• Documented and reported bugs found out during the process of testing in the bug database.
• Participated in the team meetings to discuss the issues.
• Involved in system, integration, regression testing.

Environment: Main Frames, SQL Server 2000, MS Word, MS Excel. Windows 2000/NT/XP