PROFESSIONAL SUMMARY:

• Around 10 years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS 11i/R12.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications(EBS) with major focus in Accounts Payables (AP), Purchasing (PO), Inventory (INV), General Ledger (GL), Bills of Materials(BOM), Accounts Receivable (AR), Order Management (OM), Cash Management, and Core HRMS Modules.
• Oracle Global Techno-Functional Production Support in Oracle Modules like Procure-to-Pay (P2P), Order to Cash (O2C).
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, XML/BI Publisher, Workflow Builder and Oracle Discoverer.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Have good experience in designing/developing self-service applications with OA Framework (OAF).
• Hand on experience in Oracle Application Framework (OAF) customizations and personalization’s.
• Hands on experience in Creating, Extending, and deploying Oracle Framework (OAF) Components.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Extensive experience in production support and ticketing systems, BMC Remedy.

TECHNICAL EXPERTISE:

Operating Systems: UNIX, WINDOWS-XP/NT, Windows 7, Window 8.1, MS-DOS.

RDBMS: Oracle 11G/9.x/ 8.x/SQLServer7.0.

Application Tools: Developer 2000 (Forms 6i&10g/Reports 6i&10g), Discoverer 9i, XML Publisher, SQL*Loader, OAF (Oracle Application Framework).

ERP: Oracle Applications 11.5.10.2 and R12 (AOL, SYSADMIN, INV, PO, AP, AR, GL, OM, EDI, WIP, BOM and HRMS).

Tools: SQL* Plus, TOAD 7.5/9.5, SQL Developer Tools, XML Publisher, Workflow Builder, JDeveloper, OBIEE, Apex, Remedy5/Remedy 7, and Appworx.

Languages: SQL, PL/SQL, XML, C, C++, Java, Pro*C.

Utility Tools: WS FTP, Putty.

Configuration Management Tools: ClearCase, Sharepoint, PVCS Tracker and PVCS Version Manager.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Oracle Apps Techno functional Consultant /Lead Consultant

Responsibilities:

• Worked on the third party Integrations such as IBS, Documentum, MES, and SSS for both Inbound and Outbound Interfaces in Purchase Order Module and Receivables Modules (PO and AR).
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Worked onrequirement gathering, designanddevelopmentof custom applicationSupervisor Information Management System(SIMS) inOAframework.
• Worked extensively in custom.pll and form personalization for the sales order, customer standard forms.
• Involved in development of new interfaces/reports/customization of the existing reports using the XML Publisher reports in P2P, Order to Cash (O2C).
• Created the lookups/DFFs/Valusets and uploaded the values to identify the critical customers based on the requirement in Inventory (Inv).
• Extensively worked on Procure to Pay (P2P), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL) and Cash Management (CM).
• Extensively worked on developing/customized RICEW, XML/BI Publisher components in Procure to Pay (P2P), Order to Cash (O2C).
• Created the Shell Scripts to invoke mailer notifications for the standard/custom program for Monitoring activities.
• Involved in designing and developing the Bank Statement Import program in Cash Management (CM).
• Designed and developed the new interface for Kelly Open Invoice Import program (AP) from the Legacy system.
• Customized the reports ie Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management in Oracle RDF and XML Publisher.
• Modifying the existing reports prior to converting to R12 based on the table and columns mappings. Involved in preparing the custom lookups and DFF’s to map the columns with target systems prior to loading.
• Personalization done for few of the Customer forms to plug the additional columns using the DFF’s and validating from PLSQL Package to accommodate the client changes.
• Worked as onsite coordinator role to manage daily activities between onsite and offshore.

Environment: Oracle Applications EBS R12.1.1 (INV/PO/AP/GL/OM/AR modules), OAF, Toad, PVCS, Oracle11G, Forms 6i/10g and Reports6i/10g, UNIX

Confidential, Columbus, OH

Sr. Oracle APPS Techno-Functional Consultant

Responsibilities:

• Involved in Requirements Gathering.
• Involved in Developing Inbound Outbound Interfaces using UTL FILE Package
• Involved in Developing the Receivables Invoice Prints Using Oracle XML Publisher
• Involved in Unix Shell Scripting for Secure SFTP Transfer of Invoice data files.
• Production Support and Development for Global Cummins in AP Module.
• Developed Interfaces to load Supplier Information from Legacy Systems.
• Developed Interfaces to load Invoices Information from Legacy Systems.
• Migrated AP Custom Interfaces and reports from 11i to R12.
• Enhancements involved in support.
• Worked on Remedy AP Support Issues.
• RCA analysis on repetitive tickets.
• Personalization and Extension of Oracle applications in Oracle Payables Module using OA Framework (OAF).
• Worked on POI (Payables Open Interface) rejections.
• Code Changes on custom invoice report.
• Involved in Major support of Receipt Open Interface logic in AR, AP.
• Appworx Job monitoring.
• Appworx Job modifications/Changes depending on requirement.
• Involved in Designing the Appworx Chain Documents.
• Involved in Production Support of the interfaces.
• Involved in Migrating the Customizations to UAT/CRP/Production Instances.
• Prepared MD70 Technical Design documents for OAF development, customizations and extensions.
• Created CUSTOM JAVA TOP on server for customized OAF pages.
• Created various .pdf reports using BI Publisher and associated the report generation with Front end using OAF

Environment: Oracle Applications EBS 11i/R12.1.3 (AP/AR/GL/PO/OM/INV/HRMS modules), OAF, Toad, SQL Developer, Forms 6i/10G and Reports 6i/10G, OAF, Clear Case, Appworx, Oracle9i/10g, UNIX

Confidential, Houston, TX

Oracle APPS Technical Consultant

Responsibilities:

• Customization on “Pay on Receipt” Programs to update invoice number as per receipt in Order Management Module.
• Form Personalization on Receipts Creation Form.
• Design and Development of Critical Financial reports using XML Publisher.
• Design and Development of Payables and General Ledger reports using Reports 10g.
• Worked on Customizations Involved in Requisition and PO Approval Notification workflow.
• Involved in Implementing AME Approval hierarchy.
• Worked on ApexReports.
• Worked on Intercompany transactions reports for AP/AR.
• Worked on Bank Reconciliation Report in Cash Management..
• System Administration tasks related to Menus/ Functions, Responsibilities, Users.
• Responsible for Technical documentation.
• Worked on the OAF (Oracle Application Framework) Customizations involved in iProcurement modules.
• Worked on the OAF Personalization’s.

Environment: Oracle Applications EBS R12.1.3 (GL/AR/AP/PO/INV/OM/HRMS modules), SQL Developer, PVCS, Apex, Oracle10G, UNIX

Confidential

Oracle APPS Technical Consultant

Responsibilities:

• Design and Development of HRMS, Payroll reports using BI Publisher.
• Changed the company logo in all the BI reports.
• New BI report to show current payroll run and previous month payroll run results.
• Design and Development of Payables and General Ledger reports using Reports 10g.
• Design and Development of HRMS, Payroll, PMS, OLM, reports using Reports 10g, BI Publisher.
• Worked on Forms Personalization to disable deletion option to user in Assignments Process Results Form.
• Worked on Special Information Types (SIT) Interface Program.
• Developed new report for employee’s hire or termination notifications.
• Customized Invoice report to show invoice created by and creation date.
• Created new report for GL Encumbrance Balances.
• Created new report for GL Voucher reports with Sub Ledger Information.

Environment: Oracle Applications EBS R12.1.1 (HRMS/Payroll/FA/AP/GL modules), SQL Developer, Toad, PVCS, Oracle11G, UNIX, BI Publisher and OAF

Confidential

Responsibilities:

• Implementing Oracle Apps Standards to the Product.
• New Form Development
• New Report Development
• Testing the Application.
• Developing Key Database objects and Forms Functions.
• Analyzing the code of all the forms in order to reduce redundancy in code.
• Tuning of Sql Statements and Pl/SQL Procedures, functions and packages
• Involved in development of Pl/SQL packages and database triggers.

Environment: Custom ERP Application, SQL Developer, Oracle9i, Forms 6i/Reports 6i, UNIX

Confidential

Software Developer

Responsibilities:

• Developing Forms, Coding and debugging forms, Developing Reports, Testing of Forms and Reports and Creating Pl/Sql Packages, Procedures, Functions, Views and Database Triggers.
• New Form Development
• New Report Development
• Testing the Application.
• Developing Key Database objects and Forms Functions.
• Writing Pl/SQL Procedures, functions and packages
• Involved in development of Pl/SQL packages and database triggers.

Environment: Custom Application, SQL Developer, Oracle9i, Forms 6i/Reports 6i, UNIX

Confidential

Software Engineer

Responsibilities:

• Created tables, Views, Synonyms
• Developing Forms using forms 6i and Coding
• Developing Reports using reports 6i
• Coding and debugging the forms
• Testing of Forms and Reports.
• PL/SQL stored procedures and database triggers to implement the business rules.
• Interacting with the clients for the feedback and making the necessary corrections.

Environment: Custom Application, SQL plus, Oracle9i, Forms 6i/Reports 6i, UNIX