SUMMARY:

• Have 6+ years of total IT experience and strong background in Data Modeling, ELT Design, Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in the field of Data Warehousing in ELT process using ODI and Well experienced in all phases of System Development Life Cycle (SDLC).
• 4+ years of experience on ODI (Oracle Data Integrator).
• Expert in design, development and implementation of ELT code.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inmon) - Star Schema, Snowflake, Third Normal Form (3NF), SCD, Surrogate keys, Normalization/Denormalization
• Worked extensively with complex interfaces using ODI.
• Expertise in implementing complex business rules by creating ODI interfaces.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
• Designed and developed complex Interfaces using oracle data integrator(ODI)that involved Slowly Changing Dimensions, Error handling, SCD types, Golden gate CDC and Business logic implementation.
• Created ODI(Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Experience in Installation and upgradation of ODI.
• Proficient in Oracle Data Integrator - ODI, Quest TOAD, SQL*PLUS, PL/SQL.
• Developed database objects like functions, Store Procedures, triggers and packages using PL/SQL.
• Created packages and procedures to automatically drop and create views.
• Expertise in dynamic SQL, collections, exception handling, database design.
• Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Expertise in Client-Server application development using Oracle PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Ability to produce clear documented and commented code.
• Excellent analytical and interpersonal skills and strong ability to perform as a team.

TECHNICAL SKILLS:

Tools: Oracle Data Integrator, Informatica.

Operating System: Linux, SCO Unix, Windows 2003/NT/XP

Data bases/APPS: Oracle, SQL Server, Oracle BI Apps 7.9.6.3 / 7.9.6.2

DB Tools: TOAD, SQL Developer.

Reporting Tools: OBIEE 10.x/11g

Data Modeling: Erwin Data Modeler r8 / r7, Vision.

Other Tools: Winscp, Filezilla, Putty, TFS 2013

PROFESSIONAL EXPERIENCE:

Confidential, Libertyville, IL

ODI Developer

Responsibilities:

• Gathered business requirement and prepared mapping specs.
• Involved in upgradation of ODI from 11g to 12c version.
• Configured physical and logical topology.
• Reverse engineered source and target models.
• Worked on LKM (File to sql, sql to sql), IKM (Oracle global insert, Oracle incremental update), CKM (CKM oracle), RKM (Standard)
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files(.txt, .csv, .xlxs) into oracle database.
• Created reusable mappings to implement in main mappings.
• Installed, configured and trouble shooted Golden Gate for WMS and JMS services.
• Created complex mappings with business logic to extract data from SQL Server.
• Installed, configured and troubleshooted Golden Gate for WMS and JMS services.
• Created ODI packages and procedure to execute on fly.
• Used global and project variables (declare, evaluate, refresh).
• Created scenarios with multiple variables input/default values.
• Extracted SQL Server nvarcharmax data via decode logic to oracle clob.
• Applied hints on ODI to extract and load data.
• Created complex mapping with multiple source columns data to 1 target column.
• Import/Export development code to test and production environment.
• Versioned all ODI objects, unit test documents, and scripts to TFS.
• Created alerts process to send email notification via OdiSendMail.
• Unit tested ODI mappings and procedures and documented all unit test cases.
• Took all the responsibilities of data integration, migration and conversion,
• Worked with OWB for relational, dimensional and metadata modeling. Built ETL solutions using OWB for various automated data migration processing.

Environment: s: ODI 12.1.3, OBIEE,, Microsoft SQL Server Management Studio, SQL Developer 4.0, SharePoint 2010, UNIX, Putty, Filezilla, BIRT, TFS 2013, Microsoft Dynamics CRM 4.0, Air Frame CRM, Oracle Warehouse Builder 11g Release 2 (11.2.0.4.0 ).

Confidential, Dallas, Tx

ODI Developer

Responsibilities:

• Understanding the Functionality of GPC's Application and Business requirements.
• Interacting with client for appropriate requirement specifications.
• Did extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Identifying source data that concerns specifying business rules to transform source information into key indicators.
• Modeling the data structure of the target warehouse to store the required information.
• Populating the indicators by implementing business rules
• Measuring the overall accuracy of the data by setting up data quality rules
• Designed, developed ODI (Oracle Data Integrator) (Data Integration) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
• Designed and developed complex Interfaces using oracle data integrator(ODI)that involved Slowly Changing Dimensions, Error handling, SCD types, Golden gate CDC and Business logic implementation.
• Created ODI(Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Using ODI (Data Integration), Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.
• Designed, developed and modified materialized Views, Tables, Packages, and Functions and Stored Procedures.

Environment: ODI 11g, Oracle 11g, Microsoft SQL Server Management Studio, SQL Developer 4.0, SharePoint 2010, UNIX, PL/SQL, SQL, SQL Loader, Toad, ETL, Erwin 7.x, Flat files, Oracle 11g/10g, MS SQL Server 2010.

Confidential

Informatica Developer

Responsibilities:

• Responsible for development and support of ETL routines and designed Informatica loads required for populating the data warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for the Application.
• Extensively used various Data Cleansing and Data Conversion Functions in various transformations.
• Designed Mappings using B2B Data Transformation Studio.
• Involved in Dimension modeling of Data warehouse designed the business process, grain, dimensions and measured facts.
• Created necessary repositories using repository manager to handle the metadata in the ETL process.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ.
• Used IDE to identify data duplication, understand the quality of data and report generation.
• Experience on ETL Informatica 9.x/8.x (Power Center), IDQ, B2B DX/DT v 8.0.
• Migrated the code into QA (testing) and supported QA team and UAT (User).
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon's (SCD) and Change Data Capture (CDC)
• Developed SSIS packages to extract data from different sources like OLTP databases, Excel files, Flat files, from FTP servers about Time Warner's usage data.
• Applied various SSIS transformations like look-up, conditional-split, derived column data conversion extensively.
• Responsible to collaborate with DBA and Data Architects on implementation of database changes.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Worked on database links, SQL joins loops, aliases, views, aggregate conditions and also wrote various stored procedures, Functions and Triggers for processing business logic in the database.
• Assisted in design and maintenance of Metadata environment.
• Extensively worked with multi-dimensional expression data.
• Involved in scheduling the Informatica jobs and UNIX scripts and Oracle procedures.
• Resolving if any issues in transformations and mappings during the development.
• Interacted with end users, regularly in order to generate the reports required.
• Designed and created an Autosys job plan to schedule our processes.
• Created Partitions through the session wizard in the Workflow Manager to increase the performance.

Environment: Informatica Power Center 8, UNIX, SQL Server, OBIEE, Business Objects, Visual Studio 2010 shell for SSIS, SSRS and SSAS