SUMMARY:

• 9 Years 2 months of IT experience on Oracle Applications (E - Business Suite) 11i (11.5.10,11.0.3), R12i (12.2.5, 12.1.3, 12.0.4, 12.0.6,)
• Oracle Certified Expert in Workflow Implementation (OCE), Oracle Certified Associate (OCA) in PL/SQL
• Multiple project experience involving Implementation, Upgrade, Customizations, Re-implementation, Enhancements, Support and Solutions
• Programming and Applications Development experience using Oracle 8i/9i/10g/11g, Forms 6i/9i, Reports 6i/9i, BI Publisher report, PL/SQL, Java and Oracle Workflow
• Excellent knowledge of Oracle Schema and Tables for 11i and R12
• Four Full Life Cycle Implementation Experience of Oracle Finance, Advanced Pricing, Supply Chain Management, Manufacturing (OPM, Discrete, Flow Manufacturing, etc.) and Inventory for Confidential, Donaldson, Dorf Ketal and LBC
• One Full Life Cycle Implementation Experience of Oracle iStore Module for Confidential .
• Two-upgrade Projects Experience from Oracle 11i to Oracle EBS R12 for Narang Group and Confidential
• Two-Reimplementation Project Experience from Oracle 11i to Oracle EBS R12 for G3 Councils and Confidential AMC
• Support for 7 Different Projects (WNS, Integreon, Janak Healthcare, SACL, BERR, McDonald. IDBI Federal)
• Good Functional Knowledge of Modules (PO, AP, AR, GL, OM, OE, OPM, INV, BOM, WIP, iStore).
• Experience in developing R.I.C.E components for Financials, Manufacturing, Supply Chain and Inventory Modules.
• Exposure with roles and responsibilities of Team / Module Leading, Onsite-Offshore Coordination, Development and Customization, Excellent knowledge of software quality processes and documentation.
• Exposure in providing end user training.
• Hands on experience in preparing MD70,CV40, CV60 and MD120.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i

Languages: PL/SQL, Java

Oracle EBS Version: R12 (12.2.4, 12.1.3, 12.0.4, 12.0.6), 11i (11.5.10)

Oracle Applications Modules: PO, AP, OM, AR, GL, MFG, WIP, BOM, Routing, OPM, INV, iStore

Oracle Tools / Components: Oracle Forms, Oracle Reports, Oracle Workflow, BI Publisher Reports, Workflow Business Events, Workflow Builder 2.6, SQL *Plus, SQL *Loader, Oracle Discoverer 10g, JDeveloper 9i, OA Framework, SOA, ADF, Kintana, WinScp, Unix, SQL Developer, Unix Shell Script

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Senior Software Engineer

Responsibilities:

• Designed and Developed the critical AP Invoice Workflow
• Involved in Coordination Process across multiple shores to ensure the timely delivery of the objects.
• Worked as a configuration manager. Key Responsibility being maintain the code repository and migration along with role assignment to developers.
• Develop Complex PL/SQL Scripts to meet business requirements for analytical purpose, auditing purpose and reporting purpose. These scripts are created in the form of database objects like stored procedure, packages, etc.
• Optimized the client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Oracle ADF, etc.
• Developed the Form Personalization on various P2P Modules Forms
• Developed the PL/SQL queries to share the system information with the high level management of the client for analysis purpose

Environment: and Tools: Oracle Applications R12, PL\SQL Developer, WINSCP, JDeveloper, Workflow, Oracle Form, WINSCP, Kintana and Unix

Confidential

Oracle EBS Sr Consultant/Tech Lead

• Lead the Technical Team in Delivery of Objects in Different Regions like APAC, EMEA and US

• Involved in Coordination Process across multiple shores to ensure the timely delivery of the objects.
• Worked as a configuration manager. Key Responsibility being maintain the code repository and migration along with role assignment to developers.
• Managed the Master Data Migration and Transaction Data Migration on various Oracle Modules like PO, AP, AR, OM, INV, WIP and BOM for US, EMENA and APAC plants. Data Conversions like Employee, Supplier, Supplier Bank, PO, PO receipt, Customer, Customer Bank, Sales Order, AR Invoices, Inventory Item, Item Cost, Item Category, CPN, Price List, BOM, Routing and WIP
• Develop Complex PL/SQL Scripts to meet business requirements for analytical purpose, auditing purpose and reporting purpose. These scripts are created in the form of database objects like stored procedure, packages, etc.
• Optimized the client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Discoverer Reports and SOA objects.
• Designed and developed the framework and code for integration of KANBAN System used with Oracle EBS. It includes creation of PO, ASN, PO Receipt, Stock Transfer, WIP Job Creation and WIP Job Completion in the Oracle EBS system based on the status of the item in the KANBAN System.
• Designed and Developed the Report Layout and Data Model on 11i and R12 oracle modules like PO, AP, OM, AR, INV, WIP, BOM, Routing and MFG
• Developed the common data loader program to load the data from any data file into the transaction specific staging table using Unix shell script with the functionality to archive the data file.
• Developed the Common Attachment Migration Program to migrate the attached files from legacy system to Oracle
• Developed the Project Budget Approval Mechanism based on the project budget and the role of the employee in the project. It includes customization of Budget Workflow and Development of Oracle Custom Form from the scratch. I had also customized the Project Account Generator, Project Approval Workflow and OM Workflow (OEOH and OEOL)
• Enhanced one of the most complex tool titled ‘Commercial Invoice’ to meet the client requirement. Enhancement involves query optimization, maintenance of Oracle custom forms and reports.
• Designed and Delivered the PO Sourcing Tools. The Tool helps the client to automate the creation of PO Sourcing Rules and generate the report for successful and failed records.
• Developed and Maintained the Check Print Report in eText format, Payment Instruction Register, and Supplier Payment Report.
• Developed the OAF Extensions and Form Personalization on various SCM Modules Forms
• Maintained the Customer Routing Tools and Quote Tools. The extension includes maintenance of the Oracle Forms, Interface Code and Reports.
• Maintained the project matrix for the quality analysis
• Developed the PL/SQL queries to share the system information with the high level management of the client for analysis purpose

Environment: and Tools: Oracle Applications R12, BI Publisher Reports, PL\SQL Developer, WINSCP, JDeveloper, Java Decompiler, Workflow, Oracle Form, Oracle Report, WINSCP, Kintana and Unix

Confidential

Sr. Oracle EBS Technical Consultant

Responsibilities:

• Configured the EBS setup for iStore Module

• Designed and Developed the iStore Minisites, to include the various item categories.
• Configured the login Setup for iStore Users. It includes the customer configuration, and login creation for the end-user.
• Developed the Complex PL/SQL Scripts as per business requirements for iStore objects. These scripts are created in the form of database objects like stored procedure, stored functions, packages, etc. which are used in the iStore JSP pages
• Optimized the client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Discoverer Reports and client existing Codes
• Customized the JSP pages for iStore Order page and summary page of user transactions.
• Configured the AME setup for Quotation Module
• Designed and Developed the Custom Oracle Form for various schemes and offers provided by the client to its end-customer.
• Configured the CRM Module Group for Regional and Local Level Head Setup.
• Designed and Developed JSP Reports for iStore Users
• Designed and developed the Oracle Reports for Internal Sales Team.
• Document weekly SLA monitoring reports and support activity reports
• Provided the Client Training for the iStore user and iStore support team
• Developed the Unix Shell Script to migrate the custom objects into the oracle instance
• Designed and Developed the Report Layout and Data Model on 11i and R12 oracle modules like PO, AP, OM, AR, INV, WIP, BOM, Routing and MFG
• Developed the OAF Extensions and Form Personalization
• Developed the Project Account Generator and OM Workflow (OEOH and OEOL)

Environment: and Tools: Oracle Applications R12, Oracle Reports, Java Decompiler, JDeveloper, Oracle Form, Oracle workflow, SQL Developer

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Developed the Supplier Conversion, Supplier Bank Conversion, PO Conversions and AR Invoice Conversion. The system setup for AR Invoice conversion is also configured.

• Developed the Complex PL/SQL Scripts as per business requirements for various Integration objects. These scripts are created in the form of database objects like stored procedure, stored functions, packages, etc. which are used in interaction with 3rd party system
• Optimized the client queries using PL\SQL Tuning Techniques which are used in Oracle Reports, Discoverer Reports, and Oracle Form Personalization
• Developed Interface for Supplier Master and Supplier Invoices, etc. Due to this interface, it is possible to retrieve the real time data from their Supplier Management System (SMS) into the Oracle EBS
• Designed and Developed the Oracle Form Personalization. It has simplified various complex setups of the legacy system.
• Developed the OAF Extensions
• Customized the PO Approval Workflow.
• Designed and developed the Oracle Reports and XML Publisher Reports on Finance Module. (PO, AR, AP)
• Designed and Developed the Custom Oracle Form to maintain the record of their Mutual Funds and other investment schemes.

Environment: and Tools: Oracle Applications R12, SQL Developer, Oracle Report, XML Publisher Reports, JDeveloper, Java Decompiler

Confidential

Sr. Oracle EBS Technical Consultant

Responsibilities:

• Developed the Complex PL/SQL Scripts as per business requirements for various Oracle objects. These scripts are created in the form of database objects like stored procedure, stored functions, packages, etc. which are used in interface with 3rd party system

• Optimized the client queries using PLSQL Tuning Techniques which are used in Oracle Reports, Discoverer Reports, and clients extensions
• Managed the Data Migration for Oracle Modules like PO, AP, AR, OM, INV, WIP and BOM
• Developed the common data loader program to load the data from any data file into the transaction specific staging table using Unix shell script.
• Developed the Unix Shell Script to migrate the custom objects into the oracle instance
• Developed the Form Personalization, OAF Extensions and Oracle Form on Modules like PO, AP, OM, INV, WIP and OPM
• Designed and Developed the PO Approval Oracle Workflow and OM Workflow
• Designed and Developed the 40+ Report Layouts and Data Model on Oracle Modules (PO, AR, AP, GL, OM, INV, BOM, WIP, OPM, BOM, etc.)
• Single-handedly delivered the 50 Discoverer Reports on Oracle Modules. It includes development of Views for Oracle Discoverer Report as well as layout of Discoverer Reports.
• Developed the Basic Oracle Alerts to send the messages to the client outlook
• Developed one of the most complex tool titled ‘Commercial Invoice’ to meet the client requirement. Enhancement involves form personalization and report developments
• Developed the OAF Extensions and Form Personalization
• Developed the PL/SQL queries to share the system information with the high level management of the client for analysis purpose on Oracle Schemas and Tables
• Coding, Unit Testing and peer reviewing according to technical specification

Environment: and Tools: Oracle Applications R12, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, PL/SQL, WINSCP, Unix and TOAD.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Data Migration for the Oracle Modules like PO, AP, INV, BOM and WIP

• Developed the Complex PL/SQL Scripts as per business requirements for various Oracle objects. These scripts are created in the form of database objects like stored procedure, stored functions, packages, etc. which are used to interface with 3rd party system
• Optimized the client queries using PL\SQL Tuning Techniques which are used in Oracle Reports and clients extensions
• Developed an extension object to move the data from the 11i system to R12 on ad-hoc basis.
• Developed enhancements using Form Personalization and Form Customizations
• Developed the OAF Extension
• Developed a new custom form to maintain the Discount ratio for customers.
• Customized the Oracle Reports on modules like PO, AP, AR, GL, OM, INV, WIP and BOM as per data model in R12.
• Customized the Oracle Discoverer Reports as per data model in R12.

Environment: and Tools: Oracle Applications R12, SQL Developer, Oracle Report, XML Publisher Reports, Discoverer Desktop, Discoverer Administration, Oracle Forms

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Designed and Developed the Report Layout and Data Model on R12 oracle modules like PO, AP, OM, AR, and INV

• Developed the Form Personalization requirement, OAF Extensions and Oracle Form Development.
• Designed and developed the PO Approval Workflow and PO Account Generator.
• Designed and developed the various Report Layouts and Data Model on PTP, OTC and PTM Modules (PO, AR, AP, GL, OM, WSH, INV, etc.)
• Developed Discoverer Reports on Oracle Modules like PO and AP
• Developed the Unix Shell Script to migrate the custom objects into the oracle instance
• Coding, Unit Testing and peer reviewing according to technical specification
• Developed the PL/SQL queries to share the system information with the high level management of the client for analysis purpose on Oracle Schemas and Tables

Environment: and Tools: Oracle EBS R11i, Oracle EBS R12, TOAD, Oracle Report, Discoverer Reports, Workflow, Jdeveloper and Oracle Forms