PROFESSIONAL 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.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Expertise in HP ALM to write test cases and track the defects.
• Worked on ERP source systems like Oracle EBS 11i/R12, Siebel and Oracle Fusion Middleware.
• 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.
• Extensively worked in Client - Server application development using Oracle 11g, 10g, 9i/8i, PL/SQL and SQL*Plus.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS
• Extensive Experienced in Performance Tuning of targets, sources, mappings and sessions, Co-coordinating with DBAs and UNIX Administrator for ETL tuning.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Experience in BI tools like OBIEE, XML BI Publisher
• Extensively worked with Change Data Capture (CDC) in all my previous projects.
• Good Knowledge with UNIX Operating System and Shell scripting.
• Strong knowledge on Oracle Applications EBS 11i/R12 modules like Oracle Financials, SCM, HRMS,CRM, OM, PO, INV, AP, AR, GL, Oracle Project Accounting, Billing and costing
• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.

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, Boston, MA

Sr ETL 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
• Developed/Enhanced the complex mappings, Workflows to Extract, Transform, Load data from different source systems like Oracle, Flat files, Excel to Target Oracle systems.

Confidential, Boston, MA

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 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.
• Good Knowledge on OBIEE reports.

Environment: Oracle EBS R 12/11.5.10.2 , Informatica Power Center 9.6, Oracle 10g, PL/SQL, SQL, SQL*LOADER, ERWIN, 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.
• Good Knowledge on OBIEE reports.
• 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.
• Involved in identifying the source systems and enhancing Source file validation shell scripts as per new requirements.
• 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.

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.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• 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.

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 workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Used Teradata fast loads for truncate load tables and mloads for insert, update and upsert options.

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

Confidential, Houston

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 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.
• Involving cube tuning activities and cube enhancing based on new requirements
• 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.
• 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.
• Created packages in Harvest to migrate code across multiple environments through a standard transmittal process.
• 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.
• Created reusable mapplets and transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
• 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.
• Optimization of Outline, Data Load Rules and Calc Scripts.
• 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.
• Creating Relational Connections, Migrating the Mappings from Dev to Test and Test to Production.

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: UNIX, Shell Scripting SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, Replication.