Project Oracle

MANOJ TANWAR

Phn No. - 971*******

******.********@*****.***

Career Objective:

To reach the highest echelons in a progressive organization with the hard

work, dedication and constant endeavor to perform and give better results.

Experience Summary:

Around 8 years of Technical experience on Oracle Applications. Including

Data Conversion, Customizations and Interfaces, On-site/Offshore co-

ordination. Having broad technical experience exposure in Oracle

Distribution and Financial Modules (GL, AP, AR, INV, PO, OM, BOM, OPM).

Developed Custom Workflows from scratch and Customised the Standard Ones.

. Currently Working with Path Infotech Ltd., Noida from July-2007 to

Till Date.

. Worked with MindCrackers Solution, Faridabad from Aug-2005 to July-

2007.

Technical Qualification:

B.TECH. (Mech. Engg.) from Jamia Millia Islamia, New Delhi.

Computer Skill set:

ERP: Oracle Financials, R12/11i (GL, AP, AR, INV, PO, OM, BOM, OPM)) and

India Localization.

Operating Systems: Win9x/DOS6.22/Unix.

Front End: D2k 6i and Development Suite 10g

Databases: Oracle 8x, 10g, 11g

Tools : Sql*loader, Toad, Pl/Sql Developer, XML Publisher, Oracle Workflow.

Projects Undertaken:

PROJECT 1:

Project Name: - Reimplementation of R12(12.1.3)

Client :- SRF Limited, Gurgaon.

Duration :- Sep-2012 to Till Date.

Module :- Financials, Distributions and Process

Manufacturing.

Role :- Technical Team Lead

Responsibility:

. Involved in understanding Client Requirements.

. Lead Team for Retrofitting of 11i Custom Reports and Forms as

Per R12 Structure, mainly Oracle Process Manufacturing(OPM)

Objects.

. Developed Various Conversion Programs Like Item Conversion,

OPM Formula, Recipe, Quality Specifications including

Validity Rules, OPM Item Cost, Test Method, Sampling Plans,

Generic Resources etc.

. Developed Various Custom Programs to Automate Creation of OPM

Batches from Pending Status to Complete Status using Standard

APIs.

. Developed Custom Program to Accept/Reject Inspection Required

PO Receipts as soon as OPM Quality Sample Disposition,

created against PO Receipt, is Accepted/Rejected.

. Developed Custom Program to Update Allocation Defintion based

on Total Production done in a month.

. Developed Custom Sample Approval Workflow in OPM Quality, if

any Test Result is Out of Specification.

. Developed OPM Formula Security using Custom.pll and Form

Personalization.

. Developed various Database Triggers to Call Custom Workflows,

Custom Programs.

PROJECT 2:

Project Name: - Reimplementation of R12(12.1.3)

Client :- Forbes Marshall, Pune.

Duration :- Jun-2011 to July-2012.

Module :- Financials, Distributions .

Role :- Technical Team Lead

Responsibility:

. Involved in understanding Client Requirements.

. Developed Cheque Printing Formats for DOT-Matrix Printer

using eTEXT feature of XML.

. As per standard IR-ISO Process between different Legal

Entities, Oracle does not support India Localization Taxes on

AR Invoice and AP Invoice. For this, Developed Custom

Programs to Import India Localization Taxes on AR Base

Invoice and AP Invoice.

. Customised Standard Workflows as per Requirements.

1. Move Order Workflow.

2. Order Workflow.

3. ECO Approval Workflow.

4. Project Supplier Invoice Account generation.

. Involved in Development of Custom reports using XML

Publisher without using Report Builder. Used Data Template

feature of XML to create report query and Data Model.

. Used XML Bursting Feature of XML to mail Invoice Report

Output directly to Customers.

. Developed Chart report for Oracle ASCP Module to show load

and Capacity for all resources or a particular resource of a

Plan between From date and To Date selected by User.

. Involved in Development of Conversion programs like Item

Master, Customer Master, BOM, Routing, Open Sales Order

Conversion, Open PO Conversion etc.

. Developed sql Loader control files for Conversion programs to

import Data from Flat Files to Oracle Staging Tables.

PROJECT 3:

Project Name: - Implementation of R12

Client :- Videocon Telecommunication Ltd., Gurgaon

Duration :- Jan-2011 to May-2011

Module :- Oracle Order Management.

Role :- Technical Team Lead

Responsibility:

. Developed Order Import Program using OE_ORDER_PUB to import

orders into R12 from Legacy.

. Personalize Orders Screen in R12 apps to Prevent Order

booking.

. Developed Custom Form where User can Prioritize the Orders

for Shipping according to Customers Credit Balance. If

Sufficient balance and Item has Onhand, then Orders are also

booked on selection of Orders.

. Developed File Read program which will Read Item Serial

Numbers to be shipped and reserve the same against Order

Numbers specified in the files.

. Developed Shipment Program which will ship the Orders i.e.

Pick Release, Ship Confirm and run Interface Trip Stop.

. Developed Periodic Alerts.

PROJECT 4:

Project Name: - Upgradation of Oracle Apps 11i to R12(12.1.3)

Client :- GPIL, Delhi

Duration :- Sep-2010 to Nov-2010

Module :- Financial, Distributions and India Localization.

Responsibility:

. Retrofitted 11i Reports as per R12.

o Reports:

1. XXGP: Goods Receipt Note Report.

2. XXGP AR Aging Report (New Format).

3. XXGP: VAT Claim Transactions.

4. XXGP: Purchase Register Report.

5. XXGP: Completed Receipt Report.

6. XXGP: Receipts for Excise Claims.

7. XXGP: Material Transaction Register.

8. XXGP: Item Detail Report.

9. XXGP: VAT Liability Report.

10. XXGP Trial Balance Summary 1 (Excel)

. Developed Employee as Supplier Creation Program.

PROJECT 5:

Project Name: - Customization of Oracle Apps 11i

Client :- KPMG, Gurgaon

Duration :- Jun-2010 to Aug-2010

Module :- Oracle Workflow and Oracle Forms and Reports.

Responsibility:

. Involved in understanding client requirement (Forms and

Workflow).

. Developed Custom Multi Level Approval Workflows which are

initiated from Custom Forms.

o Forms and Approval Workflows:

. FAS (Functional Acceptance)

. FAS - IOM

. CAF (Customer Acceptance Form)

. CAF - IOM

. TAX

. TAX - EAF

PROJECT 6:

Project Name: - Oracle Apps Upgrade from 11.5.9 to R12 (12.1.1) &

Support

Client :- ESPN STAR SPORTS, Gurgaon

Duration :- Jan-2010 to May-2010.

Module :- Financial Modules (GL, AP, AR and FA)

Responsibility:

. Modify all 11.5.9 customize Objects (Reports /Forms/Extension

and Interfaces) as per R12.

. Developed XML Reports.

. Involved in functional and Technical testing of Financial

Modules.

. Involved in User Training

. Issue resolution.

PROJECT 7 :

Project Name: - Customization and Production Support Of Oracle Apps

11i (11.5.10.2)

Client :- LG Electronics, Greater Noida.

Duration :- August-2007 to Nov-2009.

Module :- Finance (GL, AP, AR) and Custom Application Vendor

ERP (VERP).

Responsibilities:-

. Developed Custom forms Using Template.fmb from Scratch and Modified

existing ones as per Client requirement.

. Developed Custom forms and Procedures for Vendor ERP (VERP).

. Developed Form for Uploading images using Template.fmb for VERP.

. Personalized forms in AP module like AP Payment Batch, AP Payment etc.

. Developed and modified Reports in AP and AR module like Cancelled

Vouchers Report, Dealer Statement Report, Export AR Aging, Fringe

Benefit Tax (FBT) Report, TDS Pan Duplicacy Report, AR Aging etc.

. Developed Customised Form-16 Report from Scratch.

. Developed Program for Disabling 'Posting' Button in Journal Entry form

in GL during Month End Closing. So that, no user can post any journal

when month-end closing is going on.

. Developed GL interface in FA module for Assets which are sold by LG.

. Developed Debit Note Interface for Vendor ERP (VERP). This Process

creates Debit Note in AP against those Vendors which are currently

using VERP.

. Developed Asset confirmation Module in VERP.

. Developed AR Payment Term Screen in AR. Using this, End-user can set

any Payment term for any customer in AR. For this, developed form and

concurrent Program which is daily scheduled.

. Customised Existing Travel Module in AP and provided Daily Production

support. For this, developed many reports like Travel FBT report,

Travel Printing Report etc.

. Developed many modules for VERP like Balance Confirmation, Accounts

Reconciliation etc. from Scratch.

. Provide Production Support for Daily Issues in AP.

. Developed AR to AP Transfer Process. In this, if a customer is also a

vendor, then through this process, End-user can create CM in AR

against AR Invoice which he selects. At the same Time, one CM also

gets created in AP. This utility is available in R12, but not in 11i.

Developed form, procedures for creating CM in AR, creating receipt in

AR and applies these Receipts against CM created and creating CM in

AP.

PROJECT 8:

PROJECT NAME: Customization of Oracle Application 11.5.8

CLIENT: Hydrolux Wholesale Store, US.

DURATION: Oct'2006 - July'2007.

RESPONSIBILITIES:

. Development of Reports from Scratch: Design and developed reports

From Scratch in Financial Modules and Registered reports in Oracle

Applications as a Concurrent Program Executables.

. Created Custom Value set of Dependent, Independent, and Table Types in

11i.

. Creation of Request Set: Created Request Set and attached them to

Request Group.

. Descriptive Flex Field: Enabling DFF in the Forms to capture extra

information in the Forms..

. Registered Custom tables in Apps by using ad_dd packages

. System Administration Jobs: Creation of User, responsibility and

Customization of Menus.

PROJECT 9:

PROJECT NAME : Customization of Oracle Application 11.5.8

CLIENT : Connectsim Solutions, Canada.

DURATION : Aug'2005 - Sep'2006

RESPONSIBILITIES:

. Development of Reports from Scratch: Design and developed

reports From Scratch in Financial Modules and Registered reports

in Oracle Applications as a Concurrent Program Executables.

. Registered Custom Programs in 11i defining Executables,

Concurrent Programs, and Request Groups.

. Created table type Value set using $FLEX$ utility. Created Value

set of independent and dependent type.

. Calling Concurrent Programs in Apps: Called Concurrent Programs

in Oracle Applications with the help of API

FND_REQUEST.SUBMIT_REQUEST.

Personal Information:

Date of Birth : 02- Aug- 1981

Father's Name : Mr. S. S. Tanwar.

MANOJ TANWAR

Contact this candidate