SUMMARY

• Over ten years of experience as Oracle Applications Functional consultant including R12 implementation, upgrade and support projects
• Proficiency includes gap analysis, solution design, configuring, interfaces, Data Conversions, Integration testing, User Training, project documentation, Post implementation support, process flows and functional setups of Oracle Inventory (INV), Purchasing (PO), Advance Pricing, Order Management (OM), Shipping, BOM, WIP, Costing, Accounts Receivables (AR), Accounts Payables (AP), Sourcing, IProcurement, Quality, WEBADI, GRC Controls and SC+.
• Strong implementation experience of Procure - to-Pay (P2P), Order-to-Cash (O2C), Back-to-Back (B2B), IR/ISO and Drop Shipment end to end Cycles
• Conversant with various modules of in oracle ERP/Manufacturing application modules 11i/R12 Inventory (INV), Purchasing (PO), Order Management (OM), IProcurement, BOM, WIP and Payables.
• Expertise in re-configuring the existing application tofit the business requirements andapplying the setupsuccessfullyon implementation
• Possess unique combination of Manufacturing/Distribution and basic financial Oracle application skills with strong knowledge of their integration.
• Good knowledge in requirements study, design and development of oracle applications.
• Extensive experience in Testing Functional Architecture, validating designs, Risk Definitions, Plan Preparation, Unit Testing, System Integration testing and UAT
• Extensively used User Productivity Kit (UPK) in developing training material and trained super users on the application.
• Direct Interaction with customers, clear written and oral presentation of ideas, proposals and concepts.
• Team player with strong interpersonal and excellent communication skills with people from all levels of corporate management
• Trained in Oracle Fusion Manufacturing/SCM modules

TECHNICAL SKILLS

Supply Chain and Financial Applications: Inventory (INV), Purchasing (PO), BOM, WIP, Order Management (OM), WEBADI, GRC Controls, Quality, IProcurement, General Ledger, Payables, SC+ and Accounts Receivables (AR), Accounts Payables (AP)

ERP Versions: Oracle Applications 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2) and R12 (R12.1.3, R12.2.5)

Methodology: Oracle Application Implementation Methodology

M.S. Office Packages: Word, Excel, Power Point

Tools: Toad, Oracle Diagnostics, UPK 3.6.1, Data Loader, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Erie, Pennsylvania

Senior Functional Consultant

Responsibilities:

• Served as Solution Architect for the R12 Implementation, Development and Support Projects.
• Implemented Oracle R12 Inventory (INV) and Order Management (OM) Modules.
• Conducted detailed and comprehensive Business Analysis by working with end users and other stake holders to identify the system operational requirements, and proposed enhancements
• Involved in the requirements session, fit-gap analysis and solution design phases of the project
• Documented the current process flows, business requirements and fit/gap analysis for R12 Inventory (INV), Order Management (OM), Receiving and Shipping modules
• Conducted CRP1 sessions to demo the out of box functionality on the Inventory (INV), Order Management (OM), Receiving and Shipping modules
• Designed and developed a new custom process that can provide framework for automation of Item Activation in Inventory Module when items are pushed to Oracle Inventory (OLTP) from PLM
• Developed an interface to load ASN data from CAS and SCP, and additionally built a WEBADI to correct/re-process the error out records, if any
• Designed and developed a process to generate shipping doc for all OSP items being shipped to the supplier.
• Also, all the components assigned to the OSP operation were moved to an outside location subinventory automatically upon OSP PO approval.
• Setup blanket sales agreement, processing constraints, defaulting rules and holds as per the business requirement.
• Developed a process to ensure all unreleased work orders carry latest BOM and routing changes
• Designed and developed a complex framework to automatically change the item UOM
• Developed a custom report to generate product information certificate in English/Russian languages for items being shipped into the CIS region
• Designed and developed a trouble ticket process to resolve discrepancy on the PO receipt. It also allows users to automatically perform miscellaneous issue through the custom form.
• Extensively worked on Price Lists, Modifiers, Qualifiers and Pricing Attributes in Advanced Pricing
• Provided test scenarios and test scripts to the Business to test the business process in Oracle in various modules including Advanced Pricing, Order Management (OM), Inventory (INV) and Purchasing (PO)
• Extensively worked on WEBADI to develop reports and to load and retrieve data to and from staging tables
• On the EDI 860 shipping notice, added a new attribute to display 'Country of Origin' using oracle provided hookup 'EC DSNO EXT'
• Worked on GRC flow rules to send out notifications based on item attributes update to the finance team
• Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test plans, test cases and test data to be used in testing

Environment: Oracle Applications R12.2.5, SQL Developer, Data Loader, Windows 7

Confidential, Houston, Texas

Senior Functional Consultant

Responsibilities:

• In a development and production support lead role, responsible for Inventory (INV), Order Management (OM), Purchasing (PO), IProcurement, WIP, BOM and SC+ modules.
• Implemented Order-to-Cash (O2C) end to end including requirements gathering, fit-gap analysis, solution design, configuration, functional setups and System Integration Testing.
• Setup several IR/ISO between inventory organizations both within and across operating units. Here are some of them PPKàBMH, CHNàPPK, GEOàST, BMHàPPK, PDSàBMH, GEOàDTR
• Implemented Procure-to-Pay (P2P) end to end including requirements gathering, fit-gap analysis, solution design, configuration, functional setups and System Integration Testing.
• Setup Position and employee-supervisor approval hierarchy in many operating units as per business requirement.
• Setup ASL, Sourcing Rules, and Assignment Set for Inventory Min Max Planned Items with release generation method “Automatic Release” for auto generation of Blanket Releases and Standard Purchase Orders.
• Worked closely with super users in understanding the shop floor requirements and mass updated BOM components and routings for stator and rotor parts and rolled up the assembly cost.
• Setup shipping methods, line types, order types as part of the IR/ISO process.
• Comprehensive understanding and defining of inventory planning method (min-max), ABC Analysis, cycle counting and physical inventory.
• Subinventory accounts were updated by taking the back up of the on-hand and clearing the pending transactions.
• Resolved more than 1200 issues in the last two year in Inventory, Order Management (OM), Advance Pricing, Purchasing (PO), IProcurement, WIP and BOM on a daily basis and also worked with Oracle support on severity one issues.
• Created Stores, shopping categories, Item Categories, setup punchout sites and mapped purchasing categories in IProcurement.
• PersonalizedIProcurementPreferences page, Requisition Summary display page and Requisition Checkout page.
• Worked on Modifiers, Qualifiers, Price List setups to define the discount (or) surplus charges at various levels in OM application
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV) and Purchasing (PO) modules
• Setup new item flexfields to capture some additional information and mapped to the PO print report.
• Prepared user training documents and trained users through classroom/online sessions
• Troubleshooting the Production issues on Order Management (OM), Advanced Pricing and Inventory (INV) modules
• Participated in IT validation, each time a new instance was created, and performed end to end testing.
• Supported users during Month-end resolving pending transactions and clearing transaction open interfaces.
• Coordinated and guided the onsite and offshore teams for deliverables.

Environment: Oracle Applications R12.2.5, Toad, Data Loader, Windows 7

Confidential, Reading, Pennsylvania

Functional Consultant

Responsibilities:

• Study the existing processes and prepared AS-IS documentation for Inventory (INV), Purchasing (PO) and IProcurement modules during the upgrade from 11i to R12.
• Solution design to resolve issues and developed steps to correct the business processes.
• Replaced SBOM interface with an interface that feeds move order functionality to allow material reservations, pick-list generation and backorder tracking.
• Developed a new custom process to address the data mismatch error between the form and the base tables in purchasing.
• Resolved issues related to PO and requisition approval workflow and cleared the transactions stuck in the workflow.
• Personalized forms to disable the ability to add items to shopping cart, create/submit requisitions and receive an item and extracted items into IProcurement item catalog and loaded images.
• Setup item attribute controls, item templates and analyzed the need for sub inventories and setup shipping networks for inter-org transfer.
• Analyzed the parameters involved in cycle counting and setup ABC classes for items to aid in the implementation of counting methodology.
• Conducted conference room pilot (CRP), system integration testing (SIT) and assisted end users during user acceptance testing (UAT).
• Extensively worked on User Productivity Kit (UPK) in developing user training material and trained super users on the new R12 application.
• Prepared test scripts and listed out all of the End-to-End test scenarios across all modules as part of the system integration testing.
• Resolved several issues associated with Inventory (INV), Purchasing (PO) and IProcurement during the upgrade process from 11.5.10.2 to R12.1.3.
• Assisted in identifying the upgrade tasks, patches required and completed all post-upgrade steps.
• Enabled descriptive fields through form personalization to capture phone, fax and email on the buyer definition form as it changed from “Form Based” to “Web Based” in R12.
• Prepared retrofit and BR100 documents to document all the work and explained the new changes to the daily end users.
• Implemented period end accrual process for expense items in R12 and demonstrated the process.
• Trained super users on period/month end close process for inventory and purchasing in R12.
• Coordinated and guided the onsite and offshore team for deliverables.
• Provided on-site functional post production support.

Environment: Oracle Applications R12.1.3 & 11.5.10.2, Oracle 11i, Toad, UPK, Windows XP

Confidential, Las Vegas, Nevada

Functional Consultant

Responsibilities:

• Responsible for defining and setting up complete order cycle setups from order entry in order management to ship confirm in shipping execution module to support business requirements
• Setup WIP parameters, WIP Accounting Classes for Manufacturing Plants and Warehouses
• Calculated Cumulative Lead Times on the Routings and Roll up of Lead Times for Production Scheduling.
• Introduce Lot Based and Serial Based Manufacturing based on the product requirements.
• Configured WIP Assembly Completions with the Lot Number generations based on the Discrete Job classification.
• Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration
• Performed setups for Bills of Materials (BOM) such as defining parameters, routings, alternatives, departments etc.
• Defined exception sets, workday patterns, workday exceptions and built the calendar.
• Designed purchasing cycle to take care of generating requisition for raw materials, approval of requisitions, placing Purchase Order on the supplier, receiving the material in and finally making the payments
• Extracted and Identified the tasks for the Data Validation - Item Master, Purchase Orders, and Outside Processing Reviewed the implications of the functional decisions being made during the setup process
• Responsible for identifying the purchasing hierarchy and the setup of positions, approval assignments, approval groups and buyers.
• Working extensively on Advanced Pricing setups in Oracle Order Management - Defining Pricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, Freight Charges
• Setting up the appropriate Price List in Order Management Application for various inventory items
• Resolved severity one defects and provided root cause analysis in procurement track, which led to completion of testing on time and was appreciated by business leads
• Worked on Purchase Order workflow which included routing of Purchase orders and relieving the Purchase orders and the requisitions that are stuck in process when the Transaction processor was down.
• Comprehensive understanding and defining of inventory planning methods (min-max, re-order-Point), ABC Analysis, cycle counting, physical inventory.
• Checking on-hand quantizes, transferring items between sub inventories, transferring Items between organizations, receiving the item in the destination organization
• Setup item categories, category sets, item attribute controls, item template and catalog groups.
• Created Inter Company price list for Inter Company transactions in Order Management and Inventory application
• Setting up Pricing Attributes, and Pricing Contexts in Advanced Pricing.
• Maintained purchasing locations, buyers, approval groups, options and lookup codes
• Supported production environment for Purchasing, Inventory and Payables.
• Developed training material using user productivity kit (UPK) and involved in user training during the deployment phase for every division.

Environment: Oracle Applications R12.1.3, Oracle 11i, SQL plus, Toad, UPK, Windows NT

Confidential, Emeryville, California

Functional Consultant

Responsibilities:

• Designed and configured Inventory, Bills of Material and Work in Process as per US Supply Chain and Operations business requirements.
• Defined approaches for material replenishment to reduce inventory and increase throughput by implementing min-max planning, reorder point replenishment and kanban techniques.
• Part of the team that defined the Key Flex Field (structures) in Inventory modules, setting up of BOM for Rotary Plant for their new product, defined workday calendar, workday template, Defined Department classes, Departments, resources & Routings and assigned Resources to Departments and Operations to Resources.
• Conversion activities to load the Routings/Bills of Materials utilizing the Routing API and the Bills of Material API.
• Defined inventory organizations, parameters, sub inventories, and picking rules in Inventory
• Followed up with Oracle support regarding bugs and patches.
• Setup shipping networks to enable Inter Organization Transfers.
• Handled production support group issues related to inventory, purchasing, bills of material and work in process modules.
• Performed the month-end process, generating the monthly reports on Order backlog and Inventory.
• Worked with the technical team in gathering specifications for preparing an extension that auto assigns items to a large group of existing organizations or auto assign newly defined organization to the existing items
• Worked on User Productivity Kit (UPK) to develop training material and trained the end users on Inventory and purchasing modules

Environment: Oracle Applications 11i, Oracle 9i, SQL Plus, Toad, Windows XP.

Confidential

Functional Consultant

Responsibilities:

• Responsible for configuration of bills of material and work in process.
• Involved in testing of Oracle Inventory, Purchasing, Bills of Material and Work In Process Modules in testing instance after Setups.
• Handled Production Support Group issues related to Oracle Inventory, Oracle Purchasing, Bills of Material and Work In Process Modules.
• Created BOM, resources for finished goods and sub-assemblies and created routings standard operations for routings.
• Defined and determined the workday calendar.
• Involved in functional testing of new enhancements / Requests (New Business Processes)
• Roles included training on Fit-Gap Analysis, communication with the facility employees to get the specifications setting up Inventory Item Flexfield, Categories Flexfield, Catalogs Flexfield, Accounting Flexfields, Organizations, Sub-Inventories, Suppliers, Customers, Item Templates and Set of Books.
• Involved in preparation of test cases for both unit testing and integration testing and recording results after testing.
• Preparing Test scripts for Item entry into Item Master, writing customized reports using report wizard.
• Involved in post implementation process improvements
• Assisted in identifying and got the patches required and completed all post-upgrade steps

Environment: Oracle Applications 11i, Oracle 8i/9i, SQL plus, Toad.