Peningo Systems, Inc.

Resume of Candidate: PEN161


Rate: email us at
info@peningo.com for rate information or call (914) 921-3102

Oracle Transportation Management Consultant

EXTRACT:

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.

SUMMARY:

•         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
Solution Architect.
•         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.



EDUCATION:

•         Bachelor of Engineering (Mechanical) – June 1997
•         Post Graduate Diploma in Materials Management (PGDMM) - December 2003
•         Certified in Production and Inventory Management (CPIM) - September 2004



WORK AUTHORIZATION:

•         Permanent Resident in United States



SKILLS:


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

PROJECT EXPERIENCE:


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.
Responsibilities:
    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
Assignments.
    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.
Responsibilities:
         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
testing.
    Participated in Change Management process, Training Material Preparation, providing Super User and End User
Training.
    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
geographies.
    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
teams.

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
Responsibilities:
    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
Responsibilities:
         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
11.5.8.
         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
Responsibilities:
         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
ASCP
         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.




PROFESSIONAL EXPERIENCE:

Organization: Oracle India Pvt. Ltd. – Hyderabad, India (www.oracle.com)
Duration: August 2003 to October 2004
Designation: QA Engineer

Responsibilities
         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
features/enhancements.
         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

Responsibilities
         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

Responsibilities
         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
smooth production.
         Periodically reconciling stocks lying with vendors.
         Ensuring minimum inventory in order to reduce inventory-carrying cost.
Back to Peningo Sample Resumes