Resume Dhiraj Chhajer
Dhiraj
Chhajer
Objective
To
acquire a challenging position in IT consulting, where my functional and
technical experience on ERP applications and my analytical skills will add
value to the organization and enrich my knowledge.
Summary
7
years of IT consulting and Oracle Application implementation
experience. This encompasses technical and functional consulting
experience on distribution, sourcing and manufacturing modules of Oracle
Applications.
Experience
of implementation of Oracle Applications E-business suite for large
organization. Completed 4 Full life-cycle implementation on
Supply Chain Planning (PO, Iprocurement, INV, OM, Shipping and
Advanced Pricing) Financials (AR, AP) and Manufacturing (BOM and WIP)
modules. Working experience on Istore and Engineering
module.
Very
strong functional and technical background in Inventory, Order
Management, Purchasing, Iprocurement, Bill of Materials, Shipping,
Advanced Pricing, Quality, Workflow modules and exposure to finance
modules. Excellent knowledge of Backend Architecture of all
modules.
Expertise
in workflow customizations. Good Experience on modification of COGS
workflow, Order Line Transaction workflow modification.
Strong
experience on creating custom solutions & interfaces around
Oracle Applications to suit business needs.
Experience
of working on Oracle Accelerators.
Experience
of working on XML Publisher and customizing documents using
XML Technology.
Experience
of Forms Personalization and OA Framework Personalization
for Web based modules.
Expertise
in designing specifications for Legacy System to Oracle
data conversion/migration process. Experience on working
on designing and developing interfaces for data
conversion. Good Knowledge of Oracle Order Management,
Pricing and Manufacturing API’s and TCA model.
Strong
exposure in developing Technical/Functional design
specifications based on user requirements. Well versed
with gathering user requirements, AIM Methodology, GAP
Analysis, Finalizing implementation methodology, setting
up application, integration testing, and training users.
Working
experience of Istore, Engineering and DBI (Daily
Business Intelligence) module
Implementations.
Strong
exposure of working in varied geographies. First
Oracle implementation was in Finland and Sweden.
Other Oracle Implementations were done in USA.
Well
versed with complete Software Development Life
Cycle (SDLC) starting with user requirements till
hand over to production support.
Ability
to work & deliver in a team. Good Workforce
management and interpersonal
skills.
Assertive,
self motivated, Goal Oriented, Organized &
Efficient.
Good
knowledge of C, C++ and JAVA.
Education
Bachelor
of Engineering with specialization in Computer Engineering from Dharamsinh
Desai Institute of Technology (D.D.I.T), Nadiad, Gujarat, India– Gold
Medalist.
PROFESSIONAL
CERTIFICATIONS
Oracle
Certified Associate (OCA) – March 2006
1Z0-101
– Oracle Exam for PL/SQL Program units August 2006.
1Z0-200
-11i E-Business Suite Essentials for Implementers Certified
October 2006.
Six
Sigma Green belt Certified. Working experience of Six Sigma
methodology.
SKILLS
PROFILE
Operating
System Windows 95/98/XP, Windows NT, UNIX (AIX), Linux
Data
Bases ORACLE 8i
Tools
Oracle Reports, XML Publisher, Oracle Accelerators, Oracle Workflow, SQL
Loader, TOAD, Mathematica, IBM’s speech API, Dataloader, Mercury Loadrunner,
Testdirector
Languages
C, C++, JAVA, Visual C++, PROLOG, SQL, PL/SQL
Professional
Membership
Institution
of Electrical and Electronics Engineers (I.E.E.E)
CAREER
PROFILE
Project:
Oracle Applications 11.5.10 Implementation for NeoPhotonics at Sanjose, CA,
USA.
Period:
November 2006 – Present Date
Apps
Modules: Order Management, Purchasing, Quality, Iprocurement &
Shipping modules.
Description:
This
project is an implementation project for NeoPhotonics, a semiconductor
Industry company in Sanjose. The aim of the project is to rollout Oracle
Applications 11.5.10 and retire the various legacy systems used across the
company. The company had manufacturing and distribution units in China and
USA. The project implementation consisted of implementing Finance,
Distribution, Manufacturing and HR Modules of Oracle Applications.
Role:
Functional Consultant for Supply Chain and Distribution
modules
Team
Size: Five
Responsibilities:
Understanding
the various business process & requirements and the AS-IS scenarios
for NeoPhotonics.
Creating
Functional Specification Documents (FSD’s) based on user requirements
and understanding of the AS-IS scenarios.
Responsible
for implementing OM, PO, Iprocurement, WSH and INV modules for three
operating units. (One operating unit in USA and Two operating unit in
China)
Designing
and Implementing customized Intercompany solution based on 11.5.10
Intercompany Functionality.
Designing
CFD’s (Customer Facing Documents viz. Purchase Order, Packing Slip
and Commercial Invoice) through XML
Publisher.
Managing
Data Conversion Activities (Open Orders, Customers, Suppliers,
ASL)
User
Training and coordinating user testing during CRP2.
Working
on Service Requests with Oracle and effectively resolving
them.
Previous
Assignments
Project:
Oracle Apps 11.5.10 Release for G E Healthcare at Brookfield WI,
USA.
Period:
May 2005 – October 2005
Apps
Modules: Inventory, Order Management, Workflow, Purchasing, Shipping, AP,
AR, Advanced Pricing and Istore modules.
Description:
This
project was an implementation project for DATEX branch of GE Healthcare. It
involved working with a custom module around Oracle Applications which deals
with the Service Side business of GE Healthcare. Service Order Management
(sOM) is a web based application which has been developed as an Order Entry
tool. The orders are then processed through standard Oracle process. This is a
phased release project. The second release went live in February 2006.
Presently working on the third release, this is scheduled for October 2006.
The release would deploy major enhancements which are requested by business.
The oracle modules which have been implemented for DATEX are Inventory, Order
Management, Purchasing, AP, AR and GL modules and customization in COGS and
Order Line Workflows. There is a proposed implementation of Istore Portal for
GE Healthcare services.
Role:
Functional Business Analyst for Services, GE
Healthcare
Responsibilities:
Single
point of Contact for understanding business requirements and mapping them
into functional design documents for Development Team. Coordinating the
development work between development team and testing the requirement
prior to deployment for user testing. Facilitating user testing and
deployment into Production instance
Creating
functional documents for new service requirements which have not been
mapped previously and modifying existing documents for user changes.
Creating
setup documents for OM, Inventory, purchasing and Advanced Pricing
modules for DATEX operating unit and implementing them in test and
production environment.
Working
on user SPRs (Software Problem Request) and TARs with
Oracle.
FEDEX
Interface design – An interface which has been designed
between FEDEX and Oracle, with crossworlds as the middleware
application. This interface triggers the shipping from Oracle,
when the shipment happens from FEDEX.
Custom
repair process Implementation – This process facilitates the
processing of Repairable items which are returned by customers.
This process creates a PO-SO combination for individual repair
parts based on custom setups. This involves customization of
Order Line Workflow.
Expense
Policy and COGS Workflow modification: This involves
customization of Order Line Transaction workflow to expense
out parts which are less than a specific amount. COGS workflow
modification was also a part of Expense policy implementation
for GE Healthcare
Customized
Pick Slip and Pack Slip Report for Services: Design of
Custom Pick Slip and Pack Slip Report for
Services.
Project:
Oracle Apps 11.5.10 Laurel Clinical Systems implementation
for GEHC at Brookfield, Wauwatosa, WI & Laurel, Maryland,
USA
Period:
September 2005- March 2006
Apps
Modules: Order Management, Workflow, Shipping & Purchasing modules.
Description:
The
project is an implementation project for Laurel Clinical Systems situated in
Maryland, an acquisition of GE Healthcare. The aim of this project is to
streamline Laurel’s business processes and integrate it with GEHC. Laurel had
a legacy ERP system called MANMAN. After implementation of this project MANMAN
was retired and Laurel Plant moved to Oracle. The modules implemented were OM,
INV, PO, BOM, WIP, ENG, GL, AP & AR and Oracle Workflow. This project went
live in February 2006, following 1st Quarter close production
support. Customization of Order Line Workflow for specific business scenarios
for the service business of Laurel Clinical Systems was
implemented.
Role:
Techno-Functional
Business Analyst for OTR/Manufacturing Modules.
Responsibilities:
Understanding
the business process of Laurel Manufacturing plant and mapping it to
existing implementation of GEHC Oracle Applications.
Creating
functional design documents and GAP analysis.
Creating
and designing complete legacy open order conversion process which
includes retiring an existing system named MANMAN and moving the open
orders to Oracle and their reconciliation with Finance. This process
was practised with users during CRP1, CRP2, ITEST, and production.
FE
Consignment and Deconsignment Order Line Workflow: Creation of
new order and return line transaction workflow for incorporating
automatic consignment and deconsignment for Field Engineer Orders.
Field Engineers are GE Employees who can order parts and once the
part is shipped to them, the FE is responsible for the part until he
utilizes that part on equipment. Each FE has a specific subinventory
and locator attached to them on customer DFF Setup. If the FE uses
the part, the customer is billed in Siebel. If the FE does not use
the part and wish to return the part, the Return Order Line Workflow
should ensure that the FE’s inventory is relieved of the part. The
entire solution was workflow driven.
Preparing
setup document for Laurel Site and implementing them into Oracle
Applications.
User
awareness for the new process for OTR and Purchasing service
modules.
Preparing
user training documents and operating procedure documents for
the users.
Resolved
issues post go-live by working closely with Production
support and Oracle in resolving TARs.
Project:
Oracle Applications 11.5.9 Maximus Implementation for G. E.
Medical Systems, USA
Period:
July 2004 – May 2005
Apps
Modules:
Inventory, Order Management, Advanced Pricing, Oracle Workflow, Shipping,
Purchasing, Bill of Materials & WIP modules.
Description:
Maximus
was a global integration project, which involved integrating Instrumentarium
($2.3 billion Acquisition) with GEMS. This project was a huge project which
involved the streamlining of business processes across multiple manufacturing
and distribution sites of Instrumentarium across the globe. After completion
of this project, all sites of Instrumentarium were migrated to G E Medical
Systems Oracle Application instance.
Role:
Site Consultant for OTR/Manufacturing Modules.
Responsibilities:
Understanding
the existing business process of Instrumentarium’s Helsinki Site, mapping
it with GEMS business process and identifying gaps as per local business
requirements.
Implementing
Setup documents for Order management, Inventory, Bill of Materials WIP,
shipping and Advanced Pricing modules.
Planning,
design and execution of migration strategy for migrating from Legacy
System to Oracle Applications. 11.5.9
Creation
of custom based scripts, using SQL / PL-SQL, for extraction of
legacy data for OTR and manufacturing modules.
Functional
Validation of Setup and extracts for OTR & Manufacturing
Modules.
User
training and resolving issues with Oracle by raising
TARs.
Prepared
Data Loader scripts to load Stock Locators, Price Lists
Customers etc.
Design
of Custom Pick Slip and Pack Slip Report and commercial
Invoice Report
Project:
Oracle Apps Instrumentarium Implementation for GEHC, USA.
Period:
September 2003 – June 2004
Apps
Modules:
AP,
AR, OM, Oracle Workflow and Project Accounting
modules.
Description:
The GE
Medical Systems - Oracle Instrumentarium is an ERP project, which is on Oracle
Applications 11i. It was an integration project that involves integrating
Instrumentarium with the GEMS instance of Oracle Application.
Role:
Technical Business Analyst for GEHC
Responsibilities:
Working
as an active application developer as a part of the application development
team
The
responsibilities include
Understanding
Oracle Applications, which includes the setups, architecture &
functionality for various modules like GL, AP, AR, WIP, BOM, PO, Inventory
and Planning modules.
Preparing
the setups documents for AP and Inventory module for the various sites
for GEMS-IT.
Repair
Process Implementation: This involved customization of Order Line
workflow to facilitate repair process for service business of
Instrumentarium, where a combination of PO-SO was created for repair
items based on custom setups.
Data
loading for various modules using data loader.
Preparing
the MD060 (High Level Design document) for the AP and AR module
for various sites of GEMS-IT.
Developing
Interfaces between Oracle Project Accounting and Niku (A project
management tool) both Inbound and Outbound.
Understanding
the functional aspects of the modules Inventory, Purchasing
and BOM.
Project:
Defining a new process for generating Inventory Setup Documents in Oracle
Applications 11i, TCS
Period:
November 2003 – February 2004
Apps
Modules:
Inventory
module.
Description:
This
project was done as a part of Six Sigma Green Belt certification. The existing
process for generating setup documents for Inventory Module in Oracle
Applications 11i was ad hoc in nature. There was unnecessary extra effort as
there was no process defined which resulted in inefficient usage of time and
unnecessary effort.
To
overcome these difficulties, a process was needed, which will reduce the
efforts and time consumed in the setup preparation.
Role:
Project lead
Responsibilities:
This
project was done as a part of Six Sigma Green Belt Certification.
Defining
the project which includes the project charter and the milestone and
deliverables
Measuring
the various aspects of the project and getting the Voice of the
Customers, Mapping VoC to CTQ’s.
High
level design, and the functional design aspect of the
project
Detailed
(LLD) design of the project and various analysis of the project
Testing
the project and Project Closure
Project:
National Insurance Company Automation System (NICAS)
Period:
April 2003 – October 2003
Description:
The
National Insurance Company Automation System (NICAS) is an automation system
for the functions of Proposals and Claims Department (P&C) and the
Accounts Department for National Insurance Company. The system had the modules
for addition of new customer, addition of new policies and schemes, updating
of policies and schemes, claim addition on a policy, claim verification, claim
settlement, policy maturity settlement. It also had a supervisor module for
the management to view date wise, monthly and yearly reports on the new
policies added, matured policies and the claimed policies. The project was
made in C using flat files and later it was made in C++.
Role:
Team Member
Responsibilities:
Worked
as an active developer to develop an automation system for National Insurance
Company. The responsibilities included
Getting
the Software Requirement Specifications from the case study.
Preparing
High Level Design and Low Level Design from the SRS.
Coding
for the software.
Preparing
System Test Plan for the software
Testing
and debugging the software and fixing the bugs
found.
Preparing
System Test Plan
Testing
Preparing
the user documentation
Project:
Data Exploration by Sonification at Physical Research Laboratory
Period:
June 2002 to February 2003
Description:
Sonification
is the transformation of data relations into perceived relations in an
acoustic signal. It is looked as an alternative to visual representation of
data. More specifically, it is the use of non-speech audio to convey
information. The aim of the project was to explore whether sound has the
potential to be used in mapping data and interpret data relationships. The
project was done in JAVA, as it had to be platform-independent.
Role:
Team Member
Responsibilities:
Understanding
the requirements of the project, why sound has to be used for data
exploration and what are the alternatives to sound.
Choosing
the language for project implementation.
Understanding
how sound is produced, API usages,
Understanding
the format of MIDI files, how to load MIDI instruments, how to pass
messages to the midi instruments and use them in the
software.
Complete
development of the project.
Preparation
of documents and reports from time to time based on the status
of the project.
Project:
Voice Recognized Command Executioner
Period:
October 2001 – May 2002
Description:
The aim
of the project was to develop software, which could recognize a person’s
voice, interpret it and execute the commands he speaks. The project was
developed in JAVA. The project could recognize a good amount of words
correctly and according to the recognized word the corresponding command would
be executed.
Role:
Team Member
Responsibilities:
Understanding
the requirements of the project and what are the various languages that
can be used for voice recognition.
Understanding
IBM’s Speech API and implementing it in JAVA.
Preparing
the Low Level Design and coding for the software.
Preparation
of documents and reports from time to time based on the status of
the project
Other
Projects
Linux
System Programming (Feb 2000 – October 2001)
In
this project, a module was made i.e. diskfree (df); disk usage (du) commands
were made under Linux Environment. They displayed the various partitions, type
of partitions, and size of partitions, used and free disk space both in no of
KB’s & percentage. These modules were made using Linux system calls and
were a part of advanced Linux programming.
Computer
Networks (July 1999 – Jan 2000)
A
project was developed which would find the shortest path between two nodes of
a computer network based on the traffic and the distance between the two
nodes. The project had a GUI based interface, and any no of nodes could be
given to it as input.
-0()0-
1
posted by Dhiraj at
7:59 PM
|
0 comments
