SUMMARY

• Over 8 years of experience as Oracle EBS Techno - Functional Consultant in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12.
• Implementation and technical expertise in Oracle Applications R12/11x, across teh Discrete and Financials Modules such as Payables (AP), General Ledger (GL), Order Management (OM), Receivables (AR), Manufacturing Modules, Purchasing (PO), Inventory(INV), iExpenses, Cash Management (CM), Fixed Assets (FA), Advanced Pricing (QP), Shipping (WSH) and System administration (AOL).
• Good knowledge in Multiple Reporting Currencies, MOAC, Trading Community Architecture (TCA).
• Experience in Manufacturing, CRM, SCM and Distribution domains.
• Experience in designing, coding, testing custom applications wif an integration to Oracle Applications or other custom applications.
• Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers
• Expertise in implementing RICE components (Reports, Interfaces, Conversions and Extensions) in areas of design, development, Integration and deployment.
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, functional design, technical design, Coding, Testing, Quality assurance Documentation, Implementation, Maintenance and support of enterprise business applications
• Experience in Application Object Library (AOL) for registration of Interfaces, Forms, Reports, Concurrent Programs, Value Sets and Menus
• Experience in designing, developing and testing of inbound and outbound Interfaces of various entities including, Journals, Payables Invoices, Suppliers, Customers, Sales Orders, POs, Employees, etc.
• Experience in developing and customizing Oracle Reports using Oracle Reports 10g/6i in GL, AP, INV, OM, AR and PO modules as per business user requirements.
• Experience in developing custom Oracle Forms using Oracle Forms 10g/6i.
• Used CUSTOM.pll to customize and personalize teh standard oracle Forms.
• Experience in customizing Oracle workflows such as teh PO Approval process, Order/Line Flow to send user notifications based on teh business requirement.
• Experience in converting teh standard Oracle reports to readable XL reports using XML publisher. Extensively worked on XML Publisher for Payment templates registration, Custom Check template development, Remittance advices and other reports.
• Expertise in building Reports using Discoverer 10g/4i working on Administrator and Desktop Editions. Developed Business Areas, custom folders, complex Work Books and shared as per teh user requirement.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Experience includes exposure to all teh phases of Software Development Life Cycle.
• Prepared Technical Design Documents MD70s for customizations and CV40s for conversions using AIM documentation methodology.
• Experience wif QA Methodology and QA Validations to ensure teh Quality Assurance Control.
• Experience in Onsite - Offshore model wif experience leading a team and project management activities like Estimates, Delivery of RICE components to onsite client
• Excellent problem solving skills wif an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS

ERP Applications: Oracle E-Business Suite R12(12.0.3,12.0.4,12.0.6,12.1.3,12.1.4)/11i(11.5.9,11.5.10,11.5.10.2)

Database Tools: SQL *Plus, SQL * Loader, Toad, SQL Navigator

Databases: Oracle 11g/10g/8i/9i, SQL Server 6.5/7.0/2000

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Oracle Workflow Builder 2.6.3.5, XML Publisher, Oracle JDeveloper

Other Languages: C/C++, Java, XML, HTML

Documentation: MD070, MD050, CV60, CV40

Operating Systems: Unix (Shell Scripting), Windows XP/2003/2007, DOS, Mac OS X

Other Tools: Mercury Quality Center, Serena ChangeMan, Version Manager, TortoiseSVN, CVS, MySQL Workbench, IBM Lotus Notes, SoapUI, BMC Control-M

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Worked on teh implementation of Account Payables (AP), Account Receivables (AR), General Ledger (GL), Order Management (OM), and Inventory (INV) mainly focusing on Order to cash (O2C), Procure to pay (P2P) and Drop Ship business processes.
• Developed and scheduled concurrent programs which generates out bound files using UTL FILE utility, and placed at teh mounting directory in teh network share for various financial integrations.
• Developed UNIX shell scripts to handle teh scheduled concurrent program for every 15 minutes and send teh files from teh application server to teh network share.
• Developed excel reports in Supply Chain Modules using XML BI publisher, grouping them wif item, locators, sub inventory, organization, and company level column values in Inventory(INV).
• Worked on form personalization to provide default sorting order, restrict from approving cycle count if teh approval employee and teh counted by employee both are same in Inventory (INV) module which is in Supply chain (SCM).
• Restricting teh sub inventory form to read only and to enable only when sub inventory validates against teh custom requirement using form personalization in warehouse management system (WMS).
• Calculating teh sum, percentage, average at locator level, sub inventory level, organization level, and company level using rtf template and also xml data definition.
• Implemented after insert trigger on MTL MATERIAL TRANSACTIONS table to populate teh live data into teh custom table and tan to outbound teh data to teh remote server.
• Worked on AP Invoices form, if teh item has no cost defined for that particular period restricting standard purchase order from approving.
• Worked on various rdf reports, groping at different levels getting teh values from formula columns and developed rtf templates to handle teh generated XML.
• Developed Cycle count schedule template form in Inventory (INV) internally in Supply Chain Modules (SCM) which users can store teh cycle count information in a template and reuse teh information in teh Cycle count schedule form.
• Developed Custom forms created data blocks, items, well versed wif FORM, Block, item Level triggers, LOV's and Record groups in Supply Chain Modules (SCM) as well as Financial Modules.
• Design and Developed Complex Forms, Record Groups, Object Groups, Visual Attributes, Menus, Reports, Graphics, Parameters, System Variables, Master-Details Forms and PL/SQL Libraries in Supply Chain Modules (SCM).
• Created PL/SQL, SQL, SQL*Plus, and SQL Loader scripts to validate and call stored procedures to validate and populate database objects before generating Oracle Error and Status reports.
• Coding of custom reports for Purchasing (PO) module, defining concurrent programs, value sets and parameters.
• Designed and Developed of custom XML publisher and rdf reports in Purchasing (PO) and in Account Payable (AP) modules.
• Developed custom forms, reports and concurrent programs using Forms 10g, Reports 10g and PL/SQL and registered them to Oracle Applications using AOL.
• Extensively worked on RICEW objects to view, transfer and modify teh data in teh same or different system in financial and SCM modules.
• Developed Concurrent Programs for creating transactions, update balances in exchange for Invoice adjustments, Receipts and Reverse Receipts which are otherwise manually created in Oracle Financials and SCM modules.
• Developed a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Forms Personalization in AR, Pricing and OM using Oracle Application Framework Personalization and forms Personalization.

Environment: Oracle Applications R 12.2.4/12.0.6 (GL, AP, AP, PO, OM, WIP, INV), Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g, Workflow Builder 2.6.5, Discoverer 10g, TOAD and UNIX.

Confidential, Chicago, IL

Sr. Oracle Apps Developer

Responsibilities:

• Developed new Reports and customized existing Reports in teh AR and AP module according to teh client's requirements.
• Developed a Custom Program to validate and Import Sales Order from legacy system into Oracle Application using order processing API.
• Worked on Payables Open Invoice Interface in Accounts Payables (AP) and also developed standard reports using XML Publisher.
• Worked wif users through all Software Development Lifecycle (SDLC) phases.
• Developed supplier Conversion to load vendor details from legacy system into Oracle Applications base tables.
• Created custom forms wif control block and auto populating data to Control blocks at run time using PRE, POST-Query triggers.
• Worked on Customized standard forms through custom.pll and also generated Material Transaction Report using XML Publisher.
• Worked wif API's and Conversions like Item Master, BOM, Item-Category, On-hand quantity, Journal Import, Customer, and Sales Order etc.
• Developed new Concurrent Programs, Forms & Reports and Flex Field Customizations.
• Responsible for Gathering, refining, and documentation of teh business rules, functional and technical requirements.
• Developed UNIX Shell scripts to archive inbound/outbound files and report outputs.
• Providing Production support and halping users in teh month end closing and to complete pending transactions.
• Modification of custom components as per various requirements of teh project.
• Worked on form personalization e.g. Standard Customer Master Form Personalization to work conditionally for various responsibilities and different users as per their profile settings.
• Customized teh Order Header level and Line level Workflow (WF) processes to add teh custom activities.
• Created Materialized Views to hold teh extracted and calculated data for Reporting purposes.
• Expertise in writing Challenging Codes using SQL, PL/SQL and UNIX Shell Scripts.
• Created new custom folders and value lists in discoverer admin layer.
• Writing Custom PL/SQL packages for teh Project Costing and Billing extensions and developing various reports for Invoicing, Billing and Man-hour reports.
• Developed new custom forms from scratch as per client requirements and involved in bug analysis and fixing process.

Environment: Environment:OracleE-Business Suite R12 (AP, AR, GL, SCM, WIP, QP, PO, INV), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SQL*Developer and UNIX.

Confidential, Louisville, KY

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Developed Interface of Sales Orders Import in OM after actively participating in teh preparation of teh conversion mapping documents.
• Expertise in Oracle Finance (GL, AR, AP, EAM), Oracle SCM (OM, INV, PO, Adv. pricing, Quoting) and P2P (PO, AP, iProc).
• Worked wif users through all Software Development Lifecycle (SDLC) phases.
• Developed custom interface program to load inventory (INV) Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed a PO interface to generate Purchase Orders through an interface conversion program as per teh data received from Legacy System.
• Developed forms using ZOOM Functionality that pops up appropriate form based on teh item context. Modified custom.pll to activate zoom.
• Expertise in design and development of Conversion Programs, Interfaces and Trading Community Architecture (TCA) APIs to import data from legacy systems.
• Developed PL/SQL scripts for validating teh data and Storing teh data into MTL SYSTEM ITEMS INTERFACE and tan populating teh base tables by running teh ITEM IMPORT Interface.
• Worked on Drop shipment flow, back-to-back order flow.
• As Part of auditing developed data extraction scripts in order to extract data from GL and SL modules base tables and developed audit reports to reconcile teh data between GL and SL modules.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in teh area of technical design, development, Integration testing and deployment.
• Developed custom reports using Report 10g and also customized seeded reports.
• Analyzed teh requirements, performing risk analysis for mapping teh business processes. Understanding teh gaps, recommended teh necessary customizations.
• Developed various custom components for R12 Implementation which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• Prepared most of teh AIM Functional and Technical documents for requirements, design, and implementation steps wif data conversions, test plans and functional user training guides for all teh phases of teh project.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Package wifOracleAOL.
• XML templates, concurrent programs, request sets, menus, request groups, responsibilities, Profiles and alerts between database instances.
• Customized AP Approval, Requisition Approval and AP Approval workflow for Procurement.
• Developed custom Forms and Reports as per client requirements and making them web enabled usingOracleReports builder 10g andOracleForms builder 10g respectively.
• Enhanced functionalities in P2P cycle, as per Business process.
• Experience in developing custom Web ADI integrators and layouts.

Environment: OracleAppsRelease 12(12.1.3), (AP, AR, GL), me-procurement SQL, PL-SQL,Oracle10g, TOAD, Discoverer, Reports Builder 10g and Forms Builder 9i/10g, XML Publisher, SQL*Developer, Putty, Workflow, WinSCP, UNIX.

Confidential

Oracle EBS Consultant

Responsibilities:

• As a Technical consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including Purchasing, Inventory, and Order Management.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows teh quantity of goods received and balance quantity of goods to be received against teh shipment line.
• Developed Sales by Customer Ship-To Location report that shows teh sales information wif corresponding order number, invoice number, Item number, and PO and customer ship-to location.
• Working on Software Development Life Cycle (SDLC) for implementation of Custom Designed Applications in Oracle R12 Environment Applications using Oracle R12 Standard Objects including TEMPLATE.FMB, CUSTOM.PLL, PERSONALIZATION and Application Object Library (AOL) for Development, Implementation of Custom Designed Forms and Oracle R12 Standard Forms for PO, Modules.
• Requisition approval process and order routing process validation logic has been customized using teh custom functions at activity nodes on teh standard workflow processes.
• Created and customized reports using XML Publisher in OM, PO, AR, AP and INV Modules.
• Developed Purchase order interface, Receipt interface in P2P flow cycle.
• Registered teh form and migrated.fmx executable file to $AU TOP on forms server of client.
• Performed support activities by fixing teh issues related to INV, PO, OM Cycle, and Shipping Modules.
• Performed production and non-production support by solving tickets of all severity (P1 to P4).
• Conversion of Master and Transaction data using Open Interfaces/ API. (Master Item conversions, Item category Item On hand and AP Invoices).
• Working as a Systems Administrator, supporting end-users including Creating, Maintaining Users, Roles, Responsibility, Concurrent Request Manager, FNDLOAD, XDOLoader utilities to migrate Standard Oracle Financial and Custom Designed Objects across various instances in SDLC Process.

Environment: OracleE-Business Suite R12 (AP, AR, GL, OM, QP, PO, INV), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SQL*Developer, Discoverer 10g and UNIX.

Confidential

Oracle Applications EBS Consultant

Responsibilities:

• Customized and converted existing RDF reports that will run compatible as per teh new multi-org structure and user requirement.
• Develop Account Analysis report that shows current A/R balance, credit limit and past 12 months transaction history for teh customer(s) defined in TCA. This report is being used by credit department in order to analyze teh customer history and approve for higher credit limits.
• Resolved issues in embedded workflow of Order flow in OM module and had teh modified workflow re-deployed in teh instance.
• Customized Workflow Order routing process and Notification process based on teh approval Hierarchies to notify teh stake holders.
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Extensive Experience in OM API's like order creation, order updation and pricing.
• Developed PL/SQL Packages, Procedures and Functions for validating teh invoices and payment information from teh legacy system and imported into Oracle Applications using teh Payables.
• Open Interface Import program and populated teh base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows teh quantity of goods received and balance quantity of goods to be received against teh shipment line.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.
• Developed Sales by Customer Ship-To Location report that shows teh sales information wif corresponding order number, invoice number, Item number, and PO and customer ship-to location.
• Customized PO Approval workflow process using Workflow Builder and define processes based on teh purchasing amount and ship to location.
• Trouble shoot issues wif run time performance of teh reports and use lexical parameters and bind variables wherever required to improve teh performance.
• Converted teh customer master from Legacy intooracleAccounts Receivables (AR) using teh TCA architecture (TCA API's).
• Design and Developed Complex Forms, Record Groups, Object Groups, Visual Attributes, Menus, Reports, Graphics, Parameters, System Variables, Master-Details Forms and PL/SQL Libraries in Supply Chain Modules (SCM).
• Developed multiple Bill Of Lading (BOL) Custom Reports across Operating Units.

Environment: OracleApplications R12/11.5.10, Reports 6i/10g, SQL, PL/SQL, Oracle9i/10g, UNIX, Java, JSP, Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL*Loader.

Confidential

Oracle Applications Technical EBS Consultant

Responsibilities:

• Understanding technical upgrade process. Compiled and executed number of forms, interfaces, custom reports, customizations, extensions.
• Involved in technical upgrade like Concurrent custom reports had to be re-compiled and executed usingOraclereports and forms.
• Made Analysis of teh functional requirement document and provide a high leveltechnicaldesign document.
• Based on teh scope of teh project, provided teh detail requirement and complexity of teh project based on which resource allocation is done.
• Altered teh existing old performance test cases to fit for new upgrade functionality.
• Accomplished a technical upgrade which includes Reports, forms, interfaces and various customizations during upgrade process.
• Involved in Personalization of Forms.
• Uploaded all teh concurrent program details into another instance by using FNDLOAD commands.
• Updating MD70 documents after upgrade based on MD50 documents.
• Interacting wif client to prepare document of actual requirement based on which development.
• Preparing teh entire functional flow and halping thedevelopersfor teh proper analysis and coding to achieve teh requirement

Environment: Oracle Apps 11i (RICE, GL, AP, PO, OM, SCM), Oracle 10g, Database, PL/SQL, SQL Navigator, Bulk Loader, Oracle Reports 6i, Oracle Forms 6i, UNIX Shell scripting, XML Publisher

Confidential

Oracle Applications EBS Consultant

Responsibilities:

• Understanding technical upgrade process. As a technical me has involved number oforaclereports upgrade from Reports3i to Reports6i.
• Modifying teh existing reports which includes replacing old tables from 11.0.3 to new tables 11.5.10 and compile teh reports and moved to new environment.
• Improved teh existing old performance test cases to fit for new upgrade functionality.
• Implemented a technical upgrade which includes Reports, interfaces and various customizations during upgrade process.
• Operated technical upgrade of various reports such as teh AP Vendor Trail Balance report, AP Check Code Combination report, Regional Exploited ATB report, and GL-AP Journal report
• Tweaked teh reports to improve performance during upgrade process.
• Uploaded all teh concurrent program details into another instance by using FNDLOAD commands.
• Validated teh test scenarios and teh test cases to ensure that teh delivered unit is valid after incorporating teh changes in upgrade.
• Developed Custom Vendor creation and Update program to create or update suppliers, supplier sites and contacts wif classifications categories using PLSQL and SQL Loader.
• Defined new value set of special validation type based on teh KFF and added it to teh DFF.

Environment: OracleApplications 11i ( GL, AP, AR, PO), PL/SQL, SQL*Plus,Oracle 9i, Unix.