This contract role seeks an accomplished Fusion ERP Reporting & Analytics Technical Consultant with a minimum of 7 years of specialized experience. The position involves the comprehensive lifecycle of designing, developing, testing, troubleshooting, and supporting reports, dashboards, data models, and analytics solutions within Oracle Fusion ERP modules.

The ideal candidate possesses deep hands-on expertise in OTBI, BI Publisher, SQL, and Financials subject areas. You will be instrumental in transforming business reporting requirements into accurate, high-performance, and user-friendly analytics solutions.

Key responsibilities include designing, developing, and supporting Oracle Fusion ERP reports and dashboards across Financials, Project Portfolio Management, and Supply Chain.

Build and enhance BI Publisher reports, including complex data models and layouts. Develop and configure OTBI analyses and dashboards aligned with business needs. Write, optimize, and troubleshoot SQL queries for reporting and data validation.

Gather business reporting requirements and prepare technical specifications. Investigate and resolve reporting issues, ensuring data accuracy and performance. Collaborate with cross-functional teams to deliver meaningful reporting outcomes. Develop custom extensions using Oracle Visual Builder Studio and Application Composer when appropriate.

A minimum of 7 years of hands-on experience in Oracle Fusion ERP reporting and analytics is mandatory, with strong proficiency in OTBI, BI Publisher, and SQL. Solid understanding of Oracle Fusion ERP business processes, particularly in Financials, is essential.

Experience developing reports for Financials modules (General Ledger, AP, AR, etc.) and supporting reporting needs in Project Portfolio Management or Supply Chain is required. You must be adept at creating technical specifications, possess strong SQL development and troubleshooting skills, and be comfortable working with XML, XSLT, JSON, and web services.

Ability to analyze data issues, validate report outputs, and resolve defects is crucial. Excellent communication skills are necessary for effective collaboration with functional consultants and business stakeholders. Experience with Oracle Visual Builder Studio and Application Composer, report migration, and security configuration are considered advantageous.