Professional summary:-

• Having 7 plus years of experience in Implementation, Customization of Oracle Applications11i, and Release12.
• Good Technical Development skills in developing RICE Components in the domain of Oracle Applications E-Business Suite EBS .
• Good exposure to Application Implementation Methodology AIM , AOL, System administration Sarbanes Oxley SOX compliance and Systems Life Cycle Methodology.
• Strong Functional and Technical knowledge in Oracle Applications Finance, Supply Chain, Distribution and Manufacturing modules like Oracle Inventory INV ,Order Management OM , Bill of Materials BOM , Advance Pricing, Work In Process WIP , Shipping Execution, Purchasing PO , Account Receivables AR , Account Payables AP , General Ledger GL , Costing, PIM Product Information Management , Order To Cash and Procure To Pay cycles.
• Extensive experience in SQL, PL/SQL, Developer 2000 Forms 6i/9i/10g, Reports6i/10g , UNIX Shell Scripts, ADI, SQL Loader, Oracle Discoverer, Workflow, XML Publisher and Oracle 8.x/9.x/10g.
• Expertise in design, development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Experienced in opening and managing Oracle Support TARs Service Requests and be adaptable to high paced and tense severity 1 issues resolution.
• Extensive experience in Trading Community Architecture TCA .
• Experienced in Unix Shell Scripting, administration and creating Command line arguments.
• Experienced in developing Functional Design documents MD050 , Technical Design documents MD070 , Conversion CV40s, 60s , Business process BP80 , Setup BR100 , Installation MD120 and participated in all aspects of software development Life Cycle.
• Experienced in Unit Testing and SIT, UAT and design issues resolutions.
• Possess good interpersonal, presentation and developmental skills with Strong analytical and problem solving approach and an excellent team player
• On-site coordination experience and worked with offshore team during knowledge transfer and development support.

Technical skills:-

• ERP: - Oracle apps R12, 11i OM, INV, PO, BOM, WIP, AP, AR, GL, P2P, O2C cycles .
• Front End tools: - Oracle J Developer 11g, 9.0.5 ,Forms6i/9i/10g,Workflow Builder2.6.3.5.
• Reporting Tools:-Oracle Discoverer 10g/4i, XML Publisher, Oracle Reports6i/10g.
• Tools:-SQL Plus, SQL Loader, Toad, SQL Developer.
• Languages: - SQL, PL/SQL, C, Java, HTML, UNIX Shell Scripting, XML.
• RDMS: - Oracle 10g/9i/8i, MS Access.
• Operating systems: - SUN Solaris, HP-UX, UNIX, Windows.

Professional Experience:-

Confidential

Position: -Oracle Applications consultant

Responsibilities:

• Good exposure on Period activities of AP, AR, and GL with auto invoice setup and configurations of Collections
• Configured and tested end-end application of AR,AP, PO modules.
• Involved in various aspect of R12 upgrade User interaction, Designing, Developing, and Documenting, creating test cases, modifying current custom RICE objects in accordance with the R12 guidelines, tuning of queries and testing of various objects.
• Developed Customer Interface in Receivables worked with various HZ tables, Interfaced data from the Flat Files into Interface tables of Oracle Receivables using SQL Loader , Validated and imported the data into AR base tables using Oracle standard Customer Import Program.
• Customized standard Packing Slip report to display the individual component serial numbers and to display the barcode for the order number.
• Did Analysis and fixed Accounting issues using Account Reconciliation Reports
• Involved in Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs
• Modified existing reports by creating additional joins. And Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program AP and populated the base tables.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Customized the existing forms with descriptive flex fields.
• Customized the PO Receipts form using custom.pll for dynamic generation of locator while receiving Purchase Orders
• Developed design and implementation documents such as MD050, MD070.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts
• Tuned PL/SQL queries for better database performance using TKPROF.
• Interacted with the end users to gather desired requirements, analyzed the requirements, and finally, developed and implemented various PL/SQL and Oracle Application routines to fulfill those requirements.

Application Modules: Oracle Apps AP,PO, AR, Advance Pricing, GL

Confidential

Position: -Oracle Applications Technical consultant.

Responsibilities:

• Authored Functional and Technical design documents for customization and/or development of various Conversions, Interfaces and Reports across GL, AP and AR modules.
• Developed a custom program in order to validate and load the data from staging tables into Vendors which is a three step process in which the 1st phase is like loading all the vendors and the 2nd phase is like loading all the vendor Sites and 3rd phase is loading all the vendor contacts with the help of Supplier, Supplier Sites Supplier Contact Conversions in AP.
• Expertise in Creating and managing customers Using TCA Trading Community Architecture in AR module.
• Customized standard Oracle Applications reports and developed custom reports in OM, WSH and INV modules using BI publisher.
• Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables from interface table to the Base Interim tables and finally to the base table.
• Extensively worked on Project Accounting PA module to set up Project WBS Templates, Tasks, and Billing Event types.
• Developed Billing events and revenue events creation program by using APIs in Oracle PA module
• Developed custom revenue calculation program to generate the revenue as per the business rule.
• Modified standard Project Billing Extensions to generate the revenue as per the client requirement.
• Developed Project Milestone exceptions report which will be more useful to the executive team and finance team for every month end close process.
• Developed direct deposit of Expenses to the internal employees by using the EFT NACHA Payment format.
• Customized standard PO print report by using XML Publisher.
• Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
• Integrated Oracle shipping with FedEx and UPS shipping software tool to populate the shipping address based on the Delivery.
• Developed GL interface for importing journals from legacy systems into GL INTERFACE table.
• Customized various Concurrent Programs and AR Aging Reports in Oracle Receivables and Oracle Payables to run independently irrespective of Responsibility using SRW packages.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Imported BOM and Routings from Legacy system into Oracle Bill of Materials BOM using the standard BOM and Routing interface program.
• Involved in attaching new BOM components to the existing BOM structure according to the rules provided by the Business.
• Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software.
• Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML/BI Publisher.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location and also created shell scripts for automatic installation of objects in various Apps environments.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Applications.
• Customization of Standard Consolidated OM/INV/PO Reports, which includes extensive PL/SQL code Procedures and Functions using Report Builder. Customized AR Manual Transaction Form using oracle from personalization as per the client requirements.
• Developed various Custom reports, Customized existing reports PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report according to the functional specifications using Reports 10g, XML/BI publisher.
• Worked on Coding Debugging, Sorting out clients time-to-time technical problems.
• Performed Unit Testing of various objects and performed defect analysis and FIX during the pre-production stage.
• Communicate with BSA's and functional people with project development status and updates.

Application Modules: Oracle Apps OM, INV, BOM, WIP, AR, AP, PO, PA, GL, HR, OTL

Confidential

Position: -Oracle Applications Technical consultant.

Responsibilities:

• Requirements gathering for the reports and custom programs development through meetings with functional team and business users.
• Developed SQL LOADER scripts for 1099 totals upload and Payment History Upload, to load data from mainframe.
• Created an Oracle Alert that triggers whenever a new responsibility is added or there is a change in existing responsibility for the user accounts.
• Worked on new enhancements to the Account Payables and Receivables modules.
• Customized Check print extract to insert PO Num and Dept No in the second line of the address if a PO BOX number is given.
• Customized Reports in OE, Inventory, BOM, WIP Modules including various Work-in Process, Discrete job listing Reports, Discrete job routing sheet.
• Involved in Customer Conversion for creating Customers, and relationships into Oracle Applications using API.
• Customization of Standard Consolidated OM/INV/PO Reports, which includes extensive PL/SQL code Procedures and Functions using Report Builder.
• Developed CHANGE IN PENDING BALANCE REPORT to display the balance amounts of all the Providers with New Pending Balances, Providers with Resolved Pending Balances, and Providers with Changed Pending Balances.
• Developed a report on Electronic funds transfer PRENOTE processing to validate the bank accounts.
• Created Supplier Hold/Release process to hold/release invoices for all the suppliers based on PACE Supplier Hold Form for a given Invoice batch.
• Designed Supplier Hold/Release Form to aid end user to apply and update the holds on suppliers.
• Customized BOM setup by defining profile options, department classes, and BOM parameters.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system
• Registered concurrent programs request sets to load BOM data into Oracle 11i tables, with prior validation and error reporting and then run Bill and Routing Interface program to import BOM data into 11i applications tables.
• Created a UNIX shell script to FTP the result of a concurrent program/report to the client server.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Used Hints, Indexes and other tuning techniques to increase the performance of the slowly running reports.
• Prepared release plan to keep track of development process and LOE specific to each item.
• Helped the other teams in setting up Oracle Developer suite.

Application Modules: Oracle Apps OM, BOM,PO, AR, Advance Pricing, GL

Confidential

Position: -Oracle Applications Technical consultant.

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.
• 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.
• Developed Inventory Item interface program to validate and Import items from legacy system to Oracle Inventory, by using the standard item import program through a custom package that validates individual records.
• Developed Pick confirm and Ship confirm Interface using oracle API's.
• Developed code to import costing data of items imported from flat files to Costing tables directly.
• 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
• Using OM Define sales order, calculate the price of items on order lines, reserve pick items from INV, ship items and send information to an AR.
• Transferred GL Account Balances from legacy system
• Responsible for designing, developing, unit testing and implementing custom extensions
• Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs
• Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems

Application Modules: Oracle Apps OM, WSH,INV, BOM, WIP, PO, AR, Advance Pricing, GL

Confidential

Position: -Oracle Applications Technical consultant.

Responsibilities:

• Worked as part of the Reports Development team.
• Designed and developed Actual Income Budget Statement, Cumulative Balance Sheet and Budget/Actual Report, Income Statement with Variance, Cumulative Balance Sheet and Income Statement Consolidated report.
• Developed various Mailing list reports and Form letter reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Created new custom reports in XML/BI publisher, upgraded Standard 6i reports to XML/BI publisher reports.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Created required shell scripts for secured FTP with error handling capability.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.

Application Modules: Oracle Apps OM, WSH,INV, BOM, WIP, PO, AR, Advance Pricing, GL