SUMMARY

• Certified Professional with 9 years of experience in functional and technical aspects of Oracle Applications.
• Implementation and technical expertise in Oracle Applications 12i/11i which includes General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Inventory (INV), Purchasing (PO), Shipping, Order Management (OM), Service Contracts, Fixed Assets (FA), E - Business Tax, Customer Data Hub (CDH), Warehouse Management Systems (WMS), Project Accounting (PA), Service Contracts (SC), Installed Base, Advanced Pricing, iSupplier, iProcurement and iExpenses, HRMS(core HR, Employee Self Service),Payroll modules, Oracle Projects Costing and Billing modules.
• Good Knowledge on Trading Community Architecture (TCA).
• Strong technical development skills on RICEW components (Reports, Interfaces, Customizations, Extensions and Workflow).
• Good Knowledge on Order To Cash (OTC), Procure To Pay (PTP) and Quote To Cash (QTC) process.
• Experience in Application System Administration like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, printers and providing support to business users for any technical and functional issues.
• Upgrading oracle systems to R12.
• Strong experience on Oracle Applications Frame Work (OAF).
• Strong programming knowledge in creating SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers and API.
• Exposure to UNIX shells scripting.
• Experienced in Data Mapping, Data Conversions and Interfacing.
• Experienced working on Approval Management Engine (AME).
• Strong knowledge on interface programs to import data and convert data from legacy systems.
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation.
• Extensively worked on Oracle Workflow 2.5, Discoverer 4i/ 10g, Reports 4.5/6i/9i/10g, XML Publisher and Forms.
• Customizing Oracle applications with Custom.pll library to create new functionality to the application.
• Experience in using the tools like TOAD and SQL Navigator for Ad-Hoc Query development and database objects creation.
• Provided support for SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Support.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request/ Service Request) with oracle support, managed and monitored TAR’s for several P1 issues. expertise using oracle software for applications design, development in a single and Multi-Org, Multi-Currency environments.
• Extensively worked on AIM (Application Implementation Methodology) documents like MD50, MD70 and MD120.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• Demonstrated good leadership skills with inspirational attitude with result oriented approach.

PROFESSIONAL EXPERIENCE

Confidential, Sterling VA

Oracle EBS Technical Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 IBM Remedy Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications 11i and R12 Oracle Applications Finance (AP, AR, GL, CM, SLA, Project costing and Billing) and SCM Modules (PO, INV, WIP, BOM, WMS, ASCP, OM, Shipping)
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Developed project plans and determine necessary resources, manage project tasks and timeline, and ensure delivery of necessary system configuration or specifications documentation.
• Developed Interface for the Standard Items of Sales Orders Import in OM.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Worked on Revenue Recognition of AR for the enhancement of Revenue accounting engine.
• 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.
• Implemented the Payables Open Interface. Activities involved creation of Loader File, importing Invoices into the interface tables using SQL*Loader and then using Payables Open Interface to import the data into the Base tables.
• Developed a Supplier Conversion to load Suppliers data into Oracle Supplier base Tables by loading the data and validating the data using PL/SQL and then loading into the vendor information tables.
• Developed Vendor Conversion Reconciliation Report for the Conversion Process
• Involved in the development of Purchase Order interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Designed and developed a custom PO Output for Communication Report for the Standard, Blanket, Blanket Release and Contract Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Designed MD70 Technical Design Document, Development for PO Requisition Work Flow Approval Management Engine (AME).
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Customized the Oracle Standard Check Template according to the business requirements and made required setups for Check Printing. Changed and fine-tuned the template to generate checks by placing MICR font, Digital Signature on the preprinted watermark paper.
• Designed and developed custom packages, triggers and procedures.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE, CST, Shipping, iprocurement, iexpenses), Project Accounting (PA), Warehouse Management Systems (WMS), E-Business Tax, OAF (Oracle Application Frame Work), Customer Data Hub(CDH), Service Contracts, Installed Base, PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential, NJ

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Oracle R12 Techno Functional Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 JIRA Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP),Purchasing (PO), Account Receivables (AR), Project Accounting (PA), Service Contracts (SC), Cash Management (CE), Fixed Assets (FA), General Ledger (GL), Inventory (INV), Order Management (OM), iprocurement and iexpenses).
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Designed MD70 Technical Design Document, Development for MOPUB AP Supplier, Supplier Sites and Banks Conversion to R12.
• Designed MD70 Technical Design Document, Development for MOPUB AP Invoices Conversion to R12.
• Worked on development of Conversion and Interface packages to extract the legacy data related to projects, projects customers and tasks and to validate and import them into oracle.
• Designed, documented and developed staging tables, conversion routings, custom PL/SQL API’S for converting project, tasks and expenditure in Project Accounting (PA).
• Developed Conversion Programs to import Customers into Oracle Order Management using Trading Community Architecture (TCA) API’S.
• Supported with Service Contract Conversion which handles Sales Order Creation with Service Lines and the integrating order with service contract.
• Developed Account Receivables (AR) Invoice Integration including Adjustments and Receipt Integration from legacy applications to R12.
• Developed Account Receivables (AR) Customer Integration (Party, Party Sites, Party Contacts, Accounts, Account Sites and Site Uses) between Sales Force and Oracle R12.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Work Flow Approval Management Engine (AME) Process.
• Modified existing logic and customized receiving notification for PO Confirm Receipts Work Flow.
• Modified existing PO Account Generator Work Flow to derive charge account based on expense account rule.
• Developed Custom Self Service Page for iexpenses using Oracle Applications Framework (OAF).
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into the Oracle 12i application.
• Developed Interface to Import On hand Quantity for Inventory (INV) Items in Oracle EBS.
• Developed Interface to Move On hand Quantity from one Sub Inventory and Locator to another.
• Designed and developed a custom PO Output for Communication Report for the Standard Purchase Orders according to the business requirements by customizing Standard XSL-FO style sheets.
• Developed Custom Fixed Assets (FA) RDF Reports Asset Additions, FA Cost Adjustments, Twitter FA Detail Register, Twitter FA Register Reports.
• Worked on Unix Shell Scripting for Code Deployment of Packages, Procedures, SQL Files, Reports and LDT files.
• Designed and developed custom packages, triggers and procedures.
• Responsible for creating New Forms, Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Personalized standard Oracle forms using forms Personalization according to the business requirement.
• Assisted with user testing of reports, developing and maintaining quality Procedures, and ensuring that appropriate documentation is in place.
• Tested and fixed the bugs in exiting forms and reports.
• Facilitate CRP (Conference Room Pilots), SIT (System Integration Testing), and UAT (User Acceptance Testing).
• Developed custom DB objects and AOL objects t for the project.

Environment: Oracle Applications 11i and R12 FIN and SCM Modules (GL, AP, AR, INV, PO, WIP, BOM, CE,CST, Shipping, iprocurement, iexpenses), Project Accounting (PA), Warehouse Management Systems (WMS), E-Business Tax, OAF (Oracle Application Frame Work), Customer Data Hub (CDH), Service Contracts, Installed Base, PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Customized and Developed the Quote to sales agreement process and create the new price list based on quote process dynamically.
• Developed the Payable interface process using Web ADI for purchasable and non-purchasable items.
• Customized Blanket/ROM Release process based on the client business needs.
• Developed the Lot tagging form and calling standard order form using ZOOM functionality.
• Worked on XML Bursting program to send emails and FTP the PDF files.
• Developed Turnkey Engine process customized standard procure to pay process to meet the client requirements.
• Developed Turnkey Rejection form to project the rejected Purchase orders based on client requirement.
• Implemented Advanced Global Intercompany (AGIS) for Subcon intercompany process.
• To in corporate Subcon intercompany Key Automation process customized standard process and developed custom objects to meet client requirement.
• Developed the multiple process using Standard API’s like Inter org transfer, DOT, Miscellaneous issue, receipts and internal order import.
• Worked on upgradation process from 11. .1.3, Retro fit 11i objects code to make sure should not disturb exiting functionality and maintain the 12i standards.
• Critical process design and validations in Procure to Purchase cycle
• Use of SQL * loader utility to load data from legacy system to interface.
• Involved in customizing reports and interfaces.

Environment: Apps Supporting Release R12 (12.1.3), 11i (11.5.10.2), Finance (FIN) and Supply Chain Management (SCM) Modules: PO, OM, INV, AP, AR, CE, Shipping, SQL, PL-SQL, Forms 6i, and Reports 6i, SQL plus, Web ADI and UNIX Shell script.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Created the new concurrent program to translate the standard accounting entries into the required accounting entries for Reporting set of books.
• Designed and Developed the AR auto-invoice interfaces.
• Developed the AR Receipt (Lockbox) interface.
• Designed and developed the General Journal Interface program.
• Developed the GL Extract Program.
• Developed the AP Invoice Interface.
• Developed the Purchase Requisition Approval Workflow.
• Designed, developed and tested Oracle PL/SQL packages, stored procedures, functions and triggers to translate the accounting entries into the required entries.
• Used AOL and System Administrator modules for Registration of Developed and Customized reports.
• Developed reports using Oracle Reports and XML Publisher.

Environment: Oracle Applications 11.5.10, GL, AP, AR, CE, PO, SQL, PL/SQL, Workflow, UNIX, TOAD, Windows XP.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Implementation and customization of Oracle FIN and SCM Modules - AP, INV, OM, PO.
• Responsible for Item Interface and material transactions in INV and also Currency, calendar, Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets and Lookups.
• Developed Load statements (control files) for SQL*Loader to load legacy data from flat files in to oracle tables.
• Implemented Pl/SQL Stored Procedures to load data from staging tables to interface tables.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed interface for loading supplier invoices from various sources.
• Developed Auto invoice program for loading customer invoices.
• Responsible for Month Close, Quarter close process for General Ledger.
• Working with oracle support to resolve TAR and performance issues.
• Provided support for Data conversion from legacy system into oracle.

Environment: Oracle Application 11.5.10 Finance and SCM Modules (AP, INV, OM, PO), Oracle 9i, Oracle Reports/Forms 6i, TOAD, UNIX Shell Scripts, PL/SQL, SQL Loader.