Highlights

• I have around 4.8 years of experience in Developing, Migrating and Supporting using Oracle Data Integrator (ODI) 12c as an ODI Developer.


• Have experience in data Extraction, Loading and Transformation in data warehouse environment.


• Designed and developed mappings to load the data from multiple sources like Relational databases, flat files into oracle database.


• Developed packages, Load Plans, scenarios using Mappings, Procedures, and variables.


• Worked with knowledge modules like LKM, IKM, RKM, CKM and JKM.


• I have knowledge about Designer, Operator, Topology and Security Navigators in Oracle Data Integrator.


• Experienced in developing SCD's using built in Knowledge modules.


• Experience in creating Load Plans to execute the ODI object (Scenarios) in Serial, parallel and conditional.


• Good Knowledge of Exception Handling in Load plans and Packages.


• Experience in scheduling ODI Scenarios as per the business requirements


• Knowledge on creating ODI procedures to create and populate in target systems.


• Knowledge of ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment and Configuration of Standalone agent.


• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and Hints.

Skills

Primary Skills

ODI tools

PL/SQL

Secondary Skills

Data Integration

SQL

Projects

Project #1: - IT Industry (8 months)

This project is a Rivus Fleet managed service. It is related to vehicle leasingrental, hiring, service Maintenance and repair of all types of fleets. It is UK’s largest fleet managed service company. ODI was used to design mappings and to load into the target.





Role & Contribution:






• Implemented best practices in Export and import a objects  between environments.


• Creating several reverse engineering Models as per the requirements.


• Creating mappings as per business requirement.


• And we got the requirements from client through Jira ticketing.


• And preparing the HLD documents.


• Creating Packages by using variables, mappings and procedures


• Monitoring the Execution Logs in operator navigator.


• Creating Mappings and Reusable mappings as per business requirement.


• Creating Load plans and scheduling the jobs.


• Imported master job and executed as per the requirements.


• As part of Boomi migration, I am also working QA team for testing Boomi jobs compared to ODI.






 

Project #2: - IT Industry (8 months)

Arval is Specialist in full – service vehicle leasing and new mobility solutions for its customers. This is France’s largest vehicle leasing company, this project strategy is to rethink the mobility mix by balancing vehicle leasing with alternative forms of mobility such as car sharing, carpooling, bikes and electric scooters. ODI was used to extract the data from source systems and do the transformation and finally loading the data into target database as per client requirement.





 Role & Contribution:






• We have Packages and we need to monitor it daily, all are daily running jobs


• We are monitoring the jobs by using ODI web console.


• This weather forecast doing for PROD, PRE and UAT.


• If any Package or individual job fails, we need to investigate that issue and resolve it.


• Also, tickets will be raised from the client side, so we need to do the analysis of the job/Package and will check the data flow and rectify the issue.


• And we are followed Agile Methodology: Sprint Planning, Daily Scrum call, Backlog refinement, Sprint review.


• As per client requirement Creating mappings and packages and scheduling the jobs.


• And do the migrations from DEV to UAT , UAT to PRE and PRE to PROD using export import objects in ODI.

Project #3: - IT Industry (34 months)

Herbalife Nutrition is a global multi-level marketing corporation that develops and sells dietary supplements. The company operates in 94 countries through a network of approximately 4.5 million independent distributors and members. Getting the orders data and customer’s data from the client as the source and loaded that data into target as per business requirement





 





Role & Contribution:






• Monitoring the Execution Logs in Operator navigator.


• Export and Import jobs from UAT to PROD and executed as per the requirement.


• We have multiple load plans and we need to monitor it daily.


• If any load plan or individual job fails, we need to investigate that issue and resolve it.


• And also, tickets will be raised from the client side, so we need to do the analysis of the job/Package and will check the data flow and rectify the issue.


• Sometimes I did the enhancement on jobs,


• And reverse engineering the source and target tables.