SUMMARY:

• Over 8 years of experience as managing substantial components of large - scale ERP implementations and support of business applications using Oracle Applications.
• Experience in Oracle E-Business Suite Applications with expertise in Oracle Financials modules (GL, AP, AR and PA), Manufacturing Modules (OM, INV, Shipping WSH, BOM, WIP, PO, MRP, Project Billing, Project Costing), Human Resources (HRMS), Service Contracts and Advanced Pricing (AP) and Distribution modules
• Have hands on development experience in SQL, PL/SQL (Procedures,Packages, Functions, and Triggers), Oracle Reports 6i/10g and Forms 6i/10g, XML Publisher.
• Having skills in Oracle 9i,10g,11g environments using SQL,PL/SQL,Developer 6i/2000Oracle (Forms 9i/10g and Reports 9i/10g).
• 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.
• Experience in all aspects of Software Development Life Cycle including Software Design, Development, Implementation and Testing.

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,Cash Management, System Administrator.

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

SelfService Modules: i-Expenses, i-procurement, i-receivables, i-supplier

Tools: XMLPublisher, Toad, PL/SQL Developer, SQL*PLUS, Oracle Workflow, Oracle Developer 2000(Forms 6i/10g, Reports 6i/10g)

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Oracle apps Techno Functional Consultant

Responsibilities:

• Customized Modules AP,AR, GL, FA, MFG modules (ONT, BOM, CST, INV) using Oracle Development Suite/Reports 6i, 9i and BI Publisher. Created custom values sets, menus, and responsibilities as a part of r12Upgrade from 11.5.10.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Implementation Guide for importing Customer Calls Information from legacy Customer Notes Information into Oracle AR
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Worked on designing and implementing Oracle Alerts and Lookups.
• Created Concurrent Programs, Menus and Functions required for registering the Forms, Reports and PL/SQL.
• Worked on Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields, System Administrator.
• Involved in writing of SQL scripts.
• Customized Auto lockboxinterface such that the receipt file from automatically imported into Accounts Receivable(AR).
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• 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 employees for settlement of advances in Oracle Payables.
• Develop AP/AR/GL/PO reports using discoverer
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Package with Oracle AOL.
• XML templates, concurrent programs, request sets, menus, request groups, 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.

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

Confidential, San Jose, CA

Oracle apps Techno-Functional Consultant

Responsibilities:

• Experience in developing of RICEW components in SCM modules Oracle Inventory(INV), Purchasing, Order Management(OM), Bill of Material(BOM).
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger(GL), Purchasing and Payables and iprocurement.
• Extensively worked on modifiers,qualifiers to create a price list for various items in Order Management (OM) module.
• 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, BackOrdering and issues related to Authorization.
• Development of BOM Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base.
• Highly proficient in Oracle ERP Order Management, Manufacturing and Finance
• 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.
• 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.
• Customized standard Oracle Applications reports and developed custom reports in OM, BOM, WSH and INV modules, some of them include: Bill of Lading Report, BOM Comparison Report, Shipment Log Report, Item Summary Report and On-Time Delivery Report.
• 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, PO, AR, OM, INV, iExpenses, TCA, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(9i), UNIX, Shell Scripting, WINDOWS XP.

Confidential, WI

Oracle Apps Technical Consultant

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.
• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files which are in the production.
• Migrated objects into Oracle Apps EBS R12.
• 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 the staging R12 Apps environment to convert AP suppliers and AP Open Invoices from 11i to AP of R12.
• Prepared technical design documentation and Unit test plan documents for XML Reports, Conversions and few Extensions.
• 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, MD120 .
• Designed & developed the custom interface program to create and update an item in Item Hub with database validations.
• 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/ Oracle Bugs / Enhancements in Oracle ASCP
• 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.
• Developed Price Book Extract Report for various price lists.

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

Confidential, Upper Saddle River, NJ

PL/SQL Developer/ Oracle Form & 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.
• 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.
• 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.
• Helped customers to get reports in excel formats like customer aging report using XML publisher.

Environment: Oracle 9i, 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.

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