SUMMARY:

• 9 plus years’ experience in production planning, materials management, IT, Systems Integration and Project Management with Oracle ERP. Well versed with entire implementation life cycle of the project - analysis, design, configuration, development, post implementation and support.
• Good understanding of the Oracle Version 12 E-Business and MOAC concepts. Completed the internal for Version 12.
• Excellent functional experience and understanding of the business practices in planning, procurement, manufacturing, distribution and logistics areas.
• Extensive experience with configuring and customizing all the SCM application modules for both implementation and version upgrade projects.
• Thorough knowledge of Software Development Life Cycle phases right from project definition through post-deployment.
• Experience with all phases of testing life cycle - CRP, SIT and UAT.
• Good communication skills and a team player open to learning new technologies.

TECHNICAL SKILLS:

ERP: Oracle R12, 11i. Manufacturing and Supply Chain modules: Inventory, BOM, MRP, Order Management, AR, WIP, Shipping Execution, Pricing, Sourcing, Purchasing, iProcurement, AP, Service Contracts, Install Base and Costing modules. Oracle APS Suite: ASCP and GOP.

Languages: PL/SQL, SQL*Plus

Tools: Forms 6i, Reports 6i, SQL*Loader, TOAD, Discoverer 4i, Oracle BI Publisher, MS Project, MS Visio, MS Office

RDBMS: Oracle 8i, Oracle 9i

Operating Systems: SUN OS2.6, UNIX, Windows 95/NT/2000/XP

WORK EXPERIENCE:

Oracle ASCP SME

Confidential

Responsibilities:

• Working as the SME for ASCP module.
• Gathering requirements to bring Telamon from their legacy system to Oracle ASCP.
• Configuring the ASCP module in a centralized environment
• Setup the instance, partitions, plan options, etc. for constrained planning.
• Setup the forecast for buy items as well as the sourcing rules and sourcing assignments.
• Setup the resources and departments with capacities.
• Setup the transit times and used the ATP functionality to schedule sales orders.
• Setup the IR/ISO flow to be initiated from ASCP between Telamon warehouses.
• Implemented the ECO Use up functionality from ASCP.
• Working with the business team to simulate what-if scenarios.
• the users on how to release the planned orders from planner’s workbench, understand the exception messages, analyze the horizontal and vertical plans, etc.
• Preparing documents and test scripts.

Tools: Used: Oracle R12 ASCP, Order Management, Purchasing, Inventory, Bills of Material, Work in Process, Toad, SQLPlus and AIM documentation.

Oracle SCM BSA

Confidential

Responsibilities:

• Working as the support analyst for the INV, OM and QP modules.
• Supporting and troubleshooting issues with custom programs for all the EDI transactions - order import (850), shipping request to 3PL warehouses (940), ship confirmation from 3PL (945) and customer invoicing (810).
• Setup IR-ISO flows between different Topps warehouses. Setup OM defaulting rules, processing constraints, order types, document sequences, etc.
• Setup intercompany shipping process flow between the US and Argentina operating units.
• Setup price lists to support the intercompany process flows at transfer price using pricing formulas and custom pricing attributes.
• Modified the SLA rules to change the cogs and sales accounts for transactions to Latin American customers based on the territory setup.
• Assist the users with OBIA reporting requirements for OM and INV on a need by basis.
• Prepare test scripts and user documents for various test cycles.

Tools: Used: Oracle R12 Inventory, Order Management, Shipping, Advanced Pricing, Purchasing, ASCP, EDI, Toad, SQLPlus and AIM documentation.

Oracle ASCP Lead

Confidential

Responsibilities:

• Worked as the lead for ASCP module.
• Configured the ASCP module in a centralized installation environment
• Setup the instance, partitions, plan options, etc. for unconstrained planning.
• Setup the forecast for buy items as well as the sourcing rules.
• Setup the transit times and used the ATP functionality to schedule sales orders.
• Setup the IR/ISO flow between Kravet warehouses.
• Involved in testing the release of requisitions from ASCP.
• Prepared documents.

Tools: Used: Oracle R12 ASCP, Order Management, Toad, SQLPlus and AIM documentation.

Oracle ASCP Lead

Confidential

Responsibilities:

• Configured the ASCP module as per the business requirements.
• Setup the instance, partitions, plan options, etc. for unconstrained planning.
• Setup the sourcing rules and assignment sets for buy items.
• Setup the IR/ISO flow between CPP warehouses.
• Involved in testing the release of purchase requisitions and discrete work orders from ASCP.
• Prepared documents and test scripts.

Tools: Used: Oracle R12 ASCP, Purchasing, Order Management, Shop Floor Management, Toad, SQLPlus and AIM documentation.

Oracle Supply Chain SME

Confidential

Responsibilities:

• Worked as the SME for Inventory and Costing modules.
• Configured the INV and CST modules as per the business requirements
• Setup FIFO inventory organizations to facilitate layer costing for Landed Cost Management enabled organizations.
• Setup items (with dual units of measure), item categories, flexfields, etc.
• Setup the IR/ISO flow for managing shipments between C&S warehouses.
• Working on the functional solution documents for building interfaces between the Warehouse Management systems and Oracle.
• Closely interacting with the technical team in building various interfaces from and to Oracle
• PO receipts interface from WMS to Oracle for LCM enabled organizations with both LCM as service and pre-receiving organizations.
• IR’s interface from Oracle to WMS
• Inventory adjustments interface from WMS.
• Prepared test scripts and user documents for CRP.

Tools: Used: Oracle R12 Inventory, Costing, Landed Cost Management, Purchasing, Toad, SQLPlus and AIM documentation.

Oracle Supply Chain SME

Confidential

Responsibilities:

• Configured the INV, OM, QP and PO modules as per the business requirements.
• Setup price breaks, qualifiers and modifiers based on the business inputs in Advanced Pricing.
• Setup the transit time matrix with different freight carriers and customer specific shipping calendars for order scheduling purposes.
• Setup OM defaulting rules, order types, document sequences, etc.
• Setup the IR/ISO flow for managing shipments between Koyo warehouses from ASCP.
• Worked with the EDI team to create sales order releases against blanket sales agreements using Release Management.
• Prepare test scripts and user documents for various test cycles.

Tools: Used: Oracle R12 Inventory, Order Management, Shipping, Advanced Pricing, Purchasing, ASCP, GOP, Release Management, EDI, Toad, SQLPlus and AIM documentation.

Oracle Techno-Functional Consultant

Confidential

Responsibilities:

• Worked as the solution architect for creating central and regional distribution centers operated by a third party logistics provider.
• Configured the INV, OM, QP and PO modules as per the requirements.
• Worked on the functional design documents for all the interfaces between Oracle and Manhattan WMS used by the 3PL provider. Guided the technical team in developing the interfaces for receiving and shipping functions.
• Configured the ASCP module to generate replenishment requisitions for the new DC’s.
• Setup the drop ship process for EDI vendors.
• Imported the vendor ASN’s into Oracle to automatically close the PO’s and the corresponding drop ship sales orders.
• Prepared test scripts and user documents for various test cycles.

Tools: Used: Oracle 11.5.10.2 Inventory, Order Management, Shipping, Advanced Pricing, Purchasing, R12 ASCP, EDI, Toad, SQLPlus and AIM documentation.

Oracle Functional BSA

Confidential

Responsibilities:

• Worked with the implementation team to roll out the Oracle 12.1 version to Latin America, Russia and South Africa OU’s.
• Set up order types, credit check rule, order holds, etc. as per the requirements. Set up the pick release rules, shipping parameters and shipping networks.
• Set up new qualifier and pricing contexts as per the design and worked with the development team to define the custom packages required to fetch the price. Set up customer specific pricing modifiers based on tiers and pricing groups.
• Set up intercompany flows between the existing warehouses and the organizations under the new operating units.
• Supported the existing Oracle 12.1 instance for the INV, OM, AR, PO and Advanced Pricing modules for US, CA and EMEA operating units.
• Assist the finance and supply chain teams with period end activities on an on-going basis.
• Prepare test scripts and user documents.

Tools: Used: Oracle R12 Inventory, Order Management, Shipping, Advance Pricing, Accounts Receivables, Purchasing, Toad, SQLPlus and AIM documentation.

Oracle Functional Analyst

Confidential

Responsibilities:

• Gathered the requirements for customer specific pricing initiative.
• Set up new qualifier and pricing contexts as per the design and worked with the development team to define the custom packages required to fetch the price.
• Set up secondary price lists and modifiers as required on an ad-hoc basis.
• For Service pricing, wrote the functional specification document to build a .jsp interface for the users. Worked with the development team to design the backend for the same.
• Was part of the design for setting up intercompany material flow between regional warehouses and several small organizations servicing a specific area.
• Supporting the existing Oracle 11i instance for the INV, OM, AR, Service Contracts and Install Base modules.
• Resolved helpdesk tickets.
• Involved with period end activities on an on-going basis.
• Worked on the test scripts and prepared user guides for the end users.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping, Advance Pricing, Accounts Receivables, Service Contracts, Install Base, Toad, SQLPlus and AIM documentation.

Oracle Techno-Functional Lead

Confidential

Responsibilities:

• Led the Operations modules implementation for another legacy business to come on to the existing Oracle instance. Complete ownership of the Order-to-Cash, Procure-to-Pay cycles and Build to Forecast cycles.
• Set up the INV, OM, PO, BOM, WIP and MRP modules as per the requirements.
• Setup the coverage types, billing types, global contract defaults, flexfields, etc.
• Assisted with setup of the AR transaction types related to OKS. Mapped the billing types with the appropriate OM order and line types.
• Worked on the Configurator data migration between the new business and the existing Oracle instances.
• Set up the Sourcing rules and assignments for automatically releasing purchase requisitions from MRP.
• Setup the PO approval position based hierarchy for both direct and indirect purchases.
• Designed the intercompany flows between all the business entities from the new business and the existing entities. Worked on the intercompany AP and AR invoicing.
• Worked along with the technical team on the Direct Order Fulfillment process with the contract manufacturers by designing EDI interfaces for outbound PO (850) and PO changes (860).
• Supported the existing Oracle 11.5.10.2 instance for the INV, OM, BOM, WIP, MRP, PO, AR, Service Contracts and Install Base modules.
• Resolved helpdesk tickets.
• Modified existing reports.
• Supported month end and year end activities.
• Involved in identifying and resolving the physical counting issues.

Tools Used: Oracle 11i MRP, Inventory, Order Management, Shipping, Advance Pricing, Purchasing, EDI, BOM, WIP, Accounts Receivables, Accounts Payables, Service Contracts, Install Base, Toad, SQLPlus, Report Builder and AIM documentation.

Functional Lead

Confidential

Responsibilities:

• Led the implementation team of 7 in designing the planning solution for the Meters and Transformers product lines across the US pole. Working closely with the business to understand the legacy system and capture the requirements to design in Oracle.
• Set up the inventory module to store the parts data, perform cycle counts and order management modules to process the order fulfillment requests.
• Coordinated with the Configuration team to integrate with the order entry system depending upon the customer requirements.
• Set up the BOM and WIP modules for all the work orders generated from the customer orders.
• Coordinated with the Purchasing team to create internal requisitions and drop ship purchase orders.
• Worked on the setup and conversion for ASL, Sourcing Rules and sourcing assignments.
• Worked closely with the warehousing team to implement MSCA for receiving, picking and shipping functions.
• Preparing end user documents and was involved in the super users.

Tools Used: Oracle 11i ASCP/MRP, Inventory, Order Management, GOP, Shipping, Advance Pricing, Sourcing, Purchasing, EDI, Toad, SQLPlus and AIM documentation.

Implementation Lead

Confidential

Responsibilities:

• Led a team of 5 that implemented Oracle Field Services across the US, CA and European poles with the main focus on the integrations between Oracle Field Services, Spares Management and the existing ERP modules like Inventory, Purchasing, Order Management and Pricing.
• Set up the inventory and order management modules to integrate with the data coming from Spares and Field Services as per the business requirements gathered.
• Setup the Service Contracts module for warranty contracts originating from Order Management. Performed all the related setups for integration between OM and OKS.
• Designed and set up the Spares Management module to create an Internal Requisition every time there is a material requirement on the Service Requests in the Field Services.
• Worked closely with the mobile field services implementation for multiple GE wind parks as part of the go-live.
• Worked with the wind park technicians and helped them to access mobile field services from the Motorola MC75 handheld devices.
• Prepared end user documents and was involved in the super users.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping, Pricing, Purchasing, Service Contracts, Install Base, Field Services, Spares Management, Toad, SQLPlus and AIM documentation.

Functional SME

Confidential

Responsibilities:

• Was involved in weeklong preparation of an Oracle ERP solution to a RFP floated by GE Solar Energy for their business process.
• Led a team of 5 people to develop a Visio flow chart highlighting the Oracle modules that match the business processes depicted in the RFP.
• Presented the proposed solution to the GE Solar team.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping, Project Manufacturing, MS Visio and MS PowerPoint.

Advanced Pricing

Confidential

Responsibilities:

• Was involved in weeklong hands on with the end users in Cummins UK.
• Trained them on the basics in Advanced Pricing, creating Price Lists, Qualifiers, Modifiers, Manual discounts, Attributes, Attribute Mapping, etc.
• Created sales orders in Order Management to see how the pricing entities setup affected the price on the orders.
• Created Freight modifiers and showed the user group how they get applied on the sales orders at the time of shipping.
• Prepared guide for the users to follow during the sessions.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping, Advanced Pricing, Toad and SQLPlus.

Functional SME

Confidential

Responsibilities:

• Phase 1 for this assignment involves the Legal Entity change as mandated by the GE legal and tax requirements to realize potential tax benefits.
• Created a new DFF at the organization parameters level to bypass the standard valuation accounts. Updated all the accounting to in corporate the new LE in the purchasing, receiving, supplier, payables and shipping networks setups.
• Issuing out all the on-hand inventory using API’s, changing the accounting and bringing the material back in using API’s.
• Modifying the PO and Requisition account generator workflow to pull the charge, accrual and variance accounts on the PO from the newly created DFF instead of off the standard valuation accounts.
• Modifying the accounting on the requisitions created via requisition import program from ASCP by deploying a DB trigger.
• Phase 2 for this assignment involved defining intercompany relations among all the existing operating units (Germany, Spain, US and CA) two ways (both buy and sell).
• Created a new operating unit, which will process sales orders for two customer facing Legal Entities, that do not hold any inventory. (Drop shipping from another legal entity that carries inventory)
• Defined the intercompany flows between all the OU’s for drop shipping and physical shipping scenarios.
• Created the internal customers as required to start the intercompany transactions with the creation of an Internal Requisition and Internal Sales Order.
• Set up the intercompany price lists, order types, modifiers and built a custom program to maintain the price lists.
• Set up the customers, customer sites, transaction types, tax codes, autoinvoice and autoaccounting rules in AR to generate the intercompany AR invoices.
• Set up the suppliers, supplier sites, payment terms and tax codes to generate the intercompany AP invoices.
• Customized the AR autoinvoice interface and AP expense report interface to create the invoice with the correct customer/supplier in the case of one OU sharing two customer facing legal entities to create sales orders.
• Integrated the Oracle system to IBS (Internal Billing System) for automatic settlement of the Intercompany Due From and Due To invoices. Involved in building 5 interfaces (3 outbound and 2 inbound) between IBS and Oracle.
• Setting up the ASCP instance to create internal requisitions for replenishing the Canadian warehouse from US warehouse.
• Involved with the user and prepared the test scripts for major testing milestones.
• Participated in testing the intercompany design from end to end. Prepared the manuals for the end users to assist in performing intercompany transactions.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping Execution, ASCP, Pricing, Purchasing, Accounts Payables, Accounts Receivables, Toad, SQLPlus and AIM documentation.

Senior Consultant

Confidential

Responsibilities:

• Worked as senior consultant for implementing the INV, BOM and WIP modules in a discrete manufacturing environment.
• Designed the Inventory organization as per the requirements gathered.
• Involved in setting up the BOM and WIP modules as per the requirements.
• Completed the OSP setup for WIP and Purchasing in a job-based hierarchy.
• Loading the items, bills, prices and routings for this new organization.
• Set up freight carriers, order types and pick release rules. Created a couple of custom defaulting rules as per the business requirements.
• Set up the RMA workflow for both the Credit and Repair / Replace scenarios.
• Performed the end-to-end testing for the manufacturing and distribution modules. And preparing the manuals for the end users.

Tools: Used: Oracle 11i Inventory, BOM, WIP, OM, Shipping, AR, Purchasing, Toad, sqlldr, SQLPlus and AIM documentation.

Project Lead

Confidential

Responsibilities:

• Worked as Project Lead for implementing the OM, ASCP, QP and MSCA modules.
• Implemented the MSCA handheld enabled label printing procedure for receiving and picking business processes.
• Involved in the requirements gathering, business process designs and conference room pilot discussions. Worked on the fit-gap analysis.
• Setup the IR-ISO flow between GE warehouses.
• Involved in the items, customers and price list conversions.
• Worked on the Consigned Inventory setup.
• Worked with the technical team to develop the custom interface for integrating the Oracle Field Sales (CRM) application and the Order Management implementation.
• Prepared the manuals for the end users.
• Supported the business users and resolved issues pertaining to all the SCM and Distribution modules after go-live.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping Execution, Pricing, MSCA, Accounts Receivables, ASCP, Toad, sqlldr, SQLPlus and AIM documentation.

Senior Consultant

Confidential

Responsibilities:

• Worked with Order Management, Pricing modules and assisted in developing the test scripts for a client, which is in the semi-conductors manufacturing business during the CRP2 phase.
• Worked with the implementation team on the Order Management and Shipping Execution modules for a metals company. Was involved in the requirements gathering sessions and developing the As-Is and the To-Be process flows.
• Worked on the Advanced Pricing implementation for a software solutions provider company with a highly complex pricing and item structures. This pricing solution involved capturing the pricing attributes in the Configurator as there were a lot of different variables per item.
• Was involved with Demantra software, a product used for Demand Planning, in week long . Worked on developing test models in Demantra and prepared end user documentation.

Tools: Used: Oracle 11i Inventory, Order Management, Acoounts Receivables, Shipping Execution, Advanced Pricing, Configurator, Demantra, SQLPlus, Toad and AIM documentation.

Oracle Functional Consultant

Confidential

Responsibilities:

• Worked as the contact point for Production support for the OM, Pricing, Inventory and Shipping Execution modules.
• Developed and tested Logical Apps rules to restrict the user access to certain Inventory module forms as demanded by the business.
• Was part of the upgrade team working on upgrading the 11.5.8 version to 11.5.10.
• Prepared the end user documentation for the OM module.

Tools: Used: Oracle 11i Inventory, Order Management, Shipping Execution, Advanced Pricing, Logical Apps, Toad and AIM documentation.

Oracle Functional Consultant

Confidential

Responsibilities:

• Led the Oracle WMS implementation effort, worked on the proof of concept and feasibility. Demonstrated the out-of-the-box Oracle setups for a WMS Org to the business, including, but not limited to LPN, Put Away, Pick Confirm, Ship Confirm and barcode label printing using the MSCA scanners.
• Implemented MSCA at 3 Confidential distribution centers in the US pole, for all receiving and shipping functions.
• Worked on the interface design for integration between Oracle and 3rd party shipping application Clippership. Setup shipping label printing and other documents printing out of Clippership after the delivery is confirmed.
• Customized the standard PO approval workflow for all the OU’s by capturing the business requirements, which involved bypassing the double approvals involved.
• Was involved with migrating inventory from one inventory organization to another. Developed the Item Upload tool used to mass load new items and/or update the existing items.
• Set the auto replenishment up for the purchased raw material parts to be replenished by the supplier based on the min max levels in the inventory. Set up the ASL and a blanket purchase order to receive the product in. Developed a report on the same lines as the Requisition import exceptions report to show the items that failed the Requisition import process.
• Setup the Internal Orders process between the Distribution center and the various manufacturing sites based on the min max levels of the inventory in the DC.
• Worked on the Consigned Inventory implementation.
• Worked on several reports and enhancements from the functional perspective involving requirements gathering, user testing & and seeing them migrate through to the Production environment.
• Worked on developing the forecast upload tool to facilitate loading the forecasts via the open forecast interface.
• Supported the physical inventory activities, updating standard costs and monthly closing activities.
• Involved with resolving helpdesk tickets on a daily basis.
• Involved with functional post cloning operations.

Tools: Used: Oracle 11i Inventory, BOM, Purchasing, Engineering, Order Management, Shipping Execution, MSCA, Advanced Pricing, MRP, Costing, Accounts Receivables, Accounts Payables, iProcurement modules, Clippership, SQLPlus, sqlldr, Toad and AIM documentation.

Oracle Functional Associate Consultant

Confidential

Responsibilities:

• Responsible for the implementation of the Inventory, BOM and WIP modules.
• Studied the company’s business process and conducted the fit - gap analysis with respect to the Oracle 11i modules.
• Setting up the required flexfields according to the business requirements.
• Validated the set ups and conducted the Conference Room Pilot’s with the client.
• Coordinated with Oracle support to resolve application issues.
• Educated the user on the application.

Tools: Used: Oracle 11i Inventory, BOM, WIP modules in Discrete Manufacturing and AIM documentation.