SUMMARY:

• Oracle Manufacturing Functional Consultant with more than 9.1 years of aggregate Experience. Extensive experience with being a Functional Expert in SCM modules of PO, i - Procurement, OM, INV, BOM, 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.7 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
• 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:

PO: Procurement, OM, INV, BOM, ASCP, MSCA, Costing, Advance Pricing, Shipping modules

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

PROFESSIONAL EXPERIENCE:

Confidential, Green Bay, WI

Manufacturing Functional Analystnce Pricing

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 includes PO, i-Procurement, WMS, MRP, OM, INV, BOM, ASCP, WIP, MSCA, Quality, Costing, Advance Pricing, Shipping
• 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.
• Worked on Oracle MRP to setup 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 MRP Collection process.
• Worked on Oracle APCC - working on scenarios, service enablement planning process, worked on advance planning analytical framework, worked on the operation data store, etc.
• Worked on Oracle MSCA - worked on labeling setups, barcoding, defined strategies, data field identifier setup, setup printers, etc.
• Worked on the WMS Setups like Warehouse setup, Warehouse Org Setups, Locator Zones and Parameters, task type assignment rules, label formats, associating label types to business flows, receiving parameters, picking rules for warehouses, operation plan selection rules, advanced lot control, lot and serial attributes, Cartonization, Container Items, Contained Items, cost groups, cycle counts, etc.
• 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.
• Taking care of the Resource Allocation

Confidential, San Diego, CA

Plan to Manufacture Functional Analyst (PO, i-Procurement, OM, WMS, Quality, MRP, INV, BOM, ASCP, Costing, APCC, MSCA, Advance Pricing, Shipping)

Environment: Oracle Fusion Cloud 11

Responsibilities -

• As a Plan to Manufacture Functional Consultant implemented the modules including OM, BOM, Sales and Operation Planning, ASCP, MSCA, AR, Quality, INV, PO, Advance Pricing modules.
• Worked on the Revenue Recognition process in AR Module.
• 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 OM, Sales and Operation Planning, MRP, BOM, GOP, AR, Quality, INV, MSCA, PO, Advance Pricing, Service Contracts, Install Base modules
• Worked on the MRP Setups - setting up the planning flex fields, defining the plan options, setting up constraints for the plan, worked on defining the demand and supply sources, worked on tweaking the plan attributes for tuning the plan, etc.
• Worked on MSCA Setups - defined the printers, labelling, etc.
• 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

Plan to Manufacture Functional

Environment: Oracle 11.5.10.2

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,WMS, i-Procurement, OM, INV, BOM, Quality, MRP, MSCA, Costing, 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 B2B
• 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

SCM Functional Consultant

Environment: Global Roll Out of Oracle Release 12

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: Quoting, OM, INV, PO, Quality, I-Procurement, ASCP, BOM integrated with internal e-Procure system, Release 11i of oracle (11.5.10.2).
• Implemented 14 SOB’s (20 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Experience with Vertex Integration for Sales Tax.
• Worked on Revenue recognition in AR.
• 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.
• Implemented Auto Lock box Functionality in AR.
• Implemented Outbound interfaces for AP for creating bank payment outbound file

Confidential

Financials Functional Consultant

Environment: Oracle 11.5.10

Responsabilités:

• 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 management

Confidential

Functional Consultant

Environment: Oracle 11.5.10

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.