Nitin Attri

Oracle Apps Techno-Functional Consultant

Contact +91-991*******

Email aca42b@r.postjobfree.com

RESUME SUMMARY

* ****** * ***** ** experience in oracle application using PL/SQL, Oracle reports.

5 Experience in Reports, Conversion Programs & Interface Programs using Open Interface.

6 Worked on development and customization of Oracle Apps R.I.C.E components

Technical Knowledge in ERP – Business Suite (Modules –Inventory, General Leger, Account Payable,

7

Receivables, Order management, Purchasing, Alerts, AOL)

Strong knowledge in Multi Org and P2P,O2C areas of the Oracle Applications

8

Experienced in SQL, PL/SQL Coding like creating Functions, Procedures, Cursors, Triggers and

9

Packages.

Basic Knowledge of Oracle ADF.

10

TECHNICAL SKILLS

ERP : Oracle Application 11i, R12

: PO, AR, GL, AP, INV,OM, Alerts, AOL,ADF.

Modules

Languages : SQL, PL/SQL,Unix

: Oracle 9i/8i, 10g

Database

GUI : Oracle Reports 6i

Tools : TOAD 8.5, Sql*Loader,UTL, Discoverer,Putty,.

Documentation :MD50, MD70

PROJECT SUMMARY

Project Details 1:NCR Corporation ( Implementation Cum Support )

ERP : NCR Corporation R12 Implementation Of Oracle Apps (12.1.2)

Client : NCR Corporation India Pvt.Ltd. Gurgaon

Module : Payables (AP), Inventory, Order Management (O.M)

Team Size : 8

Duration : Dec 12 to till date

Profile – Working as a Core Team Member in the Implementation Project of ORACLE APPS 12.1.2.

Roles & Responsibilities:

Reports Development and Report Customized (Oracle Std.), Use User Exit in reports

•

XML REPORTS using BI Publisher.

•

Working on Drop Ship Cycle, RMA.

•

Worked on Internal sales order and Part Requirement Using Field Logistic Responsibility.

•

Working on Account Payables Payables Open Interface Import for synchronous data transfer from Legacy

•

to Oracle Apps checked data validation by creating PL/SQL package.

Creating outbound Interface Using UTL file.

•

Working on PO Conversion.

•

Working on Account Payables Supplier Open Interface Import for synchronous data transfer from Legacy

•

to Oracle Apps checked data validation by creating PL/SQL package.

Created Supplier Interface from scratch using SQL* Loader, Validation Program and Oracle Standard API and

•

Using SHELL SCRIPT.

Design of GL Interface: Understand the requirement of interface to integration of Oracle Apps and Legacy

•

system, Create the GL Interface to enter Journals from Legacy (Cane) system to Oracle GL.

Project Details 2: LPTI(Le Passage To India) (Post Implementation Support)

ERP : LPTI Customization of Oracle Applications 11i (11.5.10.2)

Client : Le Passage To India Pvt. Ltd. Noida

Module : Receivables(AR),Payables(AP),General Ledger(GL).

Team Size : 3

Duration : Dec 11 to Dec 12.

Roles & Responsibilities:

Reports Development and Report Customized (Oracle Std.), Use User Exit in reports

•

XML REPORTS using BI Publisher

•

Develop on Dispatch Detail Report that sends information via email.

•

Working on Account Receivables Auto Invoice Interface for synchronous data transfer from

•

Legacy to Oracle Apps checked data validation by creating PL/SQL package.

Working on Account Payables Payables Open Interface Import for synchronous data transfer from Legacy

•

to Oracle Apps checked data validation by creating PL/SQL package.

Creation of Bank and Bank Branches.

•

Creation and customization of forms using ADF.

•

Working on Payables – Document Sequences Setup.

•

Working on Account Receivables Supplier Open Interface Import and Supplier Site Open Interface

•

Import for synchronous data transfer from Legacy to Oracle Apps checked data validation by creating

PL/SQL package.

Creation of Bank and Bank Branches.

•

Project Details 3: IR(Indian Routes ) (Post Implementation Support)

ERP : IR Customization of Oracle Applications R12 (12.1.1)

Client : Indian Routes Pvt. Ltd. Noida

Module : Receivables(AR),Payables(AP),General Ledger(GL).

Team Size : 3

Duration : Dec 11 to till Dec 12.

Roles & Responsibilities:

Reports Development and Report Customized (Oracle Std.), Use User Exit in reports.

•

XML REPORTS using BI Publisher.

•

Working on Account Payables Payables Open Interface Import for synchronous data transfer from Legacy

•

to Oracle Apps checked data validation by creating PL/SQL package.

Develop on Dispatch Detail Report that sends information via email.

•

Created custom Alerts using Oracle Alert manager.

•

Project Details 4: Samarth (Implementation cum support)

ERP : Sandhar Technology Ltd. (12.1.1)

Client : Sandhar Technology Ltd. Gurgaon

Module : Inventory, Purchasing, Order Management.

Team Size : 5

Duration : July. 09 to Aug 11.

Roles & Responsibilities:

Development and customization of report: Developed Reports from Scratch and

•

Registered reports in Oracle Applications R12. Use User Exit in reports

Creating set Values of independent, dependent table types.

•

Creating all Masters like Item Master, Suppliers, Customers.

•

Creating a Purchase Orders, PO Releases, and Purchase Requisition, Order Booking & resolve the day by day

•

user issues as functional Support work.

Data Fix/Resolve the data entry mistakes done by Apps user.

•

• Planning/maintain to test the data information system and documentation

Transfer Data from Flat File to Temporary Table using SQL LOADER.

•

Oracle Applications for AOL Related Tasks.

•

Capturing KFF in STL Move Order Pick Slip Report: captured code combination value and description in

•

case of transaction type. This report is enhancement of existing custom report.

Reports Development and Report Customized (Oracle Std.): Developed Reports from Scratch and

•

Registered reports in Oracle Applications. Use User Exit in reports

XML Reports : Developed Reports from Scratch and Registered reports in Oracle

•

Developed inbound and outbound interfaces.

•

Developed procedures, functions and packages used in the creation of Interfaces and Reports

•

Pack Slip Report Customization: Customized Pack slip report and use Customized Pack Slip Report (STL

•

Pack slip Report) in document set instead of standard Pack Slip Report.

Multi_Org: Familiar of Multi_Org Environment.

AIM Documents: Maintain documentation of developing objects using AIM methodology.

Customer Loading: Loaded Customer data into AR with the help of Customer Interface. Written validation

•

Scripts to load and validate data and transfer data into interface tables.

Developed Inventory Interface using SQL*Loader and checked data validation by creating PL/SQL

•

package.

CURRENT EMPLOYEE

NCR Corporation(I) Pvt.Ltd.

Sept 13 till Present

PREVIOUS EMPLOYEE

Strawberry Infotech Pvt.Ltd.

Dec12 till Sept13

Arshiya Solutions Pvt.Ltd.

May09 till Dec12

PROFESSIONAL QUALIFICATIONS

B.E,2009 from M.D.U (Rohtak)

PERSNOL DETAILS

Father’s Name : Shri.Ved Parkash

Gender : Male

Nationality : Indian

Languages : Hindi,English

Date of Birth 02 March 1988

Contact this candidate