Skip to content

Case Study: Non-Profit Infrastructure Modernization

FLHSE

Client
Frontline Energy
Sector
Public Health / Energy Managemen
Services
Bespoke, cloud-hosted database and reporting system
Technology
Apache, Perl, PHP, MySQL, Cloud Server

Project Overview

The FLHSE Operational Platform was a bespoke, cloud-hosted database and reporting system built for the HSE’s National Health Sustainability Office, delivered through Frontline Energy & Environmental, who held the national HSE energy management contract. iWorks designed and built the full platform, integrating with GeoPal’s mobile field survey application to create an end-to-end solution for managing energy data across the entire Irish public health estate.

The Challenge

The HSE had thousands of properties scattered across every county in Ireland with no centralised view of their energy usage, utility meter references, site photographs, or billing history. Frontline Energy had field assessors visiting each property with tablets to capture data — but there was no system to aggregate, validate, and report on that information at scale. The platform needed to handle two categories of HSE site simultaneously: Lot 1A (Direct) sites managed directly by the HSE, and Lot 1B (Funded) sites managed by external agencies.

Technology

The platform was built on Apache, Perl, PHP, and MySQL, hosted on a cloud server with daily, weekly, and monthly automated backups. In early 2014 the system was also deployed locally onto HSE desktop PCs, requiring a custom installation and configuration process to replicate the cloud environment on standalone machines.

The Solution Installed

We designed and built a bespoke cloud-hosted web application tailored exactly to non-profit governance standards, focusing heavily on clear visual hierarchy and ease of use for an older target demographic:

Centralized Data Engine

Replaced scattered desktop files with a single, highly encrypted database hub.

Streamlined Workflows

Designed a simple interface that allows managers to track compliance protocols seamlessly without needing to be tech-savvy.

Role-Based Access Controls

Implemented strict security boundaries ensuring sensitive user records are only accessible by authorized personnel.

The Business Impact

The transition safely eliminated legacy infrastructure dependencies, heavily reducing daily administrative friction. Rainbows Ireland now operates on a secure, highly responsive application built to maintain compliance, absolute transparency, and long-term data preservation.

What Was Built

The platform provided a single operational hub covering the full lifecycle of site data — from field capture through to HSE reporting. Key capabilities included:

  • Central site database — Each HSE property was assigned a Unique Site Identifier (USID) and linked to GPS coordinates, site photographs, building size, and all utility meter references (electricity MPRNs, gas GPRNs, water meters, oil).
  • GeoPal field app integration — When site assessors completed a survey on their tablet in the field, data flowed directly into the FLHSE database in real time.
  • Interactive heatmap — A national map of all HSE sites displaying status, site type, and energy data at a glance.
  • Bulk utility bill upload — Frontline’s team uploaded structured Excel files of utility bills from energy suppliers. The system parsed each file and automatically associated consumption and expenditure figures to the correct site and energy type (electricity, gas, kerosene, gasoil, LPG, diesel, water, and heating oil variants).
  • Consumption and expenditure reporting — Graphical reports per site and per energy type, filterable by date range and energy supplier.
  • Excel export reports — Full data exports for HSE reporting and compliance requirements.
  • Admin and edit panel — Frontline staff could view, edit, and manage all site records through a purpose-built control panel.
  • Search and filter — Sites searchable by county, site type (Direct/Funded), energy type, supplier, and USID.

Scale

  • 3,374 HSE sites — 2,465 Direct and 909 Funded
  • 9,273 site images stored and served from the platform
  • Up to 909 data fields per site record
  • All 26 counties covered, with Dublin (738 sites), Cork (283), and Donegal (271) among the largest
  • Major hospitals included Beaumont, the Rotunda, Temple Street, the Coombe, St Vincent’s, St John’s Limerick, and Kerry General, among many others

Project Timeline

  • April 2013 — Project kick-off following HSE contract award to Frontline Energy
  • May–August 2013 — Platform development, GeoPal API integration, data template finalisation with utility suppliers
  • September 2013 — System live; Frontline uploading site survey data and utility bills; HSE Procurement given access
  • October–November 2013 — National data upload phase; live demonstration to the HSE on 5 November 2013
  • December 2013 — Database configuration meeting at Sir Patrick Dun’s Hospital with HSE Estates
  • March 2014 — Local installation at Cherry Orchard Hospital; HSE took full ownership of the platform
  • 2014–2015 — Ongoing domain, SSL, and hosting management by iWorks

Client

Frontline Energy & Environmental, on behalf of the HSE National Health Sustainability Office — in partnership with GeoPal Solutions (mobile field data capture).

Frontline Energy HSE

Is your organization still tracking data on outdated software?

We specialize in moving public bodies and charities safely off Microsoft Access, FoxPro, and legacy desktop applications. Let’s review your system layout with zero obligation.

Discuss Your Migration Project