We provide IT Staff Augmentation Services!

Oracle Applications Functional Consultant Resume

3.00/5 (Submit Your Rating)

Englewood, CO


  • 9 years of working experience in Manufacturing & Supply Chain (INV, CST, OM, WSH, PO, BOM, WIP, MRP & Quoting) and Distribution processes, which includes excellent working experience in software development in oracle applications in R12, 11i Version
  • Engineer with experience in Management and manufacturing Execution systems with world class OEM (General Electric).
  • Expertise in Plant setup in Oracle, Production Management, Process improvement, Quality Management using Oracle MES.
  • Specialties a. Project Implementation b. Project Management c. Worked for Hi - tech, Medical, Consumer product, Industrial and Aerospace industry.
  • Expertise in Oracle SCM & Discrete Manufacturing modules, having excellent functional experience in Configuration, Implementation, Upgrade, Enhancement, Testing, Production Support, Customization of Business Applications, Conversion, user training, analyzing business requirements and writing functional design specifications.
  • Functional expertise in Oracle Applications (11i & R12) modules such as Oracle Inventory (INV), Order Management (OM), Advanced pricing (QP), Shipping (WSH), Oracle Purchasing (PO), iProcurement, AME, iSupplier, Oracle Bills of Materials (BOM), Oracle Engineering (ENG), Oracle work in Process (WIP) & Oracle 11i MRP/MPS/MDS. Good experience with Oracle Quality (QA) & Project manufacturing Environments Procurement, Order Management, Pricing, Cost Management, Inventory, Discrete Manufacturing & Financials
  • Order types setup, defaulting rules, processing constraints, fulfillment sets functionality, ship / arrival sets, end customer, pricing modifier/qualifier, pick release, ship confirm, Customer acceptance.
  • Advanced pricing: Pricing Security Module, Price Book publication, Price Management, Discounts, Modifier, Qualifier, Custom Pricing, Pricing Incompatibilities, High Volume Pricing, Configurator Pricing Strategy, Pricing in Quoting, Pricing Transaction Entities (PTE), Freight Cost & Surcharges, Billing & Claims, Pricing Formulas, Price List Management, Annual Price Change Management Strategy, HTML Pricing, Custom Hooks in Pricing
  • Procurement setups, Buyer work center, types of POs, PO workflow customization, Catalog loading, Punchout setups, ASL, Sourcing rules, ASN, EDI, iSupplier registration, Sourcing, Contracts, AME, all teh standard financial flows, Chart of account setup, Account generator WF, Invoicing.
  • Inventory setups, Items, Transactions UOM, Move orders, Kanban, Physical inventory, cycle counting, Org setup, sub inventories, locators, Item templates, cost controls, pick rules, categories, Catalogues, DFF/KFF, calendars, etc.
  • Cost types, Standard / Average / LIFO / FIFO, overheads, cost elements, cost rollup, cost update, copy costs, PAC costing, Landed Cost management, COGS customization, SLA with costing and drilldown to GL & SLA. Legal entity level costing, cost master concept, project costing, WIP cost Variance monitoring etc.
  • Bills (Model, Option, Standard), Resources (sequential / offset, Alternate), Routings (Alternate, Primary), Lead time calc, Cost rollup, Supply types, Common & Copy bills and routings.
  • Discrete Jobs, Parameters, OSP, Schedule Groups, Move transactions, Resource Transactions, WIP value summary, Completion transactions, pending transactions
  • Full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT), Integration Testing and Production, User Training, go-live and post go-live Support in complex Multi-Org Environment.
  • Experience in implementation Process mapping, configuration, AS IS analysis, TO BE process development integrating various modules, Gap Analysis & Developing Functional Design Specifications.
  • Extensive Experience in all Oracle Business flows from Procure to Pay (P2P), Demand to Build (DTB), Order to Cash (O2C), Quote to Cash (QTC) and Planning to Execution.
  • Well conversant with concepts like Multi-Org, Flex fields and Workflows. Writing/executing teh scripts using SQL to perform various extracts from teh database. Well conversant with table structure and Flow.
  • Project Management: Prioritizing system problems, enhancement request and scope management. Reporting teh status to teh Steering Committee.
  • Worked on, Demand to Replenish (DTR), Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
  • Demonstrated ability to facilitate system review, data analysis, Conducting CRP & UAT and situation assessment.
  • Experience in using AIM methodologies. Through understanding of As-Is Process, designing To-Be Process, gathering business requirement, performing gap analysis, building RICE (Report, Interface, Conversion, Extension), Configurations throughout all phases i.e. CRP’s, Testing, Go Live and Production Support.
  • Worked as a Functional Lead role in projects as well as team player with good interpersonal skills, communication skills, productive in thought and action, user training skills, ability to manage multiple assignments and motivate team, adaptable to changes and new technologies, quick learning and grasping capabilities.
  • Proficient in using UPK Tool & Delivering multi medium training to user and superuser community.
  • Extensive experience in SCM, MFG, DIST functional modules with PTP, OTC, DTB cycles including business process flows, interfacing, system integration, business processing, manual work-step handling, exception handling, process automation and optimization.


Application Version: Oracle e-Business Suite R12.1.3, R12.1.1, R12.0.6,, 11.5.9, 11.5.8

EBS Modules: INV, CST, BOM, WIP, MES, PO,OM, iProc


Confidential - Englewood, CO

Oracle Applications Functional Consultant


  • Analysis of Oracle eBusiness Suite design, Development, Enhancements & Custom solution, Bug analysis and Resolutions, Software development requests dat includes data conversion strategy, solution validations and modifications accordingly.
  • Active participation and oversee across all phases of full lifecycle design and technical architecture of oracle based system specifically in R12 SCM systems.
  • Manage all phases of full lifecycle system development including requirements analysis, software design and development using oracle technologies, testing configuration and enhancement/maintenance.
  • Work closely with all stakeholders, technical engineers and process engineers to provide guidance and ensure adequate design for meeting business objectives and strategy.
  • Understanding and Gathering teh requirement from business super users and document teh same in Business requirement & analyzing teh Gaps.
  • Demonstrated application’s functionality, business processes mapped, configured and implemented.
  • Responsible for Customizations of OM, Advanced Pricing & Advanced Procurement modules.
  • Configuring teh different Contract templates for various forms of agreements such as Master Service Agreement, Professional Service Agreement, Product and Service Agreement, Non-Disclosure Agreement, Statement of Work, Leasing agreement and so on.
  • Developed setup documents using Oracle AIM methodology, configured Oracle Sourcing Application, developed documents BR 100 Set up, BR 30 Requirement Map and BP 80 Future Process Document.
  • Developed teh Functional documents (MD050) for Procurement Contracts approvals, XML templates customization to meet teh requirement, custom reports for Repository Contracts and Sourcing reports for saving trends.
  • Analyzed Perfect Commerce, On-Demand Spend Management Solutions Application, a legacy system currently used by client for multiple category purchases with features such as RFI, RFQ & Auction.
  • Demonstrated Oracle e-business Sourcing functionalities dat empower buyers conduct complex transactions with ease aimed at considerable saving.
  • Coordinated with cross-functional consultants to align, design, and implement an integrated Global e-Procurement solution.
  • Configured teh Custom responsibilities for Advanced Procurement modules.
  • Setup teh end to end OM & Advanced pricing application setup.
  • Responsible for Functional Set ups, Solution Testing and Functional Design of Extensions and Customizations.
  • Interact with Business Process Owners and other project stack holders to get functional sign off,
  • Created Test, Integration Test Plan, functional testing and User Acceptance Testing, training manuals.
  • Involved in some activities for Oracle System Administration module such as Registering teh Users and assigning responsibilities, printers in Oracle Apps.
  • Configuring teh Employee Supervisor based Requisition and PO hierarchies for approval management as per teh Procurement Policies.
  • Configuring teh AME rules for Repository Contracts and iProcurement for requisition approvals.
  • Testing of various test scenarios of Requisition to Payment cycle in Oracle advanced Procurement.
  • Modification of PO workflows attributes enabling teh auto generation of Purchase Orders for iProcurement Requisitions for Catalog and Punch-out.
  • Setups for Conference Room Pilot (CRP) for Business Champions and core team members.
  • Preparation of Test Scripts for CRP’s.
  • Document interface, views and report requirements and testing of customizations.
  • Setups for UAT and registration of all custom components during UAT in Test instance.
  • Preparation of Conversion strategy documents and carrying out conversion activities prior to go live.
  • Service procurement specific solutions
  • Create hourly rate based requisitions & Ability to auto generate invoices when a time card is approved via Oracle Time and Labor
  • Associate one SOW to one PO & Ability to only issue a PO once teh SOW is signed
  • Auto-Receive time against a PO & ensure dat a receipt cannot be entered twice (vendor vs. user)
  • Notify requisitioner when teh PO is approved
  • Created process to ensure services procurement will not create controllership issues
  • Solution to default PO number onto timecard
  • Ability to allow contractors dat are not on teh network to utilize OTL (Oracle Time and Labor)
  • Implemented Cost management and SLA for custom sourced transactions. Developed consolidation Chart of account structure process for newly acquired business.
  • Extensive travel to GEPS plants (Greenville SC, Schenectady NY, Duluth GA and Pensacola FL) to gather sustainment requirements and support from super users and plant leads.

Confidential - Leesport, PA

Functional Lead


  • Understanding teh As-Is process, Solution Design and map To-Be Process, Identify teh Gaps and Fit-Gap analysis in teh Order to Invoice Track.
  • Conduct Requirements gathering workshops and document teh “As-Is” process, to understand teh current process followed at Confidential Inc. North America Manufacturing Plants.
  • Design and document teh ‘To-Be’ process flows and Context diagrams after collating requirements from all Manufacturing Plants in North America region.
  • Configuring teh instance for Order Management and Advanced Pricing modules
  • Drive Conference Room Pilot sessions with teh business team and drive Key Design Decision (KDD) discussions.
  • Preparing teh Test Scripts for CRPs and Capturing teh Requirements / Defects
  • Identifying teh RICE to fit a Gap and documenting Functional requirements for RICE area.
  • Designing data conversion strategy document. Provide functional inputs for mapping teh fields with Legacy System (BAAN) during teh Data Conversion activity in teh track.
  • Analysis of teh data extracted from legacy BAAN system for migration of SO Headers, Built Lines, Unbuilt Lines and SO-PO Links.
  • Testing teh converted orders for accuracy in teh test systems.
  • Identifying issues in teh converted data and teh root cause analysis of teh issues.
  • Big Machines integration with Oracle Order Management:
  • Identifying data and rules required from Big Machines for successful order processing in Oracle.
  • Providing data mapping sheet describing rules around various order types.
  • Testing and identifying issues of teh orders sourced from Big Machines.
  • Providing solution to various change order scenarios.
  • Testing of teh manual change order scenarios and automated changes from Big Machines.
  • Designing a RICE component for mass update of backlog orders due to Engineering Changes.
  • Configuration of ATO/PTO model items using Configurator for orders entered manually in R12.
  • Pricing setup for teh manual orders with a markup value based on Customer.
  • Setting up Audit Trail.
  • Supporting teh production issues with a fix/workaround and providing root cause analysis.

Confidential - FL

Oracle R12 Applications Functional Consultant


  • Understanding and gathering teh requirements from business super users in teh area of Oracle Procure to Pay, Order to Cash and Inventory functional areas.
  • Providing solutions to allcomplex business requirements and set up teh same in teh oracle R12.1.3 instance
  • Responsible for creating interfaces with EDI to interact with outside storage facilities, warehouse, distribution & marketplaces
  • Functional Setups, Solution Testing and Functional Design of Extensions and Customizations for various business requirements
  • Creating teh Functional design specification documents (MD050) for RICE objects
  • Preparation of Test Scripts (TE020) to validate teh RICE objects in Oracle PO, Oracle INV, Oracle Receiving, Oracle Payables, Oracle Cost management (FIFO / Layer cost), LCM - Landed Cost management, Oracle eCommerce Gateway.
  • Working with teh technical team in developing teh interfaces for various inbound and outbound transactions with high volume processing
  • Testing of various test case scenarios of teh interfaces with real time data and defect tracking / management.
  • Document interface, views and report requirements and testing of customizations.
  • Customizations in integrations with Warehouse Management systems like EXE, ES3, WICS and Tricep with Oracle
  • Interfacing teh external systems with Oracle EBS through SOA by mapping teh data into teh staging tables
  • Validating teh data and importing Purchase Orders into EBS
  • Confidential -pricing and calculating deals for teh PO lines while teh PO’s are getting created in EBS
  • Processing PO Receipts and Corrections into EBS
  • Updating PO by adding new lines to teh PO for unordered receipts
  • Calculating teh Landed Cost for LCM organizations
  • Closing of all partial received lines
  • Functional Unit Testing, SIT, UAT and production migration
  • Analyze teh failed to process records and fixing them in post-production support
  • Worked on designing teh inbound and outbound interfaces for teh below EDI transactions
  • EDI 943, EDI 944, EDI 940, EDI 945, EDI 947 & EDI 846
  • Configuring IR-ISO setups for transfer orders between internal organizations.
  • Designing automated process for creating IR-ISOs and receiving them.
  • Configuring teh PO and QP modules as per teh business requirements
  • Customized teh pricing engine to derive teh purchase order price by price breaks.
  • Configured various modifiers as per teh business needs to be applied at teh time of PO pricing.
  • Developed a custom form to accommodate teh functionality with qualifying a price break by zone, load weight and organizations.
  • Customized teh pricing engine to populate teh sales order price from teh item cost.
  • Set up teh pricing coupons functionality.
  • Setting up Pricing Attributes, and Pricing Contexts in Advanced Pricing.
  • Setting up teh appropriate Price List in Order Management Application for various inventory items
  • Creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
  • Working extensively on Advanced Pricing setups in Oracle Order Management - Defining Pricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, Freight Charges
  • Resolved teh critical issues on Shipping Execution while Ship Confirming teh Sales Order.
  • Configuring teh LCM module for both pre-receiving and as a service options
  • Setup teh shipment types, cost factors for FIFO organizations.
  • Integrated teh LCM charges functionality with Advanced pricing to arrive at teh landed cost.
  • Setup teh freight apportioning for consolidated shipments across PO’s.
  • Setup teh residual quantity transactions specific to catch weight items.
  • Working on teh functional solution documents for building interfaces and interacting with teh technical team in designing interfaces to Oracle
  • PO Confidential -pricing
  • Price List and Modifiers conversion.
  • Prepared test scripts and training documents for testing cycles.
  • Configuring teh Order Management for ISO, DSO, Standard Sales and RMA Cycles

Confidential, IL

Lead Functional Consultant for R12 Implementation and Support


  • Developed simplified innovative solutions for complex business process to eliminate waste in resources
  • Configuring teh application based on solution design, performed gap analysis and designed workaround solutions
  • Training teh client’s super users and users on teh application and conducting pilot testing, integrated testing, design validation.
  • Functional documentation for Configurations (Setups), User Training Documents and Customization Documents. Experience in teh preparation of Standard Operating Procedures specific to Client’s business process with screen prints
  • Conducted CRP, SIT, UAT & PREPROD sessions for teh site additions and cutover was successfully completed for multiple sites.
  • Handled RICE objects for manufacturing modules and wrote several functional specification documents.
  • Created setup documentation for Inventory (INV), Costing (CST), Bill of materials (BOM), Work in Process (WIP), Engineering, Contract Manufacturing, EDI, XML (B2B integration) and Cost Management
  • Deployed Outside processing & Contract manufacturing process to meet teh business requirements
  • Integrated client’s secondary ERP system to external vendors and suppliers, contract manufacturers to has visibility to capacities and delivery times. Used B2B tools for integration (Fusion middleware B2B business objects, EDI, XML gateway)
  • Setting up Costs, Overheads, subelements, Costing reports, Cost rollups, Exploded cost rollups, cost types, Periodic Acquisition cost, Landed cost management and training users Copy costing, cost updates, variance review, WIp job closing monioor, GL posting from WIP and INV SLA. Shared Cost across orgs and month end closing.
  • Engaged in Requirement gathering (BRD), Solution Design (Process Documents) for Order management.
  • Engaged in Functional discussions with key business teams.
  • Preparing MD50, Test scripts for various scenarios.
  • Participated in deign reviews with technical teams. On RICE objects.
  • Preparing and giving client presentations.
  • Engaged in Functional testing and End to End applications testing
  • Tested teh Load Out and Load In Process with respective to shipping process.

Confidential, Atlanta, GA

Oracle Applications MFG Functional Consultant


  • Implementing & supporting various Oracle application modules in11i. iProcurement, Purchasing, Inventory & BOM.
  • Delivery of all functional documentation (AS-IS Process Maps, Future Process Maps, Fit-Gap Analysis, Functional Design) and appendices for any additions/changes to existing Oracle 11i solution, test scripts (CRP and Test script), and Setup Documentation.
  • Lot Genealogy, Operation Yield & Shrinkage usage for lot based costing in routings, Supply types, backflushing, WIP & INV Lots, Material Transactions, Move transactions.
  • Focused on Inventory and BOM, providing alternate solutions, Set-up of modules with user data using Data loader, Collected Requirement and Prepared Functional Requirement document (BR100) for BOM and Inventory Modules. Designed and implemented Item Status, Item Attribute Control, Item DFF, Item templates, Serial Control, Subinventory, Locators, Planners, Min-max planning, Cycle Counting, Item Attachments, Shipping Network, UOM Conversion, BOM Parameters, PTO Bills of materials and Manufacturing Calendar. Setup Application Users, Menu, Responsibility and Many form Personalization. Coordinated and guided teh off shore team for development of Item, Category, UOM and BOM Conversion and Interface programs, Resolution of pending transactions and open material transactions interface.
  • GAP Analysis and GAP resolution for ENGG / MRP / BOM / CST / WIP / QA / MES
  • Setup approval hierarchy, approval limits
  • Setup teh iProcurement as per teh business requirement
  • Worked around teh issues and bugs Resolution for PO Oracle 11i.
  • Setup teh training in teh area of Oracle purchasing and iProcurement.
  • Assisted teh user in creating teh test scripts and test application.

Confidential, Cambridge MA

Oracle Applications Functional Consultant


  • Implementing Oracle applications 11i. Order Management, Advanced Pricing, Purchasing & Inventory.
  • Followed AIM Implementation Methodology
  • Understanding business requirements for solution design.
  • Meeting with various user groups to understand ‘as is’ business process adopted by teh client.
  • Identify and discuss ‘to be’ process with users.
  • Evaluated setup options to match business process to be followed by client.
  • Prepared setup document (BR.100) for proposed application setup.
  • Setup CRP environment for process verification and logged issues identified.
  • Setup teh CRP and training environments
  • Assisting technical team in Conversions (data Uploads)
  • Preparing TE 40 for UAT
  • Coordinate testing all application solutions for verification of correct function and meeting business requirements.
  • Coordinating with client on daily basis for Project Deliverables.
  • Perform and document a risk assessment of teh requirements with teh objective of determining teh extent and scope of validation testing from 21 CFR Part 11 perspectives which is mandatory as a part of FDA norms (OQ and PQ Scripts) single point of Contact for Custom Reports / Conversions and other Functional Documents
  • Involved in Internal Quality/Audit Procedures


CAD & Production Automation Intern


  • Managing various electrical transformer tool manufacturing process Automation in shop floor.
  • Digitalize process flow for machine shop area and supervising teh resource availability.
  • Monitor teh new drawings released by engineering team and develop a e-process plan by checking teh resource availability.
  • Troubleshoot issues in e-Process map usage in manufacturing area and co-ordinating teh issues for resolution with engineering team.
  • Daily production update meeting co-ordination and reporting to Automation manager

We'd love your feedback!