SUMMARY:

• Oracle ERP professional with around 9 years of diversified experience asOracle Techno Functional Consultantin Developing, Implementing, Support, testing and managing full lifecycle projects globally.
• Implemented and supported various Oracle application modules: Account Payable (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Purchasing (PO),Order Management (OM), Inventory (INV), Bills of Material (BOM), Work in Progress (WIP), Shipping (WSH), Discrete Manufacturing (ODM),IProcurement, iExpenses, iReceivables, EBTaxand AOL objects.
• Proficient in support, upgrade and implementation of Oracle E - Business Suite R12 and 11i.
• Expertise in Financials, Inventory, Purchasing, Order Management, Shipping, Procurement modules with a very good understanding of the integration between the distribution and finance modules.
• Proficient in functional flow of Order to Cash (O2C) and Procure to Pay (P2P) cycles
• Provided technical support for all Inbound / Outbound transactions utilized within Order to Cash (O2C) and Procure to Pay (P2P) cycles
• Proficient in registering Concurrent Programs, Forms, Functions, Tables, developing Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL),System Administration and Documentation in Oracle Applications.
• Good knowledge on AIM documents like MD050, MD070 and MD120. Especially on Design and Development of Technical Specifications (MD70) based on functional Specifications (MD50), Preparation of Unit Test Cases (TE30) and Installation (MD120) Documents.
• Proficiency with tools used to support Oracle Applications development including Forms, Reports, and XML Publisher.
• Developed multiple complicated XML Publisher reports, used features like XML bursting and conversant with XSLT syntaxes, conditional formatting etc.
• Proficiency in understanding client’s needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Experience in Workflow . Development and Customization of RICE components (CEMLI’s)-Reports, Interfaces, Conversions and Packagesin Oracle Application 11i, R12.
• Experience using workflow components like Workflow Builder, Workflow Engine, and Workflow Monitor.
• Expertise in Data Conversion, Data migration, Developing Interfaces within several modules in Oracle Applications.
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Proficient in writing triggers, packages, procedures and functions in PL/SQL for data validations and loading.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting,C, C++, JAVA/J2EE, HTML

Enterprise Applications: Oracle E-Business Suite R12, 11.5.4 to 11.5.10, Oracle SOA Suite (10g, 11g).

ERP/Modules: Oracle Financials (GL, AR, AP, FA, CM),Oracle SCM (OM, INV, PO, WSH), AOL, Sys. Admin

Oracle Tools: Reports 6i/9i/10g, Discoverer 4i/10g, Forms 6i/9i/10g, SQL*LOADER, XML Publisher, Oracle Work Flow Builder.

Databases: Oracle 11g/10g/9i, MS Access

Tools: TOAD, SQL* PLUS, SQL Developer, SQL * Loader, PUTTY

Operating System: Windows 9x/NT/2000/XP/Vista, MS DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Hercules, CA

Sr. Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in conversion of data from legacy system to Oracle Apps R12 for different modules like General Ledger (GL), Accounts Payables (AP), Accounts Receivable (AR),Cash Management (CM), and Order Management (OM).
• Involved in analysis, design, development, testing and implementation of Oracle Applications R12.
• Involved in gathering the requirement from the user, preparing the Scope and Requirement Document, Functional Document, Technical Design Document.
• Worked towards Future business flows, Identification of Gaps, Work arounds in order to provide an Integrated Procure to Pay (PTP) business flow.
• Developed a custom conversion programs to validate and import the legacy Open AR Receipts and Open AR Transactions data into Oracle base tables. Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Define user responsibilities, set up custom menus based on user Responsibilities during Procure to Pay ( PTP ) implementation.
• Customized various reports in OM, AR Module including ARReconciliation Report, Invoice Aging Report.
• Developed a XSL template for customizing the AR Sales profit report using XML/BI Publisher and distribute the offer document generated from XML Publisher.
• Worked on OAF (Oracle Application Framework) to develop customized solutions for AR Module.
• Designed & Developed AP Invoice Audit Report and AP Invoice Open Interface for the different Sources in Oracle Payables.
• Involved in development of TCA Customer Conversion program which includes data validation and API calls.
• Involved in Forms personalization with addition of extra information through Descriptive Flex-fields.
• Developed the AOL forms using the TEMPLATE.fmb and built the code as per the AOL coding standards.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Worked on Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• Involved in Datamigration from Legacy systems to APIs and Open Interfaces.
• Designed and developed an interface program to load the legacy data into Oracle General Ledger (GL) using PLSQL package and standard Journal Import program.
• Customization of PO Requisition Approval workflow to send FYI email notification to the CFO based on the requisition amount.
• Generated weekly/monthly Reports using XML/BI Publisher for Department wise Payments to vendors.
• Developed test scripts and involved in the end to end testing, UAT and resolved the issues.Prepared Unit Test Cases and User Manualsasper business requirements.
• Extensively worked in tuning the Oracle Database queries using Indexes, Explain Plan, Optimizer Hints, SQL Trace and TKPROF for high efficiency.

Environment: Oracle Applications EBS R12(GL, AP, AR, OM,PO), Oracle 11i,BI/XML Publisher, Forms 10g, Reports 10g, SQL*Plus, SQL*Loader, PL/SQL, TOAD.

Confidential, LA

Sr. Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked with team for support of Oracle Financials (General Ledger (GL), Account Payables (AP), Account Receivables (AR), Cash Management (CM), Fixed Assets (FA) modules.
• Developed customized solution for clients, coordinating with business users and functional team members for the functional requirement.
• Performed setups in Inventory (INV) and Order Management (OM) modules based upon client requirement.
• Worked for Procure toPay (PTP) Process and Order to Cash (OTC) Processes and module integrations with Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Order Management (OM) and Inventory (INV) with in EBS System.
• Worked on testing the flow of Order to Cash (OTC)and Procure to Pay (PTP) cycles.
• Involved in Production support of RICE components in GL, SLA, AP, PO and AR with Oracle XML/BI Publisher Reports.
• Worked on iExpense creating reports, sending reports to AP, converting reports to invoices.
• Designed and developed new Forms in Forms 10g and Reports in Report 10g for Custom Application through Concurrent Request from Oracle Forms Custom Applications, which is implemented with Oracle Financial Release R12 Modules.
• Worked on oracle standard API using PL/SQL in Order Management (OM) and advanced pricing modules.
• Worked on providing test scripts for Release R12 upgrade for iExpense module.
• Customized standard Oracle Apps Reports by adding extra field or extra parameter to sort data in a report for SCM andFinance Modules.
• Developed Several Adhoc reports as per business requirement.
• Managed the processing of all Oracle iProcurement purchase orders and worked on automatic generation of standard purchase order from iProcurement requisition using supplier purchase contracts.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Developed data entry forms , complex and template forms in Forms 10g . Creation of Pop-up Menus and maintaining Master Detail relationship.
• Worked on R12 upgrade of iExpense Module, setting up JDeveloper environment to re-apply extensions in R12 instance.
• Expertise in writing PL/SQL packages for Creating and managing customer’s data using TCA (Trading Community Architecture) in AR.
• Created and customized output format in XML, new templates for XML/BI Publisher to display the reports in client requirement format.
• Worked on the Autolockbox interface program for the processing of credit card related data.
• Developed reports and data extracts in OM, WSH, INV and AR.
• Preparing functional/technical specifications for reporting, interfaces and customizations.
• Involved in Importing the Order Management(OM) data from legacy system to Order entry Interface tables using SQL*Loader, validating the data using PL/SQL script and creating orders using Order Import Program.
• Performed fit/gap analysis between the client’s business processes and their intended use of the software, identified and communicated the solutions for the problems to the client.
• Developed SQL queries to compare summary information of the standard and custom reports in Order Management (OM), Inventory (INV), and Receivables (AR).
• Attended to, researched and fixed issues that emerged from Production Environment.
• Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Worked on PVCS Version Control for to migrated codes to other instances.

Environment: Oracle EBS12.1.3 (AR, AP, PO, GL, CM, FA, OM, INV, iExpense), Oracle 11i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 10g, Forms 10g, XML Publisher, TOAD, PVCS, UNIX.

Confidential, Omaha, NE

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on EBS R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes.
• Developed code for Conversion of GL balances from 11i to R12, which includes both YTD and PTD balances.
• Upgraded Oracle reports, discoverer reports and BI publisher reports for financials.
• Did analysis to identify and prioritize PL/SQL and database objects upgrade according to dependencies.
• Worked on identifying customizations for the R12 upgrade.
• Developed custom reports using oracle reports 10g for Missing contacts and contacts points for customers.
• Customized AP Approval Workflow according to the business needs for R12.
• Developed a custom Customer Statement rtf Report using BI publisher.
• Developed code for Oracle Fixed Assets (FA) conversion from 11i to R12, which includes conversion for both corporate book and Tax books.
• Implemented interface for Vendors. Also developed packages to load and update vendor and vendor site information.
• Developed common SQL*Loader script using UNIX shell script which is been used for most of the conversions.
• Identifying the patches that are mandatory for the applications to address the current issue or for the future issues, planning and conducting the regression testing and migrating to production environment.
• Developed Custom Order Entry screen for user convenience and developed an interface to import these sales orders into OM.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).
• Developed major enhancements required for business process in Order to Cash (O 2 C) and Procure-to-Pay (P 2 P) cycles.
• Involved in developing custom XML/BI Publisher reports like Open Sales Order Summary, Purchase Order Summary.
• Customized Order Management (OM) Header and Line workflows to meet business requirements.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Involved in creating Discoverer reports to generate Purchase Order (PO) reports.
• Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program.
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms.
• Implemented Work in Process for Discrete manufacturing (ODM) that interfaced with MES software.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Involved in setting up punch out stores in I-Procurement.
• Developed and customized various custom reports like PO Requisition Details Report, Open PO Report, Open Receipts Report and PO Unsourced Requisitions Report in Reports 10g builder.

Environment: Oracle Apps R12.1.3, 11.5.8/10.2 (OM, AR, AP, PO, FA, GL), Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Shell Scripting, TOAD, UNIX.

Confidential, Phoenix, AZ

Oracle Applications Techno Functional Consultant

Responsibilities:

• The project is an implementation of Oracle Apps R12. Involved in developing conversion programs, interfaces, Custom OAF pages, building custom reports and writing UNIX shell scripts based on the functional specifications provided.
• Developed various interfaces, both inbound and outbound, which are run on the periodic basis. The modules worked on include OM, INV, WIP, BOM, AR, GL and PO.Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
• Developed custom reports using Reports 6i and also customized seeded reports.
• Developed various custom reports PickSlip Report,Bill Of Lading (BOL) using Report builder.
• Customized Shipping Transaction form and WIP Move transaction form using Form personalization. Customizations include adding menus, Hiding fields and changing prompts.
• Designed various custom components for R12 Implementation which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• Worked on SQL*Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Worked with GL tables, AR Interface, Customer Interface and GL interface (GL INTERFACE, GL BUDGET INTERFACE).
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Responsible for the implementation of Oracle Order Management, CDL and Configurator Extensions, Supply Chain Management -BOM, WIP, Inventory, Shipping, Advanced Pricing, Install Base and Advanced Supply Chain Planning with Global Order Promising for a manufacturing company with different business units.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer responsibilities.
• Developed customized reports using XML Publisher & Discoverer.
• Worked on performance tuning of existing reports and PL/SQL programs.

Environment: Oracle Apps R12, 11.5.8/10.2, GL, AP, AR, PO, OM, Oracle 9i/10g, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Oracle Configurator, Shell Scripting, TOAD, UNIX.

Confidential

OracleTechnical Developer

Responsibilities:

• Gathering functional requirements and created technical documents for custom reports, script files.
• Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
• Involved in analyzing and developing the code as per MD50.
• Created database objects like tables, views, functions, procedures, triggers etc.
• Enhanced the existing process with new functionality to meet the client requirements.
• Involved in developing reports, concurrent programs, AOL objects etc. as per the business requirements.
• Developed inbound interface to load purchase order details into purchasing base tables from legacy systems.
• Extensively worked on FND LOAD for migrating concurrent programs, value sets, descriptive flex fields, lookups from one instance to another.
• Developed UNIX shell script for file transfer and data loading to automate interface programs.
• Registered the shell scripts as concurrent programs and created a scheduling process that invokes the scripts periodically.
• Played vital role in resolving business critical issues in PL/SQL Packages, Reports etc.

Environment: Oracle Apps 11.5.6, Oracle 9i, SQL, PL/SQL, SQL developer, XML Publisher, UNIX.