Project Oracle

VEERA SARAVANAN

Oracle EBS Techno-Functional Consultant

Professional Summary

• Over 8 Years of Experience in Oracle EBS Application (R12 & 11i)

• Specialized in Business Analysis, End to End solution design and configuration of new business

models.

• Expertise in Interface design and development, Production Support, Functional Testing and User

trainings in a complex Multi-Org Environment.

• Having a sound functional skill in Oracle Inventory (INV), Purchasing (PO), Order Management

(OM) and Bill of Materials (BOM).

• Having a sound knowledge on Financial Modules Account Receivables (AR) and Account

Payables (AP)

• Excellent Hands on Experience on the End to end Life Cycles of Demand to Deliver (DTD),

Deliver to Cash (DTC) and Procure to Pay(PTP)

• Sound Experience in the Implementation and configuration of various Business Processes.

• Good Knowledge in configurations of Direct Shipment process, Drop Ship Process, Back to Back

Process, Inter Company and Inter Org Shipments with Functional setups.

• Expertise in trouble shooting and resolving critical Production issues.

• Well experienced in end to end user testing and Integrated Testing.

• Well trained in identifying the configuration missed and defects on the Production Changes

• Good knowledge in R12 PLSQL coding.

• Expertise in modifying work flows and building oracle Forms.

• Involved in the Month end process with Period Closure and posting Finance Transactions in to

GL.

• Expertise in Fixing and clearing stuck transactions on all R12 Interface tables.

• Having sound skill on Defining responsibilities, Users, Forms, Menus and Functions, Defining

concurrent Program, Oracle Alerts.

Certification: APICS Oracle CPIM Certified

Skills :

Programming PL/SQL, UNIX Basics

Languages:

Databases : ORACLE 9i/10g/11g

ERP: Oracle EBS Supply Chain Modules – OM, PO, INV, BOM.

Oracle Financials - AP and AR.

Terminal Emulation: Putty, Telnet, Winscp

Tools & Utilities: Oracle Workflow Builder, SQL* Loader, Toad, Oracle Forms Builder, XML

Publisher and Report.

Version Control: Kintana and Clear case

Detailed Project Experience:

Project#1: Business Transformation to R12 and Concurrent Manger Optimization (Jan 2013 – Till date)

Role: Business System Analyst

Modules involved: OM, INV and PO

Environment: Oracle Application E Business Suite R12.

Description: Business Transformation to Oracle R12.

The Existing customization and the business Processes of the legacy systems were converted and

designed to fit in the Oracle R12 standard Functionality. New Interfaces were developed with the Third

party shipping system.

Contributions:

• Worked as a Business System Analyst for configuring the new Back to back Order Flow with the

ODM Suppliers.

• Collected the business requirement and developed the Customer Requirement and Functional

design documents.

• Implemented Direct Shipment Process from Asia to NA with the Intercompany configuration.

• Developed custom interfaces with the External Shipping Interfaces and other legacy systems.

• Designed and Developed standard PIP 2A1, 3A13, 4B2, 7B5 with the shipment system to send

the item, Purchase Orders, Inventory Transactions and the Discrete job details.

• Performed UAT testing along with the Business users and captured the defects and requirement

misses.

Project#2: R12 VMI (Vendor Managed Inventory) Implementation (Mar 2012 – Dec 2012)

Role: Technical Analyst

Modules Involved: OM, PO, INV, Sourcing, iprocurement, isupplier

Environment: Oracle Application E Business Suite R12.

Description: Customer Requested to ship the material to two different Locations, from where they will

consume it whenever required and we invoice the customer only after the Consumption and also pay the

Supplier once it is consumed.

Contributions:

• Worked as a Technical analyst in designing the Business Flow.

• Implemented the iprocurement and isupplier portals for the customers.

• Implemented the IR and ISO Process to ship the material from the Supplier to the Customer

Location by creating the internal location in R12

• Implemented Back to Back (SO-PO) solution with the BPA, ASL and Sourcing Rule

Configurations

• Automated the consumption advice Process to create a AP invoice for the supplier.

• Enabled Billing Order Process to Invoice the End Customer when the consumption is processed.

Project#3: Oracle R12 - Third Party integration Implementation (Feb 2011 – Feb 2012)

Role: Technical Analyst

Modules Involved: AR, AP, OM, INV.

Environment: Oracle Application E Business Suite R12.

Description: 4D1 – Notify Material Release, 4B2 – Notify Shipment Receipt, 4B3 – Notify consumption

signals were implemented with the customer through the Web methods Integration and processed the data

in R12.

Contributions:

• Worked as a Technical Analyst in getting the Requirement from the End customer and converts

them in to a Technical Design.

• Created a staging table to process and load the 4D1 data from the customer and created the

Internal Requisition and a Sales order to Shipped from Internal Shipping location.

• Developed a Concurrent program to process the sales Order data and integrate them to the

Shipping system.

• Developed a custom Program to process the 4B2 data and load them in to material transactions to

move the material to the Shipping Sub inventory.

• Developed a Billing Order creation Process program to process the 4B3 consumption signal from

the customer.

Project#4: Pre-Billing Contingency Implementation for Canada Customers (Apr 2010 – Jan 2011)

Role: Functional Consultant

Modules Involved: AR, OM, INV.

Environment: Oracle Application E Business Suite R12.

Description: Implementation of Revenue management Pre-Billing Contingency for the Canada Customer

with the COGS generation once the Order was shipped and AR invoice generation after the confirmation

of POD – Proof of Delivery.

Contributions:

• Worked as a Functional consultant in designing the Process with the Customers.

• Created the Functional Design Document.

• Collected the Customer and item details and created a contingency Rule in Revenue management.

• Designed a form to enter the POD information and release the Hold to Process the AR Invoice

Process.

Project#5: L2 and L3 Production Support and Bug Fixes (Jan 2009 – Mar 2010)

Role: Technical Analyst.

Modules involved: OM, INV, BOM and PO

Environment: Oracle Application E Business Suite R12.

Description: To Support and Fix the day to day business critical issue by providing a work around and a

permanent solution by doing code change if required.

Contributions:

• Trouble shooting and Fixing the Business Critical issue to support their day to day Business.

• Implemented L3 fixes and moved the changes in to Production System.

• Root caused the repeated issues and provided permanent solution.

• Provided Work around for the issues that needs code changes and business Process changes.

• Worked with Oracle and implemented the Oracle patches to fix some the defects.

• Created end to end training document and also trained the Business users to follow the Process.

Project#6: Direct Shipment Project from NA ERP to ASIA ERP (Jun 2007 – Nov 2008)

Role: Technical Leader

Modules Involved: OM, Shipping, Inventory and AR

Environment: Oracle Application E Business Suit R12.

Description: To process the orders booked in NA ERP and load the order in to Asia ERP system. The

Orders will be shipped from Asia ERP to the customer directly and the Shipment transactions will flow

from Asia to NA ERP. An Intercompany transaction will be created between NA and Asia for the

financial transactions and the customer invoice will be generated in North America ERP.

Contributions:

• Worked as Techno Functional Consultant by collecting the requirement from business

• Created the Functional Design Document.

• Configured the Intercompany setups in R12 for Asia and EMEA.

• Designed the Shipping process in NA ERP with the customization to satisfy the Business

requirement by having custom tables and Separate Pick release rules.

• Designed the Commercial Invoice Document for the International shipments.

Project#7: Retail Products Migration Project through EDI (Nov 2006 – Apr 2007)

Role: Test Lead

EDIs Involved: EDI 850, EDI 855, EDI 810.

Environment: Oracle Application E Business Suit 11i.

Description: The Customer Purchase Orders will be processed through the EDI Interface through web

methods integration and loaded in to ERP with the Order details. With the Customer Program the PO

details were validated and the Order were loaded in to ERP through the Order Import process.

Contribution:

• Worked as a Test Lead and built the Test cased documents for the Business scenario and the

requirement.

• Each and every step was tested and identified the critical Defects.

• All EDI Process were tested End to End.

• Involved in the Configurations setups for the EDI mapping.

Project#8: Managed services R12 L3 Fixes and Implementing. (Dec 2005 - Oct 2006)

Role: PLSQL Developer

Scope of the Project: Form Personalization, Creating new Security Rules, Defaulting Rules, Work Flow

Customizations and Bug Fixing.

Environment: Oracle Application E Business Suit R12.

Description: New small Business requirements were addressed through the L3 Project and several other

form personalizations were done on the Order Entry form and Transportation form. Several security rules

were built to stop creating PO from the sales Order, cancelations of order line and several others.

The OM Order line work flow was modified by adding new Process to do additional validations and

check if we have all the setups before the Order line is progressed.

Contributions:

• Developed and made several form personalizations on the Oracle standard Forms.

• Developed Custom interfaces between R12 and to the downstream systems.

• Customized the standard OM Order line work flow.

Contact this candidate