SUMMARY:

• Over 8.7 years of industry experience including Oracle Financials Test Analyst in Analysis, Design, Development, Production support, Bug Fixes, Enhancements, and team member in Implementation rollout of Oracle e - Business Suite Financials and Supply Chain Management modules.
• Extensive experience with solutions design, interfaces, data conversion, and upgrade from Oracle Applications objects from 10.7 to 11i Migration, Enhancements and customizations of Oracle Financials and Supply Chain Management modules in Multi-org environment.
• Was involved in designing the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) as per the AIM Methodology
• Full life cycle implementation experience in Oracle Applications R11i for i-Expense, Service Contracts, Install Base, Accounts Payable (AP), Fixed Assets (FA), Cash Management (CM), Sub Ledger Accounting (SLA), E-Business Tax (EBTAX), General Ledger (GL) and Accounts Receivables (AR) and Oracle Payables (AP).
• Extensive experience with XML Gateway and XML Messaging Standards.
• Extensive experience with EDI Ecommerce Gateway - Testing EDI Standard of 810, 823, 826, 856
• Extensive experience with the Order to Cash Business Flow.
• Technical experience with open Interfaces - inbound and outbound interfaces, Standard Forms Customization using CUSTOM.PLL, New Forms Development using TEMPLATE.FMB, New report development and Reports Customization and Oracle XML Publisher.
• Experience with XML Publisher and Discoverer reporting.
• Worked extensively on providing reporting solution using XML Publisher
• Worked extensively on three tier architecture using Oracle 9i/8i, SQL, PL/SQL, Forms 6i/4.5, Reports 6i/2.5, SQL*Loader, SQL performance Tuning and Workflow 2.6.

TECHNICAL SKILLS:

ERP: Oracle Applications Release 12/11i

Modules: i-Procurement, i-Expense, SLA, GL, OM, AR, AP, PO, INV

Languages: SQL, PL/SQL, Java

Databases / Servers: Oracle 9i / OracleAS 10g

GUI /Tools: Developer 2000 Forms/Reports, Developer Suite 10g, Toad, SQL*Loader, SQL*Plus

Hardware: Windows NT/2000, IBM, Intel PC Compatibles

Operating Systems: Windows 2000/XP/Vista, Linux, UNIX

Tools & Utilities: MBSA, Patch Management tools SUS & WSUS

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Oracle Financials Test Consultant

Responsibilities:

• Tested the AR, AP, GL, FA, Cash Management, Fixed Assets, SLA, EBTAX flows.
• Tested the AR Invoice Conversion
• Tested the FA Module - Mass Additions, Depreciation, Tax Book, Corporate Book, Roll Back Depreciation, Etc.
• Tested the Oracle i-Procurement module punch out’s, customizing workflows in oracle i-Procurement.
• Tested the 3PL Logistics Integration with UPS
• Tested the e-Commerce Gateway for EDI Inbound and Outbound Interfaces on EDI 810, 820, 856, 823
• Tested Oracle i-Expense - approval workflow, defining expense approval templates, setting up expense categories, etc.
• Tested Sub Ledger Accounting - Worked extensively on the XLA schema defining the Events, Journal Sources, Journal lines, integrating external systems with Oracle SLA.
• Tested I-Expense Integration - Worked on integration between oracle i-Expense and AMEX credit cards.
• Tested the INV Conversion - Worked on converting Master Items into Oracle including categories, catalogs, item attributes, etc.
• Tested the COGS - Worked on the COGS accounting defaulting in Inventory module.
• Tested the Form for Bulk Receiving, Bulk receiving function allows the receiving clerk to capture receipt of material against a service request using Barcode scanners, automatically match the received products against the Advance exchange lines, create repair and return RMA lines and create Repair Order for each Item/serial number.
• Tested a form personalization for disabling the field version number of Sales Agreement Form and in corporate the version numbering functionality through a menu item.
• Tested the Price List upload in Advance Pricing module
• Tested the Shipping Interface in OM/Shipping to integrate shipping module to and external shipping warehouse.

Confidential, Sacramento, CA

Oracle Financials Test Analyst

Responsibilities:

• Tested the Purchase Order conversion to convert old legacy contracts into Oracle Applications
• Tested the AP Invoice Conversion to convert Legacy Invoices into Oracle AP.
• Tested the AP Vendor Conversion process.
• Tested the interface to load the partner related data to support the PO functionality.
• Tested the customization to Oracle Fixed Assets
• Tested a customization to the shopping cart functionality in Oracle i-Procurement module
• Tested the Purchasing Module - PO Document Types, Approval Groups, Approval Limits, Automatic Sourcing, etc.
• Tested the ASN Interface in Oracle Purchasing.
• Tested the TCA conversion in Oracle.
• Tested the Quote Renewal Report, which will generate 30 to 45 days prior to the contract expired.
• Tested an extension object in OM and Service Contracts. This extension wills update/ transfer data elements such as Attachments, Renewal Rule, Contract Owner, Service Partner and much more information into Service Contracts from Order Management.
• Tested an extension, which will sync Install Base End Date with Contract Line End Date. This is achieved by a custom package, which will update the Install base instance end date with contract line end date. Then send a notification through a custom workflow if the instance has multiple contracts, which are in ‘ACTIVE’ state. Any exception is handled through exception handling routine.

Confidential, Los Angeles, CA

Financials Test Analyst

Responsibilities:

• Tested the Installation, Maintenance of Oracle Discoverer 10g Reports for the Record to Report and Procure to Pay Track
• Responsible for creating Test Scripts and Test Scenarios for the Oracle Reports & Interfaces.
• Involved in System Integration, System & User Acceptance Testing of the Oracle Reports, XML Publisher Reports and Interfaces.
• Responsible for Tested the following Conversions - including pre and post data audits -
• TCA Customer and prospects
• Purchase Orders
• AP Invoices
• AR Invoices
• Item and item cost
• Price List
• Modifier and Factor List
• Blanket Sales Agreement
• Knowledge Management
• Install Base
• Oracle 11i to Siebel CRM 7.8 interface
• PO Request Inbound / Outbound interface
• Entitlement Search Engine
• Service Contract QA Check
• Service Contract Auto Renewal process.
• Generate Quote Report in Service contract
• OM Quote Report in Service Contract
• Tested the AP Vendor Conversion
• Tested the APEX Document Capture Software.
• Tested the A P Invoices Conversion
• Tested the AR Invoice Conversion
• Tested the PO Conversion
• Testing and Documenting the Modules under AIM standards for different application functionality.

Environment: Oracle Applications 11.0.3/11.5.10 (GL, Service Contracts, Install Base, OM, AR, INV), OA Framework, Oracle 9i, Oracle Workflow, XML Publisher, Forms 6i, Reports 6i, TOAD, UNIX.

Confidential

Oracle Financials TEST ANALYST

Responsibilities:

• Extensively worked on OM, AR, Service Contracts, Install Base, INV and GL
• Responsible for customizations in OM, AR, GL and INV.
• Designed and developed Inbound Interface Program using API’s to load the shipped orders into standard OM tables.
• Designed and Developed a code for Importing Journals from external system into Oracle GL using PL/SQL and SQL*Loader.
• Designed and Developed a package for Importing Invoices from external system into Oracle Receivables using PL/SQL and SQL*Loader utilizing the Auto Invoice Program.
• Developed custom reports Print Sales order Acknowledgement, Print Selected Invoice(s) and Invoice Print (Portrait) using Reports 6i and XML Publisher to provide the report output in PDF format.
• Developed around 20 reports using Oracle Discoverer 10g.
• Designed and developed a package for converting Open Sales Orders from the Legacy system into OM.
• Worked on OA Framework to customize the “Create Install Base Item” pages.
• Customized forms using CUSTOM.PLL in OM, AR and INV.
• Provided production support for AR, OM, INV and GL modules with constant interaction with the end users.
• Upgraded the custom DVRU application which was built on old version (Forms 4.5) and (Reports 2.5) migrated to Forms 10g. Forms 10g provides Web based access to the system and also increases the performance of the transaction processing. The basic functionality to synchronize the system with the Voice Recording System had also to be taken care of while implementing this solution.
• The installation and configuration to deploy the forms 10g and Reports 10g to the Apps server and the Environment and the Configuration for the forms 10g to work smoothly and effectively.
• Migration of forms 4.5 to 10g
• Migration of Reports 2.5 to 10g
• Migration of Menu and PL/SQL Libraries using two step processes.
• Configuration of OracleAs 10g (Forms & Report Server) and Deployment of DVRU Applications.
• Documented the work done as per the client requirement.

Environment: Oracle Applications 11.5.10, PL/SQL, SQL*Loader, OA Framework, TOAD, Forms 6i, Reports 6i, Oracle XML Publisher, SQL*Plus, Oracle 9i, OM, INV, AR. and PO

Confidential

Oracle Application IT Analyst

Responsibilities:

• Customization of Promise Date of Sales Order form after creation of Depot Repair Service Request.
• Procedure is used to call the API OE ORDER PUB which updates Request Date, Promise Date and Schedule Ship Date of RMA line on Sales Order form as per the business logic using CUSTOM.PLL
• Co-ordinate between Onsite and Offshore teams for Effective Delivery
• Completely responsible for all development OM, Service Contracts, Install Base, AR, OM, AP, i-Expense and INV modules.
• Performed the expense report data conversion into i-Expense from a legacy system.
• Worked on i-Expense customizing the functionality for expense approval
• Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
• Designed and developed the Auto Lockbox interface program to import receipts from 3 banks. Developed the import program and used SQL Loader to load data into the AR PAYMENTS INTERFACE ALL table.
• Escalate and derive the logical conclusion, of all technical issues, that may impact the project schedule.
• Post Production support after GO-live.
• Create TARS and follow-ups with Oracle for product related issues
• Worked on Development using custom PL/SQL Package for Suppliers Data Extract File.
• Production Support for purchasing issues involving Workflow enhancements (sourced from stock).
• Modified custom program using API’s to create new contacts, address, phone numbers and others for every new customer in the Trading Community Architecture (TCA).
• Developed SQL*loader control files and did data mapping for item interface and customer interface
• Documentation of all the processes using AIM documentation methodologies.
• Involved in unit testing and reviewing the transactions, forms and reports.
• Imported the item information from previous system to oracle inventory.
• GL Interface
• Journal Import
• Update data from the legacy system to a pre-interface table using the SQL *Loader. After validating data using PL/SQL procedure load data into GL Interface table using concurrent program loaded data into base table.
• GL Daily Rates(GL): General Ledger provides the GL Daily Rates Interface table to automatically insert, update or delete daily rates in the GL DAILY RATES table. GL Daily Rates stores the daily conversion rates for foreign currency transactions.
• Customized Inactive Items Report to add a field transaction quantity to the report.(INV)
• Customized a report Distribution Set Listing (AP) to display the Distribution Set Lists as 'like' the given Distribution set Name.
• Customized Backordered Detail Report to give the information of backorder group by customer name and customer number.(OM-shipping)
• Customized Customer Items Report to add one field for Customer Status.(INV)