SUMMARY

• A dynamic professional wif 8+ years of experience in design development, setup, support, customization and testing in Oracle ERP Applications.
• Extensive experience as Technical consultant in implementation of Oracle Applications 11i/11.o.x, R12 in Supply Chain & Manufacturing modules like purchasing, Inventory, Order Management, Work in process, Bill of Materials, Shipping, Material Resource Planning & Financials modules like Receivables, Payables, Project Accounting, General ledger.
• Extensive noledge of Business Processes across teh E - Business Suite, Order to Cash (O2C) and Procure to Pay (P2P).
• Experienced in Oracle Financial Application upgrades from 11.5.7, 11.5.9, 11.5.10.2 and R12
• Experience in customization of form personalization and creating forms.
• Experience in designing new reports and modifying existing Reports using Oracle Reports, XML Publisher and Discoverer.
• Developed several Oracle Alerts as per teh business requirement
• Experience in Oracle Application Implementation Methodology (AIM) MD-50, MD-70 Documentation.
• Good noledge on customization of workflow.
• Experienced in UNIX and shell scripting.
• Good Experience in using SQL*loader to import data into staging tables form legacy system.
• Expertise in design and development of RICE (Reports, Interfaces, Conversions and Extensions) components.
• Expert in writing stored procedures, Packages and functions using SQL & PL/SQL.
• Extensive Experience in using Application Object Library (AOL) concepts.
• Very good understanding of Multi org & TCA (Trading Community Architecture) architectures.
• Good Knowledge in Performance Tuning and Troubleshoot issues.
• Extensive noledge on AppLOAD, AppMIGRATE and AppEXTRACT tools.
• Excellent communication, leadership, interpersonal skills. Dedicated and Motivated in accepting various challenges imposed on me and showing enthusiasm in group work assigned to teh team.

TECHNICAL SKILLS

ERP: Oracle Applications EBS (Versions 11.5.7/11.5.9/11.5.10.2/ R12)

Modules: General Ledger (GL), Accounts Payables (AP),Project Accounting(PA) Accounts Receivables(AR), Advanced Pricing(QP), Inventory (INV), Work in Process (WIP), Bills of material(BOM), Order Management (OM), Purchasing (PO), Material Resource Planning(MRP),Shipping(WSH), Application Object Library (AOL).

Processes: Order to cash, Procure to Pay

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

Database: Oracle 8i / 9i / 10g

Tools: Discoverer, XML Publisher, SQL * Loader, Toad, SQL *plus

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

Web Languages: HTML, XML, XHTML, JavaScript

Packages: Ms-Office

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD20 (Functional Spec) and tan writing CV040 (Technical Spec).
• Worked extensively on ChRM, Item Orderability Rules, Pricing, On-hand Inventory and Sales Agreement CV040 documentation.
• Good noledge on SIPOC (Suppliers,Inputs,Process,Outputs, andCustomers) creation.
• Involved in review of several CV040 documentations and SIPOC.
• Extensively worked wif teh Business Owners and IT project leads to fulfill their requirements.
• Extensive noledge on AppLOAD, AppMIGRATE and AppEXTRACT tools.
• Performed data load for On-hand Inventory, Regions & Zones, PO Modifier & Qualifier, QP Modifier & Qualifier using AppLOAD tool.
• Extensive noledge on AppLOAD, AppMIGRATE and AppEXTRACT.
• Involved in converting legacy system data into teh respective PO, INV and OM modules of Oracle Applications.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields’ Registered concurrent programs, request groups for reports and concurrent requests.

Environment: Oracle Applications R12.2.3 (OM, ChRM, INV, PO, QP, Regions & Zones) oracle 10g database, PL/SQL, AppLOAD, Forms, workflow and UNIX.

Confidential, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD50 (Functional Spec) and tan writing MD70 (Technical Spec).
• Developed PL/SQL procedures, functions, packages, triggers to validate teh data and insert teh data into Oracle Standard interface tables.
• Developed teh custom program to feed Customer data from teh external source to teh standard tables.
• Developed Inventory Outbound Interface Program to extract teh inventory item data from base tables to flat file using UTL FILE package.
• Automated custom Data Cleansing packages to normalize, cleanse, validate, extract, de-duplicate and interface teh legacy Supplier and Customer data into teh pre-staging tables of Oracle custom conversion programs.
• Developed an interface program to integrate third party system to Oracle GL for importing journals.
• Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto-invoice Master Program to load teh interface table data into Oracle AR base tables
• Designed and developed wrapper program for BOM Components Interface using bom comps interface.
• Imported BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temporary table using teh SQL * Loader, validated teh temporary table data and moved to teh Interface table.
• Involved in converting legacy system data into teh respective PO, INV and OM modules of Oracle Applications.
• Worked on developing teh check template for payments using XML Publisher and in teh process communicated wif teh bank for testing and finalizing teh check template.
• Developer several reports in PO, AP, AR and GL modules using Oracle Report and XML Publisher.
• Provided teh production support for ongoing issues which are related to Order to cash and Procure to pay cycles.
• Extensively worked wif Oracle support to Resolve SRs for Production issues.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields Registered concurrent programs, request groups for reports and concurrent requests.
• Involved wif study of existing system, preparing teh Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering teh developed and customized reports.

Environment: Oracle Applications R12 (OM/OE, INV, WSH, WIP, AP, AR, GL) oracle 10g database, PL/SQL, SQL Loader, Forms, Reports, workflow and Unix.

Confidential, WI

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on SQL* Loader to load all teh data given in flat files wif various special characters and comma delimiters.
• Worked on teh development of Interfaces, Conversions, personalizing Forms, developing Reports, customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed PL/SQL Packages, Procedures, Functions for validating teh invoices and payment information from teh legacy system and imported into Oracle Application using teh Payables Open Interface Import program and populated into teh Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Worked on GL journal import to import legacy journals into Oracle GL.
• Worked on Auto lockbox process to import receipts into Oracle AR.
• Developed Scripts for teh Transaction Open Interface to load all items into a particular Inventory & Sub inventory and loading all teh serial numbers for teh items which are serial controlled in INV.
• Developed a custom program to Generate Receipts for all teh Standard PO’s which are received into teh INVENTORY wif teh halp of RECEIVING OPEN INTERFACE IN PO.
• Involved in importing Sales Orders from legacy system to Oracle Application base tables using teh standard API. Validated data using packages, before loading it into teh corresponding base tables.
• Worked on Open Resource Transaction Interface to load resource transaction information into teh oracle WIP from external source. Teh Cost Manager is launched to load teh data in interface table into oracle WIP base tables.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flexfields Registered concurrent programs, request groups for reports and concurrent requests.
• Extensively developed reports using XML Publisher and Oracle Reports in several modules.
• Worked on production support tickets supporting existing Oracle 11i system.

Environment: Oracle Applications 11i/R12 (AP, AR, GL, OM, PO), BI/XML Publisher, Discoverer, Forms 9i/10g, Reports 10g/9i, Reports 6i, Workflow Builder 2.6.3, PL/SQL, TOAD, Web ADI, KINTANA, PVCS.

Confidential, KY

Oracle Apps Techno-functional Consultant

Responsibilities:

• Involved in interacting wif functional leads, technical lead and data management team in order to document teh technical and development specifications using standard AIM documents like MD070, CV060, MD120 and resolve certain data requirement issues.
• Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.
• Developed WIP open Move Transaction Interface to load data from external data collection devices (like Manufacturing Execution Systems, Automated Test Equipment).
• Worked on Open Resource Transaction Interface to load resource transaction information into teh oracle WIP from external source. Teh Cost Manager is launched to load teh data in interface table into oracle WIP base tables.
• Defined Work in Process (WIP) Parameters, Accounting Classes, Profile Options, Production Lines, Repetitive Assemblies, Schedule Groups, Labor Rates, Shop Floor Statuses, Planning Parameters, Demand Class, Planners, Forecast Sets, Forecast Rule, MDS, MPS, MPS Options, MRP, MRP Options, Bills of Distribution.
• Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Autoinvoice Master Program to load teh interface table data into Oracle AR base tables.
• Developed a custom wrapper program (Inbound Interface) to validate and import teh legacy Open AR Receipts data into Oracle base tables using standard API: ar receipt pub.create cash().
• Involved in development of TCA Customer Conversion program which includes data validation and API calls.
• Developed custom program(Inbound interface) to validate and load teh PO documents from Orgill (a third party supplier site) into Oracle Purchasing interface table. Used Purchasing Document Open Interface program to load teh data into Oracle base tables.
• Involved in customization of Standard Oracle Reports in Purchasing (PO) and Order Management (OM) as per client requirement, using Oracle Reports and XML/BI Publisher.
• Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms. Involved in customization of Standard Oracle Reports in Purchasing and Order Management as per client requirement, using Oracle Reports.

Environment: Oracle Applications 11i/R12 (AP, AR, GL PO, INV, WSH, OM), Oracle 9i, Discoverer, Reports, PL/SQL, Stored Procedures, Windows 2000, UNIX, AOL.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions to track teh budgets, return orders at teh order level and teh line level.
• Developed interfaces like supplier, commission, item price, on hand Qty update, shipping data update (back to legacy system).
• Loaded Legacy Journals data into GL INTERFACE table using SQL*LOADER and custom wrapper program.
• Converted Legacy Chart of Accounts Data and Mapping Values Data into Oracle 11i Mapping tables, While loading data need to compare wif Segment structure, segments Mapping values, rules etc.
• Involved in Project Accounting conversion, designed and developed teh programs to convert Projects, Tasks, Budgets, Agreements and funding, Events and Cost
• Developed Profitability Report in PA (Project Accounting), showing teh details of Costing, Revenue, Budgets, Variance and profit/loss for a project. Teh report also created to work for Organization hierarchy
• Developed Utilization Report breaking it down by Organization, Department and teh Project Manager in Project Accounting.
• Involved in teh Implementation of P2P life cycle
• Developed Interfaces to load teh accrual data from Purchasing into PA and GL.
• Developed new reports and modified existing reports for PA AP, AR, and GL.
• Worked on developing FA reports as per client requirements.
• Performed System Administration functions like Created Custom Menus, responsibilities, Concurrent executable, concurrent program.
• Worked on AOL objects, updating and loading data into Lookups, Creating Descriptive Flex fields, defining new Messages.
• Developed reports using Oracle reports and Discoverer4i to analyze data OM and PO modules.
• Customization of Forms in Oracle Applications as per client requirement in OM, INV and PO modules.

Environment: Oracle E-Business Suite R12 (INV, OM, PO, AP, AR, GL, FA and PA), Oracle 9i, PL/SQL, Forms, Reports, Work Flow, Discoverer, UNIX, Apache Tomcat, TOAD.

Confidential, CA

Oracle Applications Technical consultant

Responsibilities:

• Involved in teh requirement gathering, analysis and design of teh interfaces and reports.
• Developed new Custom Oracle, SQL, and PL/SQL Reports as per teh business requirement.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Developed custom forms and reports to correct interface errors and send teh error messages to legacy system owners.
• Using SQL*Loader loaded teh data into staging table, Developed PL/SQL packages to validate teh data and load into interface tables.
• Responsible for creation of MD070s for AP Invoice import.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for teh different Sources in Oracle Payables.
• Involved in teh development of TCA (Trading Community Architecture) Model.
• Developed a custom layout XML format according to teh user specifications and worked on incorporating it to teh standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Involved in migrating developed objects between instances.
• Developed custom shell scripts to create synonyms and grant necessary permissions for teh objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Developed PO outbound interface to get teh flat files from Base Tables.
• Developed Customer conversions Program and upload teh data into Customer base tables.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).

Environment: Oracle Apps R12 (AP, GL, PO, AR, OM, INV, TCA, FA), Oracle 10g, Oracle A.me.M, Oracle SQL, Oracle PL/SQL, Discoverer, XML Publisher, Forms, UNIX, WINDOWS XP.

Confidential

Oracle Developer

Responsibilities:

• Designed & Implemented automatic error handling and recovery processes for table data loads and to make sure that dependency of teh “order” of table loads was maintained.
• Coded processes for automatic export and import of data in tables using Oracle Export/Import utility.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Responsible for developing technical specifications from business requirements
• Involved in trouble-shooting production database problems and report problems.
• Designing and developing teh module functionality using Pro*C, Embedded SQL, PL/SQL stored procedures and functions.
• Analyzed teh requirements and created a logical model of teh Oracle database and represented teh entity hierarchy and relationship using ER diagrams.
• Optimizing transactional database queries using Hints, to improve processing speed.
• Involved in creating Queries for Business Objects to produce reports, Generating XML flat files from select queries, developing SQL*Loader scripts to load data into tables, and working wif teh Production Support team to fix many high priority bugs.
• Used Advanced Explicit cursors Concept like FOR UPDATE, WHERE CURRENT OF Clause.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Fine Tuned procedures for teh maximum efficiency in various schemas across databases using Oracle Hints, Explain
• Plans and Trace sessions for Cost based and Rule based Optimization.
• Wrote Unix Shell scripts for teh relevant work.

Environment: UNIX OS, Oracle 8i, SQL, PL/SQL, SQL*PLUS, TOAD, Java, JavaScript.