SUMMARY:

• Over 8 years of experience in Designing, Developing, Converting, Implementing and Upgrading of Oracle Applications R12/11.5.10/11i/10.7 using ORACLE 8i/9i/10g, SQL, PL/SQL, Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/10g.
• Extensive experience in Implementation, Migration, Customization, Production and Support of Oracle Receivables (AR), Oracle Payables (AP), Oracle General Ledger(GL), Order Management/Order Entry (OM/OE), Oracle Inventory (INV), Oracle Purchasing (PO), Application Object Library (AOL), System Administration modules of Oracle Applications.
• Experience with RICE components.
• Experiences in tables, Indexes creation, Roles, user setups and security.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Worked extensively in Application development using Forms and Reports 6i, Discoverer 4i, SQL, PL/SQL in Client Server architecture using UNIX/ LINUX/ Windows.
• Proficient in Data conversions between Modules via interfaces and APIs, using stored procedures, functions, packages and triggers.
• Experience in OA Framework Development (OAF).
• Have a fair knowledge on ELECTRONIC DATA INTERCHANGE (EDI).
• Expertise in handling XML PUBLISHER in customizing reports.
• Experience in customization of XSL - FO templates.
• Developed PL/SQL procedures and used SQL*loader to transfer data from Legacy systems.
• Very well versed with PVCS (Version Control Systems) and Migration Tools such as Kintana.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers.
• Use and development of FND API’s like FND PROFILE, FND SUBMIT, FNDLOAD. Also wide use of Oracle Apps features like Flexfields, Security, Menus, and Functions
• Exceptional problem solving and analytical skills, highly motivated and positive oriented, excellent verbal, written, communication and presentation skills.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments.

TECHNICAL SKILLS:

Applications: ORACLE FINANCIALS R12/11i - Oracle General Ledger, Accounts Payable, Accounts Receivable, Oracle Inventory, Oracle Order Management, Oracle Assets, Oracle Purchasing, Cash Management.

Oracle Manufacturing/Distribution: Inventory, Purchasing, Order Management

Oracle CRM/Service: Install Base, Service Contracts

Oracle AOL: Architecture and Data Model, Concurrent Processing, Registering of Forms/ReportsTools: Developer 2000 Forms 4.5i/6.0i, Reports 2.5i/6.0i, Oracle Discoverer 3i/4i, BI Publisher, SQL Navigator, SQL*PLUS, SQL LOADER, TOAD.

Data Base: ORACLE 8i/9i/10g, Microsoft Access 2000/XP, Sybase, SQL Server 2000.

Programming Languages: C, C++, SQL, HTML, XML, PL/SQL, Java, UNIX Shell Scripts, BI, DW (Data Stage), Pro*C.

PROFESSIONAL EXPERIENCE:

Confidential, CA

VISA INC Development

Responsiblities:

• Responsible for collecting business requirements for new Implementation, Conversion and Interfaces then converted them into Functional and technical design documents. Involved in Unit and System Testing, UAT support and finally migrate the new component into production.
• Developed a new inbound interface for importing payable invoices from legacy system to oracle apps in R12.
• Designed and developed OBIEE reports as per business requirement.
• Designed, developed and tested the Supplier Sites deactivation program based on specified business rule.
• Developed customized UNIX shell scripts used to provide additional monitoring of production servers staging data.
• Customized the customer Statement generation program as per business requirement using Oracle Reports, XML publisher and XML bursting.
• Customized the Sales Order Acknowledgement program as per business requirement using Oracle Reports, XML publisher and XML bursting.
• Involved in Conversion from Legacy to Oracle. Designed, developed and tested Supplier Conversions, Payable Transactions and Payable Payment Format Programs as per EBS R12 and Client requirement.
• Tuned the various customized concurrent programs, Reports, used Procedures, Cursors and Functions to optimize the application process execution time.
• Designed / Developed and Tested PL/SQL Packages and Oracle Reports according to the timelines specified. Actively debugged the PL/SQL code to resolve errors encountered in various test phases.
• Provided the maintenance and testing support for the Project whenever required.
• Prepared RIPE components (Re-usable components) for both conversions and migrations of various apps components.

Confidential

Oracle Applications Technical-Consultant

Responsibilities:

• Designed and developed interface programs to extract orders from custom web application objects, populate to staging table, validate the data in staging table and send to interface tables.
• Importing Orders from Legacy EMP to Oracle includes the following interface programs EMP Interface Control,Order defaults and substitution,Order Import,Change Order Import.
• Used standard Oracle OE ORDER PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System.
• Used standard Oracle OE HOLDS PUB API to apply/release holds on the sales order created.
• Developed the below Custom reports using Reports 10g as per the client requirements in OM module Consolidated Pick Slip,Packing Slip,Daily Inventory Report,Shipping Exception Report,Item Label Report,Bill of Ladding Report.
• Form Personalization Tasks
• Pick Release Form: Not allow selection/insert/update of the organization field.
• Copy flags when copying sales orders: Allows picking and choose which sales order elements are copied along with the order.
• Customized the existing forms as per the client requirement.
• Workflow Customization Seeded OM Workflows are copied and customized to create Ship only Workflow. Workflow notification for Sales Order will be triggered at the launch of Sales Order “Book” event and an email notification is sent to the concerned.
• Dealt with registering / defining of custom applications, tables, concurrent requests, standard report submission etc and also with profile options, defining of application users and responsibilities.
• Created and used stored procedures, packages, cursors and functions to do the validations on the legacy data.
• Modified the existing code to meet the new business requirements. Interact with the Business users and analyze new business requirements or enhancements or change requests and prepared Functional/Technical Design documents.
• Involved in design of functional setups in Order Management.
• Responsible for Functional testing and Process setup.
• Created indexes to enhance the performance of the applications.
• Involved in recoding some of the existing custom interfaces in PL/SQL to reduce the turnaround time of execution and completion of concurrent processes.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all conversion and reports.

Environment: Oracle EBS R12, SCM (OM, INV, PO, WMS), PL/SQL Developer, SQL*Plus, TOAD, PL/SQL, SQL*Loader, Reports 10g, Forms 10g, Workflow Builder.

Confidential, Pittsburgh, PA

Oracle Apps Technical Consultant

Responsibilities:

• Involved in design, development & implementation of Oracle Application modules. Modules include OM, INV, Purchasing, GL, AP, AR, FA and Project Accounting.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system
• The development included the conversion of the data (Budget Upload) from legacy systems to the oracle database and also creating the custom reports for the client
• Writing stored procedures for loading orders to INV material Interface tables and running Item Imports.
• Involved in OTC and P2P business flows.
• Using OM APIs PL/SQL was written to do the validations and write into oracle tables directly. It is an inbound Interface.
• Worked on Order Import interface in OM.
• Customized the PO STANDARD XSL-FO Template in order to print LOGO, custom messages, dollar signs and other customization on the PO document according to the business requirement.
• Worked Extensively on Discoverer 9i/10g Admin, Desktop and Plus Editions to develop various reports in GL, AP, AR, OM and INV modules.
• Created Business Area’s and Custom Folders in Discoverer Admin version.
• Created APPS mode EUL and enabled seeded Business Areas and workbooks.
• Customized Reports in Purchasing like Buyer’s Requisition Action Required Report, Expected Receipts Report and Uninvoiced Receipts Report using Reports 6i.
• Customized Reports in FA like Cost Detail Report and Journal entry Reserve Ledger Report.
• Developed and Customized Reports using XML Publisher like AP Invoice Aging Report, Tax Audit Trail Report, Matching Detail Report.
• Developed On hand Inventory Value Report to report the quantity and cost of on hand inventory.
• Worked on Vendor, Invoice Conversions in AP and Customer, Invoice Conversions in AR.
• Developed a package to import vendor information into purchasing base tables
• Worked on Check Printing, AP Accrual Reconciliation Report, Payment Register Report, Invoice Aging reports for payables to accomplish customization according to business requirements.
• Customized Transaction Register Report, Invoice Aging Report in receivables according to user requirements to group the invoices at different levels.
• Used SETPARAM.GETPARAM Function in custom folder
• Involved in Customization of reports using Discoverer 10g.
• Created MD-50, MD-70 and MD-120 for all the requirements.

Environment: Oracle Applications 11i (GL, AP, AR, FA), Database 10g, UNIX, TOAD, SQL*Plus, SQL*Loader, PL/SQL, Discoverer 10g.

Confidential, Pittsburgh, PA

Oracle Apps Developer

Responsibilities:

• Designed and Developed Custom Reports for Quote to order Conversion, Closed PO Report,Sales Analysis Report, etc.using Discoverer 10g.
• Involved in Production Support for the Tickets raised, Change requests and Enhancementsfor Discoverer Reports.
• Designed and developed Invoice print Reports, PO Print Report using XML Publisher.
• Development includes interface and conversion of data from legacy systems to the Oracle database.
• Developed SQL*Loader and PL/SQL programs as a part of the development.
• Validated and interfaced AP Invoice information from Legacy system into Oracle.
• Validated and interfaced GL Journal information from Legacy system into Oracle.
• Developed a Custom program to assign Items from Master Organization to OtherInventory Organizations based on hierarchies.
• Developed a Custom Utility Program, which is used by multiple programs, to derive DivisionName, Address, etc.
• Involved in Forms Customizations. Added Validation Logic in the triggers on custom forms.
• Customized the Requisition Account Generator Workflow to populate one of the segment valuesBased on business requirements.
• Interacted with end users to gather requirements and draft specifications for the development phase.
• Created MD-50, MD-70, MD-120 and Unit Test Plan for all the above requirements.
• Involved in preparing User Manuals for Oracle Standard and Custom Reports.

Environment: Oracle Applications 11.5.10, IBM - UNIX, Oracle 10g, SQL, PL/SQL, SQL*Loader, Reports 6i, Discoverer 10g, XML Publisher and AOL.

Confidential, Texas

Oracle Apps Technical consultant

Responsibilities:

• Developed Customer Interface, Auto Lockbox Interface and Auto Invoice.
• Developed a feeder program to load external data from legacy system using SQL*Loader.
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Used Customer Interface to transfer and validate Customer data from legacy system into AR.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data & Customer Bank data.
• Used SQL*Loader to import receipt data into AR Payments Interface table after defining Lockbox, and Transmission Format and running Lockbox interface form transferred data into Oracle Receivables.
• Imported AR invoices through ELECTRONIC DATA INTERCHANGE (EDI).
• Involved in the design, development, and import of invoice information into Oracle Receivables.
• Customized reports in GL like Trail Balance (Assets & Liabilities, Expenses & Revenues).
• Worked extensively in production support Issues in Oracle Receivables and Payables.
• Worked with Administration Edition of Oracle Discoverer. Created layer of metadata for End User Layer for hiding the complexity of the database from the users, created various business areas, user views, custom folders and joins for reporting.
• Worked with User Edition of Oracle Discoverer, developed various financial analysis reports (for all modules) written for AP, GL and AR.
• Used XML PUBLISHER to develop customer order status report and credit hold reports.
• Customized multiple reports and forms in AR, AP and OE modules according to the requirements.

Environment: Oracle Applications 11.5.9, Sun Solaris - UNIX, Oracle 9i, SQL, PL/SQL, SQL*Loader, Reports 6i, Discoverer 4i, Oracle Applications 11.5.9, AOL, GL, AR and AP.