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