Mahesh

Work Exposure:

Project # 3                                                                             Aug 2022 – Dec-2022.

Project Name :Backer Hughes

Client             : TCS

Role               : ODI Developer.

ORGANISATION: EXPERIS IT Pvt Ltd.

Project Details:

BH is the world’s digital industrial company,transforming industry with software-defined machines and solutions that are connected,responsive and predictive.BH is organized around a global exchange of knowledge, through which each business shares and accesses the same technology,markets,structure and intellect.Each invention further fuels innovation and application across our industrial sectors.

Responsibilities:

·        Involved in to convert PL/SQL code to ODI mappings.

·        Created Data servers, Physical Schema, Logical Schema, Contexts using Topology

Manages and Monitored Execution of mappings using operator.

·        Involved in Data Extraction and Loading using Oracle Data Integrator.

·        Creating several reverse engineering Models as per the requirements.

·        Monitoring the Execution Logs in operator navigator.

·        Debugging the master jobs and packages by using operator navigator.

·        Mapped Logical resources to Physical resources in different contexts.

·        Scheduling the scenarios by using ODI Scheduler.

·        Debug the sessions by utilizing the log of the sessions.

·        Developed file to table mapping using odiftpget and odiftpput .

·        Created package for table to file using odisqlunload to generate file.

·        Created multiple variables in mappings and packages.

Project # 2                                                                                         APRIL 2021 – MAY 2022.

Role               : ODI Developer

Client             : OFSAA

Project Details:

Oracle Financial Services Analytical Applications (OFSAA) enable financial institutions to measure and meet risk adjusted performance objectives, cultivate a risk management culture through transparency, lower the costs of compliance and regulation, and improve insight into customer behavior.OFSAA has multiple tasks like home loan,carloan,personal loan etc.

Responsibilities:

·        Created Data servers, Physical Schema, Logical Schema, Contexts using Topology Manager and Monitored Execution of mappings using operator.

·        Involved in Data Extraction and Loading using Oracle Data Integrator.

·        Creating several reverse engineering Models as per the requirements.

• Created ODI procedures with SQL Procedures/Functions to build business rules to load data.
• Working with Flat files to load the data to Oracle target tables.
• Working with Oracle tables as source and loading to target.

·        Monitoring the Execution Logs in operator navigator.

·        Used various ODI tools like File Copy, Move, File wait, send mail,Filedelete,Unzip.

• Created and Tested ODI packages and scenarios for unit and integration testing process.
• Involved in support activities for this project.

·        Involved in Week-end ,month-end, year-end, forecasting & plan activities.

Project # 1                                                                             MARCH 2019 – APRIL 2021.

Project Name : Perkins Engine

Client             : Perkins Service System

Role               : ODI Developer.

Project Details:

Perkins is one of the biggest global Manufacturing Company, which produces electric, and diesel based power generator engines. Developing these types of engines for differentfields like Agricultural, Transport, Construction, Mines, and etc. The main objective of thisproject to create centralized data warehouse system to integrate all the sales and servicescenters. Oracle Data Integrator is used as an E-LT tool to integrate the data and place the datainto centralized data warehouse system to support the high-level business executives for theiranalysis. The Reports generated are total sales revenue - by week, month, quarter and year -based on the region, sales channel and the Product.