Supply Chain Project
Resume:
Santosh Bisht
***** ********* ******, **** *, Cupertino, CA 95014
Phone : 408-***-****(C) email : *******@*****.***
Summary :
** ***** ** ** **********. 11+ years of experience in Oracle Applications. Involved in the Implementation, Customization and support of several Oracle Supply Chain, Financials & CRM applications. Worked in Supply Chain, Manufacturing, Financials & CRM Modules (OM/OE, INV, PO, Shipping, Advanced Pricing, GOP, ASCP, Demantra, Collaborative Planning BOM, WIP, MRP, Cost Management, OPM, iSupplier Portal, Supply Chain Mobile Applications, Demand Planning, GL, AP, AR) with Oracle Applications Release 12, 11i, 11.03.
Expertise includes:
• 11 years of experience in Oracle eBusiness Suite (Rel 12, 11i/11.03), as Business Analyst/Functional Consultant, Techno-Functional Consultant/Developer/System Analyst/Project Lead for Oracle Supply Chain, Distribution CRM & Financials modules.
• 15 years of IT experience; 3 years of operations experience in demand and supply planning functions.
• Expertise in Implementation and Customization of various modules including, Order Management/Order Entry, Purchasing, Inventory, Oracle VCP modules(ASCP, Demantra, GOP, Collaborative Planning), BOM, WIP, Cost Management, Financials& CRM Modules(General Ledger, Accounts Receivable, Accounts Payables, Service Contracts, iExpense), System Administration and Application Developer.
• Extensive experience in Configuration and setup of Supply Chain & Distribution modules( ASCP, GOP, Collaborative Planning, INV, PO, OM ) and Manufacturing Modules
• Experience in various phases of SDLC including Business requirements gathering,, business process analysis and research, functional and technical specification.
• Good understanding of Plan to Make, Quote to Cash, Procure to Pay and Accounting to Reports business processes.
• Preparation of functional and technical specification documents, test scripts, unit test plans, integration testing, release & change management activities, requirement reviews, design reviews, user manuals and user Training.
• Implemented AIM methodology.
• Strong interpersonal skills, ability to interact with people at all levels.
• Experience in dealing with business users, understanding their requirements and leading a team.
• Good experience in supporting business users, troubleshooting issues & solution design;
• Have good SQL and PL/SQL knowledge
Education/Certifications:
• MS in Engineering, NITIE ( National Institute of Industrial Engineering), India
• BS in Engineering from BITS, Pilani.
• APICS Certified Supply Chain Professional (CSCP)
• Completed PMP Prep1&2 certifications.
SKILLS:
ERP : Oracle Applications 12,11i/11.03:(OE/OM, Shipping, Advanced Pricing, INV, PO, iSupplier Portal, ASCP, GOP, Collaborative planning, Demand Planning, BOM, WIP, MRP, Cost Management & AOL, GL, AR, AP), Oracle Self Service Web Applications.
CA - PRMS ( Pansofic Resource Management System) & Scala(now part of Epicor Software Corporation).
Programming Languages: PL/SQL, SQL
Database : Oracle
Software/Tools : Oracle Developer tools, TOAD, Workflow, Discoverer, PVCS, Test Director,
XML Publisher (BI Publisher), FSG, OBIEE.
Operating Systems: UNIX, Sun Solaris, Windows Other : Seagate Crystal Reports
1. Form Factor Inc, Livermore, CA Apr 2012 till date
Role : Oracle Supply Chain Planning Consultant
Project Details: Implementation of Global ASCP Plan – Requirements Gathering and Prototype Phase
• Document AS IS processes in Master Planning, Production Planning, and Material Planning and Procurement areas.
• Gather requirements for implementing ASCP; Prepare business requirements document.
• Model To Be Process flows for Master Planning, Production Planning, Material Planning and Procurement areas with ASCP as planning tool.
• Fit- Gap analysis.
• Prototype solution to meet business requirements.
• Setups for ASCP Collections and ASCP Plans.
2. Oracle Applications (EBS Rel 12.1.1), Fujitsu Computer Products of America Inc, Sunnyvale, CA Jan 2011-Mar 2012
Role Track Lead /Architect ( Distribution and Manufacturing )
Project Details: Oracle R12 Implementation( OM, INV, PO, WIP, BOM, Cost Management, Planning)
.
• Gather Business Requirements, perform Change Management, Business Process Improvement (BPI), Re-Engineering (BPR) and documenting Business Processes for Order Fulfillment, Procurement and Manufacturing processes for implementing Oracle R12. Scope included OM, INV, Shipping Execution, PO, WIP, BOM, Cost Management, Planning.
• Involved in Fit-Gap Analysis, creating business models, conducting process design workshops and documenting the resulting solutions.
• Configuration and setups related with OM, Shipping Execution INV, PO, WIP, BOM, Cost Management, Planning.
• Re-engineering Order fulfillment, Returns processes for different order types including standard, evaluation, returns, scrap, international, etc.; improve Pick Release process.
• Business mapping of various inventory transactions; cycle count, move orders, internal requisition, internal sales orders etc; manufacturing processes related with work orders for Kits and Depot Repair.
• Assign tasks, monitor and track status, and status reporting.
• Prepare functional specification documents and work with technical team on Customizations and data conversion related with Open Sales orders, On hand balances, Item Cost, Item categories, Catalogs, etc..
• Creating Test scenarios and test scripts; Testing of business processes related with Order fulfillment, Procurement, Manufacturing, Planning etc.
• Conduct CRP and support users during UAT, Conduct User training and create Training documents, cutover plan and issue log.
• Production Support, Bug Fixes, Troubleshooting issues in Supply Chain/Distribution /Manufacturing
3. Oracle Applications (EBS Rel 12.06), SunPower, San Jose, CA Sep 2010 - Jan 2011
Role Oracle Supply Chain Consultant
Project Details: Support and implement VCP ( ASCP, GOP/ATP, Collaborative Planning, Demantra), Supply Chain and Distribution modules(INV, OM, PO).
• Involved in design and implementation of key Operation Organization Objective to move from Push Planning process to Demand Pull/JIT Process.
• Implemented Collaborative Planning as part of Lean initiative to move from direct shipment based on forecast to SunPower Distribution Whs to Hub & Spoke Supply Strategy for critical supplier.
• Setups related with integrating ASCP with Collaborative Planning and Allocated ATP.
• Creating Test scenarios and test scripts; Testing of business processes related with implementing demand pull, which included forecasting, ordering, ATP and procurement processes; Collaborative Planning; Allocated ATP.
• Conduct CRP and support users during UAT.
• Prepare BR100, Functional specification document, Training documents, cutover plan and issue log.
• Coordinate with offshore development resources for customizations.
• Production Support, Bug Fixes, Troubleshooting issues in Supply Chain/Distribution /Manufacturing.
4. Oracle Applications (EBS Rel 11i), Qualcomm Inc, San Diego, CA Mar 2010 - Sep 2010
Role Oracle Applications Consultant ( Project Lead)
Project Details: Support Oracle EBS Rel 11i
• Working as Project Lead for Supply Chain/Distribution/Manufacturing modules.
• Understand requirements & issues, design specification documents, testing and deployment of RICE components required for supporting Oracle EBS at Qualcomm.
• Support interfaces between Oracle EBS and Rapid Response ( Supply chain planning tool from Kinaxis).
• Leading a team of offshore resources including coordinating offshore development efforts, status reporting.
• Testing of business processes for Order to Cash, Procure to Pay, Demand to Build processes with reference to R12 upgrade.
• Production Support, Bug Fixes, Troubleshooting issues in Financials & Supply Chain/Distribution /Manufacturing.
5. Oracle Applications, Macsteel USA, Newport Beach, CA Aug 2009 - Mar 2010
Role Oracle Applications Consultant
Project Details: Implementation - E-Business Suite Rel 12
• Worked as Business Analyst for Supply Chain/Distribution/Manufacturing modules ( Plan to Make processes )
• Requirements gathering, AS-IS and TO BE process flows.
• Setups related with OM and INV.
• Responsible for Functional Design & testing of Customizations for Supply Chain/Distribution/Manufacturing modules.
• Unit testing and Integration testing of business processes for the completed Supply Chain process including Demand to Build processes.
• Support users during the CRP & UAT phases.
• Production Support, Bug Fixes, Troubleshooting issues in Financials & Supply Chain/Distribution /Manufacturing.
6. Oracle Applications, Brocade Communications Inc, San Jose, CA, Nov 2007 - Dec 2008
Role Supply Chain Consultant
Project Details: Implementation of ASCP and Demantra - E-Business Suite Rel. 11i.
• Worked as Business Analyst/Supply Chain consultant for Supply Chain/Distribution/Manufacturing modules ( Plan to Make processes )
• Involved in Business Process Improvement (BPI), Re-Engineering (BPR) processes for migrating from i2 to ASCP and Demantra for planning.
• Responsible for requirements analysis and solution design.
• Setups related with OM/Shipping/GOP/ATP/ASCP and Demantra - E-Business Suite Integration; Schedule and run Collections and Plans.
• Designed Customization for Programs/Interfaces/Extensions for ASCP, GOP including customizing Oracle Collections for interfacing between ASCP/ERP and Demantra.
• Designed, developed and customized Demantra Collections Framework to cater to Business requirements, which included booking and shipping history, item attributes, on-hand and in-transit balances etc.
• Data validation of items, locations etc.; reconciliation of Shipment & Booking History (Revenue & Non revenue).
• Conduct CRP, UAT & Integration testing for ASCP & Demantra Go-live & Post-Production Support including logging SR with Oracle and OWC.
• Designed, developed and supported processes for Data Manipulation in Demantra; Created, modified, and supported worksheets for users.
• Troubleshooting & resolution of issues related to ASCP & GOP.
• Provide detailed analysis and solution for the change requests and production issues.
7. Oracle Applications, Sun Microsystems Inc, Santa Clara, CA, Apr 2007 -Oct 2007
Role Oracle Applications Consultant (as member of Oracle Consulting Team)
Project Details: Implementation & Production Support - E-Business Suite Rel. 11i
• Interact with business users for customization needs and resolving process and technical issues for Order to Cash and Demand to Build processes.
• Create Design specification documents.
• Managing customizations and extensions.
• Review of technical design documents and custom objects with onsite development team.
• Manage & Troubleshoot production related issues and coordinate with users/Functional team and technical team regarding resolution of issues.
8. Oracle Applications, Kyocera Wireless Corp, San Diego, CA, Dec 2006 - March 2007
Role Oracle Applications Techno-functional Consultant
Project Details: Involved in modifying existing customizations for changes due to MEID implementation, testing the business processed involved and Production Support - E-Business Suite Rel. 11i
• Interact with business users for customization needs and resolving process and technical issues ; Create Design specification documents..
• Design, development, testing of Custom programs, reports, forms for the MEID implementation project including 856 Data Extract.
• Production Support, troubleshoot production related issues in the area of distribution/Financials (OM, Shipping, Adv Pricing, INV, AR, GL, PO, AP).
• Requirements Analysis, Technical design & development of Custom Programs/Interfaces /Extensions/Reports for OM, Shipping, Adv Pricing, INV, AR, GL, PO, iExpense.
• Enhancement and development of custom reports for the OTC and PTP business processes.
• Development of alerts related to OM, Shipping and AR.
• Manage Service Requests with Oracle Support and Service Delivery Manager to resolution including escalation.
9. Oracle Applications Implementation, Lucent Technologies(Riverstone Networks), Santa Clara,CA, June 2006 – Nov 2006
Role Oracle Applications Consultant(Team Lead)
Project Details: Involved in design, development, testing for customizations and Production Support: E-Business Suite Rel. 11i
• As Team Lead was responsible for Requirements analysis, Design Specification Documents, Coding, Testing, QA and support of the Customizations and application Extensions.
• Research, identify, and resolve Go-Live production issues.
• Troubleshooting problems & issue resolution.
• Assist users in period closing and resolve issues and problems; Resolve issues for error transactions related to OM, Shipping, Billing, Booking, Order backlog, Revenue Forecasting, Service Contracts, Install Base & iSupport.
• Coordinate with other team members.
10. Oracle Applications Implementation, Logitech Inc, Fremont,CA Jan 2006 – May 2006
Role Oracle Applications Consultant
Project Details: Implementation & Production Support of ASCP/E-Business Suite Rel. 11i
• Worked as Business Analyst/Supply Chain consultant for Supply Chain/Distribution/Manufacturing modules ( Plan to Make processes ).
• Did requirements gathering, Designed, Developed and updated Process Flows, Prepared Functional and Technical Specifications Documents. Documented, updated & analyzed “As is” and “To be” processes.
• Interacted with business and developed Functional & Technical Design Specifications for Custom extensions and objects used for ASCP, Global ATP, Allocated ATP and ODP.
• Implemented Allocated ATP using Customer Class hierarchy.
• Worked on Customization for Allocated ATP; Designed Customization for ODM CM MPS & SZ MPS extracts based upon simulated plans in ASCP, Sourcing rule exception report, reports for uploaded forecast details, errored records and processed records, Custom program to group planned orders( from ASCP) in the PO requisitions interface before requisition import runs.
• Prepared Test cases, testing of customizations, fixing and resolving issues related to the customizations; Support the user community during the CRP.
• Managed customizations and extensions and work with developers for development of custom programs/extensions.
11. Oracle Applications Implementation, Rosemount Inc (Emerson Process Management), Chanhassen, MN, Oct 2005 – Jan 2006
Role Oracle Applications Consultant.
Project Details: Implementation & Production Support for implementing E-Business Suite Rel. 11i
• Worked as Oracle Supply Chain Consultant.
• Involved in solution design to implement Global Planning as part e-Global Supply Chain project.
• Setups related with ASCP Collections and ASCP Plans.
• Analyzed Customizations affected by transition from MRP based planning to ASCP.
• Understand customer requirements for min-max planning and design customization to overcome gaps with respect to planning transfer transactions. The solution included incorporating planning transfer transactions in the custom interface program to update inventory balances in Oracle for issues and sub inventory transfer in Warehouse Advantage.
• Created test cases for testing of Custom extensions and interfaces related with Supply Chain and Procure to pay processes; Testing of various business cases.
• roubleshooting and fixing issues in the area of Supply Chain Planning; Schedule and run Collections and Plans.
• Manage Technical Assistance Request (TAR's) with Oracle Support and Service Delivery Manager to resolution including escalation.
• Coordinate with offshore development team for design, development and testing.
12. Oracle Applications Implementation, Intuit Inc, Mountain view, CA. July 2005 –Oct 2005
Role Oracle Applications Consultant.
Project Details: This project involves in design, development and testing of customizations for Oracle Applications Rel. 11i (11.5.10.2) and providing support for the same.
• Techno-Functional Consultant for developing customizations for Distribution/Supply Chain/Financials( OM,
• INV, PO, AR, AP,GL).
• Technical design, development of custom programs, reports etc.
• Worked with an offshore team of developers.
• Wrote Test cases for the order fulfillment and procurement processes, test scripts, Unit Testing, Integrated system testing and user acceptance tests for Order to Cash, Invoice to Cash and Procure to Pay processes
13. Oracle Applications Implementation, Belkin Corporation, Compton, CA. Feb 2005 –June 2005.
Role Oracle Applications Consultant.
Project Details: This project involves in design, development and testing of customizations including upgrade to Oracle Applications Rel. 11i (11.5.10.2) and providing post-production support for the same.
• Gathered user requirements to handle mail-in-rebates with respect to actuals vs budgeted quantities and develop functional specifications for the customization. Customization involved development of a form which includes features to enter, edit, view mail –in –rebates (MIR) for items, view actual totals against budgeted totals and progress the MIR through various status.
• Unit testing and Integration testing of Order to Cash and Procure to Pay processes for the upgrade to 11.5.10.; Development of Reports for OTC & PTP business processes.
• Technical design & and development of a custom program to load the item relationships of items; Modify PO approval workflow.
• Enhancement of reports including order fill rate report, inventory stock aging report and inventory valuation reports etc.
• Setup for assigning documents, which included categories etc. to the Belkin Item Master (Custom form).
• Technical design and development of report to track Shadow Purchase Order details against Consignment purchase orders.
14. Oracle Applications Implementation, Imagistics International Inc, Trumbull, CT. Dec 2003 - Jan 2005
Role Oracle Applications Consultant.
Project Details: This project involves implementing E-Business Suite Rel. 11i and providing post-production support for the same.
• Techno –functional Consultant for the Order to Cash processes.
• Design, development & testing of Interfaces including PO Receipts Interface, Inventory Adjustments Interface, Ship confirmation Interface, RMA Receipts Interface, Sales Order outbound Interface and RMA Outbound Interface from & to BAX
• Design, development and enhancement of reports in the area of Logistics, Service Contracts, Order Fulfillment and Receivables, which included the technical design & development of an Equipment Variance report which listed serial numbers of FAX equipment in Oracle and not in BAX WMS and vice versa, Customer Statement Report and enhancements to the pick list report printed by the RDC; Troubleshooting and enhancement to other reports.
• Develop unit test plans &scripts; Unit testing & integrated system testing and user acceptance tests for BAX related interfaces, custom programs in order fulfillment area, Service Contracts, Install Base, Field Service & Mobile Field Service.
• Provide production support for issues related with OM, Shipping, INV & PO, Service Contracts & Field Service, Workflow, AR etc.
15. Oracle Applications Implementation, McGraw-Hill Education, Columbus, OH. July 2003 to Dec 2003.
Role Oracle Applications Consultant.
Project Details: This project involves implementing E-Business Suite Rel. 11i .
• Understand customization requirements and prepare design documents in area of OM, Shipping, INV and AR
• Technical design for customizations, which included changes in custom.pll & workflow to incorporate requirements to display messages for sales order total exceeding customer PO Amount, and putting order on hold.
• Technical design for assigning deliveries to PTO items requiring special handling in warehouse. This involved design, development of a custom package to handle deliveries involving PTO items and using shipping APIs to un-assign and reassign deliveries.
• Understand business requirement for handling depository adjustments and provide technical solution. The design included creation of custom tables, form and reports.
• Technical design and prototype development using workflow to assign deliveries to PTO items requiring special handling in warehouse.
• Understand reporting requirements for returns from depositories and design and develop corresponding report.
• Develop unit test plans &scripts; Unit testing & integrated system testing and user acceptance tests in OM, Shipping and Pricing, INV and AR.
• Coordinate with offshore development team for design, development and testing.
16. Oracle Applications Implementation, Linksys, Irvine, CA Oct 2001 to Apr 2003.
Role Oracle Applications Consultant.
Project Details: This project involves implementing E-Business Suite Rel. 11i and providing post-production support for the same. .
• Analysis of Customizations, understand user requirements, prepare design documents.
• Design, development and testing of interface programs & custom extensions, customization of workflows, testing of business processes. The interfaces included import of PO, Open Invoices Import for AP and Sales Order Import.
• Wrote CV040 Mapping documents, MD050 Functional design documents and MD070 Technical Design Documents for Order Import, Customer conversion and Item Master Conversion.
• Develop test scripts, Unit Testing, Integrated system testing and user acceptance tests in PO, AP, INV, OM, Shipping and Pricing and AR.
• Design, development, customization & testing of forms and reports in OM, PO, INV, Shipping, Advanced Pricing, AP, FA, AR, GL.
• Provide technical support, Troubleshooting problems and post implementation support to users.
• Setups and configuration of OM, AR, PO and AP; Assist in period closing for AP.
17. Pride Mobility Products, Wilkes-Barre, PA June 2000 to Sep 2001
Role : Oracle Applications Consultant.
Project Details: This project involves implementing E-Business Suite Rel. 11i and providing post-production support for the same.
Responsibilities:
• Analysis of Customizations, understand user requirements, prepare design documents.
• Design, development and testing of interface programs in PO, AP, INV, OM and AR.
• Integration: Unit testing, integrated system testing and user acceptance tests; testing of business processes.
• Design, development, customization & testing of forms & reports, interface programs in OM, Shipping, PO, AP, AR, GL, INV, WIP and BOM
• Production support to users in AR, AP, FA, GL, PO, INV, OM, WIP, BOM.
• Involved in period closing and resolving issues encountered.
ERP Analyst/Business Analyst at Sonata Software Ltd, Bangalore, India Oct 1996 to Apr 2000
Implementation of Scala, ERP software for mid size companies, at various clients like Coco-Cola, Midco, Elva Induction Ltd, Ericsson, Novartis etc.
• Implementations involved financials, Manufacturing & distribution modules.
• Involved in business process mapping, documenting “As is” and “To be” processes, identifying gaps, providing solutions.
• Setups for the Supply chain, Manufacturing, Distribution modules and Financials modules.
• Design and test Customizations for reporting requirements related with Manufacturing/Financials..
• Design of Financial Reports, Financial Consolidation of the different locations, Preparing Financial statements in Foreign currency books.
• CRP, UAT and Post production support
Robert Bosch, Bangalore, India Dec 1994 – Oct 1996
Senior Officer : Customer Order & Supply Planning
• Managed Order Fulfillment and Procurement Processes;
• Demand and Supply planning for fuel injection pumps, complements and spares.
• Implemented Purchasing & Receiving Module of Standard MRP-II (CA-PRMS i.e Pansophic Resource Management System by Computer Associates) in Direct Materials.
Welspun Polyesters (I) Ltd., Mumbai, India ( Welspun group) Feb 1994 - Nov 1994
Management Trainee in the Logistics, Distribution and Materials department.
Contact this candidate