SUMMARY:

• Over 12+ 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).
• Technical activities include Interfacing with users, identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, scheduling, producing documentation and providing production support.
• 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.
• 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

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, CA

 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 Concur Expense Report interface to Oracle AP.
• Business Process - customer will act as an agent, buy product and stock in his inventory. Sell product to end customer on our behalf and get commission. Design and developed end to end process. Standard order creation and AR invoicing for customer A. Once he sells to B he will send an EDI file. We will create return order and credit memo for A and standard order and invoice for B.
• 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, Columbus IN

 Lead Oracle EBS Technical Consultant

Confidential

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 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 ( Confidential Invoice, Packing Slip, Bill of Ladding 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,Blytheville AK

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 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 Confidential 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 My 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, 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