Automus Consulting - BI Reports Consultant - Oracle FDI

Key Responsibilities : Report Development : - Design, develop, and maintain Oracle BI Publisher (BIP) reports, OTBI dashboards, and custom data models. - Work closely with functional teams to gather reporting requirements and translate them into technical specifications. - Build SQL queries, data templates, and layout templates for complex business reports. - Optimize report performance by tuning SQL queries and data model structures. - Develop and maintain RTF, Excel, and online report templates for Oracle Cloud ERP modules. - Configure bursting definitions for automated report delivery across channels. - Perform report migration across environments and ensure version control. - Troubleshoot report failures, data discrepancies, and performance issues. - Ensure compliance with data security, role-based access, and Oracle Fusion security model. - Collaborate with integration teams to embed reports within business workflows. Implementation & Delivery : - Taking ownership and lead technical delivery of Oracle FDI projects from requirements through UAT and production go-live. - Develop and review ETL/ELT mappings, interfaces, and transformation logic. Required Qualifications : - 6+ years of experience in Oracle reporting solution with good experience of understanding the business flows and good end to end Implementations. - Deep expertise in Oracle FDI. - Proficiency with OTBI and BIP reports. - Strong understanding and experience of Oracle Fusion Cloud ERP: SCM, Finance modules. - Hands-on experience with REST/SOAP APIs, JSON, and Oracle Integration Cloud (OIC) would be added advantage. - Solid SQL skills; familiarity with Oracle Database, ADW, and data modeling best practices. Must-Have Skills : - BI Publisher - OTBI - FDI - SQL Development - Oracle Fusion Finance & SCM - Data Models & Templates