SUMMARY:

• Certified Professional with 8+ years of experience in technical aspects of Oracle Applications.
• Implementation and technical expertise in Oracle Applications 12i/11i, which includes Both OTC & PTP cycles .
• Strong technical development skills on RICE components (Reports, Interfaces, Customizations & Extensions).
• Good Knowledge on Order to Cash (OTC), Procure to Pay (PTP) process .
• Experience in Application System Administration like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, printers and providing support to business users for any technical and functional issues.
• Strong programming knowledge in creating SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers and API.
• Exposure to UNIX shells scripting and Worflow.
• Experienced in Data Mapping , Data Conversions and Interfacing .
• Strong knowledge on interface programs to import data and convert data from legacy systems.
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation.
• Extensively worked on Reports 6i/10g & XML Publisher
• Experience in using the tools like TOAD and SQL Developer for Ad - Hoc Query development and database objects creation.
• Provided support for SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Support.
• Experience in creating, managing and resolving SR (Technical Assistant Request/ Service Request) with oracle support, managed and monitored TAR’s for several P1 issues.
• Expertise using oracle software for applications design, development in a single and Multi-Org, Multi-Currency environments.
• Extensively worked on AIM ( Application Implementation Methodology ) documents like MD50, MD70 and MD120 .
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• Demonstrated good leadership skills with inspirational attitude with result oriented approach.

PROFESSIONAL EXPERIENCE:

CONFIDENTIAL

Technical Architect

Responsibilities:

• Oracle R12 Technical Consultant responsible to work on PTP and OTC RICE (Reports, Interfaces, Conversion & Extensions) Components, New Enhancements and Handling Service Now Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Oracle Applications Finance AR, AP and SCM Modules (PO, INV, OM, Shipping)
• Involved in the design documents (MD20, MD60 & MD120) for all the RICEW (Reports, Interfaces, Conversions & Extension ) Objects.
• Imported Sales Order from legacy system into Oracle Order Management (OM) base tables using the API.
• Involved in the development of Purchase Order interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Developed XML reports for stuck records in OM and INV tables and notify the same by sending email whoever submitted the request
• Worked on business event to update customer (attributes at account level) by creating Business events subscription.
• Developed WIP balance report for the WIP jobs which are in completed and Released status by using XML Publisher.
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Developed an Interface to perform account aliase Issue/receipt for the Inventory transaction types 'PO Receipt','PO Rcpt Adjust','Return to Vendor' and ‘WIP Completion’.
• Developed an Interface to load the data from multiple files (Service contract data files) into staging tables by using CTL(SQL Loader) and Unix Shell script.
• Worked on FAH to import the data from AR and post it to GL through sub ledger accounting program by using API.
• Developed outbound interface in INV to generate the data into a dat file and send it to third party system.
• Developed Item Categories Conversion.
• Designed and developed PL/SQL concurrent programs, Oracle reports and shell script.
• As part of support, worked on bug fixes and enhancements and resolved major issues.
• Designed and developed custom packages, triggers and procedures.

Environment : Oracle Applications R12(12.0.3, 12.2.3 and 12.2.5) FIN and SCM Modules (AR, OM & PO), PL/SQL, TOAD, SQL Plus, SQL Loader, Oracle Reports 10g, RTF Reports, UNIX Shell scripting.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Oracle R12 Techno Consultant responsible to work on PTP and OTC RICEW (Reports, Interfaces, Conversion, Extensions and Workflow) Components, New Enhancements and Handling P1-P4 JIRA Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules Account Receivables (AR)
• Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD70) for all the RICEW (Reports, Interfaces, Conversions, Extension and Workflow) Objects.
• Developed Conversion Programs to import Customers into Oracle Order Management using Trading Community Architecture (TCA) API’S.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Work Flow Approval Management Engine (AME) Process.
• Designed and developed custom packages, triggers and procedures.
• Designed and developed PL/SQL concurrent programs, Oracle Forms, Oracle reports.
• Tested and fixed the bugs in exiting forms and reports.
• Facilitate CRP (Conference Room Pilots), SIT (System Integration Testing), and UAT (User Acceptance Testing).
• Developed custom DB objects and AOL objects t for the project.

Environment: Oracle Applications R12(12.1.3) FIN, PL/SQL, TOAD, SQL Plus, SQL Loader

Oracle EBS Technical Consultant

Confidential

Responsibilities:

• Critical process design and validations in Procure to Purchase cycle
• Involved in customizing reports and interfaces.
• Worked as techno functional consultant in resolving the tickets raised by the users and respnonsible for enhancements for OM and AR.
• Involved to fix the issues in Interfaces, custom Reports, workflow and Alerts.
• Responsible for solving the Production issues within the time.
• Responsible for creation of the AOL Objects, SQL Files from development instance to prior production instance.
• Participated in change control board meetings to approve/reject the bug fix components.
• Involved in Conference calls for faster resolution on few issues.
• Designed and developed custom packages, triggers and procedures as part of enhancements

Environment: Apps Supporting Release 11i (11.5.10.2), Finance (FIN) and Supply Chain Management (SCM) Modules: PO, OM, INV, SQL, PL-SQL, Reports 6i, SQL plus & TOAD

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Worked as team member in the offshore technical Support in team.
• Worked as team member in the offshore technical development team.
• Responsible for technical deliverables - Data Interfaces.
• Developed XML payloads for the BPEL Process Manager.
• Testing, analyzing and resolving of issues while testing the objects
• As part of support, worked on bug fixes and enhancements and resolved the issues.
• Designed and developed custom packages, triggers and procedures

Environment: Oracle Applications Release 11i (11.5.10.2), Finance & Supply Chain Management (SCM) Modules, SQL,PL/SQL, TOAD, Reports 6i,WINSCP and Putty.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Providing Technical help desk services.
• Service request monitoring.
• Planning the Knowledge transfer phase both internally and externally.
• Ensuring compliance to Oracle delivery standards.

Environment: Oracle Applications Release 11i (11.5.10.2), Supply Chain Management (SCM) Modules, SQL,PL/SQL, TOAD, Windows XP.

Graduate Engineer Trainee

Confidential

Responsibilities:

• Developing the software for the microcontroller (ARM 7TDMI).
• Modification of the code as per the bugs found during testing.
• Involved in the fixing of the problems at field

Environment: KEIL Vision3. Windows XP.