PROFESSIONAL SUMMARY:

• Over 10 Years of extensive experience on Oracle Applications Implementation & Support of Oracle E - Business Modules - Inventory, Warehouse Management Systems(WMS), Purchasing, Sourcing, I-supplier, I-Procurement, Quoting, Order Management, Advance Pricing, Shipping, Bill of Material (BOM), Work-in-Process(WIP), Enterprise Asset Management(EAM), Depot Repair and Quality Modules.
• Implementation experience on Oracle e-Business Suite Release 12& 11i(Oracle Distributions & Manufacturing modules).
• Excellent configuration experience on Procure to Pay and Order to Cash Cycle's Using Multi-Org.
• Working knowledge withAccounts Receivable, Accounts Payable, Project Accounting, HRMS and Project Manufacturingin the integration point of view.
• Extensive US consulting experience working for a Big firm like General Electric(GE) in Manufacturing and Supply Chain domains.
• Multiple complete end to end ERP life cycle implementations covering Requirement Analysis, Process Mapping, GAP Analysis, Setups, and Functional Specification for Customizations, Testing, User, CRP, Go-live and Post Implementation support.
• Upgrade experience from Oracle apps Release 11i to 12.
• Extensive experience in supporting application in PRODUCTION environment and providing quick solutions within the SLA.
• Lead experience working in Onsite/Offshore model.
• Hands on experience in Global Implementation Rollout’s.
• Conducted requirements gathering workshops, prepared … GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user sessions.
• Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle Meta Link and Oracle Applications Patch Management.

TECHNICAL SKILLS:

Functional Modules: Oracle Applications Release 11i&12 - Inventory, Warehouse Management Systems(WMS), Mobile Supply Chain Applications(MSCA), Purchasing, Sourcing, I-supplier, I-procurement, Quoting, Order Management, Advance Pricing, Shipping, Bill Of Material(BOM), Work in Progress(WIP), Enterprise Asset Management(EAM), Depot Repair & Quality.

Language: PL/SQL

RDBMS: ORACLE 9i, 10g, 11g

Tools: TOAD, HP Quality Center, SQL

Microsoft Office tools: Access, Excel, Outlook, PowerPoint, Word, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Retail Merchandising

SCM Consultant

Responsibilities:

• Functional responsibility for end to end P2P Transaction & Master data conversions viz. Open Purchase Orders, Supplier Master data, and Open AP Invoices from third party systems.
• Working in a multi system environment with Biceps, Triceps, WCSS, EXE, Food link and Mainframe with Oracle EBS R12 being the center piece for all inbound-outbound transaction & master data maintenance flows
• Owning Interface and Extension design from conception to implementation for designated inbound and outbound P2P interfaces and Master data additional information for legacy system cross
• Design of the custom PO form and mapping of the data with the Legacy system.
• Conduct CRP sessions for showcasing proposed design of designated RICE components
• Extensively worked on the transfer of files for receipt, delivery and On hand data between Oracle, RDX and Manhattan systems.
• Assist client team in end user demo sessions
• Proficient use of Auto task and IBM RQM as a part of project lifecycle

Confidential, Wilmington, NC

Environment: Power Energy -Discrete Manufacturing

Consultant

Responsibilities:

• As Part of the Oracle E-Business suite (R12) Implementation worked on Quote to Cash (Q2C) processes .Implemented Quoting, Oracle Order Management, Advance Pricing, Shipping modules.
• Involved in the design and mapping of the ITO and OTR process in Order Management
• Integrated Quoting with Oracle Approvals Management (AME) to achieve Quote Approval Process.
• Designed the commercial approval routing in Quoting as per the requirement from Business.
• Worked on form Personalization to standard Oracle quoting form to support business needs.
• Provided a solution to fulfill the customer orders by shipping the items from the supplier directly to the customer, through the Drop Ship Process, eliminating the inventory management costs with no upfront inventory and ensuring positive cash flow.
• Designed the back to back Order process for the manufacturing, purchasable products and integrated the receiving process with the Quality module for inspection of the material.
• Designed the five step Sales order approval process from ITO PM, Engineering Team, Commercial Owner, Commercial Level2and Billing Team customizing standard Oracle, ‘Sales Order Header’ workflow.
• Designed the inbound logistics such as Receipt, Inspection and Put Away processes in Oracle WMS.
• Designed the custom process for the auto put away of inspected material to the designated sub-inventories for the specific business unit.
• Designed the custom process of auto generation of LPN’s at the time of receipt.
• Setup for the integration of Inspection process with collection plan elements to capture the business inspection attributes in Oracle Quality Module.
• Worked on the installation of Oracle WMS and MSCA application along with the RF Handheld Scanners.
• Design and implementation of the customization for Sub lot LPNs i.e. Accepted and Rejected LPNs during inspection to be populated automatically.
• Custom Oracle Form, for capturing Item on low supply and controlling their release to warehouse

Confidential, Totowa, New Jersey

Environment: Healthcare Equipment -Discrete Manufacturing

Consultant

Responsibilities:

• Designed the new Label formats as per the business requirement.
• Design of custom label printing solution for LPN and Shipping Labels.
• Worked on design of Custom LPN Shipping and Content Labels printing solution
• Custom MWA Telnet form for Label printer assignment and enquiry.
• Developed Custom MWA Telnet form for Truck Manifest creation.
• Involved in the installation and testing of the multiple Loft ware printers
• Worked on set-ups for WMS replenishment tasks and WMS picking rules for the new business requirement.
• Trained the business users on using the RF Hand held scanners.
• Provided WMS solution to the business warehouses which is suitable for their requirements.
• Designed a custom Oracle ADF form to automate the process from Picking to shipping for the high priority Orders.
• Stabilizing existing custom processes within company like Delivery Grouping Program, custom Pick release processes to meet the new WMS implementation requirements without disrupting the existing flows

Confidential, Wilmington, NC

Environment: Power Energy-Discrete Manufacturing

SCM Consultant

Responsibilities:

• Implementation of Procure to Pay cycle, I-supplier, Sourcing and I-procurement modules across 3 international OU’s.
• Designing the Approval Hierarchy Process for Approval of Purchase Requisition and Purchase orders
• Worked on interface to grant and revoke access of the PO attachments to the suppliers in export control system.
• Implemented quality inspection during the PO receipt process through the creation of quality collection plans, quality parameter and specifications
• Worked on the supplier data and the PO conversions from the legacy system.
• Provided a solution to return goods to suppliers that are found damaged after inspection using return material authorization functionality.
• Assisted in managing the supplier base by enabling supplier ranking, supplier holds, minimum order quantities which helped in creating Purchase Orders effectively.
• Worked on the Purchase order, Receipts interfaces from Global Oracle Application(SSP5) to the business specific Oracle application.
• Worked on the design and building of the outbound interface of the Purchase Orders to Manufacturing Legacy system (CIIM).
• Defining Approved Suppliers and Sourcing Rules for purchasing
• Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization
• Worked on the integration with Payables for Purchase Matching and Receipt Matching
• Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases
• Worked with client in suggesting & developing position hierarchy for organization.
• Integration with Payables for Purchase Matching and Receipt Matching.
• Setup of the RFQ and Quote process in Sourcing as per the business requirement.
• Setup of the invitation, requirement and attribute lists to streamline the negotiation process in Sourcing.
• Setup of the Negotiation styles and Configuration as per business requirement.
• Design of Grant Revoke Access to the technical engineering documents for the suppliers in Sourcing at the RFQ creation
• Designed the workflow approval process and setup the workflow attributes.
• Worked on Designing and modifying the Approved PO report formats (inventory org/Legal Entity specific).
• Implemented Price tolerance feature by enforcing Percentage and Amount tolerances to control the price on the Purchase Order lines that are auto created from the requisitions.
• Successfully executed CRP1, CRP2, and UAT and provided post production support for the end users after go-live.

Confidential, Houston, TX

Environment: Power Energy-Discrete Manufacturing

Consultant

Responsibilities:

• Definition of manufacturing departments and resources, work calendar, working time and lead times as per the business requirement and structure.
• Worked on the design of the interfaces for the Work Order Release to shop floor, Work Order updates, Work Order cancellation, Work Order Component Scrap Process,
• Work Order Move Transaction, Material Issue, Assembly completion, Work Order Component Return to Stock from Proficy (MES) to Oracle with Junot as middleware.
• Design of the OSP flow to help the manufacturing process lower engineering and manufacturing costs and increase production quality
• Extensive work done on the design of the Work Order Creation/Issuance, Work Order Execution, Quality Control and Work Order Completion Process.
• Involved in design and setup of Finished Goods Work Order Creation, Subassembly Work Order Creation, Work Order Release to shop floor, Work Order Update and Work Order Cancellation.
• Involved in design and setup of Finished Goods Work Order Creation, Subassembly Work Order Creation, Work Order Release to shop floor, Work Order Update and Work Order Cancellation.
• Involved in design and setup of Finished Goods Work Order Creation, Subassembly Work Order Creation, Work Order Release to shop floor, Work Order Update and Work Order Cancellation.
• Involved in the design of the Rework/Repair Work and Tie-Plate Work Orders .
• Design of the Make to Stock and Assemble to Order Models for the business.
• Involved in the design of BOM's in Oracle for the new products which are designed and approved in the external system E-Matrix.
• Setups related to the BOM's, routings, departments, operations and resources.
• Extensive work done on Outbound Interfaces from Proficy to Oracle for the BOM Creation, updates and Routing Data.

Confidential

Environment: Service line

SCM Consultant

Responsibilities:

• Analyzed the business requirements and provided the fit GAP analysis
• Prepared As-Is To-Be process flows documentation using AIM Methodology.
• Involved in creation of a Buyer Report, which sends all necessary information to the Buyer as per the requirement.
• Interfaces related to procurement of indirect materials and their interaction with various other legacy systems.
• Involved in enhancements and testing of custom programs for Item Inbound and Outbound interfaces.
• Implemented approved supplier list and defined item -supplier relationship which helped in defaulting supplier information on procurement documents there by reducing manual entry and errors during document creation.
• Implemented auto sourcing rules which reduced the purchasing cycle time as well as prevent purchases from debarred suppliers.
• Provided a solution to use supplier item catalog which helped the buyer in locating items and accurate pricing of items at the time purchase document creations.
• Defined customized Item templates to default set of attributes values based on item type.
• Prepared MD50 and MD70 documents.
• Conducted CRP, SIT and UAT testing.

Confidential

Environment: Service Parts (Discrete Manufacturing)

Oracle applications Distributions Consultant

Responsibilities:

• Worked on the Enhancement for the existing Purchase order Approval workflow to include the Project manager and Finance groups based on the PO total.
• Worked on requirement and testing of the custom reports
• Worked on Form personalization to the Purchase order and Requisition forms.
• Worked on the data conversion of suppliers and PO’s from the legacy application to Oracle.
• Enabled partial order fulfillment through Split lines feature. This was done by splitting single Delivery into multiple lines, thereby shipping the order partially.
• Created new shipping roles and grants based on user privileges to perform shipping transactions.
• Created new qualifiers and groups for item and customer based price based on the requirement from business.
• Conducted application regression testing after the application of patches.

Confidential

Environment: Packaging Industry (Discrete Manufacturing)

Oracle applications Distributions Consultant

Responsibilities:

• Handling issues through online tickets and resolution as per SLA
• New patch releases introduced in context with business process
• Gather Requirements for new enhancement.
• Test case Preparation and Testing
• User and documentation
• Handled issues related to creation of INPROCESS Purchase Orders and Purchase Order Requisitions and Blanket Purchase Agreement.
• Handled issues related to Receiving and account generator.
• Involved in creation of test scripts and testing of DR sanity.
• Handled issues related to Backorder shipment and customer inspection of packing prior to shipment.
• Interfacing with inventory and Receivables for Transactions.
• Handled issues related to workflow errors.
• Issues resolution related to closure of WIP jobs during the period close
• Issues related to the interfaces for WIP jobs
• Handled issues related to pending transactions material transactions.
• Handled issues related to Item Supply/demand, Reservations, Transactions open interface.
• Handled issues related to closing periods for all the modules, pending inventory transaction.