Oracle Sql

Apps Technical Consultant

Amar Nath Email: ***********@*****.***

Mobile: +91-814*******

* Objective:

Seeking a responsible and challenging position in an organization that would enable me to augment my already acquired knowledge, bring to forefront my skills and offer opportunities for growth based on achievements.

* Professional Summary:

* Have an experience of around 3.5 years in Oracle Implementation & Customizations.

* Extensively worked in Technical aspects of Oracle Applications modules such as (PO, INV, AR, AP, OM) Using Oracle 8i/9i, PL/SQL, SQL*Loader, Oracle Forms and Oracle Reports on windows.

* Worked on XML Publisher reports.

* Worked on Discoverer Reports.

* Worked on oracle apps forms & form personalization.

* Good practice on RICE components.

* Have good experience with TOAD and SQL * Loader to load data from flat files Creation of Concurrent programs, Value Sets, Tables, and Control files, PL/SQL Stored Procedures, SQL*Plus.

* Have knowledge in Reports & Interfaces and Functional flow of Procure to Pay and Order to Cash cycles.

* Good knowledge on AIM methodology.

* Good Communications, analytical and problem solving skills.

* Have Good Knowledge in Procure to Pay and Order to Cash cycles.

* Experience History:

* Currently Working as Technical consultant with Wipro Technologies, Bangalore from May, 2012 to till date.

* Previously Worked as Associate Engineer with Argus Info Solutions Pvt Ltd, Bangalore from Apr, 2010 to May, 2012.

* Educational Qualifications:

* Bachelor of Commerce (Computers) from Sri Krishna Devaraya University.

* Technical Skills:

ERP : Oracle Applications (PO, AP, INV, AR,OM)

GUI Packages : Developer 2000

RDBMS : Oracle 8i/9i

Languages : SQL, PL/SQL

Tools : Toad, SQL*Loader, XML Publisher, winscp

Working Environments : Windows 95, 2000, NT, and XP

* ERP Project Profiles:

* Project 01:

Client : Mead Westvaco

Role : Oracle Applications Technical Consultant

Environment : Oracle Applications

Description:

Mead Westvaco provides packaging solutions and products to many of the world’s best-known companies and most-admired brands. With a presence in more than 30 countries, our research, design, manufacturing and distribution capabilities serve leaders in the food and beverage, media and entertainment, personal care, home and garden, cosmetics and healthcare industries. We also have market-leading positions in our Consumer & Office Products and Specialty Chemicals businesses.

Responsibilities:

* Development and customization of reports.

* Defined value sets, concurrent programs, registering reports and PL/SQL procedures and functions.

* Preparation of SQL Loader scripts.

* Development and customization of interfaces.

* Developed MD70 based on requirement.

* Validation of staging data before insertion into Oracle base tables or Interface Tables.

Reports:

* Customized purchase order detail Report

* Developed Vendor/purchase order Report.

* Development of PO Forecast report to displays the information of the purchase order as per the Promised date.

* Developed on hand quantity report Using XML Publisher.

* Customized standard print invoice Report.

* Developed Purchase order and Invoice report.

* Development MW Inactive Vendors.

* In Transit value report.

Interfaces:

* Developed AR invoice out bond interface.

* Worked on Item conversion.

* Worked on GL interface.

* Project 02:

Client : COVAD

Role : Oracle Applications Technical Consultant

Environment : Oracle Applications

Description:

COVAD Communications: As the first company to commercially deploy DSL in the United States, Covad is a broadband expert. Covad owns the only nationwide broadband DSL network with more than 57 million homes and businesses, which represent over 50 percent of all United States homes and businesses. Covad broadband services are currently available across the nation in 44 states and 235 Metropolitan Statistical Areas (MSAs).

Responsibilities:

* Development of new reports in Account Payables, purchasing modules based on client requirement.

* Creating packages, procedures, functions, trigger and other database objects using SQL and PL/SQL.

* Creation of value sets in various modules of the application.

* Developed Purchase order Interface to upload the STANDARD Purchase order into oracle base tables through interface tables.

Reports:

* Customized the Standard AR invoice report.

* Developed RFQ report.

* Developed Standard pick slip report.

* Developed Customer sales order report.

* Developed Purchase internal report.

* Un invoiced receipt report developed.

* Development of serial update program.

Interfaces:

* Worked on PO Requisition conversion to Load the data from staging table to oracle base tables through interface table.

* Create the parties using standard API’s.

* Worked on customer outbound interface.

* Project 03:

Client : BAX GLOBAL

Role : Oracle Applications Technical Consultant

Environment : Oracle Applications

Description:

BAX Global Inc., with worldwide headquarters in Irvine, California, is a supply chain management and transportation solutions company offering multi-model logistics management for business-to-business shippers through a global network of nearly 500 offices in 133 countries

Responsibilities:

* Migrate the objects from 11i to R12.

* Migrating the Reports, Custom Views and so on.

* Performing AOL activities for new component such as creating concurrent program and value sets.

* Creation of Packages, triggers and writing PL/SQL block.

* Development of New reports as per the clients requirement.

* Customization of Oracle Standard Reports.

* Defined value sets, concurrent programs, registering reports and PL/SQL procedures and functions.

* Preparation of SQL Loader scripts.

* Validation of staging data before insertion into Oracle base tables or interface Tables.

Page of

Contact this candidate