SUMMARY

• Over 7+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. (Oracle Financials (AP, GL, AR, FA, CM) and Oracle Manufacturing (PO, INV), OM and Shipping, System Administrator, CRM, Install Base, iExpense, iSupplier and Application Object Library (AOL).
• Strong Techno-Functional experience in Order to Cash Process, P2P, SCM and more Technical experience in all Financial, Manufacturing and Distribution modules in EBS and Knowledge on OTL and HRMS Modules.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Oracle E-Business Suite (11i and R12) expertise in developing RICEW components in Financial Modules (iExpenses, iProcurement, PO, AP, AR and GL) and Distribution Modules (INV, BOM, WIP, OM, WSH).
• Proficient with use of tools like Toad, SQL Developer and SQL*PLUS Strong knowledge of Unix Shell Scripts and Perl Scripts
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Good knowledge of Order to Cash (OTC), Procure to Pay (P2P), Supply Chain Management (SCM) and Project Accounting (PA) modules.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications
• Experience in Oracle BI Apps (OBIA) - Supply Chain Analytics, Order Management Analytics, Financial Analytics, Procurement Analytics and Spent Analytics.
• Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.
• Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the APPS front end.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder
• Expertise in writing PL/SQL APIs and customization of Client Extensions in Oracle Applications
• Knowledgeable in using Oracle utilities FNDLOAD and WFLOAD.
• Experienced in handling installing and effective troubleshooting and up gradation of EUL from Discoverer 4i to 10g.
• Oracle Applications Modules: ASCP (Oracle Advanced Supply Chain Planning), OPM (System Admin, Inventory, Cost Management, Quality Management), Inventory, BOM, WIP and Costing.
• Strong experience in customizing applications using OAF, JTF, Java, JSP, ADF and JSF..
• Expertise in developing and customizing Forms using Oracle Forms 9i/6i/4.5, Reports 9i/6i/4.5/2.5, Oracle Discoverer 10g/4i and XML/BI publisher 5.6.3/5.6.2
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through the projects from inception to completion.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business Suite R12, 11.5.4 to 11.5.10. Oracle SOA Suite (10g and 11g), Oracle Manufacturing (OM, INV, BOM, WIP, PO), Oracle Financials (GL, AR, AP, FA, BOM), AOL, Sys. Admin.

Application Tools: Reports 6i, Forms 10g/6i, Discoverer 10g/4i, Developer 2000, Developer Suite 10g, XML/BI Publisher, Siebel, Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0).

Databases & Tools: Oracle 10g/9i/8i/8.0, TOAD, SQL*PLUS, SQL* Loader.

Scripting Languages: Unix Shell scripts, Perl, K shell, C shell.

Languages: SQL, PL/SQL, JAVA, XML, C, C++

Operating System: Sun Solaris, HP Unix, Linux, Windows XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Techno-Functional Consultant

Responsibilities:

• Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP, GL.
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Designed and Developed GL Interface.
• Defined Transaction Types, Auto Invoice process, Auto Accounting and Auto Lock box in Receivables.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Implemented Order to Cash modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations with OM GL, AP, AR, CM, INV with in EBS System
• Setup of ASCP, OPM, Inventory, Purchasing, WIP, BOM, and CDOA.
• Used Forms Personalization created a special trigger in sales order for booking according to user requirement
• Customized some of the Reports like Check Format, Bank Statement in AP, Customer Statement, Invoice Printing and Order/Invoice Detail in OM & RMA Using XML/BI Publisher.
• Developed Packing Slip Details Report and Open Item Details Report using XML Publisher.
• Developed Open Purchase Orders report using XML Publisher.
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers, Items, BOMS, On hand Quantity.
• Imported BOM’s and Routings from legacy system into oracle Bill of Materials (BOM) using standard BOM and Routing Interface program.
• Developed new reports in OM and INV such as Sales Tracking Report, On hand Quantity tracker, Move Order Reconcile Report, Sale Order Reconcile, Open purchase Order and Logistics/Sub Inventory status reports.
• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management (OM) system.
• Developed Order/Invoice Detail Report, Back Order Detail Report in Order Management using BI Publisher.
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, AR, FA, WIP and INV.
• Involved in setting up users and defining resources for AR and assign roles as per the requirements using CRM Administrator responsibility.
• Customized the Standard Workflow Items and process such as Order Header, Order Line, Change Order Close order, and Close line.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Analysis, design and development of integration interfaces between Legacy systems and Oracle OPM.
• Definition of legacy and custom solutions and interfaces for OPM and INV
• Critical process design and validations in Order to Cash cycle.
• Worked on Order to Cash life cycle implementation and integrating modules.
• Customized the Customer Form using CUSTOM.pll to Activate/Inactivate the Active check box based on the users and the responsibilities, implemented zoom functionality in custom forms.
• Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR PAYMENTS INTERFACE ALL), from interface table to the Base Interim tables and finally to the base table
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP, FA and GL.
• Developed UNIX Shell scripts to run the interface program and to archive the data.
• Developed Perl scripts used PL/SQL to code database objects
• Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
• Involved in System Administration functions like Created Custom Menus, responsibilities, report groups, new printer styles and workflow admin.
• Developed FSG reports to give department managers a high level view of their current operating expense categories compared to their budgets using FSG and ADI.

Environment: Oracle Apps R12/11i (11.5.10), Supply Chain Management (SCM), OM, WSH, Warehouse Management, INV, PO, AR, AP, CM, FA, TCA Architecture, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i/10g, Forms 6i/10g, Toad, Windows XP, Perl, AIM, Oracle 10g.

Confidential, Park Ridge, NJ

Oracle Techno-Functional Consultant

Responsibilities:

• Customization of PO Requisition Approval workflow to send FYI email notification to the CFO based on the requisition amount.
• Developed PL/SQL interface AP for Extraction of updated addresses into an outbound directory database for updating addresses using UTL File Packages
• Customization of Order Header workflow to close the order header once all the lines are closed.
• Custom Report on Order Management workflows to show the statuses of the workflows using Oracle Discoverer.
• Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System.
• Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, BOM, WIP, AP, FA, CM and AR Applications
• Responsible for the setups for purchasing (PO), Order Management (OM), Bill of Materials (BOM) with the SOX approval
• Creating the option classes in the Bill of Materials (BOM) Application for the service items selection in the Order Management (OM).
• Designed steps for implementation and prepared the business documentation for implementation and supporting of R12 using the SDLC/AIM Methodology and Advanced Global Intercompany System.
• Asset Form extension to capture additional asset related information.
• Custom Report to display item cost details.
• Worked as functional consultant in iExpenses, Accounts Payables and Fixed Assets.
• Prepared Project Plan for iExpenses and AP (p2p Project)
• Alert the Order Management Controller when the on hand quantity of the item is becoming less than the minimum quantity.
• Auto dealers throughout the United States on OAS using the PL/SQL cartridge deployed oracle Reports in PDF format over the Internet for direct access. Oracle Forms created the back-end system for administrators.
• Wrote a PLSQL interface in Accounts Payable for Extraction of the addresses into an outbound directory database for updating addresses using UTL File Packages and interface for Extraction of updated addresses from inbound directory into the database.
• Worked on Form personalization in receivables, where the user can’t update the last and first name of customer, bank account number, when that record is validated.
• Writing PL/SQL scripts to migrate the data from customers’ legacy system to Oracle Applications tables.
• Loading data from flat files into Oracle 9i database using SQL*loader and Perl
• Experience in Debugging and error fixing using PL/SQL debugging tools like TOAD.
• Write Perl scripts to upload data from text files (and control files) to the database using SQL*loader
• Developed the Stream Revenue Program to populate data from the base tables to the custom tables.
• Developed interface programs to integrate Legacy System with the AR module to import customer information using the Customer Interface.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Imported the batch AR transactions to load the transaction information in Interface and then in Oracle Base tables using Auto Invoice Import Program.
• Developed a custom program to implement AP-AR Netting procedure to apply payments to outstanding receivable balances and applicable interests.
• Developed PL/SQL package to validate data like GL codes and insert the freight invoices into Interface tables.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Developed FSG reports in General Ledger to list the Actual, Budget and Prior Amounts.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables using XML/BI Publisher.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application
• Developed custom XML/BI publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the Inventory module.
• Registered Concurrent Programs and defined new users, menus and responsibilities.

Environment: Oracle Apps R12, Supply Chain (SCM), OM, WSH, Supply Chain Management (SCM), Warehouse Management, INV, PO, AR, AP, FA, CM TCA Architecture, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i/10g, Forms 6i/10g, Toad, Perl, Windows XP, AIM, Oracle 10g.

Confidential, Ramsey, NJ

Oracle Techno-Functional Consultant

Responsibilities:

• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management.
• Implementation of Oracle Inventory (and assistance in WSH) in the Procure to Pay and Order to Cash business flows.
• Involved in developing Interface programs for Move Order Inbound & Outbound interfaces using MOVE Order PLSQL API between Oracle Apps and a legacy system BOSS for Replenishment Orders.
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• Responsible of business requirements gathering and definition for the FA implementation and production support.
• Definition, design, setup and implementation of Financial Leases (FA), Manual and Automatic Sequences for correct numeration of invoices in Account Receivables and Order Management, and AR Statements and AR Dunning Letters.
• Analyst Consultant for close period in OM, AR, INV, FA. Analyst Consultant in the business cycle (OM and AR).
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO, FA
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM, Advanced Pricing module
• Worked on Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• Designed and Developed packages for Journal Import Interface to import journals information into the system.
• Successfully executed CRP1, CRP2, and UAT and provided postproduction support for the end users after go-live. Provided post go-live support in INV, BOM, WIP, OM, PO, iProcurement, CM, AP and AR
• Tuning the SQL queries to improve the reporting performance in the application.
• Developed AR GL Reconciliation report using Oracle Discoverer.
• Worked on Creating and Applying Holds on Sales Order during Order Import and Pick Release.
• Developed Custom Packages, which in turn were used for reporting purposes.
• Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• Designed and developed Inventory Detail report using Discoverer.
• Customized Auto Cash Rules Report, Transaction Detail Report and Journals Entry Report in Account Receivables.
• Customized Invoices Pick and Pack slips to list back ordered items in OM module.
• Development of Discoverer 10g Reports includes creating complex views, folders, joins and item classes.
• Implemented form personalization in some forms based on client requirement.
• Developed AR Credit memo and AR Customers forms.
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client
• Developed new report Credit Memos in AR using Discoverer.
• Involved in table and columns registration using AD DD utility.
• Created Statement of Cash Flows and GL Period to Date Report using FSG’s.
• Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Developing User Guides for the end users to work with AP, PA, FA, BOM, WSH, WIP and GL APIs.
• Worked on Drop Shipment order type
• Created Profit Center Report and Cost Center Report in General Ledger using Discoverer.
• Used the Totals/Subtotals/Group/Sort features of BI Publisher to make data intense operations happen at the template level.
• As a Discoverer Administrator created Business Areas, Folders, and Setup joins between folders, Registered PL/SQL functions, created Item Classes, created date hierarchies and item hierarchies etc.
• Provided Periodic backups of EUL and involved in export, import of End User Layers from one instance to another.
• Entailed using MS Access 7.0 to perform various reports validating the loaded data and data formats. Involved in designing the screens and reports by using Developer 2000 Forms 5.0, Oracle Reports.
• Developed Order/Invoice Detail Report, Sales Tracking Report, Back Order Detail Report in Order Management using BI Publisher.
• Functional report design for OFA (PO, AP, FA, and Tax Requirements Reports in GL, for example VAT Conciliation).
• Built custom reports using Report 6i to solve the client’s reporting needs.
• Prepared MD070 Technical Design Documents for critical objects using the AIM Methodology.
• Used AOL and System Administrator modules for registering the developed and customized reports and conversion programs.

Environment: Oracle Applications R12, 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Supply Chain Management (SCM), Purchase Order Oracle 9i, Discoverer 10g, MS Access 7.0, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i/10g, Forms 6i/10g, UNIX.

Confidential, Atlanta, GA

Oracle Techno-Functional Consultant

Responsibilities:

• Worked on INV in defining a New Item in inventory, increasing the On-Hand Quantity. Involved in defining the Price List.
• Design of documents and guides for new users of Oracle Financials R11i (GL, AP, AR, FA, PO)
• Developed the Interfaces as initial data conversion from Acura (Legacy System) to Oracle Apps for INV and BOM Modules
• Description: Implementation of Procure to Pay, Customer Invoice to Cash and Accounting to Financial Reports standard business flows.
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• INV integration with PO and GL modules was extensively tested and verified before go live.
• Extensively worked on Create, Release, and complete, close discrete job for Sub Assembly goods in Procure to pay.
• Involved in Conversion Programs for Inventory Items, Inventory Transactions, Purchase Orders and Sales Orders.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Register generated reports, forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Developed the interface program to import Invoice data from legacy system to account payables using SQL*Loader and PLSQL packages to validate data.
• Customization of Order Header workflow to close the order header once all the lines are closed
• Developed Sales Order Interface by designing Staging tables, SQL*Loader Program and Custom PL/SQL to import the Sales Orders using Open interface tables in Oracle Order Management.
• Designed and developed Actual Income Budget Statement, Cumulative Balance Sheet and Budget/Actual Report, Income Statement with Variance, Cumulative Balance Sheet and Income Statement Consolidated using FSG and XML Publisher.
• Responsible in uploading and downloading of data across various servers using FTP.
• Used FND LOAD to upload and download the “LDT” files during the migration on Concurrent Programs registration.
• Designed and developed Profit Center Report, Cost Center Report using Discoverer.
• Jasper UI - Involved in changing the Jasper look and feel.
• Designed and developed BOM Actual and Planned Report to compare the cost and the Components of BOM and the WIP Jobs.
• Created a stored procedure function to overcome jasper reports complexities
• Developed various Mailing list reports and Form letter reports using Reports 6i.
• Developed Barcode Information System to provide scheduling and packing information for proper routing and efficient transport of goods.
• Used Discoverer 4i, Oracle Reports 6i and XML Publisher 5.6.2 to customize the reports.

Environment: Oracle Applications Release R12/11i (INV, OM, Supply Chain Management (SCM), Shipping, AR, PO, GL), Oracle 8i, EDI, Forms6i, Reports 6i, Shipping, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD, Discoverer4i, XML Publisher 5.6.2, PL/SQL, WinNT and UNIX.

Confidential, Boston, MA

Oracle APPS Consultant

Responsibilities:

• Developed Payables Open interface Import Program to load invoices from multiple sources like legacy invoices into Accounts Payables in a periodic basis and also designed a report using XML/BI Publisher.
• Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
• Customized existing Dunning report in Account Receivables using XML/BI Publisher.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
• Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports
• Customized Material adjustment report, Slow moving inventory report in Inventory using Discoverer.
• Used SQL*Loader to import receipts data into AR Payments Interface table after defining Lockbox, and Transmission Format and running Lockbox interface form transferred data into Oracle Receivables.
• Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUEST.
• Worked extensively on the customization of GL Auditor Reports using XML/BI Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
• Designed and developed packages to extract information related to Vendor, PO, Invoice, Payment, GL Journal details for external systems.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms
• Worked on complete SDLC from gathering requirements to Deployment.
• Developed FSG reports in GL to list the Actual, Budget and Prior Amounts.
• Created new End User Layer (EUL) in Oracle Discoverer.
• Customized Discoverer End User Layer involved creating customized folders, business layers, customized joins and granting privileges to both users and responsibilities.
• Created new custom reports in XML/BI publisher.
• Automated the process of migrating Data Definitions and Templates from Instance to Instance.
• Assisted in up-gradation of database and applications by providing necessary patch set information.
• Resolved open issues with the production system.
• Developed functional designs in support of global 11i implementation using SDLC/AIM methodology.
• Prepared technical document (MD50, MD70) for the customizations done.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable, Oracle 9i (9.2.0), XML/BI Publisher, SQL*PLUS, SQL*Loader, TOAD, Unix, Forms 6i, Reports 6i.

Confidential

Oracle Applications Developer

Responsibilities:

• Worked on Material Transactions, Material Distributions, and Resource Transactions in Procure to pay.
• Developed Open Purchase Orders report using Report 6i.
• Tuning the SQL queries to improve the reporting performance in the application.
• Extensively used System Administrator module for set up of various Concurrent Programs, Request Sets, Users and Responsibilities.
• Wrote custom code with validations to transfer the data from staging table to interface tables.
• Involved in Unit Testing and Performance Testing for reports.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Customized AP Trial Balance Report adding AMOUNT APPLICABLE TO DISCOUNT column to show the applicable discount amount and customized in Report 6i.
• Have worked in Oracle Discoverer 4i, creating Business area, folders and workbooks using Discoverer Administrator and Discover Desktop for financial department.
• Developed and designed Invoices using Oracle Reports 6i.
• Wrote PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.

Environment: Oracle Applications 11i (11.5.x), GL, AOL, AP, AR, PL/SQL, SQL*loader, Oracle Reports 6i, Discoverer 4i, Oracle System Administration AOL.