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.