Background Summary

• Over 8 years in Data Warehouse/Data Mart Development. Experience in Design and maintenance of Pharmaceutical, Financial, Health Insurance and Manufacturing Data Warehouse applications.
• Excellent experience in data extraction, transformation and loading data using Informatica Power Center 9.5.1/9.1.1/8.6.1/8.1.1 Designer, Workflow Manager, Workflow Monitor , and Informatica Power Exchange 8.1.1.
• Support between developers and end users, functional managers and Oracle regarding issues with database software, SQL programming, tuning, releases and development with Oracle tools like Oracle Warehouse Builder.
• Experienced in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Created Webservice definitions and developed corresponding WSDL's for the Webservices.
• Created data maps, registration groups and amended all the DTL fields to capture the changes in the power exchange navigator.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in data modeling in ERwin 4.0/3.5.
• Experience in coding using SQL, SQL plus, PL/SQL procedures/functions, triggers and exceptions. Good experience in Relational Database concepts, Entity relation diagrams.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre post session operations.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.

TECHNICAL EXPERTISE:

Data warehousing Tools Informatica Power Center 9.5.1/9.1.1/8.6.1/8.1.1,OWB 10.2, Informatica Power Exchange 8.1.1, Webservices Hub

Data Modeling ERwin 4.0/3.5, Star and Snow schema Modeling

Operating Systems UNIX, Sun Solaris, Linux redhat 9.0 , Windows95/98/2000/XP/NT, HP-UX

Programming Languages C, C , HTML, DHTML, XML, PL/SQL, Shell Scripting

Databases Oracle 9i/10g/11g, MS SQL Server 2005/2000, DB2

Tools TOAD, Kintana, VSS, Serena Dimensions, MQC, QTP, SharePoint, SOAP UI, Tivoli, Remedy, Starteam

PROFESSIONAL EXPERIENCE:

Confidential

Sr ETL Developer

Responsibilities:

• Worked with other ETL developers to provide the deliverables on time.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Prepared Detail design documents for the project as per the ETL standards, procedures naming conventions and code fixes.
• Created simple OBIEE reports, analyzed, generated and validated data using the reports.
• Developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from Oracle database.
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Designed different types of look-up connected/unconnected transformations in both mapping and mapplet according to the requirement of transformation.
• Involved in designing Logical and Physical models for staging, transition of the Data.
• Analysis was done using existing transactional database schema and designing Data Model to support user need for reporting.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Written pre session and post session scripts in mappings.
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager. Generated completion messages and status reports using Workflow Manager/Workflow Monitor.
• Created tables using DDL's and modified existing tables in the database based on the requirements.
• Created test cases and test scenarios and worked with users on test load analysis.
• Involved in system testing of overall processes and provided production support.
• Performance tuning of ETL Jobs and provide analysis of any outstanding issues.

Environment: Informatica 9.5.1/9.1.1, Oracle 11i, SQL Tool, UNIX, Toad, OBIEE 11.1.1.7.

Confidential

ETL Developer Lead

Responsibilities:

• Designed and developed ETL Processes based on business rules using Informatica Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, lookup and update strategy transformations.
• Involved in Performance Tuning of the mappings, used Informatica Debugger.
• Migrated Informatica Objects Mappings, Work-flows and Sessions from Dev/Test environment to Production environments by creating deployment groups.
• Developed reusable transformations and mapplets.
• Designed and developed the workflows, validated the dependencies in between the workflows which involved various tasks like even-wait, command, session tasks.
• Developed standard and re-usable mappings and mapplets using various transformations like Stored Procedure, Expression, Aggregator, Joiner, Source Qualifier, Router, Lookup, and Filter.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Used repository views in mappings in order to get the load status.
• Introduced partitioning in sessions based on data regions.

Environment: Informatica 8.6.1, Oracle 11i, PL/SQL, SQL Tool, Toad.

Confidential

ETL Developer

• Involved in the review and walkthrough of the business and technical requirements documents.
• Involved in creating the Webservices and testing them using SOAP UI tool.
• Involved in creating Webservice definitions and developed corresponding WSDL's for different Webservices.
• Extensively used Data transformation as part of developing the Informatica B2B code.
• Extensively created mapping/mapplets using all the transformations like joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, webservices consumer, SQL.
• Involved in creating UNIX shell scripts for scheduling the jobs using PMCMD and generating the Parameter Files, Manipulate/Archive Source Files.
• Involved in working with EDI HIPAA transactions 270, 271,276 and 837 .
• Worked on the complete end-to-end processing of the 837 Claims Information. Helped to debug and modify Informatica maps for 837 processing.
• Created, optimized, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Involved in tuning the SQL queries and the long running ETL mappings.
• Extensively worked with the QA team to ensure that the System and Integration test plans are completed successfully.
• Involved in trouble shooting the performance issues.

Environment: Informatica Power Center 8.6.1, B2B, PWX 8.6.1, Informatica Power Center Webservices Hub, Data Transformation, Oracle 10g, DB2, SQL server 2005, UNIX.

Confidential

ETL Developer

Responsibilities:

• Implemented Change Data Capture CDC using the pwx listener and condense jobs.
• Registered tables and amended all the DTL fields in the condense jobs.
• Performed row test to ensure all the changes are captured in the power exchange.
• Created Complex SCD type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Involved in performance or tech test to check the efficiency or performance of the code
• Created parameter files for all the workflows in both the initial/historical and incremental load.
• Loaded Data Acquisition DA layer with the committed transactions like Inserts, Updates, and Deletes on the source database ODS Facets 4.5 using power exchange and power center to serve downstream applications reporting requirements.
• Involved in migrating the registration groups from one environment to other by copying the CCT file using DTLURDMO tool.
• Used SQL transformations to run all source and target queries stored in Metric audit tables.
• Assisted in scheduling batch jobs using JCL's and shell scripts on CA-7 scheduler.
• Used Serena Dimensions for version control of ETL code, parameter files and migration of the code to different environments.
• Used PMERR tables in the power center for Error Handling.

Environment: Informatica Power Center 8.1.1, Informatica Power Exchange 8.1.1, Oracle10g, Toad, SQL Developer, UNIX, MQC, Serena Dimensions.

Confidential

ETL Developer

Responsibilities:

• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Responsible for using the capabilities of PowerCenter namely list files, pmcmd, pmrep, Target override, Persistent lookup, Dynamic Static lookup.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Developed Informatica Mappings, Re-usable Transformations, and Mapplets for data load to data warehouse and database oracle .
• Support between developers and end users, functional managers and Oracle regarding issues with database software, SQL programming, tuning, releases and development with Oracle tools like Oracle Warehouse Builder.
• Involved in creating ETL model snowflake schema , normalizing and documenting.
• Involved in Re-Design that includes dynamic creation of the logic when the new data is added to the system avoiding recoding.
• Walked through the Logical and Physical Data Models of all source systems for data quality analysis.
• Involved in XML parsing and loading XML files into the database.

Environment: Informatica Power Center 8.1, OWB 10.2, Oracle 11g/10g, ERWIN 4.0, PL/SQL developer, XML, UNIX, Windows.

Confidential

Informatica Developer

Responsibilities:

• Created Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Involved in designing of star schema based data model with dimensions and facts.
• Wrote shell scripts in UNIX environment.
• Involved in writing lot of Functions, Stored Procedures in PL/SQL as per the requirements.
• Used Dashboards and created complex SCD type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Partitioned sources to improve session performance.
• Developed data-driven approaches to support event-based job workflow scheduling.
• Performance Tuning of Sessions and Mappings.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate One time and Monthly loading of Data.
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production.
• Created design documents and performed Unit Testing on the Mappings.

Environment: Informatica Power Center 8.1/7.1.3, Business Objects 6.0, ERWIN 4.0, TOAD, XML, Oracle 10g/9i, UNIX, Windows.