SUMMARY

• Over 11++ years of programming extensive experience in Oracle EBS/Oracle Cloud SCM in Implementation/Support/ Maintenance - Performng functional work within the Oracle Procurement Suite, Oracle Inventory(INV), Supply Chain management(SCM ), Fusion Order Management (DOO ), Fusion Pricing, Oracle Manufacturing (Discrete & Process), and Order to Cash (O2C) & Procure to Pay (P2P) Cycles.
• Experience as an Oracle EBS/Cloud SCM Consultant, with expertise in Oracle Cloud SCM/Procurement modules (Enterprise Structure, Sourcing, Supplier Portal, Procurement, Fusion Supplier Qualification, Fusion Order Management (DOO), Fusion Pricing and Fusin Cost Accounting, Procure2Pay cycle).
• Hands on configuration of all the Financials modules on multiple ERP Cloud instances.
• Created and managed different status in Distributed Order Orchestration (DOO), Status management.
• Established Pricing, Inventory (Product Management), and worked on data access sets.
• Integrated web services and external fulfillment system, for shipping & invoicing in to Order Management Cloud.
• Involved in implementations of Oracle Applications R12 & Cloud R12/R13.
• Strong understanding of Cloud Security Model as it relates to Oracle Cloud.
• Configured the Oracle Cloud Applications to meet requirements and application set-ups.
• Including Fusion/Cloud ERP (SaaS) as well as E-Business Suite.
• Having experience in OBI Answers, OBI Dashboards, BI Publisher and OTBI/FRS/Smart view reports.
• Extensive experience on the Full Life Cycle Implementation of Procure to Pay Cycle (P2P), Record to Report (RTR) and Order to Cash Cycle (O2C).
• Wide knowledge in using Oracle AIM of project implementation methodologies particularly functional specification document (MD 50) for the Reports and custom components.
• Application Setup Documents (BR.100) deliverables and Test Cases (TE.20) and (TE.120) for GL, OM, INV, PO, AP, AR modules.
• Technically proficient in implementing RICE/CEMLI (Reports, Interfaces, Data Conversions, Extensions), ITR (Interface Table Reference), BIP Reports like XML Publisher Reports, SQL Reports and PL/SQL packages.
• Ability to quickly grasp/learn the new applications/ business processes in the organization.
• Experience in designing, testing custom applications with an integration to Oracle Applications or other custom applications. Also handling User queries at the time of UAT and Go Live.

TECHNICAL SKILLS

Functional Expertise: Oracle EBS 11i & R12 Manufacturing Modules BOM, WIP, PO, OPM (Production/Formulator), Inventory, MDM, MRP, Costing

SCM/MFG: Procurement, OM, Inventory, BOM, WIP, Purchasing, P2P & O2C Cycles.

Financials: GL, AP, AR, SLA, FA, Project Costing

Technologies: Oracle EBS Release 11i/R12, Oracle 10g/11g, Reports, Forms, PL/SQL, Workflow, Data loader.

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Oracle Cloud Lead Consultant

Environment: Oracle Fusion Cloud (SCM, P2P Cycle, Order Orchestration, Financials, Essbase, PPM, Procurement) BI Publisher, FBDI, OTBI.

Responsibilities:

• Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time.
• Worked on Inbound and Outbound Integrations in Cloud SCM Modules.
• Worked on Oracle Cloud SCM, P2P, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Accounts Receivables, Accounts Payables.
• Interacted with end users and translated their requirements into documents that catered the logic for implementing user requirements.
• Implemented Order Management Cloud, involved in Oracle Fusion Planning central.
• Worked on the basic setups of Inventory setups, defined the picking rules.
• Defined Parent & Child relationships and ASN settings and Mapping of Dock appointment
• Preparation of task type, project charter and project mapping, Functional design document (AN050)
• Configuration of multiple ERP Cloud prototypes (SCM and Procure-to-Pay cycle process) .
• Created outlines, calculation scripts, member formula and business rules, Data forms, reporting with Smart View.
• Data Loading/Conversions/Integrations using Financial Based Data Import (FBDI) which includes the Procurement data, Supplier data, Customer relationships data, Order info and Order Management Data.

Confidential, Tustin, CA

Oracle Cloud Lead Consultant

Environment: Oracle Fusion Cloud (SCM Cloud, Financials Cloud, & Procurement Cloud), BI Publisher, FBDI, FBDI

Responsibilities:

• 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.
• Worked on several production support issues in Order Management like stuck SO lines, RMAs, pick release & shipping documents, adjustments & maintaining setups in OM and advanced pricing.
• Written and generated various user and business reports (RD011, DS030, TE020, TE025, CV027).
• Implemented Global order promising (GOP), Distributed order orchestration (DOO), Change Management, Costing according to the client’s business requirements. and Pricing of items, Status creation & management according to business processers, importing orders, Web integration, Registering Connectors and UCM.
• Worked on data conversion for customers, suppliers, Orders, Procurement Transactions using Oracle FBDI and ADFDI templates.
• Supported client in Oracle Cloud UI personalization's and customizations for end users.
• Configured custom security and data roles.
• Worked on Fusion Reporting technologies BI Publisher, OTBI & FRS for Fusion Financials.
• Developed new Rules as per business requirements in the Custom Rules library
• Involved in Auto generating the code like interface package, using Dynamic SQL.
• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.

Confidential, Seattle, WA

Sr. Oracle Cloud Consultant

Environment: Oracle Fusion Cloud (Procurement, P2P Cycle, Financials, Order Orchestration), BI Publisher, HCM Extract, HCM Connect, FBDI, BI Publisher, OTBI.

Responsibilities:

• Worked on FBDI for inbound integrations in SCM Cloud system.
• Worked on Procurement (P2P) and Financials cloud.
• Worked on the Advance Pricing Module - defining modifiers, qualifiers, price lists, price breaks, custom attributes for pricing, price mapping, etc.
• Worked on the Configuration of the INV module including setting up of the Item Catalogs, Defining Catalogs, Defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
• Strong integration experience in integrating with Oracle Cloud ERP both inbound and outbound.
• Proficient in managing Cloud Sandbox for personalization.
• Worked on Integrations in OIC for SaaS to SaaS, and SaaS to On-Premises integration.
• Worked with Oracle Cloud Modules for Procurement, Cash Management (Bank transactions) Sourcing, and Supplier Portal.
• Developed BI Reports/OTBI in Oracle SCM Fusion Cloud.
• Customization of BI Publisher templates for checks, positive pay and confidential payment files.

Confidential, Columbus, OH

Sr. Oracle EBS Consultant

Environment: Procurement, SCM, MFG Modules, P2P & O2C Cycles

Responsibility:

• Enabled Multi-Org Access Control (MOAC) to process data and transactions more efficiently across operating units.
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations.
• Setting up Buyer, Approval Groups, and Approval Assignments in Oracle Purchasing Application.
• Troubleshooting the order management, invoices, intercompany, WIP transactions, etc issues using SQL statements in Oracle.
• Configured and implemented Supporting References through SLA setups for financial modules. Defined the Request Sets for Financial Modules for Period Close.
• Worked on several production support issues in Order Management like stuck SO lines, RMAs, pick release & shipping documents, adjustments & maintaining setups in OM and advanced pricing.
• Worked on the Advance Pricing Module - defining modifiers, qualifiers, price lists, price breaks, custom attributes for pricing, price mapping, etc.
• Handled issues with the Procurement, Inventory and Order to Cash flows.
• Involved to fix the issues in Interfaces, custom Reports, workflow and Alerts.
• Responsible for creation of the AOL Objects, SQL Files from development instance to prior production instance.
• Worked on the Configuration of the INV module including setting up of the Item Catalogs, Defining Catalogs, Defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
• Instructing team members in Planning, Inventory, Pricing, Costing, OM and MRP modules.
• Development of migration documentation, including issues detected and improvements implemented during the Go Live.
• Table mapping identification and registration.
• Custom objects control and classification into a repository.
• Team work to improve Oracle functionality and information accuracy within Oracle internal interfaces.
• Team training for handover and knowledge transfers to allow team involvement into support and new enhancement or implementations.
• Delivery of control reports and documentation of the improvements and corrections in a monthly basis

Confidential, Detroit, MI

Oracle EBS Consultant

Environment: Procurement, P2P & O2C Cycles, SCM, Warehouse Management, MFG Modules

Responsibilities:

• Performed all Purchasing, Inventory setups, and provided Support for INV and PO Modules.
• Setup of Organizational hierarchy, Operating Unit, Inventory Organizations, Stock Locators, Item categories, Revisions and Sub Inventory Locations. Configuration of Purchasing (P2P) involving Approval hierarchy, Creations of suppliers and business based purchasing options.
• Configured user responsibilities, request groups, menus and menu exceptions.
• Worked on the Auto Invoice setups for Accounts Receivables.
• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established Item Category and Item Cataloging for their products.
• Defined ABC Analysis and Cycle Count.
• Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, BOM, WIP, Mobile GUI, AP and AR Applications.
• Set up the complete Procure to Pay business flow starting from requisitions creation in iProcurement, using Auto create functionality to create purchase order or Sourcing Event, visibility of PO in iSupplier portal, ASN creation in iSupplier portal, Receiving in iProcurement and payment in Account Payables.
• Established Customer Item and Customer Item Cross Reference.
• Established a process for smooth month end closing procedure in Inventory.
• Worked on the team for the Procure-To-Pay business flow.
• Liaise between the users and the business owners throughout the entire project.
• Performed Gap analysis hence identified issues and suggested workaround solutions.
• Coordinated in closing periods and generated trail balance reports for different Operating Units of the company.
• Worked on all type of AR transaction like Standard Invoice, Debit Memo, Credit Memo, Charge Back Invoice, and Deposit Invoice.
• Implemented Enter Advanced Shipment Notices (ASN) in i-Supplier to acknowledge the delivery status and Shipping schedules.
• Integrated key purchasing functionality including Vendor Punch-out, XML Purchase Orders, Procurement Cards (P-Card), Emergency PO requisitions, Hosted Vendor Catalogs, and Automated PO Creation.
• Prepared BR 100 Documents, Functional and Technical specifications for reports.
• Trained the business users for purchasing the Click to Requisition, PO to invoice, Return Material Authorization (RMA’s), Invoice to payment flows.