SUMMARY

• Over 8 Years of experience in Design, Development and Implementation of Software Projects and 7 year’s experience in Oracle Applications.
• Extensive experience in customization, implementation, maintenance and support of Enterprise Business Applications using Oracle R 12/11.5.9/11.5.8/11.5.3/11.0.6 e - Business Suite.
• Proficient in all phases of Oracle Applications Demand Management implementation with major focus in General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchasing, iProcurement, Order Management (OM), Application Object Library (AOL), Cash Management (CE), Bill of Material (BOM), Work in Process (WIP), Fixed Assets, INVENTORY (INV.
• Experience enhancing and supporting Oracle Financials modules including Order management, Inventory management, General Ledger, Accounts Payable, Purchasing, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, and Project Management.
• Strong knowledge of Order to Cash (O2C) and Procure to Pay (P2P) life cycles in Oracle E-Business suite with very good understanding of Software Development Life Cycle(SDLC) including analysis, design, coding and testing.
• Good Knowledge of Oracle functionality.
• Experience with applying patches, deploying.
• Experienced in developing and customizing procedures, packages, functions & triggers using PL/SQL.
• Validate the BOM data to the appropriate engineering drawings such as an isometric piping drawing, P&ID drawings and Oracle ERP.
• Experienced in EBS background having supplier conversion, interface and extension development
• Well versed with client server environment and tools like Oracle Reports, Oracle Forms, Oracle Discoverer etc.
• Well versed with Oracle utilities and in-built packages like SQL*Loader, SQL*Plus, TOAD,UTL file Package etc.
• Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies including Implementation, Interfacing, Conversion, Data Migration and Data Conversion.
• Familiar with AIM Methodology.
• Strong in using Oracle Workflow Builder to develop various activities such as Notifications, Functions, and Processes.
• Strong working knowledge of Excel and MS Access Working knowledge of relation database and generating SQL scripts
• Worked extensively on development/customization of Reports converting 6i Reports to XML Publisher reports.
• Provide production Support and Administer Oracle ERP modules Order Management, Shipping, Purchasing, Inventory (Inventory Execution, Item Master, BOM), Work-in-Process, Advanced Supply Chain Planning.
• Strong experience in Performance tuning of applications using built-in Oracle utilities like Explain Plan, SQL Trace & TK-Prof, and using Optimizer hints
• 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.
• Worked extensively in Data Warehousing environments to handle bulk loading of data.
• Experienced in using Bulk Binding techniques, Oracle Built-In Packages and Unix Shell scripting.

TECHNICAL SKILLS

ERP Skills: Oracle Applications R12 / 11i Inventory (INV), Order Management (OM), Bill of Material (BOM), Work in Process (WIP), Shipping (WSH), Advanced Pricing (QP), Quoting (QOT), General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Fixed Assets (FA), Purchasing (PO), e-Commerce gateway (ECE / EDI)

Programming Languages: C, C++, C#,Java, SQL, PL-SQL, Hibernate, HQL, JavaScript, Unix Shell Scripting

Web Technologies: HTML, DHTML, XML, JSP

Data Loading Tools: ESB, Data Loader

Version Control: Kintana

GUI/Tools: Oracle Workflow Builder, Oracle Forms, Oracle Reports, Toad, Discover, XML Publisher, PL/SQL Developer, SQL Plus, SQL Loader

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

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Application Technical Consultant

Responsibilities:

• Worked on the entire lifecycle of the project including Analysis, Design, and Development, Unit Testing, QA Testing support, transition and post-production go-live support.
• Worked on various conversions to import data (Sales Orders, Invoices, Customers, Inventory, and Supplier) from the legacy system into Oracle Applications.
• Developed SQL * Loader Scripts to populate the legacy data from flat files to temporary tables.
• Worked on the complete Order to Cash (O2C) Cycle and Procure to pay (P2P) cycle modules.
• Created custom Interfaces per the client requirements to convert Standard Orders, RMA’s and Dropship orders.
• Developed Custom Auto Pay cycle Process which replaces Oracle Payables Pay cycle functionality. This customization was put to automate the pay cycle process to reduce the time required to create payment batches.
• Involved in setup and customization of ORACLE Payables and data conversion from legacy system into ORACLE Payables.
• 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.
• Importing Vendor and Invoice information into ORACLE Payables using stored procedures and SQL*Loader.
• Worked on the Item import conversion to import Inventory items from the legacy system into Oracle Applications. Worked on Customer Conversion to import Customer data from the legacy system into Oracle Applications.
• Worked on Supplier conversion interface, to process the Supplier information from a legacy source to Oracle Applications.
• Worked on creating new Dynamic Formulas and Modifiers in Advanced Pricing to meet the client requirements.
• Performed GL, AP AR set ups in Czech Republic, Slovak Republic & French Polynesia .
• Worked on the enhancement and customizations and production support issues related O2C, AR, AP, GL 11i and R12.
• Customized the RMA workflow to add additional functionality to validate the RMA items before receiving into warehouse.
• Customized the order line workflow to apply custom holds before the order is booked using Holds Pub API.
• 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.
• Supporting Oracle Financials modules including Order management, Inventory management, General Ledger, Accounts Payable, Purchasing, Cash Management, Accounts Receivables, Fixed Assets, Project Costing, and Project Management.
• Provide production Support and Administer Oracle ERP modules Order Management, Shipping, Purchasing, Inventory (Inventory Execution, Item Master, BOM), Work-in-Process, Advanced Supply Chain Planning.
• Create BOMs and Items manually and Extract and manipulate the BOM data from database.
• Designed and developed the following custom reports in OM and INV, Fixed Assets modules as per the client requirement- applying patches, deploying and maintaining the systems.
• Monthly Sales Report, Pre-Pick List Report, Orders on Hold Report and .ales Order Report
• Personalized the Shipping transactions form to disable serial number changes.
• Created generic shell scripts to FTP and purge data extracts, EBS background having supplier conversion, interface and extension development
• Performed the complete transfer for Supply Chain, including inventory items, on hand and open sales orders.
• Troubleshoot workflow issues related to error activities in notifications and SQL errors.
• Worked on Performance tuning of applications using built-in Oracle utilities like Explain Plan, SQL Trace & TK-Prof, and using Optimizer hints
• Created materialized views for discoverer reports in Information Warehouse Application.
• 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 10g, Oracle Applications R12 (OM, AR, AP, PO, GL, SLA, Shipping, Fixed Assets, Inventory, Advanced Pricing), Discoverer 10g, Oracle Workflow Builder 2.6, PL/SQL, SQL, Oracle Reports 10g, Oracle Forms 10g, SQL*PLUS, UNIX, Windows XP, TOAD

Confidential, PA

Oracle Applications Technical Consultant

Responsibilities:

• Worked on customizations of custom reports, discoverer reports, packages, functions, triggers, workflows in the areas of OM, INV, PO, AR.
• Worked on the complete Order to Cash cycle modules including Order Management, Inventory, Shipping and Receivables.
• Developed custom API’s to change the move order lines after pick release.
• Developed packages to create locations, customers, customer sites using TCA API.
• Developed PL/SQL procedures for conversion of items using the Open items import program.
• Worked on developing various profile options to incorporate security in Oracle Reports, Discoverer Reports etc.
• Wrote functions to cater to various business requirements like getting Line of Business Information, Set of Books, Legal Entity, Code combination Segments information by passing the code combination id.
• The developed functions were used in all the programs being modified.
• Created Business areas, Custom and Complex folders and developed several discoverer workbooks based on the business requirements.
• Developed customized Reports like aging analysis, Outstanding Invoices, and Customer wise report for amount that is considered bad debt.
• Setting up of new attributes, order transaction types, responsibilities, creating lookup sets, validation sets, etc. to be used in customizations.
• Gave support to the users during the System Integration test I, System Integration test II, User Acceptance Test cycles.
• Perform system maintenance, production incident problem management, identification of root cause, remediation of the problems and on-call pager support schedule.
• Select appropriate technical frameworks and solution delivery methodology.
• Defining New Descriptive flex fields, Created Value sets and value set values, Manage Concurrent Processing and Concurrent Manager.
• Involved in user training on changes in reports, programs, discoverer etc.
• Generated the extract report for the Price List changes using Reports 6i.
• Designed a program to submit all the month end jobs as per schedule.
• Involved in preparing technical and functional documentation (MD50/MD70) for Packages, Procedures, Reports, and Workflows, etc.

Environment: Oracle Applications 11.5.9 (PO, INV, OM, AR, GL), ORACLE 9i, PL/SQL, Reports 6i, Discoverer 4i, TOAD, Windows XP.

Confidential, CA

Oracle Applications Technical Consultant

Responsibilities:

• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support.
• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Developed interface programs for the conversion of grants accounting data into Oracle database.
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Developed interface program to import Purchase Order receipts from the legacy system to Oracle Applications.
• Developed interface programs for conversion of PO data using Requisitions Open Interface and purchasing documents Open interface.
• Designed and developed an Interface program to load open invoices from legacy system into Oracle Payables.
• Designed and developed an Interface program to load receivables data from legacy system into Oracle Receivables.
• Worked with Auto Invoice interface to upload the invoices into the AR tables.
• Worked on creating custom programs to import Journals from a legacy system into Oracle General Ledger.
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Customized PO Requisition Workflow and FA account generation workflow.
• Customized Requisition Account Generator and Approval workflow for iProcurement.
• Customized the Accounts Payable Vendor Entry Form as per requirements.
• Worked on design, customization and personalization of forms using Forms 6i.
• Gathered user requirements on AR revenue-reports from executive team and designed the revenue reports using Discoverer 10g.
• Developed Business Areas and respective folders for various departments and created Budget Balance Reports using Discoverer 10g.
• Developed Cross functional reports using Discoverer 10g.
• Developed 7 Budgeting and Grants Activity History reports using Discoverer 10g.
• Exported the Discoverer10g elements from one instance to another.
• Developed both paper and web based reports using Oracle Reports 6i.
• Developed new reports in BI Publisher and converted various Oracle Reports to BI Publisher.
• Developed Financial Statement Reports, Employee Salaries Reports, Invoices Report, Payroll Reports and various other reports using BI Publisher.
• Scheduled execution and delivery of reports to a wide range of destinations using BI publisher.
• Developed new reports in BI Publisher and converted various Oracle Reports to BI Publisher.
• Developed Financial Statement Reports, Employee Salaries Reports, Invoices Report, Payroll Reports and various other reports using BI Publisher.
• Scheduled execution and delivery of reports to a wide range of destinations using BI publisher.
• Involved in Unit testing of the components in development instance according to the test cases provided.
• Worked with various performance tuning techniques.
• Involved in the development of BR120, MD50’s and MD70’s using AIM.

Environment: Oracle Applications EBS R12 (PA, GMS, OM, Shipping, PO, FA, GL, GA, AP, AR), BI Publisher, Crystal, Builder 2.6, Developer 2000/6i, Discoverer 10g,BI Publisher 5.6.2, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Confidential, Billerica, MA

Oracle Apps Technical Consultant

Responsibilities:

• The project involved working on custom module which was Order Management equivalent with lot of customization using standard API’s in Oracle R12 which also involved other modules like Quoting, Pricing, Procurement, Territory Management.
• Involved extensively in workshops and discussions with End users in order to understand the Business requirements and made necessary changes in the functional specifications.
• Developed a Custom Interface using Standard Process Order API to Cancel Order, Book Order, Apply Holds, Release Holds, Create order at header and line level.
• Developed a Custom API for Order Import considering all the business rules and validation at both header and line level, applying patches, deploying and maintaining the systems.
• Developed a Custom API to convert Quote to BSA or Order as per the requirement.
• Developed a Custom API which would be used while converting Quote to BSA and Quote to Order to create a Price List which would be BSA specific.
• Developed a workflow to send notification for the price change in the quote line and also involved in the Approvers Management Engine (AME) setup.
• Developed a Custom API which would generate the URL for different Standard Oracle forms by passing in the Form Function name and its corresponding parameters as input.
• Developed a Custom API that was to get Additional Order information and Additional line information in the custom sales order form.
• Developed a Custom Territory Management API which was used to get territory and resource information and which was also used to get the primary resource for FAE in Design Win.
• Was involved in the development of the Business Cost Private API according to the business rules to calculate the Business cost, Gross Margin etc.

Environment: Oracle Applications R12 (Order Management, Inventory, Quoting, Shipping, Territory Management, Purchase Order, Pricing ), Oracle Workflow Builder 2.6, Oracle Database 10g, SQL, PL-SQL, Forms 10g, TOAD

Confidential, Philadelphia, PA

Oracle Apps Technical Consultant

Responsibilities:

• The project was the 2nd phase of the Oracle Applications upgrade which involved working on various custom Interfaces and developing custom reports as per the client requirements
• Involved in the analysis, development, unit-testing, QA support, Transition and Post-Production support.
• Worked on customization of Requisitions open interface program to upload daily requisitions.
• Worked on troubleshooting issues related to approval hierarchy and workflow for PO.
• Developed Error Correction forms for PO Receiving Interface etc. for Re-processing records which errors out while importing records from flat files in Inbound Interfaces.
• Data loaded into temporary table from a flat file and then into interface tables in Accounts Payables.
• Performed Data conversion from feeder systems for Purchasing, Inventory and Order Management module data.
• Developed a single program to import invoices into Oracle Payables from three different sources and registered this as a single concurrent program which was used by these source
• Used FND REQUEST package to submit the Concurrent programs and custom Interfaces as applicable.
• Developed a Bridge (interface) between core financial modules for AP, AR and GL
• Developed data files and programs for item upload into Oracle Inventory module.
• Developed a custom interface to process Drop-Ship Orders coming through the EDI 850 inbound Orders into Order Management.
• Developed a custom PL-SQL Interface to populate the Outbound EDI-810 transaction file with additional custom attributes as required by the customers.
• Developed Shell-Scripts to perform the initial validations on the incoming data file and call the respective EDI transactions and Interfaces using CONCSUB utility.
• Built a custom API to ensure that only the EDI orders are considered for ASN transactions (856).
• Designed and developed various reports in Order Management and Inventory modules like: Monthly Sales Report, Pre-Pick List Report, Orders on Hold Report, and Sales Order Report

Environment: Oracle Applications 11.5.10 (Order Management, Accounts Payable, Accounts Receivable, Inventory, EDI), Oracle Workflow Builder 2.6, Oracle Database 9i, SQL, PL-SQL, Reports 6i, TOAD, SQL* Loader

Confidential, IN

Oracle Apps Technical Consultant

Responsibilities:

• Converted receipts from the legacy system and imported into Oracle applications using the Receiving Transactions Open Interface.
• Customized following reports as per the client’s requirements in Purchasing.
• Printed Purchase Order Report, Printed Requisitions Report
• Customized purchase Order Form as per to customer requirements using custom.pll.
• Customized Aging 4-Bucket Report in AR as per the Business needs.
• Customized standard Journal Reports in GL as per the client requirement.
• Created and designed invoicing for the customers using XML Publisher.
• Customized following reports using XML Publisher
• Account Analysis Report
• Consolidation Exception Report for Subsidiary accounts
• Invoice Register Report
• Open Purchase Orders (by Buyer)
• Open Purchase orders by cost center
• Open & manage Oracle TARs to resolve implementation issues.
• Coordination with the users for their Business, Training and Documentation.
• Responsible for providing Post Production support by solving user queries and coordinating the development of any enhancements as required.
• Involved in user training

Environment: Oracle Applications 11.5.7 (PO, AR, GL), Oracle 8i, PL/SQL, TOAD, AOL, System Administration, Reports 2.5, Forms 4.5, Windows XP, SQL * Loader, UNIX Shell Scripting.

Confidential

Oracle Apps Developer

Responsibilities:

• Involved in system study, requirements analysis and design documentation.
• Prepared technical specifications document (MD 70) based on the functional requirement specifications (MD 50).
• Developed Data Conversions and Interface Programs in INV, OM, AR, WSH and BOM using PL/SQL, SQL, SQL*Loader Scripts and Bulk Binding concepts.
• Developed Item Master Conversion and BOM Conversion programs.
• Customized the standard Workflow Items and process such as Order Headers and Order Line.
• Developed scripts for entering transactions like Regular orders, Inter Company Invoicing, Regular Invoicing, Invoicing Rules and different methods of Receipt Processing and application in OM and AR (Order Management and Accounts Receivable).
• Designed and developed Inbound Interface Program using APIs to load the shipped orders into standard OM tables, to bind the customized WSH (Shipping) system with OM (Order Management).
• Pick slip report, Lines on Credit Check Hold Report OM.
• Orders by Item Report in WSH.
• Aging - 4 Bucket Report in AR.
• Worked on Forms Personalization.
• Maintained Discoverer access levels using Discoverer admin.
• Involved in Preparing Training material for WSH (Shipping), Order Management and Account Receivables.
• Involved in Performance tuning of various queries using TK-PROF and Explain Plan.
• Support for maintenance, troubleshooting of R12 environment.

Environment: Oracle Application R12, SQL*Loader, Toad, UNIX, Discoverer, Workflow Builder 2.6.3.5, Report Builder 10g, Form Builder 10g, XML publisher.

Confidential

Oracle Developer

Responsibilities:

• Created Tables, Views, Triggers and Indexes.
• Implemented database packages and procedures using PL/SQL.
• Designed and Developed data entry screens in Forms.
• Developed reports in Reports like daybook, general and party leaders, trail balance, profit & loss statements and balance sheet.
• Developed Master Detail and Tabular reports.
• Involved in User training.