PROFESSIONAL SUMMARY:

• Over 7 years of experience as an Oracle applications E-Business Suite Technical developer.
• Good knowledge in RICE Components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Good Knowledge in Forms Personalization and customization.
• Having proficiency in tools like Toad, SQL Loader, XML Publisher, Form builder, Report builder.
• Designed Technical Documentation using AIM Methodologies MD050, MD070, CV040, and CV070 .
• Good Technical Ability in understanding a project and steps followed in completing the project.
• Good Knowledge in Oracle Financial Modules Accounts Payable, Accounts Receivable, General ledger, Cash Management.
• Experience in design and development of Interface/Conversion programs to import data from legacy systems and integrate into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like Supplier Invoice Interface and Customer Invoice Interface.
• Experience in Customization and Implementation of Forms6i/9i, Reports 6i/9i.

TECHNICAL SKILLS:

• Oracle Apps Versions: R12 11i
• Oracle Apps Modules: OM, AR, AP, INV, PO, GL, APPLICATION DEVELOPER, SYSTEM ADMINISTRATION.
• Oracle Apps Flows: O2C and P2P Flows
• Apps Technical: Oracle forms 6i/10g , Oracle Reports 6i/10g , Oracle Workflow Builder,
• BI Publisher XML Publisher , SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML,
• Oracle Databases: ORACLE 8i, 9i, 10g
• Oracle Tools: Toad, 4.5. SQL PLUS, SQL LOADER

Environments: WINDOWS XP/2000/NT/9x, UNIX.

EXPERIENCE:

Confidential

Role: Oracle Applications Techno-Functional Consultant.

Responsibilities:

• Worked on Customization of Purchase order and Requisition workflow where user can terminate the workflow which are in InProcess and Pending State.
• Developed MD050 and MD070 documentation for up gradation from R12.0.6 to R12.1.3.
• Involved in Retrofitting the RICE components in R12.1.3 with existing customizations from R12.0.6.
• Developed Global Customer Asset Detail Report, Additions Report and Retirements Report for Venezuela Operating Units in Fixed Assets.
• Developed Global Consulting Engagement Report using Discoverer Administrator.
• Worked on Data fixes in Procure-Pay as part of daily Production Support.
• Worked on development of enhancements in Procure-Pay cycle.
• Developed shell scripts which provides the file versions in R12.1.3 as part of up gradation from R12.0.6.
• Effectively Worked on Functional Testing on 12.1.3 Upgrade as part of Up gradation from 12.0.6 to 12.1.3.

Environment: Oracle Applications R12.0.6, R12.1.3, Oracle 10g

Oracle Application Modules: I-Procurement/Purchasing, Accounts Payable, General Ledger, Fixed Assets.

Confidential

Role: Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked on Development of Importing invoices from legacy system NAVISION to Accounts Receivable module.
• Worked on archive and purge process that will save the AR invoices in a file until a given date and then deletes the records from tables.
• Good Knowledge and exposure in I-Expense AMEX Credit Card Integrations.
• Involved in Loading and importing credit card transactions and exporting the expense report into Oracle Payables in Oracle Financials.
• Involved in Procure-to-Pay process from creating requisition, PO, confirming the Receipt, creating Invoice, Paying the supplier and Transferring to GL.
• Designed and developed Interface Programs to import orders from legacy system using Order import into Order Management.
• Customized Sales Order form to add customer fax, email and phone number contacts.
• Worked on Development of creating receipts from cash management and apply it to invoices loaded in Accounts Receivable Module.
• Designed MD70 for General Ledger report Libro Giornale which pulls data from all sub ledgers interfaced and data from source systems as part of AIM Documentation.
• Customized General Ledger report Libro Giornale of general ledger data inclusive of all interfaced sub ledgers and data from source systems using XML Publisher.
• Developed shell scripts for importing AR invoices which calls SQL Loader,Custom validation procedure which runs through autosys.
• Resolved issues in AR automatic import process and manual upload to load invoices into Accounts Receivable module as part of production support.
• Designed MD70 for AR Interface import from legacy system CBS BIlling system to Oracle Receivables in Oracle Financials as part of AIM Documentation.
• Worked on development of AR import based on mapping rules and incorporated business validations to the existing
• Interface developed for other billing system feed to Oracle Receivables Navision in Oracle Financials.

Environment: Oracle Applications 11.5.10.2, Oracle 10g, SQL, PL/SQL, Reports 6i.

Oracle Application Modules: Accounts Receivable AR , Accounts Payable AP , TCA Trading Community Architecture .

Confidential

Role: Oracle Applications Technical Consultant

Responsibilities:

• Customized AP Matching holds buyer report by adding Voucher in the report and changes made to work in R12.
• Worked on Customization of Contractor Verification Report where contractors required to work on different Purchase orders in multiple time frames as part of Production Support.
• Created Templates for Sales, Invoices RTF Template , and defined Data Definitions for the templates to generate the reports with XML Publisher.
• Resolved Issues in Accounts Payable and Purchasing as part of Production Support.
• Customized expense report page in I-Expenses by adding custom messages.
• Developed various custom Pl/Sql components as per business requirements which mainly include interfaces and custom validation program units.

Environment: Oracle Applications EBS R12, Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g

Confidential

Role: Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in Conversion Process for Intercompany customer and supplier associations in Advanced Global Intercompany System with Oracle team.
• Bug fixes for AGIS conversion in importing Customer and Supplier Associations to Oracle R12.
• Involved in development of item import conversion from legacy system to R12.
• Developed Wrapper Program which kicks off Transfer Intercompany Transactions to Receivables followed by Transfer Intercompany Transactions to Payables for AGIS Transactions as part of Production Support .
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables in Oracle Procurement.
• Created Templates for Sales, Invoices RTF Template , and defined Data Definitions for the templates to generate the reports with XML Publisher
• Extensively worked on Procure to Pay P2P and Order to Cash O2C cycles.
• Involved in Procure-to-Pay process from creating requisition, PO, confirming the Receipt, creating Invoice, Paying the supplier and Transferring to GL.
• Involved in the development of the functional, design and technical documents using Oracle AIM Applications Implementation Methodology
• Involved in Development of Interface for importing AR invoices from one of third party legacy system which validates and submits standard interface program.
• Extensively worked on OM/Shipping reports, which includes the Sales Order Acknowledgment Report, Packing Slip Report and Commercial Invoice Report.
• Developed AR receipts interface to load receipts using AR RECEIPT API PUB. This API creates cash first and applies and voids cash to related invoices.
• Customized AR Invoice aging report based on Customer profile class.
• Worked on enhancements in Inventory by Updating Item id in item master table using API EGO ITEM PUB.Process Item in R12 Implementation Project as part of Production Support.

Environment: Oracle Applications EBS R12, Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g

Oracle Application Modules: OM Order Management , AR Receivables , AP Payables ,SLA, PO Purchasing , TCA Trading Community Architecture .

Confidential

Role: Oracle Applications Technical Consultant

Responsibilities:

• Oracle Receives EDI files from third party system and the file is loaded by AP team for Processing Payments. Used SQL LOADER to load the files from third party system into Oracle.
• Performed various validations required like Duplicate file check, Discard Data and Validate data.
• Once the Records are loaded Custom Match will take the success records from Oracle and load into their system and perform their own validations and those records will be picked up by oracle.
• Performed File Generation Process to generate the expense files based on various tools for different customers.
• Generated the expense files in Timex for Timex Based Customers and VMS tool for VMS based Customers.
• After File Generation process, developed regeneration process for VMS based customers as they require some files in Timex Format and VMS format.
• Created Different Concurrent Programs like ADE: LOAD AND VALIDATE, ADE: LOAD AND PROCESS REBILL and ADE: FILE GENERATION AND PULL PROCESS for successful completion of Customer rebilling.
• Customized Vendor Minority Custom Report by adding additional columns and registered as concurrent program as part of production support.
• Developed PL/SQL Procedure to remove the junk characters like carriage returns from the reports, Transaction Detail report and Open Invoice Report as part of production support.
• Involved in customized the standard reports like commercialinvoices, Sales Order Acknowledgement, AR invoice print report, AP check printing report.
• Customized Vendor Payments Report by adding Lockbox process date, receipt date and registered as concurrent program.
• Performed Geo Extract which e-mails associates information files to specific users defined in corresponding value set.
• Worked on E-Purchase Development for Automation of UPS file export which involves migrating of SQL server Scripts into Oracle and FTP to GENTRAN Internal Server and SFTP to UPS.
• Resolved Production issue on Consolidation of invoices as some invoices are not able to consolidate because of some flags defined in system.
• Created Elite Change Management tickets for approvals and move the code into Testing and Prod Environments.
• Involved in on call support for updates and make changes as part of Production Support.

Environment: Oracle Applications EBS 11.5.10, Oracle 10g, SQL, PL/SQL, Forms 6i, Reports 6i.

Oracle Application Modules: Accounts Receivable AR , Accounts Payable AP , General Ledger GL .

Confidential

Role: Oracle Applications Techno-Functional Consultant

Responsibilities:

• The project involved implementation of data conversions and customization of reports. Main modules in this project are AP, AR, GL and PO.
• Developed, implemented and unit tested AP Invoice interface. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application
• Involved in Development and some enhancements in Purchase Order Conversion..
• Involved in Development of Vendor Summary Report Paper in Procurement.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Customized AP invoice form using form personalization. Customizations include adding menus, Hiding fields and changing prompts.
• Involved in implementation of data conversions in various modules and customization of Reports and worked on different tools like BI publisher, Discoverer to generate the reports.
• Developed PO Vendor Report,Vendor ledger report using XML Publisher

Environment: Oracle Applications EBS 11i, AP, AR, GL, PO, BOM, TOAD, PL/SQL, SQL LOADER, Reports 6i, forms 6i, UNIX shell scripting.

Oracle Application Modules: AP Accounts payable , AR Accounts Receivable , GL General Ledger , PO Purchase Order .

Responsibilities:

• Wrote Procedures and Functions to validate data in custom tables and populated Invoice interface tables.
• Customized AR account status Report, and AP Trial Balance Report using Report 6i Tool.
• Developed Vendor conversion program, which include formatting, validation, reporting and loading of vendors into PO.
• Involved in Development of import and Validation Program of Journal Import.
• Registered various applications, reports, PL/SQL packages, Request Sets, Forms, Menus and Tables.
• Responsible for gathering Business Requirements, creation of Technical / Functional design Documents and user Documents..
• Created custom reports and Customization of Standard Reports in AP, which includes extensive PL/SQL code Procedures and Functions ..
• Extensively worked on report attributes like Report triggers, Program units, Attached libraries and Built-in Packages.
• Extensively worked on Format triggers, Formula columns, Summary columns, Placeholder columns and Ref Cursor Query for developing the reports and prepared complex Data Model and Data Layout in Oracle
• Reports 6i..
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL Loader routine and Reports with Application.

Environment: Oracle 8i, SQL, PL/SQL, Oracle Reports 6i, Discovere4i, TOAD 7.

Oracle Application Modules: Accounts Payable AP , Accounts Receivable AR , Order Management OM , Purchasing Order PO , General Ledger GL .