Professional Summary
6 Years of relevant work experience on Oracle Data Integrator (ODI) in Data Warehousing
field in IT industry using SQL & PL/SQL programming languages.
Installation of ODI 11g, Agents and worked on Designer, Operator, Topology and Security of
ODI 11g.Development of Interface, Procedures, Packages, Load plans.
Customization of Knowledge modules and good experience in the performance optimization
of the ETL code.
Good knowledge of Data Warehousing and database concepts.
Good client interaction and presentation skills.
Requirement gathering, technical design, implementation, SIT, UAT, production deployment &
post production support of multiple data warehouse projects.
Worked on various subject areas of Payment domain like Merchant Batch Processing, Fraud
Screening, Airline Domain like SBR(Structured Booking Records), DCS( Departure Control
System), Inventory, Settlement Systems.
Experience in preparing the documentation like mapping, migration, support documents, etc.
Worked in development as well as 24X7 production support team in the project.
Certification: AWS Certified Cloud Practitioner
Technical Skill set:
ELT Tool ODI 11G Studio
Database Oracle 11g
Language SQL , Basics of PLSQL, Shell Scripting & Batch scripting
Other Tools Toad , SQL Developer , Putty , WinScp ,ServiceNow, AutoSys
Operating System Unix, Windows Server 2008 R2, Windows 7
Project Details
Company- RBS
Project Name – Wall Street FX&MM Settlement
Industry – Finance Industry
Environment – Oracle Database 11g, Oracle Data Integrator 11g.
Programming Language- SQL & PL/SQL
Description: Wall Street is a Settlement Engine to settle the trades booked real time or at closure of
business. After Settlement of trades reports are generated and sent to the downstream systems .Real
time processing of trades are done using Oracle Goldengate with ODI to load the data into the target
Oracle tables and also the extracts are generated in the form of .Csv & XML files to sent those to the
downstream systems using ODI.
01st May 2019
Page 1 of 4
Roles and Responsibility:
ODI Upgradation from ODI 10g to ODI(11.1.1.9)g.
Creating Stand Alone Agents.
Creating ODI physical and logical connections in Topology.
Understanding the data model and to implement the same.
Creating Mapping document.
Developing ODI Interfaces, Packages, Procedures, Load Plans and Scenarios.
Performed the Real time Processing of Data Using Oracle Goldengate with ODI.
Performed Debugging and Tuning of mapping and sessions.
Scheduling and automation of jobs through Autosys.
Created yellow interfaces based on the requirement.
Migration the code from one environment to another environment.
Debugging the jobs in case of job failures
Resolving data issues
Responsible of daily production data loads
Worked extensively on XML files and used ODI In memory and external DB approach for
reading data from XML files.
Company- Oracle Financial Services Pvt Ltd
Project Name: MKB
Industry: Banking Industry
Client: MKB Bank
Environment: Oracle 11g, ODI 11g
Programming Language- PL/SQL
Description: MKB Bank is the fourth-biggest commercial bank in Hungary, and was the first to be
privatized, in 1994. The Project was to do the integration of MKB with Oracle’s Flexcube database.
The batch side programming was done using PL/SQL to extract and upload the data to and from the
Flexcube database to fulfil the requirement of the bank.
Roles & Responsibility:
Worked as a PL/SQL developer to create stored procedures, packages, functions to fulfill the
requirement.
Performed performance tuning of PL/SQL code.
Gathering of requirement from the client and creating the Analysis and Design document for
the assigned systems.
Assured no bug is present in the developed code and performed validation of the migrated
code.
Fixed various kinds of testing issues.
01st May 2019
Page 2 of 4
Company- ITC INFOTECH Pvt Ltd.
Project Name: SriLankan Airlines
Industry: Airline Industry
Client: SriLankan Airlines
Environment: Oracle 11g, ODI 11g
Programming Language- SQL & PL/SQL
Description: The project was for SriLankan Airines, a major Airline in SriLanka. The Project was to
create a data warehouse in Oracle 11g. The tool used for the code development was ODI 11g. The
Data warehouse has 8 data marts namely SBR ( Structured Booking Records), DCS(Departure
Control system), Inventory , Revenue Estimate, and others.
Awards: Spot Award at ITC INFOTECH Pvt. Ltd. Bangalore.
Roles & Responsibility:
Worked with different data sources like Flat files, XML Files and Relational database.
Developed ODI interfaces, Packages.
Had ownership of two Data Mart’s
Assured no bug is present in the developed code and performed validation of the migrated
data.
Involved in performance tuning
Fixed various kinds of migration issues.
Having good understanding of dimensional modelling.
Company- Accenture
Project Name – First data corporation ODS Implementation
Industry – Payment Industry
Client – first Data Corporation
Environment – Oracle Database 11g, Oracle Data Integrator 11g.
Programming Language- SQL & PL/SQL
Description: A complete data warehouse was built for First Data Corporation to cater their business
needs. The data warehouse has 9 data marts. The project was completed in 3 phases and at present
the project is in support phase. The ETL tool used was Oracle Data Integrator 11g, the various data
source were XML files, oracle database, and flat files.
The XML files are provided by third party vendor authorized by First Data Corporation.
The major subject areas on which I have worked are merchant batch processing, fraud screening.
The XML files were read through ODI 11g using in memory approach and also by using an external
DB approach.
Roles and Responsibility:
01st May 2019
Page 3 of 4
Installing the ODI 11g.
Creating Stand Alone Agents.
Creating ODI physical and logical connections in Topology.
Understanding the data model and to implement the same.
Creating Mapping document
Developing ODI Interfaces, Packages, Procedures, Load Plans and Scenarios.
Performed Debugging and Tuning of mapping and sessions.
Scheduling and automation of jobs
Created yellow interfaces based on the requirement.
Migration the code from one environment to another environment.
Debugging the jobs in case of job failures
Responsible of daily production data loads
01st May 2019
Page 4 of 4
