SUMMARY:

• Over 9 years of IT experience in Design, Development, Conversion, Customization, Interfacing, Implementation of business applications using ERP, Client/Server and Internet Technologies. Specialized in Oracle EBS Applications (Financials, Manufacturing and Supply Chain/Distribution) skills with sound knowledge of their integration.
• Worked on versions 11i/11.0.x, R12. Experience in Oracle Applications Implementation and Upgrade.
• Worked on Oracle Fusion Financial applications.
• Experience in setup, customization, System Administration, data conversion and interface programming and generating Reports and concurrent programs and concepts of Multi Org Access Control of Oracle R12.
• Experienced with Oracle APIs and loading data through the APIs as part of interfaces and data conversion efforts
• Proficient in developing Forms and Reports using Oracle Forms6i/5.0/4.5, Reports6i/3.0/2.5, and developing concurrent programs using SQL, PL/SQL and shell scripts.
• Proficient with the Tables & their relations in OM, WSH, INV, PO, BOM, AR, AP, GL, PA, WIP modules.
• Well versed with Application Object Library (AOL) concepts.
• Good programming knowledge in Oracle 10g, Oralce 9i,8i/8/7.x, Oracle Forms, Oracle Reports XML Publisher, PL/SQL, SQL*Loader Utilities.
• Involved in the design of custom self service pages in Payables and Receivables modules using OA Framework, JDeveloper, Toad, Java, and PL/SQL.
• Involved in Performance tuning.
• Extensively working experience on the full life cycle implementation of Procure to Pay cycle (P2P) and Order to Cash cycle (O2C).
• Strong experience in writing SQL queries, PL/SQL procedures, Functions, Cursors, Triggers, ETL in Oracle and SQL server, also involved in database testing.
• Experienced in all SDLC stages with CMM level procedures and processes.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i, R12, Oracle Fusion Applications

Modules: Purchasing (PO), Inventory (INV), Accounts Payable (AP), Accounts Receivable (AR), Order Management (OM), General Ledger (GL), Advanced Pricing (QP), Work In Progress (WIP), Bills Of Material (BOM), Shipping (WSH).

Languages: SQL, PL/SQL, XML, SHELL Scripting, Java

Database: Oracle 10g/9i.

Operating Systems: Linux, Windows

Software Tools: Toad, SQL*Loader, XML Publisher, APEX, Jdeveloper

GUI s: Oracle Forms 10g/9i, Oracle Reports 10g/9i, Discoverer, Workflow Builder.

PROFESSIONAL EXPERIENCE:

Confidential - Houston, TX

Oracle EBS Techno Functional Consultant

Responsibilities:

• Created MD070 for all RICE Objects.
• Developed custom program for Purchase Order interfaces/ Conversions to import the data.
• Worked on AP invoice conversion.
• Imported Standard invoices, Credit memos and Debit memos from legacy system to Oracle Receivables tables using PL/SQL packages/procedures and Auto Invoice Import program.
• Worked on Supplier sites and Customer sites conversion program.
• Developed item cost import interface program to load material cost.
• Prepared Technical design document and Migration instruction document.
• Developed custom Purchase Order PDF report using BI Publisher.
• Developed custom program for Purchase Order attachments conversion.
• Developed Custom Sourcing Report using BI Publisher.
• Developed custom Separate Remittance advice report as per the business requirements.
• Customized GL Trial Balance Report as per the requirements.
• Customized AP Rejected Invoice Details Report.
• Developed GL Project Fixed Rate Justification Report using BI publisher.
• Developed AP Rejected Invoice Details report using BI Publisher.
• Customizations, Personalization’s and Extensions on Contracts Workbench Administrator web page using Oracle Application Framework as per client requirements.
• Worked on custom interface between Project Accounting and Receivables.
• Worked on custom interface to create and update projects using PA PROJECT PUB.
• Created custom page using OA Framework to view AP invoice History.
• Created Test Scripts (TE040’s) for UAT sessions.

Environment: Oracle EBS Applications R12 (12.1.3,12.2.4), PON, PO, HR, AP, AR, GL Oracle Database 11g, SQL*Loader, PL/SQL, Forms 9i, OAF, Reports 9i, XML Publisher, Toad, Workflow Builder, Windows XP.

Confidential - Austin, TX

Oracle EBS Technical Functional Consultant

Responsibilities:

• Developed custom package to update item DFF’s across all orgs.
• Converted large volume of Sales Orders and Sales Agreements into Oracle System
• Developing the program to extract the catalogs information from item description.
• Developed custom alert to notify users when new customer is added or updated.
• Created custom alert in WIP module to send E-email to the users whenever a new Job is created.
• Worked on Drop Ship cycle.
• Worked on Sales Order Line cancelling using Script.
• Developed Service Contracts change report using APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Developed custom script to mass update default buyer in item setup.
• Developed custom program to import Sales Orders to Oracle Order Management tables using PL/SQL packages/procedures and Order Import Program.
• Customized PO workflow to send notifications with PO detailed information.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Worked on AR Credit Transactions form personalization.
• Development of customized forms using Oracle Application Framework (OAF)
• Developed custom report based on All Inventories Value Report (XML) report by adding required columns.
• Customized Packing Slip Report, Sales Order Acknowledgement Report, Sales Contract Report, Inventory Aging Report in OM and Inventory.
• Developed custom package to validate data and create shipping deliveries and do pick release.
• Designed and customized Separate Remittance Advice report using XML Publisher.
• Developed custom script to mass oracle update for product codes and Cost Codes.
• Developed custom report for Month End Margin Analysis.
• Customized Project Billing Status Report as per customer requirements.
• Conduct UAT sessions and help client to make sure that all the test data goes in.
• Development of user interface, menus and writing PL/SQL libraries for Forms and Reports.
• Designed and developed AP invoice Interface program to load supplier invoices from legacy to Oracle using standard API’s.

Environment: Oracle EBS Applications R12 (12.1.3), AP, AR, QP, PO, WSH, OM Oracle Database 10g, 11g SQL*Loader, PL/SQL, Forms 9i, OAF, Reports 9i, XML Publisher, Toad, Workflow Builder, Windows XP.

Confidential - Los Angeles, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Developed the Conversion program to import Item, Item Categories, Item Cross references and on hand quantities of items.
• Created Oracle Alerts in WIP module where it sends E-email to the users whenever a new Job is created.
• Customized the payment, accounting workbench and Credit Card Registration forms for Tokenization project.
• Worked on Price list conversion to import Item price, modifiers and price breaks.
• Prepared extraction scripts to fetch payments, adjustments and refunds.
• Developed conversion programs to load back the updated credit card information.
• Modified order payment process for credit card payments.
• Modified Payment inquiry report.
• Developed Custom EFT payment process for HSBC Bank in XML output.
• Generated the AP Payment Extract report which throws an excel output using BI Publisher report. Prepared MD.070 technical design document for this component.

Environment: Oracle EBS Applications 11i, OM, AP, AR, Oracle Database 10g, SQL*Loader, PL/SQL, Forms 6i, OAF, Reports 6i, XML Publisher, Toad, Workflow Builder, Windows XP.

Confidential, Jasper, Indiana

Oracle EBS Techno Functional Consultant

Responsibilities:

• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD 70, and MD120) for all the RICEW.
• Customized the Oracle Standard Check Template according to Business requirements and did required setups for check printing (Payment Process Profile setups, Payment setups).
• Worked on HRMS Employee Interface to load employee information from legacy system (PeopleSoft) to Oracle using standard API’s.
• Designed and customized Separate Remittance Advice report using XML Publisher.
• Designed and developed Shipping interface to integrate Oracle systems with FedEx Systems.
• Worked on UTL MAIL package to send report attachment to users.
• Developed custom view to send the Customer and Supplier location information to OTM.
• Developed XML report to notify the Quality Inspectors.
• Involved in integrating Oracle and ESKER/ONBASE systems to archive and fax the reports to suppliers.
• Analyzed and developed custom OAF Pages for Multi Language Translation.
• Developed custom application for Issue Tracker comprised of OAF pages and Workflow.
• Designed and developed custom formula to improve the attribute based pricing performance drastically for the dynamically configured items from the configurator.
• Worked extensively on O2C cycle.
• Involved in providing techno-functional procure-to-pay life cycle support.
• Experienced in tuning of plsql programs, time/CPU consuming SQL Queries.
• Created Test Scripts (TE040’s) for UAT sessions
• Used Quest Stat tool to migrate objects between instances.

Environment: Oracle EBS Applications R12 (12.1.3), OM, AP, AR, QP, PO, WSH Oracle Database 10g, SQL*Loader, PL/SQL, Forms 9i, OAF, Reports 9i, XML Publisher, Toad, Workflow Builder, Windows XP.

Confidential - Grand Rapids, Michigan

Oracle EBS Technical Consultant

Responsibilities:

• Designed and documented the Technical Design Document (MD70) for packages using functional specification (MD 50).
• Involved in writing interface that loads the data from external systems into staging tables.
• Responsible for writing custom packages that separates the oracle creation engine from oracle order process to save customer time in ecommerce site.
• Created a package to validate the data before calling oe order pub API.
• Developed custom package for capturing and interfacing the promotion limits to ecommerce site.
• Setup processing constraints, Custom Modifiers, Attribute linking and mapping.
• Used EMF tables to log errors.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Developed custom Business Events and subscription methods.
• Involved in writing custom triggers, indexes, synonyms.
• Involved in writing custom queues to send the information to integration layer.
• Responsible for writing UTP and Deployment documents.
• Responsible for migrating code to another instance using HP Project and Portfolio Management (PPM).
• Used SVN for files version control.

Environment: Oracle EBS Applications R12, OM, QP, INV, AR, Oracle Database 10g, SQL*Loader, PL/SQL, Forms 9i, Reports 9i, XML Publisher, Toad, Workflow Builder.

Confidential - Fairport, NY

Oracle EBS Consultant

Responsibilities:

• Actively involved in gap analysis, user training and post-implementation support.
• Developed Auto Invoice Interface to import Standard invoices, Credit memos and Debit memos to Oracle Receivables tables using Auto Invoice Master Program.
• Designed and developed Order Interface to import legacy Sales Orders to Order Management using SQL*Loader, PL/SQL Packages/Procedures.
• Customized AR Aging Report to in corporate the “Offline Invoice Number” in the report. As the report has invoice number generated automatically. So this field is termed as ‘Reference Number’ for reconciliation issues
• Created a periodic alert to send a reminder to AP users group to make payment for a particular Invoice Source.
• Created a periodic alert to send information about purchase requisitions waiting for approval to PO users group
• Designed and Developed Customer API to import Customer Data into Oracle Receivables through Standard APIs.
• Created Parties and Party Sites for customers using TCA.

Environment: Oracle EBS Applications 11i, OM, WSH, INV, AR, AP Oracle Database 10g, SQL*Loader, PL/SQL, Forms 6i, Reports 6i, XML Publisher, Toad, Workflow Builder, Unix.

Confidential - Memphis, TN

Oracle EBS Technical Developer

Responsibilities:

• Worked on UTL MAIL package to send report attachment to users
• Development of user interface, menus and writing PL/SQL libraries for Forms and Reports.
• Worked on OKS IMPORT HEADER PUB to create contract Header.
• Worked on WIP JOB Interface to create Jobs.
• Developed interface for Item data conversion to load items from flat file to Oracle Inventory using SQL*Loader, PL/SQL and Import Items program.
• Worked extensively on O2C cycle.
• Involved in writing custom triggers, indexes, synonyms.
• Involved in providing technical procure-to-pay life cycle support.

Environment: Oracle Applications R12, 11i PO, OKS, OM, AP, INV, Oracle Database 10g, SQL*Loader, PL/SQL, Forms 9i, Reports 9i, BI Publisher, Toad, Workflow Builder.

Confidential

PL/SQL Programmer

Responsibilities:

• Have performed front-end and back-end validations using triggers.
• Used Forms 6i to design several front-end applications.
• Wrote many complex reports in Salary, Overtime, Bonus and other benefits by using Reports 3.
• Used Snapshot to transfer the data from branch location.
• Involved in writing DB triggers to update master tables and perform calculations.
• Designed complex PL/SQL queries to enhance the existing reports.
• Write complex SQL Queries. Optimize and tune SQL queries that were taking long times. Created database objects like tables, views and triggers. Created E-R diagrams and analyze the database for indexes, constraints etc.
• Worked on optimizing existing PL and SQL procedures, functions and packages. Used database features like global temporary tables, table functions, collections, bulk loading techniques to improve performance of data loading and retrieving.
• Created and Developed Stored Procedures to support data activity.
• Software maintenance and development.
• Database application for downloading and uploading the data for trading operations.
• Updated user documentation for all application modules while following company standards.

Environment: Oracle 8i, Oracle Forms/Reports 6i, SQL, PL/SQL, HTML.