Key Responsibilities
Develop, customize, and maintain Oracle EBS applications across Finance, SCM, Procurement, Inventory, Order Management, and HRMS modules.
Design and develop PL/SQL packages, procedures, functions, triggers, and performance-tuned database objects.
Create and modify Oracle Forms, Reports, XML Publisher Reports, BI Publisher Reports, and Oracle Discoverer Reports.
Develop and support Inbound/Outbound Interfaces using:
SQL*Loader
UTL_FILE
APIs
Open Interfaces
Web Services
Design and develop Oracle Workflow customizations.
Develop and support Concurrent Programs and Request Sets.
Troubleshoot production issues and provide timely resolutions.
Work closely with functional consultants and business users for requirement gathering and solution design.
Perform code migration across instances using Oracle Application Object Library (AOL).
Participate in upgrades, patching, and implementation projects.
Optimize SQL queries and PL/SQL programs for performance improvements.
Prepare technical design documents and unit test cases.