SUMMARY

• An Enthusiastic software engineer seeking a challenging position as an Oracle Applications Techno - Functional consultant in any domain that allows to grow professionally in an environment conductive for gaining knowledge.
• Over 8+ years of experience as an Oracle applications (E-Business Suite) Techno-Functional consultant, technical developer with expertise in General Ledger(GL),Accounts Payables(AP), Account Receivables(AR),Order Management(OM),Inventory(INV), Purchasing(PO).
• Extensive Experience in Oracle Financials R12 & 11i.
• Good knowledge in RICE Components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Extensive Experience in Customization and Implementation of Forms6i/9i, Reports 6i/9i.
• Good Knowledge in Forms Personalization and customization.
• Expertise 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 GL Interface, Supplier Invoice Interface and Customer Invoice Interface.
• Having proficiency in tools like Toad, SQL*Loader, XML Publisher, Form builder, Report builder.
• Good Experience in Order to Cash Management and Procure to Pay Business process.
• Strong Experience in Application Object Library (AOL).
• Good Knowledge in Workflows.
• 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.

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, JAVA, WEBSERVICES

Oracle Databases: ORACLE 8i, 9i, 10g.

Oracle Tools: Toad, Tkprof, 4.5.SQL*PLUS, SQL*LOADER

Environment: s: WINDOWS XP/2000/NT/9x, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Techno-Functional Consultant

Responsibilities:

• Supported and Resolved Issues in Accounts Payable in R12 Implementation Project.
• Involved in Conversion Process for Intercompany customer and supplier associations in Advanced Global Intercompany System with Oracle team.
• Good Knowledge and Exposure in I-Procurement.
• Resolved some issues in I-Procurement like Customer is getting error after checkout for one particular Purchase.
• Bug fixes for AGIS conversion in importing Customer and Supplier Associations to Oracle R12.
• Involved in scheduling all the AP jobs through Maestro job scheduler.
• Developed Wrapper Program which kicks off Transfer Intercompany Transactions to Receivables followed by Transfer Intercompany Transactions to Payables for AGIS Transactions.
• Customized Sales order form by changing order number to claim number using form Personalization.
• Developed and customized various custom forms as per new MD50 requirements and R12 changes.
• Developed various custom Pl/Sql components as per business requirements which mainly include interfaces and custom validation program units.
• Involved in Development of Interface for importing AR invoices from one of third party legacy system which validates and submits standard interface program.
• 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.

Environment: Oracle Applications R12, Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g Oracle Application Modules: OM (Order Management), AR (Receivables), AP (Payables), PO (Purchasing), TCA (Trading Community Architecture).

Confidential, MELVILLE, NY

Techno-Functional 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.
• Developed PL/SQL Procedure to remove the junk characters like carriage returns from the reports, Transaction Detail report and Open Invoice 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.

Environment: Oracle Applications 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, Circleville, OH

Oracle Apps 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.
• 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 11i, AP, AR, GL, PO, 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).

Confidential, Seattle, WA

Oracle Financials Technical Consultant

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical design Documents and user documents. Involved in problem resolution during the support phase.
• Modules and its components like Forms 6i, Reports 6i are developed/ modified in the AR, OM and AP as per the client requirements.
• Worked on the Auto invoice and Customer interfaces in AR to import the data from legacy system to Oracle application tables by creating staging tables.
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Implementation of Interface for Journal Imports from legacy system to Oracle Database.
• Implemented TCA Architecture for customers in Accounts Receivable module.
• Involved in the setting up of the Source for the invoices and the receipt classes in the Oracle Receivables.
• Registration of new forms, Creation of concurrent executables and concurrent programs for reports.
• Developed a SQL*Loader program which will populate the data from a flat file into a temporary table and registered that as a concurrent program.
• Involved in customization of several standard reports to serve important business processes very specific to the client.
• Such reports include Purchase Order Detail Report in PO, Invoice on hold report, tax analysis reports in AP and Customized AR Transaction detail report.
• Developed Payment Remittance Interface for a particular vendor which generates out and log files of payment information.
• Developed new forms using TEMPLATE.fmb and customized existing forms in the AP module according to the client’s requirements.
• Created descriptive flex fields for standard forms to allow users populate extra information.

Environment: Oracle Applications 11.5.10.2 (OM, INV, PO, AR, AP, GL), Solaris, Oracle 8i, Forms6i, Reports 6i, Discoverer 4i, PL/SQL 8.x, SQL*Loader, Toad 7. Oracle Application Modules: Order Management(OM),Inventory(INV),Purchase Order(PO),Accounts Receivable(AR),Accounts Payable(AP),General Ledger(GL).

Confidential, AL

Technical Consultant

Responsibilities:

• Developed a custom program which maps the extracted open purchase orders data to Aon and inserted the mapped data into the interface tables.
• Developed an extract script for the uninvoiced receipts data from the Confidential Inc.
• Developed a package to validate the extracted uninvoiced receipts data to Aon and inserted the data into the interface tables.
• Worked on AP Invoices Conversion to convert the paid invoices data.
• Designed and developed Staging tables, Conversion routines, and Custom PL/SQL API for Customer Import, Order Import, Open AP Invoices and Item Import.
• Designed, Documented and Developed an Interface between a third party billing system (ADC) to General Ledger, to post the journal every week from the billing system.
• Where I developed an UNIX shell script, which calls SQL Loader program to load data into custom staging tables and checks for uniqueness of the files in Unix directory to avoid duplicate data and to archive the same.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report.

Environment: Oracle Applications 11.5.10.2 (AR, AP, GL, FA, PO), Reports 6i, Forms 6i, Discoverer, Toad, SQL Loader, XML Publisher, PL/SQL Developer, SQL*Plus, TOAD. Oracle Application Modules: Accounts Receivable(AR),Accounts payable(AP),General Ledger(GL),Fixed Assets(FA),Purchasing Order(PO).

Confidential

Oracle Apps Developer and Support

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
• 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).