SUMMARY:

• Certified Professional with 11 + years of experience in technical aspects of Oracle Applications EBS.
• Implementation and technical expertise in Oracle Applications R12/11i, which includes Both OTC & PTP cycles.
• Strong technical development skills on RICEW components (Reports, Interfaces, Conversions, Extensions & Workflow).
• Good Knowledge on Order to Cash (OTC), Procure to Pay (PTP) process.
• Experience in Application System Administration like managing 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.
• Experience in developing UNIX shell scripts, ISGs & WSDLs
• Good knowledge on OAF and SOA
• Experienced in Data Mapping, Data Conversions and Interfaces.
• Strong knowledge on interface programs to import 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, functional testing, System Integration Testing and Documentation.
• Extensively worked on Interfaces, Workflows, Reports 6i/10g XML Publisher
• Experience in using the tools like TOAD & SQL Developer for Ad - Hoc Query development and database objects creation and WINSCP& Putty to connect to server.
• Experiences in Providing 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.
• Experience is using the Version control tools Tortoise SVN & GIT
• 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.
• Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.

PROFESSIONAL EXPERIENCE:

Confidential, Louisville KY

Associate Technical Architect

Responsibilities:

• Analysis of the specifications provided by the functional team
• Design, Documents & Development
• Testing - Unit testing & Migration
• Responsible for overseeing the Quality procedures related to the project.
• Involved in the meetings with the client and in requirement gatherings.
• Involved in the Technical discussions with the client technical team.
• Responsible for the deliverables like conversions, interfaces, workflows and reports(10g&XML).
• Testing - unit testing & migration
• Responsible for creation of the AOL Objects, SQL Files from development instance to prior production instance.
• For conducting weekly status calls and sending weekly status update to client
• For helping the team whenever required and guide them accordingly.
• For release objects are ready as per release calendar dates and update the client if there is any change
• To setup calls with governance team (who will give the design and code review approval) on complex issues and provide the best solution based on the outcome of the meeting, to avoid last minute hick-ups.
• For planning and sharing the release dates based on the release calendar provided by the client.
• For sending the status update on monthly release object/Patches planned for the release
• For preparing and sending MD120 to client release manger before the CAB call and make the necessary changes after the CAB call if suggested.
• For raising Tickets/Change Request for UAT/PROD migration of objects/Patches which got approved in CAB call and update the team accordingly

Environment: Oracle Applications R12(12.0.3, 12.2.3,12.2.5 & 12.2.6) FIN (AP, AR, FAH & SLA) and Non-Finance Modules (OM,INV, Costing & PO), PL/SQL, TOAD, SQL Plus, SQL Loader, SVN/GIT,WINSCP,Putty, 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 Tickets for Bugs.
• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PL SQL 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 EBS using Trading Community Architecture (TCA) API’S.
• Involved in designing MD50, MD70 Functional and Technical Design Document, Development for Purchase Requisition Workflow 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

Confidential

Oracle EBS Technical Consultant

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 responsible 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.

Confidential

Graduate Engineer Trainee

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.