SUMMARY

• 10 years of experience as Oracle Applications E - Business Suite Consultant and Technical/functional Developer in Design, Development and Implementation of Oracle Applications R12 and 11i
• Experience in writing/debugging Oracle SQL PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Constraints, Indexes, Views, Materialized Views, Database Links, and Sequences.
• Good knowledge and experience in analysis, design, development, enhancements, customizations, interfacing and conversions of various modules that includes, PO, AR, AP, GL, FA, CE, GL, AOL and Project Accounting.
• Experienced in design, developing Data Conversion Programs, customizing reports using PL/SQL, Oracle Internet Development Suite (Forms & Reports 10G/9i/6i), and TOAD, XML Publisher.
• Strong Technical and Functional knowledge in financial modules like AP, AR, FA, CE, GL &PA.
• Good knowledge and experience in Business flows like procure-to-pay (P2P) & Order to Cash (O2C).
• Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
• Expertise in developing and customizing Reports using Oracle Report Builder (10g/9i/6i) and BI Publisher in Oracle Applications.
• Experience in development of Workflows using Oracle Workflow Builder.
• Good understanding and experience in TCA architecture and Sub Ledger Accounting (SLA).
• Experience in entire phases of Software Development Life Cycle SDLC such as Analysis, Process Engineering, Design, Development, Deployment, Testing, and Support.
• Technically proficient in RICE (Reports, Interfaces, Conversions, Enhancements) methodologies.
• Experienced in Implementation, version upgrade, support & maintenance projects.
• Good knowledge of dependencies and relationships between various application modules with knowledge of interfaces and API's.
• Involved in Financial conversions, which included data gathering from the client, validation and upload into Oracle. Standard and Custom Oracle API's were used.
• Extensive experience in back end database development using tools SQL*PLUS, TOAD.
• Has good experience in Forms Personalization’s.
• Worked on outbound interfaces using UTL FILE
• Experienced in Performance tuning.
• Developed EFT templates for Different Banks formats.
• Worked on various WEB ADI templates to load the data from desktop applications to EBS.
• Worked on AME for AP invoices Approvals.
• Designed functional and technical documents using AIM methodologies (MD50, MD70, CV40, CV70, AN-100, DS-140).

TECHNICAL SKILLS

Oracle Applications: R12 / 11i Purchasing (PO), Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), Cash Management (CE), Application Object Library (AOL) and Project Accounting (PA).

Programming Languages: SQL, PL-SQL, UNIX Shell Scripting.

Web Technologies: HTML, XML

Data Loading Tools: Data Loader

GUI/Tools: SQL*LOADER, SQL Developer, PL/SQL Developer, Oracle Workflow Builder, Oracle Forms, Oracle Reports, Toad, XML Publisher, SQL Plus.

RDBMS / DBMS: SQL, PL/SQL, Oracle 8i / 9i /10g

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Techno-Functional Consultant

Responsibilities:

• Worked on the OM, OTM, INV, AP, AR, modules.
• Created DS-140 Technical Design Documents for various RICE objects as per RICE components design and build standards of OUM methodology.
• Created TCA related and other Business Events for Meeting the Business requirements.
• Worked on Customizing Reports as per client requirements
• Worked on EFT (E-text templates) used for banks payments.
• Worked on OTM process and calculations for Freight and fuel surcharges for a sales order.
• Developed Multiple RICEF of XML reports and Interfaces.
• Developed multiple forms personalization son Sales order form as per client requirements.
• Developed Credit card invoices interface with SOA as a Medium.

Environment: Oracle 10g, Oracle Applications R12.2.5 (OM,INV,WIP,OTM, AR, AP, PO, GL, CE), Oracle Workflow Builder, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP, TOAD.

Confidential, Tampa, FL

Techno-Functional Consultant

Responsibilities:

• Worked on the entire lifecycle of the project including Analysis, Design, and Development, Unit Testing, QA Testing support, transition and post-production go-live support.
• Worked on various conversions to import data (Fixed Assets, Invoices and Customer Invoices) from the legacy system into Oracle Applications.
• Worked on the complete financial modules.
• Primarily responsible for Handling tickets/tasks and application support to the end-user.
• Worked on Customizing Reports as per client requirements.
• Worked on WEB ADI templates.
• Worked on Customizing Reports as per client requirements.
• Worked on AME for AP invoices Approvals
• Developed the interface program to interface sales order data from legacy system to Oracle Account receivables.
• Involved in setup and customization of ORACLE Payables and developed a code to interface invoices.
• Developed a custom code for conversion of Vendor and Invoice information from the legacy system to Oracle Application AP module.
• Configured AP: Setup like Payment Terms, Hold and Release Names, Period Types, Periods, AP Accounting periods, Financial, and Payable Options, Banks etc.
• Worked on Supplier conversion interface, to process the Supplier information from a legacy source to Oracle Applications.
• Developed multiple EFT templates for Different Bank Formats.
• Converted Purchase Orders from existing PO systems into the Oracle Purchasing module
• Customized PO Requisition Approval and PO Approval workflows
• Worked on PO cancelled report for Oracle cancelled POs
• Customized reports like Printed Purchase Order Report and Printed Requisitions Report using XMLPublisher.
• Developed a custom program to import journals from legacy system into Oracle General Ledger.

Environment: Oracle 10g, Oracle Applications R12.2.4 (FA, AR, AP, PO, GL, CE), Oracle Workflow Builder, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP, TOAD.

Confidential

Techno-Functional Consultant

Responsibilities:

• Developed new interfaces in replace of 11i obsoleted components.
• Upgrading the technical components of 11i.
• Remediated conversions as per R12 modifications.
• Techno functional roles played in the processes of Purchase orders coming from third-party systems
• Developed new code to fulfill tax calculating functionality in R12 for supplier invoices
• Developed UNIX codes used for integrating with third party systems.
• Developed a custom program for AR interface to validate the invoice data and import it using auto invoice import program.
• Developed a custom program for AP interface to validate the vendor invoice data and import it using payables open interface import program.
• Worked on TCA API's and developed a custom program to validate and import the customer addresses from third party system.
• Developed a custom program to import budget data into GL using GL Interface program.
• Customized the Invoice Print New Invoice report, print statement report in AR to display the output in PDF format using BI Publisher.
• Customized the Check Print Report Template for R12 as per client requirement.
• Developed the following reports of Purchasing module using Discoverer
• PO Requisition Details Report
• Open PO report by buyer
• Customized the Printed purchase order report in PO to display the output in PDF format using Bi publishers per client requirement.
• Involved in design, coding, development, documentation and postproduction support.
• Worked as a Member of the Production support system to address day to day issues.
• Involved in preparing technical and functional documentation (DS-140, MD70) for Packages, Procedures and Reports etc.
• Worked extensively with oracle support to resolve the issues by creating the SR's.
• The Initial phase was to upgrade the Purchasing, Order Management, Receivables and Account Payable.
• Involved in the modification of custom forms for R12 upgrade for MOAC feature of R12.
• Designed and developed custom Interface program for Conversion of inventory Items into Oracle Applications after doing required validations to meet the Business Requirement.
• Created Item Templates to be used for defaulting certain attributes while loading Inventory Items.
• Developed a Custom All Inventory Value Report using Reports 10g in the Inventory Module.

Environment: Oracle 10g, Oracle Applications R12 .2.3 (AR, AP, PO, GL, PA, FA&CE), PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP, TOAD.

Confidential

Techno-Functional Consultant

Responsibilities:

• Bug fixing against the tickets
• Testing and Review of the changes made to fix the bug.
• Maintaining Interfaces developed in existing NOP system.
• Internal review of technical documents and code.
• As a technical consultant, responsible for solving the technical issues faced by the users.
• Responsible for regression testing
• Participated in patch testing
• Data fix against the tickets
• Raising tickets to DBA team for server related issues faced by users
• Responsible for handling the interface errors faced by the users
• Technical analysis of oracle patches
• Responsible for Migrating the legacy data into GFS.
• Involved in requirements gathering, analysis and development.
• Designed and developed a custom code to load AP Invoices from legacy system to Oracle system.
• Involved in Unit Testing, integration and System Testing. Worked on bug fixing and enhancements.
• Used PL/SQL features like PL/SQL tables, Programs for error handling, implicit and explicit cursors for data processing.
• Developed many custom interfaces for sending Email Alerts and Notifications to the email groups using Custom Packages, Triggers or Oracle Alerts.
• Created many views for the Discoverer and also common functions, procedures according to the business requirements.
• Preparation of technical design document MD070, installations document MD120 and technical process/data flow chart.

Environment: Oracle 10g, Oracle Applications 11i (PA, AR, AP, PO, GL, Inventory, CE&FA), Oracle Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 6i, Oracle Forms 6i, SQL*PLUS, UNIX, Windows XP, TOAD

Confidential

Techno-Functional Consultant

Responsibilities:

• Converted receipts from the legacy system and imported into Oracle applications using the Receiving Transactions Open Interface.
• Customized following reports as per the client's requirements in Purchasing.
• Printed Purchase Order Report
• Printed Requisitions Report
• Personalize purchase Order Form as per to customer requirements.
• Customized invoice Print Report in AR as per the Business needs.
• Customized standard Journal Reports in GL as per the client requirement.
• Created and designed invoicing for the customers using XML Publisher.
• Customized following reports using XML Publisher
• Account Analysis Report
• Consolidation Exception Report for Subsidiary accounts
• Invoice Register Report
• Open Purchase Orders (by Buyer)
• Open Purchase orders by cost center
• Open & manage Oracle TARs to resolve implementation issues.
• Coordination with the users for their Business, Training and Documentation.
• Responsible for providing Post Production support by solving user queries and coordinating the development of any enhancements as required.
• Involved in user training.

Environment: Oracle Applications 11.5.10.2 (OM, AR, AP, PO, GL, Inventory, BOM, WIP), Oracle Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 6i, Oracle Forms 6i, SQL*PLUS, UNIX, Windows XP, TOAD.

Confidential

Techno-Functional Consultant

Responsibilities:

• The Goal of this project is to build a mini ERP that consists of 4 modules (Procure to Pay) in oracle applications.
• Involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
• Worked as a Developer in building the Procure to pay cycle. Understanding the code and develop the code accordingly.
• Worked as a member of Production Support Team to solve the Daily Tickets opened by the Business Users.
• Generated the extract report for the Price List changes using Reports 6i.
• Creation of database links to connect to the other server and Access the required info.
• Created database triggers to validate complex integrity.
• Created SQL Queries using Toad and scheduling some of the custom Reports.
• Import and export of data for development and unit testing of applications.
• Developed and enhanced various Business and ad-hoc Reports.

Environment: Oracle Applications 11.5.8 (OM, AR, AP, PO, GL, Inventory), Oracle Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 6i, Oracle Forms 6i, SQL*PLUS, UNIX.

Confidential

Oracle Application Developer

Responsibilities:

• Developed programs using PL/SQL and many packages to do the validations as per requirements.
• Extensive usage of PL SQL Collection Types to resolve many performances related issues.
• Troubleshooting and fixing the issues while monitoring the batch jobs.
• Developed Database Triggers to enforce security.
• Run SQL queries and return the results to the requestor.
• Prepared design document test scripts for the applications.
• Prepared Technical documents for new Enhancements.

Environment: Oracle Database 9i, SQL, PL/SQL, SQL*PLUS