We provide IT Staff Augmentation Services!

Oracle Supply Chain Functional Analyst Resume

5.00/5 (Submit Your Rating)

Deerfield, IL

SUMMARY

  • More than 8 years of experience as an Oracle Application Functional Consultant in Manufacturing, Inventory Control & Supply Chain/Distribution modules.
  • Implementation experience and functional expertise in Order Management (OM), Inventory (INV), Purchasing (PO), Advance Pricing, Bill of Materials (BOM), Work in Process (WIP) and iProcurement.
  • Experienced in business process operations, organizational assessment and translating them into functional requirements.
  • Design, analysis, configuration, testing, training, delivery, deployment and support of Oracle applications.
  • Experienced in end - to-end Inventory Control, Order to Cash (O2C), shipping and Procure to pay (P2P) business cycles.
  • Expertise in business process analysis, requirement analysis (AS-IS) system, (TO-BE) mapping, Fit - Gap Analysis (including Solution Designing), CRP testing, Integration testing, User Acceptance Test (UAT), system configuration, data conversions, master data loading, Go-live support including Post-Production support.
  • Expertise in Writing, Maintaining, Test Results and Generating software defects reports for the developers and well experienced in preparing User Scripts, User Manuals, test scripts as well as provide User training for a wide range of user groups.
  • Worked closely with large business users to understand the business processes, prepare the business requirements definition documents and Future Business Process model transformation.
  • Experience in data mapping & conversion from legacy system to Oracle and Data Migration procedures for 11i upgrade to R12 with coordinating technical team.
  • Expertise in implementing the projects and performing thorough testing during the UAT phase and cross validate the third party integrations as well.
  • Expertise in Purchasing concepts like creating various Purchase Order and releases as per the client business
  • Strong analytical, diagnostic and troubleshooting skills and Worked in cross-functional environment, in groups and with minimum supervision.
  • Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibility, Value sets, Flex Fields, Registering menus, Forms, Reports Concurrent programs
  • Used Application Implementation Methodology (AIM) for documenting activities of all stages of a project such as RD-20, BR-100, BR-150, BR-30, TE-020, TE-040, MD-050, CV-040 and create Standard Operating Procedures/Process flows (BP-080).
  • Worked closely with Oracle Support, logged several SRs and coordinated with Oracle Technical and Development teams by conducting Oracle Web Conference (OWC) sessions for high prioritized open issues.
  • Successfully completed 6-sigma certification and attended the project management (PMP) sessions.
  • Vast understanding of Lean Manufacturing, Kanban, Cost-benefit analysis of manufacturing technologies, Organizational assessment including Inventory and Demand management

TECHNICAL SKILLS

Modules: Oracle Purchasing, Inventory, Order Management, Shipping, Pricing, Advanced Pricing, BOM, WIP, iProcurement.

ERP: Oracle Application R12 & 11i (R12.1.3, R12.1.2, R12.1.1, R12.0.6, R12.0.5, R12.0.3, R12.0.1, 11.5.10.2, 11.5.10, 11.5.8)

Others: Data Loader, Web ADI, SQL Loader, TOAD, MS Office, MS Visio, Arena Multimedia, MATLAB.

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Oracle Supply Chain Functional Analyst

Responsibilities:

  • Extensively worked on PO, iProcurement, INV with cross functional integrations from Design phase through to delivery of all development objects including conversion and third party integrations etc.,
  • Worked extensively on BR100 documents and configuration documents in the design phase.
  • Create and update several functional design documents for custom reports in iSuppliers, conversions from legacy application to Oracle EBS and Interfaces (both In-bound and Out-bound).
  • Involved extensively on interfaces from Lawson AP to Oracle AP and coordinate with Technical team as well.
  • Extensively worked on functional designs for interfaces from Oracle AP, PO to several applications like AMT, Supplier diversity, Historical Invoice Restoration, FileNet, SunGard, Savvion, Post-Audit and others on the out-bound side.
  • Create and update design documents for interfaces like FileNet to Oracle AP, Savvion to AP and others on the inbound side.
  • Worked exclusively on Standard PO Conversion and Blanket Purchase Agreement Conversion from legacy purchasing application to Oracle EBS.
  • Worked on the conversion of existing Organizations, Jobs, Positions, Employees and employee assignments from legacy employee database to Oracle HRMS.
  • Conduct multiple meetings with key business users to get key decisions / finalizations on purchasing, KFF and DFF setups.
  • Designed a layout, input parameters and terms for a custom report on iSuppliers.
  • Involved in analyzing several lookup tables in purchasing and payables for conversions and interfaces
  • Performed complete Purchasing and INV setups in DEV1 & DEV2 instance.
  • Created purchasing hierarchies, approval limits, and approval assignments for purchasing.
  • Worked on several configuration documents. Configuration in PO includes purchasing options, receiving options, document types, organizations, DFFs, KFFs, DFF on requisition lines, INV period and so on.
  • Perform Configurations in PO, INV, AP, iProcurement include creating user sign-on, creating menus, responsibilities, request groups, AP STD profile options, DFF value-sets, DFF value-set values, payables lookups, distribution set, financial options and defaults, payables options, payment terms and so on.
  • Provide user training for offshore employees through Web sessions on prototype and customization process in PO, iProcurement, Inventory (INV) and AP modules with all third party integrations.
  • Coordinate with Offshore Technical team for timely deliverables of RICE components with detailed knowledge transfer on functional design to technical design. Perform detailed testing of developed RICE component as part of initial testing from Functional perspective.
  • Proposed several new approaches for the existing interface designs.
  • Involved in several PMO meetings, design decisions and document the same with timely follow-ups with business for prior approval on proposed decision to move to next level.
  • Maintain detailed documentation for each issue and followed the Change Management Process wherever there is a functional configuration change is proposed by the business and provide detailed functional impact analysis on proposed changes, if any.
  • Worked on making Test scripts and performed testing procedures for various functionalities and fix all configuration issues.

Confidential, Orrville, OH

Oracle Supply Chain Functional Analyst

Responsibilities:

  • Studied the existing business process & conducted meetings on client business overview
  • Prepared business requirement documents for Purchasing & OM
  • Defining and setting up of complete Procure To Pay cycle from entering the requisition in purchasing to entering the receipts and creating of the invoice in account payables module to support business requirements
  • Created requisition templates, approval hierarchy, sourcing rules, approved supplier list
  • Performed organizational set ups including inventory organizations, locations, freight carriers, items, parameters.
  • Defined product catalogs and categories in Inventory module
  • Setup stores, mapping catalogs to purchasing categories, and defined expense account rules in iProcurement
  • Performed setups for creating requisition for catalog and non-catalog items in iProcurement module
  • Assisted a project team in understanding the integration of Purchasing with iProcurement
  • Conducted Unit testing of Purchasing (P2P) cycle, iProcurement and Inventory modules.
  • Assisted in doing setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management.
  • Setting up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module for business transformation phase
  • Incorporated a new consolidation center, added new pickup location, and order types in Order Management to fulfill the requirements.
  • Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks
  • Worked in a team in understanding the integration of Advanced Pricing with OM process
  • Documented the new business processes & functional requirements & also provided with training materials to the business users.
  • Conducted CRP1, CRP2, CRP3 and coordinate UAT sessions with large business group of users.
  • Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management, & Advance Pricing modules
  • Designed the UAT test cases for various scenarios.
  • Executed User, Integrated and System Level testing with the technical team before the UAT planning.
  • Resolved the issues/bugs while the UAT and documented the same for further reference.
  • Provided user support in Go-Live phase

Confidential, Dallas, TX

Oracle Supply Chain Functional Analyst

Responsibilities:

  • Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
  • 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
  • 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 in OM including Advance 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
  • Analyzing the issues with data analyzing in the backend, 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
  • 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, Certificates 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 and Credit Memo process in Order Management, Account Receivables Application
  • Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
  • Troubleshooting the technical issues and preparing analysis on the issues in Oracle applications
  • Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management

Confidential, Naperville, IL

Oracle Supply Chain Functional Analyst

Responsibilities:

  • Participated in Ongoing process Enhancements and modification requests
  • Defined items, item status, item attributes and generated serial numbers and locators
  • Setting up of document types, buyer, supplier and approved supplier list in purchasing module
  • Defined price list, modifiers, qualifiers, price breaks as per the client requirement
  • Responsible for identifying cross functional dependencies and issues
  • Prepare and maintain BR100, BP80, BR150, MD50 and TE40 documents
  • Assisted team lead and other team members in setup and user interaction
  • Executed CRP's, prepared test scripts, smoke test and collected results
  • Worked closely with the development team on all application enhancement, requests and bug fixing.
  • Prepared user manuals and assisted the end users on inventory and purchasing module’s set-up, punch-out sites, payment options, and buyer activities
  • Trouble shoot problems pertaining to Purchase Order, Requisition, user access, notifications, suppliers etc.,
  • Participated in the configuration, implementation and testing of new client rollouts
  • Research the implementation issues on Metalink and, if needed, open a TAR with Oracle for critical issues
  • Was part of User Acceptance Test and recorded the UAT results
  • Provided post production support for Inventory and Purchasing
  • Rendered as a first point of contact for customer support during business and non-business hours to meet customer support response time commitments.

Confidential, Harrisburg, PA

Oracle Business/Functional Analyst

Responsibilities:

  • Analyzed and documented the functional requirement for data conversion and coordinated with the technical team to process the conversion
  • Performed inventory setups like inventory organization, locations, item parameters and replenishment planning
  • Setup of ABC classes for teams to aid in implementation of counting methodology
  • Setting up of complete order cycle setups from order entry in order management to ship confirm in shipping execution
  • Defined Price lists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing.
  • Modifiers include discounts, freight discounts and point price breaks
  • Analyzing the parameters involved in physical inventory and cycle counting
  • Involved in a feasibility analysis of integrating oracle functionality and legacy system
  • Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for
  • Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
  • Performed setups for split shipment process, drop shipment process, RMA process, in Order Management.
  • Performed setups for shipping parameters like picking rules, pick slip-grouping rules, release sequence rules for Order Management
  • Involved in planning and execution of CRP's
  • Communicated with other functional teams in order to integrate manufacturing functionality with the financial modules
  • Prepared TE-40 and executed the key test scenarios which include both inbound and outbound interfaces with external systems
  • Maintain issue tracker and coordinated with the team for speedy resolution
  • Prepared training materials to the business users
  • Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management & Advance Pricing modules
  • Participated in the User Acceptance Testing (UAT) Planning
  • Designed the UAT test cases for various scenarios
  • Resolved the issues/bugs while the UAT and documented the same for further reference
  • Conducted meetings for planning the cut over and go live phase

Confidential, Chicago, IL

Oracle SCM Functional Consultant

Responsibilities:

  • Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents (BR100) and other design documents as MD050 with the SOX approval
  • Conducted CRP1 testing for scenarios in Purchasing and iProcurement
  • Involved in planning CRP2, data conversion, data loading and training the end users
  • Coordination with the team for the test execution and issue resolution processes and providing the status update to project management team during the daily status calls
  • Creating Item Templates in Oracle Inventory module by modifying the control level option
  • Extensively worked on Item Attribute Controls and created different inventory items Oracle Inventory Applications.
  • Creating the shipping networks and Inter-Organization transfer between two child Inventory Organizations in Inventory module
  • Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations in Inventory application
  • Creating Job, Position, and Position Hierarchy in Oracle Purchasing Module
  • Setting up Buyer, Approval Groups, and Approval Assignments in Oracle Purchasing Application.
  • Trained and assisted the super users in testing.
  • 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)
  • Setup- supplier and supplier site
  • Created requisition templates
  • Setting up of various types of Purchase Orders i.e. Standard purchase order, Blanket purchase agreement, Planned purchase order and Contract agreement
  • Setup- of BOM structure, routing, operations, departments
  • Participated in the User Acceptance Testing (UAT) Planning and Go Live Scheduling
  • Tested and implemented the requested changes in existing setups
  • Trouble shoot problems pertaining to user and super user
  • Maintained all the updated documents
  • Based on the error's raised service request following with severity 1, 2 and 3.

Confidential, Gardena, CA

SCM Functional Analyst

Responsibilities:

  • Involved in planning & implementing the Upgradation from Oracle 11.5.10.2 to R12.0.6
  • Analyzed user requirements to R12 functionalities and mappings within the BOM, Inventory, WIP and OM modules
  • Provided manufacturing functional expertise during development of manufacturing execution system
  • Setting up the Order Management, Shipping Execution modules after finalizing on the requirements
  • Provided Super User and End User support for respective modules
  • Provided support and coordinated with the Financial team for O2C process
  • Helped continuously adapt OM’s business process and Oracle ERP System to support a dynamic business environment
  • Coordination with the team for the test execution and issue resolution processes and providing the status update to the project management team during the daily status calls
  • Worked collectively with other business areas including, planning, and finance to ensure that manufacturing function fully integrates with other business process
  • Trained end users on Inventory, Order Management modules with more prominence given to Order to Cash cycle.
  • Coordination with the client team for review and approval of the business process understanding documents, business process test scripts, list of custom components and delivery schedule
  • Worked on making Test scripts and performed testing procedures for various oracle apps modules (like: Inventory &Order Management)
  • Moved business organizations systems, data and processes from the west coast multi-organization to the east coast multi-organization Oracle environment
  • Conducted CRP’s (Conference Room Pilots) to ensure that the e-commerce business processes were defined for all major business processes and could be performed successfully using Oracle Applications

Confidential, Detroit, MI

Oracle Functional Consultant

Responsibilities:

  • Analyzed the current business process & performed Gap Analysis to map user requirements to oracle apps functionality
  • Performed a walkthrough of the To-Be business process flows
  • Reviewed the implication of the functional decisions being made during the setup processes
  • Involved in a feasibility analysis of integrating oracle functionality and legacy system
  • Defined product catalogue and categories in Inventory module
  • Worked on various setups like creation of items, creation of BOM structure and copying to multi-Org
  • Determined and defined the workday calendar
  • Determined the process for Min-Max planning
  • Setup of Bill of Material parameters, department classes, resources and locations
  • Assisted in setting up of shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
  • Oracle Inventory - Ship Orders, Update Inventory, Create/Manage Sales Orders, Inventory Planning methods
  • Involved & tested Oracle Workflow
  • Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management
  • Coordinated with the finance team in order to enter the financial information
  • Mapping the transactions relevant for client and ascertaining workarounds
  • Prepared various test cases based on scenarios and performed random tests to test the strength of the application
  • Wrote and tested business scenarios for CRP
  • Worked with end users to document the process and functional requirement also providing them with training material
  • Involved in Data Conversion Planning
  • Conducted system integration testing, involved in the User Acceptance Testing (UAT) Planning and updated the BR 100 document

Confidential, Duluth, GA

Oracle Functional Consultant

Responsibilities:

  • INV, WIP, BOM configuration setup
  • Customization requirements
  • 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
  • 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
  • Reviewed & maintained AIM documents
  • Set up item status, attributes control and item template
  • Wrote and tested business scenarios for CRP 1. Trained Users
  • Reviewed the implication of the functional decisions being made during the setup processes
  • Helped in developing user guides.
  • Prepared standard operating procedure for modification to the setup document
  • Prepared oracle suggested documentation for future reference
  • Rendered post production support in Purchasing and Order Management modules to the client
  • Worked closely with the technical team on all application enhancement request and bug fixing
  • Responsible for tracking of all issues and prioritize depending on the key business areas and time sensitive price constraints
  • Provide functional impact analysis for the proposed functional changes in production environment and coordinate with approvals from Project Steering Committee as part of Change Management Process.
  • Rendered support for researching, troubleshooting and testing product problems and client configurations
  • Trouble shoot problems pertaining to Purchase Order, Requisition, user access, notifications, suppliers set-up, payment options and buyer activities
  • Created service request and prioritized as SEV1 and SEV2 and conducted web conference to resolve the issues
  • Tested and implemented the requested changes in existing setups
  • Conduct multiple OWC sessions with Oracle Technical and Development team for detailed understanding of existing high priority issues.
  • Involved in training end users on application usage and developed the necessary document
  • Prepared standard operating procedures for modification/changes to the setup documents

Confidential, Santa Clara, CA

Oracle SCM Consultant

Responsibilities:

  • Gathered RD-50 and acquired process flow diagrams with knowledge transfer on extension of its functionality
  • Worked with Business Team for developing BR-100
  • Established and maintained clear communications on status, issues and progress with business team
  • Involved in analyzing the flow and replenishment of material
  • Involved in gap analysis to map user requirement to 11i functionality Helped continuously adapt OM’s business process and Oracle ERP System to support a dynamic
  • Provided support and coordinated with the Financial team for O2C process business environment
  • Provided Super User and End User support for respective modules
  • Defined item attributes and item categories, UOM and UOM classes
  • Complete setup for Procure to Pay Cycle.
  • Moved business organizations systems, data and processes from the west coast multi-organization to the east coast multi-organization Oracle environment.
  • Worked on making Test scripts and performed testing procedures for various oracle apps modules like Inventory and Order Management.

Confidential, Arlington, TX

Oracle Functional Consultant

Responsibilities:

  • Documented the business requirements and identified the gaps
  • Analyzed the existing business and system environment and mapped the future environment
  • Carried out system design for customizations, interfaces and extensions
  • Defined setups for Oracle Inventory. Used multi-org structure for each operating unit and validated the inventory parameters
  • Prepare BR100, TE40, MD50, BR30, BR150, BP80, CV40 and User Training manuals
  • Defined Setups for Trip Stop and Drop shipment
  • Designed conversion document for importing items from legacy systems
  • Created the setup for Forecasting demand and executing MPS and MRP cycles based on the input demand
  • Validated Setup steps for Bill of Materials like Parameters, Exception Templates, Locations, etc.
  • Performed tests on the transactional flows using inventory and work in process
  • Replicated and created transactions for different kind of test scenarios like Inter-org transfers, Intra-org transfers, receiving to simulate the actual business flow
  • Developed functional specifications for shipping document set reports and Pick list reports
  • Developed prototypes and demonstrated the functionality during CRP’s
  • Created pilot scripts and desktop procedures documentation while training users during pilots
  • Provide post-production support for Inventory and Order Management
  • Supported the end users in creating resource, creation, copying and transferring of bills
  • Maintained documentation for each issue and followed the change management process wherever there is a functional configuration change is proposed by the business and provide functional extension in the production environment.
  • Supported production environment and users on daily basis by responding to emergency requests
  • Finding out the errors made by the user
  • Execution of the modified test scripts with custom components as part of post upgrade testing of the cloned instance, for the inventory and order management functional areas
  • Proposed new solution for the existing interfaces
  • Worked on user menus and functional set-up and provided training to the end users

Confidential

Oracle IT Analyst

Responsibilities:

  • Team member in creating the OM configuration based on the business requirements and document the same.
  • Involved in implementation of complete order cycle setup from order entry in the OM module
  • Defined pricing attributes on basis of item attributes qualified for discounts
  • Setup and validation of modifiers like discounts, promo, freight and special charge
  • Created shipping setups for Pick release including Shipping parameters, Shipping transactions, Pick release rule and delivery grouping rules
  • Replicated and created transactions for different kind of test scenarios like purchasing, returning of items and ordering to simulate the actual business flow executed by the user community
  • Coordinated with functional personnel to resolve and fix bugs identified in the testing process
  • Prepared and documented a detailed training strategy for new end-users. Prepared Standard operating Procedures (SOP) for the end-users reference
  • Developed prototypes and demonstrated the functionality during CRP’s
  • Created pilot scripts and desktop procedures documentation while training users during pilots

We'd love your feedback!