SUMMARY:

Over Eight + years of IT experience in software design, documentation, and coding, testing, deployment of various applications.

• Expertise in Application Development and Customization, open Interfaces and Conversions, Development of Forms (Version 10g/9i/6i/4.5), Reports (Version 10g/9i/6i/2.5), Discoverer (version 4i/9i/10g), XML/BI Publisher reporting tool and Workflow Builder.
• Expertise in Developing, Customizing and Implementation of various Oracle Application Modules (Order Management (OM), General Ledger (GL), Account Payables (AP), Account Receivables (AR), Purchase Order (PO), Cash Management (CM), Inventory (INV), Bill of Materials (BOM), Project Accounting (PA), Human Resources (HR).
• Good Experience in Design, Development,Customizations, Conversions, Interfaces, Reports, AME, Workflows and Personalization (RICEWP) using Oracle Applications R12 and 11i, SQL, PL/SQL, Oracle 11g/10g/9i/8i, Developer 6i/10g.
• Extensive experience with Relational Database Management Systems (RDBMS) including Triggers, Procedures, Packages using Oracle and SQL Server
• Experience in Object Oriented methodologies and design practices with emphasis in J2EE framework.
• Experience in Full life cycle of Oracle Applications implementation.
• Extensive experience in Order-to-Cash and Procure-to-Pay process with full life cycle implementation.
• Involved in User Acceptance Testing (UAT).
• Excellent verbal and written communication skills.
• In depth at working with diverse technical groups and global customers to develop technology solutions that meet or exceed expectations.
• Complete Full Life Cycle experience with AIM Methodology.
• Experience in Multi-org & multi-currency process
• Excellent analytical, problem solving and communication skills with ability to be an effective team player and work under severe time constraints.

Areas of Expertise:

• Good understanding of Oracle applications including underlying table structures and database procedures and APIs both in Functional and Technical.
• Migration: Involved in Migration & Upgrade of data from Oracle Apps 11.5.10.2 to Release 12.1.3.
• Flex Fields: Good knowledge of Flex Field's structure in Oracle Apps.
• Interfaces: Designed and developed interfaces for INV, OM, PO Shipping, GL, Payables, and Receivables Modules.
• Testing: Very good testing knowledge of Oracle Manufacturing (OM,INV,PO) & Financials( AP,AR,GL)
• Tuning: Extensive Experience in Optimization (Tuning) of the Applications at the application level as well as the DBA level.
• Conversions: Extensively created mappings and conversions in Oracle Apps to import data after validations in to ERP.
• Backend: Experience in Creating Triggers, Packages, Procedures, Functions using PLSQL.
• Client Interaction: Interaction with Clients\\Business to identify the business practices, future requirements, identifying the gaps and designing alternate solution.

SKILLS:

• Oracle Applications: R12, 11.0.x/11i.x,10.7 Financials and Distribution
• Operating Systems: UNIX, LINUX, Windows(NT/2K/XP)
• Database: Oracle 11g/10g/ 9i/8i , MS Access
• Database Tools: Toad, SQL*Plus, Oracle developer 10g/9i/6i (Forms & Reports), OA FrameWork, Hummingbird Connectivity V8.0, SQL server 2003/2005/2008
• Other Tools: Workflow, Discoverer 10g/9i/4i, XML/BI Publisher, Test director
• Java/Web Technologies: Java, Servlets, JSP, Applets, Java Beans, Swings, JDBC, HTML, XML, Java Script, BPEL
• Programming Languages: PL/SQL, Java, C

PROFESSIONAL EXPERIENCE:

Oracle Applications Implementation. Aug 2010 – Till Date
Confidential, WI
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, SQL, TOAD, Workflow,XML Publisher, OAF

• The Project involved in the implementation and customization of Release 12i Oracle Applications. The modules were Inventory, Order Management, Purchasing, AR, GL, CE, AP, FA, BOM and WIP.
• Involved in Upgrading 11i to Release 12i Oracle Application.
• The main tasks were development of interfaces, extensions, customization and development of reports as per client requirements and upgrading various forms.
• Migrated data from legacy systems into the temporary tables in Account Receivables (AR).
• Worked on Order to Cash and Procure to Pay business flows
• Involved in analyzing the user requirements, helping the Business Analysts in preparing the requirement document, designed various feature sets according to the requirements and unit tested.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate
• Involved in development of Order To Cash process (credit analysis, customer billing, cash application, collection, GL posting and reporting) and Procure To Pay process (requisition, purchase order, acceptance, goods receiving, invoice, payment and reconcile)
• Provided additional information on Sales Order and Invoices by creating Descriptive Flex Field
• Customized Reports related to PO: Purchase Order Detail Report, Purchase Summary Report by Category and Open Purchase Order Report.
• Successfully designed and implemented the Receivables Open Interface. Activities involved in creation of Loader File, importing data into staging table, perform validations on data, inserting valid data into interface table, and then using Auto Invoice Program to import the data into the Oracle base tables.
• Developed many UNIX scripts for migrating codes from one instance to other.
• Created SQL*Loader control files for moving the data from flat files to staging tables.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the legacy Customer & Invoice data Conversion from Legacy System into Oracle Account Receivables (AR) by using Customer and Auto Invoice interface.
• Auto applies Credit to Invoices (AR) Designed and implemented a unique solution to resolve manual application of invoices to credit memos using AR_RECEIPT_API_PUB.
• Worked on Auto lock Box interface program to interface Cash Receipts from EDI and Non-EDI customers.
• Modified various standard Forms according to business requirements in Account payables using Form Personalization.
• Customized and Created various forms using Forms 10g in INV, OM, AP, and GL and registered and run under custom responsibilities
• Customized and created various reports using Reports 10g and registered them under the concurrent manager.
• Involved in developing new compile scripts to compile Oracle 10g Reports.
• Developed various reports in PO and OM as of the user specifications using Discoverer 10g.
• Worked on FNDLOAD for reloading forms, menus, responsibilities.
• Worked on Administration and Desktop Edition of Oracle Discoverer. In Administration Edition, Created Business areas, Custom folders, Item classes etc. In desktop edition created Workbooks and worksheets calculated items, conditions, alternate sorts, defined drill to detail data. Loaded PLSQL functions and added existing LOV's to the fields in discoverer administrator
• Workflow customization for Order Management. Reporting for shipping distribution and order statuses which were used for month-end closing
• Involved in developing new DFF's, Value Sets and Values for supporting the reports developed Registration of customized reports through creation of concurrent executables, concurrent programs, and assigning to the request group.
• Customized Positive pay report format according to Bank standards and developed script to ftp the file to bank.
• Designed and developed Alerts and Workflows depending upon the business requirements.
• Configured Inter-Org Transfers case warranted for various scenarios. Configured Drop Ship and Back to Back order scenario's for items that needed to be shipped directly to the sale locations and the warehouse and working closely with finance on internal cost transfer through projects.
• Worked on the Journal Conversion and Order Entry Conversion.
• Worked on Interface program to load supplier invoices data files into Oracle Payables.
• Worked on tuition data to GL Interface.
• Worked on Order Import, troubleshooting various issues related to Pricing, Shipping, and items attributes setup.
• Developed Test Plans to do the Unit Testing and MD120 for the deployment.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-70) by reviewing MD-50 for all conversion and interfaces.
• Tested and Fixed bugs in existing Forms & Reports.
• Tested OM features like Order Entry, Picking, Shipping and Reports.
• Tested Month End closing reports.
• Served as Production Support addressing tickets and various Change Requests.
• Extensively interacted with Oracle metal ink support to raise SR's and their resolution.

Oracle Applications Implementation. Dec 2010 – July 2010
Confidential, IL
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, SQL, TOAD, Workflow

• The Project involved in Upgrade of 11i to Release 12i Oracle Applications. The modules were Inventory, Order Management, Purchasing, AR, GL, AP, FA and CE
• Implemented and customized various forms, reports, developed Interfaces, API, Workflows depending upon client's requirement in Release 12i Oracle Applications.
• Implemented Initiating requirements gathering and identifying potential solutions for all gaps from map-gap analysis.
• Reviewing the existing Oracle environment for process improvement and resolution of outstanding issues within the Procurement, Order Management and Inventory modules.
• Performed core configuration for OM, Shipping Execution, and Advanced Pricing and Inventory.
• Designed extension to Shipping Execution that provides the ability to disassemble, package, and ship large scale products based on bill of material structure.
• Helped facilitate UAT testing for Order to Cash process.
• Worked on Advanced Pricing Reports like accrual details report, price list report.
• Conducted knowledge transfer sessions and assisted client with compilation of training materials.
• Practiced AIM methodology in all aspects of process analysis, requirements gathering, design and implementation.
• Customization and Development of Reports and Interface Scripts, Control files and Data loading.
• Defining Concurrent Programs, Executables and Value sets.
• Converted Account Payables Suppliers, Supplier sites and Site Contacts using Supplier open Interfaces Import Programs.
• Worked on creation of various Standard and Non-Standard WIP jobs. Experienced in defining BOM's and Routing.
• Implemented Order Returns with and without credits which involved setting up transaction type, loading order using SQL loader, creating receipts to close the order.
• Experience with Invoice Creation and Payment and Payment Batch Process.
• Experience in Payables Transfer to GL Process.
• Created Order Management holds using API\'s.
• Provided support in day-to-day software issues and developments of new requirements.
• Developed Sales Order Backlog Details Report.
• Prepared technical documents (MD070) for reports, interfaces and concurrent programs.
• Involved in preparation ofMD70s, Test Cases and Migration Documents.
• Extensively interacted with Oracle metal ink support to raise SR's and their resolution.
• Provided go-live support and post go-live support.
• Developed a new workflow to notify the user when ever new item created in inventory.

Oracle Applications Implementation. Aug 2009 – Nov 2009
Confidential, IL
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, SQL, TOAD, Workflow

• Involved in Implementation and Customization process of Release 12i Oracle Applications. The modules works on AP, AR, FA, CE, Purchasing, GL, and Order Management.
• Involved with study of existing system, preparing the technical design to extract data from legacy system into Oracle Applications open interface tables.
• Developed interface program to upload the expenses thru AP invoice interface
• Worked on Suppliers (Vendors) upload thru custom package.
• Validated the data using PL/SQL and populated the Payables interface table through a concurrent program, which in turn submits a standard Payables Interface Program.
• Set up profile options, payment terms, distribution sets, hold names and release names in payables.
• Imported Invoices from legacy system to Oracle Payables tables using SQL*Loader and validate them using procedure. Worked on payables open interface to import 810 inbound.
• Prepared Technical Specification Document for Payables Open Interface.
• Developed custom reports and forms in payables.
• Designed staging tables to store legacy data pertaining to invoices and payment receipts and developed SQL*Loader scripts to upload legacy data into staging tables.
• Developed PL/SQL packages to validate legacy data pertaining to invoices and insert into AR transactions interface table. Also developed a pattern to insert freight lines and tax for freight amounts for the invoices.
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Worked on Oracle Order Import API to validate and load legacy orders from the interface tables.
• Customized the Workflow for the Order Line flow.
• Developed many reports like Pick Slip, packing Slip, Mailing Label for shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also created new reports as per client requests
• Updated Oracle Inventory item on-hand quantity from the old system

Oracle Applications Implementation. Sep 2008- Jul 2009
Confidential, Columbus IN
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, PL/SQL, TOAD

• The Project involved in the implementation, customization process of Release 12i Oracle Applications. The modules were Order Management, Purchasing, AR, GL, AP, FA, CE, and Inventory.
• Involved in Upgrade Process from 11i to R12 Oracle Applications.
• Customized various forms, reports, developed Interfaces, API, ADI, Workflows .
• Customer and Invoice conversion from Legacy System (Billing) into Oracle Account Receivables by using Customer Interface and Auto Invoice.
• Performed the Data Migration using SQL*Loader Scripts for importing legacy systems data into AR interface tables.
• Worked on Customer and Invoice Interface from Legacy System (Billing) into Oracle.
• Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
• Completed the Receivables Cycle by running the Concurrent Process to transfer transaction information from Oracle Receivables to Oracle General Ledger.
• Modified the Print Statements report and Invoice report as per the formats/layout of the client.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Imported Requisition Details (Requisition Import) using SQL*Loader and PL/SQL.
• Worked on Interfaces to import items and item data (item attribute, item number) from existing system in to Oracle Inventory through Item Import Interface.
• Worked on on-hand quantity interface.
• Developed Reports to monitor the movement of the items in Inventory.

Oracle Applications Implementation. Dec 2007- Aug2008
Confidential, Dayton-OH
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, PL/SQL, TOAD

• Involved in Implementation and customization of Release 12i Oracle Applications.
• The modules worked were Order Management, AR, AP, GL, FA, PA and CE respectively.
• Developed several Reports using FSG, used open Interface to Import Journals by GL_Interface and Budget Transfer to GL by using GL-Budget-Interface.
• Used PL/SQL for validating the data from legacy system to interface tables. Run Journal Import to load the data into Oracle application tables.
• Defined Descriptive flex fields necessary for form customizations, and distribution sets and bank related information.
• Defined payment terms, locations, periods, tolerances etc. Integrated Payment reconciliation information and Purchase Order information with AP.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Imported Requisition Details (Requisition Import) using SQL * Loader and PL/SQL.
• Modified the Reports like Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports.
• Developed SQL*Loader files to load data from legacy system into the RA_CUSTOMERS_INTERFACE_ALL tables for importing Customer data.
• Entered and processing various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information.
• Developed various reports such as Detail Payment reports with reference to Salesperson, Branch Level Transaction report and Customer's outstanding report.

Oracle Applications Implementation. Mar 2007- Oct 2007
Confidential, Elmhurst-IL
Position Title Technical Consultant
Tools Utilized Forms, Reports, Interfaces, PL/SQL, TOAD

• Involved in Implementation and Customization Process of R12 oracle Applications.
• Involved in Upgrade Process from 11i to R12 Oracle Applications.
• Worked on Financial modules like AP, AR, CE, FA, PA and GL Respectively.
• Developed PL/SQL packages to validate legacy data for unapplied receipts and used APIs to create receipts.
• Used receipt creation API's (AR_RECEIPT_API_PUB.CREATE_CASH, and AR_RECEIPT_API_PUB.CREATE_AND_APPLY) to bring in Unapplied Receipts and Conversion Receipts for Open Debit items to reduce the balance to the original amount due.
• Hands on experience in understanding Oracle supplied TRM's and well versed in understanding visual linking of the tables of TRM.
• Defined menus and attached them to user-defined forms.
• Designed and developed Journal Import interface to import journals from legacy system.
• Designed and developed solutions to automate and schedule processes that could not be automated otherwise, with Concurrent Manager.
• Designed and developed interface to extract and transfer journal information from Oracle GL to legacy system.
• Designed and developed interface to import Items into Oracle Inventory
• Designed and developed the Item Categories during the Item Import.
• Designed and developed the Order transfers between two organizations using Order import process.
• Developed the Customer addresses updates thru customer interface before order import into Oracle Order Entry.
• Customized the report called ‘Back Order Detail report', which is used to review all customer orders that have been backordered.
• Modified/Developed multiple reports using reports 2.5
• Developed open Interface to Import Journals by GL Interface and Budget Transfer to GL by using GL-Budget-Interface.
• Worked extensively on customizing existing forms appearance, validation logic, behavior and incorporating new functionalities to the existing forms. Developed New forms by using Template.fmb.

Confidential, Detroit, MI June 2005 – Dec 2006
On Line Interview Application: This application is developed to help EASi consulting services in conducting interviews online. This application uses a small knowledge base database to decide what kind of questions as well question's category should be provided for online users. It allows managers and administrator to manage the question database and user database. The result checking for the question paper is done automatically by the application as well it uses knowledge base also.

Technology and tools used: Java, Java Servlets, Jsp, HTML, Photoshop paint pro, I-planet Web Server.

• Requirement gathering analysis.
• Design and Development of the application
• Testing and deployment of the application.
• End user training.

Oracle Apps developer Apr' 04- May' 05
Confidential, Bangalore, India
Tools Utilized Oracle 9i, Toad, PL/SQL, Forms 6i, Report builder 6i, Unix Shell scripting

• Setup and installation of database software and Web logic administration task.
• Assisted in database Creation, configuring tnsnames, listener, sqlnet files.
• Assisted in creation of table spaces, tables, and indexes.
• Creation of Users, Passwords and Roles and Front-end design using Developer 2000.
• Monitoring of nightly database exports, setting up automated backup of database using custom stored procedures.
• Developed Numerous Reports and Forms for various projects
• Developed PL/SQL Procedures for execute different Business Logic in Reports and Forms.
• Extensively Developed PL/SQL Procedures and Triggers to for Business Process defined by the Analyst.
• Setting up logical/physical backups for these databases.
• Automating these backups to run using schedulers.
• Development of Shell Scripts to Kill Unwanted Unix Processes
• Developed Java program to parse xml data and then store to database

EDUCATION:

• Bachelor of Technology.