SUMMARY

• 8 years of work experience in Oracle Applications E - Business Suite 11i (11.5.8, 11.5.9 and 11.5.10) and R12 (12.0.4) as Technical Consultant.
• Responsible for understand and analyze the provided RICEW Component specifications and develop solutions by using Developer 2000, PL/SQL Developer, XML Publisher and Workflow Builder.
• Extensively worked on Oracle Applications modules like AP, AR, GL, CM, FA, PO, INV and OM.
• Have Full Life Cycle Implementation Experience on Procure to Pay (P2P) and Order to Cash (O2C).
• Creation of Reports, Menus, Functions, Value Sets, Concurrent Programs, Lookups, Database Objects, Shell scripts.
• Hands on experience in preparation of Technical documentations like MD70, CV60, MD120.
• Multiple project experience involving Implementation, Upgrade, Customizations, Conversions, Re-implementation and Support.
• Hands on experience on shell script development.
• Good experience in programs debugging, issue resolutions and providing new business solutions.
• Excellent communication and interpersonal skills to handle the client meetings and solution discussions.

TECHNICAL SKILLS

Operating System: MSDOS, UNIX, Linux, Windows 2003/XP/ Windows Vista/Window 7

Languages: SQL, PL/SQL, C, Unix Shell Scripting

GUI: Developer 2000 (Oracle Forms 6i/9i/10g, Reports 6i/9i/10g)

RDBMS: ORACLE 8i/9i/10g

ERP: Oracle Applications 11i & R12

Modules: Application Object Library, Oracle Payables, Oracle Receivables, Oracle General LedgerOracle Fixed Assets, Oracle Cash Management, Oracle Purchasing, Oracle InventoryOracle Order Management, Oracle Configurator, System Administrator, Flexfields

Tools: & Utilities: TOAD, SQL *Plus, SQL*Loader, UTL File, Oracle Workflow Builder 2.6Oracle XML Publisher, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Responsibilities:

• Extracted the data and developed report to show the Receivables Transactions based on distribution accounts.
• Developed and Registered the AR Receipt Balances Report in Oracle Applications.
• Customized Intercompany Auto Match Reconciliation Report to accommodate the new batch source invoices.
• Designed and developed the AP Paid Invoices Report for the users to get the details of the invoices paid between the particular date ranges.
• Transferred the open balance customer’s data from receivables to legacy system (GetPaid) by extracting the data from oracle applications base tables and prepared the data file using UTL File utility.
• Transferred the open balance transaction’s data from receivables to legacy system (GetPaid) by extracting the data from oracle applications base tables and prepared the data file using UTL File utility.
• Transferred the open balance receipt’s data from receivables to legacy system (GetPaid) by extracting the data from oracle applications base tables and prepared the data file using UTL File utility.
• Interfaced the journals data from ADP System to Oracle GL base tables using Journal Import Program. The data has been received as file and loaded into oracle using SQL*Loader.

Confidential

Responsibilities:

• Migrated oracle payables invoices data from 11. .0.4 of oracle applications. The data has been pulled from earlier version of oracle and loaded into the newer version staging tables using db link and then validated using oracle procedures. Finally the data is imported into oracle payables using Payables Open Interface Import Program.
• Migrated oracle receivables receipts data from 11. .0.4 of oracle applications. The data is imported into oracle receivables using Receipts Applications Programming Interface (API) Program.
• Developed journals migration program to migrate the journals into R12 GL module. The journals are inserted into the GL Interface table and then ran the Journal Import Program to load the data into GL base tables.
• Registered the custom AR Daily Collection Register Report as concurrent program using the AOL module objects like Executable, Concurrent Program, Request Group and Responsibility.
• Registered the custom Collection Summary Report as concurrent program using the AOL module objects like Executable, Concurrent Program, Request Group and Responsibility.
• Developed AR Revenue Stamp Worksheet Report using XML Publisher Administrator so that the business users can get the report output directly in excel format.

Confidential

Responsibilities:

• Designed and developed number of different accounts extract program to transfer the account details from HBOS system to Confidential system.
• Using Report builder prepared the report of AP batch vendor analysis and registered that as concurrent program and the user can submit the same from SRS window.
• Worked on Journal balances extract programs to extract the data of journal balances from Oracle and transferred to legacy systems using UTL File utility.
• Worked on Journal transactions extract programs to extract the journals data from Oracle and transferred to legacy systems using UTL File utility.
• CANDG Journals data has been imported into oracle using the standard GL Inbound Interface process using the loader program and journal import program.
• Customized AP Invoice Approval Custom Workflow.
• Resolved number of production issues on oracle applications modules.
• Actively involved in the meetings for requirement gatherings and solution discussions.
• Worked with Confidential for SR’s resolution related to the standard oracle functionality issues.

Confidential

Responsibilities:

• Created and implemented the sales orders interface methodology using OM Sales Order API for the orders raised from external portals.
• Written validation programs using SQL and PL/SQL (Procedures, Functions, Packages, and Triggers) for business functionalities like eligibility checking, order raising, provisioning and de- provisioning.
• Developed custom report to show the details of sales orders raised and successfully transferred from the external systems into oracle and scheduled the report to run on a daily basis in application.
• Developed AP Payments Preview Report.
• Open Purchase Order Details Report in XML Publisher is developed and registered as concurrent request in oracle applications with the report output in PDF format.
• Prepared Technical Design documents (MD070), Unit Test documents (TE020), Conversion Documents (CV060) and Migration documents (MD120) for the technical objects.
• Migrated the objects between different instances which are used from development and testing purposes.
• Experience in XML Template Development, Template Definition, and Data Definition modules.
• Hands on experience in financial year end closing.

Confidential

Responsibilities:

• Developed AP Statement of Account Report in payables module to get the credit and debit details for a given supplier.
• Worked on Billing Workbench Report that shows the AR Invoices created from the Billing Solution.
• Prepared the Agreements Report that shows the agreement details between NAS-NJME and their customers. This report will be scheduled daily and sent the output of the report to mails.
• Involved in the designing of Entitlement Setup Report, Transaction Summary Report, Requisition Summary Report and Uniform Returns Report which is used by the business users for reporting.
• Interfaced the purchased order data came from the legacy file into oracle using the standard purchase order import program. The data will be cleansed, validated, arranged in the proper manner before loading the same into base tables. The error details will be sent to the users after the completion of program.
• Good experience on the creation of database objects like procedures, functions, tables, views, synonyms, packages to generate the requisition numbers and transaction numbers according to the client’s business requirement.
• Developed GL Average Balance Report in GL Module which shows the average balances for the given account segment values.
• Created the SQL*Plus method report to show the supplier outstanding details and moved the file into the server SQL path and then registered the same as concurrent program in application.
• Customized Supplier Payments Summary Report in payables module.
• Customized Invoice Details Report in oracle payables in order to change the fields according to business requirement.
• Imported the daily rates from exchange system (BO) into general ledger daily rates base tables.
• Worked on Incentive Invoices Import Interface to load the incentives paid to the employees from legacy to oracle applications payables.
• Developed Entitlement Setup Custom Workflow and Uniform Requisitions Approval Workflow.

Confidential

Responsibilities:

• Developed custom report that displays all the employee expense invoice details.
• Created blanket purchase orders report that shows the blanket purchase orders and its release details for the given suppliers and supplier sites.
• Customized Distribution set listing report in oracle payables module. The new report will have new attribute details in the layout and with more parameters.
• Worked on shipping details report based on the given purchase order numbers.
• Customized the standard oracle sales order acknowledgement report.
• Prepared Inventory materials report and registered as concurrent program in oracle.
• Journals data has been imported into oracle using the standard GL Inbound Interface process using the loader program and journal import program.
• Payable Invoices are imported from other systems into oracle using loader program and the standard invoices import program.
• Prepared the package program to import the standard purchase orders from legacy system.
• Written Shell scripts to read, write, rename and transfer the files from oracle server path to other systems.
• PO Requisitions Interface to import approved requisitions.
• Worked on AP Suppliers conversion program to migrate the suppliers from legacy system into oracle applications. All this kind of master data would be migrated before the go-live date of the project.