Oracle Apps Developer with Discoverer and Functional Experience.

Krishna M

*******.***********@*****.***

******.*******@*****.*** ----Preferred

________________________________________

Professional Summary:

• Six + years of experience in Oracle Applications 11i with proficiency in technical as well as functional aspects of Oracle Applications – Financials, Manufacturing, Supply Chain and CRM (GL, AP,PA, AR, FA, OM, PO, INV, BOM and WSH) modules and their Open Interfaces.

• Extensive experience in the customization of Oracle based systems: design, development, testing and implementation of relational database management systems using Oracle 8.0/8i/9i/11i, Forms 4.5/6i/9i, Reports 2.5/6i/9i,Workflows and other Oracle tools under UNIX and Windows platforms.

• Excellent live experience in implementation and Production Support of Oracle Applications 11.0.3 ,11i/R12 (Oracle Inventory, Oracle Purchasing, Order Management, Oracle Payables, Oracle Receivables, General Ledger, Oracle Projects, iReceivables, iExpenses, iSupplies)

• Expertise in writing stored procedures, Packages, Database Triggers and functions using PL/SQL.

• Expertise in using Oracle Discoverer 4i/9i/10g Administrative Edition and Discoverer Plus and Viewer, configuring discoverer and End User Layer (EUL).

• Expertise in BI(XML) Publisher Reports Creating Data Templates and complex XML Publisher Templates

• Expertise in Design and development of Interfaces and Data Migration using SQL*Loader, Oracle open interfaces, database triggers, procedures, interface tables, APIs and UTL Files

• Good experience in Oracle Applications 11i Application Object library (AOL).

• Extensive Knowledge on TCA (Trading Community Architecture)

• Experience in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus and providing support to Apps end users.

• Worked with business team for creating functional (MD050) and technical (MD070) design document for customizing the Order to Cash cycle.

• Expertise in Procure to Pay cycle.

• Good Knowledge of BPEL.

• Participated in the design, development, customization and support of Oracle 11i E-business applications.

• Resolved production related problems and enhanced applications according to requirements.

• Expertise in Production Support and Issue resolving and handling TARs with Oracle support.

• Worked on 24*7 environments to provide production support activities for Oracle 11i Application.

• Great learning skills to adapt the rapid changing technologies and implementing the same at work.

• Ability to plan, monitor, support and deliver on time while within the budget in high pressure environments, proactive initiation and solution oriented proposition contribution.

Education and Certifications:

• Bachelor of Technology in Electronics and Communications Engineering.

• Oracle9i SQL/PLSQL Developer Certified Associate.

Technical Skills:

RDBMS Oracle 8i/9i/10g, MS Access, SQL Server 2000

Oracle Applications Oracle E-Business suite 11i (GL, AP, AR, PO, INV, OM, WSH, BOM, CRM, HRMS), R12, AOL, Sys.Admin

Application Tools Forms 9i/6i/4.5 and Reports 9i/6i/3.0/2.5, Discoverer 3i/4i/9i/10g, TOAD, SQL Navigator, SQL*Loader, SQL*PLUS, XML Publisher, Noetix Views, KINTANA.

O/S UNIX, Windows NT/XP/2000/98, Linux, MS-DOS

Languages SQL, PL/SQL, C, C++, HTML, XML

Scripting Languages UNIX shell script.

Professional Experience:

Alcoa/ Sapa, Pittsburgh, PA Feb’08-Till date

Role: Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• To prepare MD.070 design documents for Inbound and custom programs

• Used SQL* Loader and UTL_FILE Packages for data conversion and interfaces.

• Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.

• Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program

• Defined the descriptive flex fields and key flex fields.

• Created Value sets for report parameters and registered in application using AOL.

• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.

• Worked on Auto Lockbox Open Interface for automatic processing of receipts in AR module of Apps based on electronic bank statement data.

• Developed PL/SQL Package to check data in the auto lockbox tables for compatibility with receivables and transfer the data into Quick Cash tables for the application receipts to the corresponding open transaction & update customer's balances.

• Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.

• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.

• Performed Tuning using Explain Plan, Tkprof, Hints and Indexes. Used TOAD, PL/SQL developer tools for faster application development.

• Implementation of business specific custom programs by writing PL/SQL stored procedures and UNIX scripting.

• Developed various reports like PO Print report, Invoice printing and attachment report and credit memo report in Reports 10g.

• Designed and developed Business Areas in Discoverer EUL as per the business requirement.

• Developed and customized several reports using Discoverer in Financial and SCM modules.

• Involved in reports generation and customization using reports 10g.

• Changes done to Amendments form using Form Builder 10g to amend unit prices in bulk.

• Fixed a Bug in Online Shop floor Timecard Form.

• Developed customer invoice, Purchase Order Report using XML Publisher

• Helping the users test the application and testing from development point of view. Also was responsible for End-to-End Testing.

Environment: Oracle Apps11.5.10,(GL, FA, AP, AR, PO, Pricing, OM,),R12,Oracle 9i/10g, Database, PL/SQL, SQL Navigator, Bulk Loader, Oracle Reports 6i/10g,Oracle Forms 6i/10g,Workflow Builder 2.6, Developer 2000, UNIX Shell scripting, Discoverer, XML/BI Publisher.

Foundry Networks Holding Co, Santa Clara, CA Dec’06 - Dec’07

Role: Sr.Oracle AppsTechno_Functional Developer

Responsibilities:

• Worked as Oracle Apps Developer for interfaces and customization of Reports.

• Involved in conversion of data from legacy system to Oracle Apps11.5.10.2 for different modules like Accounts Payables (AP), Accounts Payables Invoices Conversion, Customer Conversion and Purchase Order (PO) Conversion.

• Involved in writing AR Premium Extract Outbound interface program.

• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.

• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program (AP) and populated the base tables.

• Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.

• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.

• Worked on Oracle API bug in Supplier Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.

• Development of Oracle Order Management Inbound interface to load massive amount of Open Purchase Orders Programmatically by running user friendly concurrent programs.

• Involved in Writing Shell Scripts, Troubleshooting and resolving production issues.

• Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.

• Involved in customizing the forms for adding extra information through DFF’s.

• Customized various reports in OM, AR modules.

• Provided OM Mapping Utility Form, allows user to search, view and delete existing mappings for order cleanup process.

• Developed executive level reports for Inventory listing, Inventory wholesale value, Inventory retail value, listing by quantity, listing by cost, listing by date using Reports Developer 6i

Discoverer:

• Responsible for importing required Work books and BA’s from Alcoa to SAPA’s instance and also developing new work books.

• Also worked on creating BA’s, EUL, granting privileges in Discoverer Admin, creating and sharing the workbooks in Discoverer Desktop and Plus and running the reports using Discoverer Viewer

• Imported Alcoa’s Business Areas

• XXAR Base Business Area

• AEP Base Business Area

• AEP CST Business Area

• AEP DIE Business Area

• AEP MFG Business Area

• AEP OM Business Area

• XXAEP Total Profitability Solution Business Area

into SAPA’s location.

• Gave Grants on all tables and views to a custom EUL.

• Copied 52 Workbooks from ALCOA-NA Production Instance to Share point, which were cook booked and then migrated to SAPA-NA-instance.

• Validated the SQL queries in Custom Folders.

• Worked on Alcoa’s and SAPA’s custom tables.

• Created new Discoverer Reports needed for SAPA in the following areas.

• Sales Order information (bookings, prices, delivery date, credit status)

• Customer information

• Job information, routing, BOM, task dates

• Shipments, total and by various groupings (market, salesperson, customer)

• Item characteristics

• Trained End User’s and Power User’s to familiarize with Discoverer Plus and Viewer Tool.Customized Oracle standard reports and developed custom reports and forms to meet functional business requirements.

• As a Production support analyst solved issues related to GL, AR, AP, PO, OM, INV, Invoices.

Environment: Oracle Applications 11.5.9, Oracle 9i, Reports 6i, Forms 6i, SQL* Loader, PL/SQL, Discoverer4i, XML/BI publisher, TOAD, Windows XP, UNIX.

DS Waters LP, Atlanta, GA Feb’06 – Nov’06

Role: Oracle Apps Techno Functional Consultant

Responsibilities:

• Analysis, Design and Development of MD70 technical documents based on MD50 functional documents and business requirements.

• Developed custom PL/SQL conversion program for Import Journal and also loading customers using Oracle Standard Customer Interface Program.

• Design and Development of Interface Programs for Standard ITEM and BOM Load.

• Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).

• Designed Ship Confirm Interface to pick release sales orders in business operating unit as soon as corresponding factory sales orders got ship confirmed.

• Developed PO interface to import PO orders from legacy systems. Used API’s to update quantities and to cancel Orders.

• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables.

• Defined the descriptive flex fields and key flex fields.

• Created Value sets for report parameters and registered in application using AOL.

• Handled performance issues for several reports, which involved code optimizations using summary management.

• Performed the system administrator role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Request Groups for reports, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

• Designed and developed forms using Forms 6i.

• Customized Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.

• Created business areas, custom views and summary folders according to the user’s requirements in AR, OM and AP using Discoverer 9i.

• Developed the following Discoverer Reports

• BOM and Routing Conversion File

• Inventory Value Report

• Item Description Audit Report

• Order Job Status

• Orders for Existing LPNs

• Partially Shipped Orders

• WIP Job Details

• Customized the reports in manufacturing modules (INV, BOM, and WIP) like item quantity, item demand history, MIN_MAX planning using XML publisher.

Environment: Oracle Apps11i, GL, AR, INV, FA, AP, PO, HRMS Oracle9.2.0.5, PL/SQL, Discoverer 9i, Forms 6i, Toad, Windows 2000

Plasmine Technology Inc, Pensacola, FL Feb’05 –Jan ’06

Role: Oracle Apps Technical Developer

Responsibilities:

• Changing BOM supply types from assembly pull to operation pull using BOM_BO_PUB API.

• Conversion of journal entries, receivables customers and sales orders from the legacy system into 11i by creating staging tables and using interface programs.

• Customized several standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report using Reports 6i.

• Required Data Extraction from oracle applications base tables in a flat file format using UTL_FILE package.

• Worked on Pack Slip Transaction and added the functionality to create new containers using WSH_CONTAINERS_PUB.Create_Container API.

• Registered multiple Responsibilities, Applications, Programs and Reports using System Administration.

• Customized the Check Printing Report so as to print the playgroup and gross in the report using XML Publisher.

• Involved in Item Master Organization creation and implementation and defined commodity codes for use in customer items.

• Created all items of supply for Item Master Organization to enable assigning them to different organizations.

• Bank Branch and Bank Account Conversion: Involved in converting all the Bank Branches and Bank Accounts. This includes converting all the bank headers and supplier bank accounts once the supplier sites have been converted and finally linking supplier sites to respective bank accounts.

• Designed and developed various reports like pack slip report, trip Report, Open Purchase order report and AP trial balance report and registered the developed reports using AOL.

• Developed Item conversion program Items, Item to category set assignments and Categories.

• Developed UNIX Shell scripts to run the interface program and to archive the data.

• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically.

Environment: Oracle 11.5.4 (GL, AR, AP, OM and PO, HRMS, OTL), TOAD 7.5.2.0, Reports 6i, Forms 4.5, AIM 3.0, SQL *Loader, Discoverer 4i.

EMERSON NETWORK POWER, CARLSBAD, CA Nov’03 - Dec’04

Oracle Apps Technical Developer

Responsibilities:

• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.

• Responsible for documenting the mapping and requirements for the interfaces and conversions between the source and oracle Applications.

• Created Alerts to notify users on various business events.

• Extracted data from AP tables and generate a flat file (checks cut in a period) using UTL_FILE package at periodic intervals.

• Provided the users with detailed vendor reports on existing vendors from legacy system.

• Customized Bill Of Lading and Packing Slip reports.

• Customized suppliers audit report, expected receipts report, contract status reports.

• Customized the Accounts Payable Vendor Entry Form as per requirements.

• Involved in creating some Custom reports and Forms for the end users to check the details and errors.

• Customized Employee Listing report, Invoices on Hold report and Suppliers report as per the business requirements using Reports 6i and XML publisher.

• Responsible for the technical and user documentation of the customizations.

Environment: Oracle Applications 11.5.5 (GL, AP, OM, INV, AR), AOL, Alerts, Forms 6i, Reports 6i, Oracle 8i (SQL, PLSQL), TOAD, SQL Loader, Discoverer 4i

Intralogic, HYDERABAD, INDIA Jun’ 02 – Aug’03

Role: PL/SQL Developer

Responsibilities:

• Developed several reports based on user specified criteria.

• Wrote PL/SQL stored procedures & database triggers for enforcing business rules and Integrity

Constraints.

• Developed Libraries, Visual Attributes, Menus for Reusable in Form Modules.

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.

• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.

• Developed validation programs to validate the data before importing into the payables table.

• Created custom oracle views according to customer requirement, built Virtual tables and Virtual Views to satisfy reporting needs.

• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.

• Wrote Error-Handling package using PL/SQL tables to handle user-defined errors.

Environment: Oracle7.3, SQL, PL/SQL, Forms 4.5, and Reports 2.5, SQL * Loader, Window95, UNIX, Noetix Views.

Contact this candidate