SUMMARY

• Over 7 years of experience in implementing, upgrading and customization of Oracle e - Business Suite Applications including integration, design and development of Oracle SOA.
• Proficient in various Financial & Supply Chain modules within Oracle Applications. Few of them are Accounts Payable, Accounts Receivable, General Ledger, Sub-Ledger Accounting, Order Management, Inventory, Purchasing and Bill of Materials.
• Well versed in Implementation (R12 / 11i) and Upgrade (11.X to R12) of Oracle Applications.
• Strong knowledge of business flows like Procure-to-Pay (PTP) and Order-to-Cash (OTC) life cycles along with the dependencies and integration between various Oracle Applications modules.
• Experience in developing web-services using Oracle SOA (BPEL, XML, WSDL) to integrate Oracle EBS to other non- database systems.
• Worked on RICE Components, Workflow, Personalization (OAFand Forms) and OAF Enhancements.
• Experience in development and customization of OAF pages and embedding them in Oracle Workflow.
• Good understanding of personalizing OAF pages for simple modifications.
• Expertise in jdeveloper and development of customOAFpages.
• Extensively used XML functions like XMLELEMENT( ), XMLFOREST( ), XMLAGG( ) and others to generate XML reports from PLSQL programs
• Expertise in customizing and building new workflow based solutions using Oracle Workflow Builder across various Oracle modules like OM, PO and AP.
• Hands on experience in development and customization of RICEFW (Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components.
• Good understanding of TCA architecture and Sub ledger Accounting (SLA) in R12.
• Worked extensively on development/customization of Forms, Reports converting 6i Reports to XML Publisher reports.
• Extensive experience in AOL(Application Object Library) and SYSADMIN concepts
• Strong experience in Performance tuning of SQL and PLSQL programs using built-in Oracle utilities like Explain Plan, SQL Trace & TK-Prof, and using Optimizer hints and other tuning techniques.
• Experienced in using PLSQL Bulk Binding techniques, Oracle Built-In Packages and Utilities like SQL Loader.
• Very strong in developing PL-SQL programs (Procedure, Functions, and Packages) & Triggers, and Unix Shell scripting.

TECHNICAL SKILLS

ERP Skills: Oracle Applications R12 / 11i Accounts Receivables (AR), Accounts Payables (AP), iProcurement, Purchasing (PO), Order Management (ONT), Inventory (INV), Bill of Material (BOM), Work in Process (WIP), Shipping (WSH), Advanced Pricing (QP), General Ledger (GL), SubLedger Accounting (SLA),, Service Contracts, Fixed Assets(FA), Purchasing (PO) .

Middleware Technologies: Oracle SOA Suite, Oracle ESB, Oracle BPEL, Oracle Web Services Manager, SOAP, WSDL, XML, XSD, UDDI.

Programming Languages: C, C++, Java, SQL, PL/SQL.

Data Loading Tools: ESB, Data Loader

Developer Tools: Oracle Jdeveloper 10g, Oracle Forms, Oracle Reports, Toad, Discoverer, XML Publisher, Oracle Workflow builder.

RDBMS / DBMS: SQL, PL/SQL, Oracle 8i / 9i /10g.

Operating Systems: UNIX, Linux, Windows Vista/XP/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Project involved the modules GL, AP, AR, PO, INV and OM Modules.
• Actively participated in the initial analysis and requirements gathering phase along with the project lead and the functional team.
• Worked onrequirement gathering, designanddevelopmentof custom applicationDeviation Code MaintenanceinOA Framework.
• Development of customized forms using Oracle Application Framework (OAF).
• Developed UI screens using JSP and OA Framework.
• Developed technical designs for conversion of Oracle EBS extensions utilizing OAF systems.
• Supervised the conversion of massive data from the existing system to Oracle R12.1.3 for Service Contracts, Install Base and TCA.
• My core strength is Oracle Application E-business Suite, in which my primary areas of expertise are Oracle Lease Management, Oracle Service contracts, Trading .
• Community Architecture (TCA), Oracle Install base, Field Service, Accounts receivable and Oracle Purchasing.
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Worked on Data-conversions to import create/update new items in Inventory (INV) and assigning them categories and adding catalog information.
• Define Order/Order Line Holds and Release Reasons in Order Management and developed Package Procedures to apply these custom holds on every Ring Order at the Sales Order Line Level based on various business criteria using Holds API.
• Customized Order Line (OEOL) workflow to call the holds program thus preventing the order line from being booked.
• Analyzed the Current Quote to Order Process to re-architecture the same in the norms of Service Oriented Architecture (SOA).
• Developed a custom program for AR interface to validate the invoice data and import it using auto invoice import program, Also modified the program to skip the auto-accounting rules and use a custom process to generate the accounting required.
• Worked on customer refund process in Receivables to create Payable Invoices in AP.
• Completely automated the Payables flow all the way from importing the payables invoices till the generation of Check/Wire Payments for the suppliers using Oracle Standard API.
• Developed program to Create/Update/Terminate the suppliers in Oracle Payables using the Supplier Interface Programs.
• Worked on to customize the standard e-text template for electronic payments and standard check print template for check payments using BI publisher in AP.
• Customized the interest payment hook in Oracle Payables to generate the Interest Invoices on delayed payments.
• Worked on the design and development of the Jewelry Data Warehouse Interface which stores the complete information of a Ring Order for a given Invoice created in the System.
• Designed and Implemented a Data Migration mechanism and responsible for writing the UNIX shell scripts for smooth and better migration of Objects, Code and Data into higher instances.
• Involved in the design for Test Scenarios and Scripts for Unit Testing, Integrated Testing and UAT.
• Enhanced an existing ADF developed to mimic the WMS Process to calculate the availability of the item based on the sold quantity, available quantity and any requisition in transit
• Developed extensions and personalization’s for customer Standard (OAF) to display some custom information at attribute level and some validations when creating a customer and updating the site and account level information.

Environment: Oracle E-Business Suite R12, OM, GL, SLA, AP, AR, TCA, PO, AOL, Oracle 11g/10g, Windows XP, SQL*Loader, PL/SQL, Toad, XML Publisher, OAF, JDeveloper, Forms 10g, Reports 10g.

Confidential, IL

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked on Oracle R12 (12.1.2) AP/AR/PO/GL/OM Implementation.
• Developed customized pages usingOA Framework. Modifying existingField Service Technical Portalby customizing lov, button events, hiding regions, extending Application modules (AM) adding new view objects (VO) and customizing the controllers (CO) as per the functional specification.
• Delivery details screen - Created a customized folders/views in OAF for requested to users based on pickup status.
• Built custom screens in OAF to correct interface errors in staging tables and reprocess them.
• Created custom OAF pages to print labels for serial controlled items.
• Created security function model in OAF -It will make sure pricing info will be displayed only to authorized users.
• Successfully carried out Data Conversions, Data Migration and Validation using SQL*Loader and PL/SQL Package/Procedure from Legacy system.
• Development and testing of Quotes created from Service Contracts which is known as Super Quotes using oracle standard APIs.
• Designed and developed the OM-SC integration technical process flow charts.
• Actively participated in the setup of Payables like Invoices Sources, Pay groups, Supplier / Supplier Sites etc.
• Added customizations like Service Contracts Credit Check process, Header/Lines ship to and bill to address sync check.
• Developed programs for data conversion of Open Payable invoices from legacy systems.
• Developed programs to interface Payable invoices on a regular basis from external Systems.
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing.
• Customized the PO Account generator Workflow as per business requirements.
• Worked with Receivables Auto Invoice Interface program to load Receivable transactions from legacy system.
• Worked on Account Receivables (AR) Auto Invoice Interface and supported issues in transferring data to General Ledger (GL).
• Developed programs to convert code combinations in GL using GL Interface.
• In GL module, performed Journal import process. During the process used the GL INTERFACE table and imported data via Journal Import into GL JE HEADERS, GL JE LINES, and GL JE BATCHES.
• Worked on Order Import interface which imported New, updated, or changed sales orders from other applications such as Legacy systems using process Order API.
• Developed PL/SQL programs to convert Inventory Items and assign them child inventory Organizations using Item Interface and Inventory API.
• Developed Program to Create/Update the pricelists using Price lists API.
• Developed various Forms with Triggers, Alerts, Multiple Canvases, Multiple Window, LOVs and List Items using Forms 10g.

Environment: Oracle R12, GL, SLA, AP, AR, OM, AOL, Oracle Workflow Builder, XML Publisher, Forms / Reports 10g.

Confidential, Daytona Beach, FL

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked on Oracle financial module (AP, AR and PO) and Manufacturing module (INV, OM) implementation.
• Developed custom (Major Expenditure Planning) application using OA framework and workflow for the Approvals.
• Designed and develop customized forms in J2EE and integrate with Oracle applications using API and Interfaces and OAF.
• CreatedOAF/ADF html pages to create, query and approve WebADI manual journals.
• Customized the invoice aging report in AP to get the invoice aging data in excel format.
• Worked on understanding and gathering of functional designs for customizations / extensions / inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Worked on sub ledger accounting process.
• Design and testing of integration of Legacy Payable system with Oracle Payable with help of netting process.
• Worked with technical team to migrate suppliers, employees, bank information and open invoices data for AP.
• Worked on TCA API’s and developed a custom program to validate and import the customer addresses from third party system (AS400).
• Developed a conversion program for the import of the items & material transactions into Inventory using Interface Managers.
• Developed an interface program in inventory to create the items from the payables invoice with minimum specifications.
• Involved in the implementation and customization of Oracle Manufacturing.
• Customized the order line workflow to add additional functionality.
• Prepared functional design document and Test case document for custom enhancements.
• Prepared documents for Business Requirements, Setup configuration, Test Scenarios and Training Manuals as per AIM methodology.
• Participated in testing, user accepting testing in production and test instance.

Environment: Oracle R12, Reports 10g, Oracle 10g, SQL, PLSQL, UNIX

Confidential, Dallas, TX

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Upgrading the Oracle Manufacturing from Oracle 11.0.3 to Oracle 11.5.10 with migration/Conversion of Objects from 11.0.3 to 11.5.10 and complete reformation and migration from 11.0.3 to 11.5.10.
• Customization & Extension ofOAFPage-CsfDashboardPG & CsfPoUpdateTaskPG.
• CreatedOAFPersonalization/Extensions in Standard PA Screens(PA Module)
• Technology evaluation and prototyping application inOAF.
• Calling PL/SQL procedure in OA Framework environment and Capturing LOV event.
• Providing production support to existing modules like AR, AP, PO, GL and Inventory (Issues like modifying reports, forms, writing and running some quick queries for users etc.)
• Developed the conversion programs by creating packages, reconciliation programs, staging programs, scripts for modules like Inventory, Order Management, Purchasing & Costing from one entity to another entity.
• Developed PL/SQL packages to load data into interface tables for Item Assignment, Item Cost Update, On-hand Conversion, AR Invoice Conversions.
• Performed the complete transfer for Supply Chain, including inventory items, on hand and open sales orders.
• Performed customizations like, Item Import / Pricing Import / Order Import etc. using standard API’s / Oracle Standard Programs
• Performed forms personalization to ease the business for viewing the information in different Inventory Organization under same Operating Unit.
• Developed several reports in GL, AP, PO, and AR as per users Requests.
• Involved in performance tuning of existing scripts (PL/SQL Tuning).
• Used Multiple Order Transaction types to generate different accounting Information depending on the Customer and Item Type. This helped business to input multiple lines within a single sales Order rather than creating different sales Order for different type of Item type and Customer Combinations.
• Performance Tuning was done to make sure the Programs does not run for more than 10 minutes in the Development Environment.
• Unit Test case documents were created and the Solution was tested against these at various stages of User acceptance testing.
• Developed Unix Shell scripts for emailing the Output file and Log files of the Concurrent Programs scheduled for Intercompany Auto process.

Environment: Oracle E-Business Suite 11i, Oracle 10g, SQL, PL/SQL, Reports 10g, Discoverer 10g Admin/Plus, Windows Vista, UNIX, TOAD.

Confidential, TX

Oracle Apps Technical Consultant

Responsibilities:

• Involved in implementing Oracle ERP inventory and Order Management modules to maintain the services information and process customer orders.
• Develop various CustomizedOAFForms and Integrate with Oracle using API's and Interface Tables and initiate Workflow using WF ENGINE
• Gathered requirements, performedOAFpersonalizations, created customOAF items.
• DevelopedOAFpages from scratch to meet the business requirements.
• Worked with the business users to develop a workflow based solution for Order Booking and Fulfillment process.
• Developed packages to update items Attributes using INV API for MRP / planning.
• Developed Interfaces for GL Code combinations, GL Balances, Inventory Items, Purchase orders and Pricelists to validate the legacy data and populate the Interface tables.
• Developed SQL* Loader scripts to dump the data into temporary tables.
• Developed reports for Inventory and customized reports in Purchasing.
• Developed packing slip report, custom shipping report to display the serial number information of shipped order lines with scan able barcodes.
• Developed forms for mass update of customer profiles and profile amounts.
• Developed forms to display additional line information for order lines.
• Setup new holds and release rules on order lines and integrated them with order line workflow.
• Developed UNIX shell scripts to call SQL loader scripts, PL/SQL package procedures, and SQL scripts, submit concurrent programs and to extract data from legacy systems.
• Involved in several form and OA Framework personalization’s to provide user and responsibility based security.
• Developed UNIX scripts to extract data and dump it into files and send e-mail report.
• Managed team members, prepared MD50 and MD70 documents.

Environment: Oracle E-Business Suite 11i, Oracle 10g, SQL, PL/SQL, Reports 10g, Discoverer 10g Admin/Plus, Windows XP, TOAD.

Confidential, PA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Implementation of Oracle Applications. Modules implemented GL, AP, AR and OM.
• Responsible for deploying ofOAFpersonalization using the Functional Administrator Responsibility and Import/Export Tools
• OAFTechnical Customizations on Rel 12 Oracle Applications Framework Architecture with JDeveloper, SOA, BI Publisher and Workflow areas.
• Personalized views panel of search pages, table regions and search result views page usingOAFpersonalization module.
• Provide day to day technical and functional support in the areas of GL, AP and AR.
• Integration of MSP fee structure with GL, AR and AP.
• Designed and customized the AR Auto-Invoice process to incorporate new custom logic for bundling and Grouping of AR Invoice lines.
• Designed documents for customized Quote to billing process and consolidated billing statements.
• Developed Custom Suppliers Audit report to keep track of any changes made to the suppliers, sites, contacts and bank information attached to the supplier.
• Designed functional documents to reacted journals into Oracle General Ledger as per business requirements.
• Reconciled the journals period wise. Created the balances by closing the period after every month.
• Trained users on Application Desktop Integrator to use Journal Upload, Budget Upload, FSG Reports and Publishing reports using ADI.
• Setup of Oracle Payable including payables invoice approval using AME application administrator.
• Setup for Oracle Receivables like defining Transaction types and source, defining payment terms, and defining Auto Accounting and system options.
• Worked extensively in production support Issues in Oracle Payables and Oracle Receivables.
• Configuration of Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets, Lookups, Transaction Types, Messages.
• Preparing documents for Requirement gatherings, Application setups, Future Process Flows and Test Scripts for all the modules.

Environment: Oracle 11.5.8 OM, GL, Pricing, AR, AP, INV Forms 6i, Reports 6i, Toad, XML Publisher, Oracle Workflow.

Confidential

Oracle Apps Developer

Responsibilities:

• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Worked on Item import Open Interface in Inventory Module (INV). Oracle Inventory provides Item Open Interface to easily populate the items in flat files into Oracle Applications.
• Oracle Inventory provides Customer Item Open Interface (INV) to easily import Customer Items from external systems to Oracle Applications.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Involved in developing a custom package for importing Orders from web-based system COPS through Order Import Open Interfaces PL/SQL API in Order Management
• Customization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using Custom.pll, as per the client requirements.
• Developed a customized workflow in Order Entry to keep track of the sales order and sending the notifications correspondingly when the order is fulfilled.
• OM Line Level Workflow Changes for ATO Model Items.
• Gathered requirements from the power users concerning the customization of the reports and forms.
• Developed and customized standard Oracle Apps Reports in Inventory, Shipping, Order Management and AP Modules.
• 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 custom reports such as Payments Overdue Report, Orders for Suspense Account, and Sales Quote in Oracle Order Management.
• Customized Sales Order form and was also involved in developing new form to display Delivery Information in Oracle Order Management
• Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs.
• Responsible for creating the custom value sets and values required for the additional parameters while defining the programs.
• Wrote PL/SQL package to include Process orders API code. Customized the Workflow API packages to call the API packages.
• Performance Tuning of Custom PL/SQL Packages.
• Developed detailed data mapping document from Oracle Purchasing Release 10.7 source Oracle system to Oracle Purchasing Release 11.5.7 for PO Headers, PO Lines, PO Line Locations and PO distributions for Standard purchase orders.

Environment: Oracle E-Business Suite 11.5.7(PO, INV, OM, AOL, Sys Admin), Oracle 9i, Reports 6i, Forms 6i, SQL* Loader, PL/SQL, Discoverer 9i/10g, TOAD, Windows XP, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Involved in collecting functional specifications and converting them into technical specifications.
• Developed the PL/SQL programs which would be a part of central engine to perform the tasks created.
• Development of PL/SQL stored procedures, triggers, functions and packages.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, and DBMS OUTPUT.
• Involved in modifying various objects like Tables, Indexes and Views.
• Use of SQL*LOADER for loading data from flat files into oracle database.
• Involved in Unit testing and Documentation design.
• Consolidated documentation on the project.
• Created unit test and integrity test plans and test cases, executed test cases and documented the test results.
• Tested the integration of various components to make sure the system as a whole is working intact.

Environment: Oracle 8i, SQL*PLUS, PL/SQL, SQL*LOADER, TOAD, Windows NT, UNIX