← all projects

Dashboard and Data Warehouse Uplift for a Retail POS Vendor

A retail POS vendor's reporting dashboard had two compounding problems: the dashboard itself was built in Flash, a technology well past its supported life, and every report it ran queried the production database directly — meaning heavy reporting activity slowed down the live system customers were transacting on.

The two-part fix

The uplift addressed both halves at once. The dashboard was rebuilt in Angular running on Azure PaaS components, replacing the unsupported Flash frontend with a modern, maintainable stack. In parallel, reporting was moved off production entirely and onto a proper data warehouse, so running reports no longer competed with live transactional load for database resources.

Outcome

The result separated reporting from production for good — customers got a modern, responsive dashboard, and the underlying production system stopped taking a performance hit every time someone ran a report.

Matthew Ratcliffe, software developer and architect, Ballarat
Senior Software Engineer & Architect

20+ years across the technology stack — from greenfield builds to brownfield rescues. Based in Ballarat, VIC, focused on AI, healthcare and high-risk data systems. Full resume →