Project Oracle
Resume:
Bhushan Krishna Shinde
*.* years of experience in Oracle EBS (Oracle Apps) for Enterprise
Resource Planning (ERP)
Development
Oracle Forms, Oracle Reports, PL/SQL, BI Publisher, SQL Loader, Form
personalization, Business Events, Quality Plans
Modules known
Oracle Process Manufacturing (OPM),
Oracle Purchasing (PO),
Distribution (OM, Shipping),
Oracle Payables (AP)
Expertise
. New development and Documentation
. Oracle Apps-Fusion Middleware, ODI Integration, Advanced JMS Queue
. Oracle Apps-Fusion Middleware-Legacy System Integration
. Rollout Projects
. Customization
. Data Migration
. Job scheduling (Appworx)
. BI Publisher
Design, Development, Deployment and Implementation
. Oracle applications(EBS) development and implementation experience
. Good technical and functional knowledge of Oracle Process Manufacturing
and Distribution of Oracle Applications
. Strong product development experience
. Strong experience in Oracle Forms, Oracle Reports and PL/SQL
. Experience with integrating various legacy applications with Oracle Apps
. Strong experience in Onshore and offshore module and good customer facing
experience
. Core competency in all phases of software development life cycle which
includes analysis, design, testing, implementation and documentation
Education
. Bachelor of Engineering in Information Technology (BE IT) from Mumbai
University, India
(June 2003 - June 2007): First Class
. H.S.C. in Science, India (June 2001 - May 2003): 78.00%
. S.S.C. (March 2001): 80.53%
Software skills
Oracle Database (version 11g), Oracle Apps development tools such as
Oracle Forms, Reports, PL/SQL, SQL Loader, BI Publisher, UNIX Shell
Scripting, Form personalization, Business Events
Third Party Tools
TOAD, PVCS, Appworx, Data Load, Legacy Press, WINSCP, PUTTY, Atlas, Clear
Case, SVN, Clarity, Wrike
Operating Systems
Sun Solaris, Linux, Windows 7, Windows XP
Employment Details
. Working as a Senior Oracle Apps Consultant (EBS) for Wizard Innovation
Technologies Sdn Bhd., Malaysia from November 2014 to Till Date (1 month)
. Worked as an Oracle Apps Technical Consultant (EBS) for WIPRO Ltd.,
Mumbai, India from October 2013 to October2014 (12 months)
. Worked as an Oracle Apps Associate Technical Consultant(EBS) for KPIT
Cummins Infosystems, Pune, India from May 2010 to October 2013 (3 years, 6
months)
. Worked as a Software Programmer(EBS) with Parle Products Pvt. Ltd.,
Mumbai, India from March 2008 to March 2010 (2 years)
Professional Experience
Employer Wizard Innovation Technologies Sdn Bhd.
(www.wizardinnovationtech.com)
Designation Senior Oracle Apps Consultant (EBS)
Client Seagate Technology (www.seagate.com), USA, Malaysia
Duration From November 2014 to Till Date (1 month)
My Roles As a senior Oracle EBS consultant, performing following
roles
. Study the existing business and process
. Suggest, design and enhancement in current logic for Oracle
Procure To Pay and Oracle Order to Cash business lifecycles
. Responsible for development, support, maintenance and
implementation of a relatively complex project modules
. Works on problems of complex scope through extensive usage
of standard concepts & principles
. Responsible for coaching, and mentoring junior members in
the team
. Developing and maintaining Oracle Application
Implementation Methodology (AIM) documents (MD.050, MD.070,
BR.100)
. Ensuring high quality standards in the delivery
Employer WIPRO Ltd. (CMM Level 5) (www.wipro.com)
Designation Oracle Apps Technical Consultant
Client Kellogg's India Private Limited
(www.kelloggcompany.co.in), USA, India
Duration From October2013 to October2014 (12 months)
My Roles As a senior technical consultant, performing following
roles
. Study the existing business and process
. Suggest, design and enhancement in current logic
. Fixing existing bugs for the current manufacturing plant
logic
. Implementation of new custom logic in Oracle Process
Manufacturing (OPM)
. Implement and enhance the existing cost allocation process
for arriving item costing specific to manufacturing plants
(OPM)
. ROLLOUT these solutions for a new manufacturing plant
. Responsible for development, support, maintenance and
implementation of a relatively complex project module
. Works on problems of complex scope through extensive usage
of standard concepts & principles
. Responsible for coaching, and mentoring junior members in
the team
. Developing technical specification documents (MD70)
. Ensuring high quality standards in the delivery
Project I Implementation and Rollout of new Manufacturing Plant
(Implementation and Rollout Project)
Client Kellogg's India Private Limited
Duration From October2013 to October2014 (12 months)
Description The Company is currently setting up a new plant in India.
The Company currently uses Oracle E-Business Suite and
other Oracle applications as the ERP for its transaction
processing and operational needs across supply chain and
finance functions. The Company plans to extend the Oracle E-
Business Suite (R12.1.3) functionality to the new plant
operational requirements and map process improvements
arising out of the new plant solution back into Taloja
implementation (existing manufacturing plant in India)
Contribution As a senior member, responsible for the following:
. Involved in design phase of Oracle Process
Manufacturing(OPM) to enhancement in current plant logic
and rollout to new plant
. Replaced existing Lookups for Storing Burden Rates,
Elements into a new Custom Form(Driver Measure Elements)
specific to Plants
. Designed and developed a new custom forms to capture
monthly machine usage hours, packing hours and adhoc usage
hours for manufacturing plats
. Implemented a new logic to make dynamic enabling disabling
of BIB (Bag in a Box) lines and Packing lines in Actual
Machine Usage form, which help factory manager to avoid
wrong entries
. Implemented a new logic for Intermediate food's burden to
be apportioned across specific finished good/SKUs produced
on Monthly Basis
. Personalized a Material Transactions form and modified
existing LOV for LOT number field and added a new built-in
to create a new record group which shows new LOV as
combination of "Plant+Process line+Shift+sysdate" (VAL 2 B
23JAN14) with expiration date of that material as
"sysdate+shelf life days"
. Designed and developed a logic for calculation of
statistical journal based on actual machine usage data &
burden journals based on production data
. Designed and developed a logic to calculate Allocation
percent (OPM Financials)
. Designed and developed a logic to update the Actual cost
with the difference in Standard cost and Actual cost (OPM
Financials) of the final product
. Customized a COGS (cost of goods sold) process to create
accounting report which contains amount by manufacturing
plant wise
. Converted existing reports into excel output format using
BI Publisher(XML)
. Designed and developed a new reports for Production summary
report (OPM Financials), SKU(stock keeping unit) burden
report, SKU component usage report, Burden allocation-
statistical measures report
Environment Oracle Apps R12.1.3, Sun Solaris, Oracle PL/SQL, Workflow
Builder, Oracle Forms, Oracle Reports, BI Publisher
Employer KPIT Cummins Infosystems (CMM Level 5)
(www.kpitcummins.com)
Designation Oracle Apps Technical Consultant
Client Cummins Inc. USA (www.cummins.com), Cummins Turbo
Technology USA, China (www.cummins.com/turbos), Cummins
Emission Solutions, USA, UK, China, Turkey, Australia
(www.cumminsemissionsolutions.com), Cummins Power
Generation USA, UK (http://www.cumminspower.com), Cummins
Europe(http://www.cumminseurope.com)
Duration From May2010 to October2013 (3 years and 6 months)
My Roles As a technical consultant, performed following roles
. Interacting with the onsite co-ordinator for gathering
business requirements
. Developing High Level Design Documents (HLD)
. Developing technical specification documents (MD70)
. Prepare test plans for various types of testing
. Prepare User Guides for various types of scenarios
. Design PL/SQL Objects (table, view, trigger, sequence,
PL/SQL packages)
. Design / modify forms, reports
. Design / modify XML reports
. Job scheduling and monitoring using third party tool
Appworx
. Design reports using BI tool Legacy Press
. Design control files to load legacy system data into oracle
custom tables using SQL Loader
. Design and develop a record and playback files with the
help of third party tool Data Loader to load non oracle
data into oracle
. Create migration document (MD120) to perform migration
related activities and also maintains code versions in
version control tool PVCS
Project I Core Finance BOLT Interface Development Project
(Implementation Project)
Client Cummins Turbo Technology (CTT), USA, UK, China
Duration From October 2012 to October 2013 (12 months)
Description Cummins Inc. uses Oracle Applications in their Financial
Shared Services Organization (CFS) for General Ledger,
Accounts Receivable, and Accounts Payable duties. All
financial reconciliations are performed in this system
across Cummins. As part of the BOLT program, Cummins Inc.
wants to re-implement Finance solution from Oracle apps 11i
to Release 12.1.3 with additional functionality.
The integration between the Entity and BOLT is being done
on Two Pilot Sites and subsequently it would be rolled out
to all other entities. Core 11i and BOLT R12 will be in
existence till all the entities are linked to the BOLT R12
Instance. All the Master Data like COA, Currency Rates and
Customer etc would be maintained in BOLT R12 Instance. As a
part of BOLT Project Journal data from all the sub-ledgers
in the Pilot Entities are to be interfaced to the General
Ledger in BOLT R12 Instance
Contribution As a senior member, responsible for the following:
. Involved in design phase
. Understand the Business requirement for batch or real time
processing and designed the interfaces accordingly
. Developed Technical specifications documents (MD70).
. Prepared test plans for various types of testing.
. Developed customized business event, subscription on seeded
business event
. Used Advanced JMS Queue for Enqueue and Dequeue the xml
payloads
. Customized the PO Approval workflow to raise a custom
business event to make PO transactions activity as real
time processing
. Used SOAP API features to raise a webservices from source
system to Fusion Middleware
. Created and Used Quality Plans instead of forms.
. Mapped the source system columns with Fusion Middleware and
destination system columns.
. Designed and developed Outbound Interfaces for GL Journal,
PO and Receipt.
. Designed and developed Inbound Interface for Payables
Matched Invoice.
. Created Migration document, Setup Instruction documents
. Reviewed the code and checked in version control tool
called Clear Case
. Actively participated in CRPs, Exception & System Down
Testing and UAT
Environment Oracle Apps 11i/R12, Sun Solaris, Oracle PL/SQL, Fusion
Middleware, ODI, Oracle Business Events, Web services,
Workflow Builder, Appworx, Clear case, Quality Plans
Project II EDW Raw Material Inventory Project (Implementation
Project)
Client Cummins Power Generation USA, UK
Duration From April 2012 to October 2012 (6 months)
Description The purpose of this project is to provide a data related
to Inventory, Supplier, Work In Progress and Cost
Management from ERP to the Enterprise Data Warehouse team
through Fusion Middleware for BI tools. The ERP data based
on volume is categorized into High volume (Bulk), Setup,
Incremental data. To achieve this data flow we have
developed a custom object_types, table_types and custom
APIs at ERP side and to send this data to Fusion Middleware
we have used different latest features of Fusion Middleware
which includes Oracle business events, Advanced BPEL Queues
and Web services.
Contribution As a senior member, responsible for the following:
. Analysed the project requirement
. Designed High Level MD.050 design document
. Coordinate with clients to take an approvals
. Prepared a Low Level Design
. Prepared test cases
. Developed logic to create a custom API
. Reviewed codes developed by team members
. Prepared a Technical Solution design documents
. Tested a code on development instance.
. Captured a code in a version control tool called PVCS
. Migrated a code to UAT with the help of DBA.
Environment Oracle Apps 11i, Sun Solaris, Oracle PL/SQL, Fusion
Middleware, ODI, Oracle Business Events, Web services
Project III Turkey Implementation - (Rollout Project)
Client Cummins Emission Solutions, USA, Turkey
Description Cummins Filtration started a Filtration Business Unit in
Turkey. For a new business line of customer we have
migrated existing solutions & implemented new customized
requirements.
Duration From June 2011 to April 2012 (10 months)
Contribution As a Team Member, involved in the following:
. Designed one bolt-on application in Oracle Purchasing to
support Advanced Shipment Notices (ASNs)
. Done forms personalisation in the Purchasing area in
Receiving > Receipts screen, so that the Izmir users cannot
receive against a PO directly, they have to receive against
an ASN only
. Reduced the redundancy of XML reports by creating a single
xml report templates containing multiple languages to
support different operating units
. Used XML Bursting feature to send Sales Order
Acknowledgment report to the customers
. Used data template feature of XML Publisher to generate
desired pdf/excel output by removing existing reports used
as data source
. Designed and developed program for Container LPN Pallet
Barcode Label Printing
. Created/modified and scheduled chains and jobs containing
concurrent programs in job scheduling tool Appworx
. Designed and developed folders and mapped the reports
generated in Appworx into BI tool Legacy Press
Environment Oracle Apps 11i, Sun Solaris, Oracle PL/SQL, Oracle Forms,
Oracle Reports, BI Publisher, Legacy Press, PVCS, Appworx
Project IV CF/CES North America Oracle - (Implementation Project)
Client Cummins Emission Solutions, USA, UK, China, Turkey,
Australia
Description The purpose of this project is to replace legacy system
with Oracle e-business suite to support oracle apps ERP for
Order Management activities.
Duration From December 2010 to June 2011 (6 months)
Contribution As a Team member, responsible for the following:
. Designed and developed 2 Outbound EDIs for price formulae
and technical information
. Designed and developed packages of outbound interfaces for
integrating with Cummins Financial Shared Services system
such as EDI (e-Commerce Gateway)
. Designed and developed a form which enables a user to
define pricing rules and formulae
Environment Oracle Apps 11i, Sun Solaris, Oracle PL/SQL, Oracle Forms,
Oracle Reports, XML Publisher, Legacy Press, PVCS, Appworx
Project V OAI replacement (with MW) Project (Synchronization between
Oracle EBS and Legacy System SOMS using Fusion Middleware)
- (Implementation Project)
Client Cummins Emission Solutions, USA, UK, China, Turkey,
Australia
Description The purpose of this project is to upgrade the existing
code to replace an OAI system and to support new features
of Fusion Middleware
Duration From July 2010 to December 2010 (5 months)
Contribution As a Team member, responsible for the following:
. Mapped legacy system with Oracle EBS table columns and
Oracle EBS with Fusion Middleware Objects
. Replaced the packages written to support OAI (oracle
Application Interconnect) with the new code to support
fusion MW infrastructure, which maintains finished goods
inventory transfer data synchronization between the Oracle
EBS and SOMS(legacy system)
Environment Oracle Apps 11i, Sun Solaris, PVCS, Appworx
Project VI Weekly Forecast Upload Process - (Implementation Project)
Client Cummins Turbo Technology USA, UK, China
Description To support lower volume on some manufacturing locations,
the monthly forecast process is not conducive to business
needs. To simplify the existing scenario we modified the
forecast for 1/month into 1/week using the standard process
(rounding up), generating requirements for 4 per month
which helped business to better mirror actual customer
demand patterns.
Duration From May 2010 to July 2010 (2 months)
Contribution As a Team member, responsible for the following:
. Designed and developed a shell script responsible for
copying the source flat file(forecasting data) from source
to destination folder and from destination to load into
oracle custom staging table using sql loader and then
copying the file from destination to backup folder on unix
server
. Modified the package codes to support weekly forecast logic
Environment Oracle Apps 11i, Sun Solaris, Oracle PL/SQL, Unix Shell
Scripting, PVCS, Appworx
Project VII RLM Cum-Key Year end maintenance activity - (Year
end/Maintenance Project)
Client Cummins Power Generation USA, UK
Description This is a year-end activity for RLM module. The activity
involved disabling the active CUM key set for sales orders
between current year and create new active CUM key for same
sales orders for coming new year and also update the CUM
key start date for open sales orders. This activity was
manual. The scope of the project is to automate the process
as the volume of data started increasing from year by year
and achieve the year end activity for RLM
Duration From December 2010 to January 2010 (1 month)
Contribution As a Team member, responsible for the following:
. Designed and developed a record and playback files with the
help of third party tool Data Loader to load data to RLM
tables.
Environment Oracle Apps 11i, Sun Solaris, Oracle PL/SQL, Data Loader
Employer Parle Products Pvt. Ltd., Mumbai (www.parleproducts.com)
Designation Programmer
Client Parle Products Pvt. Ltd., Parle Biscuits Pvt. Ltd.
Duration From March 2008 to March 2010 (2 years)
Project I NEW DMS (Depot Management System) - (Implementation
Project)
Client Parle Products Pvt. Ltd., Parle Biscuits Pvt. Ltd.,
India
Description DMS is Depot Mgt. System which is used all over India
around 70 places like Manufacturing Units, Depots, and
Millers etc. This was previously in other legacy system
which was used to collect input data from users, arrange
data and put that data in data warehousing for further
analysis. This was having lots of drawbacks and limitations
like de-centralization, less secure, time consuming
transfer and processing of data etc. All these limitations
were overcome by developed New DMS, which has user friendly
front-end application using forms (D2K), which accepts
valid user inputs & store that into Oracle 10g database,
and generate reports for analysis and queries made
available for users to help them out in day-to-day
operations.
Duration From March 2009 to March 2010 (12 months)
Environment Oracle Application Developer, Oracle PL/SQL, Oracle Forms,
Oracle Reports
Project II Material Management and Finished Goods Valuation System -
(Implementation Project)
Client Parle Products Pvt. Ltd., Parle Biscuits Pvt. Ltd.,
India
Description Finished Goods Valuation System is a new project which is
the part of main MT System (Material Management System)
developed for Traceability & Audit Purposes.
Traceability: Trace the finished goods by its sales depot,
mfg. Unit and raw materials by its closing stocks.
Audit: Trace the finished goods & generate reports for
higher Authority at the end of each month.
Duration From March 2008 to March 2009 (12 months)
Environment Oracle Application Developer, Oracle PL/SQL, Oracle Forms,
Oracle Reports
Personal Profile
Date of Birth : 14 July 1985
Marital Status : Married
Passport Details : Passport Number: F7432965
Current Work Location : Malaysia
Permanent Address : Mumbai, Maharashtra, India
Contact Number : +60-112*******
Email Address : **************@*****.***
LinkedIn URL : in.linkedin.com/pub/bhushan-
shinde/55/8a3/a50/
Contact this candidate