SUMMARY:

• 8+ years of work experience in the field of Oracle Applications Procurement and Supply Chain Management (SCM) modules like Inventory, Order Management, Shipping, WMS, Pricing, BOM and WIP.
• Strong Oracle Applications implementation and support experience in Manufacturing and Order Management modules.
• Strong working knowledge of Order to Cash (O2C) and Procure to pay (P2P) business cycles.
• Extensive experience in all life cycle stages of implementation including Requirement Gathering, GAP analysis, Solution Design, System Configuration, Custom Development, Business Testing, CRP, Integration Testing, UAT, Training, Cut - over & Project coordination.
• Extensive experience with doing GAP Analysis and documenting GAPs and designing solutions for the GAP’s identified.
• Wide experience in Business Requirements Analysis, Gap Analysis, Production Support and Training Business Users for Oracle ERP Implementations
• Extensive experience in Implementation, Training Activities and Post Implementation Support of Oracle Applications.
• Experience in conducting CRP and UAT’s.
• Have conducted extensive training, presentations, tutoring and documentation of training material.
• Created business documentation like TE40, BR100, RD50 and MD50.
• Highly capable in understanding business operations and translating them into functional requirements.
• Strong problem solving and analytical skills with immense ability to grasp new concepts and apply them.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Supply Chain Functional Consultant

Responsibilities:

• As a Business Analyst Supported Oracle Supply Chain - OM, INV, PO, BOM, i-Procurement on Release 12.1.3
• Worked on Enhancements for OM, INV, PO, BOM, i-Procurement module
• Worked on the setups of the Inventory Module, setting up the planning and counting process
• Define the Inventory Org structure - including the Master and Child Inventories, Locators, Lots, Serial Controls, etc.
• Worked on the functional design of the customization to the “Sales Order Workbench” form in OM module.
• Worked in configuring the Approval Hierarchies in PO module
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured OM, INV, PO, BOM, i-Procurement modules from scratch and simultaneously created BR100 documentation for the setups.
• Worked on the Localizations for Europe (Netherland, Spain, Italy), UK, Mexico, Latin America, Japan, China
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for the client by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in Order to Cash, OM, INV, PO, BOM, i-Procurement

Environment: Inventory, Quoting, Order Management, Shipping, Pricing, BOM and WIP

Confidential, Orange County, CA

Functional Consultant

Responsibilities:

• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Performed all the setups for OM, INV, PO including setting up of the expense-reporting template.
• Worked on the integration of WIP with OM and also worked on the functional specifications for customizations to OM module.
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Defined the AS-IS and TO-BE processes.
• Implemented TCA - for AR customer master conversions.
• Implemented the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.

Environment: Oracle Applications R12.1.3 (Inventory, Order Management, Shipping, Pricing, BOM and WIP), ADI, Workflow, Workflow Builder 2.5, Oracle 9i, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting and UNIX

Confidential, Boston, MA

Supply Chain Functional

Responsibilities:

• Gathered requirement from the users concerning the customization of Supply Chain Modules like Inventory, Order Management, Shipping, Pricing, BOM and WIP.
• Worked on Configuring the Inventory, Order Management, Shipping, Pricing, BOM and WIP modules.
• Worked with the Business team to baseline NPI ‘As Is’ Process and derive ‘To Be’ flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to Solution.
• Collaborated with Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Worked for the Category & Mapping data migration to meet the go live deadline.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Worked with the Business team to baseline NPI ‘As Is’ Process and derive ‘To Be’ flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for SCM Modules (OM, QP, BOM, INV, PO) to make sure flow is working without any issues.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Oracle Financials 11.5.10 (OM, BOM, WIP, QP), Oracle 9i, Windows/NT, PL/SQL, Forms 6i, Reports 6i, Toad 8.1.6, Discoverer 4i, PVCS, Reflection

Confidential, Alpharetta, GA

Oracle Applications Functional Supply Chain

Responsibilities:

• Setup Document Approval / Approval Group / Assignments, Purchasing Options
• Define Line Types and Doc Types, Lookup Codes, PO Profile Options
• Create Requisition, Auto Create RFQ, Corrections
• Defining Standard, Blanket Purchase and Contract Purchase Agreement
• Define Supplier & Item Combination, Sourcing Rule, Approved Supplier List,
• PO Control, Release PO, Receipts, Run Reports & Journal Import Programs
• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Setup Modifiers and Qualifiers in QP.
• Setup the pricing attributes in QP
• Setup the Dynamic formulas for pricing in QP.
• Setup the Attribute mapping in QP
• Setup the QP profile options.
• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established a Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count
• Established Customer Item and Customer Item Cross Reference
• Established a process for smooth month end closing procedure in Inventory

Environment: Oracle Financials 11.5.9 (GL, AP, AR, PO, OM), Oracle 9i, Windows/NT, PL/SQL, Forms 6i, Reports 6i, Toad 7.3, PVCS.

Confidential, NC

Oracle Applications Functional Consultant

Responsibilities:

• Identify the features enhancements in the flow for Order to Cash and Procure to Pay.
• Validate the Industry requirement against the enhancement proposals.
• Worked on both ATO and CTO Models in OPM.
• Defined Modifiers, Qualifiers and Dynamic formulas in QP.
• Determination of Setups and testing the functionality of the features.
• Development of Flow Scripts and Flow Models.
• Testing of Business Flows like P2P & O2C

Environment: Oracle Financials 11.5.9, GL, AP, AR, PO, INV, OM, Oracle 8i, Windows/NT, PL/SQL, Toad, Forms 6i, Reports 6i.

Confidential, NY

Supply Chain Functional Consultant

Responsibilities:

• Member of Global GL/GIS team responsible for OM, AR and GL
• Core member of CRP2
• Worked on Mercury Quality Center as a Test Director.
• Functional design for GL interface with external systems for 70 SOB
• Responsible for communication with overseas IT resources for different global GL components
• Worked closely wit IT team for different issues.
• Set up, created the FSG profile options and created datasheets for the FSG reports.
• Developed FSG reports in Oracle General Ledger, which includes balance sheet, income statement, revenue recognition reports, and profit and loss statement.
• Developed and maintained functional specifications for custom reports
• Created test scripts for validating the FSG reports.
• Met with Dell leads and users to generate and review the current and future reporting requirements of the client.
• Provide end user support of financial and analytical reports using Oracle General Ledger, FSG, ADI and Discoverer.
• Developed several reports using Discoverer 4i.

Environment: Oracle 11.5.7 GL, AP, AR, PO, INV, OM, Oracle 8i,, PL/SQL, Forms 6i, Reports 6i, Windows 2k,UNIX.

Confidential, MI

Supply Chain Functional Consultant

Responsibilities:

• Studying the existing business process of Client
• Wrote business requirements documentation for OM, Inventory setup.
• Delivered functional setup documents (FSD) for Inventory and Order Management.
• Performed business process analysis, requirements gathering and fit-gap analysis
• Responsible for Organizational set ups including inventory organizations, locations, freight carriers, items, parameters etc
• Setup for Order Management and Inventory modules.
• Worked on Procure to Pay (PTP) and Order to Cash (OTC) Cycles
• Responsible for identifying the purchasing hierarchy and the set up of positions, approval assignments, approval groups and buyers
• Defined Jobs, employees and buyers.
• Maintained purchasing locations, buyers, approval groups, options and lookup codes
• Setup purchasing approval hierarchy and employees
• Involved in data conversion from the legacy system to Oracle Applications and implemented Min-Max inventory control methodology
• Developed and executed test scripts during Conference Room Pilot and Integration Testing
• Developed documents and performed user training
• Responsible for working with Business Units to develop best practices and develop optimized processes including determining suppliers and item data integrity
• Setting up Drop Shipment process, shipping parameters - Picking Rules, Pick slip grouping rules, Release Sequence rules
• Implemented Reverse logistics for RMA receiving, supplier returns, refurbishment and recycling

Environment: Oracle 8i, Forms 6i, Reports 3.0, Windows 95, UNIX, PL/SQL, SQL, SQL* PLUS, SQL Loader.

Confidential

Functional Consultant

Responsibilities:

• Troubleshoot the problems online (through remote connectivity) and provide timely solutions.
• Lead the team in rollout phase of the helpdesk portal (supportcentral.ge.com) across Confidential Capital IT Services.
• Received a number of excellent VOCs (voice of customer) for dis playing high customer centricity.
• Completed Green Belt (Six Sigma), and Developing Self Excellence (DSE) trainings.
• Good understanding of Six Sigma tools.
• Working knowledge of Data Warehousing tools like Cognos and Business Objects.