SUMMARY:

• Over 10 years of experience as an Oracle Applications (E - Business Suite) Consultant and Technical Developer with expertise in Oracle Financial modules (GL, AP, AR, FA), AOL and System Administrator.
• Skilled in RICE (Reports, Interfaces, Conversions, Extensions) and Workflow components.
• Experience in Order to Cash, Procure to Pay cycles.
• Very Good Knowledge and understanding of Application Object Library (AOL) and Trading Community Architecture (TCA).
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interface, APIs and UTL FILE Packages.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Extensive experience in development and customization of Forms and Reports.
• Proficient at Logical Apps and Forms Personalization.
• Generated many reports using XML/BI Publisher.
• Experienced in developing reports by using bind and lexical parameters using Reports 6i/9i/10g.
• Worked extensively on Oracle Discoverer (Desktop, Administrator, Plus, Viewer) which included working on report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Experienced in Performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Forms 6i, Reports 6i.
• Extensive experience with Oracle Application Framework
• Experienced in loading data into Oracle Database using Data Loader and SQL*Loader.
• Involved in preparation of various documents like MD070 (Technical Design) documents using AIM Methodologies.
• Overall strength lies in precise translation of business requirements into technical documents. Proven ability to quickly learn and apply new technologies with strong technical background.
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS:

ERP: E-Business Suite Oracle Applications Versions R12/11i

Oracle APPS Modules: Oracle Purchasing (PO), Oracle Receivables (AR), Oracle Payables (AP), General Ledger (GL), Project Accounting (PA), iProcurement, iExpenses, SYSADMIN, Application Object Library(AOL), Workflow, HRMS, Fixed Assets(FA),Alerts.

Processes: Order to Cash and Procure to Pay processes

Development Tools: Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Discoverer 10g/9i, BI/XML Publisher, Oracle Workflow 2.6.3, Oracle JDeveloper

Database: Oracle 8i/9i/10g, 11g, Access, SQL Server 2000, Microsoft SQL Server 6.5

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer.

Programming Languages: SQL, PL/SQL, C, C++, HTML, Unix Shell Scripting, Java, XML

Operating System: Windows 98/NT/2000/XP, SUN Solaris 2.5/5.6, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Oracle Technical Consultant

Responsibilities:

• Developed custom reports for analyzing workforce efficiency (measures and rates the efficiency of warehouse workers).
• Developed Gates plants to release setup form in Inventory module.
• Worked on Gates Manage HTS category code form for items in Inventory module.
• Designed and developed Gates Hold Source Activity report.
• Fixed the issues in packing list report.
• Modified the purge program according to the requirement in Order Management module.
• Implemented code fixes for RMA returns issue.
• Developed PL/SQL procedure for AP data set to load data into a custom table according to the client requirement.
• Developed PL/SQL procedure for AR data set according to the client requirement.
• Generated an alert by developing a PL/SQL procedure in custom WMS.
• Modified the code in Enterprise WMS package to make schedule ship date in custom WMS same as schedule ship date in Oracle.
• Developed a PL/SQL package for Junking process issue in custom WMS.
• Modified the code in Enterprise WMS to avoid dropping the N print code from oracle to custom WMS.
• Customized the code in Enterprise WMS for Holds issue in custom WMS.
• Processed the stuck orders in custom WMS to Oracle by making changes in the code.
• Worked on Performance tuning using hints, TKprof and Explain plan.
• Involved in Production support activities.
• Analyzing the root cause on the issues and fixing the issues.
• Created migrated files using FNDLOAD and preparing migration list.
• Created technical documents MD 70 and installation documents.
• Involved in Unit testing and creating Test cases.
• Created AOL objects for all development work.
• Maintain day-to-day operations of Oracle Applications and technical support.
• Developed and Customization of Oracle Standard Reports.
• Registering Concurrent Programs using PL/SQL script file.
• Worked in AR and AP modules to develop several forms using Oracle Application Framework.
• Extensive experience in XML/BI Publisher, which included working on report development objects like data templates and RTF’s.
• Implemented the Order to Cash Cycle (O2C).

Environment: Oracle Applications 11i, GL, AR, AP, PO, INV, OM, WMS, OAF, Oracle 10g, Forms 6i, Reports 6i, Discoverer 4i, Workflow, XML/BI Publisher, TOAD.

Confidential, Columbus, IN

Oracle Technical Consultant

Responsibilities:

• Developed custom forms in AP using Oracle Applications FrameWork (OAF).
• Worked in production support team to resolve issues in OM, PO, AR and AP modules, implemented various code fixes and data fixes
• Designed and developed Payables Open Interface Import Program to load Invoices from legacy system into Oracle Payables Base Tables.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Imported Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in GL using Journal import.
• Worked on generating additional accounting entries in GL, which are generated in the legacy system. Developed several extracts using Oracle UTL FILE functionality.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Involved in the Implementation of Procure to Pay (P2P) life cycle.
• Strong knowledge of data conversions from legacy system into Oracle Application modules
• Designed and Developed Custom Pick Release process using standard Online Pick Release API.
• Used Form Personalization to zoom out sales order form from AR Transactions screen using Oracle Forms 10g.
• Developed several Procedures and Database Triggers as per Business requirement.
• Customized the AR Invoice Report and Developed new reports for debit memos and credit memos in Account Receivables by using XML/BI Publisher.
• Built custom reports using Oracle Reports 10g to fulfill the business requirements.
• Customized Inactive Item Report and Cancelled Sales Order Report using Oracle Reports 10g.
• Customized standard reports like aging report and Invoice in Accounts Receivable.
• Involved in the workflow extension so that additional holds on orders can be applied through the workflow.
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc. Created Request Groups for reports.
• Registered user defined tables into applications using AD DD utility.
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Worked with FND PROGRAM package to Register, Delete the Concurrent Programs from the backend.
• Developed a PL/SQL program that is scheduled to submit concurrent programs in a desired sequence as per the functional document. Used standard FND API’s.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle Applications R12, PA, GL, AR, AP, PO, INV, OM, OAF, Oracle 10g, Forms 10g, Reports 10g, Discoverer 10g, Workflow, XML/BI Publisher, SQL*Loader, TOAD and UNIX.

Confidential, Exeter, PA

Oracle Technical Consultant

Responsibilities:

• Oracle E-Business (EBS)Suite Up gradation from 11i to R12
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Implemented Trading Community Architecture (TCA) to support complex trading communities and relationships within a trading community using PL/SQL.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Customized Iprocurement pages using VO Extension and Controller extension of OA Framework
• Customized supplier inquiry page using VO Extension and controller extension of OA Framework
• Developed a custom page using OA Framework to register new suppliers and submit for approval
• Worked as Production Support specialist for R12
• Worked on resolving the technical issues related to Order to Cash (O2C) and Procure to Pay (P2P) cycle.
• Used open Interface to Import Journals by GL Interface and Budget Transfer to GL by using GL-Budget Interface.
• Customized Receipts Form as per business requirement.
• Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
• Developed a Customized XML/BI Publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the inventory module.
• Created Business Area’s and Custom Folders in Discoverer Admin version.
• Developed SQL*Loader scripts to load data into staging tables.
• Worked extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
• Modified Privileges for Users using System Administration responsibility depending upon various Organizations.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.
• Followed (MD50) functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications 11i, GL, AR, AP, PO, INV, FA, OM, Shipping, iExpenses, OAF, Oracle 10g, Forms 6i, Reports 6i, Discoverer 4i, Workflow, XML/BI Publisher, TOAD and Forms Data Loader.

Confidential, Irving, TX

Oracle Technical Consultant

Responsibilities:

• Supported payroll for around 15000 employees across the company.
• Was part of the product development from the beginning of the product to its release in HRMS Family Pack J using OA Framework(OAF).
• Extended existing OA Framework pages.
• Developed custom PL/SQL procedures to perform various form functionalities on OA Framework pages (OAF).
• Created user-level personalizations, administrator personalizations, Deploy personalizations and extensions.
• Worked with Discoverer so users would have the ability to generate ad-hoc reports.
• Designed a major customization involving Oracle Inventory and Oracle Purchasing. The customization required creation of new tables, database triggers, concurrent programs and forms.
• Performed Extensive Application tuning for Order to Cash (O2C) Business process.
• Involved in designing of Conversion/Interface Implementation Strategy for Accounts Payable and Accounts Receivable.
• Involved in Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• AP supplier Interface: Using SQL *Loader loaded data from flat file to staging tables validated the records in the staging table then loaded into Ap supplier interface table. Validation scripts validated items like Vendor id, Ship to location, Currency code and so on
• Worked on Payables Open Interface Import Program to create invoices to import into Payables.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets)
• Developed, customized reports and implemented them using Application Object Library.
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc. Created Request Groups for reports.
• Customized Supplier Open Balance Report in Accounts Payables (AP) using XML/BI Publisher.
• Customized the Supplier Payment History Report, Invoice History Report in Payables using XML/BI Publisher.
• Created new users and created business areas, granting access and task privileges to the new users in Oracle Applications.
• Extensively worked on Discoverer 10g for developing Discoverer reports according to user needs.
• Validated the Standard Business Areas/Folder of Discoverer 10g.
• Worked on Custom security for Discoverer in R12.
• Ran concurrent program business views to populate the DFFs and KFFs in views.
• Expertise in generating reports using Oracle Reports10g meeting variety of Business needs including custom Reports.
• Created complex analytical reports using inline view, lexical parameters with Oracle Report 10g.
• Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Worked on UNIX shell scripts to automate the backup of the database.
• Did the basic setup of IProcurement to explain to the management the functionality of this module.
• Made some personalizations, catalog setups, stores setups, punch outs using bulk loader.
• Closely involved in OBIEE implementation for Financials Modules and got the Knowledge to Implement OBIEE for HR Modules at later stage.

Environment: Oracle Applications 11.5.10.2 -- Oracle SQL, PL/SQL, Reports/Forms 9i, OA Framework(OAF), Java, Discoverer, AOL, TOAD

Confidential, NJ

Oracle Applications Consultant

Responsibilities:

• Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).
• Involved in developing open interface to transfer the data from Oracle Payables to base tables of Fixed Assets (FA).
• Interacted with the business users and collected the requirements.
• Developed various interfaces, both inbound and outbound, which are run on the periodic basis.
• Loading the invoice information from legacy system into Oracle AR Module.
• Customized standard reports in Fixed Assets as per client’s requirements using Reports 6i.
• Created multi-layout report to hide/show columns based on the profile options of the user who is running the program.
• Created new materialized views and used existing views to increase the performance of the reports.
• Used Hints, Indexes and other tuning techniques to increase the performance.
• Further customized reports like AR Collection Aging Report, AP Aging Report and GL Journal Analysis Report using Discoverer.
• Developed various reports like PO Print Report, Invoice Printing and Attachment Report in Reports 6i.
• Performed Applications support as needed in Order to Cash (O2C) cycle.
• Customized the workflow for the PO Approval process.
• Customized Invoice Print Report, added few columns to the Standard Invoice Print Report using Reports 6i.
• Tuned Queries using Explain Plan and Tkprof .
• Involved in checking the validity and accuracy of the legacy data using PL/SQL packages.

Environment: Oracle Applications 11i, GL, AP, INV, PO, OM, FA, Oracle 9i, Reports 6i, Forms 6i Discoverer 10g, XML Publisher, PL/SQL, Workflow Builder 2.6.3.5, SQL*Loader, TOAD, UNIX.

Confidential, FL

Oracle Technical Consultant

Responsibilities:

• Upgradation and conversion of GL, AP, AR modules.
• Worked on Customer Interfaces to import Customers from Legacy System into AR.
• Developed code for GL Conversions to extract legacy journals and to load them to GL INTERFACE table.
• Journal Import in Oracle Apps, which in turn submit a concurrent program to import data to GL JE BATCHES, GL JE HEADERS, and GL JE LINES actual tables and verified the results using Journal Import execution report.
• Developed Auto Invoice and Auto Lockbox Interfaces in the AR Module.
• Worked on the Open Invoices Interface in the AP Module.
• Worked on Item Conversion in the Inventory Module.
• Created SQL*Loader scripts to map the customer data from legacy system to temporary tables and Formatted different SQL scripts to analyze the data and validate the same before loading into Oracle Interface tables. Customer interface is run to import the data from interface tables into main tables.
• Developed Custom Bitmap Reports such as Sales Invoice in AR using Reports 6i.
• Developed Custom Reports in AR namely Invoice Exception Report, Customer Credit Report using Reports 6i.
• Customized the Payments Form in Payables.
• Developed FSG Reports in GL.
• Designed, developed and registered reports using System Administration.
• Preparation of Test Cases and Installation Documents.

Environment: Oracle APPS 11i, GL, AP, AR, INV, OM, Oracle 9i, Reports 6i, Forms 6i, Discoverer 4i, SQL* Loader, PL/SQL, TOAD, Solaris OS 2.8, Shell scripting.