SUMMARY

• 8 years of technical experience in Oracle Applications with excellent knowledge in SQL, PL/SQL, Financials, Manufacturing, XML/BI Publisher, Discoverer, Work Flow, Oracle Forms & Reports.
• Expertise in Application Development and Customization, open Interfaces and Conversions, Development of Forms (Version 10g/9i/6i/4.5), Reports (Version 10g/9i/6i/2.5), Discoverer (version 4i/9i/10g), XML/BI Publisher reporting tool and Workflow Builder.
• In depth technical knowledge in flow of Oracle Accounts Payable, Accounts Receivable, General Ledger, Order Management, WEB ADI, Inventory and Purchasing.
• Experience in setup, customization, interface programming and concurrent programs.
• Extensive experience in data conversion from legacy systems to Oracle Applications.
• Proficiency in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Extensive experience in Order - to-Cash and Procure-to-Pay process with full life cycle implementation.
• Experience in designing and executing test cases and test plans based on business requirements.
• Good Knowledge in Trading Community Architecture (TCA) APIs to import data from legacy systems to Oracle Systems.
• Good Experience in designing, developing and troubleshooting Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Proficient with Discoverer & XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• In depth at working with diverse technical groups and global customers to develop technology solutions that meet or exceed expectations.
• Worked as an active team member in implementing ERP solutions using Oracle Applications.
• Strong analytical, diagnostic and problem solving abilities.
• Functional and Technical understanding of Oracle Applications including underlying table structures and database procedures and APIs.
• Flex fields: Good Knowledge of Flex field’s structure in Oracle Apps.
• Interfaces: - Designed & Developed interfaces for INV, OM, PO, Shipping, GL, Payables, Receivables Modules.
• Conversions: Extensively created mappings and conversions in Oracle Apps to import the data after validations in to ERP.
• Migration: Involved in Migration & Upgradation of data from Oracle Apps ver. 11. .
• Oracle On-Demand: Involved in development of E-business CEMLIs as per Oracle On-demand standards and compliance to Quality.
• Testing: Very good testing knowledge of Oracle Manufacturing(OM,PO,INV) & Financials(AP,AR,GL)
• Tuning: Extensive experience in Optimization (Tuning) of the Applications at the application level as well as the DBA level.
• Backend: Extensive Experience in Creating Triggers, Packages, Procedures, Functions using PLSQL.
• Client Interaction: Interaction with Clients\Business to identify the business practices, future requirements, identifying the gaps and designing alternate solution.

TECHNICAL SKILLS

Oracle Applications: Oracle Financials E-Business suite R12/11i, AOL, Sys.Admin.

RDBMS: Oracle 8i/9i/10g, MS Access, SQL Server 7.x, 2000.

Application Tools: Forms 9i/10g and Reports 9i/10g, Discoverer 9i/10g, TOAD, SQL Navigator, SQL*Loader, SQL*PLUS, XML/BI Publisher.

Utilities: Rational Clear Case, Clear Quest, export/import, Winscp, Putty, Humming bird.

O/S: UNIX, Windows NT/XP/2000/98, Linux, MS-DOS.

Languages: SQL, PL/SQL, C, C++, HTML, XML.

Scripting Languages: UNIX shell script.

PROFESSIONAL EXPERIENCE

Confidential, Irvine,CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the development of RICE components in Oracle OM, QP, INV, PO, AP, AR in EBS Suite.
• Worked on Party and Customer Account creation and Management for ATG web store Order Transaction through Oracle Public API to effect the HZ tables in TCA.
• Developed PL/SQL Packages, procedures and functions for validating the order information received from the legacy system and importing them into Oracle Applications using Order Import API, which populates the base tables.
• As Part of 3rd Party Process, I have loaded Items, Pricelists, Price Catalogs and Item Costs.
• As Part of 3rd Party Process, Created Discoverer report to Show latest information related to the Parts and uploads them to EBS also created a Trigger to update cost, price when ASL status changes to Approved for the respective supplier.
• Customized OEOH Workflow for ESP classification Event as part of Pre Booking validation for 3rd Party parts.
• Worked on Order Settlement process through AR receipt creation and closure.
• Worked extensively on customizing existing forms appearance, validation logic, behavior and incorporating new functionalities to the existing forms like Warehouse Stock Status enquiry, Customer Creation, Credit Review form etc and Tested and Fixed bugs in existing forms & reports.
• Worked on Custom AR Report AR Invoice Print To Billtrust using Oracle Reports Builder 10g.
• Customized existing custom oracle reports to replace plain text output to PDF format using XML/BI Publisher.
• Created several Business Areas in Discoverer and based on the Business Areas, created many number of discoverer workbooks on OM, AR modules.
• Created ldt files to migrate the Concurrent Programs/Value sets/ Request sets/Lookups to other instances.
• Worked on event based Oracle Alerts as per the business requirements.
• Designed and developed custom packages, triggers and procedures.
• Tested and Fixed bugs in existing forms & reports.
• Created the database schema objects like tables, views, synonyms, indexes, procedures, and functions.
• Designed and documented the technical specifications of an Interface (MD70) using the available functional specification (MD 50).
• Used UTL FILE utility to create a file and to read the file from the server.?
• Worked on JIRA and AdTask for corporate documentation and SVN for version control.
• Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML/BI Publisher.
• Extensively used Advanced Collections (Bulk collects, For ALL) to improve the performance of the system.

Environment: Oracle Apps R12.1.3, AR, AP, PO, OM, INV,QP, Oracle 10g, SQL, PL/SQL, TOAD, Workflow Builder, UNIX, Reports 10g, Forms 10g, Alerts, Discoverer 10g.

Confidential, WA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the development of RICE components in Oracle AP, AR, PO, GL in EBS Suite.
• Developed PL/SQL Packages, Procedures and Functions for validation of the invoices and payment information from the legacy system to import into Oracle Application.
• Developed an Interface in Purchasing to transfer all open PO information to 3rd party legacy system.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the legacy data into the staging tables. Performed data validations and mappings at staging table level.
• Customer & Invoice data Conversion from Legacy System into Oracle Account Receivables (AR) by using Customer and Auto Invoice interface.
• Developed new program in PL/SQL and Modified old programs for Payables Open Interface (AP) to import invoices from two different sources. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND REQUEST API to submit concurrent programs from PL/SQL programs.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Developed AR Invoice Print Report using XML Publisher to generate invoices based on different tax criteria.
• Customized GL daily Rates report, Aging Report, Invoice History Report using XML Publisher based on the requirement.
• Developed new Custom report like Liability Report, Aging Summary and Payment Detail Reports etc.
• Designing and developing Developer Payment Form which enables them to make payments and other actions as per the requirements.
• Designing and developing Developer Onboarding Form to enter and maintain the Company, Owner as well as bank information of the Developer, as well as creating a custom DFF on custom form.
• Good working experience in customization of forms using Forms personalization and custom.pll according to the requirement.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating Indexes.
• Created concurrent programs, value sets, lookups and fnd messages.
• Created programming code using advanced concepts of Records, Collections and dynamic SQL, Bulk Binds and Table Types.
• Developed Customized PL/SQL Packages, Procedures and Triggers to accommodate the Changes to the Existing Manufacturing / Financial Business Application as per client requirements.
• Developed UNIX shell scripts for coping and moving files to and from the Oracle server.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Performed Unit & System testing for the developed Components.

Environment: Oracle Apps R12.1.3, AR, AP, PO, GL, TCA, Oracle 10g, SQL, PL/SQL, TOAD, UNIX, Reports 10g, Forms 10g, Alerts, Discoverer 10g, SQL * Loader, XML Publisher

Confidential, WA

Oracle Apps Technical Consultant

Responsibilities:

• Involved in the development of RICE components in Oracle Inventory, Purchasing, Order Management, Account Receivables, Account payables.
• Developed a Custom Interface in Order Management that accomplishes Ship Confirm, Ship Correct, Receipt, and Receipt Correct Processes using APIs against the feed from WMS.
• Developed a Custom Interface (Which will host the receipt data) is being built as part of project called ‘CEEOT’ to tag along the existing status updates to external system. The Source of the receipt data will be ALC.
• Analyzed functional Documents and Prepared Technical design documents and Data mapping documents for importing Purchase Orders and Payables interface and loaded data into base Tables.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Used Desktop Integrator (WEB ADI) to import excels data to lookup’s table.
• Created database objects like tables, views, synonyms, indexes, triggers, materialized views and sequences.
• As a technical consultant, responsible for communicating to Business analysts, Requirements analysis, Coding, Testing, QA, Change Management, support of the Customizations and application extension.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating Indexes.
• Created concurrent programs, value sets, lookups and fnd messages.
• Developed PL/SQL procedures and used SQL*loader to transfer data from Legacy systems.
• Designed and customized On-hand Quantity reports using Oracle Reports Builder 10g for INV.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context using forms personalization.
• Involved in the design and development of Forms using Oracle Forms 10g.
• Created programming code using advanced concepts of Records, Collections and dynamic SQL, Bulk Binds and Table Types.
• Modified existing RDF report to excel format using XML/BI publisher.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developed Customized PL/SQL Packages, Procedures and Triggers to accommodate the Changes to the Existing Manufacturing / Financial Business Application as per client requirements.
• Developed UNIX shell scripts for coping and moving files to and from the Oracle server.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Provided support and fixed issues during testing of the products and after go live.

Environment: Oracle Apps R12.1.3, AR, AP, OM, INV, PO, TCA, Oracle 10g, SQL, PL/SQL, TOAD, UNIX, Reports 10g, Forms 10g, Alerts, Discoverer 10g, SQL * Loader, XML Publisher.

Confidential, CA

Oracle Apps Technical Consultant

Responsibilities:

• Worked on Sales Order creation using the Process Order API.
• Developed PL/SQL programs using TCA API’s to validate and import customers from legacy system into base tables.
• Involved in Pick Release process, Pick Confirm process and Ship Confirm process during Shipping Execution process using standard shipping API’s.
• Involved in understanding the Confidential System Architecture of Oracle Apps connected with Legacy Systems.
• Used SQL*Loader and PL/SQL for complete validation of data and used the standard concurrent program for integrating into Oracle Applications.
• Customized Sales Order Acknowledgement report in Order Management (OM) module as per Clients requirements.
• Involved in the development of RICE components in Oracle Inventory, Purchasing, Order Management, Bill of Material.
• Created a custom XML Publisher PDF report for Order Acceptance using XML Publisher to include the sales order, pricing data from OM, and customer details from TCA and include company logos, Terms and Conditions.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Designed a custom XML Publisher report for Standard Purchase Order Report to include the company logo, short and long text attachments.
• Extensively used FNDLOAD utility to Download Concurrent Programs, Responsibilities, Lookups, Flex fields, Value sets, Request Sets, Request Groups, Menus, Forms Personalization, Profile Options, Printer styles into ldt files and written a shell script to upload them to another instance.
• Registered Customized reports in AOL and System Administration.
• Created and registered new concurrent programs as well as executables when new reports were created.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating Indexes.
• Extensively used Advanced Collections (Bulk collects, For ALL) to improve the performance of the system.
• Involved in feature enhancements and bug fixes.
• Involved in analyzing the existing concurrent programs/packages and setups.

Environment: Oracle Applications R12/11I, OM, PO,BOM and INV, UNIX, SQL*Plus, PL/SQL, TOAD, Reports 10g, Forms10g, XML/BI Publisher, SQL*Loader, AIM.

Confidential, WA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed SQL*Loader scripts to import the data from the csv files sent from the legacy system into the staging tables in Oracle.
• Scripted PL/SQL packages and procedures to validate the data on the staging tables and load the data into Oracle interface tables.
• Used seeded Oracle interface programs (Journal Import) to import journals into GL.
• Developed interface to get the Customer Details and Receivable Invoices from the legacy system to Oracle Accounts Receivables (AR).
• Customized the Oracle standard API’s (Customer Interface and Auto Invoice Master Program) to import the customers and invoice data from the interface tables to Oracle Base tables.
• Performed Extensive Application tuning for Order to Cash Business process
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Creation of ldt files to load Executables, Concurrent Programs and Request sets from one instance to other instance.
• Involved in development of custom reports and forms for AP, AR, GL, OM and INV modules.
• Created several Business Areas in Discoverer and based on the Business Areas, created many number of discoverer workbooks on OM, INV and AR modules.
• Used Microsoft Word to create an RTF template with all the required data fields and registered the formatted template in XML/BI Publishers Template Definition.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and using indexes
• As a technical consultant, responsible for Communicating with the end users, Requirements analysis, Design (MD070), Coding, Testing, QA, Change Management and support of the Customizations and application extension.
• Worked with technical, functional teams to troubleshoot and resolve issues.

Environment: Oracle Applications R12/11i, GL, AP, AR, PO, OM and INV, UNIX, SQL*Plus, PL/SQL, TOAD, Reports 10g, Forms10g, Discoverer 10g/9i/4i, XML/BI Publisher, SQL*Loader, AIM.

Confidential, Chicago, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Used custom SQL*loader program to load the invoices from other accounting systems to payables staging tables.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PO interface to import Purchase Orders from legacy systems.
• Customer & Invoice data Conversion from Legacy System into Oracle Account Receivables (AR) by using Customer and Auto Invoice interface.
• Developed GL Interface for importing journals from legacy systems into GL INTERFACE table.
• Conducted Interface Testing (Customer Interface and Auto Invoice in AR, Order Import in OM) of application and reported the defects to the development team.
• Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
• Developed interface to update On Hand Quantity for the items upon receiving Shipment Receipt.
• Worked on XML/BI Publisher bursting to send PDF reports via email.
• In XML/BI Publisher created a data definition from generated XML.
• Created an RTF template with XSL equivalents to group data as of date placed in service and registered to Template definition.
• Designed reports in Discoverer based on the business requirements in AP, AR, and GL modules.
• Customized and developed several reports in AR, AP, OM modules using Reports 9i.
• Customized reports using Reports 9i like Customer Detail/ summary and Aging Bucket reports to suitthe requirements of customers .
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Prepared MD70 document for inbound interface.
• Analysis of customer reported issues, which could be a code issues, data fix issue, performance issue.

Environment: Oracle Applications R12/11I, Unix, SQL*Plus, PL/SQL, TOAD, Reports 9i, Forms 9i, Discoverer, XML/BI Publisher, SQL*Loader.

Confidential, Atlanta, GA

Oracle Apps Technical Consultant

Responsibilities:

• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Developed new program in PL/SQL and Modified old programs for Payables Open Interface (AP) to import invoices from two different sources. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND REQUEST API to submit concurrent programs from PL/SQL programs
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Created triggers to apply the holds to the Orders on change of statuses & triggers to release the holds.
• Established setups to proceed with the customizations & developed data conversions.
• Created custom packages to return the Order Status on an hourly basis to an indirect customer and on a daily basis to a direct customer and attached them to the concurrent programs.
• Created PL/SQL procedure to copy the given drop ship sales order to Standard sales order and to create the ship sets for the standard order.
• Created a database trigger to populate purchase orders descriptive flex field with drop ship order number and legacy system order number if the purchase order is a drop ship purchase order.
• Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders, RMAs.
• Extensively worked on GL, AP, AR and Fixed Assets modules in automating the closing process.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Used SQL *Loader and UTL FILE Packages for data conversion and interfaces.
• Used Template, sub Template method for a creating single report with multiple Layouts using XML Publisher.
• Used the Totals/Subtotals/group/sort features of XML Publisher/BI Publisher to make data intense operations happen at the template level.
• Involved in Oracle Discoverer installation and Configuration and Oracle Discoverer Administration, Creating EUL Schemas, Discoverer Classes and EUL user Administrations etc.
• Wrote UNIX Shell Scripts for coping and moving files to and from the server.
• Developed a PL/SQL program that is scheduled to submit concurrent programs in a desired sequence as per the functional document. Used standard fnd API.
• Involved in design of AIM (Application Implementation Methodology) document MD050 and MD070.
• Involved in post production support and enhancements of RICE objects in all phases of the project.

Environment: Oracle Applications R11i/R12, LINUX, SQL*Plus, PL/SQL, TOAD, Reports 9i, Forms 9i, Discoverer 10g, SQL*Loader.

Confidential, CA

Oracle Application Technical Developer

Responsibilities:

• Created a Concurrent Program to call the Database Package and also the procedure to load the data from the staging table to the gl interface table
• Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate table GL DAILY RATES INTERFACE.
• Run the Journal Import process to load the data from the gl interface tables to the General Ledger base tables.
• Created an interface to import Order Management data from the legacy system to Oracle Order Management. Used SQL Loader and PL/SQL packages to load and validate the data
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL SYSTEM ITEMS table.
• Developed new ftp and SQL loader programs for Auto invoice interface. Developed a request set to ftp, load custom tables, purge auto invoice interface and load auto invoice tables
• Developed PL/SQL and SQL scripts to Transfer Data to non - Oracle systems such as the Intranet, trading partners, data related to payments, invoices, PO’s and Items.
• Provided the users with detailed vendor reports on existing vendors from legacy system.
• Customized suppliers audit report, expected receipts report, contract status reports.
• Resolved complex report issues such as formatting, PDF output, parameters and exceptions.
• Removed the dependency of the printer to generate an XML output for the print statement form (AR)
• Writing UNIX Shell scripts and commands for file management, job automation and administration tasks.
• Documented detail designs for reports that were being developed and customized for company’s custom format.

Environment: Oracle Applications 11i, Oracle 9i, Forms 6/9i, Reports 6i/9i, SQL*Loader, Report Builder, Forms Builder, XML Publisher, Discoverer 4i and UNIX.

Confidential, Atlanta, GA

Oracle Application Technical Developer

Responsibilities:

• Migrated the existing reports and developed new reports as per business requirements using Oracle Reports.
• Actively involved in ongoing day to day Production Support activities / issues and providing problem resolving solutions to Tickets.
• Responsible for implementation of RICE (Reports, Interfaces, Conversions, Extensions) elements in Oracle EBS 11i environment.
• Developed interfaces like Inventory interface, Items interface, Categories interface, OM interface, Receiving Open interface and using OM, Shipping, Inventory, Installed Base APIs.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Imported data from flat files located in legacy system into database table using SQL * Loader. Designed temporary interfaces to view the loaded data. This data existed in the form of spreadsheets and access database.
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Reports 10g).
• Used PL/SQL to validate data and to populate billing tables.
• Created and manipulated stored procedures,functions, packages and triggers using TOAD 9.5.
• Involved in migrating database from oracle 9i to 10g database.
• Developed Forms and Reports using Oracle Forms and Reports 6i.
• Used Discoverer to support querying, reporting, and the graphical multidimensional analysis of the central Repository. Mainly performed graphical representations and drill-down features.

Environment: Oracle E-Business Suite 11i, AP, AR, PO, GL, OM and INV, Oracle 9i/10g, PL/SQL Developer, UNIX, Windows 2008, Forms builder 6i, Reports Builder 6i, HTML, SQL * Loader, SQL Navigator, Oracle Discoverer, QTP, Toad.

Confidential, MN

Oracle Applications Developer

Responsibilities:

• Designed technical directions for implementing the reports and documenting them into MD070
• Designed, created and maintained and Discoverer End User Layer.
• Developed several Oracle Discoverer workbooks using Discoverer Admin, Discoverer Desktop and Discoverer Viewer.
• Created custom responsibilities, menus, and functions using System Administrator.
• Developed reports using Oracle BI Discoverer, Reports Builder 6i.
• Designed and developed custom forms using Template.fmb.
• Worked on AP Conversions, loading the Vendors and Open Invoices.
• Worked on AR Interfaces(Transactions and Receipts) from AS400 to Oracle AR.
• Customized the form functionality using form personalizations.
• Used FNDLOAD to move concurrent programs, menus, and forms personalization between instances.
• Defined the descriptive flex fields on sales orders, and Invoices forms to facilitate additional information.

Environment: Oracle E-Business Suite 11i, AP, AR, PO, GL, OM and INV, Oracle 9i/10g, PL/SQL Developer, UNIX, Windows 2008, Forms builder 6i, Reports Builder 6i, HTML, SQL * Loader, Oracle Discoverer, QTP, Toad 9.5.

Confidential

PL/SQL Programmer

Responsibilities:

• Responsible for creating and modifying the PL/SQL procedure, function according to the business requirement.
• Used SQL LOADER to upload the information into the database tables.
• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Extensively analyze the security holes in the PLSQL. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file’s of the Sql*loader.
• Created and used XML for data management and transmission.
• Worked extensively on C for low level programming and embedded work.
• Involved in analysis, design, coding and Testing.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• UNIX Shell Scripting to automate procedure execution from UNIX box.

Environment: Oracle 8i/9i, Oracle Forms/Reports 6i, SQL, PL/SQL and HTML.