SUMMARY:

• Over 14 years of rich experience as a Senior Techno - Functional Consultant in Oracle Applications R12/11i (Financials, CRM, HRMS, and Distribution) on various environments like UNIX, Windows.
• Rich experience on the RICE components (Reports, Interfaces, Conversions and Extensions of Oracle Applications R12/11i (11.5.3/5/7/8/9/10 ) on Financials, Supply Chain/Distribution, Advance Pricing, HRMS & CRM modules (Service Contracts, Depot Repair, Install base, TCA.
• Experience in Application Integration; developed interfaces between Oracle Apps and legacy systems.
• Strong reporting skills using XML Publisher, Reports Builder, Oracle Discoverer & Oracle Application Express 4.2.
• Extensively used PL/SQL API’s in conversions, followed map, validate, error trapping, loading processes.
• Used AOL (Applications Object Library) and Template.fmb for all custom GUI development and Forms Customization thru Custom.pll and Forms Personalization, for specific business validations.
• Very strong SQL and PL/SQL development experience (Creation of packages, procedures, functions, database objects, APIs etc.).
• Experience in Oracle Workflow customization.

TECHNICAL SKILLS:

ERP Applications: Oracle Applications 10.7, 11.03 & 11i & R12 (AR, GL, AP, FA, INV, OM, PO, HRMS, Manufacturing, Advance Pricing, CRM)

RDBMS: ORACLE 11g/10g/9i/ 8i/7/6, UNIFY (Ver 4.0).

Operating Systems: UNIX (AIX 4.2, MAGNIX, CITIX, SCO Unix Open Server Rel. 5), Windows 95/98/XP/NT/2003

Development Tools: Oracle Developer 2000, 6iDS, 9iDS, 10gDS (Forms 10g, Forms 6i, Forms 4.5, Report 10g, Reports 6i, Report Writer 2.5, Oracle Discoverer, SQL Forms 3.0, SQL Report writer 1.1, SQL Plus, SQL Menu 5.0, Pro*C, PL/SQL.), BI/XML Publisher, Workflow Builder, OBIEE 10g, OWB 10g, Oracle Application Express 4.2

Software Tools: Oracle utilities like export 7.1, Import 7.1, SQL* Loader 7.1

Languages: C, COBOL, BASIC.

Protocol: TCP/IP, SQL*Net(TCP/IP) 2.3

WORK EXPERIENCE:

Confidential, NC

Functional Application Support Analyst

Responsibilities:

• Analyzing day-to-day production issues and providing solution to fix those..
• Analyzed new requirements with the business users and customized the application as per the requirements.
• Handling on-going new requirements and issues in OM, Inventory and Procurement as production support.
• Converted multiple Non-WMS Distribution Centers to WMS enabled.
• Involved in Technical Design and Development of Oracle Applications Upgrade from 11i to R12.1.3 in designing the Interfaces, Modifying the custom Components in OM/AR modules.
• Modified custom Forms and Reports as part of R12 upgrade.
• Coordinated with the Business and technical consultant teams, for the business process understanding, unit and integration test script documentation, on-time delivery of documents, and identification and documentation of the custom objects
• Involved in preparing Technical Design documents to satisfy the business requirements.
• Responsible for troubleshooting Production Related issues in AR/OM/INV/PO/WMS modules.

Environment: Oracle EBS R12 ( OM, AR, AP, GL, WMS, Inventory & Purchasing), Oracle 11g, SQL, PL/SQL, Developer Suite 10g, Workflow Builder 2.6.

Confidential, Charlotte, NC

Sr. Techno-Functional Consultant

Responsibilities:

• Migrated custom Forms, Functions, Menu, Concurrent Programs and workflow from 11i to R12 and tested.
• Analyzed new requirements with the business users and customized the application as per the requirements.
• Converted third party custom application Forms and reports to Oracle Application Express and attached with EBS.
• Created Shell scripts to download and upload files for various interfaces.
• Customized Sales Order Form thru Form personalization.
• Customized OM workflow to create new notifications.
• Resolved various issues related to Sales Order workflow.
• Worked on various customized forms & reports to resolve the issues in OM, Inventory and purchasing during production support.
• Handled on-going new requirements and issues in OM, Inventory and Procurement as production support.

Environment: Oracle EBS R12 ( OM, Inventory & Purchasing), Oracle 10g, SQL, PL/SQL, Developer Suite 10g, Workflow Builder 2.6, Application Express 4.2.

Confidential, PA

Sr. Technical Consultant

Responsibilities:

• Created an interface program to Create Approved Supplier List, based on data coming from Info-Lease in ASCII file.
• Customized Purchase Order Form thru Form personalization.
• Created an interface program to Create & update employee records in HR System
• Resolved various issues related to Purchase Order, Work Order and Move Order workflow.
• Customized Sales Order Form thru Form personalization.
• Worked on various customized forms to resolve the issues in OM and purchasing during production support.
• Resolved various issues related to Pricing and Advance Pricing.
• Customized OM workflow to create a new line workflow for a new line type.
• Resolved various issues related to Sales Order workflow.
• Handled on-going new requirements and existing issues in OM and Advance Pricing as production support.

Environment: Oracle EBS R12 (Financials, Supply Chain, Purchasing and HR), Oracle 10g, SQL, PL/SQL, Developer Suite 10g, Workflow Builder 2.6.

Confidential, CA

Techno - Functional Consultant

Responsibilities:

• Designe, creation and testing reports in BI Answer and published on Dashboard.
• Creation of Subject areas as per the requirements and mapped presentation layer with the physical layer in BI Administration.
• Migration of existing Discoverer Reports to OBIEE.
• Design, Development and Testing of Data security and Dashboard security in OBIEE.
• Migration and testing Code from Dev to QA and QA to Production of Repository and Dashboard Reports.
• Performing OBIEE Admin work like New user creation, account modification of existing users, Password reset and deletion of accounts.

Environment: Oracle Applications 11i (OM, INV, AR, GL, AP, Purchasing, Install Base), Oracle 9i, OBIEE 10g, OWB 10g.

Confidential, NJ

Sr. Technical Consultant

Responsibilities:

• Customized OM workflow to Apply “RFG Bill Only Review Hold” on manually created Bill/Debit only orders in OM to create correct lease in Info-Lease.
• Created various reports using BI Publisher.
• Customized OM Workflow to Interface Sales Order with Install Base.
• Migrated Install Base data thru IB Open Interface Program.
• Being a part of designing and developing customer match solution. To avoid duplicate customer records, designed a custom solution that matches the existence of the record in TCA and provide a percentage of the match. Then Customer Maintainer group reviews the matched record and decides whether to select the matched record or create a new. The solution includes DQM setups, 2 forms and a program that derives the % of match.
• Created a concurrent program to release “RFG Bill Only Review Hold” from all the orders where a corresponding Bill/Credit Order is found in the Oracle System.
• Updated Customer and party sites using TCA APIs.
• Created various customized IB reports, e.g. Instance Status Report, Instance List for a given customer.
• Customized OM workflow to change Bill to Customer at line level based on Lesser Bill To Defined in Header DFFs.
• Created program to terminate Service Contracts using Contract APIs.
• Customized OM workflow to populate Tax Exemption details in Order.
• Customized OM workflow to apply new holds on Sales Order, based on different validations, required by business.
• Customized Service Contract Form thru Custom PLL.
• Created an interface program to interface the Info-Lease (a subsidiary of Confidential ) Invoices to Oracle Receivables. This extension will populate invoice data from ASCII file to staging table. Once the eligible invoice data has been loaded into the staging area, this program will generate additional mandatory data requisite for AR Import process. The extension will then structure the inbound Info-Lease journal data to align to Oracle AR interface table specifications and upload in interface tables.
• Created an interface program to interface the Info-Lease (a subsidiary of Confidential ) lease contract journals to Oracle General Ledger. This extension will populate journal data from ASCII file to staging table. Once the eligible journal data has been loaded into the staging area, this extension will generate additional mandatory data requisite for GL Journal Import process. The extension will then structure the inbound Info-Lease journal data to align to Oracle General Ledger’s GL INTERFACE table specification. Such structuring will also include derivation of additional data based on GL specific business rules.
• Customized Sales Order Workflow, to derive the lease rate factors and calculate lease rate based on the derived factors, while booking the orders, for the Third Party and Internal Lease orders.
• Customized Sales Order Workflow to put the hold for the orders which are eligible for supply lines.
• Customized Sales Order to add the initial supply item lines for the BOM, based on machine/mainframe item and installing entity and after adding the new lines release initial supply hold.
• Customized Sales Order form thru CUSTOM.pll, to have a menu option to derive the lease rate factors and calculate lease rate based on the factors, for the Third Party and Internal Lease orders.
• Created a customized after market routing form, to maintain location assignments to the sales persons.
• Customized Sales Order Header Workflow to populate Line Level Bill To Address based on Header DFF Values.
• Customized Sales Order Line Workflow to apply Hold, if stand-alone accessory line is not having Mainframe serial Number in KFF.
• Customized Custom.PLL to delete service lines for non-shippable lines, if service is added to BOM Header.
• Created a concurrent program to update the Time Zone field on the Warranty Coverage Template of Service contracts, with appropriate Time zone based on the “Current Location” on the IB.
• Customized Min-Max planning Report to recognize items for Service Parts replenishment in Purchase Requisition and also customized PO workflow to send the notifications.
• Customized the OM Workflow to invoke a QA check program to ensure that all the data elements for successful creation of an order and contract of type Internal Lease have been entered with corresponding valid values.
• Also done the co-ordination between the development team, testing team and migration team to resolve the issues, comes during the testing. Responsible to assign the issues to the developers and migrate the solution on time, thru migration team.
• Handled on-going new requirements in OM.

Environment: Oracle Applications 11i (OM, INV, AR, GL, AP, Purchasing, Install Base, Service Contracts), Oracle 9i, Developer 6i, Workflow Builder 2.6, PL/SQL.

Confidential, MA

Sr. Technical Consultant

Responsibilities:

• Customized Sales Order form thru CUSTOM.pll, to have a menu option to submit a concurrent request to generate a Release Document and notify to the different users by email, for the current Sales Order.
• Developed customized Sales Order Release Document thru Report 6i.
• Created a custom workflow, which will insert a step before the lines become eligible for shipment and will require a release step.

Environment: Oracle Applications 11i (INV, OM, AR), Oracle 9i, Developer 6i, Workflow Builder 2.6, PL/SQL.

Confidential, MA

Sr. Technical Consultant

Responsibilities:

• Senior Technical Consultant - responsible for data interfaces
• Developed PL/SQL packages to extract the pick release data from OM, Shipping modules and interface that with a 3rd party system, which does the ship confirmation.
• Ship confirmation details are received from the 3rd party system, which will then be updated in Oracle Apps.
• Developed various customized reports in AR
• Developed reports in BI Publisher.

Environment: Oracle Applications 11i (INV, OM, AR) Oracle 9i, Developer 6i, PL/SQL.

Confidential, MA

Sr. Technical Consultant

Responsibilities:

• Senior Technical Consultant responsible for reports customization
• Developed various customized reports in Incentive Compensation Module e.g. Sales Quota Reports, Sales Credit report. Royalty Report, Sales Club Report, Sales Commission Reports etc.
• Developed various customized reports Fixed Asset Module.
• Developed various customized reports in CRM module.
• Developed complex reports using Oracle Discoverer

Environment: Oracle Applications 11i (AR, AP, FA, GL, INV, CRM, OM, PO, BOM), Oracle 9i, Developer 6i, Oracle Discoverer, SQL, PL/SQL.

Confidential, MA

Sr. Technical Consultant

Responsibilities:

• Senior Technical Consultant responsible for Reports
• Developed various customized reports in Process Manufacturing Inventory Module.
• Developed customized Quality Assurance Metrics Report.
• Developed customized Production Status Report.
• Developed Warehouse wise Inventory Report with Lot Status.
• Customized Sales Journal by GL Account Report in AR Module.
• Developed Customer Analysis Reports based on TCA, using the HZ tables.
• Developed complex reports using Oracle Discoverer

Environment: Oracle Applications 11i (AR, AP, GL, INV, OM, PO, OPM), Oracle 9i, Developer 6i, SQL, PL/SQL.

Confidential, TN

Technical Consultant

Responsibilities:

• Developments of various interface programs and extensions for Confidential project implemented by TITAN technology partners.
• Developed Interface program to import the Invoice data from 4 different Feeder Systems to Oracle AP Invoice.
• Developed program to generate a customized order form for a segment of customers to assist them in ordering their dated curriculum materials each quarter.
• Developed Discoverer based reports

Environment: Oracle Applications 11i10 (AR, AP, GL, OM, Shipping, INV, PO), Oracle 9i, Developer 6i, SQL, PL/SQL, SQL Loader.

Confidential

Technical Consultant

Responsibilities:

• Requirement Analysis, design and development of New Forms, Reports & Stored PL/SQL Procedures for Custom Modules, Projects Maintenance and Sales Target Maintenance as the extension of Order Management Module.
• Data Migration of Sales Orders, Install Base, Price List and Sales History from legacy systems to the oracle application tables using PL/SQL procedure and interface programs. Performed data validations at staging tables.
• Customization of Repair Order and Service Request forms in CRM module thru Custom.pll.
• Developed various customized reports for Service Contract module e.g. Service Reminders, Status report, Contract Renewal reminders etc.
• Developed customized Alerts for minimum Sales Order Quantity in Sales Order Forms thru Custom.pll.
• Customized Sales Order Form thru Custom.pll to put the default Order Quantity in Line level.
• Customized Sales Order Form thru Custom.pll to show the discount percentage in header and Line level.
• Developed customized Alert for On Hand Quantity in various warehouses in Sales Order Form thru Custom.pll.
• Developed various customized Sales Analysis Reports.
• Developed Customer Analysis Reports based on TCA, using the HZ tables.
• Developed customized Alerts for minimum Purchase Order Quantity in Purchase Order Forms thru Custom.pll.
• Prepared Technical Documentation (MD 70, CV40) for custom components.

Environment: Oracle Applications 11.5.9 (CRM - Service Contracts, Install Base, GL, AP, AR, INV, OM, PO), Oracle 9i, Developer 6i, SQL, PL/SQL, SQL Loader.

Confidential

Technical Consultant

Responsibilities:

• Requirements Analysis, Design and development of Forms & Reports for Custom Module, Invoice Processing System to interface different Feeder Systems to Oracle Applications.
• Developed customized Purchase Order and Invoice.
• Developed various customized Reports for Oracle Applications PO, Inventory, AR & AP Modules.
• Developed a customized system to extract the Data from Oracle Apps for different Airlines and upload on IATA web site to generate the ICH Web Form.
• Data Migration of Sales Orders from legacy systems to the oracle application tables using PL/SQL procedure and interface programs. Performed data validations at staging tables.
• Prepared Technical Documentation for custom components.

Environment: Oracle Applications 11.5.9 (GL, AP, AR, INV, PO), Oracle 9i, Developer 6i, SQL, PL/SQL, SQL Loader.