SUMMARY

• Over 8 years of experience in the software industry in the Analysis, Design, Development, Testing and Implementation of Software Applications, extensive experience in technical aspects of Oracle Applications E - Business Suite (Financials) Version 9i,11i/11.0.3/R12.
• 6 years of strong experience working as Oracle Applications Technical consultant in AR, AP, GL, INV, OE/OM, PO, BOM, ALERTS, AOL, SYSADMIN modules using Oracle Applications 11.5.10/11.5.9/11.0.3/ R12, R12, Oracle D2k, Discoverer, PL/SQL, SQL, Forms 6i/10g/11g, Reports 6i/10g/11g, Oracle10g/9i/8i/7.3 under Windows 2000/NT/98/95/XP .
• Extensive experience in Oracle Applications Rel. R12/11i/ 11.0.3/10.7 (GL, AP, AR, INV, OE/OM, PO, BOM, ENG, WIP)).
• Involved in Implementations, Version Upgrades, Data Conversions and Customization of Reports and Forms in Oracle Financials.
• Knowledge of web service modules like iStore, iPayment, iExpenses, and iProcurement.
• Extensively worked in Oracle Front-end programming and Back-end development using tools like PL/SQL, SQL*Plus, Oracle Forms 10g/6i/4.5, Oracle Reports 10g/6i/2.5, Oracle Designer 6i/10g.
• Extensive experience in writing data conversion scripts for migrating legacy data into Oracle Applications using SQL Loader and PL/SQL.
• Worked Extensively on OBIEE Administration Tool and Presentation Services.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
• Worked extensively on XML Publisher and BI Publisher.
• Extensive experience to create reports in OBIEE 10.1.3.2.0 .
• Very good hands on experience with Oracle Discoverer 4i/10g which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL).
• Proficient in coding Interface Programs for importing data from Legacy Systems and Flat Files using SQL Loader.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Extensive experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration.
• Considerable knowledge in customization of workflows and in fine-tuning code for better performance.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

Oracle Apps: Oracle 9i, 11i ( 11.5.10/11.5.9/11.0.3/ 10.7), R12, Oracle EBS Financials (General Ledger, Account Payables, Account Receivables), Oracle Purchasing, Inventory, Order Management, Project Accounting, Bills of materials, Engineering, Configurator, MRP, OTM, Sys Admin and AOL, SQLNavigator, Oracle Discoverer 4i/10g, SQLLoader, Toad RDBMS Oracle 7.x/8.x/8i/9i, SQL Server 7/2000, Access 97/2000.

Oracle & other tools: Reports 4.5/6i/10g/11g, Oracle Discoverer 10g/9i, Oracle Designer 6i/10g, SQL*Loader, Forms 11g/10g/6i/4.5, Toad, XML Publisher.OBIEE 10.1.3.2.0 , Dashboards, Answers, BI Publisher.

Database: Oracle 10g/9i/8i, MS Access.

Languages: C, C++, SQL, PL/SQL, Visual Basic, Java, XML.

Operating Systems: Windows, UNIX and SOLARIS.

PROFESSIONAL EXPERIENCE

Confidential, Miami FL

Senior Oracle Apps Developer

Responsibilities:

• Worked extensively in OM, INV, AR, AP, and PO.
• Developed many Oracle and XML Publisher reports for almost all the modules.
• Developed many BI Publisher reports using BI publisher 11.1.1.6.
• Worked extensively on XML Publisher. Developed .RTF files for xml reports.
• Extensive experience in relational databases, design, development and implementation using Oracle Designer, PL/SQL, ETL and other Oracle tools and utilities.
• Worked on the XML Publisher in developing and upgrading the oracle reports to XML Reports.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Mostly involved in database development along with the reports.
• Created item classes, conditions and joins using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Developed many discoverer reports and the list includes
• Fuel Supplier Purchase report.
• Terse Sales Report.
• Profit for Fuel and Freight report.
• Customer EFT Bank information report.
• Mailing Labels Report.
• AP invoice detail report.
• Tax sales report.
• Credit card activity report.
• Developed reports using Administrative and Desktop Edition of Oracle Discoverer.
• Involved in performance tuning using TKPROF and Explain plan.
• Created indexes and modified the joins to avoid the number of full scans for Performance tuning.
• Customized many Discoverer reports 10g for financial module.
• Customized many XML and BI Publisher Reports.
• Upgraded Shipping document reports like Pick and Pack Slip reports to R12.
• Developed many discoverer reports using discoverer 10g.
• Upgraded discoverer 4i reports to 10g in financial and HRMS modules.
• Worked in customization and development of many BI publisher reports.
• Worked with development of packages, ETL functions and procedures using PL/SQL.
• Registration of Concurrent Programs into Oracle Apps through AOL and System Administration.
• Created the database schema objects like tables, views, synonyms, indexes, procedures, functions.
• Generated ad-hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues
• Worked in creating folders, workbooks and worksheets in Oracle discoverer 10g and worked extensively on noetix views creating reports.
• Developed many reports for financial, distribution and supply chain modules in version R12.
• Developed stored procedures and packages. Extensive work in PL/SQL.

Environment: Oracle applications EBS 11i (11.5.10), R12, AP, GL, AR, PL/SQL, SQL*Plus, Perl, TOAD, Developer 2000(Reports 6i/10g/11g and Forms 6i/10g/11g), Oracle Designer 6i/10g, OAF, OBIEE 10.1.3.X, System administration, SQL Navigator, SQL Developer, XML Publisher, BI Publisher, Discoverer (10.2), SQL*Loader, Windows XP, UNIX, LINUX, JAVA, PVCS.

Confidential, Kansas City, MO

Oracle Reports and Forms Consultant

Responsibilities:

• Worked extensively on Order management, shipping execution and inventory modules.
• Development of shipping documents including Pick Slip, Pack Slip, Bill of Lading, Return Authorization letter, etc.
• Personalized Transact Move order form in Inventory so that it picks up new pick slip report developed instead of standard report when reprinting the pick slip.
• Developed new reports in Oracle R12 using 10g report builder.
• Customized existing reports and modified according to user requirements.
• Developed and customized existing discoverer reports.
• Created new workbooks and worksheets for Discoverer 10g reports.
• Up gradation of oracle reports from 11.5.10 to R12.
• Developed reports using XML and BI Publisher.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked in customization of reports in OM, WSH, and INV.
• Developed reports using Administrative and Desktop Edition of Oracle Discoverer.
• Involved in performance tuning of the reports built.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL.
• Registered Concurrent Programs and custom Applications using System Administration.
• Scheduled workbooks using Discoverer Desktop.
• Developed many reports for retail, distribution and supply chain modules in version R12.
• Worked extensively on Discoverer 10g.

Environment: Oracle applications 11i, R12, Oracle EBS Financials, OM, INV, WSH, PL/SQL, SQL*Plus, TOAD, SQL Navigator, SQL Developer, Developer 2000(Reports 6i/10g and Forms 6i/10g), System administration, XML Publisher, BI Publisher, Oracle Designer 6i/10g, Discoverer (10.2), Windows XP, UNIX, LINUX, JAVA, PVCS.

Confidential, Milford, PA

Senior Oracle Reports Developer

Responsibilities:

• Worked extensively on financial module General ledger.
• Created Balance Sheets, Profit and Loss statements for Altec Lansing.
• Created Opex reports for extracting the operational expenses of the company.
• Developed FSG reports for the Altec Lansing which is the division of Plantronics.
• Customized existing reports and modified according to user requirements.
• Customized FSG existing reports to meet the needs of the business users.
• Developed and customized existing discoverer reports.
• Created new workbooks and worksheets for Discoverer 10g reports.
• Developed reports using Administrative and Desktop Edition of Oracle Discoverer.
• Involved in performance tuning of the reports built.
• Up gradation of oracle reports from 11.5.10 to R12.
• Developed reports using XML and BI Publisher.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked in customization of reports in GL and PO.
• Customized web pages in web service modules like iStore and iExpenses.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
• Registered PLSQL functions in Discoverer Administrator, so that it can be used as a calculation in the report workbooks.
• Scheduled workbooks using Discoverer Desktop.
• Developed many reports for retail, distribution and supply chain modules in version R12.
• Worked extensively on Discoverer 10g.

Environment: Oracle applications 11i, R12, Oracle EBS Financials GL, PO, iExpenses, PL/SQL, SQL*Plus, TOAD, iStore, SQL Navigator, Developer 2000(Reports 6i/10g and Forms 6i/10g), System administration, XML Publisher, BI Publisher, SQL Developer, Oracle Designer 6i/10g, Discoverer (10.2), Windows XP, UNIX, LINUX, PVCS.

Confidential, San Francisco CA

Senior Oracle Reports Developer

Responsibilities:

• Worked extensively in OM, INV, AR, AP, PO, BOM, MRP and WIP.
• Worked on Sales order interface for Japan Project for adding lines to an existing order using OE ORDER PUB API
• Developed many Oracle and XML Publisher reports for almost all the modules.
• Developed many BI Publisher reports.
• Some of the reports developed include
• Customs Invoice Report for Japan
• Packing Slip Report for Japan
• Bill Of Lading Report For Japan
• Shippers Letter Report
• On hand Quantities Detail Report.
• WIP Packing List Report.
• Intercompany AR invoice report.
• QVC Invoice Report for Japan.
• Item Master Details Report.
• Internal Requisition Status Report.
• Worked extensively on XML Publisher. Developed .RTF files for xml reports.
• Worked in MRP and Supply chain planner modules in development of forecast reports like Active forecast report and Enterprise view for MRP.
• Extensive experience in relational databases, design, development and implementation using Oracle Designer, PL/SQL, ETL and other Oracle tools and utilities.
• Worked on Inventory Item interface for loading items into Japan Org using EGO ITEM PUB API.
• Worked in Oracle Financials and Warehouse management.
• Worked on the XML Publisher in developing and upgrading the oracle reports to XML Reports.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Mostly involved in database development along with the reports.
• Created item classes, conditions and joins using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Developed many discoverer reports and the list includes
• Pricelist Details report.
• Pick slip report for all shipped orders.
• Sales order discounts report.
• UPC codes by pricelist report.
• Interface errors report in AR.
• Item velocity and item slotting reports.
• Empty locators report.
• AR Receipts register report.
• Developed reports using Administrative and Desktop Edition of Oracle Discoverer.
• Involved in performance tuning using TKPROF and Explain plan.
• Created indexes and modified the joins to avoid the number of full scans for Performance tuning.
• Customized many Discoverer reports 10g for HRMS module.
• Customized many XML and BI Publisher Reports.
• Developed dashboards and reports that were used by the business to identify most profitable customers and analyze Revenue trends to identify opportunity / risk.
• Upgraded Shipping document reports like Pick and Pack Slip reports to R12.
• Developed many discoverer reports using discoverer 10g.
• Worked in Oracle transportation management module developing some Business intelligence reports like Bill of lading, Commercial Invoice and Packing list.
• Upgraded discoverer 4i reports to 10g in financial and HRMS modules.
• Worked in customization and development of many BI publisher reports.
• Worked with development of packages, ETL functions and procedures using PL/SQL.
• Worked in Account Balance report in Lease management module.
• Worked in creating folders, workbooks and worksheets in Oracle discoverer 10g and worked extensively on noetix views creating reports.
• Developed many reports for Financial, distribution and supply chain modules in version R12.
• Developed stored procedures and packages. Extensive work in PL/SQL.

Environment: Oracle applications EBS 11i (11.5.10), R12, AP, GL, AR, HRMS, OTM, SCM, WMS, LM, Configurator, iPayments, iExpenses, iStore, PL/SQL, SQL*Plus, Perl, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, SOA, BPEL, OBIEE 10.1.3.X, System administration, SQL Navigator, SQL Developer, XML Publisher, BI Publisher, Discoverer (10.2), SQL*Loader, Windows XP, UNIX, LINUX, JAVA, PVCS.

Confidential, Washington DC

Oracle PL/SQL, Report Developer

Responsibilities:

• Worked extensively on the financial modules GL, AR, AP.
• Worked on the Accounts Payables invoice interface and payment process according to the new requirement from the Confidential .
• Customized the existing Auto lockbox interface in Accounts Receivables and added a new payment type to the already existing two payment types and changed the order in which the invoice and debit memo is being called according to the requirement.
• Worked on the change request for customization of Auto invoice in AR.
• Customized Reports and Forms to meet user’s requirements mainly in financial modules (AP, GL, AR).
• Worked with Administrative and Desktop Edition of Oracle Discoverer. Building workbooks, editing existing workbooks, adding/editing worksheets and scheduling workbooks for user.
• Worked extensively in database development like developing procedures, packages, triggers, functions, reports and forms.
• Used Designer 6i for design and database object generation.
• Tuned SQL queries for performance tuning using Explain plan.
• Customized check printing report in AP as per the specific requirements.
• Imported Regular, Debit memo, Credit memo, invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program.
• Involved in performance tuning and changing the queries for good performance.
• Worked with development of packages and procedures using PL/SQL.
• 24/7 technical support for system maintenance and monitoring and UNIX server maintenance.
• Customized OKL CS Contract Lease Renewal workflow in Lease management module.
• Created FSG reports for some financial modules for expenses.
• Created users and responsibilities using system administration.
• Worked on the XML Publisher in developing and upgrading the oracle reports to XML Reports.

Environment: Oracle applications EBS 11i (11.5.10), R12, AP, GL, AR, PL/SQL, LM, Configurator, SQL*Plus, TOAD, Developer 2000(Reports 6i and Forms 6i), Perl, Oracle Designer 6i/10g, System administration, XML Publisher, Discoverer (10.2), SQL*Loader, SQL Navigator, SQL Developer, Windows XP, UNIX, LINUX, JAVA, PVCS.

Confidential, Houston, TX

Oracle Reports Developer

Responsibilities:

• Worked extensively on the reports and forms.
• Responsible for the rebranding of the internal reports and forms, this should reflect the new name of the company CEVA which was EGL before.
• Worked extensively on XML Publisher.
• Generated Oracle Forms and database objects through Designer.
• Customized the order line workflow in order management by changing one of the functions.
• Customized hundreds of reports to rebrand the company name, operation unit name and the report titles.
• Customized invoice print report. Added few columns to the standard invoice print report.
• Customized the reps info form, added a tab canvas to the existing canvas and added all the fields to the related tabs in the canvas.
• Created couple of FSG reports to show balances and budgets in some financial modules.
• Customized the pick slip and pack slip reports in order management.
• Customized workflows in various financial modules.
• Developed Open PO XML report by creating .RTF files.
• Developed, debugged, enhanced, and tested code for the Oracle Cash Management Application using PL/SQL, Oracle Developer and Developer 2000.
• Customized the vendor report, added some columns to the existing tables. This report in particular shows weather they are women owned or minority owned.
• Worked on item conversions in inventory.
• Worked extensively in customizations of Workflows in Purchasing (PO).
• Developed reports from scratch in Project Accounting module.
• Worked with development of packages and procedures using PL/SQL.
• Registered Concurrent Programs and custom Applications using System Administration.
• Worked in customization of reports in Lease management module.
• Developed a backlog report. This is a custom report developed to find all the orders lines, which are not fulfilled, Order lines that are not shipped.
• Extensive experience working on all the phases of the development and customization of RICE components, which include documenting the specifications.
• Developed new Discoverer reports using EUL and noetix views.
• Developed and customized reports in different web based modules like iSupplier, iExpense and iProcurement.
• Upgrading the reports from 11.5.10 to the Release 12(R12).
• Developed reports using Administrative and Desktop Edition of Oracle Discoverer.
• Responsible for building workbooks, editing existing workbooks, adding/editing worksheets and scheduling workbooks for user.

Environment: Oracle applications EBS 11i (11.5.10), R12, SCM, OM, INV, OIC, AP, GL, AR, PO, WMS, FA, iSupplier, iProcurement, PL/SQL, SQL*Plus, TOAD, LM, Configurator, Developer 2000(Reports 6i and Forms 6i), Oracle Designer 6i, System administration, XML Publisher, Discoverer (10.2),Windows XP, UNIX, Linux, JAVA, PVCS.

Confidential, Columbus, OH

Oracle Technical Consultant

Responsibilities:

• Responsible for Development and Implementation of Customer Interface using TCA APIs, to bring customers created in Legacy system, on a Daily basis. Customers and Customer Sites are created in Legacy System; need to be in Oracle Accounts Receivables.
• Worked on lock box conversions.
• Developed custom GL journal upload interface program. This interface will reduce the manual creation of journal entries to record data from the sub systems.
• Created a FSG report to show the departmental expenses.
• Worked with Administrative and Desktop Edition of Oracle Discoverer. Building workbooks, editing existing workbooks, adding/editing worksheets and scheduling workbooks for user.
• Created the value sets, profile values, custom responsibilities, menus, and concurrent programs and executables for the reports and interfaces.
• Followed the Client own methodology for all the deliverables.
• Responsible for journal imports in oracle general ledger. Here I had to import the journals from all other modules like accounts payables and account receivables into general ledger.
• Worked with development of packages and procedures using PL/SQL.
• Created Logical Designs, Physical Designs, Star Schemas for Analytics Reporting.
• Designed, Developed Error reporting, including validation for execution of interfaces.
• Customized the BOM For Manufacturing Report.
• Worked on some standard reports like Vacancy Report, Average Quota Report, Year to Date compensation report in Oracle Incentive Compensation.
• Developed the following Discoverer reports using Noetix views, Discover Admin and Discoverer Plus 10g:
• GL suspense account GL report.
• GL SOX report.
• PL SOX report.
• Fee for service revenue report.
• Price variance report.
• Registered the all programs as concurrent programs under the client custom application.
• Developed a procedure for BOM explosion items. This procedure will explode the BOM to maximum of 20 levels.
• Worked extensively in various RICE components.
• Developed new .rtf files for converting Oracle reports to XML Publisher reports.
• Customized the vendor report, added some columns to the existing tables. This report in particular shows weather they are women owned or minority owned.
• Responsible for journal imports in oracle general ledger. Here I had to import the journals from all other modules like accounts payables and account receivables into general ledger.
• Designed, Developed Error reporting, including validation for execution of interfaces
• Responsible for customization of workflows in order management module.
• Worked in customization of PO Approval workflow in purchasing module.
• Registered the all programs as concurrent programs under the client custom application.

Environment: Oracle Financials 9i, EBS 11i (11.5.10), AR, SCM, PO, OM, AP, OIC, BOM, GL, INV, System Administration, Oracle Database, Oracle Portal, OBIEE 10.1.3.X, SQL*Loader, SQL Developer, SQL Navigator, PL/SQL, Forms 6i, Reports 6i, XML, Windows XP, UNIX, Linux.

Confidential, Shelton, CT

Oracle Discoverer Reports Consultant

Responsibilities:

• Developed SQL* Loader Scripts to load the receipts from the bank files into AR tables using lockbox interface.
• Responsible for Registration of Concurrent Programs into Oracle Apps through AOL and System Administration.
• Developed interface programs to import budget details in General Ledger using SQL*Loader and Budget Upload concurrent program.
• Developed a FSG report to get the details regarding the dept expense actuals vs. budget.
• Worked on Auto invoice interface for importing the invoices.
• Customized shipping transaction form in order management to print the Packing Slip Report and update DFF to indicate the user that delivery is packed. The Print Document Set button was customized to print and update DFF.
• Using the Admin edition and User edition of Discoverer, created workbooks for management based on AP tables.
• Developed Custom reports using Discoverer.
• Worked on purchase order workflow in order to set the tolerance levels and some of the attributes.
• Customized the Cost of Goods (COGS) workflow in order management.
• Developed the BOM procedure for updating the BOM inventory items with required for revenue flag which are shippable.
• Worked on all the phases of the development and customization of RICE components.
• Customized the can i build report. This report is used to know weather we can build a BOM with the given items and quantities.
• Developed the return order receipt (RMA) which updates the return orders in the order management module.
• Importing and Posting of journals from Legacy System.
• Worked extensively on XML Publisher reports.
• Created users and responsibilities using system administration.
• Registered Concurrent Programs and custom Applications using System Administration.
• Successfully carried out Data Conversions using SQL*Loader and PL/SQL Package/Procedure from Legacy system like journals, Lockbox, Budgets, Customers etc.
• Conversion of Account Opening Balances in GL and Supplier Open Invoices in AP from legacy systems.

Environment: Oracle Financials 9i,11i, GL, AP, AR, PO, OM, BOM, INV, AOL, Oracle Portal, Oracle Database, Sun Solaris, Windows NT, SQL*Loader, SQL Developer, SQL Navigator, PL/SQL, XML, Toad, Forms 6i, Reports 6i,Unix, Linux.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Involved in design and implementation of the database and GUI. Developed various Forms with Triggers, Alerts, Multiple Canvases, Multiple Window, LOVs and List Items using Forms 6i, Reports 6i.
• Developed custom reports from GL and AR modules.
• Planning and designing Flex fields’ structures, segments and value sets according to user requirements imported data from legacy and feeder systems to Oracle Financials using PL/SQL and SQL Loader.
• Implementing budgetary controls using budget journals data imported from feeder systems.
• Developed SQL*Loader files to load data from legacy system into thRA CUSTOMER INTERFACE ALL tables for importing Customer data.
• Developed concurrent programs using PL/SQL and Shell scripts these were implemented in AOL.
• Created month end feedback reports to display the receivables Accounts, Purchasing Accounts and Inventory Accounts.
• Written SQL Loader scripts for the Legacy Data Import. Also Journal Entry Interface through SQL Loader.

Environment: Oracle Applications Release 11.5.3 (General Ledger, Account Receivables, Accounts Payables, Purchasing Order), Oracle 8i, Forms 4.5, Reports 4.5, SQL, PL/SQL, Unix, Linux.