Featured engagement
A national financial system, made self-service.
A multi-strand Oracle engagement for the Ministry of Finance, Oman, spanning Oracle E-Business Suite support, BI Publisher development and an Oracle licensing review, with a flagship deliverable: an Oracle Analytics semantic model that turned hundreds of normalised tables into ten governed, bilingual, self-service subject areas that finance users across ministries and budget units can query without writing SQL.
The challenge
Financial data sat in hundreds of normalised E-Business Suite tables with cryptic column names and no consistent reporting layer. Users needed cross-process analysis, tracing a purchase order through to payment or comparing budget against actuals, plus bilingual Arabic and English presentation and a governed structure fit for public-sector audit and reconciliation.
The solution
A single business model projecting into ten conformed subject areas, so a measure returns the same value wherever it is queried. An eleven-segment chart of accounts modelled as conformed dimensions, each switching between Arabic and English by session language, with year-over-year comparison measures on a proper time dimension and over four hundred technical columns renamed into finance terminology.
The outcome
Ten production-ready subject areas covering the full finance lifecycle, self-service reporting that removed the dependency on IT for new report columns, consistent reconcilable measures across every process, and a metadata-as-code build pipeline with automated validation that shortened release cycles and cut deployment defects.