SUMMARY

• Over 13+ years of experience as an Oracle Applications EBS Technical Consultant. Strong Design and Development skills coupled with strong implementation skills spanning Full Life cycle implementations (11i, R12), Application upgrades (R12) and Production support (11i, R12).
• Prepared functional and technical design documents for customizations and conversions using AIM documentation methodology (MD, CV, BR etc.).
• Highly conversant with various modules of Oracle Financials (GL, AP, AR), Manufacturing/Supply Chain/Distribution (INV, PO, BOM, OM, eAM), MDM (CDH (Customer Data Hub) and SDH (Supplier Data Hub)), System Administration and AOL Working knowledge of Procure - to-Pay (P2P), Order-to-Cash (OTC), Drop Shipment, Internal Sales Order (ISO) cycles.
• Excellent Technical skills in developing CEMLI (Customization, Extension, Modification, Localization, and Integration) and RICEW (Reports, Interfaces (Inbound and Outbound), Conversions, Extensions and Workflow) Components in the domain of Oracle Applications E-Business Suite.
• Hands on experience in interface design, customizations, integrating disparate systems, and data conversion.
• Design and developed Real Time Interfaces for OM, CDH and SDH using Oracle Workflow Business Events which interacts with other system through Fusion Middleware.
• Expert in Oracle Application Framework (OAF) applications, customization and extension of OAF pages.
• Analysis, Design and Implementation of Workflow extensions for OM header & line, PO Requisition Approvals and AP Invoice Approvals.
• Analysis, Design and Implementation of Approvals Management Engine (AME) for PO and AP.
• Thorough knowledge of Oracle Apps Data model and how to leverage the data for effective reporting using tools like Discoverer, Oracle Reports and BI Publisher (RTF, eText, XSL and Bursting Templates).
• Working knowledge on Form Personalization’s and Form Customizations along with CUSTOM.pll in handling various Business requirements.
• Developed Oracle Fusion Cloud OTBI and BI reports. Loading Files using FBDI and ADF DI.
• Solid experience in Database design, creation and management of schemas, APIs, writing stored procedures, functions, triggers, DDL, DML, SQL query performance tuning with hints. Proficiency in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Extensive experience with Trading Community Architecture (TCA) and Data Quality Management (DQM), including HZ APIs.
• Extensively worked on Extensible Attributes/User Defined Attributes (UDA) of OM, CDH and SDH.
• Design and developed Time log Interface using Web ADI. Published White Paper on Web ADI.
• Design and developed Web Services and SOA/BPEL processes for HR Application.
• Participated in multiple CRP(s), including UAT and go-live phases of the projects. Provided support during Go-Live and post Go-Live activities.
• Exposure with Oracle EDI Gateway and Oracle Release Management, transferring EDI documents from the legacy system to Oracle. Exposure with PDH (Product Data Hub), EDQP (Oracle Enterprise Data Quality for Product Data), EDQ (Enterprise Data Quality), ODI (Oracle Data Integrator) and Data Loader.

TECHNICAL SKILLS

ERP: Oracle Apps 11.5.9, 11.5.10.2, R12.1.3, R12.2.4 and R12.2.5, Fusion Cloud R12, R13

Modules: GL, AP, AR, SLA, OM, INV, BOM, eAM, PO, MDM (CDH and SDH), AOL

Technologies Used: SQL, PL/SQL, Reports, BI Publisher, Forms Personalization, Alerts, AOL, Web ADI

Databases: Oracle 8.x/ 9i /10g

Tools: TOAD, SQL Plus, Putty, SQL Developer, SQL*Loader, FTP, TELNET, WINSCP, FNDLOAD, Discoverer, Reports6i & 10g and Forms 6i & 10g, Workflow Builder, JDeveloper 10g & 11g, XML Publisher, UTL FILE

Middleware: Oracle Fusion Middleware, SOA, BPEL, AIA, PIPs

Version Control Tools: Tortoise SVN, Microsoft VSS, Microsoft SharePoint, ClearCase

Operating Systems: Windows 95/ 98/ NT/ 2000/ XP, MS DOS, Linux, UNIX Environment

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Redesigned existing Interfaces - Concur Expense Invoices to Oracle AP, Paycom HR to Oracle HR.
• Developed new interfaces - Customer, Supplier, AP Invoices, AR Invoices, and GL Interface.
• Redesigned and modified reports - AP Check Print, AR Invoice.
• Validated existing Concurrent Program and Reports.
• Validated and tested end to end processes.
• Prepared installation files. Migrated and installed code to CRP and UAT instances.

Environment: Oracle Apps R 12.2.5, SQL, PL/SQL, Oracle 12c, TOAD, PL SQL Developer, BI Publisher, Workflow Builder, JDeveloper, Oracle Fusion Middleware. Modules: AP, AR, GL, OM, INV, PO.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Part of technical team to upgrade project from R12.0.6 to R12.2.5. Redesigned custom objects like table, synonyms, views, materialized views; DB triggers based on new concept i.e. Editions.
• Redesigned and retrofitted custom forms, reports, workflow and interfaces for financial and distribution modules
• Developed Inbound and Outbound EDI process (850, 860, 855, 856, 810) using Oracle B2B, Oracle Document Editor and Oracle SOA. The BPEL composite is developed which includes XSD, AQ Adapter, DB Adapter and Transformation (XSL).
• Design and developed OAF page for custom Pick Release process which has functionality to select the specific lines which needs to be picked.
• Design and developed Blanket Release custom process for Procure to Pay (P2P) cycle. Design and developed Concur Expense Report interface to Oracle AP.
• Automated Drop Ship Process - Sales Order, PO Requisition, PO Release and Receiving Transaction. Secondary Supply Business Process - Sell Tires to network distributors. They sell to end customer on our behalf.
• Design and developed end to end process. This involves automation of Standard order creation, AR invoicing for end customer and Return order creation, credit memo for distributor.
• Worked on custom forms for Ship Confirm and Warranty Return. Worked on custom reports Pack Slip, BOL, Positive Pay and AP Invoice Print.
• Worked on custom Sales Order Line Workflow Process. Preparation of installation files. Migrating and installing code to higher instances.
• Involved in all phases of project development, test, UAT, go-live and post production support. Raised SR and follow up with Oracle for seeded functionality issues.

Environment: Oracle Apps R 12.2.5, SQL, PL/SQL, Oracle 12c, TOAD, PL SQL Developer, BI Publisher, Workflow Builder, JDeveloper, Oracle Fusion Middleware. Modules: AP, AR, GL, OM, INV, PO.

Confidential

Lead Oracle EBS Technical Consultant

Responsibilities:

• Leading team at onsite with team members both at onsite and offshore. Project includes transitioning business units with various legacy systems to centralized Oracle ERP system.
• Organize, prioritize, coordinate, and administer the activities and workload of the application development team.
• Understand the requirements by studying functional document. Documented coding standards to be followed throughout technical team.
• Involved in POCs to check feasibility of requirements. Design, customization and development of the Objects as per the requirement.
• Involved in field mappings for all the interfaces. Worked on the development of Interfaces, Data Conversions, Developing & customizing Reports in Order to Cash Cycle.
• Solution the Standard and CTO Order integration from legacy to Oracle and back to legacy. This includes synchronizing Customer (Bill to and Ship To), Inventory (Items), BOM (Model Option Configurations) and Pricing.
• This also includes Order Header (OEOH) and Lines (OEOL) Workflow customization. Synchronization using Workflow Business Events and Fusion Middleware.
• Solution the Procure to Pay (P2P) cycle which includes PO interface from legacy system to oracle. Solution the AR Invoices, AP Invoices and GL Interfaces from legacy system to Oracle.
• Design, customization and development of shipping documents (Commercial Invoice, Packing Slip, Bill of Lading reports). Personalization of WMS mobile screens using customListener.java feature.
• Design and developed Generic File Upload utility using OAF to upload data file from User’s desktop into ERP Database using standard oracle security.
• Design and developed custom RLM (Release Management) Exception Workbench using OAF. To maintain the track of inaccuracies in schedule originating from customers, this form is used to reconcile the issues with customer. Supporting go-live plant on enhancements.

Environment: Oracle Apps R 12.2.4, SQL, PL/SQL, Oracle 11g, TOAD, PL SQL Developer, BI Publisher, Workflow Builder, JDeveloper, Oracle Fusion Middleware. Modules: AP, AR, GL, OM, RLM, INV, BOM, PO.

Confidential

Lead Oracle EBS Technical Consultant

Responsibilities:

• Lead the team at offshore for all development activities. Understand the requirements by studying functional document. Interaction with the onsite people and resolving the offshore queries.
• Attend weekly status meetings and provide detailed status report to the client. Design, Customization and development of the Objects as per the requirement. Involved in field mappings for all the interfaces.
• Worked on the development of Interfaces, Data Conversions, Developing & customizing Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM.
• Solution the Sales Order and Standard PO interfaces from legacy system to Oracle. Design and developed CDH and SDH interfaces from legacy system to Oracle.
• Design and developed Real Time Interfaces for Customer Data Hub (CDH) and Supplier Data Hub (SDH) using Workflow Business Events. Design and extended PO workflow for email notification.
• Design and extended iProcurement and EAM OAF pages.
• Hiding fields and ordering fields in work order, work request search results screen using form personalization
• Displaying additional fields in work order, work request search results screen using VO extension. Defaulting Values in Work Request screen using Controller Extension
• Dynamically changing pick list Values based on value entered in another field using PPR and Controller Extension.
• Design and developed analytical reports and notifications using XML reports. Active involvement in all the phases i.e. development, CRP, UAT, go-live and post production support on all the areas which includes co-ordination and bug fixing.

Environment: Oracle Apps R 12.1.3, SQL, PL/SQL, Oracle 11g, TOAD, PL SQL Developer, BI Publisher, Workflow Builder, JDeveloper, EDQ, Oracle SOA, BPEL. Modules: OM, INV, BOM, PO, eAM, MDM (CDH & SDH), AP, AR, GL.

Confidential, Houston, TX

Senior Oracle EBS Technical Consultant

Responsibilities:

• Solution the Data Quality and Data Cleansing tracks for Customer Data Hub (CDH). Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the CDH implementation.
• Liaise with the users on the functional requirement and customizations. Design and developed conversions for CDH. Design and developed Real Time Interfaces for CDH using Workflow Business Events.
• Active involvement in all the phases i.e. development, CRP, UAT, go-live and post production support on all the areas which includes co-ordination and bug fixing.
• Prepared most of the AIM Technical documents for requirements, design, and implementation steps with data conversions and test plans for all the phases of the project.

Environment: Oracle Apps R 12.1.3, SQL, PL/SQL, Oracle 11g, TOAD, PL SQL Developer, ODI, EDQ, EDQP. Modules: PDH, CDH

Confidential, North Venice, FL

Senior Oracle EBS Technical Consultant

Responsibilities:

• Understand the requirements by studying functional document. Design, Customization and development of the Objects as per the requirement.
• Liaise with the users on the functional requirement and customizations. Worked on the development of Interfaces, Data Conversions, Developing & customizing Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM.
• Design and developed conversions for Inventory Items, Primary BOM, Sales Order and PO. Customized Sales Order workflow as per requirement.
• Developed BI Templates for Standard Purchase Order, AP Check Print Report and Positive Pay File. Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Prepared most of the AIM Technical documents for requirements, design, and implementation steps with data conversions and test plans for all the phases of the project.

Environment: Oracle Apps R 12.1.3, SQL, PL/SQL, Oracle 11g, TOAD, PL SQL Developer, BI Publisher. Modules: AP, AR, GL, PO, INV, OM

Confidential

Senior Oracle EBS Technical Consultant

Responsibilities:

• Understand the requirements by studying functional document. Design, Customization and development of the Objects as per the requirement.
• Liaise with the users on the functional requirement and customizations. Developed AGIS (Advanced Global Intercompany System) Interface from legacy system for Travel Expense.
• Developed and Customized XML Reports in Finance modules. Retrofitted custom 11i rdf and XML reports to R12.
• Developed Funds Consumed/Available detail XML report. Developed PO Cancellation Bursting XML Report. Created Packages and Patches using ACMP for migration.
• Developed OAF personalization and extensions for iProcurement to default attachment category, clear form fields when “Add to Cart” button is pressed, hide change button and add validation on cancel button in Requisitions page for PO linked to requisition.
• Retrofitted customized PO Approval, PO Document Create workflows. Unit testing and System integration testing. Preparation of installation files. Migrating and installing code to higher instances.
• Involved in the maintenance and support of existing applications with the users. Raised Oracle SR’s for seeded product related issue and proactively followed to bring them to closure.
• Handled all the issues during the development phase of the project for PPB2, CRP, UAT1, and UAT2. Worked in the production support to debug and fix the issues in quick time frames. Performed code reviews.
• Development of Technical Design (MD070), Test Case Documents (TE020) and Installation Document (MD120) and installation files.

Environment: Oracle Apps R 12.1.3, SQL, PL/SQL, Oracle 11g, TOAD, PL SQL Developer, BI Publisher. Modules: GL, AP, AR, AGIS, FA, CM

Confidential

Senior Oracle EBS Technical Consultant

Responsibilities:

• Understand the requirements by studying functional document. Design, Customization and development of the Objects as per the requirement.
• Involved in creation of XSD, BPEL process design and implementation, deployment of BPEL processes in Weblogic server, testing of these BPEL processes using BPEL console.
• Created Web services using DB adapter, FTP adapter, File adapter and Oracle APPS adapter. Also, was involved in creation of XSLT mapper file as a part of BPEL process using JDEVELOPER 11.1.1.3.
• Modules: HRMS

Environment: Oracle Fusion Middleware 11g (11.1.1.3), SOA, BPEL, Oracle 11g, JDeveloper

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Analysis of business process and transform to oracle functional application process. Prepared BP100 and MD50/MD70 for project implementation.
• Liaise with the users on the functional requirement and customizations. Design, Customization and development of the Objects as per the requirement.
• Involve in the preparation of test data. Interaction with the onsite people and resolving the offshore issues. Attend weekly status meetings and provide detailed status report to the client.
• Developed XML reports on AP, GL, CM. Developed OTL (Oracle Time & Labor) - Timekeeper Form Interface using Web ADI.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures and reports. Wrote SQL scripts to create staging tables and developed SQL*LOADER Control files to load the legacy data into the staging tables
• Migrated and installed code components in higher instances. Participations in the code reviews and Technical design reviews.
• Worked actively to troubleshoot defects and problem during CRP and UAT testing. Performed Post-Production support post Go-Live.

Environment: Oracle Apps R 12.0.4, SQL, PL/SQL, Oracle 10g, TOAD, PL SQL Developer, BI Publisher. Modules: AP, AR, GL, CM

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Worked on Service Requests raised to Oracle Metalink. This involves investigations/Research on the issue and online client meetings (Web Conferences) to understand the exact problem which help to provide quick resolution.
• Issues were reproduced on internal instances and based on investigations Data fixes / Bug fixes / Setup fixes are suggested to the customer.
• Analyzed and resolved performance related issues using Tkprof and SQL Trace. Analyzed and resolved issues related to forms/reports/interfaces/concurrent programs using traces (Database traces - level 4, 8, 12 and FRD trace) and debug logs.
• Analyzed and resolved issues related to ORA-, FRM- and APP- errors. Troubleshooting diagnostic scripts like AP List, Database Initialization Parameters, Accounting Diagnostic Test, CCID Research script, etc.
• Worked on issues related to Invoices, Payments, Accounting, Period Close exceptions, Suppliers and integration of AP with other modules like PO and GL. Suggested customer how to create expense report using Oracle iExpenses.

Environment: Oracle Apps 11i & R12, SQL, PL/SQL, Oracle 10g, TOAD, PL SQL Developer. Modules: AP

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Developed and Customized Reports and Interfaces as per customer business requirement. Interaction with the onsite people and resolving the offshore issues.
• Attend weekly status meetings and provide detailed status report to the client. Involved in requirement analysis, gap analysis for customizations by interacting with end users.
• Provide training to global helpdesk representatives regarding usage of the tool. Post production release validations and assistance and addressing UAT issues along with user interaction.
• Developed Custom Partial Cancel FORM to cater the needs of NEW. The form is used to cancel the partial amount of the gift card or voucher issued to the customer. This involves forms development using triggers and procedures and registering them in specific modules.
• Developed Query Find form for above. Interface - Payables Open Interface. Created Customer using TCA API. These APIs utilize the new TCA model, inserting directly to the HZ tables.
• Production Support on CRM modules. Developed data fix scripts for production issues. Prepared change request documentation and unit test plans. Performed unit testing and system integration testing.
• Logged service requests with Oracle and worked with Oracle in resolution of Applications Software defects.

Environment: Oracle Apps R 11.5.10.2, SQL, PL/SQL, Oracle 10g, TOAD, PL SQL Developer, Reports 6i. Modules: AP, GL, SC, IB, INV

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Developed and Customized Reports and Interfaces as per customer business requirement.
• Interface - GL Interface and AP Invoice Interface. Developed AR Transaction Interface which validates transaction information and loads the transaction into AR seeded tables.
• Developed SQL*LOADER Control files to load the legacy data into the staging tables. Developed Invoice Reports (Pre-printed Invoice).
• Developed PL/SQL script to release AP invoice holds when corresponding AR invoice is cleared. Created an Alert to notify the manager whenever new items are created in inventory.
• Personalized oracle standard receivables form to add a menu entry show credit card, when user clicks on this menu option the credit card number is showed to the user.
• Involved in performance tuning. Task involved is to identify the long running programs and tune them so that performance of the system is improved.
• Troubleshooting and providing the fixes to the Production issues. Based on analysis causes were identified and resolved. The resolutions were in the form of Data Fixes or Setup Fixes.
• Developed PL/SQL Stored Procedure Executable Reports. System Integration Testing (SIT)and Sanity checking. Preparation of technical design documents, Unit test scripts and Installation documents.

Environment: Oracle Apps 11.5.9, SQL, PL/SQL, Oracle 10g, TOAD, PL SQL Developer, Reports 6i. Modules: AP, AR, GL