Essex and Sussex Resident Portal
Date
2024
Technology
- PHP 8.3
- MariaDB
- Composer
- Doctrine DBAL
- PHP DI
- PHP Unit
- Silverware POS (REST)
Description
In 2024, I was tasked with working with The Essex and Sussex to ingest the Silverware POS data and provide Residents dining room insights.
I worked closely with board members and management to devise a solution that would allow residents to monitor their dining room spending, review their account balances, and monitor expenses incurred by residents or guests near real-time. Due to system and operational constraints, a compiler was designed to routinely ingest POS data up to several weeks old, filter incomplete records, and provide staff with a method to validate POS data. This compiler allowed other processes that compiled reporting tables to run at a less frequent interval and create stable snapshots for residents and reporting purposes.
A resident portal was established for residents to see this data on-demand. An additional staff section was created to provide insights into the status of the compiler, run the compiler on demand, and give more comprehensive data reporting.