Summary:

• 7+ years of IT experience in Business Requirements Analysis, Data Modeling, Application Design, Development, Testing, Implementation and Support for Data Warehousing applications.
• Developed and designed ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Mart / Power Center 5x/6x/7x/8x/9x.
• Created mappings using various transformations like Lookup, Aggregator, Expression, Source Qualifier, Joiner, Update Strategy, Router, Sequence Generator Transformation etc.
• Extensively worked on Performance Tuning of ETL mappings and sessions.
• Experience in the design and development of Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), addressing Slowly Changing Dimensions (SCDs).
• Involved in upgrading of Informatica power center 6x to 7x and 7x to 8x
• Extensively worked on Informatica Designer Components - Source Analyzer, Transformations Developer, Mapplet and Mapping Designer.
• Experience in analyzing the session, event and error logs for trouble shooting mapping sessions.
• Performed various kinds of testing like Integration, Unit and User Acceptance testing.
• Extensively usedSQLstatements while performingETL processand appliedQuery.
• Worked on Slowly Changing Dimensions (SCD\'s) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Setting up sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD. Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect).
• Experience in integration of various data sources like Oracle, DB2, Flat Files, MQ series and XML Files into ODS.
• Strong exposure to metadata manager.
• Knowledge of data analyzer tools like Informatica data quality(IDQ) and Informatica data explorer(IDE)
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL LOADER.
• In-depth understanding of Star Schema, Snow Flake Schema, Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.
• Proficient in writing UNIX Shell Scripts, configuring Cron jobs for informatica job scheduling, backup of repository and folder.
• Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience in working with scheduling tools like Autosys and Control M.
• Knowledge of reporting tool like Cognos and Business Objects.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

Skill Set:
ETL Tools: Informatica Power Center (9.x/8.x/7.x/6.x/5.x), Power Exchange,
IDQ
Analysis/Reporting Tools: Cognos, BO
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, MS Access
DB Tools: SQL*Plus, SQL*Loader, TOAD 8.6
Operating Systems: UNIX, WINDOWS XP/ 2000/98/95
Languages: C, SQL, PL/SQL, UNIX, Shell Scripting
Data Modeling: Logical and Physical Data Modeling, Star/Snowflake
Schema, Fact and Dimension Tables, ERWIN
Scheduling/ Tools: Autosys, Control-M

Confidential,FL Apr’11 - Present
ETL- Informatica Developer

Medtronic, Inc is the world’s largest medical technology company and is a fortune 500 company with its head quarters located at Minneapolis, Minnesota. Medtronic comprises of six business units that develops and manufactures devices and therapies to treat various chronic diseases.

Responsibilities:

• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Designing Informatica mappings to load slowly changing dimensions using Lookup, router & update strategy transformations.
• Creating source to staging and staging to warehouse mappings using Designer Transformations like Expression , Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look up etc.
• Contributed in developing complex ETL mappings, workflows for three types of mappings, source to staging, Dimension and fact loading.
• Writing PL/SQL procedures to perform data base activities index creation, dropping and updating database tables based on the source rows.
• Participated in the UAT phase of the project
• Involved in performance tuning of the ETL mappings and writing SQL queries for extracting data from source systems.
• Designed unit test cases for each ETL map and Involved in Integration testing and system testing phases of the project.
• Developed shell scripts that are used to populate parameter files automatically before the ETL process starts.
• Written UNIX shell scripts to handle pre-session and post-session activities like disabling and enabling activities to implement bulk load option while loading large volumes of data.
• Worked closely with data population source systems and warehouse components.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Extensively worked in the STAR schemas to optimize load and query Performance using ETL Procedures and processes.

Environment: Informatica 8.6, Oracle 10g, PL/SQL, UNIX, Autosys, TOAD.

Confidential,Connecticut Dec’09 – Mar’11
Informatica Developer

The Hartford is one of America’s largest investment andinsurancecompanies. The Hartford is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans. The company’s earnings are divided between property-and-casualty operations and life operations.

Responsibilities:

• Was responsible for collecting requirements from business users and filling the requirement specification documentation.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Extraction, Transformation and loading of data from flat files and oracle sources into oracle database.
• Created Informatica Mappings and Mapplets using different transformations
• Involved in Performance tuning for better performance
• Responsible for Creating workflows and worklets. Created Session, Event, Command, Control Decision and Email tasks in Workflow Manager
• Analyze data quality and report the anomalies to business users using TOAD
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Involved in Unit, System integration, User Acceptance Testing of Mappings
• Automation of ETL processes using Autosys.
• Diagnose production failures using Windows NT/UNIX and Autosys scheduling application.
• Involved in the production support by monitoring the workflows and resolving the problems in the production.

Environment: Informatica Power Center 8.1, Oracle 10g, PL/SQL, UNIX Shell Scripts, Power Exchange, TOAD, Windows XP, Autosys scheduler.

Confidential,NC Role: Sr. Informatica Developer/Support Analyst May’08 – Oct’09
Wachovia is a diversified financial services company — providing banking, insurance, investments, mortgage and consumer finance from 6,000+ stores, the internet and other distribution channels across North America and elsewhere internationally. The project was to develop the warehouse to make it efficient and as a single source of analysis for management of data needs and to enable the sales reps to view the managed care information at their respective levels. The main objective of the project was to build a corporate product data mart for asset management which would produce daily, weekly, monthly, quarterly, and annual reports. Informatica Power Center is used to perform ETL loads using Incremental loading and Slowly Changing Dimension logic.
Responsibilities:

• Participated in User meetings, gathered requirements, discussed the issues to be resolved. Translated user inputs into ETL design documents.
• Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Worked cooperatively with the team members to identify and resolve various issues related to Informatica and other database related issues.
• Worked on designing and developing STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Used Power Exchange to connect, extract and transfer mainframe files and was solely responsible for the daily loads and handling the reject data.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes and used Informatica Debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like XML files, Flat files, Oracle, MYSQL, DB2 and SYBASE to Oracle target database.
• Created workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with many source systems like COBOL Files, XML files, MQ series, .csv files, flat files.
• Involved in fixing invalid Mappings/Mapplets, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & too different servers.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, NOT ISNULL, END_DATE, ADD_TO_DATE, DATE_COMPARE in transformations
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Environment: Informatica 7.1, Oracle 10g, Flat Files PL/SQL Developer, Windows 2000, PL/SQL, Windows XP, HP-UX, XML.

Confidential,Cleveland, OH Dec’06 – Mar’08
Informatica Developer

Progressive is a very well know name for Insurance products. It offers Car Insurance, Home Insurance, Condo Insurance, and other insurance products. Progressive has offices all over the US with about 25000 employees. The main objective of the project was to build an Insurance Data mart. As an ETL developer, I was responsible for sales data mart using Informatica Power Center.
Responsibilities:

• Coordinated with the client and gathering the user requirements.
• Designed and developed ETL process using Informatica tool.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked extensively with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Created Connected and Unconnected lookup transformation for better performance.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug the mappings.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed Informatica parameter files to filter the daily source data.

Environment: Informatica Power Center 6.1, Business Objects, Quest Toad for Oracle, Oracle 9i, SQL Server 2000, Flat Files, Erwin, MS Visio, UNIX, Windows.

Confidential,India. Jun’04 – Sep’06
ETL/Informatica Developer
Apollo Health Street is a global healthcare services company offering Business Process Outsourcing and IT Solutions and Services to global clientele with its principle place of business in the city of Hyderabad, India. This project involved working with a financial data mart that was periodically fed from various sources. COGNOS was the reporting tool used to generate complex reports.

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions, event wait/raise, and assignment, e-mail, and command to execute mappings
• Created parameter based mappings, Router and lookup transformations
• Created mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Created complex stored procedures/functions/triggers/query tuning in MS Access 97
• Involved in Unit Testing, Integration Testing, and System Testing
• Created Catalogs, Impromptu Reports and Snapshots.

Environment: Informatica Power Center 5.1, Oracle 8i, Erwin, Cognos 6.5, Sun Solaris 7, Shell scripting, Windows 98.