Job Summary
The Applications Analyst will support a large-scale Oracle Fusion Cloud implementation, focusing on developing financial statements, management reports, transactional reports, dashboards, and analytics. The role requires strong functional finance knowledge and hands-on expertise with Oracle Fusion Data Intelligence (FDI), Financial Reporting, Financial Consolidation and Close (FCC), Oracle BI Publisher (BIP), and Oracle Transactional Business Intelligence (OTBI). The analyst will work closely with Finance stakeholders to translate reporting requirements into accurate, reliable, and maintainable reporting solutions.
Key Responsibilities
• Design, develop, test, and deploy Finance reports using Oracle FDI, Financial Reporting, FCC, BI Publisher, and OTBI.
• Collaborate with Finance stakeholders to understand reporting requirements and translate them into appropriate Oracle reporting solutions.
• Select reporting technologies based on business requirements, data sources, reporting frequency, formatting needs, and required levels of detail.
• Develop FDI dashboards, analyses, KPIs, and visualizations using Finance subject areas and semantic models.
• Develop and maintain financial statements and management reports, including income statements, balance sheets, cash flow statements, departmental reports, and variance analyses.
• Build BI Publisher reports and data models for detailed, formatted, scheduled, and high-volume reporting requirements.
• Develop OTBI analyses and dashboards for transactional and operational Finance reporting.
• Support financial reporting requirements within FCC, including consolidated financial statements, management reporting, and reporting hierarchies.
• Validate report outputs against Oracle Fusion ERP and other authoritative data sources to ensure completeness and accuracy.
• Troubleshoot reporting issues involving data, hierarchies, security, calculations, mappings, and report configuration.
• Support system integration, user acceptance, and regression testing by developing test scenarios and reconciling reporting results.
• Document report designs, calculations, data sources, filters, prompts, and technical and functional design decisions.
• Collaborate with Finance functional teams to understand General Ledger, Chart of Accounts, hierarchies, accounting periods, balances, journals, and subledger accounting.
• Rationalize reports and identify opportunities to use standard Oracle reports or existing reporting accelerators before developing custom solutions.
• Follow project development, migration, testing, and change-control standards through deployment.
Required Qualifications
• Hands-on experience developing financial reports within Oracle Fusion Cloud ERP.
• Strong experience with Oracle Fusion Data Intelligence (FDI), Oracle Financial Reporting/Financial Reporting Center, Oracle EPM Financial Consolidation and Close (FCC), Oracle BI Publisher (BIP), and Oracle Transactional Business Intelligence (OTBI).
• Understanding of Oracle Fusion Financials data structures and reporting concepts.
• Experience developing financial statements, management reports, transactional reports, dashboards, and analytics.
• Ability to independently manage reporting requirements from design and development through testing, reconciliation, and deployment.
• Strong SQL and data analysis skills, particularly for troubleshooting and validating report results.
• Ability to work directly with Finance business users and explain technical reporting concepts in business terms.
• Strong attention to detail and demonstrated ability to reconcile reports against source financial data.
