Vivek Gupta

Oracle Applications E-mail: actdr3@r.postjobfree.com

OPM & SCM Functional Consultant. Mobile: +91-956*******.

Executive Summary

* ***** ** ****** **** functional consultant specialized in OPM with a wide business knowledge in the field of Pharma, Chemical & Paper Industries.

14+ Years of Domain Experience in Manufacturing & Projects.

Key Skills

ERP Modules : Oracle Applications R12.1.3 & R12.1.1(Process Manufacturing)

(OPM Specialist) INV, NPD, Process Execution, Process Quality & OPM Financials (Costing & SLA), Purchasing & Order Management with India Localization.

Oracle Applications R11.5.10 (Process Manufacturing)

OPM INV, New Product Development, Process Execution, Process Quality & MRP.

Discrete Inventory, Purchasing (PO) & Order Management.

Simple SQL coding for querying data.

Data migration using Data loader.

Educational Qualification

MBA in Operations Management from IGNOU, New Delhi. 2000

PGDM in Operations Management from IGNOU, New Delhi. 1999

B.E. (Mechanical) from REC Rourkela. 1993

Work Experience (IT)

Solution Architect at Magna Infotech Ltd, working for Wipro Infotech Ltd supporting Ballarpur Industries Ltd, Gurgaon, Since Mar-14 to till Date.

Advisory Architect at Arihant Adroit infosystems, Pune for ERP Implementation at

Aarav Fragrance & Flavours Pvt Ltd, Thane Mumbai, Since July 2013-Jan14.

Functional consultant for OPM Modules In Riyadh Pharma Ltd, Riyadh, Saudi Arabia.

Since Mar 08- Jan 13.

Work Experience (Non -IT)

Manager (Projects) in Reliance Infocom Ltd, Delhi from Dec 2000 to Feb-2008.

Senior Engineer in Electrolux Kelvinator Ltd, Shahjahanpur from Aug 1998 to Nov 2000.

Senior Engineer in SIEL Aircon Ltd, Silvassa & Faridabad from Apr 1994 to Jul 1998.

Maintenance Engineer in Prakash Picture Tube Ltd. Kashipur from Sept 1993 to Apr 1994.

Experience Summary : Oracle Application Implementation, Support & Upgrade Projects.

A. Solution Architect For Ballarpur Industries Ltd,BILT,Gurgaon since Mar 2014.

Ballarpur Industries Limited (BILT) is part of the USD 3B Avantha Group and is the undisputed leader of the paper industry. It is Asia's largest manufacturer and exporter of paper, with a strong presence in all segments of the usage spectrum, including writing, printing, industrial and specialty papers. BILT has a diversified production infrastructure with six manufacturing units spread across India and one in Malaysia.

Project Title 1 : Support & Enhancement Project. (R12.1.1)

Client : Ballarpur Industries Limited (BILT), Gurgaon.

Company : Magna Infotech Ltd. (Working For WIPRO Infotech Ltd.)

Role : Solution Architect.

Modules : OPM Costing, Inventory, NPD, Process Execution & Process Quality &

Order Management.

Duration : Mar 2014 to till date .

Providing support & solution to Business as per Wipro policy. It Includes

- Paper Business.( SCM Modules)

- Web Portal Based P3 Business.(Internally Developed Customized Solution.( O2C Cycle)

- End to End Support for Manufacturing Business. ( All OPM Modules ) for Plants.

a) Ballarpur Unit.

b) Shree Gopal Unit.

c) Bhigwan Unit.

d) Sewa Unit.

e) Asthi Unit.

f) Kamlapuram Unit.

g) SFI Malaysia.

Supporting Period end closing for P3,OSSB & MFG Organizations.

Updating SLA configurations as per Business requirements at various units.

Reconciliation of Inventory, Sub Ledger & GL .

a) Inventory to GL.

b) Inventory to Subledger.

c) Subledger to GL.

Resolving the issues arising with help from Oracle Support Service through SRs.

B. Advisory Architect For Aarav Fragrance & Flavour Pvt Ltd, Since Jul-2013 to Jan-2014.

Aarav Fragrance & Flavour Pvt ltd is a leading Chemical company manufacturing Fragrance & Flavours.

The Project involves Customization in production modules to maintain secrecy of formulations of the client.

Project Title 2 : End to End Implementation . (R12.1.3)

Client : Aarav Fragrance & Flavour Pvt Ltd, Thane.

Company : Arihant Adroit Infosystems,Pune.

Role : Advisory Architect.

Modules : Inventory, NPD, Process Execution, Production Supervisor, Process Quality.

Duration : Jul 2013-Jan2014.

Mapping of the Business Process to Oracle Applications.

Documentations included RD020 (As-Is), BR030 (To Be), BR100 (Application Setup) & MD050 (Functional design Document) & TE040 (Test scripts)

Creating and Testing of setup in test & production Instance which includes MOAC Setup.

Data Validation and Migration in NPD, INV Module.

Simulation of the configured process to a larger audience by conducting CRPs.

Resolving the issues arising during the course of the implementation with help from Oracle Support Service through SRs.

Preparation of UAT scripts, user manual and giving end user training.

ERP System Customization Involvement in Project:

a) Integration of Oracle EBS to Vanwyk Material dispensing System.

b) Integration of Oracle EBS to E perfumery & E Flavour System.

c) Synchronizing ERP to Digital weighing M/c.

d) Maintaining Secrecy at Various ERP Forms in Production modules.

(i). Assigning Batch to a Particular Operator.

(ii). Hiding Key Ingredients during Processes.

Special Functionality Used in Project:

a) Making Production batch against Sales Order's and sending Notification to the CSR.

b) Consumption of the Ingredients from the default locator Only.

C. Functional consultant in Riyadh Pharma Ltd, Riyadh, Saudi Arabia, since Mar 2008-Jan2013.

Riyadh Pharma is a Pharmaceutical mfg company called Medical & Cosmetics Products Company based out of Riyadh, Saudi Arabia. The medical Products are being manufactured and distributed in & around Saudi Arabia Middle East and Africa.

Projects

Project Title 3 : Functionality Testing. (R12.1.2)

Company : Riyadh Pharma Limited, Saudi Arabia.

Role : Functional consultant.(SME)

Modules : Inventory, NPD, Process Execution & MES for process Manufacturing.

Duration : Jan 2010-Mar 2011.

Mapping of the Business Process to Oracle Applications.

Based upon the Business requirement, configuring the Test Instance for Manufacturing Modules.

Creation and Testing of setup in Manufacturing modules in R 12.1.2.

Data Validation and Migration.

Preparing Test scenario’s and testing in INV, NPD, PE & MES.

Project Title 4 : ERP Implementation of Manufacturing Modules.( R11.5.10)

Company : Riyadh Pharma Limited, Saudi Arabia.

Role : Functional consultant.

Modules : OPM Inventory, NPD, Process Execution.

Duration : Mar 2008-July2009.

Completed AS-IS, To-Be, Gap Analysis, Mapping testing & acceptance and Prepared AIM Deliverables included RD020 (Current Business Baseline), RD050 (Business Requirements), BR030 (Business Mapping), BR100 (Application Setup) for NPD, Process Execution Modules & MRP on R 11.5.10.

Interaction with management for issues pertaining to Oracle Applications conformance to their regulatory sensitive environment (GMP).

Gaps identification and suggested work around and customization.

Creating and Testing of setup in Manufacturing modules in R 11.5.10 in test & production Instance.

Data Validation and Migration in NPD, OPM INV Module.

Simulation of the configured process to a larger audience by conducting CRPs.

Documentation of the Observation made during the session for future analysis.

Resolving the issues arising during the course of the implementation with help from Oracle Support Service through SRs.

Preparation of UAT scripts, user manual and giving end user training.

Prepared Test scenario and testing in OPM INV, NPD, PE & MRP.

Development of reports.

Project Title 5: Post Implementation Support ( R11.5.10)

Company : Riyadh Pharma Limited, Saudi Arabia.

Role : Functional consultant.

Modules : OPM Inventory, NPD, Process Execution, Process quality & Cost Management

Purchasing.

Duration : Mar 2008-Jan2013.

Handling issues related to production support.

Simulation of the configured process to a larger audience by conducting CRPs.

Prepared Test scenario and testing in OPM INV, NPD, PE & MRP.

Developments of report documents according to user requirements. Interactions with Technical consultants for Reports requirements

Preparation of UAT scripts, user manual and giving end user training.

ERP System Work around Customization Projects:

a) Dispensing & Issuance form.

b) Synchronizing ERP to Digital weighing M/c.

c) Batch Material Reconciliation form.

d) Making compulsory to consume the ingredients before yielding the products.

e) Conditional approval-customization.

f) Rebooking of ingredients.

Personal Details

Date of Birth 21.03.1971

Passport Status Valid till 2022.

VIVEK GUPTA

DATE: 11.12.2015

Contact this candidate