Professional Preface:
 Overall 9.6 yrs. experience in application development on Oracle Data Integrator(10G/11G/12c) ETL Tool, PL/SQL and
Oracle Application Express Tool (3.0/3.2/4.0).
 Currently working as an ODI Consultant on one of the US leading conglomerate manufacturer of industrial pproducts.
 Worked in Client Location (Milton Keynes, London) for 1 year as Data Migration Engineer which includes live
migration execution, client interaction, creating/raising of new stories along with design team.
 Process expertise in Agile Methodology.
 Capable of self-learning to explore technical competency over a broad range of technologies. 

Organizational Experience
Organization Designation Duration Location
TCS Assistant Consultant Sept.18 – Till Date Hinjewadi, Phase III, Pune.
Oracle Financial Soft. Services Principal Consultant Oct. 16 – Aug. 18 Ambrosia, Pune
Accenture Software Eng. Sr. Analyst Aug. 14 – Oct. 16 Magarpatta, Pune.
IBM System Engineer Feb 13 – Aug. 14 Hinjewadi, Phase II, Pune.
Tech Mahindra Ltd. Technical Associate May 10 – Feb 13 Hinjewadi, Phase III, Pune.
Avanti Software Solution Pvt. Ltd. Software Developer Oct 09 – Feb 10 Pune

Skills Set
Soft Skills
Excellent planning and people management
skills, grasping power, zeal for taking initiative.
Designing & Documentation
Unified Modeling Language (UML), Rational
Rose, MS Word, MS Excel, MS Power Point
Domain
Telecom, Banking,
Manufacturing
Database, Web Servers and Tools
Oracle-10g/11g, SVN, GIT, SQL Developer,
WebLogic server, MSSQL-2014, Toad9.6
Technologies/Tools
ODI, OBIEE, Oracle Application Express (APEX), PL/SQL, Jython, Got
training on Talend /Informatica/ Ab Initio/ Tableau, UNIX.

Achievements:
 Awarded with prestigious “Accenture Celebrates Excellence (ACE)” Award in Q2-16 for ODI production related
work and “APEX” award in Q2-15 for ODI fixed line deliverable in NewCo, UK project.
 Received “Cookies” award for UKBSS Migration project.
 Received “Smooth Operators” client (BT) appreciation reward on completion of 50K DM within specified deadline.
Significant Projects:
 BI/DW-Dover Corporation, USA.
 Banca Intesa Belgrade(BIB), Serbia.
 Vodafone NewCo, UK.
 Vodafone Roaming Services, UK.
 BT UKBSS Migration, UK.
 eLearning, Pune.

BI/DW-Dover Corporation, USA
Role ODI Consultant Duration: Sept. 18 – Till Date
Environment Oracle Data Integrator 12C, PL/SQL, Oracle12C, Unix, MSSQL-2014, etc.
Description The global BI/DW (Business Intelligence/ Data Warehouse) delivery solution for Dover
Corporation (Fluids & Fueling segments) with a strategic vision of a common BI analytics and Data
Warehouse platform across all Dover Fluids/Fueling Business Units.
 The data for BI reports designed and developed on top of data warehouse layer and this data
will be sourced from Dover’s data source environments (SAP R/3 and Oracle R12.1.3.)
Below is a reusable BI solution implemented across the following Dover operating companies so far:
1) CPC 2) Hydro 3) Grand Terrace 4) OPW 5) Grand Rapids 6) DFS 7) MAAG 8) PSG
The ODI processes has been classified into the following categories. Each of the categories has been
identified with their corresponding folders:
 EBS to Staging Area: Each ODI process to load the data from EBS to the staging area.
 Warehouse Dimensions: Each ODI process to load the dimensions from the staging area to
the warehouse is defined here. There are subfolders for each of the dimensions.
 Warehouse Fact Tables: Each ODI process to load the fact tables from the staging area to
the warehouse is defined here. There is subfolder for each of the fact tables under their
corresponding modules.
Responsibilities  Connect with client and design team during requirement analysis Phase.
 ODI 12C development which includes topology configuration, creating different technologies
connection and Model formation and creating of different type of transformations.
 Team handling to full fill all task and delivered items on time.
 ODI POC for any production related issue and for any new requirement.
 Creation of ODI technical design document.
 Actively involved in live production related issues, code release and deployment activity.
 Had implemented different performance improvement ideas for ongoing performance issue
identified in production environment.
 Got knowledge on OBIEE reporting framework and its end use as per business need.

Oracle Financial Software Solution
Banca Intesa Belgrade(BIB), Serbia
Role Integration Consultant Duration: Oct. 16 – Aug.18
Environment Oracle Data Integrator 12C, PL/SQL, Oracle12C, Unix, MSSQL-2014, etc.
Description Banca Intesa ad Beograd replaces its Asseco legacy core banking system with Oracle FLEXCUBE.
For day today banking operation Oracle FLEXCUBE has integrated with external systems like CIF, Bank
Report, halcom etc.
Based on baking process below two different ways of integration carried out between FLEXCUBE and
external systems.
 Online / Real time integration carried with IIB (IBM Integration Bus) tool.
 Batch scheduling and near real time integration carried with Oracle middleware ODI tool.
Responsibilities  Involved in client discussion during requirement gathering phase.
 Involved with design team and BA to how we can accomplish requirement with ODI solution.
 Preparing ODI low level technical solution design.
 ODI 12C installation and JEE agent configuration.
 Established connection between Oracle and MSSQL server through ODBC.
 Till now worked on topology configuration, creating of transformation like table to table, table to
CSV/Flat/XML file, XML/CSV file to table and CSV file to JMS message.
 JMS Queue Configuration on WebLogic server.
 Preparation of ODI technical guide for team members.

Accenture
Vodafone NewCo, UK
Role Sr. ODI Developer Duration: Aug. 14 – Till Date
Environment Oracle Data Integrator, PL/SQL, Oracle11G etc.
Description Project NewCo is a major strategic project for which the scope is to replace the existent IT stack
with a full Oracle solution stack. Its key strategic goal is to improve customer experience and drive
future business growth whilst reducing operational costs.
 Organization is seeking to transform its Billing and Customer Interaction legacy estate to an Outof-the Box solution utilizing the best of Oracle suite of products. These systems will interact via Fusion
Middleware (FMW), the Oracle integration product to create an abstraction and orchestration layer,
enabling standardization of message structure. The NewCo Program will be structured around eTOM
(Enhanced Telecom Operations Map) processes as defined by the (TM) TeleManagement Forum's.
Responsibilities  Discussion with design/architecture team to understand existent business problem and current
design for resolution then transform it them into ODI solution.
 List of challenges which includes,
 Implementation of run time scenario scheduling.
 Triggering ODI scenario through web service and use of OdiInvokeWebService tool.
 Worked on complex mapping and transformation of table to table, table to CSV/Flat/XML file,
XML/CSV file to table and CSV file to JMS message.
 Worked on WebLogic server for JMS queue creation for JMS messages.
 During integration process got exposure of SOA, WebLogic server.
 Worked on SNP* tables.
 Got involved in preparation of knowledge guide, UT test cases.
 Interaction with ST,SIT,PAT,DR,OAT,Pre-Prod teams for any application issues and clarification.
 Involved with L3 team for all critical production issues.
 Part of ELS team to assist live deployment and post deployment sanity issue.
 Always interaction with client and design team for application related queries and issues

IBM
Vodafone Roaming Services, UK.
Role Package Solution Consultant Duration: Feb. 13 – Aug. 14
Environment Oracle Data Integrator, PL/SQL, Unix
Description The project is an automated solution for data collection and analysis of roaming data.
Stage 1: Once in every month, extracting data from source system (EDW(UK), Atlas (Spain) &
Netherland) to local file storage location.
Stage 2: On 12 working day of month, transformation and validation on local data to global Interface
format and then upload the files in the VRS file storage location.
Stage 3: Once every month, system pick up the data files from the VRS file storage location & then
validate the data. After that upload validated data into VRS Database.
Stage 4: Using the Data stored in the VRS Database generates the roaming reports.
Responsibilities  Preparation of LLD document based on HLD doc.
 ODI application development which includes
1. Topology & data server formation.
2. Model and data store creation.
3. New Project created under that four-different package got created.
4. For transformation new interfaces got created.
 Interaction with ST, SIT, PAT teams for any application related defects.
 Got involved in discussion with client and triage team during any prod. Incident and issues.
 Building SQL queries as per business requirement and deliver to reporting teams