SUMMARY

• Oracle Manufacturing Functional Consultant with more than 8 years of aggregate Experience. Extensive experience with being a Functional Expert in SCM modules of PO, i - Procurement, OM, INV, BOM, WIP, ASCP, Costing, Advance Pricing, MSCA, Shipping Worked with reputed Clients from different countries Domain expertise spans across Manufacturing, Materials, Logistics, and Distribution Worked with various teams successfully across multiple projects globally Good at building and managing customer relationship. Passionate to achieve goals with profitability and customer delight in mind
• Over 8 years of experience in Supply Chain Management and IT Consulting.
• Core Team-member during Oracle Application Implementations for several clients
• Extensive experience with functional tracks
• Extensive experience with the Procure to Pay and Order to Cash Business flow.
• Developed Functional Specification Documents (FSDs), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
• Developed the following AIM Documents BR100, MD050, RD020, RD030, TE030, TE040, etc.
• Experience with Oracle Fusion Cloud Supply Chain (Product Master Data Management, Inventory Management, Cost Management) and Fusion Procurement (Purchasing, Self-Service Procurement, Sourcing and Procurement Contracts)
• Primary Skill set: Excellent Functional experience in PO, i-Procurement, OM, INV, BOM, ASCP, APCC, WIP, MSCA, Quality, WMS, Costing, Advance Pricing, Shipping
• Extensive experience with Approval Manager Engine (AME)
• Good knowledge and a high level of expertise in the functional aspects of the Oracle Apps Purchase, Inventory, Advance Pricing, Order Management, MRP and Daily Business Intelligence Modules.
• Knowlede on Oracle Receivables, eBiz tax, Collections.
• Strong in Oracle Apps Implementation - Business Process Mapping, Gap Analysis, Test cases, Data Migration, Localization setups
• Proven ability to develop creative solutions to Material flow/Supply Chain management challenges

TECHNICAL SKILLS

Oracle Applications: PO, i-Procurement, OM, INV, BOM, WIP, ASCP, MSCA, Costing, Advance Pricing, Shipping modules

Others: Toad, MS Office (Word/Excel/PowerPoint), Minitab 12

PROFESSIONAL EXPERIENCE

Confidential, Green Bay, WI

Oracle Manufacturing Functional Analyst

Responsibilities

• Worked on the Plan to Manufacture track as a Functional consultant for SGP Operating Unit including gathering the requirements from the user and understanding their business model the modules worked on includesPO, i-Procurement, WMS, MRP, OM, INV, BOM, ASCP, WIP, MSCA, Quality, Costing, Advance Pricing, Shipping
• Worked on eBusiness Tax and integration with Financial modules.
• Worked on all the Business Analysis of developing the GAP Analysis, Business Requirement Documents (BRD’S), Functional Specification Documents (FSD), MD050, BR100, TE020, Te030, etc.
• Gathered Requirement for Conversion Programs Invoice, Receipts, Journals Conversion, and Customer Addresses Conversion.
• Performed all the setups for AME - setting up AME Rules, Attributes, Conditions, Notifications, Parallel Approval process, etc.
• Developed the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all the customizations and data conversions.
• Worked on the PO, i-Procurement module - setting up the i-Procurement stores, configuring the catalog management for i-Procurement, setting up the approval hierarchies in PO, defining the ASL and Sourcing rules in PO module.
• Reviewing Functional Specifications / Change requests with the client.
• Worked on the supporting all of the new features for the Procure to Pay track from an R12 perspective.
• Communicating the requirements to the technical team
• Preparing design document as per the functional requirements
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting the users with the User Acceptance Testing (UAT)
• Taking part in the review of test cases and giving necessary inputs.
• End-user training
• Updating the client on the status of the project at offshore, almost everyday.
• Reviewing and giving inputs on all the developed components, Unit test Plan and Unit test report.

Confidential, St Louis, MO

Oracle Manufacturing/SCM Functional Analyst

Responsibilities

• As a Plan to Manufacture Functional Consultant implemented the modules including PO, i-Procurement, OM, WMS, INV, BOM, WIP, Advance Pricing, Shipping modules.
• Worked on developing a Booking, Billing and Backlog system based on OM, Shipping and AR data.
• Performed Requirement and Gap analysis.
• Configurations and Setups for PO, i-Procurement, OM, WMS, INV, BOM, WIP, Advance Pricing, Shipping modules
• Setup WMS Module including defining of all of the warehouse, warehouse orgs, items, lots, serial control, Interfacing WMS with an external warehouse.
• Worked on the COGS and DCOGS Functionality in Oracle.
• Worked on the setups of the Modifiers, Qualifiers, Custom Attributes, Pricing formulas, Attribute mapping in oracle Advance Pricing module.
• 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.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Pre-upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues

Confidential, Greenwood Village, CO

Oracle SCM Functional Consultants

Responsibilities

• Designing Solution for Supplies Management Processes for the Plan to Manufacture track
• Re-designing Solution for Master Data Registry
• Developed all of the Functional Design Documents (MD050), Functional Requirements Document (FSD), Business Requirement Documents (BRD), TE030 and TE040, BR100, etc.
• Responsible for Setup and Configuration of all Distribution modules including PO, i-Procurement, OM, WMS, INV, BOM, WIP, Advance Pricing, Shipping
• Responsible for Testing and documentation
• Designed a solution to manage Inventory Items for the entire flow from Requisition-to-Receipt and Receipt-to-Expense for 5 different Inventory Organization
• Designed an automated replenishment process using Oracle’s Replenishment count process. Replenishment Count Data is fed to the Inventory Interface tables using handheld scanners
• Designed the process for UOM definition and conversion for the Items. CHP had a requirement for 297 different package combinations, which required UOM conversions.
• Reviewed and extended the use of purchasing data (e.g., Requisition templates, categories, BPAs, ASL, etc) and made these data structures available to i-Procurement
• Trained the OM Users on OM Search(Quick and Advanced) functionality in order to quickly identify the Item to Sales order match
• Business process modeling integrating AESM with Factory.
• Data Flow Model.
• Monitored the interface between OM and Ecommerce site.
• Functional design to Capture the Data, Outbound / Inbound Programs processes
• Design necessary B2B Notifications
• Oracle updates process design from B2B response of Factory.
• Functional design of the B2B Reports thro Business Objects.

Confidential, Nashville, TN

SCM Functional Consultant

Responsibilities

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Worked on the localizations for Brazil, Span and US and UK.
• Implemented financial modules: PO, i-Procurement, OM, WMS, INV, BOM, WIP, Advance Pricing, Shipping integrated with internal e-Procure system
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Implemented Party Relationships in the TCA.
• Implemented the Data Quality Management in TCA.
• Implemented the D&B Integration for TCA.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created New FSG Reports, using mutli-currency features including foreign currencies for multi org structures.
• Implemented internal control features using Form Personalization’s for modules GL, AP, AR.
• Implemented Inbound Regular Invoice interfaces for AP & AR using XL spread sheet.
• Implemented Automatic upload & Bank Reconciliation functionality in CM.

Confidential ., Detroit, Michigan

Oracle SCM Functional Consultant

Responsibilities

• Order Management/Advance Pricing
• Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time
• Setup Advanced Pricing system to simplify the Pricing process using automatic modifiers, Discounts and Promotions
• Defined several custom Modifiers and Qualifiers in Advance Pricing.
• Setup Dynamic Formulas for Advance Pricing.
• Simplified the Freight Charge application process by setting up formula to convert Freight Cost to Charge and modifiers along with associated qualifiers
• 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 managementInventory
• Designed and developed all the setups and configurations for Inventory management.
• Setup all the planning functionality for Inventory.
• Performed all the Organization setups for Inventory.
• Performed all the setups for Cycle Counting in Inventory
• Performed all the setups for ABC Analysis.
• Performed all the setups for Items, Categories, Catalogs, etc.
• 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

Environment: Oracle 11.5.10

Confidential, San Diego, CA

Functional Consultant

Responsabilités

• Responsible for understanding the Business Processes and Knowledge Transition
• Responsible for Testing and documentation
• Responsible for Training to the Operations Team
• Involved in modules OM, INV, Advance Pricing and AR.
• Participated in System analysis and gathered requirements.
• Worked on Order to Cash Process, Internal orders process.
• Creating the items, shipping Network, Locations, Conducted Miscellaneous transactions, internal customers, price list, Requisitions, pick release against sales orders, ships confirms for sale orders. Defined Sales Credits setups.
• Designed general setups like defaulting rules, processing constraints, pick release rules, shipping setups, DFFs and Transaction types.
• Designed price lists for different currencies, Modifiers and qualifiers.
• Define pricing formulas. Attaching pricing attributes to modifier lines.
• Define a price list and adding items to price list. Define a multi currency conversion list. Define modifiers list.
• Worked on Order Cycle, which includes Booking, Pick Release, Ship Confirming and Interface to Receivables, Invoice/Credit memo generation.
• Performed unit testing & integration testing along with test data preparation.
• Used AIM methodology for project documentation.
• Worked closely with technical team and given inputs for integration testing.
• Functional/Integration Testing/System Testing and User Acceptance Testing.
• Analyzed 3rd Party applications which are integrating with oracle apps and provided solutions to the integration points.
• Business study and Prepared Process Analysis Questionnaire.
• GAP analysis and resolution for Order Management Modules with respect to the service contracts. Also documented the entire Gaps and its Resolution/Recommendation.

Environment: Oracle 11.5.10

Confidential, Minneapolis, MN

Oracle Applications Analyst

Responsibilities

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
• Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management, WIP, BOM and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Conducted CRP and Integration testing for related modules
• Maintain issue tracker and coordinated with the team for debugging
• Involved with user acceptance testing (UAT) and end user training
• Prepared and provided comprehensive training materials and practice exercises

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts), Oracle 8i(SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and HP-UNIX, Discoverer