PROFESSIONAL SUMMARY

• Having 10 years of diversified IT experience in Oracle Implementation and applications Development.
• Extensive experience in Analysis, Design, Preparation of Specification, Development, Testing, Implementation and Production Support of Oracle E-Business Suite R12 12.1.3,12.2.4 , 11i.
• Experienced in configuration management and code migration tools PVCS, Clearcase Kintana
• Good exposure on design and development of RICE Components and involved in implementation and support projects.
• Very Good understanding on Functional flowsO2C P2Ptechnical architecture ofR12 INV, PO, BOM, WIP, OM, AP and Oracle Configurator.
• Worked on the development of Template based reporting tool like XML Publisher and Discoverer.
• Involved in Customization of Standard Oracle Workflow.
• Strong experience in RDBMS 10g and 11g and experience in tools like Oracle D2k, PL/SQLDeveloper, Forms 6i/10g/11g, Reports 6i/10g, Oracle10g/11g under Windows XP/2007
• Worked on Oracle APEX for creating triggers and for data insersion into tables.
• Documents MD50'S , technical specifications MD70'S , statements of problems to detailed logical flow charts for coding into Oracle applications.
• Developed inbound and Outbound interfaces using SQL Loader, UTL FILEand PL/SQL Packages.
• Has extensive hands-on experience in developing database triggers, stored procedures, functions and packages.
• Developed Interfaces using APIs and Interface tables.
• Hands on experience in development, Customization of forms using CUSTOM.pll Oracle Discoverer.
• Experience with UNIX and Shell Scripts.
• Documentation experience, keeping in line with the AIM Methodology.
• Prepared the Cut over plan for GO-Live and taken the responsibility to move all the CEMLI objects to PROD.
• Upgraded multiple projects from 11i environment to R12.1.3.

Technical Skills

Modules SCM, Manufacturing, Finance.

Professional Experience.

Confidential

Designation: Designer and Developer

Role Responsibility:

• Created Sales order for warranty and extended warranty of a service Contract.
• Worked on Data flow from Order management to Service Contracts.
• Converted Sales Territory conversions from legacy to Oracle E-Business system R12.
• Worked on the Enrollment to Service which is business requirement in CCHS.
• Provided Customized API's for the Creation of CSI Instances, Service Contracts thru API's to acquire the business requirement.
• Worked on the BOM explosion and created the install base Instance.
• Service Contracts created for the Service Items and instances for Covered Products.
• Designed and solution Request to resolution flows using Oracle Field Service
• Analyzing the requirements.
• Prepare MD 70 for the SRS.
• Developed various new custom reports in AP and PO Modules.
• Define and set up DFF's using Application Developer responsibility for Purchase Order Header to identify Contract Retention Invoices.
• Created and customized reports using XML Publisher/BI Publisher in AP, PO, OM and INV.
• Developed SQL Loader and PL/SQL programs for data conversions.
• Developed Report to Print AR Transactions for Non-Standard Orders.
• AR Auto Invoice Import Program
• Worked extensively on Service Contracts xml Reports
• Customized Revenue Accounting Program
• Modified Balance forward Billing program to show the customer contact information in the Report.
• Created new Discoverer workbooks based on Client requirement.
• Involved in Customization of Standard PO Requisition Approval Workflow.
• Responsible in creating Value sets, Concurrent Program Definitions and Executable.
• Involved in developing XML Publisher Reports with Reports 6i.
• Developed Item Extract Outbound Interface.
• Create and define template and data definitions for Open Purchase Order report.
• Involved in debugging various interface related issues in AP and Order Management.
• Developed various Extensions and Personalization's in OM.
• Responsible to design various AIM document deliverable MD050, MD070, functional, and technical documents.
• Designed reports in PO, OM,AR and AP modules using Reports 6i, Discoverer. XML publisher.
• Creation of functional specification documents, wherever required explaining the functionality and facilitate the client and identified the key areas and products functionalities.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Good development of workflow components using Oracle Workflow Builder.
• Migration of legacy data to oracle using SQL Loader and UTL FILE utilities.
• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionalities.
• Tuning and Performance Improvement of SQL Queries.
• Experience with UNIX and Shell Scripts.

Environment: Oracle Apps R12 OM, INV, AP,AR,PO, BOM ,Service Contracts, modules, SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Position: Technical Lead

Roles Responsibility:

• Responsible for all RICEW deliverables.
• Gathering requirements and preparing MD 50, MD 70.
• Involved in performance tuning of sql queries.
• Gathering requirements from client.
• A regular meeting with SME's to get the SBOM data.
• Assigning tasks to the team.
• We analyze specifications that are provided by engineering team.
• The specifications contain requirements about the Alloy metals.
• Based on requirements provided in the specifications we prepare model structure and create Configurator extension rules.
• Make a valid configuration and create a quote for the end user.
• Worked in Configurator extensions.
• Extensive experience in Configure-to-Order Implementation which includes Setups parameters, Profiles etc. , Creating and process the configurations, Order changes and returns, Updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in cz schema ,PopulatingCZ SCHEMA,Migrating,Data,SynchronizingData,CZ SCHEMAMaintenance,Integration,API's involved in Configurator development.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Worked on complex configurator models.
• Worked on complex functionality ATP dates in configurator.
• Review of functional documents for technical feasibility.
• Preparing technical designs as per AIM methodology and development of code, preparing Unit Test Scripts documents, issue resolution.
• Validated data collection templates for PTO models. Defining Structure, Rules and User Interfaces for the models in Oracle Configurator.
• Tested the models to ensure the models are as per data collection templates.
• Validated the Model Structure and accuracy of the Configuration Template.
• Designing the QP Template which is an essential part of developing the Model.
• Building Models and Preparing Unit Test Documents.
• Unit Test Execution.
• Resolving Post work Issues.
• Worked on General ledger xml reports

Environment:Oracle Apps R12 OM, INV, WMS, WIP, BOM modules, XML Publisher, SQL, PL/SQL, Oracle Configurator Developer.

Confidential

Position: Developer

Roles Responsibility:

• Designed and developed custom conversions - Item Catalog Conversion and Item Conversion.
• Developedstored procedures and packages. Extensive experiencein PL/SQL coding.
• Worked with development of packages and procedures usingPL/SQL.
• Involved in debugging various OAF related issues and Enhancement requests OA Extensions .
• Designed to convert the legacy contracts data to seeded Oracle Service Contracts
• Worked on Lot Number Adopt Assign extension Program.
• Worked on Service Contract workflow customization to send notifications to the field service requester whenever any changes have been made in Service Contracts form.
• Understanding Functional Design and get the clarification, preparing technical design document based on AIM methodology standards.
• Developed reports using XML and BI Publisher.
• Developed new reports in Oracle R12 using10g report builder.
• Proposing solutions for the requirements and Involving in status calls.
• Registered Concurrent Programs and custom Applications using System Administration.
• Designed the Business process for Extended Warranty Process
• Designed and solution Request to resolution flows using Oracle Field Service.
• Test the developed code as per the cases given in FDD and fixing bugs.
• Designed MD070, TE20 and developed the code to meet the client's requirements MD120, for extracting the correct data to meet the client requirements.
• Worked extensively in XMLPublisher reports.
• Preparing Unit Test Plan and Installation Documents.

Environment:Oracle Apps R12 INV, PO, OM, AP,Service Contracts,Install Base, Oracle Reports, XML Publisher, SQL, PL/SQL.

Confidential

Position: Technical Consultant

Roles Responsibility:

• Analyzed the 11i version tableswhich are going to modify in the R12.
• Upgraded multiple projects from 11i environment to R12.1.3.
• Retrofitted changing the columns which are obsolete in 11i to R12 views In R12
• Performance tuning of the views.
• Prepared Build Notes and Unit Test Scripts for the respective objects.
• Involved in migrating the objects from one instance to other instances.1
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document.

Environment:Oracle Apps R12 OM, INV, WMS, WIP, BOM modules, XML Publisher, SQL, PL/SQL.

Confidential

Position: Technical Consultant

Roles Responsibility:

• Analyzing the requirements.
• Gathering requirements and preparing MD 50,MD 70.
• Designed and developed AP Invoice Inboundinterface.
• AP Invoice workflow customization.
• AP checks printing report.
• Corptax inbound interface.
• Developed SQL Loader and PL/SQL programs for data conversions.
• Have done Performance Tuning of some SQL Queries.
• Item On-Hand Quantity interface.
• Worked on AP Cash Management Payment Details report.
• VE AP Cash Management Payment Details FY09.
• VE AP Inv Creation date Greater than Invoice date.

Environment:Oracle Apps R12 AP, INV, SQL, PLSQL and Discoverer Admin and Discoverer Desktop Edition, TOAD and SQL Plus.

Confidential

Position: Technical Developer

Roles Responsibility:

• Worked on AP Supplier CRP Block Inbound Interface.
• Worked onItem Conversion.
• Handling issues related Interfaces.
• Developed reports using XML and BI Publisher.
• Extensively used AOL for registering concurrent programs, Value Sets,Flex fields creating users and assigning responsibilities to end users.
• Interacted with the end users and functional architects to meet the requirement.

• Environment:Oracle Apps R12 AP, INV, SQL, XML Publisher, PLSQL,TOAD,Winscp, Putty and SQL Plus.

Confidential

Position: Technical Developer

Roles Responsibility:

• Analyzing the requirements.
• Regular meetings with the business users.
• Gathering requirements and preparing MD 50,MD 70.
• Worked on FSR Service Request Representative Work Flow Extension.
• Worked onSO Acknowledgement Report.
• Worked onPO Conversion.
• Worked on Item Conversion.
• Worked on Form Personalization in OM.
• Developed reports using XML and BI Publisher.
• Preparing Solution Design Documents for the developments.
• Interacting with clients to get the requirements and support activities.
• Involved in regular Support Activities.
• Data Extraction on request raised by end user.
• Interacted with the end users to meet the requirements.

Forms:

• Designed and Developed Market Master.
• Designed and Developed Quote ADC.
• Designed and Developed Kitchen id.
• Designed and Developed Delete Functionality.

Environment:Oracle Apps R12 INV, SO,CRM,AR, SQL, PLSQL, XML Publisher,TOAD, Winscp, and SQL Plus and Putty.