SUMMARY

• Over 9 years of experience in Oracle Applications EBS 11i and R12 (12.1.3) which includes implementation, customization, development and production support.
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70) Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Expertise in implementing and strong knowledge of Order to Cash (O2C) and Procure to Pay (P2P)
• Experience includes design, development and implementation/post production support of Oracle Applications E - Business Suite (EBS) projects.
• Has a good experience in maintaining the team and halping them to solve the typical issues they are facing and completing the deliverables on time.
• Expertise in Oracle Applications Framework (OAF), customizations of OAF Pages, extension and creation of new OAF pages.
• Expertise in Finance and Supply Chain Management modules which includes General Ledger, Account Payables, SLA, Account Receivables, Cash Management, Fixed Assets, Project Accounting, Order Management, Purchasing, Iprocurement, TCA, Inventory and HRMS.
• Excellent technical expertise in Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Has a good experience in developing and customizing Workflows.
• Profound Experience in development of Concurrent Programs, Customization of Forms and Reports, defining profile values in AOL and System Administration
• Expertise in developing Reports using BI Publisher.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency by using TKPROF.
• Involved in developing few Discoverer Reports.
• Has a good experience in customizing and developing new Forms.
• Expertise in Oracle PL/SQL programming (APIs, Packages, Procedures, Functions, sequences, SQL Loader and other SQL and PL/SQL components)
• Excellent in team collaboration, quick adaption and problem solving wif good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 Production Environment.
• Interaction wif the Offshore Development Team for development of new components and customizations based on the business requirement.

TECHNICAL SKILLS

Application: Oracle Applications EBS 11i & R12.1.3

Process: Order to Cash, Procure to Pay

Languages: SQL and PL/SQL

Databases: Oracle 11g/10g/9i/ 8i/8.0

Tools: Forms Builder 4.5/5.0/6i/10g, Reports Builder 2.5/5.0/6i/10g, Discoverer 9i/10g, JDeveloper 10g/9i, Workflow Builder, BI/XML Publisher

Operating Systems: Windows NT 4.0/95/98/2000/2003/2007 , Unix

Utilities: SQL*Loader, SQL Navigator, TOAD, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Responsibilities:

• As a Production support analyst, conducted daily production and problem analysis, troubleshooting and quick resolution support.
• Extensively working on general data request of all finance module tables which was supposed to be submitted to Canada Revenue Agency for Audit (Income tax, HST/GST, Payroll, Excise, etc.) segregated by Legal Entity and Period Year.
• Raised an SR for a problem we are facing on Cannot Cancel Ship Confirm Action and working on the issue.
• Developed a concurrent program which sends email notifications to respective users whenever GL period is closed.
• Resolved Auto Accounting Error for PRC: Generate Draft Revenue for Single Project report for some projects.
• Working on a Sales Order Acknowledgement Report Issue in which HST/GST tax amount is not getting printed for some Orders and wrongly calculated for some Orders.
• Worked on Customer Conversion (Outbound) where we converted the customer’s data from Oracle Applications to Seibel CRM.

Environment: Oracle Applications EBS R12 (12.1.3), Reports 10g, Toad, SQL*Loader, GL, AP, AR, PA, PO, INV, OM, HRMS.

Confidential, Leawood, KS

Sr. Oracle EBS Techno-Functional Consultant

Responsibilities:

• As a Production support analyst, conducted daily production and problem analysis, troubleshooting and quick resolution support.
• Created MD50’s for Financial Applications, Functional Design for Customization.
• Extensively worked on various reports (using BI Publisher) in GL, AR, AP, FA, INV, PO, OM and HRMS.
• Developed an Employee Individual Development Plan (IDP) report in HRMS using XML Publisher.
• Developed a new report Employee Leave Approval Report which fetches the Employee approval hierarchy details in HRMS using Discoverer.
• Worked on Projects Conversion from Legacy system and implemented interface to create and update Project related data from third party system to Oracle.
• Created an anonymous PLSQL block to update the Project Task names as per the user requirement.
• Developed AP Invoice Interface which halps to import vendor invoices into Oracle Applications from External system.
• Involved in Vendor Conversion (AP) to import Suppliers, Supplier Sites and Supplier Site Contacts from legacy system to Oracle Applications.
• Involved in Customer Conversion to load Customer details by creating staging tables and performing validations and finally loading the data into base tables using API’s.
• Imported Items from Legacy system into Oracle Inventory using the Standard Item Interface program.
• Imported Sales Orders from legacy system to Oracle applications using Order Import Interface.
• Worked on the Purchase order approvals and send the Purchase Order electronically to the supplier.
• Implemented Auto Lock box Functionality in AR and involved in developing of Auto Lock box Interface.
• Worked on Purchase Order Interface to upload the Purchase Order data into Oracle Applications database Tables.
• Created the final accounting for Sub Ledger Journal Entries (JEs) and transferred the accounting to GL.
• Customized and converted existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Involved in customization of Standard Trail Balance Report using report builder as per the business requirement.
• Developed OAF search pages in HRMS as per the requirement.
• Developed new Reports using Report Builder 10g and also customized seeded reports in PO & FA
• Developed customized pages using OAFramework. Modifying existing Field Service Technical Portal by customizing Lov’s, button events, hiding regions, extending Application modules(AM), Adding new view objects(VO) and customizing the controllers as per the functional specification.
• Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.
• Created templates and data definitions for reports which conditionally display company logo information based on the operating unit.
• Developed Alerts as per the client requirement.
• Extensively worked on XML Bursting in order to send the email notifications to the respective users based on the concurrent program schedule.
• Perform Tier 2 & 3 functional support for oracle financial application issues by logging, tracking and escalating issues in accordance wif procedures.

Environment: Oracle Applications EBS R12 (12.1.3), Reports 10g, Toad, PL/SQL, SQL*Loader, GL, AP, AR, PA, IExpenses, INV, PO, OM, HRMS.

Confidential, Dallas, TX

Sr. Oracle Apps EBS Techno-Functional Consultant

Responsibilities:

• Prepared Functional and Technical documents like MD50, MD70, and MD120.
• Designed and developed Payables Invoice Interface to load invoice from legacy system into the Oracle Payables Base Tables.
• Developed AR Interface which transfers the data from source system to Oracle Receivables and creates Invoices and Receipts for the transactions.
• Setup AR as per requirement of the client wif Auto Invoice, Auto Cash and revenue recognition -contingency features.
• Worked on Trading Community Architecture (TCA) and customizing customer import program for site/contact information
• Designed and developed the inbound & outbound interfaces between the Central Oracle HR system and all the dependency systems.
• Worked on VO Extension for adding some columns in Supplier Search Page using OA Framework (OAF)
• Worked closely wif the team responsible for Setups and Customization of AP, AR, GL, FA modules for additional functionality and GUI enhancement.
• Worked on Concurrent program used to transfer data into SLA and import to GL.
• Customized the Invoice Aging Report to display only not paid Invoices wif invoice status should be approved.
• Assess the current state of Oracle IExpense, demonstrated features and capabilities of Oracle IExpenses.
• Extensively worked on forms personalization’s in financial modules.
• Developed new custom XML Reports in Fixed Assets like Asset Retirements Report, Asset categories Report, Depreciation Report.
• Involved in the process of Retirements and Reinstatements of Assets in FA module.
• Customized Invoice History Report by adding few more details related to Bank (Bank Name, Branch Name and Account Number). Prepared Bug fix templates and Unit Test case design documents.
• Developed and customized various Reports (using BI Publisher) in GL, AP, AR, FA, HRMS

Environment: Oracle Applications EBS R12 (12.1.3), toad, reports10g, AP, AR, GL, FA, me Expenses, HRMS.

Confidential, Boston, MA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Developed various interfaces, which are run on the periodic basis. The modules worked on include GL, AP, AR, PO
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Carried out module configuration, set up, implementation and roll-out of 6 new operating units and conducted Unit Testing, system testing, Integration testing and UAT. Performed functional setup steps for Multi-org and Multi-currency orgs (AR)
• Loaded data into temporary table from a flat file and then into AP Interface tables.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing variations and finally loading then into base tables.
• Worked on Purchase Order Interface to upload the Purchase Order data into Oracle Applications database Tables.
• Worked closely wif project team to deliver custom processes, reports, development and integration of product extensions to the applications.
• Developed new custom Workflows as per the user requirement.
• Extensively worked on Reports using BI Publisher.
• Handled some DBA works like registering the tables, sequences and views in oracle applications and even developed some new applications according to the requirement.
• Developed some forms and done some forms customizations extensively.
• Involved in Development of AOL objects
• Creation of Value Sets
• Defining Concurrent Program
• Developed/Customized Reports in AP module
• Invoice Report
• Bank Voucher Report
• Involved in development of Interfaces
• Auto Invoice
• AR Receipt Interface
• GL Daily Conversion Rates

Environment: Oracle Applications EBS R12 (12.1.3), GL, AP, AR, INV, PO, Reports 10g, Toad, PL/SQL, SQL*Loader

Confidential, Memphis, TN

Oracle Apps Technical Consultant

Responsibilities:

• Customized various standard reports like Invoice Register Report and Payment Register Report.
• Involved in registration of new forms and Reports.
• Wrote packages to migrate customer sites, contacts and profiles data using interface tables.
• Involved in the conversion of Inventory (INV) Items and Item Category data from legacy system to Oracle ERP.
• Customized the Order entry form as per the requirements so as to display the Allowance details.
• Worked on Open Item Interface to convert Purchased Item information from Custom Purchasing system to Oracle INV module.
• Developed a new Form based on a table according to the clients requirement.
• Customized the sales Order Form using Personalization. It should not raise sales order on weekends or public holidays.
• Customized PO Form using Personalization. Whenever user enters data on Sunday, Form should exit.
• Involved in customizing DFFs as per the business requirement.
• Extensively worked wif the discoverer tool in developing various reports using both administration and desktop editions
• Customized discoverer reports in AP, AR modules such as AP trial balance, AP trial balance Aging buckets, AP metric invoices, AP metric payments, Vendor unpaid invoices.

Environment: Oracle Applications EBS 11i, PO, AP, AR, GL, CRM Toad, SQL, PL/SQL, Discoverer.

Confidential, Boston, MA

Oracle Apps Technical Consultant

Responsibilities:

• Experience includes application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Worked wif Discoverer so users would has the ability to generate ad-hoc reports.
• Customized various reports in GL, AR, AP
• Designed and developed numerous packages and procedures utilizing various seeded APIs to load data from temporary tables into Oracle base tables.
• Developed a new Master Detailed Form based on the client’s requirement.
• Developed various interfaces, both inbound and outbound, which are run on the periodic basis. The modules worked on include GL, AP, and AR.
• Custom report to obtain details on Purchasing, Receiving and Payables wif in specified dates.
• Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price.
• Involved in developing interfaces like
• Auto Invoice interface
• Customer Conversion
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures, Forms and reports. In addition, also used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets. Setting of profile options at various levels.

Environment: Oracle Applications EBS 11i, GL, AP, AR, PO, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loaderforms 6i, Reports 6i, TOAD, Windows XP.