SUMMARY

• Over 7 years of Experience in Software Development in Oracle Tools with more than 5 years of experience in Oracle Applications R12 (12.0.6) and 11i (11.5.10, 11.5.9, 11.5.8, 11.5.6, 11.5.4) E - Business Suite.
• More than 5 years Experience in Oracle Applications (Order Management (OM), Purchasing (PO), Oracle Inventory (INV),Bill of Materials(BOM), Shipping (WSH), Work in process(WIP), General ledger (GL), Payables (AP), Receivables (AR), Sysadmin and Application Object Library (AOL).
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Very Good understanding of Trading Community Architecture (TCA).
• 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 10g/9i/8i, Developer 2000, PL/SQL, Forms 10g/6i, Reports 6i/4i, SQL * Loader, Discoverer 10g/6i/4i 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.
• 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.
• Strong experience in software development principles and methods (Agile, RUP, OUM etc).
• Solid Knowledge and understanding of AOL/FND architecture and Applications.
• Involved in Complete custom OAF page design and development using Jdeveloper9i (OAF).
• 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.

TECHNICAL SKILLS

ERP: Oracle applications R12 and 11i (Financials, SCM and CRM modules like AP, AR, GL, OM, PO, PA, QP, BOM, WIP, WSH, INV, Human Resource, Service Contracts, Install Base, Depot Repair etc.), Oracle Application Framework (OAF)

Databases: Oracle RDBMS, Oracle 8i /9i/10g, MS SQL Server 2000

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, PERL

Web Technologies: HTML, JAVASCRIPT, ASP and PHP

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

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

PROFESSIONAL EXPERIENCE

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Managed customer issues/escalations by working with Product management, support and product development team.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Developed the validation program to validate the data and insert into Order Entry Interface Tables before running the Standard Order Import Program.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Developed Item and Categories conversions.
• Created PL/SQL procedures to populate custom table, which is used to develop the WIP Component Report.
• Worked on standard BOM form customization (Customized “From” and “To” effective date fields and Overlapping component).
• Worked on the Advanced Supply Chain Planning on the Inventory, Purchase orders and Work orders.
• Customized the workflow for the PO Approval process.
• Customized the AME setups for Approval groups and Attributes for PO Workflow and AP Workflow.
• Created value sets and profile options to pass parameters to concurrent programs.
• Designed change order summary report and order history report.
• Registered the Templates and Data Definitions using BI/XML Publisher Administrator responsibility.
• Developed WIP SLEP Report and WIP Location Report.
• Created customized Mailing Label and the Pick Slip Report to fulfill the requirements of the client using the WSH and OM tables using Reports 10g.
• Developed Rental Order Report, RMA Sales Order Report in Order Management using BI/XML Publisher.
• Designed and developed Letter of Credit Report, Internal Order Summary Report, Global Managed Freight Report and Letter of Intent Aging Report in Order Management using BI/XML Publisher.
• Created and Deployed BI Publisher report such as Open Items Aging Report.
• Customized Expected Receipts Reports, Journal Entries Report and Billing History Report in Account Receivables using BI/XML Publisher.
• Conversion of Oracle Reports to BI/XML Publisher Reports like Open Sales Orders Report, New Sales Order Report by Customer, Purchase Order Summary Report, ASG DueOut Daily Shipping Reports, .
• 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.
• Developed/Converted most of the existing text reports to excel format using BI/XML Publisher.
• Customized Inactive Item Report and Cancelled Sales Order Report using Oracle Reports 10g.
• Created Complex Matrix reports in BI Publisher.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements.
• Designed and developed Customized Forms.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client
• Created Item Classes, Business Areas, Work-sheets, Conditions, Calculations using SQL and database functions, etc.
• Customized the standard AR Aging Report and Invoice History Report using Discoverer 10g.
• Developed Account Status Report, Applied Receipts Register Report, and Billing History Report using Discoverer 10g in AR.
• Registered discoverer reports as Form functions and made them available for users as Menu Options.
• Converted various Discoverer reports into Reports 10g using BI publisher to display the layout in a more user-friendly format.
• 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.
• Developed several Procedures and Database Triggers as per Business requirement.

Environment: Oracle Applications R12 GL, AP, PO, INV, AR, OM, CRM, Oracle 10g, Reports 10g, Discoverer 10g, BI/XML Publisher, Forms 10g SQL*Loader, TOAD and UNIX.

Confidential, Irvine, CA

Oracle Techno Functional Consultant

Responsibilities:

• Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Developed the validation program to validate the data and insert into Order Entry Interface Tables before running the Standard Order Import Program.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Worked on the Item and Categories conversions.
• Customized the workflow for the PO Approval process.
• Worked on the Extended Supply Chain (ASCP) on deployment of Purchase orders and Work orders.
• Developed several Procedures and Database Triggers as per Business requirement.
• Created and Updated interfaces and registry information in Trading Community Architecture (TCA).
• Developed the change order summary report and order history report.
• Worked on customizing the Standard PO Report.
• Worked on standard BOM form customization.
• 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.
• Customized Supplier Open Balance Report in Accounts Payables (AP) using XML/BI Publisher.
• Created Rich Text Format (RTF) templates to generate BI/XML Publisher Reports and embedded them on Oracle Intelligence Dashboard
• Worked on the WIP Component Report and WIP Location Report.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Extensively Used Oracle Applications Framework to create and customize OA Framework pages in Sales Online module.
• Developed queries for summaries of AR Aging reports.
• Involved in the workflow extension so that additional holds on orders can be applied through the workflow.
• Used FND SUBMIT Pub to Submit Requests, Request Sets.
• Developed PL/SQL scripts to load data from external system to Fixed Assets FA MASS ADDITIONS interface tables.
• 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.

Environment: Oracle Applications 11.5.10.2,R12, GL, AR, AP, PO, INV, OM, WSH, CRM, Oracle 10g, Forms 6i/10g, Reports 6i/10g, Discoverer 10g, Workflow, XML/BI Publisher, SQL*Loader, TOAD and UNIX.

Confidential, Evansville, IN

Oracle Techno Functional Consultant

Responsibilities:

• Involved in Design Reviews, Code Reviews, Coding, and Testing. Involved in the Oracle AIM Methodology throughout the project.
• 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. Create & Design Test Plan for Financials.
• Responsible for developing the assigned RICE component i.e. Reports, Interfaces, Conversion and Extensions by following the development Standards.
• 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.
• 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.
• Developed Internal Requisition Status Report to print the status information for internal requisitions in Purchasing (PO) by using Views.
• 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.
• 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.
• Customized Supplier Open Balance Report in Oracle Payables (AP) using Discoverer 10g.
• Used Microsoft word to create an RTF Template with all the required data fields and registered the formatted template in XML Publisher Template Definition.
• Created XML / BI Templates for different Languages.
• Was involved in setup and configuration of XML Publisher Responsibility.
• Creating one-time reports and ad-hoc SQL queries based on tables in OM, AR, INV and GL modules.
• Resolving production issues reported by End Users.
• Designed and development of FSG reports in GL including Balance Sheet, P&L and other Cost Center related Management reports.

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

Confidential, Englewood, CO

Oracle Applications Technical Consultant

Responsibilities:

• Expected Purchase Order Receipts
• Internal Order Summary
• Purchase Order Requisition report
• Supplier summary Report
• Job Travel Sheet Report
• Purchase Order Report
• Proforma Invoice Report
• AR Invoice Report
• Pack Slip Report
• Pick Slip Report
• Label Printing Report
• Bank Reconciliation Extract
• General Ledger, Payables
• Electronic Funds Transfer (EFT) Purchasing, Payables
• Logiroute Extract
• Order Management, Shipping Execution
• PO Receipt Extract
• Purchasing, Receivables
• Sales Order Extract
• Order Management
• 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 and Discoverer 10g.
• Worked on debugging and fixing defects of Custom Forms using Forms 6i.
• 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.
• Developed new and customized existing reports using custom business areas, Item Classes, Work-sheets, conditions, database functions and calculations in Discoverer 10g.
• 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.
• Documented all my work in the form of MD70s, MD120s and Unit Test Plan (UTP) documents.
• 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, Discoverer 10g, Forms 6i, Reports 6i, XML/BI Publisher.

Confidential

Oracle Developer

Responsibilities:

• Development and maintenance of projects, which includes in house training, up gradation of projects, analyzing the requirements for designing specifications, development of code (PL/SQL, SQL*PLUS, FORMS 4.5) and unit testing of the applications.
• Performed System Study, Design, Development and Implementation of the system.
• Developed Forms like Invoicing, Delivery Order, Quotation, Stock Inwards, Stock outwards, adjustments etc.
• Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
• Fixing Bugs in Forms and Reports previously designed.
• Designed menus and responsibilities to different level of users in the organization.
• Documented the business flowchart, user manual and technical manual.
• Extensive use of pl/sql programming like Procedures, Functions, Triggers & Packages using SQL*PLUS to implement business rules and Used Dynamic SQL in stored procedures.

Environment: Oracle Applications 10.7, Oracle Database 8i, PL/SQL, SQL*Plus, SQL*Loader, Forms 4.5, Reports 2.5, Windows NT, UNIX