Professional Summary:

• 6+ years of experience in Analysis, Design, Development and Implementation of Data warehouse systems and Expertise in Informatica and Oracle.
• Extensive experience with Data Warehouse and BI methodologies and strong understanding of Relational, Multi-Dimensional Database concepts and OLAP.
• Business Intelligence solution in data warehousing and decision support systems using ETL tools Informatica Power Center 8.x/7.x and Business Objects XI R2.
• Experience in Data Warehouse development working with Data conversion, Data migration and (ETL) Extraction/Transformation/Loading using Informatica Power Center with Oracle.
• Experience in Informatica Power Center Client (including Designer, Workflow Manager, Workflow Monitor, Repository Manager)
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Expertise in implementing complex business rules using different Transformations, Mappings and Mapplets
• Expertise knowledge in improving Performance and Troubleshooting of the Informatica mapping and sessions and monitoring Informatica run time statistics.
• Has domain expertise in implementation of large-scale applications with the Data warehousing.
• Well Versed with different SQL Development Tools like TOAD & PL Sql Developer
• Expertise knowledge in UNIX Shell Scripting, SQL, PL/SQL Coding & scripting.
• Experience in writing Unix Shell Scripts for automation of ETL process using Schedulers like Appworx and Control-M
• Played different roles like Developer, Sr Developer and Onsite Offshore Coordinator.
• Have good idea about the onsite-offshore model.
• Flexible and versatile to adapt to new environment and working on new projects.
• Committed to continuous improvement and excellent communications. Self-disciplined, focused, solid teamwork and good team player.
• Good experience in technical documentation.
• Excellent analytical and problem solving skills and ease working within a team and independently. Good communication and presentation skills.

Skills:

ETL Tools : Informatica Power Center 8.x/7.x
Databases : Oracle 9i/10g
Reporting : Business Objects XI R2/R3.
OS : UNIX (Sun), Windows NT/2000/XP
Languages : C, SQL, PL/SQL,HTML,XML, UNIX shell scripting
Automation Tools : Appworx,Control-M
Other Tools : SQL*Plus,TOAD,SQL developer

Professional Work Experience

Project# 1

Client : Confidential
Duration : Jul ’10 – March ‘11
Role : ETL Developer

The project objective is enhancing the existing the EDW system with the changes occurred in the source systems. The existing EDW system has the cleansed, transformed and aggregated data for the Recap and Rx Claims. There had been some changes in the source due to the business. Due to this, functional team required to add 25 fields to the EDW system along with their business rules. This activity involves corresponding changes to source definitions, target definitions, staging area and ETL logic changes from staging to the EDW tables.

Responsibilities:

• Enhancing the source and target definitions using Source analyzer and warehouse designer to incorporate the new fields added in the source and Target.
• Enhancing the source to staging and staging to EDW ETL mappings by adding the new fields and the corresponding business logic.
• Enhancing the ETL logic in various transformations: Lookup, Expression, Filter, Router, Sorter, Aggregator etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode
• As part of the mainframe data capture, read the data from the COBOL copy books as source.
• Prepared the unit test cases for all the mappings to test the enhancements.
• Supporting the QA team for integration and system testing.
• Supporting the UAT and production implementation activities.
• Guiding the other ETL developers in the team.
• Worked with the DW architect to prepare the ETL design document.
• Created Low-level design document that includes the detailed design of each components and data flow diagrams.
• Coordinated with the data modeler on the data modeling activity for this project.
• Worked with delimited flat files as part of the data is coming from the flat files.
• Created DDLs for new tables and updated DDLs for the existing tables in the data mart.

Environment: Power Center 8.6.1, Oracle 10g, UNIX, TOAD, Tivoli Maestro (scheduling tool) and
Mercury quality center.

Project# 2

Client : Confidential NY
Duration : Apr ’09 – Jul ‘10
Role : ETL Developer

The project objectives involve the design and deployment of the Health Plan Enterprise Data Warehouse (EDW) Release 4.0 (R4.0) with flexible access for reporting and statistical analysis. The objective of Release 4.0 is to further enhance architecture including but not limited to the physical data model, source data utilized, extract, transform and load (ETL) routines and reporting platforms to support various requirements for Medical Economics, Medicare Finance, Pricing, Health Care Affairs and Sales and Marketing.

Responsibilities:

• Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations.
• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Involved in source data analysis.
• Participated in preparing the test cases and supported the QA team during the testing phase.
• Used Debugger to test the data flow and fix the mappings.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Tuned the workflows and mappings.
• Extensively used parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created DDLs for new tables and updated DDLs for the existing tables in the data mart.
• Implemented Type 1 Dimension logic in mappings using Informatica Designer

Environment: Informatica Power Center 8.5,Appworx, Oracle 10g, UNIX


Project# 3

Client : Confidential
Duration: Mar ’08 – Mar ’09
Role : ETL Developer

Country Insurance and Financial Services is a corporate firm broadly engaged in providing solutions for Financial and Insurance applications. A temporaryFinancial Security Office(FSO) was established in 2005to coordinate variousprojects throughout the organization.In November 2007, the FSO was replaced with a new structure of five financial security committees to guide projects.

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
• In-depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing.
• Interact with data modeler, data support teams to get the enterprise data for High level specs
• Maintaining the repositories and creating the folders and users and controlling the users access using repository manager.
• Created DDLs for new tables and updated DDLs for the existing tables in the data mart.
• Developed mappings, Sessions and workflows in Informatica Power center.
• Implemented Type2 Dimension logic in mappings using Informatica Designer
• Extracted data from Siebel CRM tables and loaded into Oracle tables.
• Extensively used Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Written SQL overrides in source qualifier according to the business requirements.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode
• Created Low-level design document that includes the detailed design of each components and data flow diagrams.

Environment: Informatica Power center 8.5, Business Objects XI R2, Oracle 10g, TOAD

Project# 4

Client : Confidential
Duration : Jun’07- Feb ’08
Role : ETL Developer

Emblem Health is one of the leading health care clients in North America and helps its clients to how to invest money in the market. The project is designed to convert the data from the old systems to the database. The conversion involved in migrate the data from legacy systems in to Database level.

Responsibilities:

• Participated in design reviews to make recommendations on performance, architecture and fault tolerance.
• Involved in creating Test Cases and conducting Test Case Walk Troughs' with the QA Team.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs
• Created reusable ETL components and maintenance of ETL mappings. Automated the ETL process through scheduling and exception routines. Performance Tuning, Performance Testing and Optimization of existing processes.
• Designed and Developed the ETL Load Strategy Documents.
• Designed and developed the Workflow and Worklets for all load process
• Developed Informatica mappings & tuned them for better performance
• Extensively used Informatica Designer to create and manipulate source and target definitions, Mappings, Mapplets, transformations, re-usable transformations.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• As part of the mainframe data capture read the data from the COBOL copy books as source.
• Worked with fixed width and delimited flat files as part of the data is coming from the flat files.

Environment: Informatica Power Center 8.1, COBOL copy books, Flat files, Oracle 10g, Toad, Unix

Project# 5

Client : Confidential
Duration : Nov ’06 – May ’07
Role :ETL Developer

AmeriCredit is one of the leading Auto Insurance and Mortgage Company contains more than 5 million customers throughout the globe. The main goal of the project is to build enterprise data warehouse so that all of its business users can access the data.

Responsibilities:

• Performed data manipulations using various informatica transformations like Joiner, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.
• Extensively utilized the Debugger utility to test the mappings.
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows.
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Created and used different tasks like Decision, Event Wait and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.1, Appworx,Oracle10g, TOAD 7.5, UNIX.

Project# 6

Client : Confidential
Duration : Feb ’06 - Nov ’06
Role :ETL Developer

United Parcel is one of the largest logistics company which serves in most of the states of U.S.A. Involved in data warehouse development project. This Data Warehouse project will enable management to better leverage information collected within current operational systems to help in their decision making process.

Responsibilities:

• Worked on Informatica Power Center 6.x tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator, etc.
• Integrated sources from different databases and flat files.
• Designed mappings with multiple sources using Informatica Designer tool.
• Designed and Developed the ETL Load Strategy Documents.
• Designed and developed the Workflow and worklets for all load process
• Developed Informatica mappings & tuned them for better performance
• Installed and configured Informatica Server and Power Center 6.x.
• Used Transformations for data joins, complex aggregations & external procedure calls.
• Tuned Mappings for optimum performance.

Environment: Informatica Power Center 7.x, Control-M,Oracle 9i, TOAD, UNIX.

Project# 7

Client : Confidential
Duration : Jun ’05 - Jan ’06
Role :BO Team member

There were total 5 applications: MPS - Market penetration system is the business sensitive application and contains the rated deals information of different rating agencies across all the geographic regions with respect to different sub asset classes; GDIR- Global debt issuance reporting; CSS - Customer survey systems contains the user feedbacks and the comments related information across the all the regions of S&P customers; REVDB – Has the data related to revenues; CPGR - The data related to the deal specific information from Core side and invoice related information from the PIMS team are joined thru universes and built the core PIMS reports.

Responsibilities:

• Refreshing the daily, monthly and quarterly reports after their data loaded into the warehouse.
• Migrating the reports from QA environment to the production environment.
• Adding users to the BO environment and granting access to reports in Supervisor.
• Supporting users in the production environment.
• Coordinating with the development and QA teams during the development, UAT and production move activities.
• Worked on adding new objects to the universes and reports as per the user requirement.

Environment: Business Objects 5, Oracle 9i, TOAD.

Education: Bachelor’s in Engineering .