SUMMARY

• Around 7+ years of strong experience in the IT Industry on Oracle Development Tools, Oracle E - Business Suite (Oracle Applications).
• Strong working knowledge of development tools such as PL/SQL, Oracle Developer (Forms 6i/10g and Reports 6i/10g,Discoverer 10g/9i/4i), Developer 2000,Workflow Builder, XML/BI Publisher in 11i and R12 environment and have rich experience in RICEW (Reports, Interfaces, Conversions, Extensions & Workflow) components.
• Experience in design and development of Interface, Conversion, Migration and Customization programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces, APIs and UTL FILE Packages.
• Experience in writing PL/SQL database triggers, stored procedures, functions and packages (backend) to handle validation for various data loads.
• Experience in Performance tuning of the database using auto trace & tkprof.
• Experience in database loading using SQL Loader and working with Export/Import utilities.
• Very good in creating Procedures, Packages, Functions, Forms, Triggers views, records, constraints and other database objects using SQL and PL/SQL.
• Experience in Forms Personalization & Custom.pll Customization.
• Experience working on Application Object Library (AOL) and System Administration Responsibilities such as registration of concurrent programs, creations of Users, Responsibilities, Forms, Functions, Menus, Value Sets and Flex fields in Oracle Applications.
• Possesses an in depth knowledge on Business Flows of Order to Cash (O2C) and Procure to Pay (P2P).
• Experience in customizing Workflows using Workflow Builder 2.6.
• Experience in Oracle (11i,R12) Implementation, Support and upgrade with Financial and SCM modules such as Accounts Payables (AP), Accounts Receivables (AR), Purchase Orders (PO), Inventory (INV), Order Management (OM), Projects (PA), Human Resources (HR), Grants Management(GMS) General Ledger(GL), Cash Management (CM), Fixed Assets(FA), Oracle Application Framework (OAF) AOL, Workflow, XML Publisher, Alerts and System Administrator modules.
• Expertise in shell scripts.
• Experience in Business requirements gathering, Proof of Concepts, Functional setup, Test Plan preparation, Unit testing and System Integration testing.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Proficient in preparing technical documents based upon user requirement.
• Experience in supporting the production system and handling day-to-day issues.
• Strong analytical and problem solving skills and a proven ability to be an effective team player with excellent time management skills.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, AOL, BOM, WIP, WSH and System Administration.

Application Tools: Reports 6i/10g, Discoverer 4i/9i/10g, XML Publisher 5.6.3/5.6.2, Oracle Forms 6i/9i/10g, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle JDeveloper.

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS.

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, Java Script, PHP, C#, Java, HTML, XML.

Scripting Languages: Unix Shell scripts, Python, Perl.

RDBMS: Oracle 8i/9i/10g/11g, Access, SQL Server 2000, MySQL.

PROFESSIONAL EXPERIENCE

Confidential, Ramsey, NJ

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Developed SQL*Loader scripts to load data from Legacy systems into custom staging tables.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Worked extensively on the customization of existing Reports using BI/XML Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
• Developed Open Purchase Requisitions, Blanket & Contact Notifications in Purchasing Module.
• Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.
• Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script.
• Developed design and implementation documents such as MD050, MD070, MD120, TE020 (Unit Test scripts), Code Review Checklists and user-documentation.
• Extensive use of pl/sql programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
• Involved in Customer conversion from Legacy System (Billing) into Oracle Account Receivables by using Customer Interface.
• Involved in Importing the Orders 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
• Modified existing Sales order Interface and Ship confirm Interface, in order to consolidate and split the order lines.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Using Forms Personalization created a special trigger in sales order for booking according to user requirements.
• Involved in Invoice Conversion from the legacy system into Oracle Account Receivables by using Auto Invoice Interface.
• Used Journal Import in GL to import data into GL JE BATCHES, GL JE HEADERS and GL JE LINES from GL INTERFACE table in Oracle R12.
• Used SQL Loader and UTL file packages for data conversion and interfaces.
• Experienced with Data Migration with Master data (Items, Customers, Employees and Suppliers) & Open Transactions data (Invoices) for various Financials Modules.

Environment: Oracle Applications EBS R12 INV,OM,(GL, AR, AP, PO),HRMS,OAF, SQL, PL/SQL, Oracle Reports BI/XML Publisher, UNIX, SQL* Loader, TOAD, SQL*Developer.

Confidential, Renton, WA

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Developed SQL*Loader scripts to load data from Legacy systems into custom staging tables.
• Developed custom interface program to load data from external system into AP Interface tables and create AP invoices.
• Involved in the development of RICE components in Oracle Inventory, Purchasing, Order Management, Bill of Material.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid AP Invoices and for populating the AP interface tables and called the seeded import programs to populate the base tables.
• Developed Extracts in AR module and the extracted files are sent via SFTP to other systems using the UNIX Shell Script.
• Designed, Documented (prepared MD70 Technical Specification Document) and developed Conversion process for Customers (as TCA Architecture), Suppliers, Supplier Sites, Bank Branches, Bank Accounts, Open Purchase Orders, and Reports.
• Created Functions, triggers, views, indexes as per the client requirements.
• Developed Inventory Interface program for sub inventory transfer and miscellanies issues.
• Used Pricing APIs to attach pricing attributes that is derived to the Orders imported from legacy systems.
• Developed IMS Packages to do DML operations on Custom tables for BOM and Pricing Modules.
• Loaded the data into the MTL SYSTEM ITEMS-INTERFACE and then the standard item import was executed to load data into the Oracle Inventory.
• Followed (MD50) functional documents and written the technical (MD70) specifications for Interfaces and Reports.
• Worked with multi-org and multi-currency orders, set up value sets in Order Management (OM).
• Developed PL/SQL packages (outbound interfaces) to extract information from Oracle Applications base tables to create Flat files.
• Involved in troubleshooting errors, fixing the bugs and fulfilled the new business requirements.
• Created UNIX Shell Scripts for automating programs, data loading and interface process in Custom and Oracle Applications.
• Interacted with Business Leads to resolve any issues during the production, development and enhancement phases.
• Developed multiple XML/BI Publisher reports on E-Business Tax like Sales Exception, Purchase exception reports to calculate tax as per the client requirements.
• Involved in setups for Conversion rate based on tax codes for various countries as per the client requirements.
• Worked on Auto Lockbox Open Interface for automatic processing of receipts in AR module of Apps based on electronic bank statement data.
• Designed bank statement reconciliation with Accounts Payable and Accounts Receivable transaction as part of Cash Management Implementation.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.

Environment: Oracle Applications EBS R12 INV,OM, BOM, (GL, AR, AP, PO), EBS-Tax, SQL, PL/SQL, Oracle Reports BI/XML Publisher, UNIX, SQL* Loader, TOAD, SQL*Developer.

Confidential, Las Vegas, NV

Oracle Technical Consultant

Responsibilities:

• Experience in total Order to Cash and Procure to Pay life cycles.
• Worked on Performance Tuning of Custom PL/SQL Packages and reports to increase the performance of custom objects.
• 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.
• Imported BOM’s and Routings from Legacy system into Oracle Bill of Materials using the standard BOM and Routing interface program.
• Modified standard Project Billing Extensions to generate the revenue as per the client requirement.
• Involved in setup of AR, HZ profile options and Tax Location Flexfield and defined customer profiles classes and lookups for TCA Customer setup.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Involved in Customer Conversion for creating Customers, and relationships into Oracle Applications using API like HZ PARTY V2PUB,HZ RELATIONSHIP V2PUB,HZ CUSTOMER PROFILE V2PUB, HZ CLASSIFICATION V2PUB, HZ LOCATION V2PUB and HZ CUST ACCOUNT V2PUB.
• Developed direct deposit of Expenses to the internal employees by using the EFT NACHA Payment format.
• 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 Confidential shipping software tool to populate the shipping address based on the Delivery.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Worked on rebuilding the Interfaces and Customizations on Account Payables and Purchasing Modules.
• Developed Custom Purchase Order Display Report (PO) as per the client requirement.
• Worked on Sales Order conversion to import the orders by using API in Order Management
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Applications.
• Customized standard forms with CUSTOM.PLL library to create new functionality.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• 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.
• Created and customized output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.

Environment: Oracle Applications 11.5.10/R12, SCM, (PA, AR, AP, PO, OM, FA, INV, BOM), Oracle RDBMS 9i, Reports 6i, Forms 6i, SQL* Loader, Discoverer, PL/SQL, Workflow builder 2.6, BI/XML publisher, TOAD, Windows XP.

Confidential, Upper Saddle River, NJ

Oracle Technical Consultant

Responsibilities:

• Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved open issues with the existing custom reports and also involved in the development of new ones.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Performed Extensive Application tuning for Order to Cash (O2C) Business process.
• Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version R12.
• Developed reports in Payables to send a Notification to AP/Buyer/Requestor of Invoices on Hold.
• Developed Open Purchase Requisitions, Blanket & Contact Notifications in Purchasing Module.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Developed AP Invoice Interface to upload items into the Oracle Payables.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
• Customized various Concurrent Programs and AR Aging Reports in Oracle Receivables and Oracle Payables to run independently irrespective of Responsibility using SRW packages.
• Involved in migrating the data into Oracle Apps from the Excel Sheets using open interface / API, Oracle utilities and third party tools (Data Loader).
• Developed Pick confirm and Ship confirm Interface using oracle API’s.
• Developed several Procedures and Database Triggers as per Business requirement.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle Applications EBS 11.5.10, (GL, AR, AP), PO,WSH, INV, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, P4V, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential, NC

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Worked on GL Conversion to extract data from legacy system to GL base tables.
• Developed Custom Packages, Procedures for validating the Summary balances and Detail Transactions from the legacy system, imported them into interface table and submitted the Journal Import program to populate base tables.
• 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.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from legacy system to Oracle Order Management by using the API
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Customized the GL Account Analysis Report based on the Clients requirement.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version 11.5.8 to 11.5.10.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Oracle Reports 6i .
• Developed PL/SQL procedures, functions and packages.
• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Created the materialized views and also created the partitioning tables.
• Created several PL/SQL packages, stored procedures and functions.
• Created various lookups, Value sets, user defined tables.

Environment: Oracle Applications 11i, OM, PO, INV, GL, Oracle 9i Database, UNIX, Oracle Reports 6i, PL/SQL.

Confidential, PA

Oracle Technical Consultant

Responsibilities:

• Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Client Requirements.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Performed Setup steps, defined various Key Flex fields and Descriptive Flex fields for Financial Modules AP, AR, GL.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into OM interface tables.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Developed a Customized XML/BI Publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the inventory module.
• Developed SQL*Loader scripts to load data into staging tables.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Customized a new workflow process in Order Entry to keep track of the Sales Order and sending the notifications correspondingly.
• Worked on Order import using Order Management OE ORDER PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data and populated the data into base tables
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.
• Followed (MD50) functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications R12, GL, AR, AP, PO, INV, FA, OM, Shipping, iExpenses, Oracle 10g, Forms 6i, Reports 6i, Discoverer 10g, Workflow, XML/BI Publisher, TOAD and Forms Data Loader.

Confidential

Oracle Apps Developer/Technical Consultant

Responsibilities:

• Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Inventory (INV) and Receivables (AR).
• Imported Requisitions from legacy system to Purchasing through Requisition Open Interface.
• Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.
• Created new business areas, workbooks according to user requirements and also involved in creating ad-hoc reports using Discoverer 4i.
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
• Involved in Open Transaction Interface to import transactions from legacy system to Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Developed custom interface program to load inventory (INV) Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed Alerts in Inventory Modules.
• Personalized AR Customer Calls Form restricted the Last Name field in the form to accept the values only from the LOV’s.
• Customized Reports in PO, AR and AP like Printed Purchase Order Report, Aging 4 Bucket Report etc using Reports 6i.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.

Environment: Oracle Applications 11.5.10, PO, INV, AR, Oracle 8i, Forms 6i, Reports 6i.