Professional summary:

• Over 7 years of experience in software design, development, maintenance, testing and troubleshooting on ETL/DWH applications.
• Expertise in Requirement Analysis, Design, Coding, and Testing Implementation of ETL/DWH projects using Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange, Data Masking, Test Data Management, PL/SQL, TOAD, COBOL,DB2, VSAM and UNIX Shell Scripts
• Extensive experience in designing, developing, and implementing Extraction, Transformation, and Load ETL techniques on multiple database platforms and operating system environments.
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.0/8.6
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Used the Informatica Workflow Monitor extensively to run, schedule, monitor, debug Informatica Jobs
• Experience in integration of various data sources like SQL Server, Oracle, XML, IBM Mainframe Flat files, DB2 into the staging area
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experienced in Performing Unit testing, system testing, regression testing, smoke testing and system integration testing.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts.
• Experienced in working with tools like TOAD and SQL plus for development and customization.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Worked on Data Replication for performance and maintenance purposes.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels

Technical Expertise:

Professional Experience:

American Family Insurance, Madison, WI March 2013 Present

ETL / Informatica Developer

Description: American Family Insurance is a private mutual company that focuses on property, casualty and auto insurance, but also offers commercial insurance, life, health, and homeowners coverage, as well as investment and retirement-planning products.

Responsibilities:

• Leading requirements gathering sessions to understand all business and systems requirements supporting the initiatives
• Involved in high-level and low-level design sessions including writing technical project documentation
• Responsible for technical design, development, and unit testing the data mappings and transformations required to populate the PepsiCo Enterprise Data Warehouse.
• Involved in writing BTEQ scripts for creating staging tables inserting test data as per requirement
• Worked on Teradata Utilities MultiLoad, FastLoad, Export/Import to improve performance.
• Designed UNIX shell scripts to automate the BTEQ scripts for loading into Teradata database.
• Created ETL load control process which keeps track of all the load run statistics and publish them to the users to notify the load completion
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Provided support and quality validation through test cases for all stages of Unit and Integration testing
• Involved in migrating objects to different environments using Deployment groups and Labels
• Worked closely with the Business analysts and attended meetings to gather and discuss the requirements for various projects.
• Prepared various documents like ETL Specification doc, Technical Design doc, Run Book etc.
• Offered production support services to resolve ongoing issues and trouble shoot them to identify the bugs

Environment: Informatica Power Center 9.1.0,Oracle, Teradata 13.0,Teradata Administrator, Teradata SQL Assistant , Control M , Mainframes, UNIX

Confidential

Informatica Developer

Description: The purpose of the project was to develop a data warehouse for the Corporate Taxes User group. Informatica tool was used to source data from sources such as Oracle, SQL Server, DB2, and Flat files and then populate a data warehouse on an oracle database as well as on SQL server 2005. The source data would come in on daily and weekly and Monthly basis. Various analytical reports are developed on this data using Business Objects.

Responsibilities:

• Involved in requirements gathering, analysis, function/technical specifications, development, deploying and testing.
• Coded, tested, implemented and maintained medium to highly complex ETL mappings and Shell scripts to build and maintain automated ETL processes.
• Coded the Informatica jobs for long term reliability, and accuracy.
• Worked with the existing application support team to help identify root cause of issues during the workflow runs, after identifying the issues took corrective actions and implemented long-term prevention plans.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Very good knowledge and Hands on experience on Flat file processing and ability to develop data validation mappings during the flat file loads and automating the ETL Load processes.
• Ability to identify and implement the parallel processing capabilities in the workflow sessions and use those capabilities to reduce the Workflow load times.
• Hands on experience on Performance Tuning using Session Partion, Lookup Properties, and Session Properties.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle 10g, Flat files, SQL Server 2005, DB2 Cobol files and to load data into staging tables first and then into Oracle Data Warehouse.
• Responsible for creating the Migration requests from Development to Stage and then after cross checking the migrated code in Stage for successful migration of all objects, the code is moved from Stage to Production.
• Designed and developed PL/SQL Procedures, Triggers and Packages for implementing business logic.
• Ability to write the Shell Scripts based on the project requirements.
• Integrated Informatica with Web Services applications through oracle PL/SQL.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations based on the design specifications.
• Troubleshooted and Performance tuned complex ETL mappings to reduce the session run time.

Environment: Informatica Power Center 9.1.0/8.6.1, Oracle 11g/10g, SQL SERVER 2005/2008, PL/SQL, Flat Files, SAM Files, T-SQL, Shell Scripts, Business Objects XI R2,FTP Servers, Linux.

Confidential

ETL Developer

Description: CareFirst BlueCross BlueShield is a not-for-profit health care insurer and offers a comprehensive portfolio of products and administrative services to individuals and groups in Maryland, the District of Columbia and northern Virginia. Its largest health care insurer in Mid-Atlantic region and nationally recognized as 'Best in Blue' insurer. CMDB is combined member database which contains membership information from Carefirst legacy systems FACETS Tables information is extracted through Informatica and loaded into CMDB Database. Informatica Jobs are executed through Unix Scripts. Enhancement Daily and Historical HIPPA workflows and loading the data into CMDB Tables

Responsibilities:

• Understanding requirements and preparation/review of High level, Low level design documents and technical specification documents.
• Extract the Membership information from FACETS Oracle Tables using Informatica 9.1 ETL Tool and load into CMDB DB2 Tables.
• Extensively used Informatica Designer to design, develop ETL jobs for extracting, transforming and loading the data
• Enhancement of Daily WF F45 HIPAA CMDB XTRC DLY and Historical WF F45 HIPAA CMDB XTRC HST workflows according to the requirements
• Written Unix Shell Scripts to execute the DLY and HST Workflows.
• Developed common routine 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.
• Worked with Parameters and Variables, Pre SQL/Post SQL, Pre session and post session commands, Emails in CMDB Mappings and Sessions.
• Created sessions and workflows to sequentially execute the designed jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Worked with PMCMD commands like start workflow, schedule workflows, stop workflow, abort workflow etc.
• Migrated the Informatica Power Center mappings and Code/Folder migration from one environment to another as part of release management.
• Involved in Unit and System Testing of ETL Code Mappings and Workflows .

Environment: Informatica Power Center 9.1, Oracle 10g, DB2, PL/SQL, Mainframes, Flat files, UNIX Shell Scripts, AS400, CA7 Scheduler, Reflection Client.

Confidential

ETL / Informatica Developer

Description: The Project Orion is the replacement for existing stored procedures in SQL server by developing different data structures to represent Asset package data. This replacement is accomplished by using Informatica Powercenter 8.6.1

Responsibilities:

• Designed ETL process, load strategy and the sequence of execution of developed Informatica objects.
• Defined and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model's using Erwin R7 with Architect teams.
• Involved in dimensional modeling of the Schemas across the Data Warehousing requirements.
• Develop data quality solutions and recommendations for data integrity issues.
• Responsible for creating the DATA MAPS, extracting incremental CDC data from Mainframe sources, exporting and updating them to the Repository, importing the required source files on to the staging environment by using Informatica Power Exchange.
• Used Tidal to Schedule the jobs.
• Extensively used ETL to load data from wide range of sources such as Flat files, Relational, VSAM, DB2, Teradata, Netezza, SQL server, XML, Oracle.
• Involved in creating simple to complex mappings using transformations like aggregator, Source Qualifier, Router, expression, look-up, joiner transformation.
• Built Workflows and Worklets to schedule, sequence and parameterize data loads into the different Datamarts and the Enterprise Data Warehouse.
• Involved in Performance tuning of the Informatica Mappings and Sessions to enhance the performance by using different Partitioning techniques and the Various Transformations.
• Implemented Slowly Changing Dimensions to update the dimensional schema.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Used Business Objects to check the validity of the data in the Data Warehouse.
• Helped in migrating from version 8.5 to version 8.6 of Informatica Power center on Windows environment.

Environment: Informatica Power Center 8.5/8.6.1 Workflow Manager, and Workflow Monitor , Informatica identity Resolution. Teradata, Oracle10g, Netezza, SQL Server Integration Services SSIS , TIDAL, Sun Solaris, Windows NT, Query Analyzer, Businessobjects6.5 Designer, Reporter .

Confidential

Informatica Developer

Description: The project was to build a data warehouse for operational and strategic reporting. The project was to design, develop and maintain Enterprise data warehouse. The objective is to integrate different source systems into homogeneous environment to build Enterprise Data Warehouse. The project has four subject areas Membership, Claims, Capitation and Provider. The goal of the project is to better decision making with appropriate data views.

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.x
• Used Informatica PowerCenter 8.6.x/PowerMart 6.1 for extraction, loading and transformation ETL of data in the data warehouse.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Oracle Reports developer for Oracle EBS and non EBS applications
• Worked on different data sources such as Oracle, XML, Flat files, MS Access.
• Apps DBA experience in 111 to R12 Upgrade
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures triggers, cursors for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Experience in generating reports using Business Objects 6.5.
• Worked on Tuning the SQL queries for better performance.
• Performance Tuning: Partitioning the fact tables and materialized views to enhance the performance.

Environment: Informatica Power Center 8.6.x / Power Mart 6.1, Oracle 8i/9i, SQL, PL/SQL, Unicenter, MS Access, Windows 2003, UNIX, UDB DB2 8.1, Business Objects 6.5.

Confidential

Jr.Informatica Developer

• Description: Solvay Pharmaceuticals, one of the top pharmaceutical companies in the world, focuses drug development efforts in the fields of psychiatry, gastroenterology, cardiology, male and female hormone replacement therapy, and immunology. When developing these drugs, Solvay Pharmaceuticals needs a repository to provide global, secure access to clinical information that is used by some 100 researchers around the world, working in a variety of areas, including data management, statistics, and clinical and medical review.
• The purpose of the project is to build a Data Warehouse for analysis, reporting and exploration that transforms massive amounts of data into intelligence, which, in turn, expedites the drug development process and effectively removes geographic boundaries to make information available to anyone who needs it, when they need it.

Responsibilities

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy Informatica 8.1 is used Dimensional modeling. Backup recovery.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Used unconnected lookup for populating date-time entered field in the target tables.
• Data integration including UB92 extracts from 70 health care facilities, patient satisfaction results, severity adjustments, core measures, and employee climate assessments.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Extracted data stored in different databases such as Oracle, SQL Server to load finally into a single Data Warehouse repository, which is in Oracle.
• Worked closely with reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica PowerCenter 8.1.x Meta-Data Repository, Designer, Server Manager , DB2 UDB, Informatica Power Connect, Oracle9i/8i, MS SQL SERVER, SQL, PL/SQL, Erwin, SQL Loader, UNIX Shell Script, IBM AIX 4.3.3, Win 2000/NT, Business Objects 6.2