Oracle Project

R ESUME

C halla. K ranthi Kumar Technical Consultant

Mobile no: +91-958******* E mail id :

k *****.********@*****.***

PROFESSIONAL SUM MARY:

• Over 4+ years of experience on Oracle Apps R12 as a Technical SCM Consultant

w ith extensively worked in OA Framework (OAF).

• Strong Working Knowledge and experience in RICE (Reports, In terfaces,

Conversions, and Enhancements).

• Proficiency in Oracle Apps Supply Chain Management Modules.

• Experience in Multi-Org Environment.

• Experience in PL/SQL coding like Cursors, Packages, Stored Procedures and

F unctions.

• Having K nowledge on WORKFLOW Process.

• Having working experience on XM L-Publisher.

• Having E xperience on developing In terfaces in PO, AP, I NV, GL.

• I nvolved in creating new web based pages using OA Framework.

• C reating AM, VO, EO, AO, VL, REGIONS, LOV’S, Pick list Setting CO as per the

C lient Configuration.

• Developed Project detail page& creation page using OAF in AR Module.

• Calling oracle API program to OAF.

• Personalization of standard oracle pages

• E xtensions of standard Oracle pages.

• E xtensions of VO, EO, CO in Standard Oracle pages.

E D UCAT IO NAL QUAL I F ICAT IO NS:

• B.sc from Avanthi Degree College, Osmania University in 2008.

WORK EXPER I E NCE:

• Working as Technical Consultant in xxxxxxxx from 2010 to t ill date.

• Worked as Technical Consultant in .

TEC H N ICAL SK I L LS:

ERP : Oracle Applications R12.1.1 (Inv, Po, Om, Ap, Ar, Gl)

Oracle tools : Sql * Plus, Sql * Loader, Toad, Jdeveloper10g.

Front end tools : Forms 6i/10g, Reports

6 i/10g,OAFramework,Bip Reports.

Operating systems : Windows Family.

Languages known : Sql, Pl/Sql.

PROJECT DETA I LS:

P roject#1:

C lient Name Belron, Egham, U K

Role Technical Consultant

Oracle Applications R12(12.1.1) Implementation

Environment

Organization OSI Consultancy pvt lmt

Duration Jan 2012 to t ill date

Modules Inventory, Purchasing, and Order Management.

Description:

Belron is the world's largest dedicated vehicle glass repair and replacement company. I t is

home to 25,000 employees, all working together to bring the Belron story to life. Our

operations span over 30 count ries and five continents, making us a global business in every

sense.

I was involved in the post implementation process, developing new reports and interface

p rograms as per the business requirements. Worked with concurrent programs, PL/SQL

API's and OAF pages.

R ole and Responsibilities:

• Designed and Developed Vendor wise Pending,Cancelled Po Report.

• PL/SQL Method of submit ting Concurrent Programs.

• Designed and Developed the Invoice Details Report.

• Developed interface program to upload the data of Purchase requisitions into Oracle Apps

Base

t ables.

• Involved in the development of procedures, functions and packages.

• Developed Outbound In terface Program to import the data from Oracle Application Base

Tables into Legacy Systems.

• Developed Purchase Order Receipts In terface to import the data from Legacy Systems into

O racle Application Base Tables.

OAFrameWork:

• Development of Order Ent ry Page in custom OE module in OAF.

• Development of Order Details Page in custom OE module in OAF.

• Development of Customer Details Page in custom RA module.

• Development of Supplier Creation page in custom POS Isupplier module.

• Development of Supplier Creation page in custom POS Isupplier module.

• Personalization’s in Standard Oracle iprocurement module pages.

• Personalization’s in Standard Oracle isourcing module pages.

Project#2:

Zain FormFactor Inc

Client Name

Role Technical Consultant

Oracle Applications R12 (Implementation)

Environment

Organization OSI consultancy pvt l td

Duration Mar 2011 to jan 2012.

Modules Inventory, Purchasing, and Order Management .

Description:

FormFactor is an industry leader in the design, development, manufacture,

sale and support of precision, high performance advanced semiconductor wafer probe cards

and now is the leading supplier of advanced wafer probe cards.

As a Technical Consultant, was involved in the development and customization and

Supporting of reports and In terfaces .

R ole and Responsibilities:

• Worked on complete order cycle setups from order entry in order management to ship

confi rm

i n shipping execution and invoicing.

• Successfully implemented Standard Purchase Order, Blanket PO and PO Releases.

I mplemented

I n ternal Sales Order using Internal Requisitions/ Standard PO and Sales Order

p rocessing.

• Defined new inventory organizations, parameters, sub inventories, and picking rules in

I nventory.

• Maintained purchasing locations, buyers, approval groups, options and lookup codes.

• Conducted comprehensive user t raining on Oracle Purchasing, Shipping Execution,

development of t raining materials and practice exercises.

• Preparing Documentation based on client requirement.

• Offshore support and maintenance of the Implemented Oracle ERP Applications suites

(Inventory, Purchasing, and Order Management).

• Provided user support to resolve various issues that occurred after go-live.

• Creation of Value sets in various modules of the application.

• Defining Concurrent Programs and Executables.

• Writing the Technical Document and Installation guide.

• Created different Profile Options and assigned values to the Profile Options.

• Worked on PL/SQL Procedures and Packages as part of Development.

• Customization of Pick slip XM L-Report.

• Troubleshooting of day-to-day problems faced by End Users and supporting the client in

solving

issues.

• Designed master-detail and Mul ti-layout templates using RTF method for XML Publisher.

• Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader

scripts.

• Developed XML Publisher Reports using plsql and bursting Concept.

• Designed Template Based XML Publisher Reports.

Project#3:

Client Name BAE SYSTEMS,UK

Role Technical Consultant

Oracle Applications 11.5.10.2 (M igration )

Environment

Organization M ind Tree

Duration Mar 2010 To mar 2011

Modules Inventory, Purchase Order and Order Management.

Description:

BAE SYSTEMS is a global company engaged in the development, delivery and support of

advanced defense and aerospace systems in the air, on land and at sea.

T his is a Migration project from US Region to UK Region for Oracle Applications 11.5.10.2

Version to meet U K Standards and its Business, Involved customization and development of

R ICEM components in PO, I NV, OM Modules

Role and Responsibilities:

• Analysis of the custom Forms, Packages, Reports.

• Developed and modified Reports, Forms, and PL/SQL Packages to meet U K Business.

• Prepared ETF (Extension Tracking Form) for the Extension’s, citing all the development

and

Modification’s done to the extension for UK Environment.

• Downloaded files from US Instance using FNDLOAD commands and modified the

m igration (ldt) files

to UK Environment and uploaded the same.

• Documented all the work using AIM Methodology. Created and updated MD070 Technical

Specifications and Test Case documents for all the development work done.

• Registered Concurrent Programs, Forms, Form Functions, Menus and Reports in Oracle

A pplications

using Application Object Library. Also created various Profile Options, DFF, Value Sets,

A ttachment Setups, Request Groups, and Request Sets.

• Achieved functional knowledge in SCM Modules, like setups, and creation of Service

Requests,

Repair Orders.

Project#4:

C lient Name EQUIN IX

Role Technical Consultant

Environment Oracle Applications 11.5.10.2(Implementaion/Support)

Organization M ind Tree

Duration Mar 2009 to mar 2010

Modules Account Receivables, Account Payables, Purchase Order and Order

M anagement, General ledger.

Description:

EQUIN IX is the leading global provider of network-neutral data centers and In ternet

exchange services for enterprises, content companies and network services providers. This

system deals with quotes and revenue, which is divided into three major stages, Sales,

Operations and Revenue. As this project recently went Live, I am working to stabilize the

p rocesses and to meet the business requirements as part of the post-implementation

support and also working with new business enhancements.

Role and Responsibilities:

• Involved in Procure-to-Pay process from creating requisition, approving requisition, creating

auto

p urchase order, approving purchase order, sending PO to vendor, receiving goods,

creating Invoice, matching the invoice against PO, Paying the supplier and Transferring

payment information to GL.

• Defined purchase Documents such as Requisitions, RFQ, Quotation, Blanket Purchase

O rder,

agreements, Archiving, Releases, Sourcing, Pricing and Purchase order shipments and

D istributions.

• Successfully designed and implemented the Payables invoice import interface. Involved in

t he

creation of SQL* Loader File to import Invoices into the Payables interface tables and

t hen into Payable Open In terface to import the data into the base tables.

• Custom PL/SQL packages were created to validate the data coming from legacy system

before

loading into interface tables.

• Involved in the development of inbound and outbound interface programs in Oracle

Purchasing and

Payables modules.

• Developed Order Import In terface Program.

• Responsible for AOL and Sys Admin tasks like registering executables, concurrent

p rograms, request

sets, creation of menus, responsibilities, value sets and profile options. Also responsible

for maintaining users and request groups.

• Developed various Complex Reports using Reports 6i. The Reports involved complex queries

i n Data

Model, Complex Layouts, Used the functionality of Additional Default Layout,

Parameters, Program Units and the use of Report Triggers.

• Coded and developed Custom AP Tr ial Balance Report, Used Discoverer for the report

customization

p rocess as per the client requirement.

• Customized and developed user interfaces for customers using Developer 6i Forms.

• AP: Modified Payment Batch Formatting program; M igrated Invoices/Invoice Lines.

• Created Process Documentation for the AP Processes.

• Designed and developed numerous packages and procedures using various APIs to load

data from

staging tables into Oracle base tables.

• Conversions – GL: Involved in conversion of Journals from Legacy system to General

Ledger.

• Defined vendors, vendor classification and payment terms to enable the offering of discount

terms

w ith installment payments.

Declaration :

I hereby declare that the above information is t rue to the best of my knowledge.

Date: ( CHALLA .KRANT H I

K U MAR )

Contact this candidate