SUMMARY

• 10+ years of focused industry experience in ITwith a strong background in Database development and Data Warehousing, ETL process using Informatica Power Center 9.6/9.5/9.1/8.6 , Expert level skills in developing strategies for extraction, transformation and loading mechanism. Performance Tuning with strong knowledge in Master Data Management (MDM), MDM Architecture Solution, MDM Data Modeling, Data Governance, Data Quality (IDQ).
• Data Warehousing ETL experience of using Informatica9.x/8.x - PowerCenter Client tools - Designer, Repository manager, Metadata management (MDM), Data Quality (IDQ)., Workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Experience Delivering Responsibilities as different capacities as Senior Developer, Analyst and Programmer including interaction with Business Users for Requirements Gathering, Creating Technical Specifications, Design, Development, Feasibility studies, Scope Definition, Business Requirements Gathering, Business Process Analysis, Functional Specifications, Data modeling, Design, Development. Implementation
• Database experience using Teradata V2R6/V2R5/V2R4.1, Oracle 10g/9i/8i, MS SQL Server 2005/ 2000/7.0/6.5 , IBM DB2 UDB 8.0/7.0,Netezza 7.0, Sybase 12.0/11.x, SQL, PL/SQL, SQL*Plus, SQL*Loader, BTEQ.
• Hands on Working knowledge in SQL and PL/SQL Writing Stored Procedures, Packages, Functions and Triggers.
• Strong exposure in ETL design, including process flow, data flow, source-to-target mappings, physical database designs, data models.
• Proficient on working with Type 1 and Type 2 Slowly Changing Dimensions.
• Extensively worked on performance tuning logic to optimize the session Performance.
• Experienced in developing TestPlans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Experience on Unit testing and documenting the jobs.
• Involved in Migration process from development to Test and Production Environments.
• Strong experience with UNIX Shell Scriptingscripting, scheduling and managing the same for batch processes.
• Expertise in preparing process and technical documents like H.L. Confidential, L.L. Confidential, Mapping Specification Document, Unit Test plan, Code and Test review checklists .
• Experience in different Data Sources like Teradata, Oracle, Netizza, Siebel, DB2, Sybase, Xml, Flat Files.
• Project deliverables planning, risk & issues resolution, milestones tracking, team workload balance and stakeholder status reporting.
• Sound knowledge in Business Intelligence (BI) and System Development Life Cycle (SDLC).
• Strong interpersonal and communication skills with excellent teamwork orientation

TECHNICAL SKILLS

Operating Systems: Win XP/NT/2000/98/95, HP-UX 10.2/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Linux 2.6/2.4

ETL Tools: InformaticaPowerCenter9.x/8.x (Designer, Repository Manager, Workflow Manager, Workflow Monitor, Informatica Power Exchange, Informatica Power Connect). Informatica MDM 9.5/9.7. Informatica IDQ 9.6/9.1.

Other Tools: Visual Basic 6.0, Oracle Forms / Reports 6i/ XML Publisher

Data Modeling: Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x/3.x

Databases: Teradata V2R6/V2R5/V2R4.1,Oracle 10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2000/7.0/6.5 , Sybase 12.0/11.x,Netezza 7.0

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting.

Others: Quest TOAD 7.0.4, BTEQ, Management Studio, RazorSQL, SQL Developer, XML Publisher

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. ETL Informatica Developer/Onsite On site Coordinator

Responsibilities:

• SIWEB Project: Key projects involved were migration for Informatica OLAP/PLSQL. PARQ Datamart for new applications in SIWEB scope, Ad-hoc dashboard reports for Microsoft BI/Tableau.
• Worked on documenting the design aspects of complex projects that adhere to standards of Confidential & Confidential while learning the companies EDW architecture- middleware and developing the data mart for PARQ.
• Master Universe Project: Configuring end to end solution, which includes creating logical and physical data model, configuration of Landing, Staging, Base Object, Match rules, Trust, MDM mappings, Cleanse functions, Creating users and code deployment.
• Performed Proof of Concept for Informatica Data Quality (IDQ) standardization and profiling using Data Analyst.
• Perform Data Profiling to assess data quality, understand relationships, define Master universe and socialize the results with Business stakeholders.
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source Definitions, Target definitions and imported them to other environments.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Deeply involved in auditing of rejected data during the ETL process in production, development and testing environments.
• Responsible for working with dba/sys admin and BA groups to get approval in time for pushing Release items in monthly release.
• Designed, developed Informatica Power Center 9.6 mappings to extract, transform and load the data into Oracle 11g target tables.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Analyzed session log files if the session failed and resolved the errors.
• Onshore/Offshore coordination, Resources workload balance

Environment: ETL/Informatica PowerCenter 9.6, Informatica Master Data Management 9.5/9.7, Informatica Data Quality 9.6 (IDQ), Oracle 10g/11g, PL/SQL, SQL, SQL*Plus, XML, Flat Files, TOAD, Tableau, Splunk, SQL Developer, Unix, Netezza.

Confidential, Des Moines, IA

Sr.Informatica/MDM Consultant

Responsibilities:

• Worked with the business analysts to gather business requirements to be translated into design considerations.
• Using strong understanding with Oracle PLSQL worked oncoversion the existing etl packages from oracle ti informatica mapping/mapplets.
• Documented the technical documents and POC for ETL in Claims for existing CORE1 sources.
• Implemented Exception Handling Mappings by using Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.
• Created dimensions, hierarchies, mappings and mapplets using InformaticaPower Center Designer.
• Configured the mappings to extract data from Oracle 9i/10g, flatfiledata sources.
• Used transformations like Source Qualifier, Filter, Aggregator, Connected and Unconnected Lookups, Joiner, Expression, Sequence Generator, Update Strategy and Router transformations to extract and transform data in accordance with the business logic.
• Worked on priority production issue during Quarterly Releases.
• Was responsible for monitoring sessions that were scheduled, running, completed or failed intesting and production.
• Debugged mappings for failed sessions.
• Extensively involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Documented processing times, developed test cases and used them to run through each process.

Environment: Informatica Power Center 9.1, Informatica MDM 9.5, Informatica Data Quality 9.1, Oracle 9i/10g, Netezza6.0, SQL Assistant Queryman, FastLoad, MultiLoad, TTU 8.0), SQL/PLSQL, UNIX Shell Programming, Unix and NTWINDOWS NT.

Confidential, Richmond, VA

Sr. Informatica Consultant, Onsite Coordinator

Responsibilities:

• Responsible for process design and development of informatica workflows related to the Pharmacy Subject area.
• Involved in dimensional modeling of the data marts and responsible for impact analysis and downstream impact.
• Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
• Extracted/loaded data from/into diverse source/target systems like Teradata, Oracle, XML and Flat Files
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier on data extracted according to the business rules and technical specifications.
• Fixing the existing bugs in the load processfor scheduled release.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Used Workflow Manager for managing workflows and Session, database connections, memory properties and perform Pre- and Post-Session tasks.
• Performance tuned the workflow by identifying the bottlenecks in sources, targets, mappings and sessions. Identifying read and writes errors using Workflow and Session logs.
• Created shell script for archiving files and trigger files
• Worked on database connections, SQL joins, loops, views, aggregate conditions.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings, sessions or system. This led to better session performance.

Environment: Informatica Power Center 9.1,Informatica MDM 9.5,Oracle 10g, Teradata V2R6, SQL/PLSQL, UNIX Shell Programming, Linux and NTWINDOWS NT.

Confidential, Frederick, MD

Sr. Informatica Consultant

Responsibilities:

• Worked with the business analysts to gather business requirements to be translated into design considerations.
• Involved in dimensional modeling of the data marts to design the business process, grain, dimensions and facts.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created dimensions, hierarchies, mappings and mapplets using InformaticaPower Center Designer.
• Configured the mappings to extract data from Oracle 9i/10g, SQL Server, Terradatadata sources.
• Extensively used transformations like Source Qualifier, Filter, Aggregator, Connected and Unconnected Lookups, Joiner, Expression, Sequence Generator, Update Strategy and Router transformations to extract and transform data in accordance with the business logic.
• Used task developer in the Workflow manager to define sessions.
• Establish Loading process usingTerradataMLOAD, FLOAD and BTEQ. Fixing the existing bugs in the load process
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Developedschedules to automate the update process and Informatica Batches/Sessions.
• Monitored sessions that were scheduled, running, completed or failed.
• Debugged mappings for failed sessions.
• Worked on database connections, SQL joins, loops, views, aggregate conditions.
• Implemented data integrity constraints like referential integrity using primary-key and foreign-keys relationships.
• Involved in extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Wrote PL/SQL procedures for processing business logic in the database.
• Documented processing times, developed test cases and used them to run through each process.

Environment: Informatica Power Center 9.1, Oracle 9i/10g, Teradata V2R6 (Teradata Manager, BTEQ, SQL Assistant Queryman, FastLoad, MultiLoad, TTU 8.0), SQL/PLSQL, UNIX Shell Programming, Unix and NTWINDOWS NT.

Confidential, PA

Sr. ETL Developer

Responsibilities:

• Participated in business analysis, ETL requirements gathering physical and logical data modeling and documentation.
• Analyzed business requirements, performed source system analysis, prepared technical design documents.
• Developing ETL design, creating SQL views.
• Designing and developing Informatica mappings, sessions, worklets and workflows.
• Establishing and monitoring issue management, change management and quality management processes.
• Loading data from Flat Files into the Staging area and into the datamart using InformaticaPowerCenter.
• Extensively used Router, Lookup, Aggregator, Expression, Normalizer and Update Strategy Transformations.
• Debugger to monitor and ensure correct flow of data through mapping.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created, launched & scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads.
• Scheduling and monitoring automated daily and weekly jobs.
• Involved in creating test cases.
• Developed the documentation on the complete ETL process.
• Prepared Run books, production monitoring and support handbook for daily, weekly and monthly processing.
• Sending the updated status report to the client/vertical manager on weekly basis.

Environment: InformaticaPowerCenter 8.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, MS SQL Server 2000, Netezza, SQL, Confidential -SQL, PL/SQL, SQL*Plus, TOAD, ERWin 4.0, HP UNIX 10.2, WINDOWS NT.

Confidential, Mason, OH

Data Warehouse Developer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Involved in the analysis, design and development of all the interface’s using InformaticaPowerCenter tools in interface team and interfaced with all the other tracks for business related issues.
• Used ERWin to provide initial physical models to meet current naming standards and/or DDL for assigned projects.
• High proficiency with PowerCenter, Power Exchange, and involved in utilizing Informatica products to move Mainframe DB2 and flat-file data to oracle.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Created complex Informatica mappings to load the datamart and monitored them.
• The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used PMCMD command for running Informatica from backend.
• Programmed in PL/SQL, created stored procedure and functions
• Created database triggers for data security.
• Created and ran the unit test scripts for base datamart remediate unit test defects and modified code accordingly.
• Used relational sources and flat files to populate the datamart.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Used Debugger to test the mappings and fix the bugs.
• Created, updated and maintained ETL technical documentation.

Environment: InformaticaPowerCenter 9.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, MS SQL Server 2000, Teradata V2R5, SQL, Confidential -SQL, PL/SQL, SQL*Plus, TOAD, ERWin 4.0, HP UNIX 10.2, WINDOWS NT.

Confidential, Birmingham, AL

Informatica Developer

Responsibilities:

• Analyzed existing system prepared and presented an Impact Analysis Document.
• Actively participated in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Configured the Repositories.
• Developed various mappings by using reusable transformations.
• Improved the mapping performance using SQL overrides.
• Created Mapplets and used them in different mappings.
• Used Debugger to test the data flow and fix the mappings.
• Implemented Error data validations using Error handling strategy techniques.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Implemented all the ETL Architecture standards for the new technology Teradata
• Post-Production support to monitor jobs in new environment.
• Developed mappings, sessions and workflows for the new ETL process followed with Quality standards.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy and Normalizer.
• Developed and implemented the long term IT goals and strategies.
• Participate in the rotation of 24/7 supports.

Environment: InformaticaPowerCenter 8.6, Power Exchange, MS SQL server2000, Oracle 8i, PL/SQL, UNIX, Erwin 4.0, Windows XP, AIX, Microsoft Visio, SQL Plus, Mainframe DB2, TOAD.

Confidential, North Chicago

ETL - Informatica consultant

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Extracted data from SQL SERVER, XML, and ORACLE source databases.
• Involved in the ETL design and its documentation.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using Visio.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Processed customer address elements by Cleansing, standardizing and converting using PLSQL.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse from SQL server and xml.
• Extensive development from the xml sources using xmlsource qualifiers.
• Converted the DTS packages into Informatica mappings and loaded the target into the Oracle database.
• Experienced in handling slowly changing dimensions.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements. staging area.
• Created SHELL SCRIPTS for generic use.
• Developed Test cases for Unit Testing of the Mappings, and also was involved in the Integration Testing.

Environment: InformaticaPowerCenter 8.1, Windows XP/NT, SQL Server 2000/2008,DB2 UDB, Oracle 10g, SQL, PL/SQL, SQL Developer, Oracle Designer, MS VISIO,ERWIN, TOAD, Autosys, Korn Shell.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Setup Procedures to Extract, Transform and Load (ETL) data from Operational Systems to the Data Warehouse by Using Informatica.
• Developed a number of Informatica Mappings and Transformations to load data from relational and flat file sources into the data mart.
• Worked on several transformations such as Filter, Joiner, Lookup, Rank, Sequence Generator, Stored Procedure and Expression in Informatica.
• Implemented Type - 1 Slowly Changing Dimensions.
• Involved in creating, editing and scheduling of the Sessions in Informatica.
• Tuned the Transformations and Sessions for better performance.
• Used pre-session and post-session scripts for dropping and recreating indexes on target table.
• Recovered the failed sessions by enabling the recovery option.
• Involved in Developing the Tables, Views and Indexes.

Environment: InformaticaPowerCenter 8.6, Oracle8i, ERWIN 4.0, Windows NT/2000, HP/UX-11, Business Objects 5.1, Toad.

Confidential

Oracle Developer

Responsibilities:

• Involved in the Analysis of how the purchase order process is organized.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Involved in creation of Schema Objects like indexes views, and stored procedures
• Development of ETL loads from legacy systems..
• Development of Oracle Reports 6i and documenting the changes.
• Responsible for web-enabling all the forms and reports.
• Coding of application screens include creation of libraries, program units, triggers for enhancing the functionality of the screens, customizing them based on presentation logic.
• Involved in writing the Triggers which internally calls procedures and functions.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire process.
• Involved in Implementation and Testing phases of the system.

Environment: Oracle 8i, SQL*plus, SQL*Loader, PL/SQL, Forms 4.5, Reports 6.