SUMMARY

• 13 Years of extensive Oracle Consulting experience in Oracle EBS SCM (Supply Chain Management) Modules (Inventory, Purchasing, Order Management, Advanced Pricing, iProcurement, AME, iSupplier, Sourcing, WIP, BOM, WMS & MSCA) and Oracle Procurement Cloud & Oracle Order Management Cloud. And 12 Years of Domain experience as a Purchasing Officer in Manufacturing Industry.
• Specialized in Implementation, Upgrade and Support in Oracle EBS Procure to Pay (P2P), Order to Cash (O2C), Make to Order (Discrete Manufacturing) and Warehouse Management modules.
• Experience in Business Requirement Gathering, AS - IS & TO-BE Study, GAP Analysis, Configuring Applications, Test Plan Preparation, Unit testing, CRP, KUT, UAT, Parallel, Go-Live and Post GO-LIVE Support.
• Experienced in designing the Interfaces between Oracle and Third-party applications. Involved in Conversion activities from Legacy to Oracle and Oracle to third party applications.
• Worked on EDI 850, EDI 855, EDI 856 and EDI 861.
• Project Management Professional (PMP) Prep I certified.
• Experience in Project Management activities such as Time & Cost Estimations, Resource Identifications & Deployment and Organizing Meetings.
• Experience in handling Pre-Sales activities in devising various trading strategies such as Proposal preparation, conducting client Demos and preparing Project Plan along with Estimates.
• Demonstrated excellence in implementing ERP systems ensuring smooth operations.
• Ability to support and sustain a positive work environment that fosters team performance with strong communication and relationship management skills.
• Excellent communication and relationship management skills with the ability to relate to people at all levels.
• A strategic planner with proficiency in designing internal control systems towards accomplishment of corporate business goals.
• Excellent experience in onsite - offshore model
• Good knowledge in Oracle AIMS methodologies and prepared BR100, MD050, TE040, CV040, CV120, and BP080 documents.

TECHNICAL SKILLS

• Oracle Purchasing (PO), iProcurement (iProc), iSupplier, Sourcing, AME, Landed Cost Management (LCM) & Accounts Payables (AP)
• Order Management (OM) - Order Entry / Shipping Execution, Quote, Advanced Pricing & Accounts Receivables (AR)
• Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Cost Management & Quality
• Oracle Warehouse Management System (WMS) & Mobile Supply Chain Application (MSCA)
• Oracle SQL & PL/SQL (TOAD)
• Form Personalization
• Data Loader

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Senior SCM Consultant

Environment: Oracle EBS - R12.2.5

Responsibilities:

• As a Sr. SCM Consultant, responsible to configure the Oracle Order Management and Advanced Pricing modules to Sherwin Sweden, Denmark, Norway, Finland and Ireland.
• Design and built the below custom screens.
• Create Sales Order Screen
• Item Creation Screen (COROB Item, Aerosol Item, COROB MAKE Item)
• New Ship to Site Creation Screen
• Sales Order Header and Line Additional Information Screens
• On Hand Availability Screen
• Add Charge Screen
• Order Dashboard (Order Organizer)
• Order Summary
• Pick Release
• Pick Confirm
• Create Sales Order Screen was built with most of the Oracle standard functionalities.
• Using this custom screen, we can create New Items and New Ship to Sites on the fly.
• Automatically, new items will be added into the Price Lists based on the Pricing Category. So that, without switching to multiple screens/forms, we can create the items and then create the sales orders immediately.
• Using this custom sales order screen, we can add or cancel lines/orders, process returns, apply modifiers, override the prices and check the Additional Order & Line Information details.
• Order Dashboard Screen was built with various tiles like All Orders, Due Today, Past Due, On Hold, Drafts, In Production and Drop Ship.
• Each Tile will give the snapshot of number of orders and lines in each category. If we select one Tile, then it will list all the orders and lines in that category.
• It was built with “Select” option. We can select the required sales orders or all orders and perform Pick Release for the selected sales orders.
• Order Summary screen will display the On-Hand Details, Batch details, Batch Status, Dropship PO details and Shipment Details.
• Built the Price List Web ADI. It will allow us to download the price lists from Oracle and do the mass updates. Once the updates are done, we can upload the price lists to Oracle.
• Involved in various Conversion activities which includes Price List header and lines, Open Sales Orders, Automatic Attachments and Item Cross References.
• This project went through multiple key milestones like, Discovery, CRP, SIT, KUT, UAT, Parallel and Go Live. During Parallel, all the real transactions are performed in Oracle and Legacy System (SYS 21 & IFS). We built the dashboard to identify the differences between Oracle and Legacy system.
• Prepared UPK documents for all the scenarios for business users.

Confidential, Cleveland, Ohio

Oracle Procurement Consultant

Environment: Oracle EBS - R12.1.3

Responsibilities:

• As a Sr. Procurement Consultant, responsible to configure the Oracle Purchasing and Inventory module related functionalities to US, Canada and Mexico retail stores.
• Designed the below custom screens for Purchasing.
• Purchase Order Creation Screen for DC’s
• Autoship PO Creation Screen for Stores
• PO Summary Screen
• PO Corrections Screen
• Archway PO Creation screen
• Receipts Inquiry Screen
• Defined various custom Purchase Order Types like DC POs, Store POs, Autoship POs, Archway POs and Special-Order POs. Each order types will follow a different process/workflow and controlled based on custom PO statuses. It talks to different third-party systems using Interfaces.
• Customized the Purchase Order Workflow based on the Purchase Order Types, Item types (Merch and Non-Merch item types) and custom PO Status like PR, RL, XM, FN and CN for DC PO Types.
• Designed the Interfaces between Oracle and Third-party applications such as EDI, POS, AOM and Prescient systems.
• Successfully implemented the EDI 850, EDI 855, EDI 856 and EDI 861 for all DC’s and Stores.
• Created the EDI Dashboard to reconcile all the EDI Transactions and Interfaces.
• Defined Inventory Organizations and Inventory related setups for 5105 Stores and 17 DC’s.
• Automated the Inventory Period Open and Close process for all inventory organizations using Organization Hierarchy.
• Prepared the UPK Documents for all the business scenarios and trained the business users and global support team.
• Prepared the Test Cases for all the business scenarios and executed.
• Involved in Post Go Live support and resolved the issues based on the SLA’s.

Confidential

Oracle WMS Consultant

Environment: Oracle ERP Applications R12.2.5

Responsibilities:

• Worked as a WMS Functional Consultant in Oracle WMS, MSCA, Inventory, Order Management Shipping and OPM Product Development modules.
• Customized the Picking and Shipping process based on the client requirement.
• Designed custom screen (Tripware) for Pick Release process to capture the vehicle details along with shipment weight.
• Developed Express Picking and Direct Shipping functionalities
• Participated in UAT, SIT and Regression Testing in Phase I for Nebraska plant.
• Gathered the requirements for other sites Seattle, Utah and Kingman plants and performed gap analysis then documented the details.
• Configured the CRP instances for Seattle, Utah and Kingman plants.

Confidential, Irving, TX

Oracle Manufacturing and Distribution Consultant

Environment: Oracle ERP Applications R12.1.3 Modules Handled: BOM, WIP, Cost Management, INV, PO, OM, Quote & MRP/MPS Planning

Responsibilities:

• As part of data clean-up activity, the below interfaces have been designed and built to copy the old item code to new item code .
• Item Interface
• Item Category
• Item Catalog
• UOM Conversions
• Item Cost for Non-BOM Items
• Item Cross References and Item Relationship
• Routing
• BOM
• Miscellaneous Receipts & Miscellaneous Issues
• Open Sales Order lines & Reservations
• Sales Order Line Cancellation
• As part of the new data additions, designed and built the below interfaces and successfully imported the new data.
• Item, Category & Catalog Conversions
• UOM Conversions
• BOM & Routing Conversions
• Prepared CV040, CV120, BR100 and MD050 documents
• Created the new Manufacturing Organization and its related configurations for all the newly acquired companies.
• Designed and built many new reports based on the business requirement.
• Worked as a Manufacturing and Distribution consultant and supported Oracle Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM) and Cost Management modules.
• Changed the previous company name and logos (Hanson Pipe & Precast) to new company name & logo in all the forms and reports (Forterra Pipe & Precast)
• Worked with support tickets and resolved based on the SLAs (Response SLA and Resolution SLA).
• Configured Oracle MRP/MPS for 11 Texas organizations.
• Configured the Intercompany Transactions between US and Canada organizations.

Confidential, Dallas, TX

Procurement Solution Architect

Environment: Oracle ERP Applications R12.2 Modules Handled: iSupplier, Sourcing, Inventory, Purchasing (PO), iProcurement & APEX

Responsibilities:

• Worked as a Solution Architect in iSupplier, Purchasing (PO), and iProcurement modules to develop the custom iSupplier Portal.
• Designed the Future Process Model and prepared BP080 document.
• Identified the project team members and prepared the project plan and other project related details.
• Gathered the business requirements by interacting with existing clients and prepared RD050 document.
• Interacted with Technical team members to develop the iSupplier Product and developed the CRP and UAT instances.
• Prepared the test scripts and conducted SIT and UAT successfully.
• In Phase I, developed the Custom iSupplier portal with Supplier Registration and Supplier Approval process.
• In Phase II, developed the interface between Oracle EBS and custom iSupplier portal to exchange the Requisition and PO details.
• In Phase III, developed the interface to exchange the ASN and Invoice details.