Srinivasulu Yarasi

Oracle Apps – OPM & ASCP Functional Consultant

E-mail: ac1lbd@r.postjobfree.com

Phone: 214-***-****

PROFESSIONAL SUMMARY

12+ years of experience in Analysis, Design, Development, Upgrade, Production and Sustenance Support of Oracle E-Business Suite(EBS) - Process Manufacturing, ASCP and SCM modules

Over 15 years in-depth, hands-on experience implementing Oracle Process Manufacturing (OPM) from Datalogix (GEMMS 3.2) up to version 12.2.6, including 11i, R12.0.6, R12.1.3, R12.2.4

Expert in Plan to Manufacture (PTM), Forecast to Plan flows with Implementation, Upgrade, Support and Project Management experience in OPM Modules (Product Development (GMD), Process Execution (GME), Process Costing (GMF) and Process Quality), MES for OPM, Oracle SLA, Oracle Inventory and Oracle ASCP, Electronic Records and Signatures(ERES), Order Management (OM), Oracle Quality, Approval Management (AME), Inventory (INV), Application Objects Library (AOL), and System Administration (SYSADMIN) modules.

Total 16+ years of experience, Includes 5+ years of domain experience in manufacturing as Production Planning Control (PPC) in charge of steel industry

Hands-on experience with all project phases including Project Planning and Scoping, Requirements Gathering, fit/gap analysis, proof of concept and design, testing, training, cutover planning and deployment and post Go-Live support

Very good skills in Managing, Supporting, Conduct Project Team Meetings, Communicate Action Plans, Coordinate with Cross functional teams for Project Milestones and follow up with Client/End user. Excellent skills in Requirement analysis, Functional Designs/MD050, Application Design, Gap Analysis, Configuration and Conversions.

Techno Functional and very good experience in RICEFW, PL/SQL, XML Publisher, Workflow, AME, form personalization, OAF Page Personalization’s.

Subject Matter Expert in OPM & Costing, SLA and MAC(11i) with Specialization in various OPM Functions like Formulas, Recipes, Routing, Samples, Specifications Batches, Process Instructions, Discrete Quality, Collection Plans, Dispensing, Costing (Item Standard, Item Actual and Lot Level Actual Costing) and Period Close processes

Expertise in Setting up Common Key Business Setups from scratch including Flex fields and Org Structure

Working knowledge in Oracle ASCP, Bills of Material, Work-in-Progress(WIP), Oracle Cost Management, Purchasing, Order Management, Production Scheduling(PS), Core HRMS.

Trained in Fusion(Cloud) Core HRMS(Workforce Deployment), Cloud Procurement. Waiting for Manufacturing Cloud readiness.

Good problem solving, analytical, interpersonal skills and a good team player.

Excellent understanding delta changes in R12+ versions.

Expertise on Oracle Business Accelerator Tool (Rapid Implementation Methodology)

Have exposure as Project Manager, Offshore Lead, Solution Architect, and Functional Consultant - expertise in SDLC process and packaging of the custom solutions like Shell Scripts, ldt, etc.

Bachelors in mechanical Engineering from Kuvempu University in Dec-2000, University First Rank

TECHNICAL SKILLS

Applications

Oracle E-business Suite R12(R12, R12.1+, R12.2.4/6), 11i, GEMMS

Tools:

Toad, SQL, SQL plus, PL/SQL, Data Loader, HP Service Manager, JIRA, AutoSys, Service Now

Oracle EBS modules

OPM, Product development(GMD), Process Execution(GME), Process Costing(GMF), Process Quality, Oracle Inventory, MES for OPM, OPM Quality, ERES, AME, Oracle SLA, ASCP, OM, PO, Bills of Materials, Oracle Quality,

Other Utilities

MS Office: Word, PowerPoint, expert in MS Excel, Visio, MS Projects,

EMPLOYMENT HISTORY

Dates

Organization

Position

Jun-17 to till now

Lilax Technologies Inc

EBS OPM SME

Oct-15 to Jun-17

Cognizant Technology Solutions

Senior Manager

Aug-11 to Sep 15

Rolta India Ltd

Senior Group Manager

Dec-08 to Jul-11

Hitachi Consulting (Sierra Atlantic s/w Services Ltd)

Principal Consultant

Sep-06 to Oct-08

Oracle India Pvt Ltd

Senior Solution Specialist

Dec-00 to Sep-06

JSW Steel Ltd

Assistant Manager

PROFESSIONAL EXPERIENCE

Client: PepsiCo, Plano TX. Duration: Nov-15 to Jun-17

Project: 11iOPM/R12 ASCP Sustenance Support

Environment:11i OPM, R12 ASCP Role: Support Lead

Pepsi Bottling Company is largest coal producer with operations across the US & Canada. PepsiCo has larger Oracle EBS footprint with integrations across many third party applications like Arete (Avail, prevail), Voice Pick, Siebel Direct Orders, PowerBuilder and a bunch of homegrown application.

Responsibilities

Support Day-to-day support de-centralized EBS 11i OPM & R12 ASCP application used at PepsiCo

Manage integrations to multiple third party systems like Arete (Avail, Prevail),SAP, bi-directional EDI data, FMS (File Management System), LIMS, OneTouch and bridging jobs, etc

Interact & Co-ordinate with team members to ensure quality delivery of Change Requests (CRs) on time.

Analyze Functional issues & arrive at RCA and design enhancements in process to ease application usage.

Review requirements docs/functional design documents, test case set-up, etc. (e.g., MD-50, MD-70, TD-50)

Remotely Lead off-shore & on-site team for MFG and ASCP Production/Operations Support

Handling OPM & ASCP SM tickets for 72 Plants and 350 Warehouses thru SM tool

Handle OPM Period Close process for 400+ whse’s and export transactions to standalone EBS GL system

OPM Cost Management for all items across 400+ warehouses (National Raw Material Costing)

Support the planned and unplanned downtimes of the OPM & ASCP applications

Manage Data Warehouse (DWBI) mapping and integrations thru Informatica and Teradata

Upgraded ASCP from 12.0.6 to 12.1.3.9

Data base upgraded to 11.2.0.4

Client: BRLPS, Bihar, India. Duration: Jan-14 to Sep-15

Project: JEEViKA R12 implementation

Environment: R12.2 HRMS, Finance (AP, AR, GL), PO, Projects Role: Project Manager

Bihar Rural Livelihoods Project (JEEViKA) is promoted by Bihar Rural Livelihoods Promotion Society (BRLPS), an autonomous body under the Department of Finance, Govt. of Bihar. The BRLPS Mission is to scale up the JEEViKA model of poverty alleviation in 4200 villages across 151 blocks of 21 Districts.

The EBS implementation is chosen to automate process and track different project statuses, to meet the need of establishing a robust system for timely decision making.

Responsibilities:

Resource planning and follow-up embarking process on to project

Co-ordinate with Functional leads to track and manage project as per plan.

Co-ordinate with Technical team and Functional team on timely deliverables and demos.

Conduct Daily/Weekly Scrum/standup calls for daily planning/tracking of tasks

Project status updates to Key Stake holders

Involvement in steering committee & Project Governance meetings along with Program Manger

Client: Schreiber Foods Inc, Greenbay, WI Duration: Apr-12 to Oct-13

Project: Schreiber R12 Upgrade & RICEWF remediation

Environment: R12.1.3 OPM, Finance (AP, AR, GL), eAM, OM, PO Role: OPM Functional Lead

Schreiber Dynamics Dairy (SDD) is the Indian arm of Schreiber Foods Inc. US. SDD is major contract manufacturer for Dairy Products in India. SDD produces for elite brands like Tropicana –PepsiCo, Danone yogurt, Britannia butter and ghee, etc.

Global Single instance for US (SFI) and India (SDD) operations. Upgrade is carried out in US and validation of mappings and flow individually handled by two teams, US and India respectively

Responsibilities:

Co-ordinate, plan and Manage India team for SDD requirements mapping and validations.

Co-ordinate & plan – Tasks & efforts of off-shore for remediation of Technical objects

Functionally validate MD050 and assign the objects to competent developer.

Guide Functional Consultants and developers with functional flow and underlying tables for OPM related objects/Enhancements.

Monitor objects development progress and update client and raise invoice for consumed hours.

Functional requirement gathering and solution design & review for Enhancements.

PROJECT PROFILE 4

Project: Core Labs R12 Upgrade /Client: Core Labs Ltd, US

Role: Offshore Account Manager and Project Lead

Duration: Sep’12 to Jan’13 / Environnent: Oracle E-Business Suite R12.1.3, Upgrade, RICEWF remédiation

Modules : Inventory, Bills of Materials(BOM), Work in Progress(WIP), Oracle Costing, Purchasing, Order Management (OM)

Core Laboratories is a leading provider of proprietary and patented Reservoir Description, Production Enhancement, and Reservoir Management services. With over 70 offices in more than 50 countries located in major oil-producing provinces, Core Laboratories provides services to the world's major, national, and independent oil companies. They continue to develop and acquire technologies that complement their existing products and services, and they disseminate these technologies throughout the world with global network presence.

Responsibilities:

As account manager finalized offshore development plan in line with onsite deliverables plan.

Resource planning and follow-up embarking process on to project.

Monitor project status and weekly update to onsite stake holders on the health of project. Plan for deviations if any.

As a Project Lead co-ordinate with US team plan and Manage India team for Core Lab requirements mapping and validations.

As project lead co-ordinate with track leads for smooth sailing of project.

Involvement in steering committee & Project Governance meetings

Project completed with ZERO escalations.

PROJECT PROFILE 5

Project: Project ION / Client : Regeneron Pharmaceuticals, Inc, US

Role: Project Lead / Duration: 4 Months (from Dec’11 to Mar 12)

Environnent: Oracle E-Business Suite R12.1.3, Upgrade, RICEWF remédiation

Regeneron is a biopharmaceutical company. Regeneron discovers, develops, and commercializes pharmaceutical competency team, provides products for the treatment of serious medical conditions. Major work is remediation of the existing RICEWF objects. Major objects are from OPM area and related to GMP compliance of pharma industry.

Responsibilities:

Co-ordinate with onsite team and plan the efforts at off-shore for objects remediation.

Functionally validate MD050 and assign the objects to competent developer.

Guide developer with functional flow and underlying tables for OPM related objects.

Monitor objects development progress.

Conduct Functional testing before delivering to onsite team

Designed and Developed Batch Label printing API customization -Oracle Loftware connector

Project: Rolt OPM Competency Building / Client: Internal CoE

Role: OPM Functional Lead /Duration: 3 Months (from Sep’11 to Nov 11)

As part of building OPM competency team, provided OPM Boot camp training.

OPM Functional Boot Camp – 6 Weeks

OPM Technical Training – 6 weeks

Project: PPG R12 Upgrade analysis / Client: PPG, US

Role: OPM Functional Lead

Duration: 6 Weeks (from May’11 to Jun’11) /Onsite Netherlands

Environment: Oracle E-Business Suite R12.1.3 : OPM, ASCP, Inventory, Financials

Pittsburg Paints and Glass (PPG) is worlds largest paint manufacturer. Analyzed existing 11i application and suggestions provided on the implications of Re-implementation and upgrade to R12. Conducted R12 delta training to users for all modules of OPM at PPG site, Netherlands. Covering major impacting functionalities, like

Implication of changing from OPM warehouse as either inventory org or sub-inventory in R12

Advanced costing features like IBOM report, change in cost calendar & assignment structure and hence reducing data maintenance.

Flexibilities of SLA over MAC.

Also covered functionalities like Least cost formulation with derived costs, S88 Compliance, 11 profiles as OPM parameters, Lot Genealogy, etc.

Project: Sherwin William Malaysia R12 Rollout / Client: Sherwin Williams Inc., USA

Role: OPM Functional Lead / Onsite :

Duration: Aug’10 to May’11 / Environment: Oracle E-Business Suite R12.1.2 : OPM, ASCP, Oracle Inventory

Sherwin Williams Inc., USA, Manufacturers of coatings for plastics, metal, and wood serving the automotive, aerospace, construction, industrial, and maintenance coating sectors. Sherwin Williams is on a fast track growth & is leveraging technology for reaping benefits. A study to assess SW Malaysia requirements was carried out and SW Malaysia is rolled out into Oracle Applications ERP Solution.

Responsibilities:

Gathered requirements, validated the Requirements and Provided the Fit & Gap analysis for Product development, Process execution and Quality modules.

Performed Solution design/mapping and delivered To-Be process document (BP080), and setup documents (BR100)

Configured the required setups in all OPM Modules

Provided the data Conversion plan and Mapping.

Complete design, documentation (MD050), testing of the customizations and reports.

Completed SIT & UAT

Configured the Production instance.

Provided Post Go-Live support for 8 weeks, including two month end periods close.

Project: Terga Foods R12 Implementation / Client: Trega Foods Ltd, USA

Role: OPM Functional Lead / Onsite

Duration: 7 months (from Jan’10 to Jul’10) / Environment: Oracle Applications E-Business Suite R12.1.1

Trega Foods (Wisconsin, USA) a division of Agropur is a leader in Cheese Production in Wisconsin. Trega Foods is a worldwide supplier of award winning cheese and whey products. A study to assess Trega Foods requirements was carried out and Oracle Applications ERP Solution was configured.

Responsibilities:

Gather Business requirements from business users and study in depth existing process flow from Product development -Process execution and Quality and delivered requirement gathering document (RD020)

Provided Solution design/mapping and delivery of To-Be process document (BP080).

Setting up CRP instances as per business requirements and testing of end to end flows.

CRP demonstration to super users.

GAP analysis and design of extensions to meet the gaps.

Complete design, documentation (MD050), testing of the customizations and reports.

Design of conversion strategy and data migration of manufacturing objects.

Complete documentation on Solution design, Setups(BR100), data templates, customizations, etc.

Provided Post Go-Live support for 6 weeks.

Project: Nexus 11i conversion / Client: PPG, US Role: Functional Consultant /Offshore

Duration: 11 months (from Feb’09 to Dec 09) / Environment: Oracle Applications E-Business Suite 11.5.10.2

Conversion project from GEMMS 4 & Oracle financials 11.0.3 to 11i. Involved in design and development customization of Equalization process and Cognos report for supply chain modules.

Responsibilities:

Involved in the Understanding document preparation(As –Is)

Involved in the design of To-Be process.

Involved in the development of Equalization customization from scratch to end, viz Bilk Equalization, SKU destination Equalization, Batch Management & Bulk To Fill

Complete end-to-end testing of the custom solution and deployment

Analyze and estimate effort for Change Requests and bugs reported and provide fix for the them.

Complete documentation of Equalization includes User Document, Test Cases, what-if scenario’s, etc.

Development and testing of Equalization cognos reports.

Oracle Accelerator: Rapid Implementation tool building

Oracle Business Accelerators constitute a rapid implementation approach based on standard business flows and leading industry practices. It is an integrated suite of methods, services and tools that enable a partner to evaluate deploy and maintain Oracle Applications. This solution provides an online setup tool and associated collateral targeted to a specific industry and/or country. Oracle Accelerators deliver faster implementations with lower costs, mitigated implementation risks and high-quality results

Roles and Responsibilities: -

Getting Business Requirements (RD.050) from Pre-Sales Team and Oracle Implementation Partners from different industries and countries.

Building the scope of work and solution footprint after understanding the business requirements.

Designing Flow Models (BF020) based on the Business Requirement and Scope of Work.

Defining the Project Plan and objectives for the team members, setting up the Time lines & Identifying, and organizing necessary resources for execution.

Reviewing with Senior Management team to update the progress of the Project & effect the changes as per the directions.

Building up the instance manually by identifying required setups (BR.100) to deliver the required solution for specific industry and country as per the scope of work and business requirement document.

Designing the Data Model and Setup Document for the identified required setups

Create the Automated Setups for the identified setups in Oracle Accelerators Tool as per the data model and setup document, and build the training baseline instance

Configuring the Automated Setups to build the individual flow-family baseline instance, with required shared products setups for integration.

Configuring the setup tool questionnaire in three modes for Training (Single and multi-org structure), Production Basic (Single Org structure), and Production Advanced (multi-org structure)

Create the test scripts (TE040) for demonstrating the end-to-end Business Process Flow Sequence with complete integration of the individual Flow-model within Flow-Family and Different Flow-Families.

Create Test scripts (TE040) for advanced mode Multi-Org Structure.

Coordinating with DBA Team for OBA Project Workspace, Patches and Licensing and creating the Solution Implementation Guidelines (TA160) to be included in baseline instance and training gold instance.

Coordinating with Development team for Metal ink and Control patches releases and Updates for resolving build show stopper issues.

Working Closely with Pre-Sales Team and Oracle Implementation Partners about the Project deliverables, Solution implementation and Build support.

Build 1:

Industry/ Country: Natural Resources and Mill Products / United States

Role / Duration: Project Leader / Jan - 08 to May - 08

Solution Environment: Oracle Applications E-Business Suite R12.0.4

Modules Handled: Process Development, Process Execution, Process Quality, and OPM Cost Management, MES Business Flows: Concept to Release, Product Costing to Inventory Valuation, Recipe Designer

Highlights:

Requirement Analysis and Data Model preparation

Developed Business Flow ‘Product Costing to Inventory Valuation’

Developed Test Cases (TE.040) for ‘Product Costing to Inventory Valuation’ with Cost Rollup (Actual & Standard Costing), Cost Update & Inventory Valuation with Cost Adjustment.

Developed test cases for the Recipe Designer Workbench with Least Cost Formulations.

Involved in the Business Process Architecture (BP) for Costing & Cost Adjustments.

Build 2:

Industry: Life Sciences - Pharmaceuticals & Biotech, Canada /Duration: Mfg Lead / Aug - 07 to Dec - 07

Solution Environnent : Oracle Applications E-Business Suite R12.0

Module Handled: Collaborative Planning, Advanced Supply Chain Planning (ASCP), Product Development and Process Execution.

Business Flows: Forecast to Plan, Customer Collaboration to Consensus, Concept to Release

Highlights:

Implemented Planning flows starting from Customer Collaboration to Consensus Forecast.

Developed Test Cases (TE.040) for Inventory Optimization, Customer Collaboration

Developed Sourcing Rules, Bills of Distributions, Assignment sets

Developed multi country localization approach in a single template

Build3

Industry Health & Beauty, Homecare, UK / Duration: Mar - 07 to Jul - 07

Solution Environment: Oracle Applications E-Business Suite R12.0

Business Flows: Concept to Release, Stability Study Development, Least Cost Formulations

Highlights:

Implemented Least Cost Formulation & New Product Development flow.

Managed the Accelerator Tool Configuration by integrating all the modules

Developed Test Cases (TE.040) for ‘Stability Study Development to Evaluation’

Build 4:

Industry: Consumer Products – Food & Beverage, US Duration: Oct - 06 to Feb - 07

Solution Environment : Oracle Applications E-Business Suite R12.0

Modules Handled: Product Development, Process Execution. MES for OPM

Business Flows: Concept to Release, Schedule to Produce

Highlights:

Involved in Accelerator Tool Configuration.

Definition & Automation of Business setup Questions

Setting up Process Organization setups

Involved in the OPM Setups, viz Plant/ Lab Org Parameters, Recipe Validations, etc.

(JSW Steels Ltd, Karnataka, India / (From Dec2000 – Sep2006)

JSW is the modern Greenfield integrated steel plant based on environment friendly Corex Technology with capacity of 4 MTPA HR coils. JSW opted Oracle e-Business suite 11.5.10 for its day-to-day business activities. The Organization opted Oracle 9i database on Linux platform with Oracle Report Builder 6.0.8.8.3 and Oracle Forms [32 Bit] Version 6.0.8.8.0.

Responsibilities

Involved in preparation of Business Plan, Quarterly, Monthly for units like HSM (Hot Strip Mill), CTL (Cut-to-Length), BOF (Basic Oxygen Furnace), CCP (Continuous Casting Plant), COREX (Iron Making) & Pellet plant.

End -User support for implementing the Tailor-made applications and Production Systems as a part of ERP- Implementation for the Production units material scheduling, production planning, Production Inventory Evaluation, Sales Forecasting, Dispatch.

Preparing Business Requirements, Change Request, Error Reporting, Error Analysis, Unit Testing, System Testing, Integrated Testing (Manufacturing, Commercial, and Logistics systems), and Training.

Industrial Experience

Take the lead role in rolling the FLAT products. Work closely with the operational teams & Co-ordinate between inter-departments for smooth flow of materials, utilize relationships to ensure that product implementation schedules are met & Collection priorities of marketing are fulfilled.

Facilitate strategic Marketing resources to assist in the sales process.

Responsibility for the Order processing from initial point of contact (lead generation), presentations, proposals, through priority negotiations and execution for the Customer Service.

Excise declaration of finished goods on daily basis & Keep track of the Raw Material & Finished Good Stock.

Generate MIS reports for the Top Management to take strategic decisions.

Fluency in utilization of ERP (Steel Process Tracking System) application for the material scheduling, production planning & order tracking.

Contact this candidate