SUMMARY

• Around 8 years of functional expertise with proven knowledge and skills in Oracle E - Business Suite Supply Chain modules Inventory, Purchasing (P2P), IProcurement, and Order Management (OM), BOM, WIP.
• Experience in implementation, Upgrade, Integration and Support of Oracle ERP applications specifically in Purchasing(P2P), iProcurement, Inventory, Order Management (OM), Bill of Materials (BOM) and Work in Process (WIP)..
• Proficient in analyzing business requirements, process flow, fit-gap analysis, solution design, conversion strategy, production cutover and change management.
• Experience in preparation of AIM methodology documents such as MD050, RD020, BR100, BP080, BR010 and standard operating procedures.
• Excellent knowledge on Procure to Pay (P2P) and Order to Cash cycles.
• Experience in various levels 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.
• Knowledge on design and development of custom solutions for interfaces, Form, Reports using PL/SQL.
• Led several sessions to end users at the client place.
• Team player with strong interpersonal, communication and time management skills.
• Ability to learn and adapt to the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

Operating Systems: Windows 95/ 2000/2003/ NT, XP, 2007, Vista, Linux

Oracle Modules: INV, PO, OM, iProcurement

ERP Versions: Oracle Application 11i (11.5.9, 11.5.10) & R12

Softwares: Cogtool,Minitab, Arena Simulation and Pro-E, TOAD, SQL developer.

Office Packages: MS Office 2010, MS Project 2010, MS Visio

PROFESSIONAL EXPERIENCE

Oracle Procurement Functional Analyst

Confidential, NH

Responsibilities:

• Responsible for Oracle R12 implementation which includes requirements gathering, creating MD050 documents, and conference room pilots, system integration testing, UAT, Go-Live and production support activities.
• Worked with the project team in configuration of procurement (P2P), inventory modules.
• Created Task maps, BRD's, MD50's and BR100's for P2P Resale processes. Involved in review of BRD sessions and conducted BRD review sessions with Business for PO processing, PO pricing and Buyer Vendor processes.
• Involved in multiple discussions with Development team on Design walkthrough sessions, POC sessions. Have conducted SIT and UAT sessions for Gamma Project.
• Created MD050 for getting appointments from third party system(RDS) on to Oracle custom PO form and again from Oracle to another third party system(WCSS).
• Created MD050 and test scripts for PO import interface from external system(Mainframes) to Oracle.
• Performed end to end testing of RDS appointments both inbound to Oracle and outbound from Oracle.
• Performed end to end testing of PO import interface from third party system to Oracle.
• Co-ordinated with Oracle DEV, SOA, EDI & legacy applications team during the design, development, testing & migration phases of the project. Preparation of Cutover list, Migration list, Patch List and seamless migration of all those to Production.
• Performed UAT (User acceptance testing) for Oracle applications implementation.
• Handled errors like PO failing due to cancellation of single line PO's and trying to add the line for the same PO again.
• Created test scenarios and end user manuals for Business and IT system integration testing.
• Involved in system integration testing and UAT of Procurement implementation and resolved few issues related to value map setups.
• Tested the functionalities as per the requirements, before Go-Live. Post production Support and Adhoc report requests

Oracle SCM Functional Analyst

Confidential, Bloomington, MN

Responsibilities:

• Responsible for Oracle 11i to R12 transformation which includes requirements gathering, creating conversion documents, and conference room pilots, system integration testing, UAT, Go-Live and production support activities.
• Worked with the project team in configuration of procurement (P2P), account payables, BOM, WIP and inventory modules.
• Created MD050 and data conversion document for transformation based on the business requirements to guide development team.
• Worked on setting up profile options, organization parameters for new operating units under R12.
• Set up of BOM Parameters, Routings, Resources, WIP Parameters and Manufacturing Calendar such that it completes the work job transaction in one step.
• Worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items.
• Implemented WIP with outside processing (OSP) for handling the Contract Manufacturing involving Payment at the production time.
• Worked with OBIEE team in getting the procurement spends analytics from Oracle EBS to OBIEE.
• Explained the process of EBS transformation to OBIEE team which helped them in consolidated reporting.
• Analyzed data duplication scenarios that affect the consolidated reporting between two environments 11i and R12.
• Provided column and table mapping solution for consolidated reporting in OBIEE from 11i and R12.
• Provided solution for new commodity code changes and deprecating old commodity codes by adding new four segment commodity code combinations used for Purchasing.
• Defined validation to use for additional segment value. E.g., create new value set and assign allowed segment values.
• Performed UAT (User acceptance testing) for OBIEE and Oracle applications implementation.
• Done expense account rules setup which are used to automatically generate account segment values when creating a requisition based on the commodity code assigned to the requisition.
• Created test scenarios and end user manuals for Business and IT system integration testing.
• Involved in system integration testing and UAT of Procurement transformation and resolved few issues related to setups.
• Tested the functionalities as per the requirements, before Go-Live.
• Created document on how AMEX spend reporting is being done through EBS and shared it with OBIEE team.

Oracle Functional Analyst Procurement

Confidential, Torrance, CA

Responsibilities:

• Responsible for customized application implementation which includes requirements gathering, solution design, and conference room pilots, system integration testing, cutover, Go-Live and production support activities.
• Worked with the project team in configuration of procurement (P2P), iProcurement, account payables, inventory modules.
• Created MD050 and design layout document for custom application based on the business requirements to guide development team.
• Worked on the Requisition import process to import requisitions from the custom application to Oracle Purchasing.
• Created Expense Account Rules for Expense Categories to default the charge accounts on Requisitions and Purchase Orders in order to prevent category invalid errors.
• Worked on multi currency conversion in purchasing after importing the requisition from customized application in to the operating unit which is not related to the local currency.
• Worked on challenging tasks like getting Non PO invoice amounts from oracle to customized application and matching with that particular event using unique number in DFF's.
• Created approval work flow through AME(Approval Management Engine).
• Worked on verifying and inserting GL code combinations through API before requisition is imported in order to prevent 'Charge account invalid' errors.
• Built approval hierarchies by setting up rules through AME. And helped the development team to modify first approver, to add approver in between same as iProcurement.
• Tested and modified the interface program in SQL as per the business requirements.
• Designed SQL test scripts for the development team.
• Performed end to end testing of the customized application and logged issues and solutions in issue tracker for the development team to resolve.
• Created test scenarios and end user manuals for super user and end user testing.
• Tested the functionalities as per the requirements, before Go-Live.
• Created documents and trained more than 100 people at the site.
• Involved in End to End testing of Australia iProcurement implementation and resolved few issues related to setups.
• Created test scenarios and end user manuals for super user and end user testing for iProcurement.

Oracle Supply Chain Techno Functional Consultant

Confidential, Phoenix, AZ.

Responsibilities:

• Responsible for full life cycle implementation which includes requirements gathering, solution design, and conference room pilots, system integration testing, cutover, Go-Live and production support activities.
• Worked with the project team in configuration of purchasing (P2P), IProcurement, account payables, inventory, BOM, WIP and Order Management (OM) modules.
• Depicted AS-IS Business processes at various sites and successfully retired the Legacy Systems and performed Fit-Gap Analysis to ON Semi Conductor Business Process.
• Created Expense Account Rules for Expense Categories to default the charge accounts on Requisitions and Purchase Orders.
• Created Blanket Purchase Agreement for suppliers, Sourcing Rules and Approved Supplier Lists to enable automatic generation of purchase orders when a requisition is raised and approved in the shop floor.
• Created standard bills and Model bills to represent products and service that allow user-selected options in BOM.
• Configured ATO(Assemble to Order) BOM models to represent product models that require assembly “downstream” in Oracle Work In Process(WIP).
• Created a catalog of standard job and schedule documents in WIP.
• Utilized advantages of Price Breaks, MOQ’s in Blanket Purchase Agreements to meet the requirements.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Implemented Item Relationships and Customer Item Cross s.
• Configured the employee/supervisor relationship hierarchy for Requisition and Purchase Order as per the Procurement Policies.
• Performed Min Max planning setups and incorporated Fixed Lot Multiplier based on the business processes.
• Suggested development of Min Max Attributes load program as one of the site has a requirement to change the Min Max attributes frequently.
• Suggested Internal catalog functionality in Oracle iprocurement for Indirect material Requisition Process.
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Order Management applications.
• Worked on shipping tolerances at customer level in Order Management application.
• Extensively worked on Modifiers, Qualifiers to create a price list for various items in Order Management module.
• Defining customer, containers, vehicles, freight carriers and payment terms as per business needs.
• Documented setups for Standard purchase order (PO), Blanket purchase agreement, Purchase requisition and internal requisition and route approvals using employee/supervisor relationship.
• Involved in testing of end to end, Procure to pay (P2P) mainly in the areas of Purchasing, Inventory, BOM, WIP.
• Created test scenarios and end user manuals for super user and end user testing.
• Tested the functionalities as per the requirements, before Go-Live.
• Created documents and trained more than 100 people at the site.
• Performed data loads during cutover activities like loading catalogs using Iprocurement Catalog Administration and Open PO load using Custom developed upload programs.

Oracle Business Analyst

Confidential, Vista, CA.

Responsibilities:

• Part of cross functional team involved in sharing information with the functional lead, technical lead, management and business functions involved in the implementation.
• Assisted the organization in implementation and support of purchasing (P2P), IProcurement, accounts payables, sourcing modules and Order Management (OM).
• Analyzed supply chain process, performed value stream mapping and developed business process best practice.
• Expertise in setting up Global Blanket Purchase agreements and Inter Company Relationships for Centralized procurement.
• Configured Complex Sourcing Rule Setups and ASL’s with combination of MOQ’s and Price Breaks
• Configured Self Billing At supplier classification to enable auto payment to the supplier after Receiving transaction is performed.
• Worked on technical design and developed a customization that prints, shipping documents after ship confirmation and re-pricing are done.
• Expertise in setting up Customers Order Types, Line Types Document, Sequence Price lists, Release Sequence, Pick Rule, Release Rule and Pick Slip Grouping.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, and Order Management modules.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application.
• Configured Expense Account rules to default the charge accounts when creating purchasing documents
• Enabled inventory accuracy by compiling ABC analysis based on most valued and most used items and implementing Cycle Counting and Physical Inventory procedures.
• Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups.
• Co-planned communication strategy to drive change and increase adoption speed for the talent redeployment program.
• Extracted inventory data and develop Inventory Key Performance Indicators, inventory accuracy and inventory turnover rate.
• Conducted fitment and gap analysis from requirement specifications and modified business processes to accommodate client specific requirement.
• Audited inventory cycle counts and participate in evaluation and phasing out of obsolete parts.
• Worked on Lean and Six Sigma activities to drive cycle time and inventory reductions by building work groups and mentoring them.
• Assisted in development of materials for new technology and process improvements.

Oracle Supply Chain Consultant

Confidential

Responsibilities:

• Configured R12 applications while setting up new inventory Org for Inventory module.
• Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
• Assisted in setup of security, responsibilities, alerts, workflow approvals and system privileges.
• Supported all Oracle Applications patching and maintenance activities by testing and troubleshooting functional issues.
• Extensively worked on different Inventory transactions and solved the period end issues.
• Implementation of inventory management tools like Cycle Counting, Physical Inventory ABC Analysis, Max-Min Planning.
• Defined Value Sets, Descriptive FlexFields, and Custom Profile Options.
• Managed Oracle Service Requests (SR's) to resolve effectively and efficiently.
• Supported team to drive productivity and profitability across the portfolio of services whilst ensuring all services are delivered to the quality standards and contractual obligations required.
• Analyzed issues in the application’sfunctionalimplementation, technical infrastructure, performance capability, stability and security synthetically, and responsible for the optimizing scheme and its realization.
• Developed strong understanding of the business requirements and objectives in order to drive functional design, document the software gaps and formulate solutions.
• Developed a detailed system and program specifications and created business models and business requirement scenarios.
• Assisted in implementation of Vendor Management Inventory (VMI) solution for supplier determination of items, quantities and delivery schedules based on customer provided information.
• Lead functional acceptance testing of enhancements and patches.
• Assisted in deriving interface planning, operational planning and requirements.
• Developed and executed plans for deploying the application data fix into production.

Business Analyst

Confidential

Responsibilities:

• Responsible for assistance during ERP system set-ups including Item set-ups, and their periodic validation and correction
• Part of Implementation team involved with installation of new applications working closely with cross-functional team of Engineering, Sourcing, Materials, and Finance.
• Act as an interface for any new requests/upgrades in ERP system by effective understanding of the requirement & communicating the same with the experts.
• Plan, Generate and maintain daily department requisitions of materials using ERP application.
• Perform monthly itemized inventory control and materials recovery to eliminate stock outs using ERP Inventory Module.
• Developed and documented action plans for Gap Analysis of labor productivity and Time tracking.
• End users and implementation of ERP applications (Inventory, Material Management and Production Planning) as part of ERP implementation project.
• Involved in forecasting and planning of material and equipment needs for entire department.
• Optimized production processes based on analysis of productivity trends and manufacturing metrics
• Analyze and track production efficiency of machines including parameters like throughput/cycle time/production capacity