SUMMARY

• Having 7 years of IT Industry experience in Support/ Interfaces/ Customization/ Testing/ Documentation of Oracle Applications 11i, R12 and Developer 2000.
• Strong Hands - on experience in Oracle ERP Applications, SQL, PL/SQL, Oracle Report Builder 6i, 10G, XML(BI) Publisher, SQL*Plus, SQL*LOADER, UNIX Shell Scripting and FTP.
• Experience in Application system Administration activities like defining responsibilities, Value sets, Flex fields, Reports, Managing Concurrent Programs, Providing Support to Apps End Users.
• Experience in developing Oracle reports in BI Publisher/XML Publisher.
• Expertise on Data Conversion and Data Integration from Legacy Systems or External Systems into Oracle Applications using Oracle open Interfaces and Oracle Public API’s.
• Experience in Oracle Financials and Supply Chain modules
• Good communication, self motivated and adapt to new technologies in a short period of time.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11i,R12 Modules Purchasing(PO), Accounts Payable(AP)Account Receivable(AR), General Ledger(GL), Order Management(OM), Inventory Management(INV), AOL, Work in Progress(WIP)

Languages: SQL, PL/SQL, C, C++, Unix

Databases: Oracle 11g/10g/9i, MS Access

Software Tools: Toad, SQL*Loader, SQL Developer, Putty, WinScp, PVCS, Note Pad+

GUI Tools: Oracle Reports 10g/9i, XML(BI) Publisher, Discoverer 10g, Workflow Builder

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Itasca, IL

Oracle Apps Technical Consultant

Responsibilities:

• Developed outbound interface to generate advance shipment notice file to inform customers about shipments.
• Developed outbound interface to generate a data file whenever ship confirm took place for certain location and FTP the file to server.
• Developed SQL*Loader scripts to load data into staging tables.
• Developed inbound interface to load data into rcv shipment headers, rcv shipment lines and rcv transaction base tables.
• Created different Alert Email Notifications (Periodic) to notify end users about failure of any outbound file generation using Alert Manager Responsibility.
• Developed and customized PL/SQL programs, functions, procedures and triggers.
• Developed Approved Supplier List report, Final Assembly Schedule Report from the scratch according to business requirement.
• Customized BOM Explosion Report, Invoice on Hold Report, Packing List Change Report, Pick List Change Report and several other reports according to requirement.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Designed and documented the technical specifications of an Interface (MD70) using the available functional specification (MD 50)

Environment: Oracle Apps 11.5.10.2, OM, INV, PO, BOM, WIP, Oracle10g, TOAD, PL/SQL, SQL*LOADER, Reports 6i.

Confidential, Duluth, GA

Oracle Apps Technical Consultant

Responsibilities:

• Designed and customized various Oracle reports in OM, AR, and GL.
• Customized the standard reports in AR module like Aging by Account, Dunning History and Billing History.
• Worked on XML Publisher for generating reports.
• Worked extensively in various RICE components.
• Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
• Dealt with registering / defining of custom applications, tables, reports, concurrent requests, standard report submission etc and also with profile options, defining of application users and responsibilities.
• Developed packages containing different procedures and functions using PL/SQL.
• Involved in post production support and enhancements of RICE objects in all three phases of project.

Environment: Oracle Apps R12, GL, AR, INV, OM, AOL, Oracle9i, TOAD, PL/SQL, SQL*LOADER, Forms 6i, Reports 6i.

Confidential, Schenectady

Oracle Apps Technical Consultant

Responsibilities:

• Design and developed the changes using Oracle Forms, PL/SQL through minor enhancements, bug fixes, Form personalization.
• Developed AP interface to import invoices from staging tables to AP open interface tables.
• Worked on GL interface to import journals from legacy systems into GL interface tables.
• Designed and developed Invoice rejection report, Active supplier list report, purchase order reports.
• Worked on Oracle reports to serve the business needs.
• Designed and built new database views and tables.
• Developed and customized PL/SQL programs, functions, procedures and triggers.
• Worked on performance tuning of complex queries, functions, procedures and packages.
• Worked on interfaces and SQL packages to import data from external system like IBS (Internal Billing System), VFS (Vendor Financial Systems into Oracle AP standard tables.
• Unit testing of the components.
• Interacted with business units to understand their needs.
• Developed custom interfaces to import data from legacy systems into the Apps tables.
• Worked on System Administrator and Application Developer responsibilities.
• Worked on SQL queries with analytical functions.
• Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Forms, Concurrent Requests, Request Sets, Concurrent Programs, Value-sets and defined Flex Fields.
• Provided post-production support to the users.
• Debugging the issues and applying the necessary fixes.

Environment: Oracle Apps 11.5.10.2,AP,GL,PO, Oracle 9i, SQL, PL/SQL, Forms&Reports 10g, Toad, Unix.

Confidential, IL

Oracle Apps Technical Consultant

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Interfaced data from the Flat Files into Interface tables of Accounts Payable using SQL*Loader and executed the Payable Open Interface Import Program to generate invoices.
• Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard item import program through a custom package that validates individual records.
• Developed Pick confirm and Ship confirm Interface using oracle API’s.
• Involved in rewriting some of the existing custom interfaces in PL/SQL to reduce the turnaround time of execution and completion of concurrent processes.
• Developed code to import costing data of items imported from flat files to Costing tables directly.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO)
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces
• Transferred GL Account Balances from legacy system
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications.
• Involved in customization of reports in PO, AR and AP, such as Printed Purchase Order Report, Aging 4 Bucket Report, etc using Reports6i and XML/BI Publisher
• Used UTL FILE facility for inbound and outbound interfaces
• Implemented performance tuning in the application program to enhance the speed by utilizing Indexing SQL HINTS and Materialized Views.

Environment: Oracle Applications 11i, GL, AP, AR, INV, PO, PL/SQL, Oracle 7.3, Oracle Reports, SQL *Loader.

Confidential

Oracle Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL Procedures and Functions.
• Created Custom Staging Tables to handle import data.
• Created custom triggers, stored procedures, packages and functions to populate different database.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Developed PL /SQL code for updating payment terms.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Design, Development and testing of Reports using SQL*plus.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancement on oracle application.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, MS- Office, Windows NT 4.0/2000/XP Windows 2000.

Confidential

Oracle developer

Responsibilities:

• Interacted with end users for gathering requirements.
• Perform database tuning, monitoring, loading and back up.
• Used SQL loader to load data from csv files into Oracle tables.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed SQL for loading metadata from Excel spread sheet to the database using SQL Loader.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Developed SQL script for loading data from existing MS Access tables to Oracle.
• Create record groups for manipulation of data, Perform unit and system integrated testing.
• Involved in database design, development of database, tables and views.
• Involved in application testing, deployment and production support.

Environment: Oracle 8i, PL/SQL, TOAD, SQL*Loader, MS Access, Excel spread sheet, Windows NT.