Oracle Apps Technical Consultant Resume

SUMMARY

Having 6+ Years of experience in out of 4.5 Years in Oracle Applications 11i and remaining in Oracle D2K. High degree of interest in utilizing and enhancing Oracle Applications knowledge and experience, Being a team player and an enthusiastic learner.
Providing Functional Support and Technical Support for Oracle Applications P2P domain.
Worked in Implementation, Support of Oracle ERP Applications 11i with concentration on PO, AP,OM,INV,AR.
Responsible for understanding and analyzing the provided RICE component specifications and developing solutions by using Developer 2000 and PL/SQL.
Experience with Oracle and Other Utilities: TOAD, SQL *Plus, SQL*Loader.
Development and customization of Reports, Interfaces and Conversions.
Development of XML Publisher Reports and Forms using Template.fmb
Having good Knowledge in the concepts of Forms, Multiorg and flex fields.
Experience in creation of Menus, Functions and Value sets etc.
Capable of working independently and as well as a part of a team.
Possess very good communication and interpersonal skills.
Knowledge of R12 also.

TECHNICAL SKILLS

ERP Applications: Oracle Apps 11i (PO, AP, INV, OM, GL, AR)

Database: Oracle8i, 9i.

Languages: SQL, PL/SQL

Tools: TOAD, SQL*Plus, SQL*Loader, Clear Case, Remidy, $u tool

GUIs: Developer 2000 (Forms 6i and Reports 6i)

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10.2, Oracle 9i, Oracle Developer -

Responsibilities:

Worked on Procure to Pay Cycle.
Report to display Purchase Order details with buyer as parameter.
Developed Canon Vendor Detail Report
Developed Customer Merge Report
Developed GRN Report.
Downloading and Uploading the *.ldt file for value sets, Concurrent Programs, Request Group, Request Sets using FNDLOAD utility.
Hard coded analysis for various RICE objects
Providing fixes to the issues identified in testing phase.
Provide production support for the deployed project till it is stabilized
Interfaces Worked On GL Open Interface: Importing journals from legacy system into Oracle Apps.
Interfaces Worked On PO Open Interface: Importing Purchase Order from legacy system into Oracle Apps.
Importing Information into Oracle Applications (Staging table) through SQL* Loader.
Table creation, table handling, writing stored procedures, function, Packages, database trigger, indexes and packages.
Responsible for Open and close periods in PO/AP module.
Developed Interface for Supplier Upload from flat file.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10.2, Oracle 9i, Oracle Developer-

Responsibilities:

Developed various forms using Template.fmb.
Developed Purchase order details report.
Developed PO Conversion program to load standard PO details from Legacy system to Oracle Applications.
Developed AP Invoice Interface to transfer invoice details from Legacy System to Oracle Applications.
Worked on Journals Outbound Interface program to external Journal Information
From Oracle Applications to Legacy System by using UTL FILE package.
Involved in preparation of technical design documents for the RICE Components.
Involved in moving the code from one Instance to another Instance.
Worked closely with functional team to understand the requirements.
Involved in Unit Testing of the components.
Worked on GL Inbound Interface to upload journals from legacy to APPS.
Worked on Payments Outbound Interface program using UTL FILE Package.
Experience in Development of Multi Org and Multi layout Reports and Customization of Oracle Standard Reports by using Reports6i.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.9, Oracle 8i, Oracle Developer 2000

Roles & Responsibilities:

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.9, Oracle 8i, Oracle Developer 2000

Responsibilities:

Worked on development of reports with Oracle Applications.
Worked on XML Publisher Reports.
Tested the report’s output against Oracle Apps.
Created the database schema objects like tables, views, synonyms, indexes, procedures, and functions.
Worked on Performance Tuning and Optimizing SQL and PL/SQL scripts.
Provided immediate resolution of any technical issues like in reports and interfaces during Production.
Worked on different kind of concurrent programs like SQL*Plus, PL/SQL.
Involved in preparation of MD 70 based on MD 50.
Involved in testing of components which peers developed.
Testing the developed components with front and Applications.
Registration of reports using AOL script
Designing the Technical Documents for the Assigned Components.
Testing with available data in the modules like Purchasing and Inventory.
Responsible for developing the assigned RICE component i.e. Report, Interface.