SUMMARY

• ETL Expert with 7+ years of Data warehousing experience using InformaticaPowerCenter 8.x/7.x.
• Extensively worked with various components of the InformaticaPowerCenter - PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor to createmappings for the extraction of data from various source systems.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Excellent capabilities in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type I, Type II, Type III slowly changing dimensions.
• Experience TOAD, Oracle development tools.
• Good understanding of life cycle Implementation for data warehouse.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Experience in Dimension Data modeling concepts like Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Created UNIX shell scripts to access data and move data from Production to Development.
• Good knowledge on UNIX Shell scripting. Developed UNIX scripts and scheduled ETL Loads.
• Coordination in preparing project plans with managers and development team to make sure project plans are correct and are in time.
• Excellent Interpersonal Skills with the ability to work independently and with the Team.

TECHNICAL SKILLS :

ETL Tools: Informatica Power Center8.6.1/8.1.1/8.0/7.1.1/7.1.3, PowerExchange
Databases: Oracle 10g/9i/8i, IBM DB2, SQL Server, Teradata
Reporting Tools: Business Objects, Crystal Reports
Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Erwin 7.2/4.0/3.5.2/2.X,Normalization, Denormalization and MS Visio
Scheduling Tools: Crontab, Autosys
Languages: SQL, PL/SQL, C,C++, UNIX Shell Scripting.
Development Tools: PL/SQL, SQL, Developer 2000, Oracle Developer Suite, SQL Plus, Toad 8.x/9.x/10.x
Operating System: UNIX, Sun OS, AIX, Windows 2000/XP/2003, Mainframe
Office Applications: MS-Office 2000/2003/2007, Visio, MPP.
Other Utilities: SQL *Loader, Multi-Load, Teradata SQL Assistant

Education:
Bachelors in Computer Science

Professional Experience:

Client: Confidential, Boston, MA Aug10-Till Date
Role: Sr.ETL/InformaticaDeveloper

Description:
Confidential, is a not-for-profit health care system that is committed to patient care, research, teaching, and service to the community locally and globally. Collaboration among their institutions and health care professionals is central to its efforts to advance its mission.

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document.
• Creating mappings using a variety of transformations like Source Qualifier, Lookup (static/dynamic cache, connected/unconnected, persistent/non-persistentcache),StoredProcedures (connected/unconnected, pre/post/normal), Routers, Filters, Aggregator, Normalizer, Unions, Update Strategies, Sorters.
• Extracted large volumes of data from different data sources into staging tables, performing transformations on them before loading into final tables.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Updating existing procedures, functions, triggers and packages to synchronize with the changes in Transformations.
• Worked on delimited flat file sources and Extracted data from DB2 and Oracle source systems and loaded into flat files.
• Created Mapping Parameters & Parameter files in the mappings.
• Used Workflow manager for creating, testing and running sessions and Batchesin the workflow.
• Responsible for testing ETL jobs beforedev to test and test to production migration.

Environment:Informatica Power Center8.6.1 (Repository Manager, Power Center Designer , Workflow Manager, Workflow Monitor), Oracle 10g, Windows Server 2003, ERWIN 4.x,Microstrategy.

Client: Confidential, Albany, New York Apr09-Jun10
Role: Sr.ETL/InformaticaDeveloper

Description:
Confidential, physicians collaborated to launch (CDPHP), a not-for-profit individual practice association (IPA) model health maintenance organization (HMO). More than 25 years later, CDPHP is still guided by its valued physician base and has evolved into an award-winning health benefits provider offering a variety of commercial and government-sponsored plans to the diverse communities it serves.

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Informatica Power Center 8.5 is used to extract, transform and load data from different Operational data sources like Oracle as an ODS, DB2 and flat file.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• DB2, SQL Server and worked with business users and developers to develop the
• Scalability and performance tune existing batch to handle large volumes.
• Implemented Type I and II Slowly Changing Dimensions.
• Worked on delimited flat file sources.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner Transformation, Update Strategy, Lookup transformation, Rank transformation, Expressions, Aggregator, and Sequence Generator.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations and Mapplets confirming to the business rules.
• Testing and Data Validation - each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management.
• Created tasks like Timer Event Raise, Event Wait, Decisions, and Email.
• Data Enhancements and deliverables done to QA Environment Successfully.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Designed reusable transformations and Mapplets to be re used with various mappings.
• Performing Unit, Integration and Regression testing and preparing Test Cases for the same.
• Defined roles and responsibilities within the team and reviewing deliverables.
• Delegating work to team members.
• Coordinating work offshore team.

Environment:Informatica Power Center8.5 (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor), Oracle 10g, UNIX Shell Scripting, ERWIN 4.x

Client: Confidential, MichiganNov08-Dec09
Role: ETL Informatica Developer

Description:
Worked on "Supply Chain Regional Data warehouse Project", the project goal was to consolidate various IT support and Business processes across Mid-West region to use common Tools and Processes in an effort to align with PGM Center and thereby reduce overall operational and support costs. All the Midwest Regional Supply Chain applications, Data management and Reporting were standardized to use InformaticaPowerCenter for consistent Data Extract and Management and Cognos for consistent Reporting needs. The data was coming from various Plant Supply Chain applications (MAPS, RCS Manugistics, IDB, COLAS and LIMS) which are in AS/400 DB2, SQL Server and Oracle. All these data was extracted and consolidation into a Region-wide Data Warehouse accessible for business user query and reporting needs.

Responsibilities

• Interacted with business users and business analyst to understand requirements and system requirement specification document.
• Designed logical & physical data models for data warehouse & data marts with star schema and Snow flake Schema.
• Extracted data from DB2 and Oracle source systems and loaded into flat files using Informatica.
• Designed incremental loading process to load data into staging tables.
• Worked with active transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Designed and developed complex mappings using various transformations like unconnected and connected lookup's, Expression, Sequence generator and more.
• Implemented slowly changing dimensions according to the requirements.
• Used Workflow manager for creating, testing and running sessions and Batches.
• Optimized existing applications at the mapping level, session level and target level for better performance.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Configured the sessions using Workflow manager to have multiple partitions on source data and to improve performance.
• Identified and removed bottlenecks in order to improve performance of mappings and workflows.
• Developed shell scripts for informatica pre-session, post-session scripts.
• Developed test plans and test scripts to test the data based on the business requirements.
• Responsible for testing ETL jobs before test to production migration.

Environment:Informatica Power Center 7.1, Oracle 9i, DB2, MS SQL Server, Flat files, UNIX, Kornshell scripting, Windows XP.

Client: Confidential, Hyderabad, India. April06-May08
Role: ETL Developer

Description:
The existing OSSAMS tool generates reports on repair/trouble and provisioning data as imported from any provisioning or trouble reporting information sources. The graphical user interface (GUI) connects to the server side OSSAMS application that guides the users through a number of reporting and subtotaling options, giving the user a great deal of flexibility on the appearance of the final report. The existing OSSAMS database was replaced by Oracle database and GUI for generating reports was replaced with Business Objects. It required designing and developing complex business critical reports using PL-SQL and Business Objects on the new Data Warehouse developed in Oracle.

Responsibilities

• Informatica Mapping Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Extracting source definitions from various databases like Oracle, SQL Server and flat files.
• Creating the mappings using a variety of transformations like Source Qualifier, Lookup (static/dynamic cache, connected/unconnected, persistent/non-persistentcache),StoredProcedures (connected/unconnected, pre/post/normal), Routers, Filters, Aggregator, Normalizer, Unions, Update Strategies, Sorters.
• Working extensively with Shared Folders, Mapping Parameters & Parameter files in the mappings.
• Developing several Informatica mappings and tuned them for better performance.
• Developing, scheduling, monitoring workflows using Informatica Workflow Manager & Workflow Monitor.
• Creating Pre-session and Post-session UNIX scripts to disable/enable Indices, running procedures.
• Designing and Developing Oracle PL/SQL objects, Shell Scripts for Data Conversions and Data Cleansing.
• Creating Test Cases, Unit Testing and Integration Testing to ensure the successful execution of data load. .
• Participating in the System Integration Test, User Acceptance Test of the code, creating packages and moving code across environments.

Environment:Informatica Power Center 5.1, Oracle 7.3, SQL Server 2000, TOAD,UNIX.

Client: Confidential, Hyderabad, INDIA Feb05 - Mar06
Role: PL/SQL Developer

Description:
Confidential, is one of the India's leading IT company. The goal of the project was to create and application that maintains all database about clients accounts, fund direct, managed accounts and variable life data for a telecommunication department for State government.

Responsibilities:

• Involved in the preparation of specifications for PL/SQL procedures and functions to do the data migration and conversion.
• Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Coded SQL*Loader, PL/SQL procedures, and triggers to migrate data from legacy applications into Oracle.
• Updating existing procedures, functions, triggers and packages to synchronize with the changes in Transformations.
• Involved in extracting large volumes of data from different data sources into staging tables, performing transformations on them before loading into final tables.
• Involved in performance tuning using Explain Plan, Tkprof utilities.
• Created numerous views and materialized views to improve the performance.
• Provided Test Data to QA team for validation.
• Responsible for data analysis, engineering, programming, implementation and support for the product.

Environment: Oracle 8i, SQL, PL/SQL, SQL *PLUS, SQL* loader, Toad, UNIX Shell Scripting.