Summary:

• Around 10 years of IT experience in the Design, Development, Implementation and Testing of Enterprise Data warehouse and Data mart applications for Sales, Logistics, Costumer support, Finance, Pharma, Manufacturing using Oracle Data Integrator ODI and Informatica Power Center.
• Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data Mart Life Cycle development.
• Strong experience in ETL Extraction, Transformation and Loading process using different tools like Oracle Data Integrator 10.1.3.5 , Informatica Power Center 8.5/8.1.1/7.1 .
• Involved in Data profiling, Data cleansing and legacy Data translation using Oracle AMB and IDQ.
• Extensively used ODI Oracle Data Integrator to extract data from different sources using Oracle Data Integrator tools - Security Manger, Topology Manager, Designer and Operator.
• Performed ETL process to load data from different sources into data warehouse using Oracle Data Integrator ODI and Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor .
• Experience in integration of various data sources databases like Oracle, SQL Server, Flat Files, Access, Hyperion, Sybase and DB2 into staging area. And also involved in migration of data from Informix 2.4, Teradata 7.1 to oracle database.
• Extracted client information data and history from JD Ewards, SQL server, Oracle E-Biz ERP applications to OBIEE which is OLAP tool.
• Designed and developed complex mappings and varied transformation logics using transformations like connected and unconnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more. Experience in execution of Sessions, workflows and worklets.
• Strong Oracle skills that include build/maintain tables and indexes, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions and performance tuning of SQL queries and Good knowledge in XML, HTML.
• Experience in Performance tuning, Backup/Recovery of Informatica Repositories. Good knowledge in latest Domain, Node and services concepts in Informatica 8.1.1. And experience in creating web service providers and consumers in Informatica 8.1.1.
• Worked in product based company and involved in installation and maintaining of Oracle Data Integrator ODI and PowerCenter 8.5 on different platforms like Solaris, Linux, AIX and upgraded from different versions latest versions.

Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

Professional Experience

Confidential

Role: Sr.ODI Consultant.

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 11g to DWH
• Migrated and converted the flat source files from multiple sources to ORACLE staging tables.
• Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
• Built transformations, configured servers and established connections to various sources and targets
• Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
• Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
• Handled error through exception handling and configured the event-based scenarios to send the alert emails.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Used I-series, SQL developer for Unit testing of data loaded after execution of interfaces.
• Understanding and discussing the new requirements from Business analysts through regular interaction.
• Involved in Installation, configuration and administration of development, execution repositories in ODI.

Environment: Oracle Data Integrator 10.1.3.5, Oracle11i, Jd Edwards, DB2, I-series, sql developer, Windows NT.

Confidential

Role: Sr.ODI Consultant.

Responsibilities:

• Involved in gathering business requirements, translating them into technical specifications and in writing mapping documents.
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Created specification documentation for ODI mappings based on extraction rules.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the target database.
• Created ODI Interfaces using different transformation logics and migrated data from legacy to oracle data base.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Extensively created procedures and variables to execute pre and post interfaces in a package.
• Used ODI operator to debugger after execution of interface.
• Strong data migration knowledge in Oracle E-Business Suite 12.1.1 modules like AR, AP, INV, CSI, QP etc.
• Created packages in designer and executed packages, interfaces, procedures, variables.
• Involved in Installation, configuration and administration of development, execution repositories in ODI.

Environment: Oracle Data Integrator 10.1.3.5, Oracle11i, Oracle E-Business Suite 12.1.1, DB2, I-series, sql developer, Windows NT.

Confidential

Role: ODI Developer.

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 11g to DWH
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Built transformations, configured servers and established connections to various sources and targets.
• Used ODI operator to debugger after execution of interface.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
• Handled error through exception handling and configured the event-based scenarios to send the alert emails.

Environment: Oracle Data Integrator 10.1.3.4, DB2, SQL Server 2003, Toad, Erwin 3.5, Oracle SOA Suite.

Confidential

Role: ODI Developer.

Responsibilities:

• Involved in gathering business requirements, translating them into technical specifications and in writing mapping documents.
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Created specification documentation for ODI mappings based on extraction rules.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the target database.
• Created ODI Interfaces using different transformation logics and migrated data from legacy to oracle data base.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Extensively created procedures and variables to execute pre and post interfaces in a package.
• Used ODI operator to debugger after execution of interface
• Created packages in designer and executed packages, interfaces, procedures, variables.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Used I-series, SQL developer for Unit testing of data loaded after execution of interfaces.
• Understanding and discussing the new requirements from functional team through regular interaction.

Environment: Oracle Data Integrator 10.1.3.4, Oracle11i, DB2, I-series, sql developer, Windows NT.

Confidential

Role: Informatica ETL developer.

Responsibilities:

• Used Informatica Power Center for Extraction, Transformation and Loading to Target.
• Extracted client information data and history from JD Ewards, SQL server,DB2 transformed and loaded into oracle database.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Developer.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data scrubbing and to cleansing and consistent data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, Look up.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Reusable Transformations, Mapplets and Mappings using Designer.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Worked closely with DBA and System testing teams in designing and testing of the application.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Created specification documentation for each ETL process based on client requirements.

Environment: Informatica 8.1.1, Oracle10g, DB2, SQL Server, PL/SQL, Flat files, Windows NT.