We provide IT Staff Augmentation Services!

Senior Oracle Reports Developer Resume

Indianapolis, IN

SUMMARY

  • Over 9 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, Reports 6i/10g, 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, Oracle Discoverer 10g/9i, Oracle Designer 6i/10g, SQL*Loader, Forms 10g/6i/4.5, Toad, XML 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, Indianapolis IN

Senior Oracle Reports Developer

Responsibilities:

  • Worked extensively on creating new dashboards, Analytics, OBIEE Reports for the implementation project.
  • Effectively interacted with the end users for requirement gathering and defined requirement specifications documents.
  • Worked on upgrading lot of discoverer reports from 11.0.3 to 11.5.10.
  • Extensive work in Oracle discoverer desktop, Plus and Administration tools.
  • Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
  • Created business reports using BI Answers as per requirements.
  • Generated various Analytics Reports using global and local filters.
  • Created new analysis for OBIEE.
  • Worked on customization of Out of box Dashboards in OBIEE.
  • Developed many Oracle and XML Publisher reports for almost all the modules.
  • Developed many BI Publisher reports using BI publisher 11.1.1.6.
  • Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
  • 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 in creating folders, workbooks and worksheets in Oracle discoverer 10g.
  • Worked on the XML Publisher in developing and upgrading the oracle reports to XML Reports.
  • Mostly involved in database development along with the reports.
  • Extensively worked on creating OBIEE Analysis and Dashboards for Supply Chain, Financials and Procurement Modules.
  • Created item classes, conditions and joins using Discoverer Administrator.

Environment: OBIEE 11g, PL/SQL, SQL*Plus, Perl, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), 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, Miami FL

Senior Oracle Reports/Forms 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
  • 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, TCA, PL/SQL, SQL*Plus, Perl, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, OAF, OBIEE 10.1.3.X, System administration, SQL Navigator, SQL Developer, Oracle Weblogic, 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, TCA, 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 Confidential .
  • Created Opex reports for extracting the operational expenses of the company.
  • Developed FSG reports for the Confidential 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
  • 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
  • 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, TCA, 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

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.

Hire Now