Oracle Service

PROFESSIONAL SUMMARY

. Over * years of Techno-Functional experience in Oracle Applications

11i projects with implementation and customization experience in

Finance, Distribution, Manufacturing and CRM Modules.

. Expertise in developing and customizing Reports, Interfaces, Forms,

XML Publisher reports, Data Conversions, Extensions and Oracle APIs.

. Completed the Oracle Forms Developer Certified Professional

Examination (OCP).

. Strong analytical, communication and troubleshooting skills with

ability to work in a dynamic, team oriented environment.

TECHNICAL SKILLS

ERP : Oracle Apps 11i (AP, AR, OM, INV, PO, AOL, OKS,

GL)

Programming Languages : PL/SQL, Shell Script, Java, C, C++

Operating Systems : WINDOWS XP/NT/2000/98/95, UNIX, LINUX

Database : Oracle 9i/10g

Tools : Reports 6i, Oracle Work Flow Builder 2.6, Discoverer 4i,

Forms 6i, SQL Loader, TOAD, SQL Optimizer, PL/SQL

Developer, Data Loader

EDUCATION

. Bachelor of Technology: Andhra University College of Engineering,

India

WORK EXPERIENCE

Xerox DMO Chestnut Wave 3 Release 1 - Mexico

Apr 2008 - Present

Working from Xerox Corporation, Webster, USA

Oracle Apps Techno-Functional Consultant

Wave 3 of the DMO ERP program includes the implementation of Oracle 11.5.10

Install Base, Service Contracts, Field Service, Oracle Quoting and

Inventory modules and uploading the data to Accounts Recevables.

Responsibilities:

. Designed Solution Design Documents for following processes :

- Automatic Contract Creation Process from Order Management

- Web Based Meter Reading - Oracle Customization.

- Billing Calculation Process Customization

- Item Load Process

. Developed the complete automatic contract creation process from Order

Management using APIs.

. Creation of automatic service requests for the equipments that require

installations.

. Developed the components for Install Base Initial Load.

. Developed a reusable set of components that will enable the users to

select the file names in server as an LOV in Oracle Application

. Developed a customization that involves the billing of the usages

lines of the contract

. Developed a web based interface for the third party organization such

that the counter values for the equipments are entered by the third

party organization in the web pages and an interface is developed such

that those values are reflected in the corresponding Service Contracts

in Oracle Apps.

. Developed an interface program that loads all the Equipments and

Accessory Items for Xerox Mexico.

. Developed a Meter Reading Card Report that is the basis for the third

party organization in entering the equipment counter readings.

. Developed a customization that involves in Credit Hold validations and

Service Suspensions.

. Developed the Order Management Peer Form that is the basis for

automatic contract creation and also for the billing calculation.

. Responsible for reviewing and approving the solution design documents

and Technical Design Documents.

Environment: Oracle 11.5.10+, Service Contracts, Install Base, Service

Requests, Inventory, Order Management, Accounts Receivables.

Xerox DMO Chestnut Wave2 Release 2 - Brazil

Mar 2007 - Apr 2008

Worked from Tata Consultancy Services Ltd, India

Oracle Apps Techno - Functional Consultant

The Wave 2 of the DMO ERP Project includes the implementation of Oracle

11.5.9 Accounts Receivables (AR), Advanced Collection (IEX), Integrated

Receiving (RI), Purchase Order (PO), Order Management (OM) and Inventory

(INV) modules.

Responsibilities:

. Involved in the solution design documents for the following processes

1. XBRA NTFISCAL Print Program

2. Oracle Customization - Collection Document - Invoices Treatment

3. Oracle Extract - Extract Interface with orders to WIS (Legacy)

. Responsible for setting up meetings with the onsite team and gathering

the requirements

. Developed an interface that will send all the sales orders to Legacy

to determine the exact route for the shipment and subsequently process

the shipping process after getting confirmation from the legacy.

. Developed Automated PO creation process based on Invoice and Receips

Matching

. Developed a collection document report where the Xerox is responsible

to send those documents to the customer in a specified manner.

. Developed data ware house extracts where the Accounts Receivable and

Accounts Collections information is send to Legacy.

. Responsible for unit testing for the components developed

. Responsible for tracking of defect logs and also approval of Technical

Design Documents

. Developed Price list load interface

. Developed a report that will track all the Invoices that are erroring

out while creation of invoices

Environment: Oracle 11.5.9, OM, WMS, PO, AR and INV.

Xerox DMO Chestnut Wave 2, Release 2 - Mexico Jan 2006 -

Mar 2007

Worked from Tata Consultancy Service Ltd, India

Oracle Apps Techno - Functional Consultant

As part of DMO Chestnut Wave 2 implementation, XMEX requires the Payables

Open Interface Import for Production Purchases placed on the DMO

Organization DMO provides the Standard Oracle DSNO output (departure

shipping notice outbound) to their value chain partners with shipment and

invoice information.

Responsibilities:

. Responsible for the development of Interface that will create Invoices

based on Three way Matching.

. Responsible for customization of Standard Payables Open Interface

Import Program such that Pre Payments are loaded into the system

through Payables Open Import Program. The Standard Payables Open

Interface Import program will not support loading prepayments into the

system.

. Involved in Integration testing for the components developed.

. Responsible for creation of Solution design documents and Technical

design process for the above interface.

Environment: Oracle 11.5.9, PO, AP.

Xerox DMO Chestnut Wave 1, Release 1 - Brazil

Dec 2004 - Jan 2006

Worked from Tata Consultancy Service Ltd, India

Oracle Apps Technical Consultant

The Wave 1 of the DMO ERP Project includes the implementation of Oracle

11.5.9 General Ledger (GL), Accounts Payable (AP), Purchasing (PO) and

Integrated Receiving (RI) modules in XBRA

Responsibilities:

0. Responsible for developing the Interface that will Load all the

Employees, their setup as Vendors and their Corresponding Bank

Accounts - All of the loads in a single Interface.

1. Designed and developed an interface where the Bank Payment File is

transferred securely between the Oracle Applications and the Banks

Server.

2. Developed a conversion process that involves in converting the Legacy

GL Code Combinations to new set of Code Combinations.

Environment: Oracle Applications 11.5.9, GL, AP,. RI, PO, HRMS

Xerox Supplies Release 5.8 - USA May 2004 - Dec

2004

Worked from Tata Consultancy Service Ltd, India

Oracle Apps Technical Consultant

A Large Portion of Xerox Business is done in the area of Supplies which

would include paper, toner etc. Xerox is going to replace all the legacy

systems and the process flow of this project involves the end customer

placing the order with Xerox and in turn places an order to purchase goods

from a supplier and the vendor ships the paper directly to the end

customer.

Responsibilities:

. Designed a automatic customization process that involves in creation

of sales order, purchase orders based on the Quotation information.

. Developed a concurrent program that involves in creation of sales

order based on APIs.

. Developed an Advanced Shipment Notice Form that involves in carrying

out the receipts based on the drop shipment process.

.

Environment: Oracle Applications 11.5.9, OM, PO, INV.

Contact this candidate