SUMMARY

• Work Experience with more than 7 years in Oracle Application in the area of Manufacturing and Supply Chain Management/Distribution.
• Oracle Apps Analyst with specialization in
• Supply Chain Management (Inventory, Purchasing, Order Management, Advance pricing, Receiving, Shipping (PO, INV, OM,QP,WSH))
• Manufacturing and Distribution (Bills of Material, Work In Process, Warehouse (BOM, WIP, WMS))
• Carried out number of Full Cycle implementations and various other projects in different versions of Oracle Applications 11i and R12.
• Hands - on experience implementing various processes like Order To Cash (OTC), Procure To Pay (P2P), Return Material Authorization (RMA), Drop Shipment, Make To Stock (MTS), and Quote to Cash (QTC).
• Experience with Oracle E-Business Suite and involved in Implementation, Onsite & Offshore Support, Global Roll-out, Enhancements, Integration, Problem Solving, Troubleshooting and Training. Expertise in Inventory (INV), Bills of material (BOM), Work in Process (WIP), Order Management (OM), Shipping (WSH), Purchasing (PO), Advanced Pricing (QP) & System Administration (SYSADMIN).
• Exposure to preparation of high-level functional design documents like AIM docs, (MD60 for forms, reports extensions, CV docs of Conversion, from one Legacy system to Oracle Applications, Loading Data into Interface Tables, Handling the Errors).
• Ability to interact directly with client and/or end users / Super users to solicit information and define solution requirements.
• Writing/executing the scripts using SQL to perform various extracts from the database. Well conversant with table structure and Flow.
• Experienced with Production Support for both Onsite-Offshore project model.
• Self-motivated and directed with a keen attention to detail and can contribute in both, a team-oriented environment or a self-driven environment.
• Project Management - Prioritizing system problems, enhancement request and scope management. Reporting the status to the Steering Committee.
• Tasks performed in various projects include -
• Business Process modeling and Requirements Gathering.
• Fit-Gap Analysis.
• Creation of Solution Design and system configuration.
• Development of Test Scenarios.
• Testing - CRPs, Unit Testing, Integrated Testing, User Acceptance Testing(UAT)
• Development Of Training Material And Documentations (AIM Methodology)
• Trained Business Users.
• Post-Production Support for both Onsite-Offshore project model.

TECHNICAL SKILLS

Oracle Applications Core: Manufacturing and Supply Chain/Distribution

Modules: INV, OM, QP, PO, WSH, WIP, BOM, MRP

Documentation: AIM Methodology

Applications Releases: 11.5.9, 11.5.10, 11.5.10.2, R12.0.3, R12.0.6, R12.1.3

Operating Systems: Windows 95, Windows 2000 XP.

Other Software: SQL Loader, Data loader, Toad, MATLAB, MathCAD, Microsoft - Word, Excel, Power Point, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

Oracle Apps SCM Functional Consultant

Environment: Oracle Applications: R12.1.3 Implementation, PL/SQL, SQL* Plus, SQL *Loader

Responsibilities:

• Successful solutions derived for the unique business processes followed at different contract manufacturers to meet business demand & to meet unique manufacturing process.
• Analyzed the “As-is” processes with the project team by interviewing Branch SME’s and via information requests, documenting site visits and discussing day-to-day operations with branch personnel and business leaders.
• Designed the “To-be” process flows based on business transformation vision and got consensus among various stakeholders to approve the said design.
• Created Inventory Orgs, Item Master, Item Categories and Catalogs and Sub inventories.
• Involved in importing of item cost from legacy system. Implemented Procure to Pay and Order to Cash cycles.
• Also involved with many setups and interface designs of Purchasing and Order Management.
• Implemented Purchase Requistion Process and Approval hierarchy to manage non-production items purchases in the Organization.
• Configured Auto-Sourcing rules, Approved Supplier List(ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench.
• Gathered requirement for Item templates by classifying items like Purchased Item, Reference Item and Supercede item accordingly created templates for them by enabling suitable attribute.
• Setup Planners, Buyers, Categories, Unit of Measurement, Modifiers, Qualifiers and Price lists.
• Set up new user responsibilities for different org based on the end user
• Setup suitable descriptive flex fields for the item based on the Inventory Organization.
• Set up Assignment set, Sourcing Rules and the Approved Supplier list.
• Set up of Payment Terms, PO Lookups, Purchasing options, Suppliers, Transaction Reasons, Employees, Receiving Options, Financial Options, and Ship-to Location.
• Set up PO vendors, vendor sites, and Descriptive flex fields to capture additional information.
• Assist users in creating Standard Purchase order and Blanket agreement.
• Following are the custom components developed along with PREP implementation,
• Purchase Order Integration from ERP to O2S (Order to settle) system through Optio system based on the transmit code. Where the Po information is communicated to supplier, and supplier communicated to buyer through O2S system, enhance real-time demand is visible to Supplier in Online.
• Incorporated Logic for Approving the PO for special charges items - Expense types though customization of approval assignments.
• Enabled the system to allocate material for picking (directed picking) by using Picking Rule.
• Worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items.
• Involved in setting up Out-Side processing flow.
• Developed Custom Solution for Scheduling, WO (Discrete Job) Creation, TRIP Creation, Doing a Dummy ship confirm even before releasing the SO (Sales Order) because of Business requirements for Material Planning.
• Worked end-to-end on Oracle EBS Procure-to-Pay and Order-to-Cash processes.
• Stream lined the receiving process, shipping process, discrete job processes.
• Created custom report in supply chain modules using BI Publisher.
• Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.
• Created functional design (MD050) documents for various objects on FWRICE.
• Developed comprehensive Test Plans, conducted Functional Unit Testing, System Integration Testing, User Acceptance Testing.
• Successfully completed CRP Phase as per the business requirement.
• Conducted Training & Business Process Refresher for the business & project team.

Confidential, Seattle, WA

Oracle Apps SCM Functional Consultant

Environment: Oracle Applications: R12.0.6 Implementation, PL/SQL, SQL* Plus, SQL *Loader, BI Publisher

Responsibilities:

• Understanding of Confidential business model & integration of different Business Units.
• Simulation of Contract manufacturers (CM) on different payment model (Pay at Shipment and Pay at Production) and developed seamless integration concept for greater visibility of CMs based on their requirement.
• Modeled the conceptual design into a pilot project to demonstrate end-to-end transaction by configuring Oracle Apps modules.
• Setup of Application Users, Menus, Request groups, Responsibilities and many forms of Personalization and inventory org access.
• Designed and implemented Item Status, Item Attribute Control, Item DFF, Item templates, Item-Relationship, Sub inventory, Planners, Cycle Counting, Item Attachments, Shipping Network, UOM Conversion and validation of inventory orgs.
• Performed the clearing of all open transactions like intransit shipments, intransit receipts, Open ASN POs, Open WIP jobs by coordinating with the Planning team and used Data Loader for issuing out and load back on-hand for implementing the lot to non-lot conversion of items belonging to contract manufacturing warehouse. Also used data loader for recreation of work orders.
• 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.
• Implemented the approval hierarchies in Oracle PO for requisition/ purchase order approvals, Sourcing rules, Approved suppliers list (ASL), and Quotations.
• Involved in data mapping and data conversion for Items, Suppliers, and Open Purchase orders, Quotes, Sourcing Rules, and Approved Suppliers List.
• Created Blanket Purchase Agreements for OSP items for Pay at production model and worked on the set up of new BPAs for service item type after modifying an existing OSP BPAs for Pay at Shipment model.
• Created customized functional design for an Expense Standard Purchase Orders in EBS for the tolling charges for finished goods shipped out from the Contract Manufacturers (Co-man) facility.
• Worked on the set up of Customers, shipping parameters and created various Roles like Roles for Super user, Roles for Picker, Roles for shipper and Granted to User.
• Created Global queries for oracle access renewal and the other query triggers the data based on link between Purchase order and Sales order.
• Coordinated and guided technical team for the development of customized value map maintenance and Expense PO program.
• Implemented Receipt transfer issue, Procure to Pay and Order to Cash cycles.
• Prepare site specific test script and performed complete cycles testing during the implementation life cycle involving inter instance as well.
• Involved in the Creation of test script documents for CRP & UAT and successfully completed it.
• Month end closing procedure for Oracle Payables and Oracle Inventory. Worked very closely with the Financials team for closing the financial GL books also.

Confidential, Miami, FL

Oracle Apps SCM Functional Consultant

Environment: Oracle Applications: 11.5.9 to R12.0.3 Upgrade/Implement/Post production Support, PL/SQL, SQL* Plus, SQL *Loader, BI Publisher.

Responsibilities:

• Understand Confidential business and provide Functional Business support to Confidential Customers in Europe & APAC related to Oracle Apps Purchasing, Receiving,Order Management (OM), Advance Pricing (QP), Shipping (WSH), and Inventory.
• Optimized the supply chain model using theory of material, capacity and transportation constraints.
• Involved in importing of item cost from legacy system.
• Designed and tested various test business case scenarios, unit testing and integration testing for various business flows.
• Handle prioritizing of business issues and enhancements and guided various other team members.
• Important role in maintaining Oracle setups, designing Pricing Formulas, Modifiers, and Pricing Events. Simplified Pricing Adjustments process which caused significant reduction in manual pricing maintenance.
• Designed custom reports for Oracle purchasing (PO), some of them are listed below:
• Inactive Po: Report showing all PO where there has been no movement for ‘X’ days.
• Report to capture the PO’s, which are received but not yet delivered in WMS Enabled organization.
• Report to capture the Return to Vendor PO’s.
• Unprocessed approved requisitions: Report listing all approved purchase requisition that have not been auto created into a Purchase Order.
• Incomplete PO’s: Report showing all the Open purchase order for a particular time period.
• Customization of sourcing complete auction workflow to update all the sourcing documents i.e. ASL, catalog quotations as an attribute to ASL, sourcing rule, assignment set and Lead Time. Therefore, when the Plan runs for the existing demand, PO can be automatically rolled out. Setting up the attachments for reports like Pick Slip and Pack Slip reports.
• Performed the INV and WMS setups including developing the WMS rule strategies and the associated rules to support the Inbound, Outbound and Warehouse processes.
• Customized the picking process by adding Lot Swapping (Lot Substitution) capability to improve picking efficiency based on the business requirenment.
• Worked on gap to add the ability to capture serial numbers at the time of issuing the material to production order based on the business need.
• Conducted CRP and UAT Sessions and configured UAT Instance and prepared BR100 Documents for Advance Pricing and Inventory modules.
• Integrated Oracle WMS Module with Oracle Quality to enable inspection process after an item is manufactured as per the business needs.
• Prepared the test cases and TE040 documents for CRP and UAT testing.
• Trained Users for their day to day Order Management activities
• Prepared Cut- over Plan and listed down all Pre & Post Go- live tasks for Order Management and Inventory module.
• Created Custom Reports for fast moving and slow moving items by warehouse as per business needs.
• Post Go-Live support and handled Various Order Management and Inventory Issues during production support.
• Manage Oracle Service Requests to resolution effectively; work with Oracle Metalink Support via OWCs on critical severity issues for workarounds & patches.
• Responsible for weekly meetings with client, client’s contractors and other support teams.

Confidential, Calhoun, GA

Oracle SCM Functional Lead Consultant

Environment: Oracle Applications: R12.0.6 Implementation.

Responsibilities:

• Understand business process architecture for Order to Cash, Make to Stock, Procure to Pay of Taiping Carpets entities for business operations and re-engineered current business process during the upgrade to R12.
• Conducted business requirement session, perform Map and Gap analysis and identified key gaps. Involved in POC phase of the project for Inventory, BOM, WIP, and OM Modules.
• Designed detailed Business Process Flow diagram to depict Order & Shipment and manufacturing flows among various TPC business entities.
• Validated the set up steps for Inventory like Inventory Organization, Accounting Information, Inventory Information, and Receiving Information.
• Set up of Sub-inventory, assigning items to Sub-inventory, ATP Rules, Picking Rules, Pick Slip Grouping Rules, Shipping Networks and Descriptive Flex Fields.
• Configured Bill of Materials and Work in Process as per the client’s requirement. Designed BOM structures as per the product line and standards pre existed, Created Routings and common routings based on product families.
• Designed Outside Processing (OSP) WIP steps and sourcing rules.
• Created various functional documents on requirement gathering, gaps and testing using AIM methodology.
• Created a customized quote forms in the oracle system and also used Web-ADI tool for sales order processing as per the business requirement.
• Configured the item flag based on the various attributes for each line quote as to perform the order process.
• Worked on gap to add the ability to capture serial numbers at the time of issuing the material to production order based on the business need.
• Worked on the gap to add the ability for the users to perform mass change in Oracle Order Organizer form when more than 1000 records needs to be changed.
• Performed system admin activities like creation and maintenance of users, creating responsibilities, menu maintenance, creation of requests and request sets, etc.
• Conducted Client site Training for users and prepared End User Guides.
• Handled conversion stages for Inventory, BOM and WIP modules for master and transactional data.
• Provided post production support for all issues - standard, custom, and some legacy system issues.
• Improved processes, performance after Go-Live to best fit the client’s expectation with regards to time.

Confidential, San Jose, CA

Oracle Functional Analyst

Environment: Oracle Application: 11.5.10.2 / Post Production Support

Responsibilities:

• Responsible for the proper functioning of all the activities related to manufacturing and procurement.
• Worked with end-users, IT technical resources and Oracle support to troubleshoot problems and resolve applications issues.
• Performed future planned activities and CRPs.
• Have involved in various functions to perform Inventory process, getting TAR’s resolved.
• Troubleshooting processes and jobs and suggested changes as needed to improve processes and reduce failures.
• Assisted other project teams and Superusers with data extractions for various migration activities.
• Managed virtual teams with remote resources, extensive use of SQL queries during production support.
• Creating functional design and configuration documents.

Confidential

Oracle Functional Analyst

Environment: Oracle Application: 11.5.10.0 / Implementation

Responsibilities:

• Implemented processes related to Inventory, BOM modules.
• Supervising process and functional activities of all Oracle modules in a manufacturing plant.
• Coordinated multiple testing iterations prior to User Acceptance Test to confirm to client’s business requirements.
• Setup of resources, routing, departments standard update cost as per the requirement in BOM module.
• Worked end-to-end on Oracle EBS Order-to-Cash module.
• Tackled issues in various modules especially in manufacturing and distribution sectors.
• Troubleshoot and recommend changes as needed to improve processes and to reduce failures.
• Prepare all local Design Documentation (BR100, BR30, TE40 and MD50), prepare the setup doc and the incremental for their site and do the setup in the instance, Prepare site-specific test script.
• Involved with the interplay of various disciplines such as finance, production, sales and procurement.
• Defined Setups to maintain inventory accuracy like Cycle count and Physical inventory.