Sign in

Oracle Apps consultant with ODI & SOA

Cincinnati, Ohio, United States
October 18, 2016

Contact this candidate


Nirav M Dhameliya

* *****’ experience with ability to blend into fast paced environments and work

independently as well as in a team environment. Passion to quickly learn any new system and technology and become productive within no time.


Cincinnati, Ohio




• Oracle Cloud & EBS techno-functional with expertise in Manufacturing Modules (Inventory, Order Management, Purchasing, Engineering, BOM, WIP, MSCA, Depot Repair, Field Service), financial modules (GL, FA).

• Providing Solutions, leading, managing and client reporting in mid to large projects for Oracle Implementations, support, rollouts and Oracle support central for Severity issue.

• Experienced in ODI (Oracle Data Integrator) ETL tool for development of Legacy (Microsoft Database) to Oracle apps with INV, PO, AP & GL.

• Worked on design, testing, performance maintenance, tuning, troubleshoot of ODI ETL interface and lead offshore ODI developer.

• Experienced to calling Oracle apps API through SOA suite and lead

& helped SOA team to develop complex BPEL logic.

• Customization experience in MSCA (Mobile Supply Chain Application) using JDeveloper to meet business requirement for Inventory Transactions.

• Excellent knowledge of AOL (Application Object Library), System Administration Modules, Alert and Desktop Integration (Web ADI).

• Support project Experience with end users in triage and resolution by handling incident tickets, root cause analysis to recommend process and/or configuration improvements.

• Expertise in legacy Inbound/outbound conversion through Oracle standard interfaces & APIs using custom package.

• Proficient in development of RICEW (Reports, Interfaces, Conversions, Extensions, Workflow Builder) components in the area of technical design, development, Integration testing and deployment on industry best practices.

• Expertise in Application Development Tools like Oracle Forms, Forms personalization, PLSQL, Java Store Procedure, Personalization, XML Publisher, ADI, Discoverer, OBIEE, SQL*Loader

& Shell scripting.

• Substantial development experience in creating Stored Procedures, Packages, Triggers, Functions, Indexes and Views.

• Good knowledge of tools like HPPPM, Quality Control CVS, SVN, Kintana, Ticket Handling tool, Lotus Note.

• Proficient in SQL, PLSQL & Report Performance Tuning using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.

• Knowledge & understanding of web technologies and Java, JDeveloper, XML, HTML, CSS, JSP, Oracle SOA and programming language C & C++.

• Nirma Institute of Technology, Gujarat

University, India

Master of Computer Application (Aug-

2005 to May-2008)

• Sikkim Manipal University, India

B.Sc. with Information Technologies (Aug-

2000 to Jan-2005)

• Bhavnagar University, India

B.Sc with Mathematics (May-2000 to



• Oracle SOA Suite 12c Certified Impleme-

ntation Specialist (License OC1640397)

• IGATE: Pat on Back Award for Technical

excellence in providing innovative solution

to the Customer for the most complex and

critical problem of resolution of

performance of General Ledger Interface

• IGATE: Pat on Back Award for

appreciation for excellence in taking

complete ownership & providing valuable

support during functional system testing

phase of the project

• Achieved Third position in the event

Relay Runners of Innovation ’06 – National

Level Technical Symposium jointly

organized by Infocrats, C Dibers, ACES and

AMS held at Institute of Technology,

Nirma University.

• Achieved Third position in Mathematical

Quiz competition conducted by the

Department of Physical Education,

Bhavnagar University, Bhavnagar

Types of Project

Support & Enhancement





Employment History


Capgemini (IGATE Technologies)

April 2012 – PRESENT

• Helped business to find 3.4 billion GL different, it’s root cause and permanent solution with zero


• Client recognition for GE Predix smart shop work scope project effort and innovative idea to automate the upload process which reduced many man hours.

• GL ODI interface performance tuning with 10x

improvement vs the 1k per hours.

• Client appreciation for awesome work during go live, to stayed with all the way through, persistent and tenacious, conscientious and always there to do

whatever it takes.

• Helped business to find root cause of annoying price interface issue and reduce end users work load.

• Self-learn Oracle ETL tool (ODI) and SOA, help to meet project deadline.

• Lead SOA team and Provided Query & API Mapping

to SOA team in very short time


December 2010 – April 2012

• Design complex BI publisher reports which had

dynamic layout with barcode font, to speed up

development time of 50 oracle report and trained


• Played a key role in setting of different barcode with Java classes for the encoding of barcode.

• Arranged IDHASOFT internal Oracle Apps Technical training for the trainees

Zensar Technologies

January 2008 - December 2010

• Performed a tuning of shipping report with 10 sec vs 6 min and helped business save cost of new server


• Self-learn Oracle MSCA architecture &

customization, given training to Seniors & project Managers.

• Helped team to find root cause of long running

Discover report and fixed it with few seconds.

• Designed innovative solution to decrypt Triple DES algorithm encrypted credit card in oracle database using Java store procedure.

• Proven technical expertise in Oracle Applications, ODI & SOA and designing the solution for complex business requirements.

• Understand customer has plans / commitments based on our delivery timelines and act accordingly.

• Strong programming, debugging, implementation,

problem solving and analytical skills.

• Provide innovative solutions to complex business problems.

• Ability to learn new programming languages quickly.

• Enjoys solving hard and difficult problems quickly.

• Efficient in time management, multitask and able to commit to daily deliverable.

• Ability to provide end user training and mentor to less experienced colleagues.

Employment Client & Project

IGATE GE Oil & Gas - AL Pascal Integration Phase 2 GE Aero-DP – Testing for GE Power & Water

GE Oil & Gas – Unified Quoting, Subsea

Business Brazil

GE Oil & Gas - AL Pascal Integration

GE Power & water with AMPS Integration


Paradigm (PDGM)

LKT Industrial Berhad

Technical traning for new trainees

Belkin International

ZENSAR Logitech Inc



Role Played

Oracle Apps Technical Specialist

Cut Over Manager

Configuration Manager

Project Lead

Deputy Consultant

Technical Trainer

Senior Software Engineer

Contact this candidate