SUMMARY

• 8+ years of experience as an Oracle Supply Chain Management(SCM) Functional Consultant working in multiple projects in both R12 and 11i versions wif an in dept understanding in the areas of Manufacturing and Distribution including Inventory Controls as per the nature of the business and size of the operations wif third party integrations etc.,
• Good understanding of business process operations, organizational assessment and translating them into functional requirements
• Excellent knowledge in all Oracle Supply Chain modules and integrations across cross modules as well
• Extensive knowledge on Inventory Controls, Order to Cash (O2C) & Procure to Pay (P2P) cycles
• Expertise in business process analysis, requirement analysis (AS - IS) system, (TO-BE) mapping, CRP testing, Integration testing, UAT, system configuration, data conversions, master data loading, Go-live support, Post-Production Support
• Understanding of all phases of ERP implementation such as business process study, business requirement gathering, gap analysis wif respect To-Be solution design, development and testing, cut over, Go-Live and post production support
• Implementation experience and functional expertise in Order Management (OM) including Advance Pricing, Inventory (INV), Purchasing (PO), Advanced Supply Chain Planning (ASCP), Bill of Materials(BOM), Work in Process(WIP), Master Production Schedule (MPS) and Material Requirements Planning (MRP)
• Excellent problem solving, communication, analytical, interpersonal & leadership skills
• Expertise in Writing, Maintaining, Test Results and Generating software defects reports for the developers
• Worked closely wif business users to understand the business processes and prepare the business requirements definition documents
• Expertise in implementing the projects and performing thorough testing during the User Acceptance phase of the project
• Worked in cross functional environment, in groups and individually wif minimum supervision
• Used Application Implementation Methodology (AIM) for documentation purposes
• Experience in using tools such as Data loader, SQL loader, Web ADI, TOAD and EXCEL for importing and exporting data
• Effective communication & experience in various projects using MS Project, MS Excel and MS Visio
• Experience interacting wif customers at multiple levels in a variety of Industries & Business segments
• Have experience in End to End Implementation and skills in leading medium to big sized teams
• Worked closely wif Oracle Technical support on all high prioritized open SR’s and conduct OWC sessions for speedy resolution of issues
• Carried out Process Customization, Data Conversions and Developed Interfaces
• Trained in Six Sigma levels of Quality and implemented Lean manufacturing, Continuous Improvement and Statistical Process Control methodologies

TECHNICAL SKILLS

Oracle Modules & Versions: Oracle Modules INV, PO, OM including Advance Pricing, iProcurement, BOM, WIP, MRP & MPS, including Q2C, O2C and P2P cycles

Oracle R12: R12.0.2, R12.0.3, R12.0.4, R12.0.5, R12.0.6, R12.1.1, R12.1.2, R12.1.3

Oracle 11i: 11.5.7, 11.5.8, 11.5.9,11.5.10,11.5.10.2

Software’s & Other Tools: PL/SQL, ADI, Web ADI, Hyperion, OBIEE, Discoverer, TOAD, SQL Loader, Data Loader, MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Eugene, OR

Oracle SCM Functional Analyst

Responsibilities:

• Involved in planning & implementing the up-gradation from Oracle 11.5.10.2to R12.1.3
• Worked collectively wif other business areas including, planning and finance to ensure that manufacturing function fully integrates wif other business process
• Monitoring the business users screen to understand the issues and fixing it by guiding them to complete the process in a right way
• 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
• Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications
• Replacing the critical issues in Test instances to fix the problem in PROD instance
• Resolving the issues on Pending Transactions from various applications
• Resolving the month end issues and prepared a setup document for Month-end closing
• Maintained AIM documents like BR100, BR150,MD50 and TE40
• Worked on making Test scripts and performed testing procedures for various Oracle Application modules like Inventory & Order Management
• Conducted CRP 1 (Conference Room Pilots) and documented the results to ensure that the business processes were defined for all major business processes and could be performed successfully using oracle Applications
• Tested the functionalities as per the client requirements
• Performed bug checking and logging and followed up the TAR resolution process
• Trained end users on Inventory and Order Management modules and provided user guide
• Involved in planning of UAT

Confidential, Iowa City, IA

Oracle SCM Functional Consultant

Responsibilities:

• Studied and analyzed the current business process and was part of business requirement meetings
• Performed AS-IS Analysis
• Performed a walkthrough of the To-Be business process flows
• Responsible for documentation of BR100 and MD50
• 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
• Trained the super users by providing documents using VISIO flow diagrams for better understanding
• Assisted team lead and other team members in setup and user interaction
• Trained the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way
• Executed CRP's, prepared test scripts, smoke test and collected results
• Worked closely wif the development team on all application enhancement, requests and bug fixing
• Prepared user manuals and assisted the end users on inventory and purchasing modules
• Rendered support for researching, troubleshooting and testing product problems and client configurations
• Was part of User Acceptance Test and recorded the UAT results
• Provide post production support for Inventory and Purchasing
• Render first point of contact for customer support during business and non-business hours to meet customer support response time commitments
• Trained the super users by providing documents using VISIO flow diagrams for better understanding

Confidential, Harrisburg, PA

SCM Functional Analyst

Responsibilities:

• Involved in planning & implementing Oracle 12.1.3
• Perform the AS-IS, Gap and Fit Gap Analysis
• Created BR100 & MD50
• Conducted numerous meetings and trainings on Oracle functionality to communicate and educate the users.
• Provided support and coordinated wif the Financial team for O2C process
• Worked collectively wif other business areas including planning and finance to ensure that manufacturing function fully integrates wif other business process
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, workday calendar, locations, freight carriers, item parameters etc
• Involved in making setup of vendor catalogue into Oracle to define new items & categories
• PO: Setup Suppliers, Assigned Approval Groups, Document Types and Purchasing, Receiving and Financial options
• Setup of various Purchase Orders
• Worked on user menus
• Conducted CRP1( Conference Room Pilot) testing for the Purchasing and Inventory
• Communicated wif the technical team for the bugs found
• Worked on making Test scripts and performed testing procedures for various oracle apps module like Inventory and Purchasing

Confidential, Atlanta, GA

Oracle SCM Functional Analyst

Responsibilities:

• Analyzed and documented the functional requirement for data conversion and coordinated wif 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 planning and execution of CRP's
• Communicated wif other functional teams in order to integrate manufacturing functionality wif the financial modules
• Prepared TE-40 and executed the key test scenarios which include both inbound and outbound interfaces wif external systems
• 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, Arlington, TX

Oracle Functional Support Consultant

Responsibilities:

• Rendered post production support in Purchasing and Order Management modules to the client
• Worked closely wif the technical team on all application enhancement request and bug fixing
• Updating and validation of BR-100
• Responsible for tracking of all issues and prioritize depending on the key business areas and time sensitive price constraints
• 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
• 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, Orrville, OH

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed all the required documents like BP30, BR100. BR150,MD50
• Setup- Various types of Purchase Order, supplier and supplier site
• Created requisition templates, approval groups, approval hierarchy and approved supplier list
• Setting up of various types of Purchase Orders i.e. Standard purchase order, Blanket purchase agreement, Planned purchase order and Contract agreement
• Configuring iProcurement module
• Setup- of BOM structure, routing, operations, departments
• Conducted CRP1 testing for scenarios in Purchasing and iProcurement
• Involved in planning CRP2, data conversion, data loading and training the end users
• Coordination wif the team for the test execution and issue resolution processes and providing the status update to project management team during the daily status calls
• 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 wif severity 1, 2 and 3

Confidential, Milwaukee, WI

Oracle SCM 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
• 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
• Coordinated wif 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 wif end users to document the process and functional requirement also providing them wif 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, Evansville, IN

Oracle SCM Functional Consultant

Responsibilities:

• INV, WIP, BOM configuration setup
• Customization requirements
• 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
• Worked on Shipping Tolerances at Customer level in Order Management Application
• Worked wif 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.
• Working wif different teams to resolve the issues for the assigned sites. Research the issues on Metalink and Open the TAR wif Oracle for critical issues and following up wif Oracle support regarding bugs and patches
• Resolved the issues on Taxes, Freight charges for the customers in Order Management Application
• Helped in developing user guides.
• Prepared standard operating procedure for modification to the setup document
• Prepared oracle suggested documentation for future reference

Confidential, Santa Clara, CA

Oracle SCM Functional Consultant

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 wif the SOX approval
• Worked extensively on Unit Testing, and System Integrated Testing
• Prepared User Training 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 wif 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
• Setting 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
• Setting 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 wif release generation method “Release using Create” enabling auto generation of Blanket Releases, Standard Purchase Orders against the Blanket Agreements and Catalog Quotations
• Defining and maintaining 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
• Performing regression testing during upgrades.
• Responding to functional assistance tickets from the super users, problem analysis and resolution

Confidential, WI

Oracle SCM Functional Consultant

Responsibilities:

• Study and analysis of the existing systems and business processes to create AS-IS document.
• Conducted conference room pilot (CRP), training and testing sessions for business champions & super users.
• Configuration, enhancement and prod support of Oracle Purchasing, iProcurement, Account payables, Account receivables, Order Management, General Ledger and Inventory modules.
• Ensured defect-free product functioning by performing extensive testing of various test scenarios.
• Delivered product functionality clarifications to clients to maximize productivity.
• As part of AIM implementation, provided client wif Application extensions functional design (MD 50), Unit Test Script (TE 20), System Test Script (TE 40) and User guide (DO 70).
• Provided timely reports and drove steering committee meetings to update on the direction needed to solve the issues.
• Management and coordination of the project/issues wif onsite & Off Shore functional and technical teams.
• Cost & time estimations of enhancement projects using System Enhancement Request (SER) form for approval, visibility and control of the top management.
• Coordination wif the QA’s and DBA’s to complete tasks wifin the time deadlines Worked wif business users and IT for possible enhancements and their usage.
• Carried out User Training adopting the “Train the Trainer” methodology.
• Worked wif Oracle support on Service Requests (SR’s SEV1) 24x7 to get the system up and running and meet the close deadlines.

Confidential, Detroit,MI

Oracle Functional Support Consultant

Responsibilities:

• Provide post-production support for Inventory, Order Management, Bills of Material and Work In Process applications
• 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 wif 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 Functional Consultant

Responsibilities:

• Performed full life cycle starting from analyzing business to Go live
• Responsible for Scope of the Project, Business
• Performed a walk through of the To-Be business process flows
• Prepared BR100, MD50 and RD20.
• Documented the AS-IS, training material and operating procedures
• Conducted numerous meetings and trainings on Oracle functionality to communicate and educate the users.
• Analyzed the current business process and did the requirement gathering for Order Management (OM) & Purchase Order (PO)
• Performed Map and Gap Analysis
• Setup suppliers, payment terms and pricing methods
• Responsible for successful completion of conference room test pilots wif the business process owners.
• Worked closely wif the development team on all application enhancement and bug fixing.
• Designed new interfaces and custom components for on going enhancement requests
• Prepared test scripts and user guide to follow up
• Participated in the User Acceptance Testing (UAT) Planning
• Resolved the issue/bugs while the UAT and documented the same for further reference
• Involved in Data Conversion up to the date