Job Summary
We are looking for an experienced
Oracle BI Publisher Reports Developer / PL/SQL Engineer with strong expertise in
Oracle Fusion Cloud ERP, Oracle E-Business Suite R12, BI Publisher, OTBI, XML Publisher, and Oracle PL/SQL. The candidate will be responsible for designing, developing, optimizing, and supporting enterprise reporting solutions across
GL, AP, AR, Procurement, and other Oracle ERP modules.
Must-Have Skills
- Strong experience in Oracle Fusion Cloud ERP reporting, including OTBI, BI Publisher, and reporting security such as roles and data access sets.
- Hands-on experience with Oracle E-Business Suite R12 reporting, preferably using BI Publisher/XML Publisher.
- Strong knowledge of Oracle PL/SQL, XML Publisher, and BI Publisher.
- Ability to design and develop XML Publisher and BI Publisher templates.
- Experience working with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR.
- Strong SQL skills with experience in query development, optimization, and performance tuning.
- Experience developing and maintaining PL/SQL packages, procedures, functions, and triggers, including packages supporting Oracle Integration Cloud interfaces.
- Strong understanding of Oracle GL, AP, and AR tables and data structures.
- Experience implementing data validation, error handling, data integrity, and performance tuning in PL/SQL solutions.
- Ability to prepare technical documentation and provide production support for reports and database objects.
- Excellent communication and stakeholder management skills.
Key Responsibilities 1. Oracle Fusion & EBS Reporting
- Design, develop, enhance, and optimize reports using Oracle Fusion OTBI and BI Publisher.
- Work with Fusion Analytics Warehouse (FAW) where applicable.
- Develop reporting solutions across Oracle Fusion ERP modules including GL, AP, AR, Procurement, and related modules.
- Support reporting requirements across both Oracle Fusion Cloud ERP and Oracle EBS R12 environments.
- BI Publisher / XML Publisher
- Develop pixel-perfect management, operational, financial, and regulatory reports using BI Publisher.
- Design and maintain BI Publisher data models, templates, layouts, bursting, scheduling, and report delivery mechanisms.
- Develop and maintain XML Publisher templates and reports for Oracle EBS R12.
- Manage report catalogs, folders, permissions, and security.
- OTBI & Analytics
- Develop ad-hoc analytics and operational reports using OTBI.
- Work with relevant OTBI subject areas and reporting structures.
- Create and maintain reporting solutions aligned with business requirements.
- Perform data analysis and reconciliation across multiple ERP modules.
- SQL & PL/SQL Development
- Develop complex SQL queries, joins, views, and data extraction logic for reporting.
- Optimize queries for high-performance reporting.
- Develop and maintain PL/SQL packages, procedures, functions, triggers, and supporting database objects.
- Support PL/SQL packages used for Oracle Integration Cloud (OIC) interfaces.
- Implement robust exception handling, validation, logging, and data integrity controls.
- Cross-Platform Data & Reconciliation
- Extract and reconcile data between Oracle Fusion Cloud ERP and legacy Oracle EBS R12.
- Investigate and resolve data discrepancies across GL, AP, AR, Procurement, and related modules.
- Ensure accurate and consistent reporting across different Oracle platforms.
- Functional Collaboration
- Work closely with Finance, Accounting, Procurement, and other functional teams to understand reporting requirements.
- Translate business requirements into scalable technical reporting solutions.
- Participate in requirement gathering, technical design, development, testing, deployment, and production support.
- Production Support & Documentation
- Troubleshoot report failures, data issues, performance problems, and production incidents.
- Perform root-cause analysis and implement permanent fixes.
- Maintain technical specifications, report documentation, data mappings, and support documentation.
- Ensure reports and database objects meet performance, security, and data-quality standards.
Preferred Skills
- Experience with Oracle Fusion Financials reporting.
- Strong understanding of GL, AP, AR, and Procurement business processes.
- Experience with Fusion reporting security and data access.
- Knowledge of FAW is an advantage.
- Experience with Oracle Integration Cloud (OIC) interfaces is preferred.
- Experience in both Oracle Fusion Cloud and EBS R12 environments is highly desirable.
Candidate Profile
- 5+ years of relevant experience in Oracle reporting and PL/SQL development.
- Strong hands-on experience with BI Publisher + PL/SQL.
- Good understanding of Oracle ERP financial modules and underlying tables.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills.
- Ability to work independently and collaborate effectively with functional and technical stakeholders.
Skills: reporting,bi publisher,pl/sql,oracle
