SUMMARY

• Over 10 years of Oracle Applications11i (E - Business Suite) Experience including Developing, Customizing, Testing and Implementation as a Techno-functional Consultant.
• Worked on several modules which include General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), Cash Management (CM), Order Management (OM), Inventory (INV), Purchasing (PO), Bill of Materials (BOM), Work in Progress (WIP), Shipping (WSH), Workflow and System Administration.
• Experienced in Implementing Order to Cash and Procure to Pay Process Flows.
• Good Knowledge in FORMS CUSTOMIZATION using CUSTOM.pll, TEMPLATE.fmb and FORMS Personalization.
• Expertise working with Oracle 8i/ 9i, Developer 2000, PL/SQL, Forms 6i, Report 6i, SQL * Loader, TOAD, Data Load, Oracle Discoverer 4i and XML Publisher.
• Good Knowledge on the TCAarchitecture, HZ Schema tables, Relationships and the TCA Model.
• Ability to handle both Development and ProductionSupport Roles.
• Extensive use and application of AIM in projects.
• Expertise in managing OracleTAR's and escalations.
• Experienced in implementation and customization of Oracle Applications, integration with legacy systems, design and development of inbound and outbound interfaces.
• Worked with Sys Admin Module (Registering Forms, Reports and PL/SQL Programs), Creating Users, Customizing Menus, Assigning Responsibilities, Creating concurrent executables, concurrent programs, Creation of Value sets, setting System profile and User profile options as per the requirement.
• Experienced in identifying Technical gaps, estimating work, architecting system interactions, designing custom solutions and programming, scheduling, producing documentation, user manual to users and providing production support.
• Ability to work individually as well as in a team. Strong team player.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Oracle Applications Techno-Functional Consultant

Environment: Oracle Apps 11.5.10/R12, GL, AR, AP, OM, PO, INV, HRMS Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, TOAD, Windows XP, HP-UNIX.

Responsibilities:

• Developed Custom Sanctions Interface that integrates with the SOA application to bring SANCTIONs data into the Oracle Inbound.
• Used XML Bursting File feature in the various report to deliver emails to the end-users with EXCEL/PDF output attachments.
• Developed AR Consolidated Invoices package that will deliver the printed invoices into the FTP Outbound to various Customers.
• Developed Customer/Supplier Integration package that integrates EBS customer information (TCA) with the Oracle CRM On-Demand Application. Involved calls to SOA
• Web Services and deployed of SOA Composites.
• Developed Custom AP Format Payment Program to select Payment Formats automatically for all PAYGROUP and Payment Methods. Once Confirmed delivers the XML Payment Format File to the BANK Inbound File Location.
• Developed XML Publisher Data Definitions for AP Payment Formats using XML and XSL.
• Developed SFTP Host Program to deliver files to the HSBC Bank Inbound directory.
• Involved in the requirements gathering, design and development for restricting AP Payments, Create Invoices and Modify Invoice Interfaces to the AP Associate Users using FORMS PERSONALIZATION.

Confidential, Seattle, WA

Oracle Applications Techno-Functional Consultant

Environment: Oracle Apps 11.5.10/R12, GL, AR, AP, OM, PO, INV, HRMS Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, TOAD, Windows XP, HP-UNIX.

Responsibilities:

• Involved in the development and design of the Global AR Aging report across all organizations and also worked on the UAT Testing issues resolution.
• Developed GL Close period BI Publisher reports for month end closing. Used XML Bursting File feature in the report to deliver emails to the end-users with EXCEL output attachments.
• Developed a Custom AP Web Expense report (PL/SQL package) based on the organization information parameters. Used UTL FILE utility to generate PIPE-delimited format outputs to be used for AP Team Analysis.
• Developed a Custom Invoice Duplicate Report (PL/SQL package) for the AP Payables Manager to verify the INVOICE Duplicates from Vendors and validate against the checks paid for the INVOICES. Used UTL FILE utility to generate PIPE-delimited format outputs for AP Team.
• Developed a Custom GL Report with AP Details including PO Information (if available for invoice) based on GL Set of Books and Periods to be used by the Finance Team. Developed in PIPE-delimited OUTPUT as per the requirements from Financial Analyst.
• Developed Custom Purchase Order Reports in XML Publisher for South Africa, Slovakia and Italy Purchasing Implementation.

Confidential, San Diego, CA

Oracle Applications Techno-Functional Consultant

Environment: Oracle Apps 11.5.9/R12, GL, AR, AP, OM, PO, INV, HRMS Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, TOAD, Windows XP, HP-UNIX.

Responsibilities:

• 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.
• Customized the Pricing Attributes workflow as per the Business requirement whenever Price is updated and it send a notification for approve.
• Developed queries for summaries of AR Aging reports, AR to GL Reconciliation reports, Auto-invoice execution/validation report, Tax and Revenue reports, Receipt register reports etc.
• Worked GL Unposted Journals Conversion from 11.5.9 to R12.
• Worked on the Customer Conversion from 11.5.9 to R12.
• Involved in the modification of custom reports for changed tables in R12.
• Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
• Recustomized the AR Module Sales Journal by GL Account Report from Report Version in 11i to XML Publisher in R12.
• Customized the standard forms in application modules using CUSTOM.PLL for hiding the fields, changing the visual attributes & prompts of the fields.

Confidential, Santa Clara, CA

Oracle Applications Techno-Functional Consultant

Environment: Oracle Applications 11.5.10.2 (GL, AP, AOL, Alerts), OM, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer 4i.

Responsibilities:

• Involved in developing new interfaces, customizations of existing interfaces, developing new reports and customizing existing Reports and Forms 6i to meet the business/client requirements.
• Developed several Ad Hoc reports using Reports 6i. Developed complex reports using lexical parameters, bind variables and several dynamic SQL queries.
• Involved in the Functional Setup of GL, AP, AR and PO.
• Upload of payment receipt through Auto Lockbox Interface in AR.
• Exporting AR invoices to a legacy systems.
• Customized the Invoice Aging Report in AR and Purchasing Requisition form in PO.
• Worked on invoice interface in AP.
• Worked on Mass Addition Interface in FA. Build PL/SQL programs to perform Mass additions to load conversion of assets from legacy system.
• Customized Purchase Order Report according to the business requirements PO.
• Developed ItemInterface conversion script for importing item information from Legacy System to Item Base tables through Open Item Interface program in INV.
• Developed Custom Oracle Reports for OracleOrder Management.
• Uploaded the assets information into Fixed Assets module.

Confidential, Irving, TX

Oracle Applications Techno-Functional Consultant

Environment: Oracle Applications 11i (GL, AP, AOL, Alerts), PA, Forms 6i, Reports 6i, Oracle 8i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer 4i.

Responsibilities:

• Rewritten and modified most of the custom reports for OM and Inventory modules in 11i.
• Major modifications to OM Workflow Processes.
• Developed interfaces between ARGO Custom shipping application and Oracle OM.
• Integrate Clarify with Oracle OM and AR modules.
• Worked on DNSREC Project to bring the installation information from E*connect through Web Methods to staging tables in Oracle OM. Pick released and ship confirmed the serial numbers using Oracle OM APIs
• Developed a Custom API to import orders from one of the legacy system Siebel to OM using oe order pub API.
• Developed custom API to copy inventory items from one org to another org (used an API Inv Item grp.create item).
• Developed API to update the items to set the serial control flag at Receipt.
• Custom Open Purchase Orders Report (by Buyer) report developed using XML Publisher.
• Custom PLL was used to place validations when the some of the orgs were set to serial controlled at receipt. The major validations are to validate the part number is matching against the legacy data based on the serial number entered or not. Is serial number entered is all caps or not.
• Developed many reports in Inventory, OM modules. Custom Serial Sub inventory reports, Custom DBS Sales report.

Confidential, Secaucus, NJ

Oracle Applications Techno-Functional Consultant

Environment: Oracle APPS 11.5.10, UNIX (AIX), Windows NT, Oracle 9i, GL, AP, AR, OM, INV, WIP, BOM, Reports 6i, Oracle Discoverer 4i.

Responsibilities:

• Developed Custom Sales Representative Sales Payments Report for OM, which allows users in order for them to pay the sales force their commissions.
• Developed Custom Outstanding Sample Orders Report for OM, to track sample requests that have not been returned or invoiced.
• Involved in the Functional Design and setup of Return Orders Hold, which allows different responsibilities to apply and release hold.
• Involved in the Functional Design and setup of Sale Type field in Order Header DFF that allows the ability to track sales accurately and help revenue and marketing efforts.
• Worked on changes required on a Custom EDW Outbound Interface Program to export all Educational Order transactions from Oracle - OTC into EDW.
• Worked on changes required on a Custom Pick Release Outbound InterfaceProgram that will be used to send Oracle shipment line information to WMS for order fulfillment.
• Developed reports using Oracle Discoverer 4i, which involved creating database views, End User Layers, Importing functions/views into the business area.
• Developed stand-alone procedures to load data from 11.0.3 to 11i for BOM and WIP.
• Worked on Adhoc Reports using XML Publisher.
• Designed and developed Custom Order Import Exception form for OM, which allows users to view legacy order status with OM order status.

Confidential, Providence, RI

Oracle Applications Techno-Functional Consultant

Environment: Oracle APPS 11.0.3/11.5.10 , UNIX (AIX), Windows NT, Oracle 9i/10g, GL, AP, AR, PO, OM, INV, Reports 6i, XML Publisher.

Responsibilities:

• Customized GL Request Approval Process for changing the Timeout of Request Approval from Approver Notification in GL Module.
• Designed, developed and implemented the following interfaces AR Lockbox Interface for multiple banks AR Custom Aging.
• AP Invoices Interface for Multiple data sources.
• Update MD70s as needed based on defect resolutions.
• Mapping of data elements in the source system to facilitate GL Import Process. Analyze various required, conditionally required columns of GL INTERFACE table.Worked on a Custom AR Invoice Report using Reports 6i.

Confidential, San Jose, CA

Oracle Applications Techno-Functional Consultant

Environment: Oracle APPS 11.0.3/11.5.10 , UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 8i, GL, AP, AR, PO, OM, INV, WIP, BOM, Shipping, Reports 6i.

Responsibilities:

• Accomplished Workflow Customization in Order Management by applying holds at Line Level using Order Holds API.
• Developed database triggers on Order Lines Table for returning REASON CODE in the Receipts DFF.
• Developed Custom Shipments Reportto communicate with customers, sales reps and regional offices more effectively and less expensively by emailing the results.
• Customized the Order/Invoice Detail Report in Order Management.
• Worked on the Migration of Custom.pll customizations from 11.0.3 to 11i.
• Worked on Custom Oracle Alerts for Terms Code Validation Email Verification and PO's in "Requires Re-Approval" Status based on client requirements.
• Developed All Order Type Margin Analysis Report in OM.
• Made changes to the Shipping Transactions FORM logic to restrict the generation of duplicate serial numbers.
• Worked on Return Material Authorization custom package development in OM.
• Involved in the Conversion of legacy Purchase Orders into PO module. Developed separate validation programs for different PO types.
• Developed Item Extract and Item Costs Extract programs.
• Customized Purchase order report according to the business requirements PO.

Confidential, Chicago, IL

Oracle Applications Techno-Functional Consultant

Environment: Oracle APPS 11.5.9, UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 9i, GL, AP, AR, PO, BOM, OM, INV, Form 6i, Reports 6i,Workflow builder 2.0.

Responsibilities:

• Developed Custom Forms namely Revenue Accounting Setup form for Revenue Accounting and Progress Billing Setup Form for Progress Billing Custom modules.
• Involved in Workflow of Order Management (OM).
• Customized the Requisition Approval workflow for deriving account segment values in PO Module.
• Involved in the OM Workflow Customization to create AR invoices by checking item attributes at line level for shippable items.
• Worked on Performance Tuning of Custom Package for COGS and Revenue Accounting.
• Developed Conversion scripts for the Item Category and Product-Tree Conversion.
• Developed database triggers on Order Lines Table and Order Price Adjustments Table for Custom Requirements.
• Developed a Custom Package to update and add pricing attributes to Items.
• Used BOM interface to load data from legacy system, validate and push the data in base tables BOM BILL OF MATERIALS.
• Developed Migration scripts to migrate code between instances and FTP scripts to transfer files to the Citibank Server using UNIX (AIX) Shell scripting.
• Developed MD070 documents for default Sourcing Rules, COGS changes and Discoverer reports.

Confidential, Woodbury, NY

Oracle Applications Techno-Functional Consultant

Environment: Oracle APPS 11.5.8, UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 8.i, GL, AP, AR, PO, OM, INV, Reports 6i.

Responsibilities:

• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Developed a Custom Open Invoice Interface to AP, which automatically populates the AP interface tables through a concurrent program.
• Developed SQL*Loader scripts to load legacy data into Custom Staging Tables.
• Developed Cross-reference tables for mapping Supplier Location Codes, Line of Business Codes to GL Accounts.
• Developed FTP shell scripts, which automatically logs into the Supplier sites and downloads the Invoice Data Files and saves into the Client Server Inbox.
• Developed Tally Interface to GL taking into consideration the Debit and Credit Memos.
• Developed MD70: Technical Specification Document using AIM Methodology.
• Involved in the study of Client’s Business Requirements and developed complete automation process plan of the Invoice Import to GL.
• Developed a Custom Report to show all the invoices sent to each business locations from different suppliers and categorizing them into Capitalized Expenses and Non Capitalized Expenses based on client’s requirements.
• Worked on Adhoc reports in AR.
• Involved in making changes to Custom Pro*C programs according to Business Requirements.