Experience Summary:

• Over 7+ years of experience in Information Technology including analysis Design, Development, Implementation of Data Warehousing in ETL Worked extensively in developing ETL for supporting Data Extraction, Transformation and Loading using Oracle Data Integrator (ODI) and Data stage.
• Experience in building BI DW’s/performing Data Integration from source systems to EDW, ODS, BI Reporting solution systems using Oracle Data Integrator v.11g/10g (v 11.1.1.7/11.1.1.6 v/11.1.1.3/v.10.1.3.5).
• Expertise in Oracle Data Integrator and ETL loads.
• Experience of having worked with ELT Tool ODI against different databases Oracle (9i, 10g), DB2, MS SQL Server (2005, 2008) and MS Access.
• In addition has knowledge of ODI 12 C and other tools like OBIEE, Informatica.
• Extensive development experience in Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server,DB2, Legacy systems, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.
• Worked extensively with complex interfaces using ODI.
• Expertise in implementing complex business rules by creating ODI interfaces.
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Hands on experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
• Experience in debugging Interfaces. Identified bugs in existing Interfaces.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Expertise’s in developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning.
• Experience in analyzing, requirement gathering, documenting and editing Business/User Requirements.
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements.
• Strong in analysis, design, coding and a good Team player in full life cycle / SDLC support from Initial design phase to production support.
• Proven track record of providing value-added service to the Business.
• Hands on experience in Performance Tuning at all levels
• ODI Best Practices Implementation.

Technical Skills:

ETL Tools: ODI 11g/10g, Data stage 8.1, Informatica 8.6.1
RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2
OLAP Tools: OBIEE 11g/10g
Programming Languages: SQL, PL/SQL, C#, UNIX shell scripting, XML, HTML.
Operating System: Windows NT, Windows 2003/2000, XP, and UNIX

Professional Experience:

Confidential, USA
ETL /ODI DEVELOPER
Confidential is a global nutrition company that has helped people pursue a healthy, active life since 1980.
Nutrition, weight-management and personal care products are available exclusively through dedicated independent Distributors in more than 80 countries.
Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Development and design of ODI interface flow for Upload / Download files
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle, SQL SERVER) feeds using ODI.
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures
• Develop packages for the ODI objects and scheduled them as scenarios
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator Enterprise Edition 11g.
• Support in full legacy to ODI data conversion and Integration task
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Installation and Configuration of Oracle Data Integrator (ODI)
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Responsible for configuration of Master and Work Repository on Oracle
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.

Environment: ODI (Oracle Data Integrator) 11g (11.1.1.7), SQL Developer, Oracle 11g/10g, OBIEE 11g, UNIX scripting, Windows NT

Confidential , Charlotte, USA
ETL/ODI DEVELOPER
Confidential Corporation is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. As of 2010, Bank of America is the fifth-largest company in the United States by total revenue, and the third-largest non-oil company in the U.S. (after Wal-Mart and General Electric). In 2010, Forbes listed Bank of America as the third biggest company in the world.
Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Development and design of ODI interface flow for Upload / Download files
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle,DB2) feeds using ODI and CDC
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures
• Develop packages for the ODI objects and scheduled them as scenarios
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator Enterprise Edition 11g.
• Support in full legacy to ODI data conversion and Integration task
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Installation and Configuration of Oracle Data Integrator (ODI)
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Responsible for configuration of Master and Work Repository on Oracle
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.

Environment: ODI (Oracle Data Integrator) 11g/10g (11.1.1.6/10.1.3.5 ), SQL Developer, DB2, Oracle 11g/10g, OBIEE 10.1.3.x, UNIX scripting, Windows NT

Confidential , USA
ETL DEVELOPER

Confidential is an American automobile manufacturer that has been producing automobiles since 1925. From 1998 to 2007, Chrysler and its subsidiaries were part of the German based DaimlerChrysler (now Daimler AG. Under DaimlerChrysler, the company was named "DaimlerChrysler Motors Company LLC", with its U.S. operations generally referred to as the "Chrysler Group".
Responsibilities:

• Identified components for migration to DataStage through in-depth impact analysis
• Prepared high level and low level design documents for the projects
• Designed ETL processes to Extract, Transform and Load from files into DB2 database and vice versa
• Used DataStage Designer for developing various ETL jobs
• Designed parallel jobs using various stages like Sequential File, Complex Flat File, ODBC, Join, Merge, Filter, Lookup, Modify, Transformer, Change Capture and Funnel
• Extensively used Complex flat file stage to read Mainframe files (Fixed and Variable)
• Developed jobs in QualityStage to standardize the data and used Info Analyzer for column, primary key and foreign key analysis
• Used Autosys to schedule DataStage ETL batch jobs on a daily, weekly and monthly basis
• Performed unit, integration and regression testing of ETL jobs
• Used DataStage Director to monitor and collect statistics of various ETL jobs
• Fine-tuned ETL jobs for better performance and cost effectiveness

Environment: IBM WebSphere DataStage 8.1, DB2, IBM Mainframe, MVS, SQL.UNIX Shell Script, Autosys