We provide IT Staff Augmentation Services!

Oracle Scm Techno Functional Analyst Resume

Malta, NY

SUMMARY:

  • Techno Functional Distribution and Supply Chain Consultant with over 9.3 years of total industry experience including 8 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 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 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, Service Contracts, Install Base, 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 -
  • Oracle Purchasing, Service Contracts, Install Base, Order Management, Inventory
  • Oracle General Ledger (GL)
  • Oracle Process Manufacturing (OPM) - OPM INV, OPM OM and OPM PO
  • Oracle Receivables (AR), Payables (AP)
  • Cash Management (CE)

TECHNICAL EXPERTISE:

ERP-E-Business Suite: Oracle Applications Release 12/11.5.8/10.7/9.4 (PO, INV, WIP, AP, SYS ADMIN, AOL, OM)

PROFESSIONAL EXPERIENCE:

Confidential, Malta, NY

Oracle SCM Techno Functional Analyst

Responsibilities:

  • Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Carry out Data Mapping for data conversions.
  • Worked on Import and Export Compliance process - worked on the commercial invoice, worked on the denied parties screening, worked on the configuration of the integration between Oracle Shipping and the denied parties screening tool.
  • Worked on Intercompany Transactions using IRISO process.
  • Worked on the Order to Cash flow - including the setups Quoting, OM, Shipping, Service Contracts and Install Base, Inventory, Purchasing, Export Compliance modules
  • Quoting configuration setup for CRP’s such as master data setup, custom quote statues, pricing and discounting for quotes.
  • Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
  • Worked on Oracle Advance Pricing module - defined the primary and secondary price lists, defined the modifiers, qualifiers, define custom attributes for pricing, defined formulas for pricing, worked on setting up the freight modifier, etc.
  • Worked on Oracle Purchasing module - defined the PO approval hierarchies, setup automatic sourcing, defined the approved supplier lists, defined the integration of PO with Procurement contracts, worked on configuring requisition templates, etc.

Confidential, Sunnyvale, CA

Oracle SCM Techno Functional

Responsibilities:

  • Worked on 11i and oracle R12 instance for the Quote to Cash Process.
  • Worked on Drop Ship where Orders will be sent to Contract Manufacturing from there it will Logistic department.
  • Worked on 7 entity US, Canada, RSA, NLP(European)Germany, UK and Israel for O2C Process and 30 Entity for Quote to Cash Process for calculation for tax process Pre-Cal and Post Cal and One Source Tax Determination for calculation tax. Taxes will be calculated based on Tax Regime. worked on customization process different channels like B2B, PTO, CTO orders, BPA, CPA, PO.
  • Worked on extracted data with SQL in OM side and AR Side .
  • Worked on the configurations of Quoting, OM, Service Contracts, Install Base, Advance Pricing, Shipping, Inventory and AR modules.
  • Advance Pricing Business Requirement Study and designed / documented Functional Specification.
  • Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
  • 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.
  • Created Views and Reports using Oracle Discoverer Tools.
  • Created interface for custom account creation process with DocuSign.
  • Daily support work for Oracle issues in Purchasing, AP, Inventory.

Confidential, Louisville, KY

Oracle SCM Techno Functional

Responsibilities:

  • Extensive experience and exposure with complete Quote to Cash Cycle with core focus on Quoting, OM, Shipping, Purchasing, Credit Card and AR Payments.
  • Oracle AR payment integration with Cyber source and FDMS (First Data Merchant Services), Client line systems for credit card processing.
  • Coordinated with Oracle for resolving issues like Receipts with incorrect and corrupted status, Submit offline Transaction Program Errors
  • Coordinated with Cyber source for settlement issues and for payment resolution.
  • Developed Report to extract the data from Client line report for clearing the receipts in Cash Management.
  • Worked on Production support: Trouble shooting and Root cause analysis.
  • Involved in Pay Pal Integration Payment System tool with Oracle EBS.
  • Worked on Cyber source integration with EBS
  • Implemented Credit card systems and Bank Systems
  • Deep understanding of AR reversal transactions like Charge back, Credit Memo, Debit Memo etc.
  • Worked on Revenue Recognition side Bill in Advance, Bill in Arrears.
  • Worked on the Reversal process, Refund Process and Chargeback in AR
  • Coordinated with offshore team for Enhancements and Production Support issues.
  • Gathering Requirement from Business and Transition to offshore team.
  • Worked on SQL Database TOAD, SQL Developer, Data Loader, FND Loader.
  • Worked on the forms and reports changes
  • Worked on the XML Publisher report development
  • Worked on Discoverer report development
  • Worked on Prepayment types, payments terms like Net30, Net40 etc.
  • Worked on OM end to end flow and AR complete process.
  • Working knowledge on MD20, MD60, BR100, BP80, BR30/80(Unit testing/ASIS and TOBE process)

Confidential, Bothell, WA

Oracle SCM Techno Functional

Responsibilities:

  • Configured the Quoting, OM, Advance Pricing, INV, Shipping, Purchasing modules.
  • 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 Quoting, OM, Advance Pricing, INV, Shipping, Purchasing modules.
  • 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.

Confidential, Billerica, MA

Oracle SCM Techno Functional

Technology: OM, Advance Pricing, INV, Shipping, AR, AP, GL

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 OM, Advance Pricing, INV, Shipping, AR, AP, GL 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 Order to Cash 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 Techno Functional

Responsibilities:

  • Interaction with business users as a part of As - Is Study for clients legacy application D3 Pick for OM, Advance Pricing, INV, Shipping, AR, AP, GL modules
  • 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 Order to Cash modules including OM, Advance Pricing, INV, Shipping, AR, AP, GL
  • 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

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.

Hire Now