Professional Summary

• Over Seven (7) years of IT experience with extensive Data Warehousing implementations across various industries.
• Over Six (6) years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x/7.x/6.x and Power Mart 6.x.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FastExport, MultiLoad, FastLoad and Informatica.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical / communication skills and good team player.

Technical Skills

ETL Tools: Informatica 9.x/8.x/7.x/6.x, Informatica PowerExchange 8.x/7.x
Databases: Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access, Netezza, Teradata
Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g
Data Modeling: ERWIN , Visio
Reporting Tools: MS SQL Server Reporting services 2005, Business Objects XI, Crystal Reports 10, Oracle Reports 2.5.
Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, Perl.
Operating Systems: UNIX, HP, Sun Solaris 2.x/7/8, Windows ME/2000/2003/NT/XP, IBM AIX

Confidential, Madison, WI Oct '11 - Till Date
Sr. ETL Developer

Confidential, offers auto insurance, homeowners insurance, life insurance, health insurance, business and farm/ranch insurance in 19 states. American Family insurance is the nation\'s third-largest mutual property/casualty insurance company. The objective of the project was to build an Insurance Data Mart. The datamart application is used for analysis of different data like Claims, Membership, Eligibility, Sales Representative etc. As an ETL Developer, I was responsible for extracting and loading data which helped in tracking the number of online-applications for a particular claim, for a particular region, for a period of time and disposal of the applications based on their eligibility.

Responsibilities:

• Worked closely with Business Analysts in understanding the Business requirements.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using ERwin 4.0.
• Utilized Informatica Data Explorer to analyze legacy data for data profiling.
• Developed mappings to extract data from SQL Server, Oracle, 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.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Developed Mappings using various Transformations like Aggregate, Expression, Filter, Lookup, Joiner, Sequence Generator, Stored Procedure, Update strategy and Rank.
• Used workflow manager extensively to create tasks, worklets, and workflows and executed the tasks.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Developed PL/SQL stored procedures to implement complex business rules.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the indexes.
• Used command line mode to embed Pmcmd commands in to shell scripts and used Pmcmd, Pmrep commands in Interactive mode to access repository and workflows.
• Implemented reconciliation process for data consistency between source systems.
• Defects were tracked, reviewed and analyzed.
  Involved in migration of the mappings and workflows from the development server to the Test Server to perform the integration and system testing.

Environment: Informatica Power Centre 9.0.1/8.6.1, Oracle 9i,10g, MS Sql Server, SQL, PL/SQL, Erwin, SQL Loader, Unix Shell Script, Win 2000/NT.

Confidential,Charlotte, NC April '10 - Sep '11
Sr. Informatica Developer

Bank of America offers a range of financial products and services for businesses and customers all over the world. Customer information is very crucial for the bank and the bank decided to establish a customer data warehouse (CDW) that would serve as a consolidated, centralized information source. BOA designed its CDW carefully, ensuring that infrastructure would meet the service-level requirements of internal users. The scalability, reliability, and performance requirements were all factored into evaluation and planning process. For the CDW database itself, BOA selected Oracle for its features like parallel query, materialized views, and partitioning would provide BOA with the speed of information that users seek.

Responsibilities:

• Conducted user meeting and gathered the requirements
• Wrote technical requirements and specifications for the modifications to assess the feasibility of the project after interacting with customers/end users to obtain the requirements.
• Worked with BusinessAnalysts and Data Architects in gathering the requirements and designed the Source to Target Mapping Specification Documents.
• Prepared technical requirements documents which include both macro-level and micro-level design documents.
• Used technical transformation document to design and build the extraction, transformation, and loading (ETL) modules.
• Involved in preparing & documenting Test cases and Test procedures. Involved in developing these for Unit test, Integration Test and System Tests
• Designed and Developed Informatica Mappings which will capture and load the incremental load from the source tables into the target tables.
• Implemented Slowly Changing Dimensions - Type I,II mappings as per the requirements.
• Performed Data transformations using various Informatica Transformations like Union, Joiner, Expression, Lookup, Aggregate, Filter, Router Normalizer, Update Strategy, etc.
• Involved in the performance tuning of Informaticamappings, mapplets, and Reusable transformations and analyze the target based commit interval for optimum session performance.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Used Sequence Generator to create Dimension Keys and Update Strategy to insert records into the target table in staging and Data Mart.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created error log table to capture the error messages, session load time.
• Optimized Query performance and DTM buffer size, Buffer Block Size to tune session performance.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions.
• Identifying read/write errors using Workflow and Session logs.
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.

Environment: Informatica Power Center 9.1/8.6.1, Sql server 2008, Oracle 10g/11i, Business Objects, PL/SQL, TOAD, Windows XP, UNIX, ERWIN.

Confidential, Salt Lake City, UT March '09 - April '10
ETL Developer

Confidential, provides transformational medical technologies and services that are shaping a new age of patient care. Eligibility Information Data mart is involved in assisting the eligible customers in getting essential benefits like vision care, disability program, pension plan, dental care, savings and Long term care. The project Eligibility Information Data mart is responsible for building/maintaining key data marts like Eligibility, Case, Application Registration, Benefit Issuance etc. These data marts are used to develop key strategic reports using Business Objects to multiple business users to enhance the performance of the agency workers. Key performance measure is the amount of time taken to process an application.

Responsibilities:

• Conducted user meeting and gathered the requirements
• Wrote technical requirements and specifications for the modifications to assess the feasibility of the project after interacting with customers/end users to obtain the requirements.
• Worked with BusinessAnalysts and Data Architects in gathering the requirements and designed the Source to Target Mapping Specification Documents.
• Prepared technical requirements documents which include both macro-level and micro-level design documents.
• Used Erwin data modeler to design the datamarts and also generate the necessary DDL scripts for objects creation for DBA review.
• Used technical transformation document to design and build the ETL modules.
• Involved in preparing & documenting Test cases and Test procedures. Involved in developing these for Unit test, Integration Test and System Tests
• Designed and Developed Informatica Mappings which will capture and load the incremental load from the source tables into the target tables.
• Implemented Slowly Changing Dimensions - Type I, II mappings as per the requirements.
• Involved in the performance tuning of Informaticamappings and Reusable transformations and analyze the target based commit interval for optimum session performance.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Used Sequence Generator to create Dimension Keys and Update Strategy to insert records into the target table in staging and Data Mart.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created error log table to capture the error messages, session load time.
• Optimized Query performance and DTM buffer size, Buffer Block Size to tune session performance.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions.
• Identifying read/write errors using Workflow and Session logs.
• Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.

Environment: Informatica PowerCenter 8.1/8.6.0 Tools (Designer, Workflow Manager, Workflow Monitor), Informatica Metadata Manager,,Oracle 9i/10g, Sql server 2005, Toad 9.5, Unix, Erwin 7.x.

Confidential, Houston, TX Aug '07 - Feb '09
Sr. ETL Consultant

Confidential, a world leader in insurance and financial services, is a leading international insurance organization. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. The objective of the project is to build an Investment Management Data Mart using Informatica PowerCenter and also to generate reports based on the data available in the Data Mart.

Responsibilities:

• Worked closely with Business Analysts in understanding the Business requirements.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using ERwin 4.0.
• Utilized Informatica Data Explorer to analyze legacy data for data profiling.
• Developed mappings to extract data from SQL Server, Oracle, 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.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Developed Mappings using various Transformations like Aggregate, Expression, Filter, Lookup, Joiner, Sequence Generator, Stored Procedure, Update strategy and Rank.
• Used workflow manager extensively to create tasks, worklets, and workflows and executed the tasks.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Developed PL/SQL stored procedures to implement complex business rules.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the indexes.
• Used command line mode to embed Pmcmd commands in to shell scripts and used Pmcmd, Pmrep commands in Interactive mode to access repository and workflows.
• Implemented reconciliation process for data consistency between source systems.
• Defects were tracked, reviewed and analyzed.
• Involved in migration of the mappings and workflows from the development server to the Test Server to perform the integration and system testing.

Environment: Informatica PowerCenter 8.1, ERwin, Oracle 9i, Teradata SQL Server 2005, Windows XP, UNIX, SQL, PL/SQL, PL/SQL Developer.

Confidential, Education department April '06 - July '07
Informatica Developer

Responsibilities:

• Resolving issues related to Enterprise data warehouse (EDW), stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Worked with heterogeneous source to Extracted data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Migrated day one data for existing members in PCMH program from EDW into OLTP system using ETL process.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.

Environment: Informatica Power Center 8.1.1/7.1.3,Oracle 10g/9i/8i,Erwin,TOAD, Oracle SQL Developer, UNIX Shell Scripts, SQL, PL/SQL

Confidential, India
Informatica Developer July '05 - Jan 06

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.
• Developed the document of the complete ETL process.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.

Confidential, Hyderabad, India April '05 - May '05
Oracle Developer

The main objective of this project is to provide the senior and the middle level management of the organization with a query reporting and analysis tool. The system provides analysis on Key Performance Indicators used in the Organization.

Responsibilities

• Moved data from legacy systems to Oracle 8i using SQL*LOADER and PL/SQL procedures.
• Involved in data modeling using ERWIN data modeler.
• Creating physical data model.
• Designed the application security.
• Created all Oracle schema objects.

Environment:Oracle 8i, SQL*Loader, Windows 98, Erwin 4.0.