EXPERTISE SUMMARY:

• Nearly 7 years of IT experience as Oracle Applications EBS Technical Consultant in Financials and Manufacturing applications.
• Experienced in the implementation of Procure to Pay (P2P) and Order to Cash (O2C) business processes working primarily on Data Conversions/Interfaces/Customizations/Extensions/Testing of Oracle Application versions 12.1.3/ R 12.0.6/12.0.4/11.5.10.2/11.5.8.
• Experienced in version upgrade from 11i to R12.
• Proficient in using RICE components like Reports, Interfaces, Conversions and Extensions
• Well versed with various Oracle Application Development tools including Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/9i/10G, Workflow Builder, XML Publisher, etc.,
• Expertise in technical skills such as registration of Custom builds Tables, Forms and Reports, Custom Development of Modules following application hierarchy.
• Experience in Oracle Financials (GL, AP, AR), Manufacturing, PO (Oracle Purchasing), OM (Order Management, Advanced Pricing), Service Contracts (OKS), Install Base, Payroll, Advanced Benefits (OAB), Oracle Time and Labor (OTL), OA Framework, AOL (Application Object Library) and System Administrator.
• Good knowledge in AIM (Application Implementation Methodology). Expert in documenting Specification documents like MD70, MD50, MD120, CV40 etc.,
• Good experience in creating AOL objects registration including: Executable, Concurrent programs, forms, functions, menus, profiles and customizing Descriptive flex - fields.
• Knowledge of process/data flow, base tables, interface tables and standard APIs.
• Experience in building Forms, generating Reports and registering them as concurrent programs, creating responsibilities, users, request sets, value sets, etc., in Oracle applications using AOL, System Administrator, and UNIX shell scripts.
• Excellent communication skills self motivated and adapt to new technologies in a short period of time. Strong problem-solving skills and analytical skills.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 11i(11.0.3,11.5.8, 11.5.10.2), R12(12.0.4, 12.0.6, 12.1.3) Purchasing(PO), Accounts Payable(AP), Account Receivable(AR), General Ledger(GL), Order Management(OM), Inventory Management(INV), Cash Management (CM), Fixed Assets (FA), Human Resources (HR), Application Object Library(AOL), etc.Languages: SQL, PL/SQL, C, C++, Unix, HTML, and Java Scripts

Databases: Oracle 11g/10g/9i, DB2

Software Tools: Toad, SQL*Loader, SQL Developer, Putty, WinScp, SQL*PLUS

GUI Tools: Oracle Reports 10g/9i, XML(BI) Publisher, Discoverer 10g, developer 9i, Workflow Builder

Operating Systems: Windows, Unix, Linux, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Upgrade of 11i Custom objects from Release 11i to R12 in all modules.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Worked on SQL*Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Involved in the customization of reports as per the clients requirement.
• Replaced the RA customer view with AR customer when the PO Close Process has been upgraded to R12.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances.
• Developed Item Master Conversion and Sales order Conversions.
• Prepared Functional Mappings for data conversion from 11i to R12 for all Financials modules.
• Customized MODULES AP, AR & GL, FA in Multi - Org environment.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Involved in Performance tuning of the discoverer reports.
• Updated MD70 document according to the R12.
• Involved in writing technical design documents for conversion and customization.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.

Environment: Oracle Applications R12(R12.1.3), 11i (11.5.10.2), (AR, AP, GL, PO, FA, iProcurement), Discoverer 10g, Reports 10G, XML/BI Publisher, SQL, PL/SQL, Forms 10G, TOAD, Workflow BUILDER, JDeveloper, Windows XP.

Confidential, Hoboken, NJ

Responsibilities:

• Involved in the design and development of 11i to R12 Journal Entry extract and GL Balances conversion.
• Documented various technical specification documents including,11i to R12 daily Interface extracts, PeopleSoft Interfaces, Journal Approval Workflow, FAH web ADI templates, Data extracts to fiduciary Data Marts etc.,
• Developed PL/SQL packages as per business requirements for transformation and loading of data from/to flat files.
• Designed and developed custom Web ADI template for loading Journal Entries into FAH.
• Developed various Discoverer reports for consolidation and reconciliation of financial data.
• Created business areas, custom folders, summary folders, hierarchies and item classes in Discoverer Administration edition.
• Built Workbooks in Discoverer 10g and edited the existing workbooks; adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling workbooks.
• Designed and developed a process for extracting errors and storing them to errors table by category, resulting from Custom extensions, as a packaged solution.
• Extensively used SQL loader to load all interface data into Custom source transaction tables for further validation and processing.
• Designed, documented and developed staging tables and custom PL/SQL API’s for converting Open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customer Accounts, Sites, Profiles, Profile amounts using TCA, Open AR Invoices, Open Purchase Orders from legacy system to Oracle Applications.
• Developed Bank reconciliation reports as per business requirements.
• Developed various Subledger accounting reports for data streamlining and analysis.
• Developed extensions for GLBATCH workflow, for validating Image s in Web Center.
• Configured various AOL objects including Custom Menus, Responsibilities, Forms, Lookups, Value Sets, Profile Options, Request Sets, etc.,
• Extensively worked on FND LOAD for downloading and Uploading LDTs into different instances. Various custom FND objects are migrated using the approach including: Value sets, DFFs, Profile Options, Form Personalizations, Menus, Responsibilities, concurrent programs. Lookups etc.,
• Created various database objects including tables for lookup and mapping, Views for reports, DB links, Procedure, functions and Packages.
• Extensively used UTL FILE utility for data extract into flat files from Oracle EBS.
• Providing Post go-live support for objects released for DAY1 while simultaneously working on DAY2.
• Created Test Plans, supported in object migration, and issue resolution as of when needed.

Environment: Oracle Applications R12, GL, AP, AR, PO, SLA, INV, AOL, Reports 10g, Forms 10g, Oracle Database 11g, SQL, PLSQL, Workflow Builder, SQL*Loader, TOAD, Discoverer 10g, UNIX.

Confidential

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Interfaced data from the Flat Files into Interface tables of Accounts Payable using SQL*Loader and executed the Payable Open Interface Import Program to generate invoices.
• Developed Pick confirm and Ship confirm Interface using oracle API’s.
• Involved in rewriting some of the existing custom interfaces in PL/SQL to reduce the turnaround time of execution and completion of concurrent processes.
• Developed code to import costing data of items imported from flat files to Costing tables directly.
• Experience in importing requisitions from legacy system to Oracle Purchasing through Requisition Open Interface (PO).
• 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.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Personalized various forms in AP, AR, PO and GL for restricting access and implementing client specific business logic.
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications.
• Involved in customization of reports in PO, AR and AP, such as Printed Purchase Order Report, Aging 4 Bucket Report, etc using Reports6i and XML/BI Publisher
• Performed performance tuning on various application programs to enhance the speed by utilizing Indexing, SQL HINTS and Materialized Views.
• Customized AP invoice approval and PO approval workflows to add additional messages in the notifications, Supplier Type approval logic, etc.,
• Working in collaboration with DBA team, created partitions and automated scripts to dynamically archive old partitions and create new.
• Developed AIM documentation as per client requirements. Authored Migration and integration installation documents.
• Worked with Version control and Code Migration Software.
• Involved in post-production support, issue analysis and Bug fixing.
• Created various Service Requests with Oracle Support, working with them closely for fixing various Bugs and applying data fixes in AP.

Environment: Oracle Applications (11i/R12.1.1): GL, AP, AR, INV, PO, CM, IEXP, FA, Oracle Database: 9i/10g, SQL, PL/SQL, Oracle Reports 10g, Forms 10g, XML Publisher, SQL *Loader, Workflow Builder, UTL, AIX, Clear Case, Kintana.

Confidential

Responsibilities:

• Analyzed the various reports that require customization in OM and Inventory. Customized Sales Order Acknowledgement report to meet the business requirements for Retail orders.
• OM Customization - Forms Personalization for Related Item Price and Quantity.
• Prepared categorized iProcurements catalog for different kind of items used in the company.
• Created Oracle Business Areas and Workbooks using Discoverer.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Work flow customization to auto creates PO for Low Value requisitions.
• Involved Implementing extension in iStore Checkout functionality for display additional lines on Review & Place Order page
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Involved in adding new descriptive flex field in Order Management to capture additional data.
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, AR, WIP and INV.
• Developed Auto Invoice Interface program to import invoices from legacy systems to AR.
• Used Auto Invoice to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import Program.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.

Environment: Oracle Applications (R12.0.4): INV, AP, AR, OM, WIP, BOM, OPM, FA, CM, Oracle Database: 10g, SQL, PL/SQL, Oracle Reports 10g, Forms 10g, XML Publisher, SQL *Loader, Workflow Builder, UTL, AIX, Clear Case, Kintana.

Confidential

Responsibilities:

• 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 packages and procedures to update the data from production ERP to the data warehouse tables.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.
• Developed custom reports as per client requirement in OPM Forecasting module.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Involved in design of functional setups in Order Management.
• Created PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables with Bulk.
• Modified Invoices form in AP and Transactions form in AR to restrict data access.
• Developed AP Invoice Conversion and vendors conversion programs.
• Worked on the Auto Lockbox in receivables that automatically creates receipts using the electronic information that the bank provides.
• Preparation of Technical Documents for Reports and Interfaces.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports and XML Publisher.
• Wrote technical design documents MD-70 for conversions, extensions, interfaces, and reports.
• Created and modified PL/SQL API for creation of assets retirement and Mass additions in interface table in FA module.
• Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.

Environment: Oracle Applications (11.5.10.2): GL, AP, AR, PO, CM, FA, Oracle Database: 9i/10g, SQL, PL/SQL, Oracle Reports 6i, Forms 6i, XML Publisher, SQL *Loader, UNIX, VSS.

Confidential

Responsibilities:

• Design and development of components for Payables Interface, which loads Expense reports data into payables. Employee Expense reports are processed and approved in Metro/Extensity (third party tool), and is interfaced with payables. Data will be populated into AP INVOICES ALL, AP INVOICE DISTRIBUTIONS ALL tables. Analyzed and modified the code to include schema level changes. Development of “view expense report errors” form where user can query & rectify the errors.
• Customization of Custom Supplier Entry Screen from 2.3 to 6i. This form will not display bank information and Address information when opened from enquiry responsibilities. Account tab modified to have only one account.
• Development of kit Inventory Report. Report should display similar information like indented BOM screen of bill of materials. Report can be submitted for single or multiple kits. This report is being called from a host program, which is registered as a concurrent program. This customization also includes SQL*loader program. Involved in Design, development and testing of all the components.
• Development of kits maintenance form. User can query the kit information and few fields through this form. The form involves business specific validations and front end duplicate checking and developed using TEMPLATE.fmb following apps standard. Modified other forms (Default country Formats, Defaulting Rules) of custom module.
• Parts maintenance interface. This Interface program is used update the parts maintenance database from a text file which has updated information about parts. Modified the interface logic as per the changes in the business requirements and development of sql*loader and required pl/sql programs. Developed Shell Scripts to automate Data loading and Interface programs
• Unit testing of the customization Migrated/Developed and Preparing Unit Test case Documents.
• Development of Corporate Queue screen using TEMPLATE.fmb. This screen is used query all pending subscriptions to approve/reject them. This form involves QUREY-FIND implementation.
• Development of “adjustments-main” form using template.fmb. This form is the starting point for various adjustments (ex: prepaid to postpaid). Constructed special menu using APP SPECIAL. User can navigate to different adjustment form from here.

Environment: Oracle Apps 11i (GL, PO, INV, OM, AP, FA, AR), SQL, PL/SQL, UNIX, Oracle 9i/8i, Forms and Reports 6i, Developer 2000