Oracle Sql

CV of Nagaraj Dhanashri

Profile Summary:

Nagaraj Dhanashri is a technical Consultant with 5+ years of experience in

Oracle Applications implementation. He comes with good experience in the

technical aspects of Oracle Applications 11i (General Ledger, Account

Receivables (TCA), Order Management, Account Payables, Purchase Order,

Inventory (INV), BOM, WIP,IB, Service Contracts, HR, Payroll and System

Administration). He has involved in Oracle based business application

design and development, implementation, customization, maintenance,

conversions, interfaces and user training. He has worked with reputed

clients like Ixia, Thermo fisher Scientific, AM Castle, Megtec Systems etc.

Nagaraj possess excellent communication and interpersonal skills.

Technical Summary:

. Good experience in the technical aspects of Oracle Applications 11i

(General Ledger, Account Receivables (TCA), Order Management,

Account Payables, Purchase Order,Inventory (INV), BOM, WIP, and

System Administration)

. Involved in Oracle based business application design and development,

implementation, customization, maintenance, conversions, interfaces

and user training

. Expertise in developing conversions routines between legacy to Oracle

ERP/Manufacturing Applications using SQL * Loader, PL/SQL, Standard

Open Interfaces

. Very strong experience in SQL, SQL*Plus and PL/SQL

. Well versed with client server environment and tools like

Developer/2000, SQL*Loader, and TOAD

. Solid Experience in Database design, Creation and Management of

schemas, writing stored procedures, functions, triggers, SQL query

performance tuning

. Thorough knowledge of Oracle Apps Data model and how to leverage the

data for effective reporting

. Solid Experience in Database design, Creation and Management of

schemas, writing stored procedures, functions, triggers, SQL query

performance tuning.

. Experienced in Forms 6i, Reports 6i and workflow builder.

. Extensively worked on AIM documents like CV40, CV60, MD050, MD070 etc.

Technical Skills:

Oracle Apps GL, AR, AP, OM, INV,BOM,QP,PO,IB, HR

Database Oracle 10g/9i/8i/8.0/7.x, SQL server, MS

Access

Tools Oracle Forms 6i, Reports 6i, Discoverer 4i,

Workflow builder 2.6, SQL*Plus, SQL*Loader,

TOAD, XML Publisher 5.0.

Languages PL/SQL, C, C++, Java, VB.NET, PHP, XML, SQL.

OS Windows 2003 Server/NT/ 2000/ XP, UNIX

Web ASP, J2EE, Jdeveloper, XML web services

Technologies JavaScript, VBScript, CGI, Perl

Other Skills LDAP, UML, FrontPage, CSS

Education:

. M.S. Computer Science, New Jersey Institute of

Technology (NJIT)

. Bachelor in Information Science and Engineering

Major Projects:

Client : Ixia, Calabasas, CA

Project Title : Implementation of Oracle Applications 11i

(11.5.10)

Duration : Nov'08 - Till Date

Role : Technical Consultant

Environment : Oracle Apps 11i, AP,AR,PO,FA,GL,INV,BOM,IB,OKC,HR,PER,Forms 6i, Reports 6i, workflow builder and custom licensing

application.

Responsibilities:

Development of custom licensing application

. Developed custom api's to validate and publish products to FNO using

cast iron. (Product structure was published in xml format). These

api's are further in other relevant places.

. Developed custom api's to validate and publish product family to FNO.

. Developed api's to create, update and delete temp license entitlements

for Product family.

. Developed program for publication set to publish large number of

products, licenses or product family at once to FNO.

. Developed workflow to handle exceptions in publications.

. Developed custom forms using forms builder 6i to maintain setups for

product family.

. Developed api's to create, update and delete eval request which

enforced the business rules provided by the end users. These api's

were used in the eval portal.

. Developed api's to create, update and delete eval licenses.

. Developed custom workflow using workflow to implement eval request

approval workflow.

. Created a separate schema with required grants and privileges for

licensing application to provide a separate area for code promotion.

. Created and maintained deployment scripts to deploy objects for

licensing application.

HRMS

. Extracted HR data for APD System (HRP).

. Worked on mapping legacy fields to Oracle by coordinating with

business users.

. Developed program to validate import Employees (US, Romania and India)

information using oracle api's.

. Developed program to validate and import Assignment and Salary

Information.

. Developed program to convert employee historical information (Job,

Position, Location and Salary).

. Developed views to implement Oracle HR security in Oracle to Cognos.

. Developed views for Appointment report and headcount report in Cognos.

Apps Support

. Developed master view for cognos report to identify unique component

in a BOM.

. Developed program to stage data for install base detail report.

. Worked on performance improvements of may objects including alerts,

materialized views, reports etc.

. Developed templates for data conversions to integration projects for

Catapult and Agilent (N2X).

. Extracted and transformed data from Catapults legacy system

(expandable, Pegasus and custom DB) as per conversion templates.

. Resolved redo log issue caused due to refresh of materialized views

when upgraded database from 9i to 10g.

Client : Thermo Fisher Scientific

Project Title : Implementation of Oracle Applications 11i

(11.5.10)

Duration : Feb '08 - Oct '08

Role : Technical Consultant

Environment : Oracle Apps 11i, System Administration, AOL, GL,

AR(TCA), OM, INV Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Toad, Forms 6i,

Reports 6i, OA framework jDeveloper.

Responsibilities:

. Developed interface program to bring in previous demand history and

calculate forecast then import the forecast into current oracle

system.

. Imported items from legacy into Oracle using Item

Open Interface.

. Imported customer bank and payment information using customer open

Interface tables.

. Customized Discrete Job Pick List report.

. Created Serum Win-Loss custom report

. Importer AP Invoices in into Oracle using interface

tables.

. Loaded Users, responsibilities, menus, profiles and

flexfields using FNDLOAD.

. Associated employees to users using non-public API.

. Developed a custom forecasting tool using jDeveloper which allows

salesrep to enter forecast for every customer and every item for next

18 months, which would help planning better plan the production.

. Customized PO Approval Workflow as per customer's

requirement.

. Customized PO print report using XML Publisher.

. Customized RMA work flow to bring in an approval

hierarchy.

. Developed AR Invoice report using XML Publisher.

. Developed Margin report in order to calculate period wise margin based

on item, item category, salesrep, sales type, customer etc.

Client : AM Castle

Project Title : Implementation of Oracle Applications 11i

(11.5.10)

Duration : Oct '07 - Jan '08

Role : Technical Consultant

Environment : Oracle Apps 11i, System Administration, AOL, GL,

AR(TCA), OM, INV Oracle 8i, PL/SQL, SQL*Plus, SQL*Loader, Toad, Forms 6i,

Reports 6i, Oracle XML Publisher 5.0.

Responsibilities:

. Preparing Functional and Technical documents for Data

Conversions and Interfaces.

. Implemented conversion of Customers using TCA API's ( created mapping

tables for deduping old-new customers)

. Created customer account relationships using TCA API.

. Analysis, Design and Development of Open Invoice Data

conversions

. Developed PL/SQL programs to Import AR Invoice into

Oracle form multiple legacy

systems

. Designed and developed PL/SQL programs to import

Purchase Orders from legacy

systems to Oracle Purchasing

. Developed script to convert PO attachments

. Migrated all the instances from Linux to AIX

. Developed conversion script to convert Vendors and

vendor sites into Oracle

Client : Megtec Systems, De Pere, WI

Project Title : Implementation of Oracle Applications 11i

(11.5.10)

Duration : Aug '06 - Sep '07

Role : Technical Consultant

Environment : Oracle Applications 11.5.10 (General Ledger, Accounts

Receivables (TCA), Order Management, Inventory), AIM Methodology,

SQL*Loader, PL/SQL, XML Publisher 5.0, XML Gateway, Discoverer 4i, Oracle

8i, Reports 6i.

Responsibilities:

. Involved in conversions, development of new reports,

customization of the existing

Reports

. Responsible for data conversion in AR, AP, Inventory,

Purchasing, OM, BOM and WIP

. Involved in development and testing of interfaces in

AR and AP

. Implemented Customer Conversion Using Application

program interfaces in TCA

. Imported Suppliers Information from suppliers for

Legacy system into Oracle

Application using Interface tables

. Was involved in the conversions Items, Item Locators

and On hand Quantity in

Inventory Module

. Implemented Bills of Materials routings and Bills of

Materials Conversion using API's

. Imported Sourcing Rules and Approved Supplier List

into Oracle Purchasing

. Imported Open WIP discrete Jobs and transactions form

legacy system into oracle

applications

. Designed Interfaces, XML Web Services for Web-to-

Oracle interface to create TCA

objects using APIs

. Developing and testing XML publisher report template

in 5.0 environments

. Customized standard 'Sales Order Acknowledgement

Report

Client : Security Alert Technology, Bangalore

Project Title : Implementation of Oracle Applications 11i

(11.5.10)

Duration : May '03 - Jan '05

Role : Oracle Applications Developer

Environment : Oracle Applications 11 (AP, AR, GL, AOL), PL/SQL,

SQL*Loader, Forms 6i, Reports 6i, Discoverer 4i, SQL*Plus, Windows NT,

Oracle 8i/9i, TOAD

Responsibilities:

. Created temporary tables, and conducted data conversion and mapping of

data from legacy system to Oracle Applications using PL/SQL and

SQL*Loader.

. Migrated the data from legacy systems into the temporary tables in

Account Payables (AP). Successfully designed and implemented the

Payables Open Interface. Activities involved creation of Loader File,

porting Invoices into the AP_Invoices_Interface and

AP_Invoice_Lines_Interface interface tables using SQL*Loader and then

using Payables Open Interface to port the data into the actual tables.

. Developed a control file to load Customer information from flat

file into interim tables using SQL/Loader then validated data

and written customized program to insert data into the interface

table using PL/SQL

. Developed the conversion of Customer from legacy systems to Oracle

Applications, Imported external invoices into Oracle Receivables (AR)

through Auto Invoice Program using SQL*Loader.

. In General Ledger (GL) module, developed the Budget Upload Open

Interface to load the data from legacy systems to the

GL_Budget_Interface table using SQL*Loader. Then used "Budget Upload"

which in turn submits a concurrent program to port data to actual

table and verified the results using Budget Upload Execution Report.

. Transferring data from data files provided by the bank into auto

lockbox table using an SQL* Loader scripts

. Developed Database Packages, Procedures, Functions, Triggers, Tables

and Views in Oracle 8i.

. Designed and developed custom reports using Reports 6i in AR, AP as

per business requirements

Contact this candidate