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.