We provide IT Staff Augmentation Services!

Oracle Planning Functional Consultant Resume

4.00/5 (Submit Your Rating)

Cleveland, OH

PROFESSIONAL SUMMARY:

  • Over 8.5 years of total IT experience including experience execution of 4 Project lifecycles in Oracle Applications implementations including the exposure to e - Business Suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
  • Over 8 years of extensive experience on Oracle Supply Chain Manufacturing Applications consulting including Quote to Cash and Procure to Pay Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional roles.
  • Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
  • Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
  • Experience with Oracle Business Accelerators for e-Business Suite Release 12.
  • Experienced in working with Oracle Applications Release 12
  • Expertise in Advanced Pricing (QP), Order Management (OM), Costing (CST), Shipping (WSH), Inventory (INV), Purchasing (PO), Enterprise Asset Management (eAM), Oracle Transportation Management (OTM), Advance Supply Chain Planning (ASCP), Demantra, Rapid Planning, Work in Process (WIP), Bills of material
  • Possess strong knowledge of Value Chain Planning and Supply Chain Management modules of Oracle applications, with concentration on INV, Quoting, i-Procurement, OM, Advance Pricing (QP), Trade Management (OTM), PO, COSTING, SLA, AP, AR, combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
  • Worked on the configurations and setups of
  • Experience with the return process in Order Management, OTM, Reverse Logistics flow and integration to Depot Repair.
  • Extensive experience in CRM Modules of Service Contracts and Install Base.
  • Extensive experience with the Order to Cash and Procure to Report business flows.
  • Formulated solution design and implementation strategy based on client requirements.
  • Configured the application based on solution design, performed gap analysis and designed workaround solutions.
  • Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
  • Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
  • Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.

SKILL:

ERP APPLICATIONS: Oracle Applications 12.1.X, 11.5.X, Oracle EBS Master Data Management (MDM) module of Product Information Management (PIM), Supplier Data Hub (SDH), and Customer Data Hub (CDH), Financials (AR, AP, GL, FA and Cash Management), Enterprise Asset Management EAM and Supply Chain Modules of OM, OTM, PO and Inventory

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Oracle Planning Functional Consultant

Responsibilities:

  • Worked on the Functional mapping of data Conversions & Enhancements for INV, WIP, BOM, ASCP, APCC, Demantra, VCP, GOP modules.
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for INV, WIP, BOM, ASCP, APCC, Demantra, VCP, GOP
  • Worked on the Outside Processing Functionality in Oracle WIP.
  • Performed all the setups and configurations for BOM module.
  • Worked on setting up the Approval Hierarchies in Purchasing Module.
  • Implemented Outbound interfaces for INV and OM modules.
  • Worked on Demantra modules of Demand Management, Advance Forecasting and Demand Modeling, Trade Promotion Optimization, Real Time Sales and Operations Planning and Predictive Trade Planning.
  • Conducted data analysis and forecasting session for demand management relevant to Oracle Demantra
  • Tested and define support procedure for Oracle Demantra Module
  • Worked on Demantra Real Time Sales & Operational Planning (RTS&OP) and Demand Management. Collected base line data, identify performance and planning exceptions.
  • Worked on Advanced Forecasting and Demand Modeling and helped to define casual factor in Oracle Demantra
  • Worked on the setups and configurations for OM, Purchasing, i-Procurement, AR, Quoting, Shipping, Advance Pricing and Inventory modules
  • Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
  • Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
  • Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
  • Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
  • Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
  • Provide inputs and part of the team for new solution.
  • Test various business scenarios in the new system.
  • Interact directly with end users, infrastructure teams, and project teams.
  • Functional design of the Conversion / Integration programs.
  • Progress the track thro CRP1, CRP2, UAT & Go Alive.
  • Provide user training & documentation

Confidential, Itasca, IL

Oracle Planning Functional Consultant

Responsibilities:

  • Worked on the setups of the Order Management module - defining the processing constraints, defaulting rules, header and line flows, transaction types, setting up credit checking, etc.
  • Worked on the setups of Modifiers and Qualifiers, price breaks, volume based discounts in Oracle Advance Pricing
  • Worked on the EDI E-Commerce Gateway - for 850 - PO Inbound and Outbound,855 - PO Acknowledgement,856 - Advance Shipment Notice inbound and outbound and 810 - Outbound Customer Invoice
  • Worked on the setups and configurations on the Rapid Planning module - defining the Simulation Sets, Rapid Planning Solver, Data Collection, defining plans, release process, interfacing of oracle Demantra forecasts to the rapid planning server, releasing planned orders, function and data security, etc.
  • Involved in customizations of Oracle Transportation Management - Business Process Monitor, Automation Agent, Saved Query, Saved Condition, Complex Expression, Action Check, User Access, Custom Action, Smart Link and Manager, Screen Set and Menu Layout.
  • Designed various tender and general notifications by creating XSL, configured Style sheet Profile and Out XML Profile in Oracle OTM
  • Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Worked on the setups of the Purchasing module - defining the Approval hierarchies, document types, defining the financials, receiving and purchasing options.
  • Worked on the configurations of the i-Procurement module - worked on the direct and transparent punch-out’s
  • Work on rolling out the Demantra (with Sales & Operations Planning) solution to new operating unit - Replacement Parts Division.
  • Handle requirements gathering, fit-gap, to-be process design, and high level project planning.
  • Design and build the Demantra integrations and customizations/extensions specific to the new operating unit.
  • Carry out Data Mapping for data conversions.
  • Understand Division-specific business processes from the end users and implement the same.
  • Responsible for training the end users on the new processes and facilitated on-the-job training.
  • Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
  • Worked on the setups and configurations for OM, OTM, Rapid Planning, Demantra, Purchasing, i-Procurement, ASCP, Demantra and Inventory modules
  • Worked on the setups of ASCP and GOP Modules - setting up the Source definition, Destination definitions, plan parameters, supply and demand sources, etc.
  • Worked on setting up constrained and unconstrained plan parameters in oracle ASCP
  • Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
  • Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
  • Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
  • Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
  • Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
  • Provide inputs and part of the team for new solution.
  • Test various business scenarios in the new system.
  • Interact directly with end users, infrastructure teams, and project teams.
  • Functional design of the Conversion / Integration programs.
  • Progress the track thro CRP1, CRP2, UAT & Go Alive.
  • Provide user training & documentation

Confidential, Atlanta, GA

Oracle OPM Functional Consultant

Responsibilities:

  • As a OPM Functional Consultant implemented the Order to Cash Business flows including OPM OM, OPM INV, OPM PO, OPM Quality and OPM Costing modules.
  • Worked in the configuration of the OPM OM, OPM INV, OPM PO, OPM Quality and OPM Costing modules.
  • Worked on Oracle ASCP to setup Constrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
  • Worked on Oracle Engineering module - setup ECO/NCO processes, setup the profile options, entering employees, defining change order types, ECO Departments, Approval Lists, defining reasons, defining priorities, auto implement manager.
  • Worked on Demantra modules of Demand Management, Advance Forecasting and Demand Modeling, Trade Promotion Optimization, Real Time Sales and Operations Planning and Predictive Trade Planning.
  • Conducted data analysis and forecasting session for demand management relevant to Oracle Demantra
  • Tested and define support procedure for Oracle Demantra Module
  • Worked on Demantra Real Time Sales & Operational Planning (RTS&OP) and Demand Management. Collected base line data, identify performance and planning exceptions.
  • Worked on Advanced Forecasting and Demand Modeling and helped to define casual factor in Oracle Demantra
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in i-Expense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate i-Expense access, assigning signing Limits, etc
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Accounts Receivables and Account Payable Module
  • Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options

Confidential, Omaha, NE

Order to Cash Functional Analyst

Responsibilities:

  • As a SCM Functional Consultant implemented the following modules Purchasing, Channel Revenue Management, OTM, Inventory, Procurement Contracts, OM, Advance Pricing, Shipping
  • Worked on the Functional mapping of data Conversions & Enhancements for Purchasing, Channel Revenue Management, OTM, Inventory, Procurement Contracts, OM, Advance Pricing, Shipping modules.
  • Preparing BR100, TE40, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on the configurations of the OTM Module.
  • Setup the Approval Hierarchies in Oracle Purchasing module.
  • Worked on the setups Channel Revenue Management - setting up the customers and buying groups, calendars, time structure, etc.
  • Involved in troubleshooting issues on Auto Invoice Import Program.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • I-Procurement - Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
  • Provided with useful training to the users in GL, AP, OM, INV and PO Modules.
  • Created FSG Financial Reports critical to company’s business process.

Confidential, Omaha, Nebraska

Order to Cash Functional Analyst

Responsibilities:

  • Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units.
  • Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
  • Worked on the Financial modules of OM, INV, AR, PO
  • Performed all the setups for OM, INV, AR, PO modules.
  • Worked on the Revenue Recognition Process in Oracle AR module.
  • Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
  • Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
  • Pricing Business Requirement Study and designed / documented Functional Specification.
  • Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
  • Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
  • Conducting Pre Project Review & Post Project Review.
  • Providing Post Implementation support
  • Worked for the Category & Mapping data migration to meet the go alive deadline.
  • Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.

Confidential, CT

Oracle Functional Analyst- SCM / Order to Cash

Responsibilities:

  • Participated in Scope analysis for supply chain domain
  • Collated the issues in the current version and requirements in the latest version
  • Prepared AS IS and TO BE process documents
  • Configured additional Setups in the upgrade version
  • Developed Test scripts and successfully completed CRP 1 with Localization
  • Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization
  • Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases
  • Configured Auto-Sourcing rules, Approved Supplier List (ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench
  • Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process
  • Designed and developed all the setups and configurations for Inventory management.
  • Setup all the planning functionality for Inventory
  • Performed all Organization setups for Inventory
  • Performed all setups for Cycle Counting in Inventory
  • Performed all setups for ABC Analysis
  • Performed all setups for Items, Categories, Catalogs, etc.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, AR, GL and FA

We'd love your feedback!