Experience Summary:

• Over 8 years of IT experience in oracle applications 11i and R12 as an Oracle Technical Consultant.
• Primarily in worked in General Ledger GL , Payables AP , Receivables AR , Purchasing Order PO , Inventory INV , Order Management OM , Bill of Materials BOM , Work in Progress WIP , Application Object Library AOL , System Administrator.
• Comprehensive technical experience in Oracle Applications tools Oracle Reports 6i 10g, Oracle Discoverer 10g, Oracle XML Publisher, Oracle PL/SQL and SQL, Interfaces, AOL Application Object Library .
• Good expertise in developing Reports, Interfaces, Conversions and Extensions RICE Components.
• Well experienced with AIM Application Implementation Methodology Documents, Participated in written Technical Document's MD.070 , Migration Documents MD.120 , test case documents TE.40 and Conversion Mapping CV040 according to the business requirements.
• 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
• Experienced in Customization, Personalization of Oracle Reports 6i/10g
• Experienced in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and API's.
• Experienced in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data into Oracle Applications using PL/SQL,SQL Loader, UTL File, Unix Shell script's.
• Experienced in Customizing and developing Oracle Forms 6i/9i/10g/11g.
• Experience in Customizing form functionality using Form personalization.
• Extensively worked on PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL Loader scripts.
• Involved in performance tuning in oracle using Explain plan, Auto Trace and TKPROF.
• Implemented in Procedure to Pay P2P workflows.
• Worked on Oracle Discoverer Desktop, Administrator, Plus, Viewer , which includes report developments, discoverer administration, configuring discoverer and End User Layer EUL .
• Worked on Iprocurement requisition and receiving pages, worked on different test scenarios of Iprocurement requisitions in a functional set.
• Exposure in OA Framework customization and Personalization of JSP pages.
• Extensive knowledge in Trading Community Architecture TCA and worked on importing customers into Oracle AR, banks, suppliers into Oracle AP using TCA API's
• Excellent Interpersonal communication, documentation skills and experience coordinating with project managers, business analysts, Architects and Developers.

Technical Skills:

Professional Experience:

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Interacted with SME's, Business Analysts and Users for gathering and analyzing the Business Reports Requirements
• Involved in Writing Functional Specification MD050 , Technical Specification MD070 , Conversion Mapping CV040 documents for converting Open Requisitions, Open Purchase Orders, Suppliers, Supplier Sites, Supplier contacts, Customers using TCA
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer Ran concurrent program business views to populate the DFFs and KFFs in views
• Registered the Concurrent Programs, Forms, Reports and Request Sets in AOL and System Administration
• Strong Oracle RICE Reports, Interfaces, Conversions and Extensions development experience in all AP, AR, GL, PO and OM Modules
• Designed and developed Discoverer reports by communicating and interpreting end-user business requirements
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables
• Imported Journal Entry Transactions into GL tables using SQL Loader and successfully created the Journal Entry's in GL using Journal import
• Worked on generating additional accounting entries in GL, which are generated in the legacy system. Developed several extracts using Oracle UTL FILE functionality
• Involved in designing of Conversion/Interface Implementation Strategy for Accounts Payable and Accounts Receivable
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Account Payables AP
• Developed views, functions, procedures, triggers, packages using PL/SQL SQL to transform data between source staging area to target staging area
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the calendar feature, WHO columns, defining DFFs etc.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Customized the existing forms with descriptive flex fields
• Created Workflow notifications to avoid manual user intervention to notify a list of people in Order Management and AR when a credit hold is applied for an order
• Design and Development of Customized Order Cycles using Oracle Workflow
• Customized the Order Line level workflow, which will apply hold based on the mismatch between order header level and order line level
• Worked on OA Framework in personalization and customization.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 9i/10g and registered as XML reports in applications
• Customized Supplier Open Balance Report in Accounts Payables AP using XML/BI publisher.
• Customized the Supplier Payment History Report, Invoice History Report in Payables using XML/BI Publisher
• Environment:
• R12/11i AR,AP,GL,PO,INV , Oracle 9i/10g, Discoverer 10g, Reports 10g, XML/BI Publisher, Workflow Builder 2.6.3.5,Toad, SQL PLUS, Dynamic SQL, UNIX.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in GL, AR, AP, OM conversion converting of legacy data in to Oracle Applications using of PL/SQL package and Shell Script. SQL Loader was used to load data into custom tables
• Involved in requirements analysis, design and implementation of customization of OM Workflow for different order types
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports 6i and registered as XML reports in applications
• Involved in Unit Testing and Performance Testing for reports.
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• Responsible for creating the Database tables, indexes, constraints in Oracle 8i.
• Analyzing the business requirements and system specifications to understand the application.
• Coordinating with onsite team during the development.
• Involved in creation of various database components include tables, PLSQL scripts.
• Involved in coding of applying/releasing custom holds on an order and ship confirming the order.
• Performed Banks Migration using API to import External Banks, Bank Branches and Bank Accounts into Cash Management and assigning them to respective Supplier, Supplier Sites.
• Involved in coding of receiving purchase orders.
• Creating LDT files for the AOLs.
• Preparing/reviewing MD-70, TE.040 documents.
• Executed test scenarios for Oracle R12 Legacy Systems like Xelus
• Raising defects in Quality Centre tool for the issues in System Integration testing SIT
• Used Trade sphere extensively for the Sales order holds release process in testing process
• Providing daily status to the clients on SIT testing
• Interacting with the client and get the process to test the legacy along with the r12 oracle application.
• Preparation of test plan and test scenarios, cases.
• Functional/Technical assistance to team members

Environment:

Oracle Applications R12, Oracle 10g, Reports 10g, Discoverer 10g, XML/BI Publisher, PL/SQL, SQL PLUS, Dynamic SQL, SQL Loader, Quality Center.

Confidential

Oracle Applications Technical Consultant

• Analyzed the Business Requirements and System Specifications to understand the application.
• Developed XML reports for inventory and PIM modules.
• Developed on hand quantity transfer from item to item using interface.
• Developed statutory reports on business requirements
• Developed alerts on errored concurrent programs which involves sending email to respective team
• Developed generic pl/sql procedure to send emails using SMTP servers
• Worked on Public API for Sales Order, Freight Cost update and ship Confirm API.
• Developed Clipper Ship Integration Process Interface process for Clipper Ship Application.
• Customized Pack Slip Report RDF to XML Publisher
• Customized Pick Slip Report RDF to XML Publisher
• Preparation of Design Documents Detailed MD70 document that contains MD50/70/120 contents
• Involved in Client discussions for resolving the issues and Involved in Unit Testing.
• Environment:
• Oracle Applications R12, Oracle 10g, Reports 10g, Discoverer 10g, XML/BI Publisher, PL/SQL, SQL PLUS, SQL Loader.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Preparing MD-70 technical design document and MD-120 Component deployment documents.
• Creating LDT files for the AOLs.
• Developing new XML Publisher reports and customizing existing Oracle standard RDF reports to meet the requirements using Reports 10g.
• Creating Item Classes and assigning Item classes to respective reports.
• Creating Custom packages/function and registering them with Discoverer business area using Discoverer Admin.
• Developing reports using the Custom folders in Custom Business Area using Discoverer 10g Desktop.
• Developing Custom queries and folders in Custom Business Area using Discoverer 10g Administrator.
• Extensively used AOL and System Administrator modules for Creation of various Concurrent programs, Request sets, Value-sets and Descriptive flex fields, request groups for reports and concurrent requests.
• Performance Tuning the Stored Procedures Packages to make programs work faster.
• Developing custom programs to extract from R11 tables using DB Links, validate and load the data from staging tables into Interface tables which is a three step process in which the 1st phase is like extracting loading data into staging tables and the 2nd phase is like validating extracted data, upload into Interface tables/API and 3rd phase is Calling APIs or Standard Interface programs to load interface data.
• Worked on Interface to Import Supplier, Supplier Sites and Site Contacts in Accounts Payables.
• Worked on Interfaces to import Receivables Transactions into the interface tables in Accounts Receivables Successfully designed and implemented the Auto Invoice Import Interface. Activities involved extraction, importing Transactions into interface tables, defining sources for import and then using Auto Invoice Import Interface to import the data into the base tables.
• Developed PO Conversion and AR Auto invoice
• Developing/Customizing Discoverer and RDF reports by thoroughly understanding the requirement documents MD-50, MD-55 .
• Developed PL/SQL programs for validations
• Developed PL/SQL Procedures, Packages, Triggers and Functions
• Involved in the analysis and implementation of the Database system
• Used custom SQL loader program to load the invoices from other accounting systems to payables staging tables.
• Also developed PL/SQL scripts. Registered concurrent programs, request groups for reports.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program.
• Created loader file, porting invoices into the tables using SQL Loader and then using Payables Open Interface to import the data into the actual tables.
• Pack Slip Report Customization RDF to XML Publisher
• Pick Slip Report Customization
• Engaged in Unit testing TE.040 and Peer reviews of team members Work requests

Environment:

Oracle Applications11i AP, AR and OM , PL/SQL, SQL Plus, SQL Navigator 4.3.x, Oracle database version 8.0.5, Reports 6i