Technical Consultant Resume

PROFESSIONAL SUMMARY:

Having 4 years of experience in Implementation of Oracle Applications as a Technical Consultant, Involved in the Development and Customization of RICE Components.
Worked in different Modules in Oracle Applications (PO, AP, GL and INV) well versed with Application Object Library.
Experience in working with Standard and Custom Reports, interfaces in GL, PO, and AP.
Experienced in 11i Implementation, developing Technical specification, Code Realization, Data Conversion and Interfaces.
Created different types Values Sets as per business requirement.
Extensively worked on AIM documents like MD050, MD070 and TE020.
Experience on XML Publisher Reports.
Extensive Knowledge of Reports, Defining Concurrent Programs, Request Sets, Defining Value Sets.
Having good Domain knowledge in Procure to Pay Life Cycle.
Experience in writing Stored Procedures, Functions, Packages & Triggers using Sql*plus and pl/sql.
Exposure on workflow.
Knowledge on Custom.pll and Personalization
Excellent communication skills and good team working skills.
Capable of working independently and as well as a part of team.

TECHNICAL SKILLS:

ERP Applications: Oracle Applications11i (PO, AP, INV, GL)

Languages: SQL, PL/SQL

GUI: Developer 2000

Tools: SQL* PLUS, SQL* Loader, TOAD, XML

Environment: s: Win - 98/2000/NT, Win-XP and UNIX

Database: Oracle 8i/9i.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Environment: Oracle Applications 11i(AR, AP, PO, INV, GL)

Responsibilities:

Preparation of Technical documentation.
Registration of custom tables and concurrent programs.
Creation of Value Sets in various modules of application.
Involved in client meeting.
Involved in support of Customization, Custom module development and Implementation and Support phase of the project.
Worked on MEC Pending Transactions and GL Batch id reports.
Worked on Cross Currency Journal Creation report.
Worked on AR Interface Records for MEC report.
Worked on Agilent Auto Post schedule report.
Worked on Prompt payment discount (PPD) Scripts Automation report.
Worked on cross currency report.
Worked on Invoice Grouping Error report.
Worked on PWC Quarterly GL Data Request report.

Confidential

Technical Consultant

Environment: Oracle Applications 11i

Responsibilities:

Involved on designing and developing technical documentations for interfaces, reports.
Customization and reports development of Account Payables, Purchasing modules based on client requirements.
Developed the interface program to import the data from legacy system to Purchase Order Base Tables using SQL*Loader and PL/SQL packages to validate data.
Registration of Custom Tables and Concurrent Programs.
Maintained good communication channel with the Technical Designer both onsite and offshore.
Developed Vendor-PO Shipment Details Report
Developed Check Status Report.
Developed Invoice Report & Receipt Report.
Developed Inventory Item Cost Report using XML Publisher.
Developed XML Publisher Report to display Payment Details to Suppliers.
Customized the Order by Item Report add a field to display the returned Quantity.
Customized Invoice History Report to add Payment Details.
Worked on CUSTOM.pll to customize the existing oracle purchasing form as per Client Requirement.
Customized the Invoice Form in INV module using Personalization.
Enable Descriptive Flex Fields to the Existing Forms.

Confidential

Technical Consultant

Environment: Oracle A pplications 11i, Oracle.

Responsibilities:

As a support team member, I need to work on the tickets and updating the user about the issues by the E.O.D.
Maintained good communication channel with the Team members both on site and offshore.
Monitoring the daily running concurrent programs.
Creation of New queries by using all Oracle Apps Modules based on tickets.
Modification of existing queries and Enhancement.
Maintaining a repository of unique tickets along with the solution/workaround.
Analyzing the tickets and communicating the best possible solution to the user in comprehensive manner.
Worked on different interfaces for the data flow issues.

Confidential

Technical Consultant

Environment: Oracle Applications 11i, Oracle.

Responsibilities:

Involved on designing and developing technical documentations for interfaces, reports.
Worked on Performance tuning.
Maintained good communication channel with the Technical Designer both onsite and offshore.