We provide IT Staff Augmentation Services!

Oracle Applications - Functional Consultant Resume

SUMMARY:

  • More than 9 years of experience in Implementation/ Upgrade / Support of Oracle ERP applications in various modules like Inventory (INV), Purchasing (PO), Order Management (OM), Pricing, Shipping, Product Data Hub (PDH), Supplier Life Cycle Management (SLM) and Customer Data Hub (CDH).
  • Working knowledge on Advanced Supply Chain Planning (ASCP), Bill of Materials (BOM), Work in Process (WIP), Account Payables (AP), Account Receivables (AR) and General Ledger (GL)
  • Proficient in analyzing business requirements, process flows, fit and gap analysis, solution design, conversion strategy, production cutover, testing, (including UPK), production support and change management.
  • Extensive exposure in preparation of AIM methodology documents such as RD020, BR100, BP080, BR010, MD50 and end user manuals.
  • Strong experience in various rounds of System Testing, Functional Testing, Integration Testing and User Acceptance Testing.
  • Served as a liaison between the business and IT to provide Oracle functional and technical business solutions that meets needs of client managers and other stake holders.
  • Experience in the preparation of standard operating procedures specific to Client’s business process with screen prints.
  • Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users etc.
  • Highly motivated team player with positive attitude, goal oriented and excellent business and interpersonal skills.

TECHNICAL SKILLS:

ERP: Oracle Applications R12, 11i (11.5.8, 11.5.9, 11.5.10 and 11.5.10.2)

Oracle Applications: Product Data Hub (PDH), Supplier Life Cycle Management (SLM)Order: Management, Quality, Mobile GUI, Inventory, Purchasing, Pricing, Shipping Execution, ASCP, Advanced Procurement, Account Receivables, Account Payables, Bill of Materials, Work in Process, iProcurement and Payables.

Languages/Tools: Developer/2000, Forms 4.5, PL/SQL, Oracle C, C++, COBOL, Visual Basic 4.0, Power Builder.

Operating System: Windows XP, Windows NT, MS DOS, and UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications - Functional Consultant

Environment: Implementation and support of Oracle App 11i/ R12 in Purchasing, Order Management, Shipping, Inventory, ASCP, Work in Progress, Bills of Material.

Responsibilities:

  • Introducing and the super users on various Oracle modules include Inventory, Purchasing, Order Management, Shipping, ASCP, Work in Progress and Bills of Material
  • Thoroughly understanding the business requirements and providing them the best work around to satisfy the business needs
  • Identifying the gaps and coordinating with the development team to build the customizations.
  • Preparing test cases, test scenarios and testing the custom objects (reports, Form personalization’s, Forms and etc.) prior migrating those to Production
  • Writing the PL/SQL reports in various modules to help the users in day to day activities
  • Troubleshooting and analyzing the various issues by writing the SQL queries
  • Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench
  • Extensively working on lead times, lot multipliers, fixed days supply, Minimum order quantities related to ASCP
  • Extensively working on the integration between Shiplinx and Order Management to calculate the freight and waybill number to execute the shipping in Oracle
  • Extensively working on migrating the open orders / on- hand from the legacy (GLOVIA) system to Oracle
  • Preparing functional design documents (MD50), business requirement documents (BR100)
  • Resolving the production issues on the dropship sales order, Outside processing and other various day to day transactions in Order Management and Inventory
  • Modifying the business process to reduce the cost of the operations while implementing the functionality in Oracle
  • Extensively working on intercompany sales orders in Order Management/ Purchasing and inter-org transfers in Inventory application
  • Explaining users to fix the issues on Push model and the related transactions in Work in Progress
  • Thoroughly the users on checking the items where used, on-hand, transactions, supplier quotations, Sourcing rules, sourcing assignments and etc. to help them in daily activities.
  • Based on the business needs, providing the checklist to the key users on the sequence of the steps to perform in Oracle prior creating a Purchase Order and Work order in Purchasing and Work in Progress modules
  • Setting up the designators for the bills in Bill of Materials
  • Preparing PL/SQL custom reports on various modules

Confidential

Oracle Applications - Functional Consultant

Environment: Implementation and support of Oracle App R12 in Purchasing, Order Management, Inventory, Supplier Life Cycle Management (SLM) and Customer Data Hub (CDH)

Responsibilities:

  • Gathering the business requirements from the end users, mapping it to Oracle R12 and identifying the gaps to implement Supplier Life Cycle Management (SLM) and Customer Data Hub (CDH) modules
  • Preparing functional design documents (MD50), business requirement documents (BR100) and test scripts
  • Extensively working on Data quality management to implement supplier / customer data hub modules in Oracle applications
  • Preparing the data mapping documents for Item and Supplier conversions
  • Troubleshooting the issues on standard purchase order approvals Approval Management Engine (AME) in purchasing application
  • Extensively working on user defined attributes (UDAs) and restricted the privileges for the users to update/view the UDAs in R12 modules
  • Troubleshooting the purchase order/ requisition approval issues in various business scenarios.
  • Involved in production support for the existing and enhancements done
  • Designing oracle reports and troubleshooting the production issues using PL/SQL

Confidential, Seattle, WA

Oracle Applications - Functional Consultant

Environment: Implementation and support of Oracle App 11i (11.5.10.2)/ R12 in Inventory, Purchasing, Order Management and Quality

Responsibilities:

  • Extensively working on enhancements to the existing functionality in Inventory, Purchasing, Order Management and Quality applications
  • Monitoring the production issues using Remedy tool and resolving them in Inventory, Purchasing, Order Management and Quality using Remedy tool
  • Working with various business users to understand and create the business requirements, functional design documents (MD50), scenarios and test scripts
  • Coordinating with the technical and the testing (QA) teams to clarify the solutions and thoroughly participated in system integration, unit and regression testing
  • Creating MDF (Master Design Framework) documents to analyze the risk, benefit, advantages and cost effort to develop a new solution and DEMO it to the super users as a part of finalizing the solution for the business requirement
  • Extensively working on drop-ship and internal sales orders within the part of customized solution to procure the Green Coffee beans from various suppliers and sell it to the Starbucks customers
  • Creating collection elements, collection plans with dynamic view creation in Quality application.
  • Working on shipping networks, custom value maps to derive the certain field values to perform the sales order creation process and the receipt transactions in EBS
  • Coordinating with the business users and helping them to fix the production issues on the devanning process for the Green Coffee and TAZO
  • Configured the customer managed freight for the purchase orders/ releases and modified the purchase order report template to communicate to the suppliers about the freight management
  • Working with the Supplier Transportation Integration (STI) team to accomplish the tasks related to integrate the EDI ASNs (Advanced shipment notices)
  • Coordinating with the business to understand the requirements and creating the functional design documents (MD50s) for Oracle form personalization’s in Purchasing application
  • Extensively working on quality control (QC) tool to create the enhancement requests / defects and working with the technical and the testing teams to successfully complete the task
  • Logging service requests (SRs) with Oracle to resolve the production issues in Purchasing application

Confidential, Durham, NC

Oracle Applications - Functional Consultant

Environment: Implementation of Oracle Apps R12 in Inventory, Purchasing, iProcurement, Order Management, BOM, WIP, MRP, MPS, AP, AR

Responsibilities:

  • Gathered the business requirements, identified the functional specifications, and mapped to R12 Inventory, Purchasing and Order Management applications
  • Extensively worked on unit of measure conversions, item categories, cross s in Inventory
  • Created setups for converting Freight costs to charges, auto-packing, customer item number in Order Management
  • Created Position Hierarchies, Approval Groups, Approval Assignments, Approved Supplier List, Sourcing rules for various items being used in MRP/ MPS
  • Created various Order Management transaction types, picking rules, Document categories, Document Sequences based on the business requirements in Order Management
  • Worked on Blanket Sales Agreements with version control and approvals in Order Management applications
  • Extensively worked on outside processing and drop shipment flows in Purchasing/ Order Management integrated with Work in Process and Bill of Materials application
  • Worked on Purchasing item categories and expense accounting rules being used in iProcurement and Purchasing applications
  • Prepared documents, BR100, setup documents, test scripts for the business users.
  • Participated in CRP1, CRP2 and CRP3 for demonstrating the R12 functionality in Inventory, Purchasing, Order Management applications
  • Extensively worked with business users to resolve the issues and also coordinated with Oracle to resolve the Production issues
  • Worked on auto-create process to automatically create MRP driven Purchase Requisitions and Blanket Releases
  • Extensively worked on auto-creating the invoices imported from Order Management and troubleshooting the issues when importing the sales orders
  • Worked on invoices created against purchase orders and resolved the issues in matching the purchasing orders
  • Created Bills, Routings, Standard Operations, Departments, Resources based on the business requirements

Confidential, Boston, MA

Oracle Applications - Functional Consultant

Environment: Implementation in Oracle Apps R12 Supplier life cycle management

Responsibilities:

  • Gathered the business requirements, identified the functional specifications, and mapped to R12 Oracle in supplier management application.
  • Implemented DUN and BRAD street (D&B) setups in Supplier management application.
  • Created Bulk import setups to import the suppliers into R12 after applying Data quality management (DQM) rules
  • Created custom transformation rules using Data quality management in R12 Oracle
  • Extensively worked on D&B sourcing rules and user defined attributes (UDAs) to implement Supplier management module
  • Worked on different negotiation styles using R12 Sourcing application and created custom negotiation styles to meet the business requirements
  • Created BR100s and MD50 documents to implement customizations - import the D&B data into R12 Oracle, Export Multi row UDAs, Generate Supplier detail report in R12 Supplier management application
  • Worked with super-users to give the knowledge sharing on the R12 application
  • Defined user defined attributes at various levels(supplier, site levels) in R12 Supplier management application
  • Heavily coordinated with the team members to implement the R12 Advanced Procurement using Purchasing, Sourcing, and Service Contracts applications.
  • Worked as a lead for the end users during the implementation of the Supplier Life Cycle Management application
  • Mapped the user defined attributes to the profile pages at the prospective supplier level in R12 Oracle
  • Created sourcing events and mapped to the suppliers to create request for quotes (RFQs) in R12 Oracle
  • Extensively worked on testing the customizations in different Oracle instances - DEV, QA
  • Worked with Oracle support to fix the bugs and tested the environment after applying the required patches
  • Created test scenarios and test scripts to test the various functionalities in R12 Oracle

Confidential

Oracle Applications - Functional Consultant

Environment: Implementation and support in Oracle Apps 11.5.10.2 in Inventory, Purchasing, Order Management, Shipping, Advanced Pricing, Bill of Materials, Work in Progress, Service Contracts, Account Payables, Accounts Receivables and Costing, Oracle R12 (12.1.2) in Inventory, Purchasing (Advanced Procurement)

Responsibilities:

  • Identified the functional specs, prepared the documentation setups and business requirement documents (BR100), setup documents and functional design documents (MD050)
  • Provided the suggestions/options of the best way to implement their need in Oracle Applications with the SOX approval
  • Troubleshooting the production issues on various applications (Work in Progress, Bill of Materials, Purchasing, Inventory, Material Planning, etc.), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
  • Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application
  • Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Year end processes
  • Troubleshooting and fixing the issues in Order management application - Tax code, Customer credit check, Backordering, Return Material Authorization issues
  • Created Oracle service requests and fixed the bugs in Oracle Work in Progress application with the help of Oracle support. Tested the fix in TEST instance prior to apply in other instances.
  • Trained the super users by providing documents using VISIO flow diagrams for better understanding.
  • Prepared the functional design documents to explain the functionality of the custom concurrent programs in Oracle Costing application by analyzing the PL/SQL program
  • Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing
  • Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
  • Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing
  • Created the material documents on various applications in Oracle
  • Created Inter-org transfer setups for Inventory application in Oracle R12
  • Troubleshooting the order management, invoices, intercompany, WIP transactions, etc issues using SQL statements in Oracle
  • Provided a test DEMO in R12 including Product data hub (PDH), Inventory, Order management applications
  • Prepared and knowledge sharing materials on Costing, Item Revisions, View Potential Shortages for the item using Microsoft PowerPoint
  • Trained the super users by giving demonstrations on various process flows in oracle applications and helped them to understand the process in a better way
  • Prepared business requirement, functional design documents and working with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances
  • Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Supply chain management, Financials, Manufacturing areas
  • Troubleshooting the issues on Service Contract (on returns, exchanges, repairs) application and providing the fix, solution to resolve the issues
  • Troubleshooting the issues on Telesales, CRM applications
  • Gathered the requirement details from the super user and enhanced the Oracle custom report (in PL/SQL) in Bill of Material (BOM) application

Confidential, CA

Oracle Applications - Functional Consultant

Environment: 11i/ R12

Responsibilities:

  • Gathered Business Requirements from business users and prepared Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
  • Worked with Development team to built the functionality for the new requirements and tested in DEV / QA instances before migrating it to UAT and PROD instances
  • Understanding / Reproducing / Analyzing / Troubleshooting / Resolving Product Data Hub (PDH) functional issues and helping development team to resolve technical issues
  • Understanding and identifying the complexity of new PDH business requirements and proposing the solutions / options to accomplish the requirements as a part of implementing PDH SKU 1.2 project
  • Extensively worked on PDH and ERP interfaces as a part of daily activity and troubleshooting / analyzing the issues on those Interfaces
  • Creating / Updating / Deleting SKU’s, SKU Relationships using spreadsheet tool in PDH, pushing the updates from PDH to ERP by running synchronization programs, and Troubleshooting the Synchronization issues between PDH and ERP
  • Worked on Flexfields- segments, value sets, values and look up codes in PDH, ERP
  • Worked on File Upload tool for mass updates on Tax Categories, SKU attribute values, Business Rules.
  • Worked on Autogen tool to create / update SKU’s in PDH, ERP at a batch level and troubleshooting the issues while creating / updating/ Restricting / Granting the access to create / update the SKU at different levels - SKU, SKU attributes, SKU catalog by setting up the rules in setup work bench in PDH
  • Worked on dynamic Mini tables to create / update the business rules using file upload tool in the customized Oracle form.
  • Extensively worked on Item Search based on different attribute values by creating our own search criteria.
  • Extensively worked on Spreadsheet upload, Multi Item Extract form tools to create / update / delete the SKU for various Inventory Organizations.
  • Created SKU (Item) setups for Attribute Groups, Attributes, Catalogs, Item Pages, Display Formats in PDH application
  • Worked on Parent and Child SKU (exploded SKU) setups and fixed the issues on Auto-explode linking logic which is being used while creating the SKU’s using Autogen Tool in PDH application
  • Worked on Item Relationships and actively participated to implement the Relationship enhancements for all type of SKU’s in PDH- Provided the functionality to create Item Relationships based on the user configurable rules
  • Actively participated on Spreadsheet Upload tool enhancements in PDH - Provided the preview functionality to review the staging data before committing it to the PDH
  • Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production
  • Worked on gathering the business requirements for the NEW SKU releases and mapping into Oracle 11i, identifying the GAPS and providing the alternatives to minimize the GAPS.
  • Preparing business requirement, functional design documents to develop the custom reports in various applications in Oracle
  • Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
  • Extensively worked on Price Upload, Item Upload, Autogen process to create / update the Items, Prices in Oracle testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
  • Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO
  • Extensively worked on Change Requests (CR’s) and preparing the BRD’s, FD’s on OM, Advanced Pricing module
  • Extensively worked on troubleshooting the issues on Custom Concurrent Programs in Oracle, providing the workaround and finding the Root Cause of the issues.
  • Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances
  • Analyzed the issues using TOAD, providing the workaround to fix the issues, testing the workaround in TEST instances and providing the updates to Business.
  • Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the setups in TEST instance
  • Monitored the help requests created by the Business in AdvenNet software and helped them in resolving the issues.
  • Troubleshooting the issues while updating / creating the Prices, Items in Oracle using Price Upload, Item Upload, and Autogen.
  • Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules
  • Worked on creating the Licenses, s for the various SKU’s in Order Management, Inventory Application
  • Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
  • Extensively worked on different Inventory transactions and solved the period end issues
  • Worked on the different Purchase Order setups, generated the invoices, and resolved the pending transactions
  • Worked on RMA Process, importing EDI orders, and Credit Memo process in Order Management, Account Receivables Application
  • Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
  • Created category sets, category codes, default category sets for the various items in Inventory application
  • Troubleshooting the technical issues and preparing analysis on the issues in Oracle applications
  • Worked on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management
  • Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
  • Implement various improvised processes to prevent user errors and stabilizing the system.
  • Implement major modifications in the application with focus on making the system more user friendly and ease in extracting the required data from Oracle.
  • Work on major upgrades of database and application that included testing of major upgrades and releases.
  • Co-ordinate with Oracle Support for resolution of TAR’s- Worked with Oracle to resolve the issue on maximum number of attributes within the multi level row attribute group, and the mini table setup issues
  • Serves as part of the Transition Project that successfully enabled the Team to start within the specified timeframe
  • Responsible for of end-users and provided the aggressive support to resolve the UAT, Production issues

Confidential

Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.2.

Responsibilities:

  • Understanding the clients business and taking care of the business users help requests on Oracle Apps using AdvenNet software
  • Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, BOM, WIP, Mobile GUI, AP and AR Applications
  • Monitored the business users screen to understand the issues and fixing it by guiding them to complete the process in a right way
  • Analyzed the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications
  • Replicated the critical issues in Test instances to fix the problem in PROD instance

    Resolved the issues on Pending Transactions from various applications

  • Resolved the month end issues and prepared a setup document for Month-end closing
  • Worked on Mobile GUI Application for Receiving, Picking, Packing, Dropping, and Unpacking the items
  • Resolved Physical Inventory and Cycle Count issues in Inventory Application
  • Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
  • Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application

    Extensively worked and resolved the issues on Work Flows (Requisition, Purchase Order, RMA Order, Standard Sales Order, Internal Sales Order, Drop Ship Order)

  • Worked on Modifiers, Qualifiers, Price List setups to define the discount (or) surplus charges at various levels in OM application
  • Resolved the critical issues on Shipping Execution while Ship Confirming the Sales Order.
  • Worked and fixed the root cause problems in BOM, WIP Applications
  • Worked on workflow notifications and re-routing the notifications to other employees based on the super user requests
  • Resolved the issues while importing the EDI orders to OM Application
  • Worked extensively on Over (or) Under Shipment tolerances and corrected the setups to populate those values as needed in Order Management module
  • Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups according to the business needs in Order Management module with the SOX approval
  • Worked on Shipping Tolerances at Customer level in Order Management Application
  • Worked with client in suggesting & developing position hierarchy for organization in Purchasing module
  • Good Knowledge on Blanket Purchase Agreement and Releases in Purchasing Application
  • Worked extensively on Item categories, Category sets, Category codes and resolved the issues on Item categories for the reports in Inventory and Purchasing modules
  • Troubleshooting and clearing the PO Approval issues, Stuck POs from the Workflow utilizing the standard scripts from Oracle
  • Worked with different teams to resolve the issues for the assigned sites. Research the issues on Metalink and Open the TAR with Oracle for critical issues and following up with Oracle support regarding bugs and patches
  • Resolved the issues on Taxes, Freight charges for the customers in Order Management Application

Confidential

Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.2

Responsibilities:

  • Understanding the client’s business process and gathering the Business Requirements from the business users to map into Oracle Applications
  • Participated in CRPII to explain the business process flow in Oracle according to OVT business needs
  • Conduct the GAP analysis and prepared Business Requirement Documents (BRD100) and MD050’s, MD070’s with the SOX approval
  • Worked extensively on Unit Testing, and System Integrated Testing
  • Prepared User Manuals in INV, PO, and OM applications and trained the super users
  • Worked extensively on Inter Company transactions, Inter Organization transactions in Inventory application
  • Creating functional design documents to build the new Oracle custom reports and testing the developed reports before migrating it to the other instances
  • Created various order types with the approval hierarchy in Order Management (OM) module
  • Worked on Quote Management in OM including creation of versions for the Quotes
  • Worked extensively on Return Material Authorization (RMA) transactions in Order Management
  • Created Purchasing Hierarchies, Approval Limits, Approval Assignments for the various positions in Purchasing application
  • Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications
  • Created Inter Company price list for Inter Company transactions in Order Management and Inventory application
  • Extensively worked on Modifiers, Qualifiers to create a price list for various items in Order Management module
  • Created setups to import Freight Costs entered at shipping into Account Receivables module

    Created setups for Physical Inventory in Inventory Application

  • Set up user defined transaction types for inventory transactions pertaining to the issues done to the various cost centers from Stores. Custom Pll was developed to restrict the Transaction Types LOV based on the Inventory Organization in which the transaction is being performed
  • Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups
  • Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
  • Set up of buyer less procurement process for frequently procured items through the internal catalog for iProcurement requisitions. Set up of ASL’s for iProcurement-requisitioned items with release generation method “Release using Create” enabling auto generation of Blanket Releases, Standard Purchase Orders against the Blanket Agreements and Catalog Quotations
  • Defined ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations.
  • Created category sets, category codes, default category sets for the various items in Inventory application
  • Performed regression testing during upgrades and taking the ownership of the user management during the full life cycle implementation
  • Responded to functional assistance tickets from the super users, problem analysis and resolution

Confidential

Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.2.

Responsibilities:

  • Understanding the client’s business process and mapping into Oracle Applications accordingly
  • Identified the functional specifications, preparing the documentation setups, Business Requirement Documents (BRD100) and functional design documents as MD050 with the SOX approval
  • Provided the suggestions/options of the best way to implement their need in Oracle Inventory Organizations
  • Created Item Templates in Oracle Inventory module by modifying the control level options
  • Created the shipping networks and Inter-Organization transfer between two child Inventory Organizations in Inventory module
  • Defined ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations in Inventory application
  • Trained and assisted the super users in testing.
  • Worked on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management
  • Worked extensively on Advanced Pricing setups in Oracle Order Management - Defined Pricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, Freight Charges
  • Set up Pricing Attributes, and Pricing Contexts in Advanced Pricing
  • Created Multi-Currency conversion setups in Advanced Pricing for various items
  • Resolved the issues on Drop Shipment and Internal Sales Order in Order Management
  • Created Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
  • Generated the invoice against the sales order in Account Receivables module.
  • Set up processing constraints to restrict the users to cancel the sales orders at different stages
  • Set up the appropriate Price List in Order Management Application for various inventory items
  • Demonstrated the configuration setups for the new child inventory organization, different Items, Item attributes and the item template in Inventory application
  • Research the issues on Metalink and Open the TAR with Oracle for critical issues.

Confidential

Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.

Responsibilities:

  • Mainly responsible for mapping the client’s business process in the modules of Oracle purchasing and iProcurement
  • Responsible for doing the gap analysis based on the customer’s requirement
  • Responsible for the setups for purchasing (PO) with the SOX approval
  • Defining Positions, Position Hierarchy, Approval Groups, Approval Assignments, and Document Types in purchasing module
  • Was responsible for the setup of items, defining cost types and assigning cost to the items.
  • Setting up the setups forContract Purchase Orders for Multi Function Printers
  • Setting up Item templates, Item attributes, UOM and UOM classes
  • Setting up of Approved Supplier List, Assignment Set, and Sourcing Rules for the service Items with release generation method “Automatic Release” for auto generation of Blanket Releases and Standard Purchase Orders
  • Setting up Group by option as “Vendor” to pick up the requisition lines through scheduled “Create Releases” program before the end of the day to optimize the Purchase Order costs. (Reduced number of Purchase Orders creation)
  • Worked with client in suggesting & developing position hierarchy for organization

    Defining and maintaining receiving options, control options, Payment terms, Purchasing locations, buyers, approval groups, approval assignments

  • Developing business relationships and integrating activities with other IT colleagues, primarily developers to ensure successful implementation and support of projects
  • Analyzing the PO Approval issues and clearing the Stuck POs from the Workflow utilizing the standard scripts from Oracle
  • Enabling descriptive Flexfields and key Flexfield segments on some forms in Oracle Purchasing Application
  • Defining the Purchasing, Receiving and Financials Options as part of the setup
  • Coordinated with business users and IT in developing new solutions based on gap analysis
  • Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances
  • Preparing Test Cases for the new functional requirements
  • Preparing process mapping, GAP and User Documents
  • Testing of the migrated changes in QA Instance and giving sign-off to move production.
  • Developing business relationships and integrating activities with other IT colleagues, primarily developers to ensure successful implementation and support of projects
  • Research the issues on Metalink and Open the TAR with Oracle for critical issues