SUMMARY

• Overall experience of 7 years in all phases of design, development and implementation of Oracle Applications
• Strong Technical Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e - business Suite R11i the main concentration being in the modules: Oracle Account Payables (AP), Oracle IExpenses (IExp), Oracle General ledger(GL), Oracle Receivables (AR), Oracle Iprocurement (Iproc), Oracle Purchasing (PO), Order Management (OM), Application Object Library (AOL), System Administration
• Technical (technical lead, developer, etc.) activities: interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support
• Strong in Design and development of Conversions and Interfaces in Oracle Applications
• Comprehensive understanding of the Oracle Applications Implementations
• Strong in PL/SQL (stored procedures, triggers, functions etc.) for implementing, testing the complex backend data operations on oracle and SQL Loader
• Expertise in Customization and Implementation of Oracle Financials R12/R11i/10.x (GL, AP, AR, FA, PO, OM, INV, BOM, EDI Gateway, iExpenses, iProcurement)
• Forms, Reports, Workflow, Discoverer, XML Publisher, BI Publisher
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Experience in Order to Cash (O2C), Procure to Pay (P2P) business flows
• Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance
• Extensively worked on Oracle Discoverer (Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL)
• Expertise in creating AIM Documents - MD 050, MD 070, MD 120 and CV 040 documents, coordinating UAT and cutover activities. Worked with Oracle Support - creating TAR’s - on many projects
• Versatile team player with excellent communication, interpersonal and mentoring skills with strong leadership qualities

TECHNICAL SKILLS

Oracle Applications: R12, R11i, R11, R10.5.7

Application Modules: Account Payables (AP), Accounts Receivables (AR), Purchasing (PO), General Ledger (GL), Order Management (OM), Inventory (INV), Warehouse Management (WMS), Advanced Pricing, Oracle Procurement, Install Base (CSI/CSE), Service Contracts / Contracts Core (OKS/OKC), Trading Community Architecture (TCA/HZ), Sales Online, Field Service (CSF), Project Accounting (PA), Advanced Pricing (QP), Bill of Materials (BOM), Work in Process (WIP), Configurator, Electronic Commerce/EDI Gateway (EC), Approvals Management (AME)

Other Components: Workflow/Workflow Builder, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flex fields System Implementations New Module Installations, Upgrades, Customizations and Extensions; Interfaces and Data Conversion

Oracle Tools / Components: SQL*Plus, SQL*Loader, Oracle Forms 10g, 9i, 6i, Oracle Reports 10g, 9i, 6i, Oracle Discoverer, JDeveloper, OA Framework, Forms Personalization, Workflow Builder, BPEL, Forms Personalization, Business Intelligence (OBIEE), XML Publisher, Noetix Misc Toad, SQL Navigator, HP ITG (Mercury), CVS, PVCS, MS Access, Remedy, CMMI

Languages: SQL & PL/SQL, Korn/C/Bourne UNIX shell scripts, JavaScript, VB

PROFESSIONAL EXPERIENCE

Confidential

Techno Functional Consultant

Responsibilities:

• Requirements gathering for the reports and custom program development through meetings with functional team and business users
• Developed Interface of Sales Orders Import in OM after actively participating in the preparation of the conversion mapping documents
• Developed various interfaces, both inbound and outbound, which are run on periodic basis
• Loaded the invoice information from legacy system into Oracle AR Module
• Involved in customization of several standard reports to serve important business processes very specific to the client. Reports included 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 using Reports 10g
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• 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.
• Scheduled various concurrent programs and reports to run on a specified time daily without interfacing other standard programs using System Admin Responsibilities.
• Created an Oracle Alert that triggers whenever a new responsibility is added or there is a change in existing responsibility for the user accounts.
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL SYSTEM ITEMS table.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Establish data conversion routines and executed scripts to convert GL, AP and FA data from legacy systems
• Involved in the iExpense implementation, designing and performing a major modification to the daily inbound interface to handle multiple files on the same day. Also generated scripts to encrypt and archive the inbound data file which consists of confidential information.
• Prepared Mass Additions posting report, purge report, additions status report and unposted Mass additions report in Fixed Assets FA module .Established new procedures for AP, PO, GL and FA modules.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables and developed asset interface
• Debugged the custom interface between Project Accounting PA and Receivables AR.
• Develop a Program for the Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in Receivables AR.
• Customized the standard Inventory INV In-Transit Value Report using Reports 10g/XML/BI publisher
• Developed Supplier Audit Report and Bank Audit Report in Accounts Payable (AP) and Rental Order Report in Order Management (OM) using XML/BI Publisher.
• Created business areas, user views, custom folders and joins for reporting using Oracle Discoverer 9i in Administrative edition as per the user requirements.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40).

Environment: Oracle ApplicationsR12 (General ledger (GL), Fixed Assets (FA),Account Receivables (AR), Account Payables (AP), Purchasing (PO),Project Accounting ( PA), Inventory(INV), Order Management(OM)), Oracle 11g, Forms 10g,Reports 10g, Discoverer 9i, XML/BI Publisher, SQL*Loader, SQL*Plus, TOAD, WinNT/2000 and UNIX.

Confidential, Atlanta, GA

EBS R12 Integration Specialist

Responsibilities:

• Upgrade Assessment of current business process in R11 (GL, AP, AR and PO)
• Impact analysis in current business process due upgrade changes/enhancements.
• Business process mapping with all standard and customized modules.
• Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Analyze and test integration with 3rd Parties and legacy systems.
• Full CRP1, CRP2 testing cycles, with issue trackers and SME’s sign of. Full UAT testing Cycles, with issue trackers and SME’s sign of.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
• Post go-live support
• Worked on GL Balances Inbound Interface - a monthly interface, using first week of that month; GL Outbound Interface (BHAG, Hyperion) - daily interface and it fills the abase cube (DW system); GL Outbound Interface (Transaction) - monthly interface, used before closing the period.
• Designed and developed GL Daily Rates Interface - a daily interface between Oracle and Routers system.
• Designed and Developed Supplier Conversion, Open Invoices Conversion, Closed Invoices Conversion programs using the MOAC responsibility.
• Worked on AP P-Card Invoice Import - a monthly interface that gets the file from P-Card and also from Oracle (project related data). Merges the files and loads them through AP Invoice Interface. Delivered AP Expense Amex Credit Card Interface - daily; Cash management bank statement interface - daily.
• Mapped legacy data fields to Source System Data and data cleansing.
• Designed and developed Positive Pay File for negotiable and voided checks. Generated the output in fixed length XML template using BI Publisher.
• Architected inbound AR Invoice interface. Mapped homegrown legacy data fields to Source System.
• Designed and developed Invoice Print New invoices and Invoice Print Selected invoices. Generated the output in custom XML template using BI Publisher.
• Delivered Employee, Employee Assignment, Job, Address, Contractors conversion and ongoing interface from PeopleSoft to Oracle HR.
• Mapped PeopleSoft HRMS data fields to Oracle R12 HRMS; Data Mask of Employee SSN using Form Personalization.
• Designed and developed custom program to update bank information for the employees who got converted as Suppliers during the process of submitting the expense reports.
• Worked on inbound interface from Hyperion to Oracle Project Costing to create Projects, Budget and Class Codes for Classification using the predefined templates. Designed and developed an outbound interface from Oracle Project costing to Hyperion by extracting the actual expenditure spent on all projects, which have a capital budget number.
• Designed and developed Construction in Progress (CIP) report and Project Summary Report using BI Publisher.
• Workflow: Account Generator modification, supplier provisioning, imaging & expense workflow process to place the expense report on hold and release; Project costing approval and timecard approval modification.
• XML Reports: Payments (ACH, Positive Pay, Check Printing), Send Remittance Advice, PO Print (Standard, Blanket & Agreement). AR Invoice, Spend Data, Over/Under 40 Hours Timecard, Auto-Approved Timecard, Supplier & Journal Audit reports.
• Created OAF page forms for GL mapping and supplier inquiry.
• Designed and developed AP expense imaging integration using AXF and BPEL process (Stellant).

Confidential, CA

Oracle Apps Technical Consultant

Responsibilities:

• Worked extensively on Auto Lock Box to bring data from external sources into Receivables AR base tables.
• Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing PO 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.
• Created Custom responsibilities: GL, AR, OM, INV and moved all orders booked and status not closed to the new responsibilities for further process.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventory modules.
• 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.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.
• Worked on Conversions of employees from Legacy System to Oracle HR.
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location.
• Developed Interface for the Standard Items in INVENTORY generating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables
• Developed a Discoverer Report to capture the sales order line details for a category of items that were exchanged Developed AP Two Way Match report using Discoverer.
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Adding and Capitalizing a CIP asset in Fixed Assets FA module.
• Designed, developed and loaded data using FA MASS ADDITIONS Interface from Legacy systems.
• Developed interfaces to import payable invoices and iExpenses related invoices.
• Responsible for design, development of reports across various modules using XML/BI Publisher and Discoverer. Customized the Master/Detail budget report in GL and the Discounts Available
• Customized existing Oracle Reports in Inventory Module (INV), Pricing using Reports 10g.
• Developed several new forms using TEMPLATE.fmb & customized standard forms through Custom.pll.
• Developed forms using ZOOM Functionality that pops up appropriate form based on the item context. Modified custom.pll to activate zoom.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL *Loader.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Personalized custom self-services forms using OA Framework.

Environment: Oracle Applications R12 ( General ledger (GL), Account Receivables (AR), Account Payables (AP), Purchasing (PO), Inventory(INV), Fixed Assets ( FA ), BOM, Order Management(OM), HR, Iexpenses), Advanced Pricing, Oracle 10g, Reports 10g, Forms 10g Discoverer 10g, XML Publisher, PL/SQL, SQL*Loader, TOAD, UNIX, Workflow Builder.

Confidential, Columbus, OH

Techno Functional Consultant

Responsibilities:

• Designed and developed conversion to load on hand quantities, lots and locators into inventory INV using oracle on-hand and Lots interface.
• Developed Item Master sync out-bound interface to maintain synchronization between item and its attributes in oracle and the third party WCS system.
• Involved in the Functional setup of Order Management (OM), Inventory (INV) modules.
• Involved in importing Sales order data into Oracle Application base tables. Wrote PL/SQL procedure to validate data and load into interface tables and using order import inserted orders into the base tables.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executables, registering applications.
• Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance, and ECO Report. And changed the output format to XML and created new templates for XML Publisher to display in pdf or Excel Format.
• Generated Order submission summary and Detail reports by email Report using BI Publisher.
• Conversion of Oracle Discoverer Reports to BI Publisher Reports like 5 Year Sales Order Report, Gross Sales Analysis Report and Sales by Category Report.
• Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).
• Involved in developing open interface to transfer the data from Oracle Payables to base tables of Fixed Assets (FA).
• Serialization/De-serialization of the XML document at the database level.
• Designed and developed extension to create move orders using oracle seeded API.
• Customized existing forms appearance and incorporated new functionalities. Developed new forms using Template.fmb (AU TOP/forms/US).
• Imported BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temporary table using the SQL * Loader, validated the temporary table data and moved to the Interface table.

Environment: Oracle Applications 11i (Inventory (INV),Order Management (OM),Account Receivables (AR),Account Payables (AP),Application Object Library (AOL), BOM, PL/SQL, TOAD, SQL*LOADER, Forms 6i and Reports 6i, Discoverer 9i, Workflow, UNIX.

Programmer/Analyst

Confidential, NJ

Responsibilities:

• Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules. Designed and recommended solution for custom processes flow integrated with standard applications.
• Personalized Field Service FS Dispatcher Form.
• Customized Item Instance Query Report in Install Base IB using Template.fmb.
• Involved in Field Service Setups for CRM Foundation, Install Base IB, and Service Contracts SC.
• Used TCA API\'s for creating Parties, Party Accounts, Contacts, and Account Sites.
• Worked on enhancements of Customer Facing Document Reports in Quoting and Service Contracts SC.
• Developed the Service and Contracts (SC) parts of the Population Report, monitored the report performance and handled data issues like missing contracts, invalid contract end date, and null territory id.
• Developed Customer Data Import program for data loading from different systems to Oracle TCA tables.
• Expertise in Oracle Discoverer in Creating various business areas, user views, custom folders and joins for reporting.
• Customized Customer Products Summary Report in Install base IB using Discoverer 10g.Design and Development of Contract Inbound Interface for Oracle Service Contracts (SC).
• Developed PL/SQL Procedures to convert data in custom tables to service contracts using Service Contract (SC) APIs.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization of existing OA Framework pages.
• Developed Serial Number Search Report in Install Base IB using Discoverer 10g.

Environment: Oracle Apps 11i (General ledger (GL),Service Contracts SC, Install Base IB, Field Service FS, Account Receivables (AR), Inventory(INV), Order Management(OM), System Administrator), Oracle 6i, Reports 6i,Discoverer 4i, SQL, PL/SQL, SQL*Loader, Unix Shell scripting.

Sr. Systems Analyst

Confidential, FL

Responsibilities:

• Converted Order Detail Report, Credit Order Summary Report, and Orders by Item Report in Order management from report 6i to BI/XML publisher.
• Developed Orders/Parts with Shortages Report in manufacturing and materials using BI/XML Publisher.
• Developed PL/SQL scripts to load data from legacy system to install base IB tables.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into Install base IB tables.
• Created the necessary objects (Interface table, Control file and concurrent program) for Service contract SC interface.
• Creating Install scripts for Services module.
• Developed Service Contract SC conversion program by using the standard API’s
• Developed Tax Benefit Recipient Interface and report, Credit Card Transactions interface in Internet Expenses/iExpenses module using Reports 6i, BI/XML Publisher and Discoverer.
• Customized existing Dunning report in Account Receivables using BI/XML Publisher.
• Developed Contract History Report, Serial Number History Report, Expired Contract Report on the Service Contracts SC using Discoverer10g.
• Worked on Service Contract SC conversion program by using the standard API’s.
• Customized the standard workflow to send notification to the customer before invoicing.
• Automated the process of migrating Data Definitions and Templates from Instance to Instance.
• Developed several Unix Shell Scripts to Transfer files from one server to another server, UNIX to mainframes etc during interfaces and conversions and used them as wrapper programs.
• Involved in various Bug fixing issues and immediate Defect resolving issues in Install Base IB, Account Payables, General Ledger, PO, and iExpenses Modules.
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using HP/Kintana Migration tool and through FNDLOAD scripts.

Environment: Oracle Applications 11i, PO, AOL, Service Contracts SC, AP, AR, GL, Install Base IB, iExpenses, Workflow Builder 2.6.3.5, Forms 6i, Reports 6i, Discoverer 6i, XML Publisher 5.6.3, Oracle 10g, SQL Plus, TOAD, UNIX.

Confidential

Oracle Apps Developer

Responsibilities:

• Customized the seeded reports and created the new reports which suited the business requirements.
• Registered the new BI/XML Publisher report as concurrent program. Conversion of Oracle Discoverer Reports to BI/XML Publisher Reports like 5 Year Sales Order Report, Gross Sales Analysis Report and Sales by Category Report.
• Create SQL Purge Scripts to clean out outdated and erroneous data based on business rules
• Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance, and ECO Report. And changed the output format to XML and created new templates for XML Publisher to display in pdf or Excel Format.
• Developed Custom BI / XML Publisher reports for On-Hand-Quantity available for all the items in every Sub-Inventory which belonged to a particular Organization in the Inventory module.
• Customized Oracle standard reports like AP and AR aging Reports, Purchase Price Variance, and ECO Report. And changed the output format to XML and created new templates for XML Publisher to display in pdf or Excel Format.
• Developed Custom Reports such as Service Contracts by Status Report, Service Contracts Detail Report, Service Contract Forecast Management Report using Reports 6i.
• Developed Supplier Audit Report and Bank Audit Report using the Audit Trail functionality in Accounts Payable (AP) and using XML/BI Publisher.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.