Project Oracle
Resume:
Mukesh Deshmukh
Summary
I have ** years of experience in Information Technology Including 11.5
Years of experience in Oracle application ERP system as a Oracle
application specialist. I have completed 3 Full Life cycle Oracle ERP
implementation and experienced in 4 Oracle ERP support projects. Expertise
in Implementation and support of ERP packages in the functional and
technical areas of Manufacturing (INV,WIP,BOM,Costing), Supply Chain
Management (PO, OM) and Supply Chain Planning (ASCP).
Knowledge particularly for Cummins Inc in Oracle Application ERP
Cummins Inc., a global power leader, is a corporation of complementary
business units that design, manufacture, distribute and service engines and
related technologies, including fuel systems, controls, air handling,
filtration, emission solutions,High Horse Power engine and electrical
power generation systems. Headquartered in Columbus, Indiana (USA), Cummins
serves customers in more than 160 countries through its network of 550
company-owned and independent distributor facilities and more than 5,000
dealer locations.
Education
1) Bachelors in Sciences from Rani Durgavati Jabalpur.
Technical Skills
Languages & Technologies: Oracle Pl/SQL
Software, Tools & Platform: Oracle Configurator, Reports
10g/6i, Forms 10g/6i,
Discoverer 4i, SQL plus, PL/SQL,SQL Loader and
Data Loader, remedy, winscp, Putty.
Testing Tool: Toad, Sql/plus
Databases: Oracle 11g
Operating System: Windows 7
Version Control: Clear Case
Reporting Tools: Oracle Obiee Report,Oracle developer
Achievements and Reorganization
. Received individual delighted customer award at KPIT Cummins (Feb
-2018)
. Received twice group delighted customer award at KPIT Cummins (Feb
-2010)
Professional Experience
06Jan2014 to Till Date KPIT Cummins Infosystems Ltd UK Oracle
Application Specialist
Project I Engine Structure Point-of-Fit Maintenance and Explosion
Client: Cummins Inc. Daventry UK
Description: Cummins EBU (engine business unit) sites
currently still maintain engine structure definition
within legacy IMS mainframe system, and HHP (high-
horsepower) sites such as Daventry and Seymour also rely
on IMS to perform engine structure explosions and build
document printing even though most business processes
are executed in Oracle ERP (enterprise resource
planning) applications.
A major project is underway to move product definition
from IMS mainframe to Wind-chill PLM (product lifecycle
management) applications, but that will not include site-
specific component point-of-fit maintenance or structure
explosion processes. This is because the Cummins
standard was to move those activities into NG-MES (next
generation manufacturing execution system).
However, not every Cummins site will implement NG-MES
due to cost and complexity issues, so the business
requirement exists for an alternative solution for
engine structure (point-of-fit) maintenance and
explosion within Oracle ERP instead.
This new Oracle solution must offer the same or greater
levels of flexibility and efficiency as the existing IMS
MSBM (master summary bill of material) and ABSN
(assembly build sequence number) functionality, with the
MSBM# being the "what" and the ABSN being the "where".
It should also support the Cummins-specific "03
language" item relationship functionality, whereby
associated items are grouped together without the
conventional need for a phantom assembly. However, the
maintenance of these item relationship setups should
remain in IMS and simply be interfaced into Oracle for
use during structure explosion, as the long-term
direction for such maintenance is that it will
eventually move to Windchill PLM applications.
.
Contribution: As a Oracle Application Specialist, responsible for
the following:
. Involved in Directly Working with the client and
taking the Requirement and Design.
. Involvement in Business communication, meetings and
analyse the new opportunity and development.
. Involved into Urgent high priority issue in the Plant
and provide the Solution.
. Design the Custom Forms for ABSN/MSBM mapping,to
reduce the dependency from other legacy system.
. Design and Develop interface from IMS system to
Oracle ERP.
. Design and develop conversion from IMS sytem to Orcle
ERP.
. Setup Oracle Tools like Developer 6i/10g, Oracle
9i/10g, JDeveloper9i/10g, Toad, SQL Optimizer and
other tools.
. Leading the Team, Onsite and Offshore communication.
Environment Windows 7,
26FEB2008 to 05Jan2014 KPIT Cummins Infosystems Ltd USA Oracle Application
Specialist
Project I Seymour Engine Plant
Client: Cummins Inc. USA
Description: Seymour Engine plant is a High Horse Power(HHP)
Engine plant. These Engine include 19L,30L, 96L and
Marine. To maintain the business flow, Seymour Engine
Plant has implemented Oracle ERP system.
During my tenure, I was involved in the
implementation and support of oracle application ERP.
I was involved into Gap Analysis,requirement
gathering,Onsite and offshore connect, user testing
for new process code development,data conversion,
interface, Reports development, provide a status and
progress report to Client and tom management, Onsite
Team Management. During this implementation I
worked on high priority issue and task and provide
the solution to plant, application support during the
Month end Activity/Annual Physical Inventory, Design
and develop new process flow for reviewing code
process and maintain coding standards, Involved into
new business process and map into oracle application
filling the gap by Oracle application customization,
manage successfully full life cycle data discover,Architecting, high level design,testing, deploying
and maintain the Client/user interaction.
Contribution: As a Oracle Application Specialist, responsible for
the following:
. Involved in Directly Working with the client and
taking the Requirement and Design.
. Involvement in Business communication, meetings and
analyse the new opportunity and development.
. Involved into Urgent high priority issue in the Plant
and provide the Solution.
. Participated Oracle Application Support activity like
Month End Activity report,E&O Report, Material's
report and API(Annual Physical Inventory).
. Provide a better solution to enhance the process and
current support activity.
. Worked and managed successfully many Full Life Cycle
of Software & Business Projects involving Requirement
Analysis, User interviews, Data discovery,
Architecting, High level Design, Low level Design,
Presentation Layer, Prototyping, Designing,
Developing, Code Reviews, Testing, Implementing,
Deploying, Documenting, Maintaining and client/user
interaction.
. Developed and customized RICE components like
Reports, Forms, Interfaces, Conversions, Extensions
and workflows as per client requirements.
. Setup Oracle Tools like Developer 6i/10g, Oracle
9i/10g, JDeveloper9i/10g, Toad, SQL Optimizer and
other tools.
. Leading the Team, Onsite and Offshore communication.
Environment Windows 7,
Professional Experience
17-APR-2006 To 25-Feb-2008 KPIT Cummins Infosystems Ltd India
OracleApplication Specialist
Project I Oracle ERP 11.0.3 support
Client: Cummins Inc. Daventry UK
Description: Daventry Engine plant is a High Horse
Power(HHP) plant. Daventry plant purchased from
Herbert Ingersoll established to build the KV engine,designed for construction then start building other
engines too i.e. QSK45,QSk60,QSk78 and QSV81. and
Marine. To maintain the business flow Daventry Engine
Plant has implemented Oracle ERP 11.0.3.
Contribution: I was involved in the support of oracle
application ERP.
I was involved into Gap Analysis,requirement
gathering,Onsite and offshore connect, user testing
for new process code development,data conversion,
interface, Reports development, provide a
status and progress report to Client and top
management, Onsite Team Management. During this
implementation I worked on high priority issue and
task and provide the solution to plant,
application support during the Month end
Activity/Annual Physical Inventory, Design and
develop new process flow for reviewing code process
and maintain coding standards, Involved into new
business process and map into oracle application
filling the gap by Oracle application customization,
manage successfully full life cycle data discover,Architecting, high level design,testing, deploying
and maintain the Client/user interaction.
DEC 2004 - Mar 2006 Sellcraft Softech
Business Analyst
Project I Electricity Board
Client: Gujrat Electricity Board Baroda
Description: Electricity Board). This is the 1st E to E
implementation for Any Electricity Board in India. In
this project I am involved preparing document and
Setup for every instances, development and
customization of Reports, Interfaces, Workflows,
Forms, Concurrent Programs, Flex fields, etc. as per
the following details:
Contribution:
. Project Module Functional Task: setup of project
costing and project contract for every instance,
Preparing the functional and technical document,
Gathering the requirement from the client, Make the
Visio Document according to the GEB Process and
Mapping between GEB Process and Oracle Application.
. Technical Task: involved in development and
customization of Workflow Reports, Interfaces, Forms,
Concurrent Programs, Flex fields, etc. as, MSP to
ORACLE PROJECT: Sending the data from Microsoft
project to oracle project and receiving the data from
oracle project to MSP, Customize Pa budget line form
through the client extension and Attached Descriptive
Flex Field.
. AOL Sysadmin task : Creating standard menu and
submenus, Creating Users in oracle applications with
particular request group, Creating different
responsibilities and assigning responsibilities to
particular user, Adding concurrent program
definitions to particular request group.
Environment: Window Vist/XP
Nov 2003 - Nov 2004 System Plus Pvt . LTD Technical
Consultant
Project I Brazil Tropicana
Client Tropicana
Description I was involved in development and customization of
Reports, Interfaces, Workflows, Forms, Concurrent Programs,
Flex fields, etc. as per the following details
Contribution As a senior team member involved in the following
activities:
. Implemented the Interface for Open Item Interface
from the legacy System to
Apps.
. Implemented the Interface for Receiving Open
Interface from the legacy
System to Apps.
. Customized OM Follow UP Report.
. Customized License Royalty Report based on Order
Type.
. Customized sales Order Report to display sales
orders based on order status wise.
. Customized the Purchase Order Detail Report which
displays the planned Purchase orders.
. Customized Over shipment Report which identifies
service overcharges.
. Customized Order/Invoice summary report which
reviews summary Information's about the orders.
. Customized the Unbooked Orders Report for getting
the full information about the unbooked orders.
. Added Descriptive Flex fields, Query Find Window
in forms.
. Added Triggers in form level, Block level and Item
level.
Environment Windows XP/Vista
Jan 2001 - Oct 2003 System Plus Pvt . LTD Software
Developer
Project I Domestic Client india
Client Domestic Client
Description I was involved in small size of development project.
My responsibility to take the initiative and complete
the project independently.
.
Contribution
. Hospital Management System- In Hospital management
system (HMS) of National Hospital, the hospital
wanted to keep information about their patient's
general information and their medical history. The
HMS is specifically designed for indoor patients
where it keeps a record of all the services rendered
to the patients accordingly bills are raised from
HMS. It provides and charges the patients
accordingly. In addition, the HMS also keeps record
of newly born baby and their registration is done
through HMS only.
. Payroll Management System-This Interface is meant for
providing Employee Details of a Employee along with
information like what allowances s/he is getting. We
can enter employee information of an employee for
further reference This Interface is meant for
entering Pascale Details from which a pay scale is
selected for an employee. This Button is meant for
taking the initiation to ADD new information or data
to a particular Interface. Then using the Save Button
we could save the information for future referencing.
. CD Library Management System-Manual Systems of
maintenance of the records was difficult to manage as
people may forget to make an entry of purchase
orders. Also placing order would take hours.
Especially when the supplier is sitting in another
state and we should have a contact with the supplier
to take the order, giving the latest position of the
orders was very difficult, and company already has
the system Designed in FoxPro but for the sake of
database security & increasing flexibility the
company wanted to design this system.
. Inventory Management System-Website for the client
that deals in sales & services of the products. The
website facilitates online registration of customers
and selling of products to them. It also provides
facility of generation purchase order for products
and spare-parts that falls under the buffer zone,
issuing spare-parts to its service & repair
department. It helps in maintaining the records of
suppliers, its Employees, Transports and generation
of Bills and Challans against sales & purchase
orders, payments received or payment made.
Environment Window 2000, Visual Basic, MS-Acess 2000
Contact this candidate