SUMMARY

• Over 7+ years of professional experience as a Techno - Functional consultant in Oracle Applications 11i and R12.
• Strong Hands on Implementation, Upgrade and Support of ERP packages in Functional & Technical areas of Financials (GL-General Ledger, AP- Accounts Payables, AR- Accounts Receivables, FA- Fixed Assets, CE-Cash Management), Manufacturing (WIP- Work in Process, BOM- Bills of Materials, CST- Cost Management), Supply Chain Management (INV-Inventory, PO-Purchasing, OM-Order Management) .
• Expertise in designing and configuring setups for Order-to-Cash (O2C), Procure-to-Pay (P2P) and Dropship cycles.
• Developed and customized RICE components (Reports, Interfaces, Conversions, Extensions) and Workflows as per teh client requirements.
• Experience in developing and modifying Oracle Forms and Reports.
• Hands-on experience in Data Conversion, Data Migration and Developing Interfaces, Extensions in various Oracle ERP modules.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• A strong experience wif Oracle Discoverer Tool Suite.
• Expertise in creating and customizing various reports for Oracle Applications using XML/BI Publisher.
• Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Experience in customizing standard Oracle forms wif teh use of CUSTOM.PLL, Forms Personalization and Framework Personalization.
• Extensive experience in Creating Users, Responsibilities, Request Groups, Profile Options and registering Executable, Concurrent Programs by using Application Object Library (AOL), System Administrator.
• Extensive experience in developing Functional Specifications (MD50), Technical Specification Documents (MD70) and Migration document (MD 120) using AIM Methodology standards.
• Ability to interact wif functional users and business analysts to gather requirements to recommend feasible solution(s).
• Involved in various stages of Analysis, Design, Development, Testing, and Implementation of application development process.
• Strong problem solving and troubleshooting skills, highly motivated and ability to work as an individual and also as a dynamic member in a team.

TECHNICAL SKILLS

ERP: Oracle Applications 11i, R12

EBusiness suite Modules: GL, AP, AR, PO, FA, CE, OM, CST, BOM, WIP and INV modules

Oracle Tools: Developer 6i, Developer 2000, Forms 6i/9i/10gReports 6i/9i/10g, PL/SQL, SQL*Plus, SQL Reports, SQL, SQL*LoaderDiscoverer 9i/10g, XML/BI Publisher

Languages: PL/SQL, SQL, Shell scripting, Java, C, HTML, XML

Databases: Oracle 8i, 9i, 10g, 11g

Operating Systems: UNIX, Linux, Sun Solaris, Windows 95/98/2000/XP, 2003, 2007

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Oracle Apps Techno-Functional consultant

Responsibilities:

• Involved in system study, requirements analysis, gap analysis and design documentation.
• Prepared technical specifications document (MD 70) based on teh functional requirement specifications (MD 50).
• Used SQL *Loader control file to import teh customer information provided in teh form of flat files into staging tables.
• Developed and implemented AP Invoice interface. dis involved importing data from teh legacy system into staging tables using SQL*Loader, validating teh data using PL/SQL procedure, inserting data into interface tables and running teh invoice import concurrent program to load teh data into Oracle AP tables.
• Involved in Development and Implementation of Customer Interface using TCA APIs, to bring customers into Oracle AR which arecreated in Legacy system, on a Daily basis.
• Worked wif GL tables, AR Interface and GL interface.
• Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing.
• Imported teh customers into Oracle Receivables using teh CUSTOMER IMPORT form wifin oracle applications.
• Imported customer data into Oracle Receivables tables using TCA APIs.
• Worked on building Business Areas, Discoverer Workbooks and Parameterized reports using Discoverer.
• Created business areas, custom folders, summary folders, hierarchies and item classes in Discoverer Administration edition.
• Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared teh workbooks wif teh designated users only.
• Creation of new custom reports and customizing of existing reports using Oracle XML Publisher.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing teh reports using Oracle Reports Builder.
• Designed and customized reports like New Customer Setup Report and Contract Price List Report using Discoverer.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer.

Environment: Oracle Applications 12.1.3(AP, AR, GL, PO, OM), Oracle 10g, LINUX, Reports 10g, Forms 10g, Discoverer 10g, XML Publisher, PL/SQL, SQL*Loader and Toad.

Confidential, Renton, WA

Oracle Apps Techno-Functional consultant.

Responsibilities:

• Developed Conversion program to import Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading teh data into supplier information Base tables.
• Experience in importing PO Headers, PO Lines from legacy system to Oracle Purchasing through Purchase Order Open Interface (PO).
• Designed and Developed an Item Conversion to Import legacy inventory item data using teh MTL SYSTEM ITEMS table.
• Developed custom interface program to load inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing and Oracle Inventory modules.
• Extensively used of PL/SQL programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
• Involved in checking teh validity and accuracy of teh legacy data by writing PL/SQL packages.
• Report in AP as required by teh client utilizing teh Oracle Discoverer.
• Developed a Discoverer Report to capture teh sales order line details for a category of items.
• Developed Open Purchase Orders report using Discoverer.
• Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers using Reports 10g.
• Responsible for design, development of reports across various modules using XML/BI Publisher and Discoverer.
• Customized existing Oracle Reports in Inventory Module (INV) using Reports 10g.
• Developed several new forms using TEMPLATE.fmb & customized standard forms through Custom.pll.
• Wrote MD70 and MD120 for all teh development that me have done.
• Invoices were imported from teh Excel sheets to teh Oracle Database using SQL *Loader.
• Created Descriptive Flex Fields, registered Concurrent Programs, Value Sets, Values, Report parameters, new functions, new menus, new responsibilities, new users and System Administration.

Environment: Oracle Applications R12(GL, AR, AP, PO, INV, OM, PO), Oracle 10g, Reports 10g, Forms 10g, Discoverer 10g, XML Publisher, PL/SQL, SQL*Loader, TOAD, UNIX.

Confidential

Oracle Financial Analyst

Responsibilities:

• Developed Interfaces for AP Invoices and AR Invoices from third party systems.
• Designed customer conversion strategy, data mapping and development using APIs.
• Wrote stored procedures and functions as needed by Conversion programs.
• Designed and developed ACH/ WIRE outbound Payment Interfaces to Bank of America.
• Developed Chase bank XML Check Template for In house check printing.
• Designed and Developed positive pay outbound Interface for Chase Bank.
• Worked wif Chase and Bank of America support teams for integration testing of payment outbound Interfaces.
• Customized AR to GL Recompilation Report Template and on account Credit memo Gain and Loss Report Template using XML Publisher.
• Developed Journal Entry interface by writing a custom package to validate teh data from teh flat file and populate teh same into GL interface table.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces in Oracle Financials.
• Developed automate payment and invoice creation using property manager.
• Defined approval rules that determine teh approval process for oracle applications. Rules are constructed from conditions and approvals.
• Designed and developed lease conversion in oracle property manager.
• Worked on conversion from one property to another one.
• Developed XML Reports -TM Custom Retainage Report, TM GL Account Detail By GRANT + FS Data, TM GL ACCOUNT DETAIL FOR PM DATA
• Wrote MD70, MD120 and Conversion mapping (CV60) documents for all teh development work and for migration to PROD instance.
• Support and Enhancement works in developed reports and interfaces after Go Live.

Environment: Oracle Applications Suite R12 (AP, AR, IBY, FA, GL, OM, INV, PO, OAB), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, LINUX and RDMS 11g.

Confidential, Gaithersburg, MD

Technical Consultant

Responsibilities:

• Involved in following modules INV, AP, AR, OM, WIP, BOM, FA, CM.
• Customized teh components, upgraded shell scripts, which calls reports, control files and SQL files which are in teh production.
• Migrated database objects into Oracle Apps EBS R12.
• Setup Custom Modifiers to derive discounted price as per teh business requirements.
• Worked on teh staging R12 Apps environment to convert AP suppliers from 11i to TCA Model and AP of R12.
• Developed Oracle 10g Reports using XML publisher.
• Developed Program for Item Conversion from teh legacy system to R12.
• Developed Backlog Summary report for Sales Orders.
• Developed teh templates for several reports using XML publisher.
• Developed Open Purchase Order Report.
• Involved in Item Import Interface and Item Cost Import Interface.
• Developed Margin Analysis Report which will pull all teh sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice.
• Developed Price Book Extract Report for various price lists.
• Prepared design documents (MD050) and technical documents (MD070) for all teh customizations.

Environment: Oracle Applications (R12 and 11i), SQL, PL-SQL, Oracle 9i/10g, Forms 6i/10g, Reports 6i/10g, Putty, Workflow, WinSCP, UNIX.

Confidential, Boston, MA

Technical Consultant

Responsibilities:

• Involved in developing Technical documents like MD70, CV40, CV50 and other CV documents based on AIM methodology for technical designs, conversion data mapping, designing conversion programs and extensions.
• Used Order Import to import data from interface tables to core OM tables, in Order Management (OM).
• Created Triggers to update teh amount and duration of teh renewed contracts, which are migrated from legacy system.
• Involved in Implementation of Procure to Pay (P2P) cycle which includes Items and Categories, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Worked on Tuning teh SQL Queries and PL/SQL Code.
• Performed Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Designed and developed PL/SQL interface program for batch Order Entry to validate teh data in temporary tables and send teh data to teh interface tables.
• Customized several Forms & Reports in AR to fit teh complex need of teh customer.
• Developed code for Conversions to extract legacy journals and to load them to GL Interface tables using Journal import.
• Interface programs for AR Customers and OM Open Sales orders were written using API and used extensively to import teh data into base tables.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Designed and Developed teh Back end process for Auto Lock Box Interface to read and write teh multiple files coming from Bank.
• Customized several standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.

Environment: Oracle 11.5.3 (GL, AR, AP, OE and PO), TOAD 7.5.2.0, Reports 6i, AIM 3.0, SQL *Loader, UNIX

Confidential

Oracle Apps Developer

Responsibilities:

• Involved in Customizing teh following Reports SHIPMENTS REPORT & ORDER BY ITEM REPORT.
• Developed a Vendor Import Program to import vendor information into Oracle Applications Database.
• Developed PL/SQL Program to Populate PO Requisition Interface table to import Requisitions.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along wif CustomerInterface (AR), and Order Import Interface (OM) programs to support teh interface requirements.
• Designed and developed reports for teh Cash Receipt Collection and Cash Receipt Application for customerInvoices in Accounts Receivables.
• Developed Commercial Invoice Report, Packing Slip Report, Pick slip report and Commercial InvoiceDrop Ship Report Shipping Reports in (OM Module) by using XML Publisher.
• Validated teh data and populated teh Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Involved in maintenance and support for customizations for Forms 6i, Reports 6i and PL/SQL Code

Environment: Oracle Applications 11i (GL, AP, AR, PO, Shipping, BOM, WIP, OM, INV), Oracle 9i, SQL*Loader, PL/SQL, Forms 6i, Reports 6i, TOAD, Windows 2000.