Must have skills:
- Oracle Fusion Cloud ERP reporting (OTBI, BI Publisher), and security (roles, data access sets).
- Oracle E‑Business Suite (R12) reporting (BI Publisher), Solid Oracle PL/SQL & XML Publisher knowledge.
- Design and generate reports using XML Publisher and BI Publisher templates.
- Work closely with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR.
- Create and optimize SQL queries for high-performance reporting.
- Develop and maintain PL/SQL packages, procedures, functions, and triggers for Oracle Integration Cloud interface packages. .
- Work closely with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR.
- Knowledge of Oracle tables for GL, AP, and AR.
- Ensure data integrity and implement error handling and performance tuning in PL/SQL code.




- Prepare technical documentation and provide production support for reports and database objects.
- Excellent communication skills.

Key Responsibilities:
- Reporting (Fusion & EBS)
- Design, develop, and optimize reports using Oracle Fusion OTBI, BI Publisher, and Fusion Analytics Warehouse (FAW) where applicable.
- Extract and reconcile data across Fusion ERP modules (e.g., GL, AP, AR, Procurement) and legacy EBS (R12) for cross-platform reporting.
- Build pixel-perfect regulatory/management reports (BI Publisher) and ad‑hoc analytics (OTBI).
- Create subject areas, data models, bursting/templating, and scheduling strategies; maintain report catalogs and security.

📌 BIP Reporting/OTBI (Hyderabad)
🏢 ElfOnze Technologies
📍 Hyderabad