SUMMARY

• Over 8 plus years of experience in Implementation, Customization and supporting R12 and Oracle Applications 11i systems.
• Strong Functional and Technical knowledge in Oracle Applications Finance, Supply Chain, Distribution and Manufacturing modules like Oracle Inventory(INV), Order Management(OM), Purchasing (PO), Account Receivables(AR), Account Payables(AP), General Ledger(GL), Costing, Advance Pricing, Work In Process(WIP),Bills Of Materials(BOM), Shipping (WSH) and AOL.
• Expertise in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and extensions/Customization) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader in the domain of Oracle Applications.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Solid Knowledge and understanding of AOL/FND architecture and Applications
• Experience in Implementing Trading Community Architecture (TCA) to support complex trading communities.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using Oracle open interfaces and Oracle Public API’s.
• Extensive experience in developing and customizing numerous Forms using Oracle Forms 10g/6i/4.5, Reports using Reports 10g/9i/6i implementing bind and lexical parameters and also generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s.
• Experienced in Unit Testing and SIT, UAT and design issues resolutions.
• Expertise in writing Loader scripts. PL/SQL Packages, PL/SQL Procedures, Functions, Triggers, Packages and Advanced PL/SQL (PL/SQL tables, Record type, Bulk Collects, Bulk Binds) and SQL 
• Expertized in Performance Tuning using SQL Trace, and Explain Plan.
• Excellent working knowledge in UNIX shell scripting.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 MD120, Code Review Checklists and user - documentation documents.
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 AP, AR, GL, CM, iExpenses, OM, PO, PA,INV

Databases: Oracle RDBMS, Oracle 8i /9i/10g/11g, MS SQL Server 2000

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, PERL,UNIX Shell Scripting

Web Technologies: HTML, JAVASCRIPT, ASP and PHP

Tools: Forms 6i/9i/10g, Reports 6i/10g, Toad, SQL Navigator, SQL*Plus, SQL*Load, JDeveloper and XML Publisher 5.6.3/5.6.2 ,Oracle Forms 6i/9i/10g.

Operating System: UNIX, Linux and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential, Greenville, SC

Oracle Applications Techno Functional consultant

Responsibilities:

• Worked with business users on gathering requirements, designing, and development of the Order to Cash and Procure to Pay cycle as per their business requirements during the R12 upgrade.
• Setup Descriptive Flex Fields, Value sets for various components in OM, Inventory modules.
• Involved in Order Management setups for transaction types, document sequencing, profile options, defaulting rules, and processing constraints.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program in Oracle Apps EBS R12.
• Involved in Open Sales Order conversion based on client specifications.
• Worked on Customer, Sites, Contacts, Customer Profiles into Oracle AR from the JD Edwards as part of the R12 upgrade.
• Developed AR Auto Invoice package for validating the data before importing data into RA interface tables and used the Auto Invoice to import the customer invoices.
• Developed interface to transfer complete AR Customer info and the AR invoice details from Oracle AR to into Get Paid 8.0 using Unix script and SQL scripts.
• Worked setting up the DFF’s at the Oracle AR Customer account level and at the Invoice level for capturing legacy attributes information.
• Developed a custom XML/BI Publisher report to daily list all the rejected invoices based on the interface table that will provide all the details of the AR Invoice and the reason for the rejection of the Invoice.
• Converted Suppliers, Supplier sites, Supplier contacts using the Oracle Standard interface tables as part of the Oracle Accounts Payables.
• Responsible for converting the Open Purchase Orders using Import Standard Purchase Orders from the JD Edwards into Oracle Purchasing(PO).
• Developed Unix Scripts for archiving and ftp’ing the outbound files to 3rd party servers.
• Architected and created the Unix directory structure for various systems, which integrate with the Oracle Apps.
• Worked on modifying the logic for the Views, PL/SQL packages to support MOAC as per the business requirements.
• Developed a Common package, which contains functions and procedures to provide solutions in handling the flex values, value sets and other requirements for the Multi Org enabled code.
• Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUEST.
• Created Registration scripts and FND LOAD scripts for the migration of the objects between multiple instances.
• Worked on script to assigning required profiles to all the custom responsibilities to support the MOAC.
• Developed Credit Packing Slip Details Report and Open Item Details Report, Sub-Inventory Mismatch Report using Oracle BI Publisher.
• Used AOL and System Administrator modules for registering the developed and customized reports and conversion programs.
• Performed System Administrator functions such as defining Users, functions, responsibilities, concurrent programs, flex fields, Value Sets, Profile Options, registering forms in AOL and the post clone tasks.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Responsible for Fixing Performance issues using the Explain Plan, TK PROF, SQL Analyzer and SQLT.

Environment: Oracle Applications EBS - R12, Oracle 11g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher

Confidential, Charlotte, NC

Oracle Applications Techno Functional consultant

Responsibilities:

• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into OM using Order Import Concurrent Program
• Worked on developing Multi Org enabled Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• Design and Developed Order Import Interface in Order Management.
• Created a custom program to create and pack container in Oracle Order Management
• Involved in Conversion Programs for Inventory Items, Inventory Transactions, Purchase Orders and Sales Orders.
• Worked on INV in defining a New Item in inventory, increasing the On-Hand Quantity and was involved in defining the Price List.
• Developed SQL Loader files to load data from legacy system into the RA CUSTOMERS INTERFACE ALL tables for importing Customer data.
• Developed a shell script for download/upload the file from FTP server and to encrypt and decrypt based on the transfer.
• Developed an Outbound interface program to transfer the data from Oracle PO base tables into the flat file.
• Worked on Order to Cash Process. Worked on creation and booking the order and on the Workflow Background Process to transfer the data to receivables.
• Worked on the Purchase Order Inbound EDI Interface (850/Orders).
• Developed New Forms and customizations in standard forms based on user requirements using Oracle Form Builder and OA Frame work in Manufacturing and distribution Modules.
• Developed Payables Open Interface Import Program to load invoices from multiple sources like legacy invoices into Accounts Payables in a periodic basis and designed a report using XML/BI Publisher.
• Developed XML Publisher reports in OM and INV such as Sales Tracking Report, On hand Quantity tracker, Move Order Reconcile Report, Sale Order Reconcile, Open purchase Order and Logistics/Sub Inventory status reports.
• Developed new reports in OM and INV such as Sales Tracking Report, On hand Quantity tracker, Move Order Reconcile Report, Sale Order Reconcile, Open purchase Order and Logistics/Sub Inventory status reports.
• Worked on modifying the logic for the Views, PL/SQL packages to support MOAC as per the business requirements.
• Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUEST.
• Setup Descriptive Flex Fields, Value sets for various components in AR, OM, Inventory modules.
• Developed a Common Utils package, which contains functions and procedures to provide solutions in handling the flex values, value sets and other requirements for the Multi Org enabled code.
• Personalized a form to validate quantity entered in Sales Order lines for a specific inventory item with respect to quantity available in inventory.
• Worked on AR customer conversion, AR invoices conversion, GL trial balance report customization
• Involved in Customization of Cancelled Orders Report, Orders Summary Report.
• Created Registration scripts and FND LOAD scripts for the migration of the objects between multiple instances.
• Worked on script to assigning required profiles to all the custom responsibilities to support the MOAC.
• Developed Credit Packing Slip Details Report and Open Item Details Report, Sub-Inventory Mismatch Report using Oracle BI Publisher.
• Developed new reports in OM and INV such as Sales Tracking Report, On hand Quantity tracker, Move Order Reconcile Report, Sale Order Reconcile, Open purchase Order and Logistics/Sub Inventory status reports.
• Built custom reports using Report 6i to solve the client’s reporting needs.
• Used AOL and System Administrator modules for registering the developed and customized reports and conversion programs

Environment: Oracle Applications EBS - R12, Oracle 11g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher

Confidential, Atlanta, GA

Oracle Applications Techno Functional consultant

Responsibilities:

• As part of the R12 Re implementation, implemented various transaction data conversions like Payables Open Interface, AR Auto Invoice interface programs.
• Design and Developed Item Category and Inventory Material Transaction Interface.
• Developed Auto Invoice Interface Program to import Customer Invoices, credit memos, and debit memos from the legacy systems in to AR.
• Developed interface to transfer the details of the new sales order that are created in Oracle Order Management to the 3PL warehouse in order to ship the goods from the warehouse.
• Performed Auto Lock Box set ups based on the BR100 documents.
• Created interface to import the journals from the 3rd party vendor called Blackline and used the SFTP method get the file from the Blackline server and decrypt the file once it is loaded into the client side.
• Troubleshoot all the functional setups if any interface or any production issue in BOM, WIP, Inventory and ASCP.
• Worked on Inventory transactions interface to load transactions from Warehouse every 2 hours to Oracle from 3rd party system.
• Developed EDI Gateways to read the incoming file and process it.
• Involved in creation of customized Payroll Register, Earnings and Deductions Register and Payment Register.
• Build Budget Position Funds Detail Page from scratch to allocate funds to different assignments.
• Developed one-time PL-SQL programs to convert Recruitment data from various Legacy systems, which in some cases included spreadsheets. Also, created audit scripts to assist with data reconciliation.
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL SYSTEM ITEMS table.
• 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.
• Worked on the personalization of the custom forms Sales Order to raise error messages, clear off a DFF value when the sales order is created thru copy method and used FND LOAD for the moving the personalization between other instances.
• Created system alerts to notify the users and IT regarding the unexpected errors and activities in the system.
• Modified the Order Flow-Generic workflow, to send notifications to the Sales Representative whenever a particular type of order is booked.
• Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management
• Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher.
• Developed custom XML/BI publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a Organization in the Inventory module.
• Updated various documents like Systems Requirements document (SRD) by interacting with the business and documenting the requirements and Solution Design Document (SDD), Technical Design document (TDD) to document the design and development details following the TTM (Time To Market) methodology.
• Performed fine-tuning the complex SQL queries using EXPLAN PLAN, TKPROF utilities.
• Well versed with creating Service Requests in Meta link and get the oracle support on severity basis.

Environment: Oracle Applications EBS - 11i, Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher

Confidential, Minneapolis, MN

Oracle Applications Techno Functional consultant

Responsibilities:

• Involved in development process of Currency conversion program, for the OIC (Oracle Incentives and Commissions) module to change the base currency and add different send and receive currency to all the agents in a specific country to support the Dodd-Frank rules and created a form to display and correct the errors in the conversion process.
• Involved in AR Receipt conversion to convert the entire customer balances in the Legacy System-Power Transact into Oracle AR.
• Used Import Standard Purchase Orders and Receiving Transaction Process interface programs to create purchase orders and receipts in Oracle Purchasing.
• Worked on the implementation of the O2C (Order to Cash) .
• Involved in performance tuning using the complex SQL queries using EXPLAN PLAN, TKPROF utilities and tuned the cursors and SQL’s of the core payment reports in the AR and AP modules to reduce the run time, which are used by business to make daily high critical payments.
• Created and customized different oracle XML publisher reports and RDF reports (AR, CE, AP, GL, and INV) like SLA Journal Entries summary report, Receivable Activities report and Inventory Items report etc. to help business and marketing teams to understand the logistics and adjustments to be done.
• Created custom code for delivering the reports to the users thru email when they are run on CA automation system.
• Involved in converting all the packages, reports and forms to support Multi Org Access as part of expansion of the business to have Multiple Operating Units.
• Worked on creating responsibilities, security profiles menus and menu exclusions to support different business requirements which include the supporting of the Multi Org Access.
• Designed MD 70’s (Technical Designs) as per the MD 50’s.
• Performed various AOL and system Administrator activities depending on the requirement.
• Well versed with creating Service Requests in Meta link and get the oracle support on severity basis.
• Created shell scripts and one time SQL scripts to support the business requirements.
• Communicate the changes made and issues resolved to projects managers and business system analyst on timely basis.
• Responding to Production support tickets on time and fixing the issues and show stoppers.
• Lead off-shore team in India.

Environment: Oracle Applications R12, Oracle 10g, Forms 10g, BI Publisher 10.1.3, SQL*Loader, TOAD, XML Publisher, UNIX, PLSQL, SQL Plus

Confidential, Memphis, TN

Oracle Applications Techno Functional consultant

Responsibilities:

• 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
• Discussed with users to gather Business Requirements and to develop a model to implement the system with ‘Procure to Pay’ and ‘Order to Cash’ cycles.
• Implemented and tested Purchase Order Interface and Payables Open Interface to import legacy systems data to create Purchase orders and AP invoices.
• Imported BOM’s and Routings from legacy system into oracle Bill Of Materials(BOM) using standard BOM and Routing Interface program.
• 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.
• Developed Sales Order interface in Order Management (OM) to import Sales Orders from the Legacy System using SQL  Loader.
• Created SOFE screen (custom sales order entry) using oracle forms for creating Sales Orders and developed custom interface to Order Management.
• Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard Item Import program through a custom package that validates individual records.
• Involved in Customer conversion from Legacy System (Billing) into Oracle Account Receivables by using Customer Interface.
• Developed Item conversion program for assigning Items to Item category set and Categories
• Involved in Invoice Conversion from the legacy system into Oracle Account Receivables by using Auto Invoice Interface.
• Modified the Order Flow-Generic workflow, to send notifications to the Sales Representative whenever a particular type of order is booked.
• Modified existing Sales order Interface and Ship confirm Interface, in order to consolidate and split the order lines.
• Developed PL/SQL program to be used to create Ship Confirm with delivery details using shipping API
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances
• Worked with FND PROGRAM package to Register, Delete the Concurrent Programs from the backend.
• Used Forms Personalization created a special trigger in sales order for booking according to user requirements.
• Customized Pick release and ship confirm form and other existing forms to add search criteria on descriptive flex fields.
• Developed reports in Oracle inventory (INV) for comparison of available and on-hand quantities in various lots and sub-lots using XML Publisher to display in PDF format.
• Developed Pricing, Inventory, Shipping & Order related Reports like: Advance Back Order Report, Package Recognition Report and Product Validation Report using XML Publisher.
• Developed UNIX Shell scripts to run the interface program and to archive the data and Performed the uploading and downloading flat files from UNIX server using FTP.
• Developed design and implementation documents such as MD050, MD070, MD120, Code Review Checklists and user-documentation.

Environment: Oracle Applications R12, Oracle 10g, Forms 10g, BI Publisher 10.1.3, SQL*Loader, TOAD and UNIX XML Publisher, UNIX, PLSQL

Confidential, Memphis, TN

Oracle Applications Techno Functional consultant

Responsibilities:

• 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.
• Developed PL/SQL scripts to load order data from external system to Supply Chain Module( OM) interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL)
• 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.
• Created loader file that is used in porting invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL Loader and then using Payables Open Interface to import the data into the actual tables.
• Involved in designing of Conversion/Interface Implementation Strategy for Accounts Payables and Accounts Receivables.
• Used Import Standard Purchase Orders and Receiving Transaction Process interface programs to create purchase orders and receipts in Oracle Purchasing
• 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
• Involved in processing of Bank Receipts using Auto Lockbox.
• Involved in Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Customized the existing forms with descriptive flex fields.
• Converted Order Detail Report, Credit Order Summary Report and Orders by Item Report in Order management from reports 6i to BI publisher
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in Client required format.

Environment: Oracle Applications R12,AP,AR,CM,iExpenses,OM Oracle 10g, Forms 6i/10g, Reports 6i, XML/BI Publisher 10.1.3, SQL*Loader, TOAD and UNIX XML Publisher, UNIX, PLSQL, SQL Plus.

Confidential, Rockville, MD

Oracle Applications Techno Functional consultant

Responsibilities:

• Performed Extensive Application tuning for Order to Cash (O2C) Business process.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR 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 extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
• Troubleshooting of the Order Management (OM) and Inventory (INV) modules within Oracle Applications.
• 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.
• Modified Privileges for Users using System Administration responsibility depending upon various Organizations.
• Imported data from XML and flat files to load them into Data Warehouse.
• Developed Cash requirements report in Account Payables (AP) using Report 10g.
• Developed various Mailing list reports and Form letter reports using Reports 10g.
• Developed new reports such as Cancelled Sales Orders, On-hand Details, Material Adjustments using Reports 6i and XML/BI Publisher
• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, Collections, Materialized Views.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts

Environment: Oracle Applications - R12 (AR,AP,PO,GL,FA,PA,OM,INV), Oracle 10g, Discoverer 9i/10g, Reports 10g, XML/BI Publisher, Forms 10g, Toad, SQL*PLUS, UNIX.

Confidential, Oakland, California

Oracle Applications Techno Functional consultant

Responsibilities:

• Involved in customer conversion from legacy system into Oracle Accounts Receivable (AR) by using Customer Interface.
• Design and development of AP suppliers, AP invoices conversion programs using AP suppliers open interface and AP invoices open interface.
• Involved in Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• Worked on the Auto Invoice interface to load legacy invoices into AR.
• Scheduled Payment Process and created Electronic payments using Payments Manager in Account Payables (AP).
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Created Trigger on AR PAYMENTS INTERFACE ALL to generate receipt number automatically.
• 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 Materialized views in an external system on Purchase order data, Requisition data and Vendor data in Oracle Payables.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Designed and developed Forms using Forms 10g as per the business requirements, provided Zoom functionality using CUSTOM.pll.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher, Conversion of Oracle Reports to XML/BI Publisher Reports like AP Check Printing Report and AR Invoice Report.
• Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.
• Customized Invoice Aging Report in Oracle Payables.
• Developed Cash requirements report in Account Payables (AP), various Mailing list reports and Form letter reports using Report 10g.
• Customized standard Oracle reports such as Min-Max Planning, AR aging, Expected PO Receipts Reports and modified the Print Statements report and Invoice report as per the formats/layout of the client using Reports 10g.
• Tuned PL/SQL queries for better database performance using Explain Plan.

Environment: Oracle Applications (General Ledger, Accounts Payables, Account Receivables, Fixed Assets), Oracle 9i, XML Publisher, Reports 6i/10g, Forms 6i, Windows 2000/NT, SQL*Plus, SQL*Loader, TOAD, PL/SQL, UNIX.

Confidential

Oracle Applications Techno Functional 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.
• 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.
• Personalized AR Customer Calls Form restricted the Last Name field in the form to accept the values only from the LOV’s.
• Created new reports such as Incoming Sales and Order Report and Shipping Detail Report using Reports and 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.
• Developed Alerts in Inventory Modules.

Environment: Oracle Financials 11.5.10, Oracle 8i, Forms 6i, Reports 6i