SUMMARY

• Over 8 years of experience as managing substantial components of large - scale ERP implementations and support of business applications using Oracle Applications.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Outstanding Functional/Technical knowledge in Oracle Applications Oracle Financials like (GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), PO-Oracle Purchasing, OM (Order Management/Advanced Pricing), Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials), Install Base, Service Contracts, iExpenses, iProcurement and AOL (Application Object Library).
• Have hands on development experience in SQL, PL/SQL (Procedures, Packages, Functions, and Triggers), Oracle Reports 9i/10g/11g and Forms 9i/10g/11g, XML Publisher.
• Having skills in Oracle 9i, 10g, 11g environments using SQL, PL/SQL, Developer 2000Oracle (Forms 9i/10g/11g and Reports 9i/10g/11g).
• Possess good expertise in developing programs using SQL*loader, Toad and PL/SQL
• Experience in Designing and developing reports using XML/BI Publisher, Discoverer.
• Strong coding experience in PL/SQL development using Stored Procedures with Functions, Triggers, Packages, Writing and Tuning complex SQL statements.
• Expertise in Design, Development and Customization of RICEW (Reports, Interface, Conversions, Extensions and Workflows) using SQL*Loader, PL/SQL, UTL File etc.
• Ability to learn and implement the setups needed for financial, distribution and supply chain modules.
• Experience in Customization, Upgrade, Implementation and Production Support of Oracle Financials and Oracle Supply Chain modules.
• Excellent analytical, problem solving, communication skills and interpersonal skills and consistently being organized by management and peer for producing high quality work.
• Experience in System Administration activities and Strong knowledge of AOL.
• Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) and Drop Ship end to end Cycles.
• Experience in Order import interface program to import sales order.
• Developed Workflows to send notifications based on the business rules.
• Customized Order Management Header and Line workflows to meet business requirements
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure.
• Extensive Functional & Technical skills in the area of Business User Interaction, System Requirement gathering, Application Development, Customizations and Implementation of software applications in client-server, database and enterprise software environments.

TECHNICAL SKILLS

ERP Versions: Oracle Applications 11i, R12

Modules: General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Oracle Purchasing (PO), Oracle Inventory (INV), Order Management (OM), Shipping (WSH), Bill of Materials (BOM), Work in Process (WIP), MES, Sub Ledger Accounting(SLA), Cash Management(CM), System Administrator.

Languages: PL/SQL, SQL, C, C++, Java, HTML, XML, JCL and COBOL

Self-Service Modules: i-Expenses, i-procurement, i-receivables, i-supplier

Tools: XML Publisher, Toad, PL/SQL Developer, SQL*PLUS, Oracle Workflow, Oracle Developer 2000(Forms 9i/10g/11g, Reports 9i/10g/11g)

Databases: Oracle 9i, 10g,11g, R12, MS SQL Server 2010

Operating System: Windows XP, 7, NT, UNIX, Windows- 98, 2000, 2003, 2007

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville,Florida

Oracle Developer/ Oracle Forms and Reports Developer

Responsibilities:

• Customized Modules AP, AR, GL, FA,MFG modules using Oracle Development Suite/Reports 9i/10g and BI Publisher. Created custom values sets, menus, and responsibilities as a part of r12Upgrade from 11.5.10.
• Modified standard Oracle reports AP Aging report, AR Aging report, AR Commitment balance to excel format using XML Publisher.
• Involved in the Oracle Web Expense -Landed Costing Custom module-Inventory-Account Payable and Purchase-Landed Costing Custom Module-inventory-Oracle Payable.
• Key user Training for the landed Costing custom Module and Integration with Oracle Payables, Oracle Web Expense, and Oracle Cash Management, Inventory, Order Management and Account payable
• Developed a custom check print format to suit the client’s banks requirement using XML Publisher.
• Created and customized reports using XML Publisher in OM, AR, GL, CM, AP and SLA.
• Worked on designing and implementing Oracle Alerts and Lookups.
• Worked on Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields, System Administrator.
• Involved in writing of SQL scripts.
• Involved in the design of the Chart of Accounts structure based on the requirements of both the companies
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Developed Sales Order Report using XML Publisher.
• Worked on oracle alerts and developed alerts to send mail notification to suppliers for remittances in Oracle Payables.
• Experience with implementation and support of Oracle 11i R12 applications including Oracle Applications Framework(OAF), SQL, PL/SQL, Oracle workflow, JDeveloper, Form personalization, Oracle Alerts and Oracle Reports, OBIEE, XML Publisher, and Forms.
• Develop AP/AR/GL/PO reports using discoverer which include the following:
• GL Summary Report.
• PO requisition reports
• AR sales profit report with cost of goods.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Package with Oracle AOL.
• XML templates, concurrent programs, request sets, menus, requestgroups, responsibilities, Profiles and alerts between database instances.
• Developed the bursting process to email, Fax and print a document based on the business rules at the same time.
• Customized AP Approval, Requisition Approval and PO Approval workflow for Procurement.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on Customer Listing - Detail/Summary report and Dunning History report. Registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.
• Created Concurrent Programs, Menus and Functions required for registering the Forms, Reports and PL/SQL.
• Extensively involved in designing the project and coordinating a highly professional team.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.

Environment: Oracle Apps Release 12(12.2.3), (AP,AR,GL), SQL, PL-SQL, Oracle 10g, TOAD, Discoverer, Developer 2000(Reports 9i/10g and Forms 9i/10g),XML Publisher, SQL*Developer, PL/SQL, Putty, Workflow, WinSCP, UNIX.

Confidential, Herndon, VA

Oracle Developer/ Oracle Forms and Reports Developer

Responsibilities:

• Developing of RICEW components in SCM modules Oracle Inventory (INV), Purchasing, Order Management (OM), Bill of Material (BOM).
• Implementation and Customization of MODULES AP, AR & GL, SLA.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Disabled the Post button on the Journals for Sox compliance, using Forms Personalization.
• Developed custom forms using TEMPLATE.fmb to hold additional item information.
• Worked to resolved the issues on Drop Shipment, Internal Sales Order in Order Management application.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Troubleshooting and fixing the issues in Order management application - Return Material, Back Ordering and issues related to Authorization.
• Using custom.pll, disabled the order booking button to restrict sales reps from booking Promo orders exceeding a certain limit.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions
• Developed Discoverer reports like AP Invoice Disbursement, Item master listing, AR all reasons report, Transaction/Customer Balance report.
• Highly proficient in Oracle ERP Order Management, Manufacturing and Finance
• Extensive experience in development of Custom Forms using Template.fmb, customization of existing Oracle forms using Custom.pll/Forms Personalization.
• Developed Schedule Ship report to identify the errors in the Shipment dates for the retail customers. This report lets the internal sales force identify the manual errors committed during the order booking process.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Development/modification of custom reports in purchasing and payables
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Maintained Bills of Materials (BOM) the cost of each resource, outstanding processing, overhead, and job close transaction by providing entity, period and no table description.
• Developed custom forms using TEMPLATE.fmb to hold additional item information.
• Developed reports like Packing Slip, Pick Slip, and Mailing Label for Shipping and Credit Order Detail, Freight Carrier, Orders by Item, Order Detail & Summary Reports for Order Management.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Developed Customer License Form to save the Customer’s License information.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL.
• Developed the PL/SQL Scripts to translate the old Asset Category to new Asset category values that are been setup in the R12 Fixed Assets.
• Developed custom Forms and Reports as per client requirements.
• Creation of Customized Mailing Label and the Pick Slip Report to fulfil the requirements of the client using the OM and WSH using Reports 10g.
• Oracle Workflow:
• Developed workflow business events to report the promise date and schedule ship date changes on the orders.
• Customized the PO workflow to send notifications to specific people using adhoc roles.
• Created Concurrent Programs, Menus and Functions required for registering the Forms, Reports and PL/SQL.

Environment: Oracle Apps R12, Procure-2-Pay(P2P), Oracle 10g, Oracle SQL, Oracle PL/SQL, AP, GL, SLA,PO, AR, OM, INV, iExpenses, TCA, TOAD, Discoverer, PL/SQL,XML Publisher, SQL*Developer, Forms(9i), UNIX, Shell Scripting, WINDOWS XP.

Confidential, San Jose, CA

Oracle Developer/ Oracle Forms and Reports Developer

Responsibilities:

• This project was an upgrade project which involved the upgradation of Oracle Applications 11.5.8 to Oracle Application R12.
• Involved in following modules INV, AP, AR, OM, WIP, BOM, OPM, FA and iprocurement.
• This project was essentially an Upgrade Project and developed the below Custom reports using Reports 10g as per the client requirements in OM module
• Consolidated Pick Slip
• Packing Slip
• Shipping Exception Report
• Item Label Report
• Bill of Ladding Report
• Daily Inventory Report
• Involved in customization of various reports as per the user requirements, which includes customized mailing label report, sales order acknowledgement report, Order Status Summary report, printed purchase order and packing slip report, Vendor Performance report.
• Setup Custom Modifiers to derive discounted price for few business requirements.
• Worked on OAF (Oracle Application Framework) to develop customized solutions for iProcurement Module.
• Prepared technical design documentation and Unit test plan documents for XML Reports, Conversions and few Extensions.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Developed Customer License Form to save the Customer’s License information.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.
• Modified existing reports by creating additional joins and designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Developed the templates for several reports using XML publisher.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Applications.
• Developed Open Purchase Order Report.
• Helped team documents such as MD50, MD070, and MD120.
• Designed & developed the custom interface program to create and update an item in Item Hub with database validations.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions.
• Worked on in Order import interface program to import sales order.
• Worked extensively on Reports and Custom Forms
• Contributed to the design specifications of the Oracle XML Gateway and advised other product teams on the development of XML messages.
• Identified many Gaps/OracleBugs / EnhancementsinOracleASCP
• Developed Margin Analysis Report which will pull all the sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice.
• Responsible for migrating custom concurrent programs, reports, forms, responsibilities from one instance to another instance using FNDLOAD utility.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Development/modification of custom reports in purchasing and payables
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Implemented Order Management Workflow extension for RMA Finance approvals for various financial validations which Carnival requires during Order to Cash process.
• Seeded OM Workflows are copied and customized.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL*Plus.
• Seeded OM workflows were copied and customized accordingly.
• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support
• RMA Approval workflow notification for Sales Order will be triggered at the launch of Sales Order “Book” event.

Environment: Oracle Apps Release 12(12.1.3), (AP,AR,GL,SLA), SQL, PL-SQL, Oracle 10g, Forms & Reports, Putty, Workflow, WinSCP, UNIX.

Confidential, WI

Oracle Developer/ Oracle Forms and Reports Developer

Responsibilities:

• Analyzed and mapped business processes before migrating to R12.
• Impact analysis of RICEW components and prepared test scripts to test them..
• Upgrade 11i Technical Components to R12.
• Developed custom Requisitions and Purchasing Documents Interface to import requisitions information from legacy system. Used SQL* Loader, PL/SQL packages to validate the data before inserting into base tables.
• Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Creating reports using Reports 11g.
• Troubleshooting, 24x7 Production support.
• Defined Editors, Created List of Values and Record Groups in Oracle Forms 10g.
• Design, development and testing of Reports using Report 10g.
• Customized the Print Purchase Order Report based upon user requirements.
• Worked on auditing activities such taxation, Accounts payable.
• Handling audit of clients and preparing reports of the same.
• Reviewing invoices and checking the requests of the same so as to avoid any errors.
• Matching invoices and setting up same for the payments.
• Preparing accounts payable cheese and processing the same through net transfers.
• Reconciliation of the payments and monitor accounts to ensure payments are made up to date and resolve any discrepancies.
• Designed and developed outbound interface, for extracting data from GL and AR as per the client requirement, using oracle standard UTL FILE utility.
• Review/Create/Modify the Reports RDF and Form in Oracle 10g.
• Migrated Business Area/Item Classes from one Instance to the other in Discover 10g.
• Customizes the pick and ship Delivery Option Using Form Personalization.
• Helped team documents such as MD050, MD070, MD120.
• Developed Reports Like Weekly reports, Daily Stock status reports, Weekly, Monthly.
• Developed Conversion script in Inventory module by using SQL*Loader, PL/SQL stored procedure, UNIX and Oracle standard API.
• Developed XML Publisher Reports Based on PL/SQL Stored Procedures to provide different output formats.
• Developed interface program and conversion program to load the legacy data into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables.
• Crated customer aging report using customer invoice date.
• Developed PL/SQL Programs to validate data and insert into the interface tables. Then used standard import programs to load the data from interface tables to base tables
• Helped customers to get reports in excel formats like customer aging report using XML publisher.

Environment: Oracle 9i(AP,AR,GL),PL/SQL, Oracle APPS-11i (PA, OGA), XML Publisher Report, TOAD.

Confidential 

Oracle Developer

Responsibilities:

• Performed daily monitoring of databases for availability and performance metrics.
• Reviewed log files from overnight and batch processes for significant events.
• Review SQL and PL/SQL for Production and sub-environments to ensure accuracy and optimization.
• Created Database tables, views and indexes.
• Creation of functions using PL/SQL.
• Creation of DML, DDL, DRL, TCL, DCL using SQL.
• Creation of Joins, Equijoin, Sub quires in SQL.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL * LOADER
• Developed Reports as per client requirement.
• Involved in creation of SQL scripts.
• Involved in creating customer invoice reports.
• Creation of Packages, Stored Procedures & triggers using PL/SQL.
• Load the data using SQL*Loader.
• Prepare the unit test cases and responsible for execution.
• Review enhancements made by peers in the team.
• Preparing High level and Low level design documents.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.

Environment: Oracle 9i, Developer 2000, SQL, XML, PL/SQL, Windows NT 4.0, MS Access 2000.