Technical Consultant Resume

SUMMARY

Having 3.3 years of IT experience in Oracle Applications R12 and Responsible for understanding and analyzing the provided RICE components.
Experience in development and customization of RICE (Reports, Interface, Conversions, and Extensions) Components.
Worked with new implementation and supporting projects in supply chain, manufacturing and financial modules. Worked with the implementation team of ORDER TO CASH and PROCURE TO PAY cycles.
Worked with RICE components in various modules like Purchasing(PO), Order management(OM), General Ledger(GL), Account Payables(AP), Account Receivables(AR), Inventory(INV) .
Experienced in conversion and interface development, new & customized reports .
Experienced in customization by extension and modification of the standard application suite using Application Object Library (AOL).
Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL.
Good experience on development of XML Publisher Reports.
Having Good Knowledge on Workflows.
Having good Knowledge on AIM documents as per the Oracle Standard Corporation.
Highly motivated team player with strong business and analytical skills.

TECHNICAL SKILLS

Oracle Applications: Oracle apps R12

Modules: Order Management (OM), Inventory (INV), Purchasing (PO), Payables (AP),Receivables (AR), General Ledger (GL) .

Database: Oracle 9i, 10g.

Languages: SQL, PL/SQL .

Development GUI Tools: Forms 10g, Reports 10g and XML Publisher.

Oracle & Others Tools: SQL*PLUS, SQL*Loader, Oracle Workflow, TOAD, WINSCP.

Operating Systems: Windows 2000, Server 2003/XP.

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant

Software: Oracle Applications R12, Oracle 10g, Reports, XML Publisher, TOADSQL*Loader

Responsibilities:

Implemented SQL* LOADER scripts to upload data from external systems to oracle applications custom tables.
Working experience with various API’s .
Involved in implementation process of Conversions and interfaces
Written stored procedures and functions using PL/SQL.
Defining Concurrent Programs, Executables.
Developed XML reports as per the client requirement.
Creation of Value sets in various Modules.
Creation of documents like MD70, Migration documents.
Developed Approved PO Requisition Report.
Developed Cleared Invoice Report.
Developed Vendor Received Quantity Report.
Developed Supplier Invoice Details Report.
Developed Invoice Payment Status Report
Developed AP invoice Interface to import the invoices details from legacy system to Oracle apps base tables.
PO Vendor Conversion to upload the vendor details to oracle applications base tables .

Confidential

Technical Consultant

Software: Oracle ApplicationsR12, Oracle 10g, Reports, forms, TOADSQL*Loader, Flezilla, XML publisher

Responsibilities:

Being a part of the offshore team and responsible for the following Technical Components.
Development of Interface Programs to import the data from Legacy System to Oracle
Applications Base Tables by using SQL*Loader Program.
Developed Sql queries to obtain specific information as per requirements.
Developed XML reports as per the client requirement by using the .rtf formats and developed
Developed Packages to extract the data from base tables into flat files by using UTL FILE package.
Defining Concurrent Programs, Executables.
Customized existing reports as per the client requirement.
Creation of Value sets in various Modules of the application
Developed new form as per client requirement by using TEMPLETE.fmb
Registering and as well as Scheduling the Concurrent Programs.
Developed Packages, Functions, Procedures, Cursors, Triggers and Views by Using PL/SQL code

Confidential

Software Engineer

Responsibilities:

Understanding the report functionality and analysis and review of high level documents mainlyMD 050’s.
Analyzed the user requirements.
Developed Sql queries to obtain specific information as per requirements.
Developed Outbound Interface to Extract the data from Base tables into Flat Files.
Developed new reports as per client requirement.
Implemented Stored Procedures(Procedures, functions).
Developed new form as per client requirement by using TEMPLETE.fmb.