Technical Consultant Resume

PROFESSIONAL SUMMARY:

Having 3+ years of experience as a Technical Consultant in oracle applications R12.
Expertise in Development and customization of RICE (Reports, Interfaces, Conversions, Extensions) components.
Hands on experience in modules like PO(Purchasing Order), AP(Accounts Payable), GL(General Ledger), OM(Order Management), AR(Account Receivable) Modules.
Expertise in Developing RDF and XML Publisher Reports.
Extensive Knowledge on reports, Executable, defining Concurrent Programs, Request sets and value sets.
Experience in writing procedures, functions and packages using SQL *PLUS and PL/SQL.
Having Work Experience on Procure to pay (P2P) and order to cash (O2C) Cycles.
Extensive experience in developing SQL *Loader control programs and PL/SQL validations scripts for validating and pre - import processing legacy data from legacy system to oracle applications.
Programming experience in developing Packages, Procedures, Functions.
Developed technical designs (MD070) and migration document (MD120) for different reports, interfaces and conversions.
Had knowledge in OAF( oracle application framework) pages development.
Worked with the tools like WINSCP, TOAD.
Having Working Experience on XML Publisher reports and Form Personalization.
Knowledge on functional Multi org architecture.
Ability to rapidly learn new concepts together with excellent interpersonal skills.

TECHNICAL SKILLS:

ERP: Oracle Applications R12 (12.1.3)

Modules: AP, AR, GL,PO

Languages: SQL, PL/SQL, Unix Shell Script

MS: DOS, Windows XP/2003/NT, Unix, Linux.

Databases: Oracle 10g/11g

GUI Tools: Oracle Forms & Reports 6i/10g

Tools: SQL * Loader, TOAD, BI Publisher

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Environment: Oracle applications 12.1.3, Oracle 10g/11g, UNIX, TOAD.

Responsibilities:

Developed Outbound Interface to upload the payment data to Legacy system by using the UTL FILE Package.
Developed SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data.
Involved in understanding and analysis of functional documents (MD50) and preparing Technical Documents (MD70) and MD120.
Modified RTF template for printing the cheque for a bank in payables.
PL/SQL method of submitting Concurrent program Validation of staging data before insertion into Oracle base tables or Interface tables.
Worked on Form Personalization in Purchase Order.
Developed Package, Stored Procedure, Function, and Exception as per Business requirement.
Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
Developed Customer order and Account Payables Invoice Report to display the PO and corresponding Invoice details.
Developed Supplier Payments Report using XML Publisher.

Confidential

Technical Consultant

Environment: Oracle applications 12.1.3, Linux, Windows7, TOAD 9.5.

Responsibilities:

Developed XML Publisher Reports using Data Templates as well RDF files.
Purchase Order Interface and Supplier Interface.
Customer order Report Developed Based on RDF, XML Data Definition and Xls Templates.
Developed Cash Positioning report in Cash Management using XML Publisher.
Involved in updating MD070, MD0120 documents with changes as per R12.
Resolved all performance issues of custom reports and interfaces.
Involved in writing Control Files for SQL Loading.
Developed Supplier Payments Report using XML Publisher.
Developed Package for multiple source lines of a particular fixed assets creation using API.
Developed WEB ADI for Data Insertion into Staging Table.
Resolved performance issues with standard oracle Programs with help of appropriate Oracle patches.