SUMMARY

• Over 9 years of Experience in Software Development in Oracle Tools with experience in Oracle Applications R12 (12.1.3, 12.2) and 11i (11.5.10, 11.5.9, 11.5.8, 11.5.6, 11.5.4) E - Business Suite.
• Total Experience in Oracle Applications (Warehouse Management (WMS), Order Management (OM), Oracle Inventory (INV), Sysadmin and Application Object Library (AOL), Purchasing (PO), Payables (AP), Receivables (AR), Advanced Supply Chain Planning (ASCP).
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Hands on Experience in the Web Service Integration.
• 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 PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Expertise working with Oracle 11g/12c, Developer 2000, PL/SQL, Forms 10g/6i, Reports 6i/10g, SQL * Loader, xml Publisher and BI Publisher.
• Experience working 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.
• Experience configuring Intelligence Dashboards with drill-down capabilities using global and local Filters, Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience in configuration, multi-org and MRC (multiple reporting currencies) implementation.
• Worked on UNIX Shell scripting, scheduled them for sending daily bug Status Report by email.
• Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.
• Solid Knowledge and understanding of AOL/FND architecture and Applications.
• Involved in Complete customOAFpage design and development using Jdeveloper9i (OAF).
• Strong Knowledge in Oracle Cursor Management and Exception handling.
• Expert in using UTL FILES, Export, Import, SQL*Loader Utilities, CONCSUB Utility, FTP, TOAD.
• Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Oracle Applications ‘Business Flows’ are well known and plan detailed test cases and scripts based on the Business Flows to conduct conference room pilots, system integration and user acceptance testing.
• Acted as a communications liaison between applications end-users, the SOP and technical teams for any communications to improve end-user satisfaction for Oracle Applications.
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through the projects from inception to completion.

TECHNICAL SKILLS

ERP: Oracle applications R12 and 11i (SCM and Financial Modules like AP, AR, OM, PO, QP, BOM, WIP, WSH, INV, Service Contracts, Install Base, Depot Repair etc.), Oracle Application Framework (OAF)

Databases: Oracle RDBMS, Oracle/9i/10g

Languages: SQL, PL/SQL, Java, Unix

Tools: Forms 6i/10g, Reports 6i/10g, Workflow builder, Toad, SQL Navigator, SQL*Plus, SQL*Load, JDeveloper, Oracle Configurator, Developer 2000, XML Publisher and Kintana

Operating System: UNIX, Linux (Red hat enterprise) and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Developed PL/SQL scripts to load order data from external system to AR transaction tables.
• Developed Customer with AR transactions and Customer receipts data by Out-bound and In-bound Interfaces.
• Developed the validation program to validate the data and insert into Order Entry Interface Tables (OE HEADERS IFACE ALL,OE LINES IFACE ALL) before running the Order Import Program.
• Developed PL/SQL Package to load Items information from legacy system into Staging tables and doing validations and loading into interface tables(MTL SYSTEM ITEMS INTERFACE) and calling standard Item Import Program to load to base tables MTL SYSTEM ITEMS B.
• Experience working on Report Development objects like Data Templates and RTF’s.
• Registered the Data Templates and Data Definitions using BI Publisher Administrator responsibility.
• Customized Pick Slip Report in Warehouse Management (WMS) using BI Publisher.
• Developed Shipper Declaration Report and Serial Number Report in the build and Pack process (WMS) using BI Publisher.
• Developed BUILD and PACK Oracle 10g Custom form in the Warehouse Management (WMS) after Pick Slip printing.
• Have 2 Years of Lead Experience and maintained a team of 5 members onsite.
• Hands on experience on the General Ledger for Loading ledger Data
• Developed/Converted most of the existing text reports to excel format using BI Publisher.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements.
• Designed and developed Customized Forms.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client
• Customized Oracle Workflow for generating Code combinations in Oracle Receivables and Oracle Payables.
• Business will report to IT any type of issue during the order entry for the customer on a good to the Order closes in the System.
• Converted various RDF reports having Report Layout into BI publisher to display the layout in a more user-friendly format.
• Developed OAF page for Uploading and Downloading the Customer excel data.

Environment: Oracle Applications R12.2.1, Oracle Applications 11.5.10, GL, AP, PO, INV, AR, OM, Oracle 10g, Reports 10g, Oracle Workflows, OAF, BI Publisher, Forms 10g SQL*Loader, TOAD and UNIX.

Confidential, Englewood,CO

Sr. Oracle Application Technical Consultant

Responsibilities:

• Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
• Designed and developed ITEM IMPORT to load items from the legacy system into the Oracle Inventory Base Tables.
• Developed Customer with transactions and receipts data by Out-bound and In-bound Interfaces.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Designed and developed STOCK LOCATORS to load locators from the legacy system into the Oracle Inventory Base Tables.
• Developed several Procedures and Database Triggers as per Business requirement.
• Worked on generating additional accounting entries in GL, which are generated in the legacy system. Developed several extracts using Oracle UTL FILE functionality.
• Extensive experience in XML/BI Publisher, which included working on report development objects like data templates and RTF’s.
• Registered the Templates and Data Definitions using XML/BI Publisher Administrator responsibility.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client
• Involved in customizing the forms for adding extra information through DFF’s.
• Extensively Used Oracle Applications Framework to create and customize OA Framework pages in Sales Online module.
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Experience in Oracle APEX to create reports.
• Hands on Experience in the General Ledgers for Loading Ledger Balances.
• Developed PL/SQL scripts to populate a table with application rates of employees for 3 months (Custom Database)
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.
• Job Travel Sheet Report
• Purchase Order Report
• Proforma Invoice Report
• AR Invoice Report
• Pack Slip Report
• Pick Slip Report
• Label Printing Report
• Reports developed in XML/BI Publisher:
• Bank Reconciliation Extract
• Interfaces/Extracts developed:
• Worked on fixing the defects on the Forms based Views, Triggers (Form level, Block level, Item level) using Forms 6i.
• Customized Sales Order form using Form Personalization.

Environment: Oracle Applications R12.2.1, Oracle Applications 11.5.10, PO, INV, OM, WSH, AR, AP, GL Oracle 11g/12c, Forms 6i/10g, Reports 6i/10g, Workflow, XML/BI Publisher, SQL*Loader, TOAD and UNIX.

Confidential, Davidson, North Carolina

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Preparation of technical upgrade and test strategy documents.
• Review the Functional Design Document (MD050s) and prepare detailed Technical Design Documents (MD070s).
• Involved in retrofit and development of the interfaces from external systems to EBS R12 - PO, INV, AP, QA, and WMS
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning, clone and refresh for development and various test execution cycles.
• Developed stored procedures, functions and packages, Views for implementing major functionality of the system. Developed scripts for populating database tables with test data.
• Developed scripts for concurrent executables and concurrent programs for Interfaces and Custom reports.
• Responsible for developing the assigned RICE component i.e. Reports, Interfaces, Conversion and Extensions by following the development Standards.
• Developed Key Flex Fields (KFF’s) and Descriptive Flex Fields (DFF’s) w.r.to the client requirement.
• Involved in working with Order Import, Item Import, Customer Interface, AP Invoices, Subledger Accounting, Requisition & Receiving Interfaces and Conversions for various Financials & SCM Modules.
• 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.
• Created common regions in OAF and used across pages.
• Created different type Alert Email Notifications (Periodic and Event) for the users to check with Order & Items on every day base schedule using Alert Manager Responsibility.
• Used Microsoft word to create an RTF Template with all the required data fields and registered the formatted template in XML Publisher Template Definition.
• Upgrading various RDF Reports in Financial Modules using XML Publisher (now BI Publisher).
• Resolving production issues reported by End Users.

Environment: Oracle Apps 12.1.3, R12 (AP, AR, GL, PO and FA), Oracle 11g/12c, Forms 10g, Reports 10g, Discoverer 10g, SQL*Loader, Workflow Builder 2.6, XML Publisher, TOAD, WINDOWS XP, UNIX.

Confidential, North Carolina

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Job Travel Sheet Report
• Purchase Order Report
• Proforma Invoice Report
• AR Invoice Report
• Pack Slip Report
• Pick Slip Report
• Label Printing Report
• Developed the reports and interfaces using Multi-Org and Multilingual concept.
• Worked on development of Outbound Interfaces/Extracts and new reports using Reports 6i, XML/BI Publisher
• Worked on debugging and fixing defects of Custom Forms using Forms 6i.
• Worked on high-level co-ordination with Onsite team (US) and other members from the offshore teams.
• Developed new reports and outbound interfaces in various modules such as Order Management, Inventory, Purchasing, Receivables, Payables, General Ledger, Shipping Execution, Bill of Material and Work in Process.
• Reports developed in XML/BI Publisher:
• Interfaces/Extracts developed:
• Worked on fixing the defects on the Forms based Views, Triggers (Form level, Block level, Item level) using Forms 6i.
• Customized Sales Order form using Form Personalization.
• Developed a Create or Update Reservations Interface using an API (inv reservation pub), this provides a ‘Back to Back’ order transaction functionality for an internally sourced sales order.
• Documented all my work in the form of MD70s, MD120s and Unit Test Plan (UTP) documents.
• 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 and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of new Invoices
• Involved in the setup and configuration of BI Publisher Responsibility.
• Created value sets and profile options to pass parameters to concurrent programs.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables.
• Improved the performance of developed objects using performance tuning the SQL and PL/SQL scripts.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, OM, INV, PO, BOM, WIP), Oracle 10g/11g, Discoverer 10g, Forms 10g, Reports 10g, Workflow builder, XML/BI Publisher.

Confidential

Sr. Oracle Apps Technical Developer

Responsibilities:

• Created new packages and procedures using SQL and PL/SQL.
• Worked with oracle collections and Table functions.
• Developed Ref Cursors for the application team whenever they need data from database.
• Mapping the data requirements, developing PL/SQL data admin scripts for the ETL Process.
• Used Bulk collect feature to improve the performance.
• Developed new Oracle forms and Modified existing forms for the enhancements.
• Customized Supplier Open Balance Report in Accounts Payables (AP) using XML/BI Publisher.
• Customized AP Invoice on Hold Report, AP Payment Register Report using Report 10g.
• Built custom reports using Oracle Reports 10g to fulfill the business requirements of the client.
• Customized Inactive Item Report and Cancelled Sales Order Report using Oracle Reports 10g.
• Developed and customized reports like Min-Max Planning report using Oracle Reports 10g.
• Worked on Modifying existing Oracle reports for the enhancements.
• Involved in User acceptance testing and fixed the issues.
• Analyzed and Compute statistics to improve the response time in queries and tuned the SQL queries.
• Created XML / BI Templates for different Languages.
• Was involved in setup and configuration of XML Publisher Responsibility.
• Tuned the existing queries for performance.
• Created Item Classes, Business Areas, Work-sheets, Conditions, Calculations using SQL and database functions, etc.

Environment: Oracle Database 10g/11g, Forms 10g and Reports 10g, PL/SQL, SQL, UNIX, PL/SQL Developer, Toad, Sql Developer.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Involved in requirements analysis, detailed design and generation of functional specifications documents.
• Created tables with proper keys and constrains which doesn’t violate business rules and create views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Created PL/SQL Libraries which involves PL/SQL procedures, functions and packages.
• Improved the performance of various existing reports by tuning the SQL statements. Created Indexes, used Hints, Other tuning techniques and analyzed the queries using Tkprof, Explain Plan to increase the performance of the reports.
• Granted the roles and privileges to the users of the application.
• Worked with Oracle Hierarchical Tree Item in Oracle Forms and also worked with Oracle Connect-by Hierarchical Queries.
• Developed IMS Packages to do DML operations on Custom tables for BOM and Pricing Modules.
• Created Quote creation process Package to create Quote in Pricing (Q2C flow) by using Views.
• Worked on creating the role based security for the application.
• Responsible to write SQL scripts for test cases to validate data in production
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Involved in production support.
• Develop UNIX scripts for jobs as per requirements.

Environment: Oracle Database 10g, 11i and 11i Forms and Reports 6i, PL/SQL, SQL, SQL Navigator, and Oracle EBS (OM/PO/AP/AR).