SUMMARY:

Confidential is an expert in helping organizations deploy Oracle’s value chain planning solutions. Confidential has spent the last 15 years applying his deep product, technical and industry experience helping top global companies such as Confidential, Confidential, Confidential, Confidential, Confidential and Agilent gain bottom - line value through improved supply chain performance. Clients span multiple industry verticals ranging from High Technology, Contract Manufacturing, Banking, Finance, Energy, Consumer Goods and Entertainment. Deep product knowledge (Senior Product Lead for Oracle Planning products) and extensive Industry expertise (Manufacturing & Distribution & Financials) makes Raghav an optimal fit to solve complex problems and design creative solutions that accelerate business value.

TECHNICAL SKILLS:

SKILLS: Solaris, Linux (Ubuntu, Debian, Redhat), Oracle 11g, 10g, 9i, 8i, C,C++, Java,, BC4J, Oracle RDBMS 6, 7, 7.1,8.x, 9.x, Oracle Forms 6.0, 2.3, 3.0, 4.5, Reports 2.5, 2.0 (Developer 2000), 1.1, PL-SQL, Pro*C, MQ-Series, Active Web Object Request Broker, Corba, Case*Generator 2.0, Case*Dictionary 5.1, OCI, Filenet, Filenet Oracle E-Business Suite Integration (Imaging and Document Solution), Oracle Identity Manager ( Xellerate ), Oracle Access Manager ( Netpoint ), Netegrity Identity Minder, Sun Identity Manager 8.0, HIPAA Compliance

Packages: Oracle Manufacturing & Financials, Release 12, 11i (11.5.10, 11.5.8, 11.5.7, 11.5.4), 11.0, 10.7 SC, 10.6, 10.5, 10.4, AOL (Application Object Lib.); Oracle Value Chain Planning suite (ASCP, GOP, SNO, Demantra, IO, APS, APCC)

Modules: Manufacturing (WMS, MRP, OSFM, INV, WIP, MRP, BOM), Oracle Purchasing, Order Management, Order Entry, Confidential, General Ledger, AR, AP, QTC (Quote to Cash)

Languages: C++, C, Basic, Java, HTML,PL/SQL, SQL, C

Methodology: Oracle AIMS Methodology

Industry Experience: Manufacturing & Production, Hi-tech, Contract Manufacturing, Banking, Finance, Medical Equipment, Media & Entertainment

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

• Lead design and implementation of Sales Performance Management models for the Dynamic Territory and Quota Plan setup using Anaplan.
• Perform complete configuration and development tasks by working with Sales Analyst & Business owners.
• Translate 2D spreadsheet models into Anaplan Multi-Dimensional Models.
• Gather business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of Anaplan Models.
• Execute new Anaplan solutions to support new business objectives, initiatives and solve complex business problems
• Implemented ASCP
• Demantra Custom collections
• Demantra Custom Workflows and Worksheets
• Implemented APCC and OBIEE
• Implemented Inline Forecast Consumption,
• Developed and Designed and Built a Custom High Volume ATP Solution.
• Developed and Designed Forecasting and Planning Metrics and Dashboarding Solution Based on Archieved Planned Data, and Collected Data

Confidential,Mountain View,CA

Techncial Program Manager

• Implemented GATP,
• Customized ASCP -EBS Collections, Built Collections to Collect in Custom dashboarding solution.
• Implemented Inline Forecast Consumption,
• Developed and Designed and Built a Custom High Volume ATP Solution.
• Developed and Designed Forecasting and Planning Metrics and Dashboarding Solution Based on Archived Planned Data, and Collected Data. (sort of a custom APCC type solution based on Confidential tech stack) - Actionable Business Intelligence. (ABI)
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Implemented and Customized order to Cash cycles touching various modules such as AR,
• PO and AP, GL.
• Worked on the Budget Upload Open Interface to load the data from legacy systems

Confidential

Project Manager

• Created custom integration profiles and customized seeded integration profiles for data flow from Demantra to Confidential Optimization (safety stock planning) and ASCP
• Extensive Experience with Customizing EP Load Processes,
• Extensive Experience standard workflows and customized workflows
• Worksheet performance issues and under* Created custom integration profiles
• Customized Seeded Integration Profiles
• Extensive Experience with Customizing EP Load Processes,
• Extensive Experience standard workflows and customizing
• Analyzed Worksheet performance issues and optimized Forecast Engine Setups and Nodal tuning.
• Extensive Expertise in Installing Demantra and ASCP (Single and Multiple Node Setups)
• Extensive Expertise in Identifying Patches for specific instance configurations and applying patches in Windows, and Unix Environments.
• Designed custom forecast archival process to archive unconstrained forecasts from Demantra
• Modified seeded integration profile to source data (break dimension data to granular level) for computing forecast accuracy and updated EP LOAD process for data loads.
• Oracle Demantra R12.2, 7.3 .Installation, Configuration and Integration with Oracle EBS, JDE E1 2.5 and third party ERP systems. Data collections, Custom Release process from ASCP.

Confidential

Technical Program Manager

• Implementation of Oracle Advanced Planning Solutions
• Implementation of Spend Management Solutions to track spending on Flash Memory and Drives
• Implementation and testing of ASCP EDD plans
• Implementation and testing of End Item Substitution
• Implementation and testing of Component Substitution
• Financials - Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Implementation and testing of Forecast consumption at ATO Model Level
• Implementation and testing of Forecast Consumption at Product Family
• Implementation of Project Netting
• Implementation of Reservation at Planning Group
• Multi Node Installs of R12 on Linux (Ubuntu)
• Cloning and creation of multiple R12 Instances.
• Configuring of Oracle ASCP with R12 Destination and Source 11.5.10
• Installed, Configured Demantra 7.3 and created proof of concept prototype for breadboard forecasting for data centers. Customized EP LOAD collections to collect breadboard forecasts and created granular forecasts at component level by exploding BOMs . Integrated with R12 system for end to end flow of source master/transaction data, unconstrained forecasts, constrained forecasts in ASCP and back to source ERP system.

Managing Principal Consultant

Confidential,Fremont CA

• As a Principal Consultant, my role was involved implementation of Oracle Advanced Supply chain modules. The current responsibilities include implementing Oracle ASCP and GOP and giving solution presentation and leading proof of concept for the engagement. The brief summary of my experience is as follows.
• Functional and technical consultant ASCP/GOP consultant
• Business requirements gathering for Supply Planning and integration between Contract Manufacturers
• Gap Analysis between Oracle Vanilla ASCP/GOP and Business requirements
• Techno Functional Consultant for Oracle ASCP implementation
• Techno Functional Consultant for Oracle Demantra Implementation - Assessed required patches to source system for standard collections - Installed patches and setup integration to Oracle source and ASCP modules.
• Preparation of BR100, MD70 and MD50
• Solution Design for Oracle ASCP/GOP
• Proof of Concept for Various GOP scenarios (CTP ATP, SKU level ATP etc)
• Proof of Concept for Allocation scenarios (% based and demand class based)
• Financials - Worked on Custom High Speed Auto Invoice Import Interface into Oracle Financials
• Implementation and testing of Forecast consumption at ATO Model Level
• Implementation and testing of Forecast Consumption at Product Family
• Proof of concept - Priority based pegging
• Design and Proof of concept - Product Family based ATP
• Region level sourcing - Design and proof of concept
• Collections and Pre-and Post plan customizations - Design and development
• Configuration and Integration with Oracle EBS, JDE E1 and third party ERP systems.
• ASCP Setup - Sourcing rules, Assignment sets, Priority rules etc
• Design and Development of Custom Reports (Factory extract, Order scheduling vs MPS variance etc)

Senior Project Lead - Oracle Advanced Planning and Scheduling

Confidential

• Developed and coded MBP (Memory based Planner) enhancements for the planning engine
• Design and development of the Collection Routines of Oracle APS . (Integration of Oracle APS with the rest of manufacturing modules)
• Designed and Developed the Releases Interface Between Oracle APS and Oracle WIP / Oracle Purchasing
• Designed and Coded the Planners workbench Release Interfaces
• Designed and coded enforcing integer requirements options of the Advanced planning system
• Designed and Coded Data Collections from ERP to ODS
• Designed and Coded Data Collections from ODS to PDS
• Implemented the Partition feature of the APS planning system
• Designed and Coded the OSFM (Shop Floor Management) to APS interfaces
• Designed and Coded the OPM (Process Manufacturing) to APS Interfaces
• Designed and Developed the Complex Planners Workbench UI using Forms 6.0, PLL libraries.

Environment: Oracle Manufacturing & Financials - 11i,11.0, Oracle 9.x, 8.x Forms 6.0, Pro*C, SQL*Plus, PL/SQL

Consultant - through Oracle Consulting

Confidential,Orange, CA

• Worked with following modules: Manufacturing - INV, MRP, BOM, Order entry, Accounts Receivables, Sales compensation.
• Developed costing conversions routines to bring from costing input information from legacy system to the Oracle Applications.
• Developed item conversions routines to bring data from legacy.
• Developed category conversion routines to bring data from legacy.
• Developed customized receivables interface, and auto invoice interfaces.
• Developed and customized pick slip reports, invoice reports and bill of lading reports.
• Developed a bit mapped invoice report
• Developed an auto cancellation concurrent program based on a cancel date at order header level.

Environment: Oracle Manufacturing & Financials - 10.7,Oracle 8.x Forms 4.5, Reports 2.5,Pro*C, SQL*Plus, PL/SQL

Techno Functional Lead Consultant

Confidential

• Involved in the implementation of Oracle General Ledger. Design of GL chart of account structure, setting up GL profile. Options, converting over the chart of accounts from the legacy application to Oracle General Ledger, GL import interfaces to Oracle Confidential, Oracle Receivables.
• Involved in customization of Order Entry module. Recreated the accounts receivable interface programs with order entry by coding in Pro*C. The new interface program would handle discounts as per user requirement rather than as per the Oracle application rule sets.
• Customized pick slip handling and shipping routines by interfacing with a third party pick ticket management system, which would generate bar codes.
• Developed customized reports as per user needs for pick slip printing in OE and forecasting in Confidential and MRP modules. The forecasting report would print all changes in forecast either entered by user or generated by MRP processes.
• Customized the mechanism of discount handling.
• Designed and developed a custom AR interface utilizing C and Pro*C.

Environment: Oracle Manufacturing & Financials - 10.5, Oracle 7.1, Forms 2.3, Reports 2.0, Reports 2.5

Confidential,Colombus,IN

• Involved in the implementation of OE, Confidential and MRP subsystems.
• Involved in customization of Order Entry module. Modified the Accounts Receivable interface and Accounts Payable interface to generated auto invoices between a customer and vendor.
• Developed routines to handle automatic faxing of confirmed orders and shipments. Created custom report programs as well as a shell script that would print the spooled output to a fax gateway with customers fax number as a parameter.
• Designed a module to handle orders, which would be drop shipped from a vendor site, or a manufacturing site.
• Designed and developed an audit report that would list all orders that has been pick released but not ship confirmed.

Environment: Oracle Manufacturing & Financials - 10.5, Oracle 7.1, Forms 2.3, Reports 2.0, Reports 2.5