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 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 Confidential and HDFC 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.me.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 .
• 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

Sr Software Engineer

Responsibilities:

• Designed and Developed teh critical AP Invoice Workflow
• Involved in Coordination Process across multiple shores to ensure teh timely delivery of teh objects.
• Worked as a configuration manager. Key Responsibility being maintain teh 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 teh form of database objects like stored procedure, packages, etc.
• Optimized teh client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Oracle ADF, etc.
• Developed teh Form Personalization on various P2P Modules Forms
• Developed teh PL/SQL queries to share teh system information with teh high level management of teh client for analysis purpose

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

Confidential

Oracle EBS Sr Consultant/Tech Lead

Responsibilities:

• Lead teh Technical Team in Delivery of Objects in Different Regions like APAC EMEA and US
• Involved in Coordination Process across multiple shores to ensure teh timely delivery of teh objects.
• Worked as a configuration manager. Key Responsibility being maintain teh code repository and migration along with role assignment to developers.
• Managed teh 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 teh form of database objects like stored procedure, packages, etc.
• Optimized teh client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Discoverer Reports and SOA objects.
• Designed and developed teh 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 teh Oracle EBS system based on teh status of teh item in teh KANBAN System.
• Designed and Developed teh Report Layout and Data Model on 11i and R12 oracle modules like PO, AP, OM, AR, INV, WIP, BOM, Routing and MFG
• Developed teh common data loader program to load teh data from any data file into teh transaction specific staging table using Unix shell script with teh functionality to archive teh data file.
• Developed teh Common Attachment Migration Program to migrate teh attached files from legacy system to Oracle
• Developed teh Project Budget Approval Mechanism based on teh project budget and teh role of teh employee in teh project. It includes customization of Budget Workflow and Development of Oracle Custom Form from teh scratch. me had also customized teh Project Account Generator, Project Approval Workflow and OM Workflow (OEOH and OEOL)
• Enhanced one of teh most complex tool titled ‘Commercial Invoice’ to meet teh client requirement. Enhancement involves query optimization, maintenance of Oracle custom forms and reports.
• Designed and Delivered teh PO Sourcing Tools. Teh Tool halps teh client to automate teh creation of PO Sourcing Rules and generate teh report for successful and failed records.
• Developed and Maintained teh Check Print Report in eText format, Payment Instruction Register, and Supplier Payment Report.
• Developed teh OAF Extensions and Form Personalization on various SCM Modules Forms
• Maintained teh Customer Routing Tools and Quote Tools. Teh extension includes maintenance of teh Oracle Forms, Interface Code and Reports.
• Maintained teh project matrix for teh quality analysis
• Developed teh PL/SQL queries to share teh system information with teh high level management of teh client for analysis purpose

Environment: and ToolsOracle 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 teh EBS setup for iStore Module
• Designed and Developed teh iStore Minisites, to include teh various item categories.
• Configured teh login Setup for iStore Users. It includes teh customer configuration, and login creation for teh end-user.
• Developed teh Complex PL/SQL Scripts as per business requirements for iStore objects. These scripts are created in teh form of database objects like stored procedure, stored functions, packages, etc. which are used in teh iStore JSP pages
• Optimized teh client queries using PL\SQL Tuning Techniques which are used in Oracle Forms, Discoverer Reports and client existing Codes
• Customized teh JSP pages for iStore Order page and summary page of user transactions.
• Configured teh AME setup for Quotation Module
• Designed and Developed teh Custom Oracle Form for various schemes and offers provided by teh client to its end-customer.
• Configured teh CRM Module Group for Regional and Local Level Head Setup.
• Designed and Developed JSP Reports for iStore Users
• Designed and developed teh Oracle Reports for Internal Sales Team.
• Document weekly SLA monitoring reports and support activity reports
• Provided teh Client for teh iStore user and iStore support team
• Developed teh Unix Shell Script to migrate teh custom objects into teh oracle instance
• Designed and Developed teh Report Layout and Data Model on 11i and R12 oracle modules like PO, AP, OM, AR, INV, WIP, BOM, Routing and MFG
• Developed teh OAF Extensions and Form Personalization
• Developed teh 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 teh Supplier Conversion, Supplier Bank Conversion, PO Conversions and AR Invoice Conversion. Teh system setup for AR Invoice conversion is also configured.
• Developed teh Complex PL/SQL Scripts as per business requirements for various Integration objects. These scripts are created in teh form of database objects like stored procedure, stored functions, packages, etc. which are used in interaction with 3rd party system
• Optimized teh 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 teh real time data from their Supplier Management System (SMS) into teh Oracle EBS
• Designed and Developed teh Oracle Form Personalization. It TEMPhas simplified various complex setups of teh legacy system.
• Developed teh OAF Extensions
• Customized teh PO Approval Workflow.
• Designed and developed teh Oracle Reports and XML Publisher Reports on Finance Module. (PO, AR, AP)
• Designed and Developed teh Custom Oracle Form to maintain teh 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 teh Complex PL/SQL Scripts as per business requirements for various Oracle objects. These scripts are created in teh form of database objects like stored procedure, stored functions, packages, etc. which are used in interface with 3rd party system
• Optimized teh client queries using PLSQL Tuning Techniques which are used in Oracle Reports, Discoverer Reports, and clients extensions
• Managed teh Data Migration for Oracle Modules like PO, AP, AR, OM, INV, WIP and BOM
• Developed teh common data loader program to load teh data from any data file into teh transaction specific staging table using Unix shell script.
• Developed teh Unix Shell Script to migrate teh custom objects into teh oracle instance
• Developed teh Form Personalization, OAF Extensions and Oracle Form on Modules like PO, AP, OM, INV, WIP and OPM
• Designed and Developed teh PO Approval Oracle Workflow and OM Workflow
• Designed and Developed teh 40+ Report Layouts and Data Model on Oracle Modules (PO, AR, AP, GL, OM, INV, BOM, WIP, OPM, BOM, etc.)
• Single-handedly delivered teh 50 Discoverer Reports on Oracle Modules. It includes development of Views for Oracle Discoverer Report as well as layout of Discoverer Reports.
• Developed teh Basic Oracle Alerts to send teh messages to teh client outlook
• Developed one of teh most complex tool titled ‘Commercial Invoice’ to meet teh client requirement. Enhancement involves form personalization and report developments
• Developed teh OAF Extensions and Form Personalization
• Developed teh PL/SQL queries to share teh system information with teh high level management of teh 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 teh Oracle Modules like PO, AP, INV, BOM and WIP
• Developed teh Complex PL/SQL Scripts as per business requirements for various Oracle objects. These scripts are created in teh form of database objects like stored procedure, stored functions, packages, etc. which are used to interface with 3rd party system
• Optimized teh client queries using PL\SQL Tuning Techniques which are used in Oracle Reports and clients extensions
• Developed an extension object to move teh data from teh 11i system to R12 on ad-hoc basis.
• Developed enhancements using Form Personalization and Form Customizations
• Developed teh OAF Extension
• Developed a new custom form to maintain teh Discount ratio for customers.
• Customized teh Oracle Reports on modules like PO, AP, AR, GL, OM, INV, WIP and BOM as per data model in R12.
• Customized teh 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 teh Report Layout and Data Model on R12 oracle modules like PO, AP, OM, AR, and INV
• Developed teh Form Personalization requirement, OAF Extensions and Oracle Form Development.
• Designed and developed teh PO Approval Workflow and PO Account Generator.
• Designed and developed teh 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 teh Unix Shell Script to migrate teh custom objects into teh oracle instance
• Coding, Unit Testing and peer reviewing according to technical specification
• Developed teh PL/SQL queries to share teh system information with teh high level management of teh 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

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Managed teh Data Migration for teh Oracle Modules like PO, AP, AR and INV
• Designed and Developed teh Report Layout and Data Model on R12 oracle modules like PO, AP, CRM, AR, and INV
• Developed teh Form Personalization requirement, OAF Extensions and Oracle Form Development.
• Developed teh Self Service HR Workflow
• Developed Discoverer Reports on Oracle Modules like PO and AP
• Developed teh Unix Shell Script to migrate teh custom objects into teh oracle instance
• Mentor teh team members in teh implementation.
• Coding, Unit Testing and peer reviewing according to technical specification

Environment: and Tools Oracle Applications R12, SQL Developer, Oracle Report, XML Publisher Reports, Oracle Workflow

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Developed teh Complex PL/SQL Scripts in teh form of database objects like stored procedure, stored functions, packages, etc. using PL\SQL Tuning Techniques which are used in Oracle Reports, Oracle Custom Forms, Custom.PLL and Workflows, Bug Fix on Oracle Forms, Oracle Workflow, Form Personalization.
• Managed teh Data Migration for teh Oracle Modules like PO, GL, AP, AR and INV
• Developed teh Form Personalization requirement, OAF Extensions and Oracle Form Development.
• Designed and developed teh various Report Layouts and Data Model on PTP, OTC and PTM Modules (PO, AR, AP, GL, INV, etc.)
• Developed teh Unix Shell Script to migrate teh custom objects into teh oracle instance
• Performed Unit Testing of various objects in teh Project.
• Prepared teh Technical Documents for teh requirement.

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