The Department develops and manages policy areas of health service delivery, to ensure various health bodies across the state provide consistent, efficient and effective services.
I&A were subcontracted by Oracle Consulting Services to undertake a review of this process which set out the current state and a proposed a future state.
Challenges and Business Objectives
The Department was producing a monthly dashboard report which was distributed to the Area Health Units and Health Corporate Executives. The report contained key financial and operational metrics by Budget Holder providing a comprehensive variance analysis of budget vs. actual together with the latest reforecast which were represented by a combination of tables and charts. The effort necessary to produce this document was considerable, the process was fragmented and largely manual involving a considerable number of spreadsheets, reports, many data extractions from multiple sources and a considerable amount of emailing of information between participants involved in the process.
This review document provided an analysis of Current State incorporating a process flow analysis by working day and the proposed Future State which was predicated on replacing many of the spreadsheets and associated processes with an Oracle based solution comprising elements of the Hyperion suite together with Oracle’s business intelligence solution, Oracle Business Intelligence Enterprise Edition (OBIEE).