Management Oracle

Nagari Sahu

**** ******* *****,

Coraopolis, PA - 15108,

Cell: +1-843-***-****

Email : ***********@*****.***

OVERVIEW

. Around 18 years of experience in the industry that includes 13

years in the Information Technology field in Oracle Applications

11.0.3/ 11i/ R12 with multiple end-to-end successfull life cycle

implementations in both Oracle Discrete-Process Manufacturing

(OPM)/Distribution area and over 5 years of domain experience in

the areas of Manufacturing, Supply Chain Management, Process

Redesign and Project management.

. Expertise in business process integrations with different modules

of both the Oracle Discrete/Process Manufacturing and

Distribution suite viz, Inventory, Order Management, Shipping,

advanced pricing, WMS, Release Management, Purchasing, iSupplier

Portal, Bills of Material, Engineering, Work in Process, Costing,

OPM Suite (Oracle Process Manufacturing).

. Implemented Oracle EBusiness Suites for clients like GE

Healthcare, Regal Beloit, Cummins Inc, Fujitsu America Inc,

Lifecell, JM Smucker, SABIC (Formerly GE Advanced Materials),

AstraZeneca Pharma, Aurobindo Pharma, Pepsi Co Intl (Study),

Charter Steel, Macsteel USA,US Steel.

. Understanding of all phases of ERP implementation such as

business process study, business requirement gathering,gap

analysis with respect to the To-Be solution design, development

and testing, transition, cut over, Go-Live, post production

support and post implementation audit.

. Experience working with the Onsite/ Offshore delivery model,

client relationship management, and project management.

SKILL SETS

. OPERATING SYSTEMS: Windows 95/ 98/ 2000/ NT

. ERPs: Oracle Applications 11.5.10.2/ R12

. Oracle Discrete Manufacturing Suite: (INV, OM, PUR, Advanced

Pricing, Shipping, RLM, iSupplier Portal, iProcurement, WIP, BOM,

ENG,MRP, Costing, ASCP)

. Oracle Process Manufacturing Suite: (OPM PD, OPM PE, OPM Process

Planning, OPM Quality, MAC/SLA, OPM Costing)

. LANGUAGE/ TECH: PL/SQL

. DATABASES: Oracle 9i/10g/11g

. TOOLS: TOAD, SQL Developer,HPQC, Share Point

EXPERIENCE

US Steel, Pittsburgh, PA

Mar 2013 - Till Date

Role: Solution Architect

. Part of the Accenture R12 Project team responsible for helping

the client in solution designing the future road map for the

implementation in the Tubular business.

Trouble shoot technical issues and problems, monitor progress against

plan, and communicate status to the PMO.

Gathering customer requirements, issues, writing and interpreting

functional design documents for Oracle add-ons and extensions and working

with technical developers, DBAs, and Oracle Support to meet these

requirements and resolve issues.

Established/Updated new standard cost for the Product items by defining

its formula, Routing, Recipe and generated the item cost by standard cost

roll up process.

Responsible for the OPM Costing and SLA modules set up and transaction

testing analysis for batch accounting.

. Provide support in the month end period closing by resolving

errors in the Lot cost process and accounting preprocessor.

. Designed a customization to generate the correct accounting entry

in SLA using the custom source capability.

LifeCell (A KCI Company), Branchburg, NJ

Jan 2012 - Mar 2013

Role: Solution Architect

. Part of the IBM R12 Project team responsible for designing

complex customizations in the manufacturing track adhering to the

FDA CFR 21 Part 11 norms in GMP validated enviornment, remapping

the existing customizations, Complete end to end full cycle

testing using all the custom objects in the MES enviorment.

. Configuration of Order Management and Shipping by setting up

Transaction types, order line workflow setup, processing

constraints, Holds, setting up pick rule, Pick grouping rule,

release sequence rule, document categories, document sequences,

document set, defaulting rules based on the customers, setup

price list, modifier and qualifiers, shipping parameters, ship

confirm rules, custom packing slip, bill of lading report, custom

commercial invoice report.

. Configured IR-ISO set up for inter org transfrer/Inter Comanty

transfer to transfer the Finshed Goods to Canadian business

entity.

. Configuration of inventory module by setting up operating unit,

inventory orgs, Organization Parameters, sub inventory, Flex

fields, Profile options, Catalogs, categories, UOM, Attribute

controls, Item type and Item Templates for different kind of

items, stock locators and cross-reference of items, Item Cycle

Count.

. Resolved the transactions stucked in the AR invoice interface.

. Defined cost sub elements, Bills of materials, Routing and

Established item standard cost by standard cost roll up

process.Analyzed the item cost history and variance

analysis.Maitaining the item cost by using the cost update and

cost mass edit functionality.

. Data Conversion Strategy for Manufacturing, Order Management and

Quality track which includes Formula, Routings, Operations,

Activities, Quality Tests, Quality Specifications, MES- Process

Instructions and Open sales orders.

J M Smucker, Orrville, OH

Jun 2011 - Dec 2011

Role: Manufacturing-Costing Lead

. Part of the OPM upgrade team from 11i to R12 responsible for

remapping the existing customizations, redesigning the affected

business processes to utilise the new R12 features, data

validation and MAC to SLA migration.

Macsteel USA

Mar 2011 - Jun 2011

Role: Manufacturing Lead

. Being Part of the manufactured team implemented Oracle suite

12.1.2 (Rel 12) for multiple locations for the Macsteel service

centre in the southwest region.

. Stream lined the lot cost process errors, variance analysis and

implemented the NCM process as a part of quality for material

rejection and claim processing .

. Mostly responsible for the OPM Costing and SLA modules set up and

transaction analysis.

. Provided post golive onsite production support, helpdesk ticket

resolution and month end period closing support for the business

users.

. Implemented ASCP in decentralized environment with centralized

multi-org planning using forecast spread functionality with

inline forecast consumption. ASCP was fined tuned with proper

time fences, safety stock, planned order quanties using fixed

lots, lot multiplier, fixed days supply etc. Planning detailed

reports were modified, created custom reports for inventory

projections.

Fujitsu America Inc.

July 2008 - Jan 2010

Senior Oracle SCM Consultant

Charter Steel, Saukville, WI

Nov 2010 - Dec 2010

. Part of the 12.0.6 to 12.1.3 upgradation team for testing the

business cycles and implementing the new functionalities.

. Implemented the OPM sequence dependent set ups, batchable

resource functionality for ASCP.

. Established new standard cost for the ingredient items and

generated the finished goods item cost by standard cost roll up

for year 2011.

. Used the lot genealogy functionality to have a complete

tractability of the item parent lot from receiving till shipping

in the value chain

. Defined test specifications, test methods, sampling plans,

quality system parameters, sample tracking, analysis and

generate certificate of analysis.

. Written the functional specification document for the OPM-MES

integration.

Regal Beloit Corporation, Grafton, WI

Jun 2010 - Nov 2010

. Functional Consultant for data conversion and custom components

development for the manufacturing track.

. Handled item conversion which was more complex due to decaded old

data in the Manman legacy system and so many business rules for

data extraction.Component pick list report and custom pegging

solution designing for parent and sub assembly Jobs.

. Defined BOM and WIP parameters and WIP account classes.

. Conducted user traing and CRP session for the BOM and WIP

modules.

Fujitsu America Inc, Richardson, TX

Mar 2009 - Jun 2010

. The project involves the implementation of Oracle eBusiness Suite

integrating with other applications like BaaN, Baxter, Road warrior.

. Functional lead for the distribution track, worked on the complete

solution design, system integration for the Repair and Managed

Service Business.

. Have completely automated the process of service request creation to

service request closure spanning transactions like Service Request

to Repair Order, Part requirement Fulfillment by IR/ISO creation

with back to back order creation.

. Configured Min Max planning for MRO items.

Oracle Applications, Oracle CRM: Release 11.5.10.2 (OM, INV, PO)

Edgepark Surgical Inc., Twinsburg, OH

Sep 2009 - Mar 2009

. Functional Lead for the Order-to-Cash track.

. Worked on the project that included the implementation of Siebel

as the front-end order taking system, Oracle eBusiness Suite in

the back-end to process the orders/ invoice, and PKMS (Manhattan

Associates) as the Warehouse Management system for handling the

inventory and shipping transactions; the biggest challenge was to

tightly integrate all the three systems and establish a seamless

flow of data within these three systems.

. Configuration of Order Management (BR100) and Shipping by setting

up Transaction type, workflow setup, processing constraints,

Holds, setting up pick release rule, grouping rule, release

sequence rule, document categories, document sequences, document

set, defaulting rules based on the customers, ATP Rule, setup

price list, pricing formula, modifier and qualifiers, shipping

parameters, ship confirm rules, custom packing slip, bill of

lading report, custom commercial invoice report, setting up

different printers for different document printing.

. Worked on the complete solution design, system integration of

Siebel, Oracle Applications, and PKMS (Manhattan Associates) with

SOA as the middleware.

. Created the KIT items using the Oracle PTO item and PTO BOM

feature.

Oracle Applications 12R (OTC), PKMS, Siebel

TTI Hoover, EL Paso, TX

Jul 2008 - Sep 2009

. Worked on the solution design for the schedule to build process

and the Out Side Processing (OSP) operation using isupplier

portal.

. Defined the WIP Parameter and accounting classes.

. Demonstrated the entire OSP operations using the isupplier

portal, the WIP job creation, move transaction, scrap and job

closure process.

. Defined BOM, Routing, and Resources for item cost roll up and

lead time roll up.

. Supplier Self Registration (Profile and Address), Purchase Order

Collaboration.

. Manage Order Changes, Streamline Payment with Online Invoicing,

using iSuplier Portal.

. Access to Data across buyer-managed organization, ASN/ASBN to

create shipment notification and invoices.

Modules Implemented : Oracle Applications: 11.5.10.2 (WIP, BOM, iSupplier)

KPIT Cummins Infosystems Ltd.

Senior SCM Consultant

April 2005 - June 2008

PepsiCo International, Jordan

Oracle Financials Upgrade to 11i and Implementation of OPM

. Onsite/ Offshore Project Manager

. Managed a cross functional team of five members that encompassed

Functional and Technical Resources for the Client Implementation

project

. Prepared the project plan and high-level process maps integrating

multiple business processes and systems for the toll gate reviews

to effectively communicate the project status upward to the

client, stakeholders, and management team

. Configured the quality module for the inbound logistics (PO

Inspection) and work in process production sampling process

. Used the lot genealogy functionality to have a complete

tractability of the item lot from receiving till shipping in the

value chain

. Defined test specifications, test methods, sampling plans,

quality system parameters, enabled quality wok flows, detailed

sample tracking, analysis and generate certificate of analysis

and certificate of compliance

. Conducted the stability study plan for the various raw materials

of different potency in different environmental condition.

Oracle Applications 11.5.9 (OPM, Costing, MFG, OTC)

Cummins Industrial Center, Seymour, IN/ Cummins Turbo Technology,

Charleston, SC

. Onsite Order-to-Cash Functional Lead

. Worked on the project that included the implementation of the

Oracle eBusiness Suite, Manufacturing, and Financial modules at

Cummins, one of the major plants for high horsepower diesel

engines and supported Oracle Applications for Cummins Turbo

Technology Business Unit

. Set up Order Management, Shipping, and Release Management modules

that included defining transaction types, system parameters,

processing constraint, defaulting rule, shipping parameters, and

release rules

. Defined RLM processing rules, crated/ assign CUM Keys, resolved

RLM exception messages, and defined trading partner.

. Set up supplier scheduling Bucket patterns, Scheduling Options

and Supplier CUM management

. Supported the integration between apps and Clear Orbit WMS

. Customized the cost of goods sold account generator to generate

the correct cogs account.

. Conducted the requirement analysis and business process mapping

study of the critical business processes to identify the gaps and

conceptualized the solution design process for the Order-to-Cash

process

. Streamlined the flow of consigned Inventory using the standard

Oracle Consignment Inventory Management feature as a part of the

process improvement

. Prepared the functional specifications for the customizations,

interfaces, and new requirements and helped the Offshore team in

the development process.

Oracle Applications 11.5.10.2 (eBS, Financials, MFG, OTC, RLM,

INV)

BearingPoint, Onninen, Oslo, Norway / Tata Auto Plastics

Onsite Production Support

. Onsite Support Coordinator

. Provided onsite production support for the faster resolution of

application issues and helped the users to use the application

smoothly and derive the maximum benefit

. Resolved tickets in the modules such as Order Management,

Purchasing, Inventory, BOM, Costing, and Work in Process

. Implemented the Engineering module for managing the engineering

change orders for the client

. Reduced the number of issues by almost 50% for the client by

following the process of Root Cause Corrective Action (RCCA) so

that the same problem was not repeated again and again, thus

significantly reducing the number of issues

. Prepared the functional specifications for the new requirements

and helped the GDC team in the development process till testing.

Oracle Applications 11.5.10.2 (Financials, MFG, OM, PO, INV, BOM, Costing,

WIP)

Fritolay Turkey, SMLC Lebanon (A PepsiCo JV)

Post Implementation ERP Auditing

. Onsite Auditor

. Evaluated operational efficiency and effectiveness in terms of

all relevant and usable features available in the ERP that were

being used properly avoiding duplication, repetitive data entry,

and non-value adding processes under Oracle Applications

environment

. Ensured that the financial, operations, and compliance risks were

adequately controlled, particularly for the areas that had direct

impact on financial records

. Evaluated effective configuration of Oracle ERP and assessed data

integrity, reliability, and consistency

. Ensured that proper access controls and segregation of duties

were in place under Oracle Applications environment

. Identified areas where improvements in current practices could be

done by benchmarking with good practices.

Oracle Applications 11.5.9

GENPACT (Formerly GECIS Software)

April 2003 - March 2005

Oracle SCM Consultant

. Worked for the Oracle Center of Excellence under the umbrella of

GE Capital International Services (GECIS) that mainly involved in

the implementation and support of eBusiness Suite Applications

for various GE Businesses

GE Plastics, Malaysia/ GE Plastics, Singapore/ GE Plastics, India/GE

Plastics Japan

Implementation of Oracle Applications at GE Plastics (OPM)

. Onsite/ Offshore Lead Consultant

. Led a team of 10 members that encompassed Oracle Functional and

Technical Resources to execute the deliverables from the offshore

. Define ASCP planning option, Sourcing Rules/BOD, Establish ODS

and PDS Link.

. Completed ASCP specific set ups in OPM like Resources, Forecast

and MPS Schedule Parameter.

. Multi org planning, setting up the data collection process.

. Defined formulas, recipes, planning schedule and forecast, and

OPM company fiscal policy.

Oracle Applications 11.5.9 (OPM, Financials, QM, PP, Process Execution)

Satyam Computer Services Ltd.

September 2000 - April 2003

Senior Associate

AstraZeneca Pharma India Ltd./ Aurobindo Pharma Ltd.

Implementation of Oracle Applications (OPM)

. Onsite Team Member

. Carried out the requirement analysis and business process mapping

study for the critical business processes to identify the gaps on

the OPM modules

. Conducted comprehensive on-hand product training on the OPM

modules to the project core team members

. Provided workarounds/ customizations requirements for the

identified gaps

. Documented the SOPs, set-ups, gap analysis, and As-Is and To-Be

process flow documents

. Carried out application setup for the OPM modules such as formula

management, quality management, process execution, mac and cost

management.

. Define cost overhead and run the actual cost process to establish

the cost, generated test subledger report.

. Worked on extensive unit and integration testing on the above

modules

. Provided post production support during the after Go-Live stage

Oracle Applications 11.0.3/ 11.5.7 (OPM, INV, PO, OM)

GE Medical Systems

Integration Testing for GE Medical Systems

. Offshore Team Member

. Conducted system integration testing and validated transactions

related to the discrete Manufacturing modules such as Inventory,

Bills Of Material (BOM), MRP, Work in Process (WIP), Purchasing,

and Order Management as per the standard global test scripts of

the client.

. Responsible for standardization of test scripts, designed

comprehensive testing plan to automate the testing process by

using the WinRunner tool, and ensured all the business case

scenarios were fully tested.

. Defined forecast set, MDS (Master Demand Schedule), Planning

Parameters run MRP/MPS for generating the exception messages and

the Planned orders.

. Alarmed the client on the issues to be taken in consideration

during integration testing

Oracle Applications 11.5.7 (MFG, INV, BOM, MRP, WIP, PO, OM)

Saint-Gobain Vetrotex India Limited

Furnace Rebuild Project

September 1999 - September 2000

Management Trainee

. Worked for one of the leading Fiber Glass manufacturers in the

world, the Indian subsidiary of Compagnie Saint-Gobain (CSG) of

France, a Fortune 500 company

. Prepared master production scheduling and materials requirement

planning as per the rolling quarterly forecast

. Prepared the project planning and scheduling for the Furnace

Rebuild project at Saint-Gobain

. Evaluated and rated vendors with respect to the supplied items as

per the company guidelines

. Worked in close liaison with various consulting firms such as

Vetrotex International, France in relation to plant process study

and improvement and also in various expansion and modernization

projects of the plant

Indian Rare Earths Limited

September 1993 - June 1997

Production Engineer

. Worked for the public sector, under the Department of Atomic

Energy, Government of India, a leading producer and exporter of

beach sand minerals such as ilmenite, rutile, garnet,

sillimanite, zircon, and monazite in India

. Managed the shop floor production activity independently and

carrying the operation of continuous dredging production line

. Responsible for planning and shift scheduling for the requirement

of human resources

. Responsible for safety of man, machinery, and plant's integrity

during the production shift

. Participated in various change management programs at shop floor

level for the implementation of TPM

. Established good co-ordination and interpersonal relationship

with other departments for smooth plant functioning

CAREER PATH

. Sr. Consultant, RJT Compuquest Inc. ( Apr 2011 - Till Date)

. Sr. Consultant, Fujitsu America Inc. (July 2008 - Mar 2009, Jun

2010 - Jan 2011)

. Sr. Consultant, enrichiT Inc. (Jun 2009 - Jun 2010)

. Systems Manager, KPIT Cummins Infosystems Ltd, 3 Yrs (APR 2005 -

Jun 2008)

. Consultant, Genpact, (Formerly GECIS -Software), 2 Yrs (Apr 2003

- MAR 2005)

. Sr. Associate, Satyam Computer Services Ltd, 2 Yrs 7 Months. (Sep

2000 - Apr 2003)

. Management Trainee, Saint-Gobain Vetrotex India Ltd, 1 Yr (Sep

1999 - Sep 2000)

. Production Engineer, Indian Rare Earths Ltd, 3Yrs 10 Months (Sep

1993 - Jun 1997)

EDUCATION

. BS of Engineering in Mining, National Institute of Technology

(NIT), Rourkela, India, 1993

. PGD in Management (Systems and Operations), Goa Institute of

Management, India, 1999

. Pursuing the CPIM Certification Program

. Certification - ASCP, Oracle Corporation

. Training on Six Sigma from GE

. Completed Basics of Supply Chain Management (BSCM) Module, CPIM

Contact this candidate