Oracle procure To Pay Analyst Resume
Birmingham, AL
PROFESSIONAL SUMMARY:
- Over 11 years of experience in analysis, design, development, implementation and support of Oracle E - Business suite 11i and R12 for SCM and Manufacturing across multiple industries.
- Primary activities include performing fit gap analysis, solution designing, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support.
- Extensive experience in setting up and configuring Oracle Supply Chain Management suite Release 11i and Release R12 i.e. Oracle Order Management, Purchasing, iProcurement, iSupplier, Inventory, Advanced Pricing, Shipping, Cost Management, Bills of Material and Work in Process modules.
- Certified Oracle Order Management R12 Implementation Specialist.
- Implementation and roll-outs experience in Oracle Supply Chain Management based environment.
- Experience in 6 full life cycle Oracle R12 and 11i implementations and 3 support projects.
- Implemented and supported SCM across multiple businesses of GE (General Electric) i.e. Confidential, GE Power & Water, Confidential, Confidential and Confidential and Confidential and Office & Studio manufacturing business.
- Experience in handling full life cycle implementations i.e. Perform fit gap analysis, solution design, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support.
- Experience in end to end implementation and support of Oracle Order to Cash and Procure to Pay processes in Oracle Apps 11i and R12.
- Experience in implementing Approval Management Engine (AME).
- Experience in implementing BOM for PTO, ATO and CTO models.
- Hands on experience in setting up ETL and XML gateways to integrate electronic sales order creation and updates between third party systems and Oracle.
- Designed and implemented third party interfaces with Oracle Applications.
- Understanding of Oracle table structures, Schemas, Oracle open interfaces.
- Experience in building and analyzing SQL and PL/SQL scripts.
- Experience in preparing Functional specification documents and Test cases using AIM and OUM methodologies.
- Preparing and updating Requirements Test Traceability Matrix (RTM)
- Working knowledge of cross functional modules like Account Receivables, Account Payables, General Ledger, Service Contracts and Installed Base.
- Experience in supporting inventory period close and annual standard cost update activities.
- Good communication, analytical thinking, organizational skills and problem solving skills with proficiency in grasping new concepts quickly and utilize it in productive manner.
- Experience in collaborating with clients on business process enhancements.
TECHNICAL SKILLS:
Languages: SQL, PL/SQLTools & Utilities: TOAD, SQL Developer, Data loader
Domain Knowledge: Oracle Application - E Business Suite 11i and R12
- Order Management,
- Advanced Pricing,
- Shipping,
- Purchasing,
- iProcurement,
- iSupplier,
- Inventory,
- Bills of Material,
- Cost Management,
- General Ledger,
- Account Payables and Account Receivables
WORK EXPERIENCE:
Oracle Procure to Pay Analyst
Confidential, Birmingham, AL
Responsibilities:- Perform fit gap analysis, solution design, prepare process flows an conduct pilot sessions.
- Built the requirements traceability matrix.
- Designed solution around PO and Requisition approvals using Approval Management Engine (AME).
- Setup P-Card and built custom reconciliation engine.
- Performed an end-to-end solution for Procure to Pay by leveraging iProcurement and iSupplier functionalities.
- Implemented strategies on catalog management.
- Setup Local content zones and Punchouts in iProcurement.
- Setup Catalog Management.
- Perform fit gap analysis, solution design, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support.
- Improve existing business systems by implementing industry best practices.
Environment: Oracle EBS R12 (Purchasing, iProcurement, iSupplier, Payables, Order Management)
Oracle Order to Cash Analyst
Confidential, East Greenville, PA
Responsibilities:- Configuration and set up of Oracle Order Management and Advanced Pricing as per the business requirement.
- Perform fit gap analysis, solution design, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support.
- Improve existing business systems by implementing industry best practices.
- Design multiple Price List selection logic to derive correct PL selection for Configured Models/Options.
- Provided schema for numerous modifiers to match to qualifier criteria and drive correct Modifier selection
- Strategy to design PTO and CTO models in BOM.
- Design and implement Cross Order discounting by periods as qualified to customer specific orders
- Design Sales agreements that will become the base for Sales Order Agreements that can leverage SOA limits and terms for releases, returns and reporting against SOA Balance.
- Set up EDI and XML gateways between third party systems and Oracle application.
- Design Back to Back Orders, Configure to Order, Dropship orders based on planning priorities.
- Design, program and implement Oracle applications customized to meet client specific needs.
- Analyze the reporting and programming requirements of clients.
- Research, design, documentation, and modification of Oracle applications throughout the software development life cycle.
- Determines configuration requirements for systems, analyzes and improves performance of Oracle programs, analyzes requirements for data exchange between Oracle application and 3rd party systems, determines viable programming alternatives when configuration does not meet the required functionality and assists in developing and implementing technical standards.
- Document configurations, programs and subsequent revision.
- Work with cross functional teams for End to End Testing and smooth execution of Oracle Supply Chain suite with other oracle applications.
- Conduct extensive unit testing of programs and software applications to ensure they produce the desired results as per the technical and functional requirements.
- Translating business requirements into functional specifications for communication within technical teams.
- Train clients on use of Oracle application and provide technical debugging.
Environment: Oracle EBS R12.2.5 (Oracle Inventory, Order Management, Purchasing, iProcurement, Cost Management, Work in Process, Bills of Material, Account Receivables and Account Payables), SQL, PL/SQL and Dataloader
Oracle SCM Module Lead
Confidential, San Francisco, CA
Responsibilities:- Configuration and set up of Oracle Supply Chain Management for Order Management, Inventory, Purchasing and Advanced Pricing functional areas.
- Perform fit gap analysis, solution design, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support.
- Improve existing business systems by implementing industry best practices.
- Designed variations of Order Business Flows - order-to-cash, drop-ship, back-to-back, configure-to-order, and internal orders.
- Designed Order Creation with Different Types of Items.
- Implemented Pricing Strategies
- Created and managed Price Lists, Discount Lists - Tier-based discounts and Attribute based discounts and Shipping Charges
- Setup Change Management and Process assignment
- Defined Processing Constraints and Hold Codes
- Design, program and implement Oracle applications customized to meet client specific needs.
- Analyze the reporting and programming requirements of clients.
- Research, design, documentation, and modification of Oracle applications throughout the software development life cycle.
- Document configurations, programs and subsequent revision.
- Work with cross functional teams for End to End Testing and smooth execution of Oracle Supply Chain Management Cloud with other cloud services.
- Conduct extensive unit testing of programs and software applications to ensure they produce the desired results as per the technical and functional requirements.
- Translating business requirements into functional specifications for communication within technical teams.
- Train clients on use of Oracle application and provide technical debugging.
Environment: Oracle EBS R12 (Oracle Inventory, Order Management, Purchasing, iProcurement, Cost Management, Work in Process, Bills of Material, Account Receivables and Account Payables)
Oracle SCM Module Lead
Confidential, Schenectady, NY
Responsibilities:- Providing SCM Functional L2 Support on R12 - Order Management, Advanced Pricing, Shipping, Inventory and Cost Management modules.
- Troubleshooting on different types of sales order - standard sales order, Internal Requisition Internal Sales Order (IRSO), Return order- replacement.
- Designing and execution of test cases in Internal requisition and internal sales order (IRSO) flow, Back to Back and Drop Shipment scenario and setting up PTO and ATO models in GE Industrial environment
- Analyze and amend software/configuration errors in a timely and accurate fashion and provide status reports where required. Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced as per the technical and functional requirements
- Problem management for recurring issues and providing permanent solutions.
- Suggesting / providing process improvements to business
- Liaising with other partner teams like technical, DBA, sysadmin, L1, L2 etc. for troubleshooting of the issues
- Working with product company for raising Service requests and working with them for closure of the issues
- Perform unit and regression, patch testing in Oracle SCM modules for enhancements and quarterly releases
- Creating, updating and maintaining Custom component functional design documents, setup documents
- Providing business adhoc reports on need basis from the production.
Environment: Oracle EBS R12 (Oracle Inventory, Order Management, Purchasing, iProcurement, Cost Management, Work in Process, Bills of Material, Account Receivables and Account Payables)
Oracle SCM Module Lead
Confidential, Greenville, SC
Responsibilities:- Gathering business requirement, Performing Fit Gap analysis.
- Configuration of pricing attributes, modifier and qualifier.
- Setting up formula based pricing,
- Gross margin protection through Order management
- Re-pricing of sales order through re-pricing workflow
- Custom attributes mapping and pricing based on custom attributes
- Setting up discount, Free delivery and coupon discount setup
- Configuration of promotions (Buy1 Get 1, Other item discount)
- Creation of training manual.
Environment: Oracle EBS R12 (Oracle Inventory, Order Management, Advanced Pricing and Account Receivables)
Oracle SCM Functional Consultant
Confidential, Greenville, SC
Responsibilities:- Setting up organisation structure, customer type, different order to cash cycle flows- (drop shipment, back to back).
- Mapping of sales cycle using different order type (bill-and-ship, bill only, ship only, and re-price).
- Mapping of return flow, gross margin holds, version control.
- Mapping of margin, pricing, information in Advance Pricing modules- (modifiers, qualifier,)
- Mapping of Purchase Order, Inventory and Order Management touch points such as inventory items, reservation, move orders, purchase order, sales order issue and sales order pick.
- Setting up ATO, PTO Models, Option Classes and purchase items in Inventory and BOM.
- Interacted with client during the Implementation process, involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Application
- Involved in Implementation and support of complete end to end Procure to Pay and Order to Cash Process.
- Assigning Supplier in the Sourcing rule which is in the approved supplier list.
- Worked on creating the Sourcing rules to develop the continuity planning and to create auto Requisitions and Purchase order based on Sourcing Rule.
- Worked on purchase agreements in pricing for different suppliers.
- Worked on Modifiers and Qualifiers to display price on Purchase order.
- Implemented Different types of Sales Orders.
- Created AS-IS/To-Be Design Document (BP80), Customizations design document (MD50), BR100 (Configuration document) and CF250
- Lead the maintenance of issue tracker
- Involved in End user training.
Environment : Oracle EBS R12 ( Oracle Inventory, Order Management, Advanced Pricing, Purchasing, Cost Management, Account Receivables and Account Payables)
Oracle SCM Functional Consultant
Confidential
Responsibilities:- Designed business process and application configuration for Oracle Procure to Pay (P2P) and Order to Cash (O2C) processes.
- Interacted with the key end users and business owners to map applications to standard business processes and conduct gap analysis
- Supported all formal documentation of solutions
- Lead all solution activities including testing and verification
- Contributed to the training and development of key users
- Reported to senior management and worked with global teams during implementation and post go-live
- Developing functional designs for Oracle solution components (HLDs)
- Developing prototypes/Conference Room pilots to validate solution design
- Worked with cross-functional teams (Oracle Applications Development and Supply Chain business) to design and implement business requirements
- Worked with key members of various departments and IT teams to identify and resolve application issues, system enhancements, and new user requirements
- Worked with the project team in resolving application issues, in designing and implementing system enhancements, and in documenting new user requirements
- Worked with other external application teams in identifying data requirements and interface designs to meet solution objectives.
- Provide input for production related issues
- Requirement gathering, gap analysis and solution design for Supply Chain and Manufacturing modules.
- Designed Process flow and ER diagrams for Order Management (Drop Ship and Back to Back orders) and Purchase Order (Blanket Purchase Orders).
- Designed Functional Design Documents (MD50) on Oracle Sales Order Interface, Status updates
- Written rules and formulas for configuration setups.
- Worked on creating the Sourcing rules to develop the continuity planning and to create auto Requisitions and Purchase order based on Sourcing Rule.
- Setup Position Hierarchy, Sales Agreements.
- Setup Quote to Cash flow
- Interacted with the key end users and business owners to map applications to standard business processes and conducted gap analysis
- Created AS-IS/To-Be Design Document (BP80), Customizations design document (MD50), BR100 (Configuration document) and CF250
- Lead all solution activities including testing and verification
- Contributed to the training and development of key users
Environment: Oracle EBS R11 ( Oracle Inventory, Order Management, Purchasing, iProcurement, Work in Process, Bills of Material, Advanced Pricing, Cost Management)
Oracle SCM Functional Consultant
Confidential
Responsibilities:- Understanding the As-Is process, Solution Design and map To-Be Process, Identify the Gaps and Fit-Gap analysis in the Concept to Product (CTP) and Plan to Build (PTB) Tracks.
- Conduct Requirements gathering workshops and document the “As-Is” process, to understand the current process followed at GE Manufacturing Plants.
- Design and document the ‘To-Be’ process flows and Context diagrams after collating requirements from all Manufacturing Plants.
- Configuring the instance for Inventory, Order Management, Purchasing, Bills of Material, Cost Management, Work in Process modules of Oracle Apps
- Drive Conference Room Pilot sessions, Requirement Gathering sessions with the Business team and drive Key Design Decision (KDD) discussions.
- Preparing the Test Scripts for CRPs and Capturing the Requirements / Defects.
- Identifying the RICE to fit a Gap and documenting Functional requirements for RICE area.
- Designing Data Conversion Strategy document. Provide functional inputs for mapping the fields with Legacy System during the Data Conversion activity in the track.
- Worked on implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables and Procure to Pay (P2P) cycle including Requisitions, Purchase orders, Receipts, Account Payables.
- Was involved in various enhancements, implementations and regular support activities on Oracle EBusiness suite including setups on Customer cross reference, shipping terms, pricelist assignments, processing roles, Items, Organizations, sourcing roles
- Involved in the design MD50, Technical Specification Docs (MD070), and Unit Test Cases Docs (MD 120)
- Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement in Oracle Application Object Library (AOL).
Environment: Oracle EBS 11.5.10 ( Oracle Inventory, Order Management, Purchasing, iProcurement, Work in Process, Bills of Material, Advanced Pricing, Cost Management)
Oracle SCM Functional Consultant
Confidential
Responsibilities:- Resolving day to day business issues and handling enhancement requests in Oracle Purchasing, OM, iProcurement, iSupplier, Inventory, Advanced Pricing and Cost Management by closely following up with the business and raising SR’s with Oracle Support.
- Production support in P2P and O2C cycles.
- Preparing the functional design documents for enhancement request.
- Performing functional testing and preparing the test cases for enhancement requests.
- Conduct user training on new process changes.
- Support users in period end process.
- Monitoring the monthly EBS off releases that are part of implementing the enhancements and patches by production support team in different modules.
- Interact with the business users through regular meetings and provided updates on all open issues.
- Perform Physical Inventory, Annual Standard Cost update and Month end closures
- Identifying the missing setups and configurations and resolve issues in Purchasing and Order Management modules.
- Providing business adhoc reports on need basis from the production
- Working in an onsite- offshore delivery model
Environment: Oracle EBS 11.5.10 ( Oracle Inventory, Order Management, Purchasing, iProcurement, Work in Process, Bills of Material, Advanced Pricing, Cost Management)
Oracle SCM Functional Consultant
Confidential
Responsibilities:- Perform Physical Inventory, Annual Standard Cost update and Month end closures for US and Canadian OUs.
- Correct the errors by making appropriate changes and re-checking the program to ensure that the desired results are produced
- Worked in resolving the technical and functional related issues related to QTC (Quote to Cash).
- Worked on resolving the Configurator issues such as formula setups, rules etc.,
- Involved in Functional setups and workflow for Order Management
- Preparing the functional design documents for enhancement request.
- Providing business adhoc reports on need basis from the production
- Working in an onsite- offshore delivery model
Environment: Oracle EBS 11.5.10 ( Oracle Inventory, Order Management, Purchasing, Work in Process, Bills of Material, Advanced Pricing, Cost Management)