Peningo Systems, Inc.
Resume of Candidate: PEN161
Rate: email us at email@example.com for rate information or call (914) 921-3102
Oracle Transportation Management Consultant
14 years of Supply Chain and Manufacturing experience with 9 years of experience in Implementation, Rollout, Upgrade and Support of Oracle Value
Chain Planning, Transportation Management and Manufacturing Applications. Well versed in requirements gathering, business analysis, solution
architecting & leadership on complex ERP projects for Fortune 500 companies. Exposed to best practices & optimal solutions across industry verticals
viz. Hi-tech, Manufacturing and Retail. Demonstrated thought leadership with white paper declared runner up for Titan awards in Oracle Open World 2008.
• Multiple full-cycle implementations experience on modules of Oracle such as Advanced Supply Chain
Planning, Global Order Promising, Inventory optimization, Oracle Transportation Management (OTM)
• Worked on multiple rollout and support projects of Oracle VCP and OTM as Functional Consultant and
• Worked on architecting and developing Go To Market solutions involving various VCP modules like ASCP, IO, GOP, RP, Demantra and APCC.
• Architected one of the first few solutions in industry integrating Oracle ASCP, OTM, PO and OM modules.
• Expert Level Functional Knowledge in Configuring and Customizing Oracle Advanced Supply Chain Planning, Global Order Promising, Inventory
optimization, Oracle Transportation Management (OTM)
• Working knowledge of various modules of Oracle like Inventory, BOM, WIP, OPM, PO, OM,
• Experience and Expertise on discovery projects involving gathering requirements, capturing As-Is Process flows, performing Fit-Gap Analysis,
scope determination, design To-Be Process flows & providing estimates for Implementation and RICE components.
• Hands-On experience in all phases of implementation including requirements gathering, feasibility analysis, solution design, development of RICE,
testing (UT, IT, SIT, UAT), migration, cutover and Go-Live.
• Meticulous in documentation using AIM methodologies viz. BP.080 Develop Future Process Model, RD.050
Gather Business Requirements, BR.100 Define Applications Setup, MD.050 Create Application extensions functional design, CV.050 Define manual
conversion procedures, CV.060 Design conversion programs, TE.040 Develop system test script, TE.050 Develop systems integration test script, TE.070
Perform unit test,
TE.110 Perform system test
• Experience in playing the dual role of Project Manager in multiple projects. Involved continuous client interfacing, team management, project
scheduling and monitoring, bottom line on deliverables. Ensured projects to be within budget and time building excellent relationship with client IT
Directors, CIO’s and Senior Managers
• Very competent at leading support teams involved in providing workarounds, perform Impact Analysis, functional designs, debugging the
custom codes, prepare data fix scripts, follow up with Oracle on Service Requests (SRs), patch analysis and testing.
• Experience in performing due diligence for Proof of Concepts for new modules such Rapid Planning, Advanced Planning Command Center.
• Assisted technical teams in understanding business requirements, developing a solution and implementation especially in an onsite-offshore
model. Good experience in writing ad hoc SQL queries on TOAD/PLSQL to fetch the data from Supply Chain, Manufacturing, Transportation Management
and related modules.
• Conducted trainings to process leads, users/super-users & managers on various Oracle modules on a train the trainer model.
• Conducted CRP (Conference Room Pilot) for audiences across multiple geographies.
• Excellent leadership Skills: Motivating, ensuring consistency and excellence, building consensus, mentoring, performance management. Excellent
communication skills both verbal and written
• Strong team player in educating and empowering the team members with required knowledge and go-getter.
• Adherence to Standards and Processes: Ensure compliance as per standards & best practices laid down for the projects. Able to bring best
practices, change management & process orientation into the project.
• Actively involved in D2D – Demand to Deliver – solution which is Oracle Practice level initiative within the Organization. D2D is Oracle applications
based, out of the box solution for Hi Tech Industry; jointly developed with Oracle; covering the full breadth of demand and supply value chain; through 8
seamlessly integrated business sub processes (chevrons). Leading ‘Production and Operation Planning’ Chevron which comprises of Oracle ASCP,
Rapid Planning, Production Scheduling, Advanced Planning Command Center and Inventory Optimization. This chevron closely interacts with other
chevrons namely ‘Sales and Operations Planning’ and
‘Demand Sensing and Shaping’ which are based on Demantra.
• Involved in various pre-sales pursuits for existing and new clients. Activities include understanding customers’ pain areas, discussing various
solution options, recommending solutions involving Oracle modules, getting use cases from the customers, preparing and conducting system demos to
the clients. Also involved in preparing proposals for the RFPs received from clients.
• Bachelor of Engineering (Mechanical) – June 1997
• Post Graduate Diploma in Materials Management (PGDMM) - December 2003
• Certified in Production and Inventory Management (CPIM) - September 2004
• Permanent Resident in United States
Functional Skills : Supply Chain, Manufacturing
Oracle Softwares : Oracle VCP R12/11i Modules (ASCP, IO, GOP, RP, APCC, Demantra), OTM, PO, OM, Inventory, WIP, BOM, OPM, Application
Developer, PL/SQL, SYS Admin, SQL*Plus, Data Loader
Databases : ORACLE 8i, 9i, 10g, 11i, MS-Access, SQL Server
Tools : TOAD, SQL Developer, MS Office Suite, MS Project, Excel
Operating Systems : Win 2007, XP, Win 2000, NT, UNIX, Sun Solaris
Clientele : Cisco Systems, Starbucks Corporation, Sony Corporation, Kraft Foods
Cisco Systems, San Jose, CA December 2011 till Date Project Description: Cisco Systems, Inc. is
the worldwide leader in networking for the Internet. Supply Chain – Large Scale Services (SC – LSS) project focuses on transitioning from multiple Oracle
instances to single R12 instance of Oracle for Order Management, Manufacturing, Procurement, Order Promising and Scheduling
Role: Plan track lead responsible for implementing multilevel, lead time based and supply-based, ATP and CTP
capabilities using Oracle ASCP and GOP R12. It involves setting up Oracle R12 planning instance and using it partially for order promising and scheduling
while continuing the use of Oracle 11.5.6 instance, eventually transitioning order promising and scheduling functionality completely to R12. SC-LSS Plan
Track also involves designing processes and solutions around proactive and situational backlog management.
Conducting CRPs to demonstrate functionalities and solution multilevel, lead time based and supply-based, ATP
and CTP capabilities using Oracle R12 ASCP and GOP.
Leading a team of consultants engaged in the project and located onsite and offshore.
Designing functional specifications for interfaces, extensions and reports for integrating various instances of Oracle used for Order Management,
Manufacturing, Planning and Scheduling and Kinaxis Rapid Response used for Supply Planning.
Reviewing technical design documents, coordinating development of the RICE objects.
Reviewing Test Plan, Test Cases and Test Data preparation and providing feedbacks. Ensuring quality testing of the solution by the QA team.
Driving User Acceptance Testing to ensure adequate user involvement and testing of the solution.
Working with Oracle to get issues with standard functionalities fixed. Following up on SRs, analyzing and testing patches provided by Oracle.
Designing data cleanup and conversion approach for entities like Item Attributes, Sourcing Rules and
Conducting Proof of Concepts and designing solutions for proactive and situational backlog management using
Oracle Rapid Planning (RP) and Global Order Promising (GOP).
Designing to-be solution architect for integrating various Oracle and non-Oracle instances for performing Order
Scheduling and Backlog Management.
Starbucks Coffee Company, Seattle, WA August 2007 to November 2011
Project Description: Starbucks is the largest Global Business Systems Solutions (GBSS) was a major business transformation program at Starbucks. It was
a multiyear, multi geography, business transformation and end to end implementation project of various modules of Oracle ERP like Inventory, Order
Management, Purchasing, Value Chain Planning, Process Manufacturing, Discrete Manufacturing, Financials etc. It involved design, development and
testing of custom features to add to the standard product features. The system was developed and rolled out in multiple phases across various locations
in Europe and Middle East, Asia Pacific, North America
Role: Planning and Forecasting track lead responsible for successful implementation of Oracle R12 Value Chain Planning modules like Advanced Supply
Chain Planning (ASCP), Global Order Promising (GOP) and Inventory Optimization (IO) across multiple geographies.
Track lead for Planning and Forecasting track, which included Oracle Advanced Supply Chain Planning, Global Order Promising, Inventory
Optimization, and Manugistics. This was a Global implementation involving multiple geographies, such as EMEA, North America and Asia-Pacific.
Managing a team of professionals – onsite and offshore – engaged in design, development, testing, training, deployment and support activities
being undertaken as part of GBSS.
Coordination with different tracks comprising of Starbucks employees and multiple other vendors.
Interacting with Starbucks IT and Business Leadership and providing regular updates, suggestions and highlighting risks.
Worked with different teams in different geographies to understand their requirements in the planning and forecasting space.
Worked on Requirements gathering and analysis for new functionalities in above modules.
Reviewed the AS-IS process flows and worked with the process Leads to refine the TO-BE Process Flows.
Conducted the Solution Design Workshops for varied audiences such as the track leads, solution architects, process owners.
Worked on the Gap Analysis and proposed workarounds to avoid multiple customizations.
Designed custom solutions wherever necessary to meet Starbucks’ complex business requirements. E.g. designed solutions for Remaining Shelf
Life Management, Inventory Segmentation across business units, Safety Stock Management.
Designed processes for supply planning of Make and Buy finished goods and components.
Designed solution for Holistic Supply and Transportation Planning by integrating ASCP, OTM and EBS.
Worked on the high-level designs and detailed functional designs for the identified RICE objects
Reviewed the technical designs and provided timely feedback to enable quality deliverables from the development team.
Designed data cleanup and conversion approach for repetitive conversion of various entities like Item Attributes, Safety Stock, Sourcing Rules
and Assignments from legacy system to Oracle during various phases of the project and during rollouts to various geographies.
Provided guidance to testing team during different phases for testing such as System Testing, Integration Testing, Load Testing and Certification
Participated in Change Management process, Training Material Preparation, providing Super User and End User
Participated in Test Planning and Test Execution of various end to end flows within Plan Track across tracks.
Assist in Go Live activities including Instance preparation, Mock-Cutover, Production Cutover, Functional check out of setups and data and post
Go Live checkout.
Tuning output of ASCP Plan to meet user expectations of accuracy level. Writing ad-hoc queries, extracting data, preparing pivot tables to be used
for analysis of plan output.
Performance tuning of complete Planning cycle (including Data Collections, Plan Output, Custom programs) to avoid minimum downtime to various
Writing ad hoc simple to medium SQL queries to fetch the data from database tables for data verification during
setup, testing and plan output analysis.
Prepared several re-usable artifacts (solution design documents, training material, configuration workbooks and know-how papers) for project
Kraft Foods, Madison, WI September 2006 to July 2007
Project Description: Move Optimization System for Transportation was an end to end implementation project to implement Oracle Transportation
Management OTM 5.5 (Formerly GLog) at Kraft Foods. Freight Payment, Load Consolidation and Cooperative routing functionalities were implemented
and rolled out to multiple sites.
Role: Business Analyst
Gathered requirements and translating business requirements into systems specifications.
Configured OTM for enabling Freight Payment, Shipment Planning and Cooperative Routing functionalities.
Designed, configured and tested automation agents.
Prepared integration test plan and performing integration testing.
Designed reports related shipment planning and cooperative routing.
Designed programs to upload data from excel sheets to Oracle Database for various entities like Service Provider and Equipment Capacities.
Built interfaces to feed data from OTM to legacy tool used for collaborating with Transportation Service Providers.
Sony iSemiconductors, Fukuoka, Japan July 2005 to August 2006
Project Description: This project aims at upgrading Oracle ASCP from 11.5.8 to 11.5.10 and providing post go-live support.
Role: Lead Functional Analyst
Unit Testing of new functionalities in 11.5.10 and documenting results
Preparing presentations for Conference Room pilot (CRP) and conducting CRPs
Plan comparison, analysis and tuning to ensure Plan output form ASCP 11.5.10 is similar to or better than ASCP
Conducting User Acceptance Testing. Resolving issues raised by users during UAT.
Coordinating with Oracle to get issues related to standard functionalities resolved. Explain issue to Oracle Support and Development by means of
OWC. Following up with Oracle to get patches to fix product issues. Testing of patches provided by Oracle and recommending application of patches.
Configuring Oracle ASCP 11.5.10.
Preparing implementation plan and carrying our cutover activities.
Post Go-Live Production Support for system stabilization.
Monitoring Plan Run Cycle and fixing any issues arising in the process to ensure timely plan availability to the users.
Production support to resolve issues reported by users within predefined SLAs based on severity of the issues.
Explaining product functionalities/solution to uses whenever necessary.
Sony FTV, Tokyo, Japan December 2004 to June 2005
Project Description: This project aims at implementing Oracle ASCP for the Flat TV business of Sony Electronics.
Role: Functional Analyst
Requirement Gathering and understanding business processes.
Preparing As-Is business process flows explaining current business processes.
Identifying Standard Functionalities of potential use to the client and Unit Testing of these functionalities in Oracle
Preparing CRP Test Plans and data requirements. Setting up client data in the system and running ASCP Plans.
Conducting CRP, executing test plans and documenting test results.
Conducting trainings for users on navigation and basic functionalities in Oracle ASCP.
Organization: Oracle India Pvt. Ltd. – Hyderabad, India (www.oracle.com)
Duration: August 2003 to October 2004
Designation: QA Engineer
Working closely with Product Management team & development team during the preparation of High Level Design
(HLD) & Detailed Level Design (DLD) respectively, based on Business Requirement Document (BRD).
Understanding the new features/enhancements after studying above documents.
Applying functional expertise and coming up with business flows/scenarios relevant to the new
Preparing System Test Plans in the form of Test Outline and Test Script.
Executing various business flows on Oracle Applications during System Testing.
Validating the observed behavior against expected functionality and logging bugs.
Coordinating with other members of the team.
Organization: Godrej & Boyce Mfg. Co. Ltd. – Duration: November 2000 to August 2003
Designation: Deputy Manager – Systems & Planning
Carrying out material and production planning activity for the entire division using various planning engines in Baan like MPS, MRP, PRP and DRP.
Ensuring timely availability of material for production from internal suppliers.
Monitoring and controlling raw material, WIP and Finished Goods inventory in order to reduce inventory-carrying cost.
Key user and system administrator for BaaN system.
Imparting training of the BaaN system on various modules like SFC, EDM, Planning, Purchase, Distribution and
QMS to end users in order to ensure overall understanding of the system & proper implementation.
Trouble shooting of queries raised by various end users & liasoning with software division, Godrej Infotech Ltd whenever required.
Devising and implementing SOP’s for various activities carried out in the plant.
Generating and submitting periodic MIS reports on various pulse parameters like labor efficiency, production, dispatches & inventory
Organization: Godrej & Boyce Mfg. Co. Ltd. –
Duration: November 1997 to October 2000.
Designation: Executive – Vendor Development
Identifying components & subassemblies to be off-loaded.
Developing new and existing vendors.
Negotiating with vendors.
Providing technical support to vendors to improve quality of items received from them.
Placing Purchase Orders on vendors and issuing raw materials to them.
Ensuring timely receipt of various components and sub-assemblies as per the requirements of customer departments, in order to ensure
Periodically reconciling stocks lying with vendors.
Ensuring minimum inventory in order to reduce inventory-carrying cost.