SUMMARY

• 6+ years of IT experience in Data Warehousing and Oracle Data Integrator (ODI)
• Competent in using ETL and BI tools like ODI (11g/10g) and PL/SQL
• Worked on Integration projects involving E - Business Suite, Oracle and Teradata
• Well versedin Installation, configuration, Migration and administration of ODI platform and Applications.
• Gathered Business requirements by interacting with the business users.
• Customized ODI Knowledge modules.
• Extensively worked with ODI Designer in Creating Projects, Creating Models, Reverse engineering the data-stores (metadata) from Database, developing ODI Interfaces, developing ODI Procedures, defining Project specific Variables/Global variables (Declare, Set, Refresh, Evaluate Types), Defining the flow of execution in ODI Packages and generating ODI Scenario’s once the execution flow is defined in package
• Solid Experience in performing the customizations to the ODI Knowledge Modules as part of tuning the Knowledge Module Code based on the requirements
• Experience in Querying ODI work repository tables for capturing the information related to ODI Operator Logs.
• Experience in using ODI package Tools
• Experience in creating complex ODI interfaces with data sets, lookups and temporary interfaces.
• Experienced in tuning the ODI Interfaces, Load and SQL queries for better performance.
• Experienced in creating ODI Load Plans.
• Ability to configure Change Data Capture CDC and integrate with Oracle Golden Gate.
• Experience in Setting up User parameters in ODI.
• Experience in configuring Repository connection information in OdiParams.sh/Odiparams.bat files.
• Start/Stop the ODI Agent in Regular/Scheduling mode
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Strong leadership, interpersonal, public speaking, technical presentation and oral/written communication skills.
• Highly motivated, works well independently, and in a team environment.
• Possess strong foundations of Technology, Quality and Business Processes.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, DOS, Windows XP/NT

Programming Languages: C++, C

ETL: Oracle Data Integrator 11g/10g, Oracle PL/SQL

Databases: Oracle (11g/10g), MS SQL Server, Teradata

Web Technologies: HTML,XML, ASP, JAVASCRIPT

Configuration MGMT: Visual Source Safe 6.0

Familiar with: Core Java, ODI 12c, OBIEE 11g

PROFESSIONAL EXPERIENCE

Confidential, GA

ODI Developer

Responsibilities:

• Configured Oracle Golden Gate and Oracle data integrator in DEV,QA and PROD environments
• Understanding the business functionality & Analysis of business requirements.
• Involved in the preparation of the Detailed Design documents.
• Created data servers and physical & logical schemas for IBM DB2, Oracle databaseand flat files.
• Created interfaces, packagesto load data from IBM DB2, Oracle database, and flat files to Claims Data Mart on Oracle 11g.
• Customized IKM merge knowledge modules to handle a business scenario.
• Created procedures to execute complex business logic and re-usability of the code.
• Framework to handle full load and incremental load
• Migrated scenarios and other ODI components from one environment to other.
• Scheduled ODI scenariosusing ODI Agents and also assisted in creating a GUI interface to invoke the scenarios on Demand.
• Migrated ODI scenarios to test and production environment

Environment: Oracle Data Integrator (ODI 11g), IBM DB2, Oracle 11g, SQL Developer.

Confidential, TX

ODI Developer

Responsibilities:

• Configured Oracle Golden Gate and Oracle data integrator in DEV,QA and PROD environments
• Worked on ODI for data migration tasks and updating of databases.
• Used ODI designer to load data from flat files to target databases.
• Experience in configuring ODI agent as Load balancing.
• Extensively used different kinds of LKM’s like SQL loader, and file to SQLto load data
• Customized ODI topology settings for creating C$, I$, E$ tables.
• Customized IKM’s for creating the staging tables with no logging enabled and loading the data to the tables by splitting into parallel threads (performance enhancements) to load huge volumes of data.
• Involved in production support for an application with 5 different modules.
• Trained different application development teams in ODI.
• Used ODI designer to create interfaces, packages to facilitate data loading. Tune SQL statements to Insert and update data into the DIMENSION and FACT tables.
• Involved in upgrading ODI 10.1.3.4 to 11g beta version.
• Worked on ODI work Repository, Tables for capturing the Step details and the Sql’s generated by ODI and also the Error Messages encountered during the Interface (Scenario) Execution in ODI.
• Wrote complex SQL queries for extraction of data from various sources.
• Implemented reprocessing of interfaces (due to data errors) mechanism in ODI.
• Experience in scheduling the jobs in ODIScheduler.

Environment: PeopleSoft Financials, Oracle Data Integrator(ODI 10g/11g), Oracle 11g, SQLdeveloper, Flat Files

Confidential

ODI Developer

Responsibilities:

• Extensively worked in the ETL procedures and processes.
• Created data servers and physical & logical schemas for IBM DB2, Oracle database and flat files.
• Used ODI designer to create interfaces, packages to facilitate data loading. Tune SQL statements to Insert and update data into the DIMENSION and FACT tables.
• Designed the ETL processes using ODI Designer.
• Monitoring the ETL process using Operator and Metadata
• Error checking and testing of the ETL procedures and programs using Informatics session log
• Created variables, procedures, packages in ODI as part of Integration needs
• Used standalone agents to schedule ODI scenarios
• Worked extensively on Oracle database 9i and flat files as data sources.
• Huge volumes of Data extraction from legacy systems and uploaded into Oracle using SQL*Loader and PL / SQL.

Environment: Oracle Data Integrator (ODI 10g), Oracle 9i, SQL developer, Flat Files

Confidential

ODI Developer

Responsibilities:

• Understanding the requirements of the client, business scenario(s).
• Created and Configured Physical and Logical Agents at Topology level
• Developed workflow to kickoff either full loads or incremental loads based on the condition load type
• Converted the existing procedures and packages to ODI Interfaces and packages
• Developed interfaces with SCD-1 and SCD-2 loading strategies to populate dimensions and facts
• Developed utility to run only the interfaces which have changed in the source tables.
• Used variables to handle incremental and full load
• Used standalone agents to schedule ODI scenarios
• Migrated the ODI scenarios to production execution repository
• Provided production support

Environment: Oracle Data Integrator (ODI 10g), OBIEE 10g, SQL developer, Flat Files