SUMMARY:

• Certified Oracle Professional, Business Process reengineering analyst with 9 years of experience as an Oracle Supply Chain Management Functional Analyst and an exceptional track record in analyzing, implementing, upgrading and post production support of Oracle Manufacturing and Distribution modules in highly customized environments
• 9 years of EBS experience including Business Analysis with Requirement Gathering, IS - AS, TO-BE, Gap analysis, various Testing, Conducting CRPs and UAT.
• 2+ Years of experience as a team lead / Project lead and lead multiple Projects, enhancements, extensions, testing, Reports and Interfaces.
• Extensive hands on expertise in Oracle EBS (E-Business Suite) Supply Chain Management (SCM) modules including Inventory (INV), Purchasing (PO), Order Management (OM), Bill of Materials (BOM), Work in Process (WIP) and good knowledge of iProcurement (iProc), Material Requirement Planning (MRP)/Master Production Scheduling (MPS) and end to end business cycles of P2P and O2C.
• Good knowledge of WMS implementation.
• Good working knowledge of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles in Oracle Applications, coupled with strong domain knowledge of functioning of supply chain models
• Proven Expertise in business process mapping, analysis, design and configuration, customization & workarounds, functional issue resolution, System Integration and Acceptance Testing as a part of Implementation& Up gradation
• Proficient in creating & maintaining Application Implementation Methodology (AIM) documents- Business Process Architecture (BP 80), Business Requirement Definition & Mapping (BR 30), Module Design & Build (MD 50), Conversion (CV 40), Data Migration, Application Configuration (BR 100), User Manuals & Test Scripts (TE 40)
• Worked on various phases of Implementation, Upgradation & Post-Production Support
• Vast experience in managing large group of business team and coordinate the key business users to get sign off the documents at different intervals and to meet the aggressive time lines
• Exploration Phase Scheduling- Application requirement & evaluation study, Selection of Product Vendor & sourcing, Product demonstration to Project Steering Committee & Key Business Users Selection of implementation methodology
• Coordinate with Oracle Technical Support on open SR / TARs and conducted OWC for the speedy resolution of the open issues
• Extensive experience in managing offshore team and coordinating with onsite & Offshore technical team for speedy resolution of technical issues and timely deliverable of RICE components
• Enable Phase Scheduling- Defining Roles and Responsibilities, On the job for Key users & End users, Parallel process running, UAT, going live, Post implementation issues (help desk)

TECHNICAL SKILLS:

Oracle ERP Versions: R12 (R12.0.3, R12.0.4, R12.0.5, R12.0.6, R12.1.1, R12.1.2, R12.1.3) 11i (11.5.7, 11.5.9, 11.5.10, 11.5.10.2)

Oracle Modules: PO, iProc, INV, OM, Advance Pricing, WIP, BOM, OPM, WIP, Install Base, Field Service, MSCA, P2P, O2C & Q2C Cycles.

Data Loader, Web ADI, ADI, Hyperion, OBIEE, PL/SQL, TOAD, SQL Loader and Discoverer, WINSCP.

Office Suites: MS Excel, MS Access, MS Word, MS Visio, MS Outlook.

PROFESSIONAL EXPERIENCE:

Confidential, Jamesburg, NJ

Oracle SCM Functional Team Lead

Responsibilities:

• Day to day/ Month end production issues: receiving issues, Shipping issues, Release issue, Transaction issues, Interfaces issues, serial and lot issues, Scanner issue, Printer Issue, Tab issue.
• Enhancement: Lead following enhancements with team of 4: Colorlynx Dropship Project, Equipment Dropship project, designed new pages to track RMA, Custom PO creation programs for supply and contract supply items, Label Printing Project for ELearning and Prograf and E-carrier page and process.
• Discoverer Reports: Designed reports like RMA on demand report, Open receipts report, new Item creation report, Release summary report, and Shipment tracking report.
• Custom Interface: lead team of 2 with following interface implementation: Designed interfaces to send PO’s and to receive PO’s between Oracle and S21; Interfaces between new Business Process Centers and Oracle; Interface between DB SCHANKER and ORACLE.
• Built custom ASN EDI between CSA and CUSA, since EDI 856 will not support serial number.
• BPC Conversions: On-Hand, Item, Organization, Sub inventory and Location.
• As part of enhancement, Interface and Report build our team collected Requirements from business, worked on AS-IS and TO-BE process.
• Identified GAP and created MD50 / PRICE documents and updated BR100 document.
• Tested new components and existing components as part of unit and integrated testing.
• Conducted UAT after preparing UTD (User Document). After approval, new changes were deployed to Production with the help of CM team.
• Integrated Prophet by Baxter planning tool to replace Min-Max planning.
• As part of this project I designed and sent 12 feeds into Baxter, this includes Item Master information, Model Information, Demand, Onhand, Site, BOM etc.
• Upon processing Baxter sent PO information, Move Order Information for Technicians and Min-Max details (useful for validation in Oracle)
• Using above information POs (Created new buyer and followed standard approval process) and Move Orders (Maintained Approval limit in Value Set and compared item cost* qty against it) are created
• Lead team and automated end to end process for Software fulfillment in CSA.
• Our team collected Requirements from business, worked on AS-IS and TO-BE process.
• Identified GAP and created MD50 / PRICE documents and updated BR100 document.
• Designed and Implemented Dropship Sales Order creation from Custom application (SOM), PO creation from Sales Order, Custom Auto PO receipts, PO registration, Install base instance creation, contract creation, renewal process and RMA process
• Created 19 KFF on Item Master as part of Software project. Multiple Value sets are created to maintain values for KFF.
• There were about 5000 items related to Software, Software License and Software Maintenance affected.
• 16 components: SOM, OM, Shipping, PO, Receiving, Item Master, Inventory, Contract creation, AR.
• New Java pages were created for Registering Software and for Supplier view.
• Tested new components and existing components as part of unit and integrated testing.
• Conducted UAT after preparing UTD (User Document). After approval, new changes were deployed to Production with the help of CM team.
• Screen and Functionality Design: Inventory Transaction Inquiry, Receiving Order, Item Change, Item Adjustment, Stock Status Change, Purchase Order, Shipping Order .
• Reports: Designed reports like RMA on demand report, Buy report, new Item creation report, release summary report, and Shipment tracking report.
• Interface: Designed interfaces to send PO’s and to receive ASN between S21 (CSA) and S21(CUSA); S21, Oracle and ETUDE interface to collect on-hand, Received quantity and shipped quantity from S21 and Oracle and send it to ETUDE; S21 and Tecsys WMS interface.
• Conversion: Locator, PO Acknowledgement, ASL, Shipping Grants, Pick Release Rules, WMS Package Codes, Item and On hand.
• Testing: Testing Screens, Functionality, Report, Interfaces and Conversion.

Confidential, Buena Park, CA

Oracle SCM Functional Analyst

Responsibilities:

• Lead testing with team of 7
• Tested integrity of the system with different modules related to SCM and third party interfaces.
• Prepared documents and Trained users.
• Conducted UAT for OM and PO users.
• Validated SCM cutover validation report before GO-LIVE.
• Maintained documentation for each issue & followed the change management process wherever there is functional configuration change is proposed by the business.
• Conducted team meeting at the end of the day and discussed about progress of the issues in the issue tracker and discussed about how to approach new issues.
• Responsible for tracking of all issues created by me and prioritize depending on the key business area & assign it to the technical teammate.
• Prioritized as major, minor, critical and blocker depending on the issues & coordinated with my team to resolve the issues
• Provided to end users for repetitive user errors

Confidential, Schaumburg, IL

Oracle SCM Functional Analyst

Responsibilities:

• Collected AS-IS order flow and Shipment flow for 3 different oracle systems (1 11i and 2 R12) from the business and communicated to my team and made them to understand the relationship between 3 different oracle system and multiple interfaces.
• Conducted business meeting to collect all the requirements for order flow and shipment flow and offered 6 different options (for each system) as the part of TO-BE process.
• Draw AS-IS and TO-BE business flow using Visio.
• Gave power point presentation to the business (includes flow diagrams, cons and pros) which helps business to understand different options easily.
• Work extensively with Q2C and D2D team and setup IR-ISO, Drop Ship, Back to Back, Sourcing Rule, Approved supplier list and Supplier.
• Redesigned O2C and P2P process
• Owned functional specification documents and KDD for 3 different oracle systems.
• Maintained different trackers used to track 4000+ responsibilities.
• Collected priority for the responsibilities which to migrate into prod and communicated to my tech team.
• Use to communicate daily and weekly status with business and teammates.
• Involved as a part of testing (sanity check, smoke test, negative test, regression analysis and SIT)

Confidential, Eldon, MO

Oracle SCM Functional Analyst

Responsibilities:

• Automation of Item Set up including set up of Item
• Setup of Item Templates & Item Categories
• Setup of Order Management with Order Transaction Types, RMA types with various kinds of Order Holds utilizing credit check at different stages of the order
• Order entry & order booking - Use defaulting rules & processing constraints to help through order entry
• Implementation of Holds using Oracle workflow to ensure greater control over Order Modification
• Invoicing of the orders as per the business rules
• Analyzed various pricing business scenarios to understand pricing & discounting requirement of the client
• Implemented various pricing & discounting measures based on product hierarchy & pricing attributes
• Defined & mapped flexible attributes & domains to control the prices & discounts applicable to different items, customers & orders
• Defined various price lists, pricing contexts, attributes & attribute values to meet the business requirement
• Setup of Price Lists for different Order Transaction types, RMA types.
• Setup Modifiers to pass on charges to the customers like Freight charges (captured at the point of shipping)
• Set up Agreements with customers to use pre-negotiated prices, freight charges & payment terms
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, & Approval Management
• Set Up of sourcing rules & Approved Supplier Lists
• Prepare & review test scripts based on the business requirements.
• Planned, Executed & Monitored the CRP phases in Development instances
• Imparting functional to users & super users
• Conducted user Acceptance Testing (UAT) successfully performed Go-Live stage
• Provided post-production support for PO, OM, Advanced Pricing & Inventory
• Worked on Change Management to follow up the necessary changes which have been made as per the business flow in day to day activities

Confidential, Lexington, SC

Oracle SCM Functional Analyst

Responsibilities:

• Conducted meetings regarding the cut over & Go live plans
• Provided post-production support for Inventory, PO and BOM
• Rendered support for troubleshooting, testing product problems and client configurations
• Conducted meetings to identify and assess the impacts of production issues and provided solutions
• Transferred engineering items to WIP, Inv and defined standard operations
• Assisted and monitored transactions in inventory such as miscellaneous transactions & inter org transfers
• Supported the end users in copying, transferring & checking for loops in bills
• Handled issues that came up during the live phase, prioritized them based on the severity and raised Service Requests
• Documented issues which came up during Unit Testing, performed change management process proposed
• Tested the system functionality after scheduling upgrades and customizations
• Handled customer requests for system enhancements, testing and maintenance
• Updated user scripts and proposed best practices for Inventory, BOM and OM
• Updated the BR 100 documentation according to the changes processed
• Assisted users in performing daily activities and resolved issues

Confidential, Moberly, MO

Oracle SCM Functional Analyst - (Purchasing, & Inventory)

Responsibilities:

• Designed and implemented Item Status, Item Attributes, Item Templates, & UOM Conversion
• Data Migration of Item Categories, Cost groups, On-hand Inventory Quantity, Supplier lists, Locator & Sub-inventory
• Item categorization for Min-Max & Re-Order Point Planning, depending on client requirements & suggested Re-Order Point planning for certain item categories previously replenished by Cycle Counts
• Setup of Consigned Inventory by defining specific Asset & Expense Sub-Inventory according to Supplier & Receipt Routing techniques
• Conducted CRP1 & resolved all identified issues resulting from testing the solution
• Design & development of the User Guide for PO & INV focusing on Inventory Transactions, Hierarchies & Approvals

Confidential, Lisle, IL

Oracle SCM Functional Analyst - (OM, PO, Advanced Pricing, O2C cycle)

Responsibilities:

• Provided manufacturing functional expertise during development of distribution execution system
• Setting up order management, shipping execution setups after finalizing on the requirements
• Provided support and coordinated with financial team for O2C process
• Performed bug checking, logging & followed up with the SR resolution process
• Helped continuously to adapt order management process & Oracle ERP system to support a dynamic business environment
• Trained end users on order management & purchasing
• Worked on making Test scripts and performed testing procedures for various oracle apps modules
• Conducted CRP’s (Conference Room Pilots) to ensure that the business processes are performed successfully using oracle Applications
• Go-Live stage was performed successfully

Confidential, Thornton, CO

Oracle SCM Functional Analyst - (PO, INV, P2P Cycle)

Responsibilities:

• Analyzed the existing business process flows in manufacturing & supply chain management
• Interacted extensively with the Client’s formulated strategies and analyzed gaps to streamline the usage of existing oracle ERP
• Complete procure to pay cycle setups from entering the requisition in purchasing to entering the receipts & creating the invoice in accounts payables module to support business requirements
• Performed organization setups including inventory organizations, locations, freight carriers, items, etc
• Defined product catalogs and categories in inventory module
• Conducted Conference Room Pilot (CRP1), made all the standard setup and successfully run the smoke test to check with the errors

Confidential

Oracle SCM Functional Analyst

Responsibilities:

• As a Functional Consultant, was involved in the Implementation and Customization of Oracle Applications (Oracle Inventory and Oracle Purchasing)
• Detailed Study and analysis of the existing system
• Gathering of requirements and desired functionality list for Order management module
• Set up of Inventory Organizations, Sub inventories, Item relationships, Shipping networks, Transaction Sources etc.,
• Set up user defined transaction types for inventory transactions pertaining to the issues, transfers, miscellaneous receipts
• Set up of Order Management with Order and Line Transaction Types suiting to business needs
• Assigned relevant order level and line level work flows at the Order Transaction types mapping to the business needs. Eliminated customization of workflows by mapping the business flows to the standard seeded workflows available in the Order Management
• Set ups of Internal Sales Order process specific to Inter Org transaction business needs and Drop shipments
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies and Buyers
• Set up of Approved Supplier List, 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
• Modification of PO workflows (PO Create Documents, PO Requisition Approval) attributes enabling the auto generation of Purchase Orders
• Configured Requisition based on position and PO hierarchies for approval management as per the Procurement Policies
• Imparting functional to users and super users
• Carry out set ups in TEST and PROD instance and assisted in conversion activities prior to go live
• Go Live Scheduled and ended successfully