下载PDF
Yellowfin > 实例探究 > Automated reconciliations deliver over 25% process efficiencies for St. LukesHealth
Yellowfin Logo

Automated reconciliations deliver over 25% process efficiencies for St. LukesHealth

技术
  • 应用基础设施与中间件 - 数据可视化
  • 分析与建模 - 预测分析
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 医疗保健和医院
适用功能
  • 商业运营
  • 质量保证
用例
  • 过程控制与优化
  • 质量预测分析
  • 远程资产管理
服务
  • 系统集成
  • 数据科学服务
挑战
St. LukesHealth, a Tasmanian not-for-profit health insurer, faced inefficiencies in their payroll group processing. The manual reconciliation of member payroll deductions with employer remittance advices was time-consuming and required the attention of their most experienced staff. The process involved comparing employer-provided PDF files with data in the HAMBS insurance operating software system, which was tedious and prone to errors. With 25 payroll groups to manage, the task was ripe for automation to free up staff for more productive work.
关于客户
St. LukesHealth is a Tasmanian not-for-profit health insurer established in 1952. The organization manages over 30,000 policies covering more than 62,000 people across Australia. As the membership grew steadily, the need to re-evaluate internal processes became apparent. The organization aimed to automate routine tasks to allow their experienced staff to focus on more value-adding activities. The first process identified for automation was payroll group processing, which involved reconciling member payroll deductions with employer remittance advices. This task was previously handled manually by the Member Services team, consuming significant time and resources.
解决方案
To address the inefficiencies, St. LukesHealth implemented ETL tools from Prometheus and the Yellowfin platform for data manipulation, visualization, and reporting. The first step was to request employers to provide data in CSV format instead of PDF, making it easier to manipulate and insert into a source CSV file. Sample templates were created for testing and validation, and a report was developed to support faster, more accurate reconciliation of payments. The new system displayed HAMBS system data on one side and the equivalent employer data on the other, allowing for quick identification of discrepancies. The automation process took two months to implement and has since seen incremental improvements, including alerts and broadcasts to further reduce operator intervention.
运营影响
  • The automation process has significantly reduced the time required for payroll group processing, with some tasks now taking as little as half an hour compared to an entire afternoon previously.
  • Staff satisfaction has increased as they are now freed from tedious, repetitive tasks and can focus on more productive work.
  • The degree of operator intervention has diminished with each improvement, making the process more efficient and less error-prone.
数量效益
  • Processing efficiency gains of between 25% and 33% in payroll group processing.
  • Reduction in time required for reconciling one of the largest payroll groups from an afternoon to around half an hour or less.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.