We provide IT Staff Augmentation Services!

Sr. Oracle Functional Consultant Resume

Racine, WI


  • Oracle Professional 17 years of experience in IT and 13 years of functional experience in Procurement, Manufacturing, Planning modules. Project Management experience following SDLC and PMP methodology.
  • Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, UAT, Cut - Over and Project Coordination activities.
  • Well versed with weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
  • Ability to perform setups and implement and provide design solutions in EBS 11i and R12 in WMS, SCM, P2P and O2C processes.
  • Strong familiarity in implementation and upgrade projects of Oracle ERP (EBS 11i and R12). Solid understanding on impact analysis in current business process due upgrade changes, enhancements and 3rd Parties integration.
  • Strong Exposure in preparation of high-level functional design documents (BR100, MD050, CF250 and Test Cases.).
  • Extensive knowledge in Custom application development, Conversions, Interfaces & Reports.
  • Excellent functional knowledge in SCM, P2P and O2C modules like Inventory, Work in Progress, Engineering, BOM, MSCA, WMS, ASCP, Order Management, Purchasing, Receivables, Payables and iStore.
  • Recommended WMS configuration or modification to reduce and simply operating time and cost for client.
  • Excellent knowledge on various setups for ASCP, VCP, Inventory Optimization, Min-Max Planning, Re-order point Planning.
  • Well versed with weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
  • Engaged business users with Project Team, Developer Team and Production Support Team to design and implement effective solutions.


ERP: Oracle EBS 11i, R12, Ebizframe.

Language: SQL, PL&SQL, UNIX Script

GUI: Oracle Forms/Reports 6i, Workflow, Oracle Designer9i, Discover 4i

Tools: & Utilities: TOAD, PVCS, KINTANA, Work Flow, APPWORX, Vista plus.

Industry Experience: Service, Manufacturing, Pharmaceutical, Telecom.

Software Engineering: SAD, CASE Tools with Oracle Designer9i, ER Diagram.


Confidential, Racine, WI

Sr. Oracle Functional Consultant

  • Support R12 in SCM, P2P, O2C, Planning and WMS processes.
  • Provide Fit-Gap analysis and solution designing for various enhancements and customization.
  • Coordinate with offshore team involved in supporting Enterprise application communicate status, issues and delivery plan.

Environment: R12 (OM, PO, ASCP, INV, BOM, WIP, ENG and WMS).

Confidential,Menomonee Falls,WI

Sr. Oracle Functional Consultant

  • Defined and implemented new or improved IT system solutions in Order management, planning, supply chain, manufacturing, and distribution functional areas, which includes the following modules: OM, PO, ASCP, INV, BOM, ENG and WMS.
  • Provided hands-on functional and technical business system process and configuration expertise to IT and Actuant’s businesses.
  • Worked with business management and users to solve problems and translate business requirements into functional specifications and designs, and then take approved solutions through their respective implementation cycle.
  • Acted as a key liaison between the business user community and IT staff both on a regional and global basis, and effectively report out the progress and status on any activities.
  • Research and analyze new software solutions whether it is for new modules or bolt-on’s, and present such findings to the pertinent business and IT communities, like Demantra.
  • Setup procurement hierarchy for requisition and purchase orders. Worked with manufacturing engineers to change BOM structure, costing and routing.
  • Worked in WMS implementation and customization team to define rules, strategies in WMS application to improve the performance of the equipments and pickers.
  • Fixed WMS Packing workbench for UCC code for specific customers for packing detail with Bar Code. Define Pick none process for stock out location for cycle count and alert the business.
  • Setup WMS barcode printers for on-demand printing and updated print label as required. Setup WMS routing logic for best picking route for pickers and equipment.
  • Worked with MDM team for mass update of Items and BOM and Support ASCP planning run, sourcing rule, ASL, ATP on daily basis. Post production support for INV, BOM, ENG, WIP, OM, ASCP, WMS, and PO.

Environment: R12 (OM, PO, ASCP, INV, BOM, WIP, ENG and WMS), Demantra.

Confidential,Eau Claire, WI

Sr. Oracle Functional Consultant

  • Conducted workshops for gathering user requirements, perform gap analysis, configure and workarounds in Planning and Forecasting processes.
  • Designed and implemented Oracle WMS for the warehouse. Customize the WMS Rule, Strategy and Workbench to meet the client requirement for Picking and Putaway rules.
  • Setup Rules, Strategies and workbench for Wave picking in WMS application and support WMS application as needed. Tested various scenarios in O2C, P2P process involving Oracle WMS.
  • Work closely with business user to setup, configure, and customize of INV, BOM, PO and WIP modules.
  • Provided in-depth information for consolidation to receiving, putaway, quality control, picking, allocation, packing, loading, shipping and cycle counting in WMS application.
  • Work closely with various departments and IT Analysts to gather an in-depth knowledge of business processes and procedures.
  • Apply full-life- cycle methodologies to projects and change control. Responsible for documentation using Oracle AIM methodology or using company standards. Perform on-call application support as necessary.

Environment: R12 (OM, PO, MRP, INV, BOM, WIP, ENG and WMS), Stibo, Demantra.

Confidential,Lake Forest, CA

Sr. Sr. Oracle Functional Consultant

  • Analysis of current business processes and definition of new processes within Oracle Application. Business requirements gathering, mapping, gap identification and workarounds using BR100 and MD50 documents.
  • Responsible to trainee IT personal and implementers within modules of ASCP, SCM, MFG, and Forecast.
  • Conducted Workshops for gathering user requirements, perform GAP analysis and configure user requirement to Oracle Planning modules.
  • Automate the sales order release process for Software and Media Orders, which required setup of new Order Type, Sub-inventory and Pick Release Rule.
  • Design the solution to load Master Schedule entries into a Master Schedule from outside sources using schedule interface. ASCP souring rules configuration to allow ATP and OM’s SO scheduling.
  • Implement & setup INV, WIP, BOM, Engineering modules. Patching and bug research, implementation requests, test and delivery.
  • Design Demand at Risk report to provide the demands which need attention. Define and worked on the process to streamline the reservation process and auto pick-slip generation.
  • Define the process to address the BOE (custom clearance issue) in Middle East Operations. Worked on defaulting rule, delete constraint rule, Modifiers, Qualifiers and Pricing attributes.
  • Define Procurement souring rules configuration to allow ATP and scheduling. Resolved issue in Order management, service contract, Receivable, Purchasing, Inventory modules.

Environment: R12 (OM, PO, ASCP, INV, BOM, WIP, ENG and WMS), Demantra.

Confidential, WI

Sr. Oracle Functional Consultant

  • Maintained all projects documentations following GE standard & program version control. This includes weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
  • Worked with Business users in 11i to Scale R12 upgrade project, which includes 11i AS-IS analysis for Inquiry to Order, Order to Revenue and Procure to fulfill processes in 11i.
  • Performs systems analysis, design, implementation, maintenance, and enhancement for Oracle Finance, Procurement, Engineering, and Supply Chain & Logistic Modules.
  • Involved in Planning and implementing data conversion methodology and modified the data collection process. Configure and test Oracle VCP applications: ASCP, IO, Smoothie (Demantra).
  • Setup architecture for SOA and Time & Labor application for project billing and employee earned hours.
  • Automate "transact move order" process. Modify file to SRC to send after move order is transacted vs. current logic at pick release.
  • Design new interface data file for invoice data from Oracle to 3rd party (SRC) and modified the existing intercompany invoicing program.
  • Design new report to show all released and unreleased discrete jobs and the operations that are left to complete. This report is used to track, update, and prioritize the discrete jobs within WED.
  • Fulfilled the iStore enhancements for voice of customer, Shipping date logic, Export compliance screen and new store setup.
  • Provided the solution to load legacy data like Purchasing Items, Field Service Items, Install base Items to Oracle ERP.
  • Design new report to show all released and unreleased discrete jobs and the operations that are left to complete. This report is used to track, update, and prioritize the discrete jobs within WED.
  • Fulfill the Business requirement to store the scanned copies of shipping documents at receipts and then view these documents from AP invoice for Audit.
  • Design the process to send the Approved Purchase Orders to Requesters, Service Manager, Project Manager and Buyers every 15 minutes.
  • Setup sales order with the associated account information for Engineering Lab, which are placed via i-Store/Order management with Project numbers associated with it for downstream project accounting.

Environment: R12 (OM, PO, AP, ASCP, INV, WIP, BOM and ENG), Demantra.


Sr. Oracle Functional Consultant

  • Performs systems analysis, design, installation, maintenance, and enhancement for mission critical applications within the Supply Chain & Logistic Modules.
  • Developed solutions meeting user requirements, and write functional and technical documents, and worked with technical team for development & testing. Worked in As-Is, To-Be, Solution Design, CRP-I, CRP-II, Solution Piloting and UAT.
  • Worked in 11i to R12 upgrade to Cash and procure to pay processes, which include testing iterations and resolving the issues.
  • Designed and implemented Automation of all the Master Data changes (Forecast, Item, BOM, Routings, Resources, Sourcing rules) to Oracle ERP modules and Mass Changes of business entities (Part attributes, Categories, Resource usages, Yields etc).
  • Worked with DBA on the performance of various standard collection programs for the Planning processes.
  • Setup processing constraint, defaulting rule, document sequence, pick slip grouping rule, release sequence rule, shipping document set etc.
  • Modified the OM workflow to in corporate business requirement for Export Compliance Screening process.
  • Worked with the management team in business requirements gathering and analysis to determine new objectives and procedures, mainly on Legacy data collection to ASCP and Demantra.
  • Implemented the business process for WD Online store project, from on-hand quantity display to fulfill the Orders in Oracle. Automated the Internal requisition process based on sourcing rule and Auto substitution process.
  • Setup Inventory Organizations and sub-inventories, item attributes and item categories, UOM conversion, ATP parameters, WIP parameters.
  • Setup receiving options for inventory, document approval, sourcing rule in Purchasing. Trained user for PO & RMA Receiving, Inspection, receiving transactions and Deliver to Warehouse.
  • Design and implemented the strategy to upload, and update the Standard Cost on daily and quarterly basis using Cost Management.
  • Modified ECO Approval workflow, notification system and program to update the Item attribute. Post production support for INV, BOM, ENG, WIP, OM, QP, AR, CST, TCA, and PO.
  • Support Period End issues in Inventory Module. Design the process to update standard cost and rollup on quarterly basis in Oracle Cost Management.

Environment: R12 (OM, PO, INV, BOM, ENG, WIP, WMS and ASCP), Demantra.

Confidential, NY

Oracle Functional Consultant

  • Gather business requirements, GAP analysis, Module setup, Configuration, training end users and production support. Involved in 11i to R12 upgrade in various modules with business users & support team.
  • Performed all functional testing to ensure that the standard and custom processes and reports worked correctly after the upgrade to R12. Setup of Inventory, Order Management, BOM, WIP, WMS, Cost Management.
  • Setup Defaulting Rule, Processing Constraint, Order type, ATP rule, Scheduling, Price list, Qualifiers, Modifiers and other advance pricing processes.
  • Setup Bill of Material/routing and routing redesign to support outside processing for furniture items. Functional Testing of Order to cash, and Procure to pay process involving WMS processes.
  • Design and implemented order import process using Order Import interfaces for the Web Orders and legacy system orders.
  • Design Customer Information form for Customer Services, which enables user to view important information of the Customer, Open/Closed Orders, and aging information and roll up summary of the Customer.
  • Design and implemented Product life cycle Inquiry form for Research group and Design team, which enables user to view day-to-day activity of the items.
  • Design and implemented on-demand Invoice & Receipt print/fax/email form and customized Invoice creation program to in corporate new requirements.
  • Setup address validation process based on Satori Software address management solutions for TCA. Set up for Invoice, Receipts, Lockbox, Auto Accounting and System Option Parameters.
  • Design and implemented complete process which uploads the Export/Import information to Integration Point Server.
  • Design and implemented the shipping process to interact with the Pitney server to calculate freight charges and tracking information for the deliveries.
  • Modified the Mobile Application (MSCA) for RF Scanners to create return putaway task. Design and implemented data migration from legacy system to Oracle Applications for Item import, Order Import, Pricing Import and Customer Import.
  • Month end closing for Inventory and resolve the issues for the unprocessed transactions.

Environment: 11i/R12 (OM, PO, INV, BOM, ENG, MSCA and WMS).

Confidential,Fairfield, NJ

Sr. Oracle Functional Consultant

  • Design Price List Validation process and Preview Form to review and correct errors in Price List Lines. Design Concurrent Programs to submit pricelist upload from the above form after the corrections are completed.
  • Design Concurrent Programs to Create a New Price List that maintains all Zero Dollar Products of certain type (Option Classes, Option Model, Branding Kit, Software Drivers and others) as Price List Lines.
  • Modify the Custom Library, not to copy the Price List from the BOM Header Price list to the Zero Dollar Price list items.
  • Customized Service Contract Form to obtain the correct price for the combination of Labor item, servicing entity and product category type, and then up lift that price by a percentage uplift factor that is associated to the service zone in which the service was performed for direct service entities.
  • Customized workflow process to ‘provide the ability to automatically generate and send notifications and approvals pertaining to sub inventory transfers for various reasons in different stages of the Move order processes’.
  • Customized Order Header Workflow to uplift the price of machine (child items on BOM) items based on the Leased factor.

Environment: 11i (OM, PO, INV, BOM, SC, QP).

Confidential, FL

Sr. Oracle Functional Consultant

  • Design and implemented Quotation Workbench and integrated with Order Management. Design and implemented Data Conversion and Data Migration for Custom Pricing module.
  • Design Sales Order confirmation Report, BSA Confirmation Report. Design and implemented Concurrent Programs Quotation Into-Plane Report based on Template to be sent to Customer.
  • Design and implemented API to Email and FAX the Reports to be sent to Customer and Supplier. Design and implemented API to store and maintain the transmission status of the Documents sent to the customer.
  • Personalize the PO Receiving Form, which must be priced at the time of receiving as per the date sensitive nature of the transaction.
  • Worked with GL Account Balance Inquiry Report in order to report all the Accounts with the PTD and YTD Balances in a particular period.


Oracle Sr. Software Engineer

  • Preparation of AS-IS Analysis Document of the existing 10.7 version code. Preparation of Technical Design Document from Functional design documents.
  • Setup Defaulting Rule, Processing Constraint, and order type and prepare test cases. Design and developed ‘EC Order Correction Form’ which is used to correct the sales orders which has been imported from various Ordering Tools.
  • Developed Concurrent Programs ‘Cisco Deal Management Report’ to track the deals with the customers.
  • Design and implemented Form Function ‘Service Form’ through which all the services provided by Cisco are defined, maintained and tender is created.
  • Integrated Sales Order data from IC Engine to Order Management tables using API’s. Preparation of Unit Test Case for the Customized and New Developed Objects.
  • Created end user training manuals and perform end-user training. Functional testing of Order Management and Inventory Modules.
  • Preparation of Unit Test Case, Unit Test Results for the Custom Objects. Developed and deployed international CRP and UAT. Setup Alerts to monitor business processes and system performance.

Environment: 11i/10.7 (OM, PO, INV, BOM, QP).


Oracle Sr. Software Engineer

  • Worked on Interfaces (IVRS- electronic interfaces to outside systems) Technology, which is the electronic interface to the outside world using the Third-Party Software Clinphone.
  • Developed on Oracle Advance Queuing for sending messages once a consignment is Shipped Confirmed.
  • Design the process to send Emails to the Concerned Authority when a new Formulation is created. Design and Developed Form Function for storing Labeling Information.
  • Developed Report for the traceability of intermediate inventory and process steps of complex dosage formulations.
  • Preparation of Unit Test Case and Unit Test Results. Worked in Clinicopia, IVRS, Advance Queuing.

Environment: Clinicopia.

Hire Now