SUMMARY

• Having 9+ years of IT experience in various phases of IT projects following the SDLC process such as analysis, design, coding, testing and deployment.
• Strong Data warehousing experience in building and managing various data warehousing/data marts using Informatica products such as Power Center 9.x/ 8.x/ 7.x/ 6.x.
• Strong experience in extraction, transformation and loading data using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor)
• Performed the data profiling and analysis making use ofInformatica Data Quality (IDQ).
• Experience in BI tools like OBIEE, XML BI Publisher
• Worked on ERP source systems like Oracle EBS 11i/R12, Siebel and Oracle Fusion Middleware.
• Worked on data integration project from SAP to EDW systems.
• Working Knowledge on different data sources such as Flat Files, Oracle, SQL Server, DB2, Sybase, XML files and Excel Files.
• Worked on Salesforce (Veeva) source system.
• Extensive knowledge in Kimball and inmon mythologies.
• Extensive experience in Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica 8x using PMCMD, repository creation/Backup/Restore using PMREP, Creating repository user/role/group
• Experienced in improving session run times by partitioning the sessions.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Automated the processes using UNIX shell scripting and scheduled them via Autosys and UC4.
• Strong troubleshooting and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Good Knowledge with UNIX Operating System and Shell scripting.
• Expertise in HP ALM to write test cases and track the defects.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x/8x/7x/6x, ERWIN, SSIS.

Languages: SQL, PL/SQL, T-Sql, C, C++.

RDBMS: Oracle 11g/10g/9i/8i, DB2, SQL Server, MS Access.

Environment: s: WINDOWS NT/98/95/2000/XP, LINUX, IBM OS/2, UNIX, MS-DOS

Scheduling: DAC, crontab, Informatica Scheduler, AppWorx, Unix scripts.

Tools: TOAD, FTP, Mercury Quality center, HPSD, Remedy, Kintana, PVCS,SVN.

Reporting Tools: OBIEE, XML BI Publisher, Discover, Developer 2000, MS Access Reports.

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr ETL Developer

Responsibilities:

• Developed Customer master mappings to identify the final address from different vendor files.
• Created Technical Design Document from the functional specification documents.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Automated the Target alignment process which is used for Pharma salesreps.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Worked withInformaticaData Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.
• Developed PL/SQL stored procedures and packages to process the data for Oracle Confidential Data Warehouse.
• Worked on tuning the informatica mappings, sessions, workflows and worked on the informatica session partitions.
• Identified and debugged the critical production issues and worked on its resolution.
• Customize the existing Informatica mappings which are sourcing from Salesforce application.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Used Informatica PowerCenter 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, Flat files, Excel to Target Oracle systems.
• Created design documents and performed Unit Testing on the Mappings.
• Work closely with DBAs, application, database and ETL developers, change control management for migrating developed mappings across Dev, QA, and PROD environments

Environment: Salesforce, Informatica Power Center 9.6, IDQ 9.6, Oracle 11g, PL/SQL, SQL, SQL*LOADER, SQL Developer, TOAD, Shell Scripting

Confidential, MA

Sr Informatica Analyst

Responsibilities:

• Analyzed the existing mappings which are affecting during rollout.
• Worked with Business Analysts and identified the mappings which need to modify to load international operating units data into EDW system.
• Developed new mapping to inactivate International customers from customers dimension and load customers from Oracle EBS.
• Developed PL/SQL packages to load the data from EBS tables to ODS tables.
• Developed new Informatica mappings to load the international data into existing EDW system
• Developed the Informatica mappings to load the Sales Orders, Purchase Order details from Oracle EBS tables to ODS tables and EDW.
• Developed the Informatica mappings to load the Receivables Invoices, Revenue Information and Ledger details from Oracle EBS tables to ODS tables.
• Oracle ERP to integration system to forecast the Items.
• Prepared the automation script which identifies the data gap between source and target systems.
• Used Transformations like Source qualifier, Aggregator, Expression, Rank, Router, Filter, Update Strategy, Joiner and Lookups.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs.

Environment: Oracle EBS R 12/11.5.10.2 , Informatica Power Center 9.6, Oracle 11g, PL/SQL, SQL, SQL*LOADER, TOAD, Shell Scripting

Confidential, Minneapolis, MN

Sr Informatica Analyst

Responsibilities:

• Developed the Informatica mappings to load the Sales Orders, Purchase Order details from Oracle EBS tables to ODS tables.
• Developed the Informatica mappings to load the Receivables Invoices, Revenue Information and Ledger details from Oracle EBS tables to ODS tables.
• Developed the Informatica mappings to load the Items and Item categories information from Oracle ERP to integration system to forecast the Items.
• Developed the Informatica mappings to load the Stores information from EBS to SQL Server Ordering application.
• Designed the Data Mapping documents from Oracle EBS to ODS tables.
• Involved in developing OBIEE reports.
• Worked with the XML files to load the xml data in to the staging database.
• Load the data from the files to Oracle database tables by using SQL Loader.
• Used Transformations like Source qualifier, Aggregator, Expression, Rank, Router, Filter, Update Strategy, Joiner and Lookups.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs.
• Involved in preparing Low level Mapping design documents and detailed technical specification spreadsheets.
• Defined Target Load Order Plan for loading data into different Target Tables
• Prepared the Job schedule spread sheets as job dependency to run the jobs with Oracle DAC scheduling tool.
• Designed the documents which are based on the required specifications.
• Perform extensive testing and wrote SQL queries to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Customize the logic of mappings.

Environment: Oracle EBS R 12/11.5.10.2 , Informatica Power Center 9.1, Oracle 10g, PL/SQL, SQL, SQL*LOADER, ERWIN, TOAD, Shell Scripting

Confidential, Denver, CO

Sr Informatica Developer

Responsibilities:

• Retrofitted PL/SQL scripts, functions and procedures from Oracle EBS 11.5.10 into the R12 world.
• Developed the Informatica mappings to load the Sales Orders, Purchase Order details from Oracle EBS tables to Warehouse tables.
• Implemented and configured OBIEE in Windows environment and integrate it with ORACLE data warehouse.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.
• Knowledge on using Debugger within the Mapping Designer to test the data flow between source and targetand to troubleshoot the invalid mappings.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Used SSIS to create complex mappings using different transformations to load data to server.
• Experienced in using the UTL File package in PL/SQL, to develop oracle concurrent request scripts for writing tables into MS Excel Worksheet.
• Developed stored procedures using PL/SQL.
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
• Used Autosys scheduler to schedule and run Informatica workflows.
• Developed reports on SSRS on SQL Server.

Environment: Oracle EBS R 12/11.5.10.2 , Informatica Power Center 8.6/ 9.1, Oracle 10g, PL/SQL, SQL, SQL*LOADER, ERWIN, TOAD, Shell Scripting

Confidential, CA

Senior Informatica Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Used Informatica PowerCenter 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.
• Efficiently worked on MDM data modelling, data mappings and data integration.
• Involved in integrating external business application with Informatica MDM hub using Batch process.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Worked with BA in the QA phase of testing.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications using ERWIN Tools.
• Involved in analyzing existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques using ERWIN in Data warehouse.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts
• Extensively used SSIS FTP tasks for data transfers from FTP servers to SQL Server.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used Teradata fast loads for truncate load tables and mloads for insert, update and upsert options.

Environment: Informatica Power Center 8.6, ERWIN tool, T-sql, Oracle 10g, PL/SQL, SQL, SQL*LOADER, ERWIN, TOAD, Shell Scripting

Confidential

ETL Developer/Analyst

Responsibilities:

• Involved with development of ETL process flows to transform data from multiple sources into common staging area and then loaded them to the target Warehouse database.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, SQL Server, Flat files, Excel to Target Oracle systems.
• Created reusable mapplets and transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
• Developed the informatica Mappings to load the SAP sales orders,Purchage order data into warehouse.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on analyzing the PLSQL code for extraction of Business logic involved in the Data loading process.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production.

Environment: Informatica Power Center 8.X, ERWIN Tool, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, MS-Excel XP Spreadsheet Add-In, Shell Scripting using AWK/ SED

Confidential, Columbus, OH

ETL / Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 6.2 - Source Analyzer, Data warehouse designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Responsible for design, development and maintenance of Data Marts including Sales, Policy, Customer Reporting and Claims leveraging Informatica Power Center ETL tool, Oracle, DB2 and PL/SQL.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center.
• Responsible for development of robust and reliable solutions requiring low maintenance, thorough testing of solutions.
• Strong experience on health care provider directory.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings.
• Used the Informatica Server Manager to embed sessions with pre- and post-session shell scripts. Also, wrapped session PMCMD commands in shell scripts for batch processing using Autosys Scheduler.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts.
• Used crontab to schedule jobs in the production environment.
• Created Stored Procedures to transform the data. Worked extensively on SQL, PL/SQL for various needs of the transformations.
• Actively involved in building the system test environment and migrated mappings from Development to System Test environment and executed code in QA environment.
• Participated in Review of Test Plan, Test Cases and Test Scripts prepared by system integration testing team.
• Monitored the performance and identified performance bottlenecks in ETL code.

Environment: Informatica Power Center 6.2, Oracle 9i, DB2, ERWIN 4.0, Unix Shell Scripting, Teradata V2R5, Crontab, MS PowerPoint, Business Objects 6.0/6.5, SAS, TOAD 7.5, SQL, PL/SQL, Win NT 4.0

Confidential, Atlanta

ETL Developer

Responsibilities:

• Involved with development of ETL process flows to transform data from multiple sources into common staging area and then loaded them to the target Warehouse database.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, SQL Server, Flat files, Excel, Informix, to Target Oracle systems.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on analyzing the PLSQL code for extraction of Business logic involved in the Data loading process.
• Developed many data load rules for loading specific type of data files.
• Involving cube tuning activities and cube enhancing based on new requirements
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, ERWIN 4.0, Unix Shell Scripting, Crontab, MS PowerPoint, Business Objects 6.0/6.5, SAS, TOAD 7.5, SQL, PL/SQL, Win NT 4.0

Confidential

Oracle Developer

Responsibilities:

• Analyzed the sources, targets, transformed the data, mapped the data and loading the data into targets using Informatica.
• Developed different Transformations to load the data into target.
• Extracted data from various source systems and populated Target system with the transformed data.
• Used different transformations like Filter, Aggregator, Rank, Lookup and Expression.
• Prepared mapping documents.
• Developed stored procedures.
• Developed master scripts to move the database objects from one instance to other instance.

Environment: SQL, PL/SQL, Informatica Power Center 7.1, Oracle 9i, DB2, ERWIN 4.0, Unix Shell Scripting,