Financial Information System for Healthcare

Case Study

Project Details
Client Alexandra Hospital
Product CUBOT Financial Information System for Healthcare
Categories  Healthcare, Revenue Analysis
Data Sources SAP Billing System and Excel Files
Metrics of Focus Revenue Performance, Cost Accounting
Time to Deliver Approximately 3 Months
Solution Description

Singapore’s public healthcare is regarded as one of the best systems for healthcare in the world and we have worked with several publicly managed hospitals in Singapore. While the structure of the healthcare system has evolved over the last decade or so, having different managing bodies, IT centralization to IHIS, and having different holding bodies. Alexandra hospital is a public hospital with a sizeable occupancy of about 300 beds, offering multiple specialist services and therefore tertiary care. Our implementation for healthcare providers is fairly extensive by means of data processing, ETL and scheduling, as well as the calculation of metrics for Healthcare finance. Because the reporting needs for finance is fairly high due to the need for end of month reports, as well as the fact that it is the department closest to the information on profitability, the implementation demands are also higher.
The analytics solution that was delivered meant that healthcare administrators were able to use data from multiple systems effectively in order to drive better hosptial performance.

Business Solutions : Metrics & Analytics
Collating GL Month End Reports

Through the use of transaction information, the hospital finance team was able to make use of data to generate general ledger reports. Data processing and scheduling were streamlined to provide the finance team with all their information needs within 3 hours of closing for the day. Less time spent collating GL reports meant that more time could be allocated to understanding revenue and cost trends.

Reducing Bill Sizes

Healthcare Finance in Singapore reports Bill Sizes to the Ministry of Health, who then publishes average bill sizes for DRGs across public hospitals in Singapore for patients to make more informed choices.
The need to drive costs down for hospital operations often arises from the administrative side of healthcare, rather than the medical side. Therefore the finance department’s role in reducing bill sizes is to understand anomalies and higher than average costs within DRGs to then understand why a higher cost may occur. The strength of the CUBOT’s data discovery features was really used in this scenario, where analysts were exploring bill size statistics within many categories, down to a reasonable level of depth.

Calculate Consultant Fees

Doctors fees were calculated based on the number of private and subsidised patients that the doctors consulted. Using the defined logic to calculate their fees, the process can be automated to save more time performing this routine activity.
Furthermore, the idea is that doctors should be rewarded for taking on greater workloads, and so the calculation of the rewards required fair amount of logical inputs that were not friendly to calculate in regular MS Excel or Access.

Understand patient profiles

Understanding customers is just as important for revenue analysis as customer segments and patient characteristics become apparent. Demographic information, housing information were particularly noteworthy for Singapore public hospitals from a finance perspective.

Technology Solutions
Challenges
Solutions
Product Module
Enormous learning effort to design and implement data reporting and analytics Soltion for Healthcare Finance Vizualytics Solutions
Automating routine GL reports ETL, Automated Calculations, Data Integration CUBOT ETL
Vizualytics Services
Data not available in time Scheduled data processing & calculations that are nearly real-time CUBOT ETL
Difficult to derive some information through excel Calculating logic-based metrics through scripts Vizualytics Services
Lack of insight into relationships, patterns and category-wise information easily Data Modelling and Drill-Down features CUBOT Analyze
image (19)
Michael Chen
Alexandra Health
Former CFO

Up to date information such as patient bills, visits, hospital and department financial results, workloads and referrals are just a few clicks away