SUMMARY:

• Over 7 years of experience as an Oracle Applications R12/11i (E Business Suite) Techno Functional consultant, with expertise in Oracle Financials modules (GL, AP, AR, FA, PA and Cash Management), Manufacturing Modules(OM, INV, Shipping, BOM, PO, WIP), iExpense, HRMS, OTL, Advanced Pricing and Distribution modules, CRM ( Service Contract SC, Install BaseIB, Field Service FS,Depot Repair DR).
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Expertise in design and development of conversion programs, interfaces and Trading Community Architecture (TCA) APIs to import data from legacy systems.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12/11i, Oracle 11g/10g/9i/8i, Discoverer 10g/9i/4i/3i,Oracle Reports/Forms 10g/9i/6i/4.5/2.5, XML Publisher 5.6.3/5.6.2.
• 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.
• Successfully migrated database from Oracle older versions to Oracle latest versions and from MS Access, Sql Server to Oracle.
• 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).
• Solely managed the activities like design, development, coding, testing and End-user training.
• Substantial development experience in creating stored procedures, Packages, Triggers, Functions, Indexes and Views.
• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization of existing OA Framework pages.
• Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.

Technical skills:

• ERP: Oracle E-Business suite R12/11i General Ledger GL, Accounts Receivables AR, Accounts Payables AP, Fixed Assets FA, Order Management OM, Inventory INV, Shipping WSH, Project AccountingPA, Cash Management CM, Advanced Pricing , Purchasing PO, iExpense, HRMS, OTL, AOL, System Administrator, BOM , WIP
• Application Tools: Reports 6i/9i/10g, Discoverer 4i/9i/10g, XML Publisher 5.6.3/5.6.2, Oracle Forms 6i/9i/10g , Workflow Builder, Oracle Enterprise Manager (2.1.0) and OA Framework.
• Databases & Tools: Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer
• Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS
• Languages: SQL, PL/SQL, C, C++, Java, HTML, XML
• Scripting Languages: Unix Shell scripting
• BI: OBIEEtill 10.1.3.4.1, XML/BI Publisher
• ETL: Informatica6x to 8.6.1, DAC7x to 10.1.3.4.1

Education Qualifications:
Bachelors of Computer Science

PROFESSIONAL EXPERIENCE:

Confidential,Washington D.C. Apr 2012 - Feb 2013
Oracle Apps Technical Consultant
Responsibilities:

• Worked on AR, AP, PO, GL, DOI Payroll, Federal Travel modules and data warehouse development.
• Extensively worked on conversions into Oracle AR, GL Balances import, Vendors and PO by mapping the data, writing oracle stored procedures, packages and oracle seeded packages. Has developed interfaces for transferring data from legacy to Oracle Apps.
• Worked on GL interfaces for balances Conversion, SQL, PL/SQL, stored procedures and packages
• Worked on Interfaces & reports for Fed Admin of Fund status availabilities, Budget Distribution Validations, GL unliquidated obligations & insufficient funds
• Worked on AR interfaces & discoverer reports of Disgorgements, Section 31, Host Pay and Outstanding Receivables.
• Worked on invoice conversions by designing, developing style sheets and generating XML files using Oracle PL/SQL, Oracle AR, BI Publisher, XMLDOM package
• Administered and developed various OLAP reports using OracleDiscoverer.
• Modified standard reports and integrated with Oracle Applications 11i using Application Object Library
• 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.
• Created business areas, user views, custom folders and joins for reporting using Oracle Discoverer 10g in Administrative edition as per the user requirements.
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Supported AP Supplier Conversions (Vendors, Vendor Sites and Vendor Contacts) and Invoice Conversions using AP Interface Tables, PL/SQL packages, API’s
• Developed Discoverer reports to provide the list of important transactions across several modules such as AR, AP, GL and PO in DELPHI system.
• 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.
• Worked on Conversions of employees from Legacy System to Oracle HR.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Helped financial team in Oracle UI and Oracle issues and conduct user trainings
• Worked on ETL using Oracle Apps and stored procedures
• 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.
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization of existing OA Framework pages.
• Prepared most of the AIM Functional and Technical documents for requirements, design, and implementation steps with data conversions, test plans and functional user training guides for all the phases of the project

Environment: Oracle Federal Financials 11.5.10.2,Oracle Applications 11i( General ledger (GL),Fixed Assets (FA) ,Account Receivables (AR),Account Payables (AP),Purchasing (PO),Inventory(INV),Human Resources (HR),Payroll ,Federal Travel,Order Management (OM)),SQL,PL/SQL,Embedded SQL,Oracle 10g,TOAD,Discoverer 10g, Linux

Confidential, New York Jan 2011 - Mar 2012
Oracle Apps Techno Functional Consultant
Responsibilities:

• Requirements gathering for the reports and custom programsdevelopment 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 holdreport, 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 andMTL_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 FAmodules.
• 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 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.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40).

Environment: Oracle Applications R12( 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.

Client: Confidential, New Jersey Mar 2011 - Dec 2011
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.
• 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.
• 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
• 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.
• 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.

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.

Client: Confidential, New Jersey Oct 2009 - Feb 2011
Oracle Techno Functional Consultant
Responsibilities:

• Designed and developed conversion to load onhand 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).
• Involved in product design, development and support for components of OA Framework,Common Applications (CRM Core) modules of Oracle Applications 11.5.10 and R12
• Developed various screens using OA Framework.
• Worked on OA Framework personalization and extensions.
• 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.

Client: Confidential, Grand Rapids, MI Jun 2008 - Sep 2009
Oracle Techno Functional Consultant
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.
• Worked on enhancements of Customer Facing Document Reports in Quoting and Service Contracts SC.
• UsedTCA API\'sfor creating Parties, Party Accounts, Contacts, and Account Sites.
• 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, 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.
• Developed Serial Number Search Report in Install Base IB using Discoverer 10g.
• Created a SOA Object for integrating 11i and R12 implementation for handling customer information using BPEL, ESB and Oracle Applications Adapter.
• Implemented Oracle ESB (Enterprise Service Bus) and integrated withBPEL.
• DevelopedBPELprocesses that contain exception handling to capture the Remote and Binding faults.
• Designed and developed several fault handling routines in BPEL.
• Using JDeveloper as the development environment.
• Implemented best practices such as error handling and file archiving in Oracle ESB.
• Worked on the condition builder in BPEL.
• Used the rules editor in BPEL to define and assign rules in BPEL.
• Created a SOA object for sending quoting information to third party system.

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.

Confidential, INDIA Sep 2006 - Apr 2008
Oracle Apps/BI Consultant
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.
• 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.

Environment: Oracle Applications 11i ,Service Contracts SC ,INV , AP , AR ,PO , Oracle 6i, XML Publisher 5.6.3, Discoverer 4i, Reports 4i, SQL*PLUS, SQL*Loader, TOAD, Unix