SUMMARY:

• 8 years of experience, of which includes rich consulting experience in R12/R11i as Oracle Apps Techno - Functional Consultant.
• Proficient in technical concepts and extensive expertise in RICE Component (XML Publisher Repots, Framework Application (OAF), SQL and PL\SQL.).
• Extensive experience in Implementation, Customization, Upgrade, Production Support of Oracle EBS.
• Three oracles R11 to R12 upgrade experience.
• Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in Order Management, Purchasing, Oracle Quality, Payables, Receivables, General Ledger Modules.
• Proficient in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.
• Experience in finding out RCA and resolving issues related to workflows
• Proficient in creating Documentation using AIM methodology. Familiar with all the Standard Documents like MD.50, MD.70 and TE.20
• Involved in production support, development and migration activities.
• Worked in teams, involved in various responsibilities like Requirement gathering, development, Unit testing and UAT
• Proficient in understanding the business requirement and coordinating with development team in implementing the same.
• Aware of the Setup of Purchasing and Payables.
• Ability to work independently and with analyst, with distributed teams and onsite team setting to deliver results.
• Excellent analytical, problem solving and communication skills, detail oriented with ability to be an effective team player and work under severe time constraints

TECHNICAL SKILLS:

Technology: Software Operating System Tools Oracle e - Business Suite(R12/11i), Oracle Forms & Reports Builder 6i, Oracle DB Oracle Workflow Builder, Oracle 11g/10g/9i, Sun Solaris, Linux and Discoverer 10g, XML Publisher, SQL/PLSQL,, Quality Center, Oracle JDeveloper, Windows NT TOAD, SQL Developer, Oracle vertex system, Putty, star team

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional Consultant

Responsibilities:

• Impact Analysis due to integration of Extreme and Brocade Systems on the downstream applications.
• Code changes as per new design for integration of new business for database objects like packages, procedures and triggers.
• Code changes as per new design for XML BI reports.
• Analysis of the CEMLI objects that would impacted due to Integration.
• Coordinated with Teams for Migration activities.
• Authored migration document for SIT, UAT and PRODUCTION.
• End to End Business Flow Testing in SIT for Order Fulfillment, Procurement.

Confidential

Techno-Functional Consultant

Responsibilities:

• Modifications of the Vendor Upload program to in corporate GST.
• Did Form Personalization as per Requirement.
• Developed Queries to Validate Set ups for India Tax.
• Coordinated with Teams for Migration activities.

Confidential

Techno-Functional Consultant

Responsibilities:

• Enhancement and modifications of the existing code, BI publisher reports.
• Finding root cause analysis of issues related to code, hence moving the code for bug fixing.
• Involved in identifying the technical objects which relates to that particular customization and segregate the list and working with the respective teams.
• Migration of components to TST environment by coordinating with dba team.
• Authored document of Understanding as per the business process.

Confidential

Techno-Functional Consultant

Responsibilities:

• Daily issue resolution, root cause analysis and application monitoring in P2P Oracle Application modules.
• Solution design of fixes, enhancement and development of objects.
• Ensure all requirements are translated into technical design document for custom Components.
• Work with 3rd party vendors to fix oracle bugs and perform root cause analysis.
• Maintain the day to day status report of the tasks performed.

Confidential

Technical Consultant

Responsibilities:

• Developed stored procedure to bulk data uploads into database, corrections/updates to data in bulk through Interfaces and API after validations.
• Developed conversion program for migration of history data from legacy system in R12 oracle application.
• Enhancement and modifications of the existing code.
• Development of the BI publisher reports.
• Finding root cause analysis of issues related to code, hence moving the code for bug fixing to Enhancement.
• Developed and Customized OAF pages using oracle Jdeveloper.
• Created many database objects like packages, procedures etc.

Confidential

Techno-Functional Consultant

Responsibilities:

• Handling production issues and bug-fixing.
• Analyzing and solving the issues related to PO, requisition that effect the production.
• Worked as technical consultant to resolve issues on Oracle Workflow.
• Resolved various cross functional issues.
• Finding root cause analysis of issues related to code, hence moving the code for bug fixing to Development Team.

Confidential

Techno-Functional Consultant

Responsibilities:

• Remediated Reports to make compliant as per Release 12.2.2.
• Remediated Interfaces and Extensions to make compliant as per Release 12.2.2.
• Remediated Various Unix Shell Script to make compliant as per Release 12.2.2.
• Deployed minor enhancements/bug fixes and maintained various functionalities.
• Developed Trial Balance Detail Report for GL.
• Developed Translated Trial Balance Report for GL.

Confidential

Technical Consultant

Responsibilities:

• Provided Data fixes on Suppliers and Customers Conversion Scripts.
• Deployed minor enhancements/bug fixes and maintained various functionalities.
• Evaluated the issues in the system and proposed corrective solutions.
• Providing fixes to the issues identified in the testing phase.
• Authored Technical Design documents for Given Functional Design.
• Interfacing Files for as per Country Specific Requirements into SIT.

Confidential

Technical Consultant

Responsibilities:

• Developed Oracle reports and also worked on database objects like Procedure, Package, and Triggers.
• Customize reports.
• Remediated Components for Upgrade.
• Received the Manager Appreciations after the successful SIT.
• Providing fixes to the issues identified in the testing phase.
• Created Many documents like MD70, MD50.
• Involved Code Migrations Activities.

Confidential

Technical Consultant

Responsibilities:

• Developed Various Queries For Extract on different Oracle modules as per Requirement.
• Developed the following components for the project.
• Developed and worked on various xml reports on Order Management, Inventory, Purchasing. e.g.
• Proforma Invoice
• Move order Pick Slip Report.
• Sales Order Acknowledgement Report.
• INV Material Transactions Report.
• PO Print Report.
• Purchase Order Acknowledgement Report.
• Developed a MRP Forecast interface.
• Developed different Value Sets and make them specific to site level, org level etc.
• Providing fixes to the issues identified in the testing phase.
• Preparation of Technical Documentation.Design the template for each report and before development of reports.

Confidential

Technical Consultant

Responsibilities:

• Developed the following components for the project.
• Developed custom forms
• Developed custom Reports
• Worked OAF page development