Oracle Scm Techno Functional Consultant Resume
Bothell, WA
SUMMARY:
- Functional Distribution and Supply Chain Consultant with over 8.3 years of total industry experience including all years on core ERP Applications. Experience includes execution of 3 full lifecycle 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 7 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 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
- Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, i-Procurement, OM, ASCP, BOM, WIP, Advance Pricing (QP), PO, INV, WIP, COSTING, AP, AR, combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
- Experience with Oracle Process Manufacturing (OPM) - OPM INV, OPM OM and OPM PO
- Experience with the return process in Order Management, 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.
- Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
- 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.
- Specialization in Procure to Pay and Order to Cash business flows
TECHNICAL SKILLS:
ERPEBusiness Suite: Oracle Applications Release 12/11.5.8/10.7/9.4 (SQL, TOAD, PO, INV, WIP, AP, SYS ADMIN, AOL, OM)
PROFESSIONAL EXPERIENCE:
Confidential, Bothell, WA
Oracle SCM Techno Functional Consultant
Responsibilities:
- Configured the OPM INV, OPM OM and OPM PO module.
- Configured Taxware Enterprise for Oracle 11i in end-to-end implementation.
- Lead software team to develop customizations for Taxware Enterprise applications.
- Designed and produced reports in Business Objects for monthly tax reporting.
- Implemented “Single European Payments Area” enhancements in Oracle Accounts Payable and HRMS to allow Oracle applications to produce Payment XML messages compliant to European Union legislation.
- Performed all the setups for OM, WIP, ASCP, BOM, AR and INV modules.
- Worked on the WIP setups like WIP Parameters, WIP Accounting Classes, WIP Profile Options, Production Lines, Repetitive Assemblies, Schedule Groups, Discrete Execution Workstation, etc.
- Worked on Oracle ASCP module - setting up the Source definition, Destination definitions, plan parameters, supply and demand sources, etc.
- Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
- 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.
- Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
- Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
- 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.
- Collected and populated AP Supplier Bank and Bank Branches data.
- Created concurrent program to print daily price list and price modifier record changes.
- End-to-end testing for new Web Order Entry interface and Oracle Order Import.
- Built concurrent program to report monthly revenue by raw materials for BOM items.
- Daily support work for Oracle issues in Order Management, AR, AP, Inventory.
- Worked on the setups of Oracle WMS - defining the WMS Organizations, WMS Sub Inventories, configured the rules engine - defining the put away, picking, Task type Assignment, Cost Group Assignment, Picking Rule allocation, etc.
- Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time
- Available to Promise (ATP) and Auto-Scheduling functionality configuration reduced the Scheduling process time and enhanced customer service level
- Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
- Internal Sales Order/Internal Requisition process was configured to establish a simplified Inter company sales across operating Units
- RMA and Approval Management functionality setup reduced the process time in Customer Returns management
- Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
- Established a Item Category and Item Cataloging for their products.
- Defined a ABC Analysis and Cycle Count
- Established Customer Item and Customer Item Cross Reference
- Established a process for smooth month end closing procedure in Inventory
- 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
- Worked on Modifiers and Qualifiers setups
- Worked on configuring the Primary and Secondary price lists
- Worked on setting up price breaks
- Defined the coupons for discounts
- Used the Get Custom price API for publishing price to an external system
Confidential, Billerica, MA
Oracle SCM Techno Functional Consultant
Technology: PO, i-Procurement, AP, INV, OM
Responsibilities:
- Authored and executed test plans to ensure successful implementation. Actively involved with Unit testing, QA, Integration and Regression testing, and UAT.
- Resolved/debugged various issues during process mapping, development, unit testing, UAT and postproduction support.
- Liaison with Oracle support, helpdesk, business process owners, developers and major stakeholders. Facilitated communication between the business unit and IT from initial requirements definition to final implementation.
- Developed several MD050, Functional Specification Documents (FSD) and Technical Specification Documents (TSD)
- Support involves starting from Order entry to order fulfillment which involves customized configurator for Order entry, BOM, WIP, Requisition, PO, OSP, i-Supplier Portal, Drop shipments, Receipts, Invoicing, Qualifiers, Modifiers, Price breaks, payments receiving, transfer to GL, Inter company transactions etc.,
- Worked on the configuration of the PO, i-Procurement and AP modules and worked on the integration of Quoting with OM.
- Flow Testing for SCM Modules (Consignment INV, AR, OM and PO) to make sure flow is working without any issues.
- Setting up of complete Procure to Report cycle setups.
- Part of S&M team & assisted the business for understanding the new Dual Build / Dual Pickup process flow in the business transformation phase
- Worked on catalog setup and management in i-procurement
- Performed master data sets for Procurement including approved supplier list, sourcing rule, custom BPO conversion for production cutover activity
- Define Supplier & Item Combination, Sourcing Rule, Approved Supplier List
- 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
- Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
- Established a Item Category and Item Cataloging for their products.
- Defined a ABC Analysis and Cycle Count
- Established Customer Item and Customer Item Cross Reference
- Established a process for smooth month end closing procedure in Inventory
Confidential, Los Angeles, CA
Oracle SCM Business Analyst
Responsibilities:
- Interaction with business users as a part of As - Is Study for clients legacy application D3 Pick for (Oracle Purchasing, Oracle Payables, Order Management, Configurator, Service Contracts, Install Base, Inventory
- Setup the Work Execution flow and Preventive Maintenance Flow in Enterprise Asset Management.
- Worked on the Revenue Recognition process in AR including setting up the deferred revenue rules.
- Performed all the setups for P2P modules including Purchasing, Inventory and AP.
- Setup Modifiers/Qualifiers in Advance Pricing.
- Business Requirement, Scope Management Documents Preparation
- Fit Gap Analysis for (Oracle Purchasing, Oracle Payables, Order Management, Configurator, Service Contracts, Install Base, Inventory) & preparation for Fit Gap Document
- To Be High Level & Detail Documents Preparation
- Module Configuration Documents Preparation Oracle Purchasing, Oracle Payables, Order Management, Configurator, Service Contracts, Install Base, Inventory modules setup
- User Training as a part of CRP1, CRP2, CRP3
- Data Migration requirement gathering for (BOM, Routings, Items, Open PO, Suppliers)
- Data Migration functional specification documents creation
- Design Creation & Validations
- Application testing w.r.t individual module
- Issues Tracking & Customer Sign off
Confidential, Miami, FL
Oracle SCM Techno Functional Consultant
Responsibilities:
- Worked on the entire Procure to Pay business process.
- Performed all of the setups for i-Procurement, PO, AP and GL
- Developed several enhancements to the Business Processes on the Procure to Pay side.
- Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
- I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
- Support Production issues on a day to day basis including month end closure p1 issues
- Implementation and support of Cash Management and Account Payable Module
- Functional Support for SOX and PWC Audit
- Integration and Implementation of Foreign exposure through Fire Apps external software with Oracle GL
- 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 Setup and Support of Markview170 System.
Confidential
Oracle Applications Techno Functional
Environment: Oracle E-Business Suite 11.5.10, Manual Testing, and Windows 2003 server.
Responsibilities:
- Worked as a functional Consultant to implement Oracle Application 11.5.10.2 involving PO, i-Expense, i-Procurement, AP, AR, GL Modules Meet with customers to understand their system and service requirements and then Writing Functional Test Scripts for the end to end testing, coordinating with the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.
Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, i-Procurement, AR, GL