Supply Chain Functional Consultant Resume
Pittsburgh, PA
SUMMARY:
- 10+ years of IT Experience, which includes experience as a Functional Consultant/Business Analyst with specialization in Oracle Supply Chain and Distribution Systems His industry experience revolves around Oracle ERP Applications - Implementation, Support and Upgrade.
- He is well conversant Oracle Supply Chain Modules - OM, Advance Pricing, AR, PO, i-Procurement, INV, WIP and BOM. Have 2 full life cycle implementations in Release 12. He well understands for both the “Quote to Cash” process as well as the “Procure to Pay” process. He is very much conversant with Configuring Oracle Application modules as well as understanding the underlying schema, which give me a better insight into converting user requirements into functional and technical specifications.
- Extensive experience with of End Users and Business Super Users using Oracle Tutor, WebEx virtual and well as conducting of CRP’s and UAT’s. Well versed in preparing material and manuals.
- He has been actively responsible for testing of the functionality of Oracle ERP Application. He is well conversant with documentation as per the AIM methodology. He has also been involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions. He is actively involved Conference Room Pilots and User Acceptance Testing. His responsibilities also include building, testing & development as per Business Requirements.
PROFESSIONAL EXPERIENCE:
Confidential, Pittsburgh, PA
Supply Chain Functional Consultant
Responsibilities:
- Set up price lists, modifiers, and qualifiers
- OM and Advanced Pricing module configuration document preparation
- Demonstrated functionalities of Advanced Pricing and Order Management to the business users.
- Gap analysis for OTC Process
- Designed a solution to get freight cost from Oracle Transportation management using Advanced Pricing “Get Custom Price” Function.
- Prepared functional design documents for Advanced Pricing and Order Management
- Worked closely with technical team to develop customizations in OM and Advanced Pricing modules
- Test Script development and test execution for customized objects
- Conducted UAT and assisted end users in understanding the customized design
- Fixed the issues gathered during UAT
- Support and troubleshooting of Advanced Pricing and Order Management modules
Environment: Oracle Apps 12.1.3 e-Business Suite- Advanced Pricing, Order Management, Configurator, Shipping, Toad and SQL Developer as a tool for SQL queries, HP Quality Center, HP Open View
Confidential, CA
Responsibilities:
- Understanding the existing business processes including Order Management, Shipping, WIP, Advance Pricing, i-Procurement, Purchasing
- Preparing existing business process documents
- Discussing with business users and preparing BP80 for future To Be Process documents for PO, i-Procurement, OM, INV, Shipping, Advance Pricing, Service Contracts, Install Base
- Worked on the Outside Process functionality in WIP.
- Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
- Giving demonstration of standard functionalities of OM, INV, Purchasing, i-Procurement, Shipping, Advance pricing to the Business Users.
- Proposing solutions and customization for gaps and getting the approval from business users.
- Working with Technical team closely and getting done development for customizations for OM, INV, Purchasing, Shipping, Advance Pricing Modules.
- Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for Purchasing, i-Procurement, Order Management, Shipping, Advance Pricing, INV Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
- Preparing technical specification documents for Order Management, Shipping, Advance Pricing, PO and INV modules.
- Preparing BR100 and Completing the Setups and configurations for i-Procurement, Purchasing, Order Management, Shipping, Advance Pricing, INV
- Preparing and using data loader script to load the data and completing setups for Service Request module.
- Preparing the test cases for Order Management, PO, Shipping, Advance Pricing, INV modules
- Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
- Fixing the issues collecting during CRP1, CRP2 and UAT.
- Working 24 by 7 during cutover and down time
- Providing support to users after implementation is done and fixing all issues related to set ups
- Fixing the issues for converted data for Purchasing, i-Procurement, Order Management, Shipping, Advance Pricing, INV modules
Environment: Oracle Apps 11.5.10 e-Business suite- Order Management, WIP, Shipping, Advance Pricing, INV, Purchasing, i-Procurement, SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX.
Confidential (LA-CA)
Oracle SCM Functional
Responsibilities:
- Oracle WIP, Order Management, i-Procurement, Inventory, Purchasing,
- Project includes data migration for following entities
- Interaction with business users as a part of As - Is Study for clients legacy application D3 Pick for (Oracle Purchasing, Oracle Payables, i-Procurement, BOM, WIP, Order Management, Configurator, Service Contracts, Install Base, Inventory
- Setup the Work Execution flow and Preventive Maintenance Flow in Enterprise Asset Management.
- Worked on the Revenue Recognition process in AR including setting up the deferred revenue rules.
- Performed all the setups for O2C modules including OM, Inventory.
- Setup Modifiers/Qualifiers in Advance Pricing.
- Business Requirement, Scope Management Documents Preparation
- Fit Gap Analysis for (OM, INV, PO, AR, GL, Shipping, i-Procurement ) & preparation for Fit Gap Document
- To Be High Level & Detail Documents Preparation
- Module Configuration Documents Preparation OM, INV, PO, BOM, WIP, AR, GL, Shipping, i-Procurement modules setup
- User as a part of CRP1, CRP2, CRP3
- Data Migration requirement gathering for (BOM, Routings, Items, Open PO, Suppliers)
- Data Migration functional specification documents creation
- Design Creation & Validations
- Application testing w.r.t individual module
- Issues Tracking & Customer Sign off
Confidential, Boston, MA
SCM Functional Consultant
Responsibilities:
- Requirement Gathering for (OM, BOM, WIP, INV, PO, AR, GL, Shipping, i-Procurement)
- Functional Specification Creation for OM, INV, BOM, WIP, PO, AR, GL, Shipping, i-Procurement
- Design Creation & Validations of all the interfaces and conversions.
- Issues Tracking & Customer Sign off
- Led the UAT and CRP Testing.
- Led the effort for the end users, business users, power users as well as functional resources.
- Prepared materials for all Supply Chain modules like OM, BOM, WIP, NV, PO, AR, GL, Shipping, i-Procurement
- Conducted the UAT and CRP for purposes.
- Used WebEx for the remote users
- Used a combination of Word Documents and Powerpoint slides to provide the .
Confidential, PA
Oracle Functional Consultant
Responsibilities:
- Setting up Multi-Org Environment for the New Operating Units
- Setting up Approval hierarchies for the application
- Customizing Approval hierarchies as per Confidential business flow
- Have created Data Loading scripts for PO/Requisition loading into Confidential Apps from legacy system
- Configured Order Management, Inventory, i-procurement, iStore and Quoting.
- Have worked on Auto Shipment
- Have done setting up of Vendors/Banks
- Troubleshooting critical issues
- Key Point of Contact for (PO/ i-Procurement, /INV/AP)
- Work on Critical Enhancement’s & Bug fixes
- Maintaining Confidential Purchasing/Payment operations
- Client Interaction
- Have done Due Diligence & created SPP/SOW/Risk Plan/DPP for the project
- Maintaining SLA’S for project
- Establishing & Controlling delivery processes to maintain quality & quantity of deliverables
Environment: Oracle Apps 11.5.8, Oracle PL/SQL, Developer 2000, Toad and SQL navigator as tools for SQL queries
Confidential
Application Lead
Responsibilities:
- MRO Global (Tech-Functional) Support for Confidential - Confidential
- Key Point of Contact for (OM, Advance Pricing, PO, INV, WIP)
- Process Architecture & Enhancement.
- Worked on key tasks such as Sub-Inv. Transfer, Costing for Inv.
- Worked on Writing and Customizing Interfaces.
- Worked on Auto Shipment for Confidential
- Created Inventory Organizations
- Done Repair Blanket PO SET UP for WIP Jobs.
- Populated Items By Using Templates for Confidential
- Worked on Performance Tuning using SQL TRACE/TKPROF/EXPLAIN PLAN
- Done Complete Automation of Opening OM/PO/INV Periods.
- Have Enabled Segment9 for Accounting Flex Field
- Involved in Database upgrade from 7.3 to 9i.
- Complete Process flow knowledge on INV, PO, and WIP.
- Concurrent Manager Administration, Interface monitoring.
- Involved in Tracking/downloading/Applying patches
- Have Experience in Configuring Concurrent manager/Setting up printers
- Concurrent Programs, reports, Request groups Creation, registration, scheduling
- Application Users creation.
- Performance Tuning for Reports & Interfaces.
- User’s on Key issues.
- Root Cause analysis for reoccurring problems on PO, INV, and WIP.
Environment: Oracle Apps (10.7sc/11I), Oracle PL/SQL Developer 2000, and PL/SQL, Using Toad and SQL navigator as tools for SQL queries
Confidential
Software Developer
Responsibilities:
- Responsible for requirement analysis, design and development of modules during my involvement with Employee Management tool.
- I provided components like Leave management, Appraisal and Project management.
Environment: C#, ASP.net, Oracle 9i