Professional Summary:

• Over 7+ years of experience in Design, Development, Conversion, Customizations, Interfacing and Implementation of business applications using Oracle Applications 11i/R12.
• Expertise in RICE (Reports, Interfaces, Conversions and Extensions)
• Experience in Data Load Professional Tool.
• Extensive experience in using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 9i/ 6i / 4.5, Reports 9i/6i/2.5, Discoverer 10g/4i, XML Publisher, SQL*Loader, EDI 810/850/856 and Workflow.
• Worked in OM (Order Management/Advanced Pricing), Oracle Financials (GL, AP and AR), Manufacturing (INV, WIP and BOM), PO (Oracle Purchasing), Process Manufacturing (Formulator, Quality Manager), HRMS and AOL (Application Object Library).
• Worked extensively on Data Conversions in Various Modules.
• Extensively worked on AIM documents like MD050, MD070 and MD120.
• Extensive experience in identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored SR/TAR's for several P1 issues.
• Expertise in Customizing Oracle reports and developing custom reports by using Report 6i/9i/10g, Discoverer 4i/10g and XML Publisher.
• Experienced in Customizing Oracle Forms with Forms personalization, Custom.pll on Forms 10g/9i/6i/4.5.
• Proficient in customizing Workflow in Oracle Apps.
• Well versed with Performance tuning concepts such as Optimizer Hints, Explain Plan, SQL Trace and TK Prof
• Experience in set-up, configuration, and functionality checks.
• Adept in PL/SQLProcedures, Functions, Packages and UNIX shell scripts.
• Excellent communication skills with ability and willingness to work towards the business and technical requirements of clients and users.
• Excellent teamplayer with strong analytical, presentation and problemsolving skills.
• Analytical, methodical and resourceful approach to problem solving, identifying root cause and corrective actions to meet short and long-term business, financial and system requirements, good understating of team management, communication and presentation skills.

Technical Skills:
Oracle Applications : Oracle Applications 11i, R12
Oracle ERP Financials : Accounts Payables (AP), Account Receivables (AR),
General Ledger (GL), Cash Management (CM), Fixed Assets
(FA), Project Accounting, TCA
Oracle ERP Manufacturing : Inventory (INV), Bill of Materials (BOM), Work in Process
(WIP), Purchase Order (PO), Order Entry/Order Management (OM), Shipping and Advanced Pricing.
Oracle Process Manufacturing: Formulator and Quality Manager.
Operating Systems : MS-DOS, UNIX, Linux, WINDOWS NT/XP/2000/98
Languages : SQL, PL/SQL, Java.
Development Tools : Developer 2000, XML Publisher, Oracle Forms 10g/9i/6i,
Reports 10g/9i/6i, Discoverer 10g/4i Reports and Work Flow
Builder
Database Tools : SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator
Document Méthodologies : MD.070, MD.050, CV.060

Education: Bachelor's in Computer Science

Professional Experience:

Confidential, TX Nov'11 - Till Now

Confidential, is one of the largest provider of Aluminum, Rolled and Extruded Products, Recycled Aluminum and Aluminum Alloy Manufacturing was formed at the end of 2004 through merger of Commonwealth Industries, Inc. and IMCO Recycling, Inc. The objective of the project was migration of data from E-Business Suite 11i to R12.
Roles and Responsibilities:

• Involved in preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) during designing phase.
• Interacted with end users to gather requirements and Draft specifications during development Phase.
• Involved in requirements gathering and testing (Unit, Mock, Pre Production).
• Created Concurrent Programs, Executables and Request sets.
• Used Import Items, Suppliers Open Interface to load Items and Suppliers.
• Coding, Testing of the technical components to meet the functional requirements
• Written an API for Converting Resources/SalesReps (OM) and was able to convert all active Resources/SalesReps from Legacy System into R12 Production.
• Designed and Developed Staging table, SQL*Loader Control Program and Custom PL/SQL API to convert required Employees from Legacy System to Production.
• Designed and Developed Staging table, written a PL/SQLAPI for converting the required Users from Legacy System to Production.
• Responsible for validating data in temp table and importing data to GL interface table and running GL Balances Import.
• Designed and developed staging tables, conversion routines, Custom PL/SQL API's for converting Formulas from legacy system to Production instance.
• Designed, documented and developed staging tables, conversion routines for converting Custom Object like Legacy Customer Mapping, Customer Segmentation, ASN Trading Partners, Price Index History and PO Price Details from legacy system (11i) to Oracle applications R12.
• Responsible for loading Data from Legacy System to Oracle Application R12 for Recipes, Recipe Validity Rules, Specification, Specification Validity Rules and Samples On Hand Inventory .
• Responsible for Extracting Data from Legacy System and Import it to Production (R12) using Data Load Professional tool for Carriers, Contract Purchase Agreements, Manufacturer Part Numbers, Catalog Groups, Item Cross References and Expense Account Rules.
• Responsible for validating data in staging tables and running custom program to import data from staging to interface tables and then running Mass Additions Concurrent Program to migrate data from interface to base tables in Fixed Assets (FA).
• Migrated code from SVN to target instances using JENKINS migration tool.
• Interacted with business users to resolve any issues during the development, Mock testings, Pre Production testing and production phase.
• Created .ldt files for the concurrent programs and request groups.
• Created test scripts for every level of testing from unit testing stage to integration testing.

Environment:Oracle Applications - AP, AR, GL, HR, OM, PO, INV, Formulator, Quality manager, SQL*Loader,PL/SQL developer, TOAD.

Confidential, Grand Rapids, MI. Jun '10 - Nov '11
Oracle Apps Technical Consultant
Description: This project is R12 implementation with customization of PO, OM, GL, AR, AP modules. Developed and customized reports using Oracle 10g, Reports 10g and XML Publisher, provided technical support using PL/SQL, SQL*Plus, SQL Loader, TOAD, UNIX.
Roles and Responsibilities:
Interfaces and conversions:

• Integration of Custom Purchasing interface with Oracle BPEL Process. BPEL process calls EBS Package to populates Purchasing interface tables and creation of purchasing data. Error and Fault Handling in BPEL and EBS Packages.
• Created a common error handling routines for EBS Custom packages and forms.
• Documentation of all RICE objects, like preparing technical design (MD070), test cases (UTP), MD120 as per AIM methodology.
• Development/Customize the RICE components like Reports in Oracle Applications R12 and Custom application which is integrated with Oracle Applications to get the output as per requirement.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Developed PL/SQL Procedures for Customer interface using TCA in (R12) Accounts Receivables according to Client Requirements.
• Bug Fixing And providing Support to RICE components.
• Invoked standard API's within custom packages for creating and updating Customer, Sites and Contacts.
• Developed custom PL/SQL API's for converting Projects, Tasks, and Expenditure types from legacy system (Mainframe) to Oracle Applications.
• Designed, developed and documented an inbound interface for AP Invoices from windows based applications from 11i to R12.
• Responsible for providing production support for Fixed Assets (FA) and Account Payables (AP).
• Responsible for the deliverables of the RICE team (Reports, Interfaces, Conversions and Extensions).
• Responsible for running the Open Interface to import data from OM interface tables into the base tables.
• Implementation of Financial modules (GL, FA and CE) in R12 version.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.

Workflow:

• Customized the AP Invoice Approval workflow and added new workflow function to validate 2/3 way match and to get requester information from requisition into Invoice.
• Involved in Workflow administration for processing Requisition and Purchase orders.

Forms:

• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PL/SQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.

Reports:

• Created a Report for End Users to get the vendor and its site information.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report..
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Involved in development of Discoverer reports like PA account information report, AR aging report etc.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.

Environment: UNIX, Oracle Applications (R12) - AP, AR, Purchasing, GL, FA,OM, TCA, Oracle 10g, Forms 10g, Reports 10g, XML publisher, SQL*Loader, PL/SQL developer

Confidential, Kalamazoo, MI Oct' 08 to Jun' 10
Technical Consultant

The Project involved Implementation of Oracle Applications 11i. Was involved in customizing AR, GL, AP, CM, PO modules including conversion, writing interface programs according to user and business requirements, customizing and developing several reports sing Oracle Reports 6i and Discoverer 4i according to the functional specifications provided.
Responsibilities:
Conversions/Interfaces

• Designed and implemented Purchase Order (PO) outbound (850), AR Invoice (810) outbound EDI process through PL/SQL custom packages.
• Developed PL/SQL API's to generate 850 and 810 EDI Format files.
• Involved as a team member that implemented the Oracle Purchasing module by interacting with the client to understand user requirements. Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Developed staging tables, conversion routines and PL/SQL API to load the Open Legacy Purchase Orders, Payable Invoices, Items and BOMs from legacy system.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Provided functional guidance to help the technical teammates create new automated processes on the modules INV, AP, GL, BOM, PO
• Written an API for Converting the Invoice Payments(AP) and was able to convert all the Historical Invoice Payment History into Production.
• Designed and developed conversion routines, custom PL/SQL API's to convert Jobs, Employees, Employee Addresses, Element Entries, Element Link, Deductions, etc from Legacy system.
• Journal Import: Developed an interface for monthly import of journal entries from Payroll system by using the journal import Interface provided by Oracle General Ledger.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy Payable Invoices into Oracle Payables, Journal Imports Interface from external Payroll into GL, Items into Inventory, Bills of Material into BOM, Work Orders into WIP from legacy system.

Forms

• Developed new forms using TEMPLATE.fmb and customized existing forms in the AP module according to the client's requirements.
• Created descriptive flex fields for standard forms to allow users populate extra information.
• Involved in entering transactions like Regular Orders and Inter Company Invoicing.

Reports:

• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i and registered as XML reports in applications.
• Uploaded and attached the templates to the custom reports in XML Publisher and processed the reports by customizing XML Gateway for the purpose of EDI.

Environment: Oracle Applications 11i (11.5.6/11.5.8), GL, AR, AP, PO, CM, INV, BOM, WIP, OM, HR, OTL, OAB, Payroll, Oracle 8i, Forms 6i, Reports 6i, Discoverer4i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts, HP-UX,XML Publisher

Confidential, India Limited Jan'07 - Oct'08
Jr Technical Consultant

Description: Confidential, is an India-based company. The Company is engaged in designing, manufacturing and marketing electrical products and services related to power generation, transmission and distribution.
Responsibilities:

• Involved in Implementation of many developmental projects in Oracle and D2K.
• Gained experience in writing SQL, SQL*Plus, PL/SQL procedures in Oracle.
• Customized many Forms and Reports according to the business requirements of the clients.
• Security measures at the back end were implemented using Database triggers, validation and Navigational triggers to enforce security at the front end.
• Customized PL/SQL Packages and written database procedures.
• Written PL/SQL validation scripts.
• Involved in generating forms, developing procedures and packages, writing database triggers etc. Used post query trigger to retrieve the employee information. Check boxes, Radio buttons, list items and LOV's were used to make the system more users friendly.
• Interacted with the end user during production support by helping them to develop user required reports and modify the existing as per the requirement.
• Involved in writing technical design documents for conversion and customization.
• Wrote reports in various styles like Matrix, Form letter, and Master-Detail. Various formats were generated using Reports 2.5. Coding was done using PL/SQL.

Environment: UNIX, Windows NT, Oracle10.7, Developer2000 (Forms 4.5, Reports 2.5)

Confidential, Bangalore IndiaSep '05 - Jan '07

The project involved implementation of modules GL, AR, AP, OM. Was involved in conversion, writing interfaces, reports and forms development and customization on these modules. Interfaces involved creation of temp table, loading the data into the interface table using SQL loader (writing the control file to map the data into interface table) from flat files, validation of data before putting the data into Oracle base table and a form was created to correct the erroneous data before loading the data again.

Responsibilities:

• Wrote script to import customer information from legacy system into Receivables using SQL*Loader and PL/SQL.
• Developed program to load external data from legacy system using SQL*Loader into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE Interface Tables.
• Worked on customizing standard Lockbox Interface for Receivables.
• Customized multiple reports and forms in GL, AP, AR and OM modules according to the requirements.
• Interacted with users and analyzed their requirements to develop custom code, forms and reports as per their need and registered with application.

Environment: Oracle APPS 10.7, Oracle 7.3.4/8i. PL/SQL 2.3.3.0.0, SQL* Loader, TOAD