Surpassing Limitations
Innovative solutions that augment senior care operations through technology
The following projects were designed in my current role as I desired for personal use, and were sometimes shared. They use the style of HLE because I like to rock the colors of my team in work related matters. They should be taken as examples of my understanding of the underlying concepts rather than direct programming examples.
PredPPE-03: Glove Need Estimator
Developed a mathematical formula and web application to predict monthly PPE needs for caregivers. The base formula was derived from observation and the safety padding component was derived from the state of New York's regulatory formula established during the COVID-19 pandemic. Together, they ensure availability of properly-sized gloves while minimizing required individual purchases (i.e. buying for a month instead of whenever we're low). The safety padding helps hedge against the uncertainty in use and employee needs.
PRFDB-2 - Invoice Database System
Built an automated invoice tracking system that monitors Gmail for invoice documents I send to myself and corporate AP, extracts key information, and maintains a searchable database. Features binary search optimization for efficient queries and automatic file organization in Google Drive. Eliminated the need to rely on paper invoices for record keeping whenever I was the one who submitted it, allowing me to search the entire recorded invoice-history.
Timesheet 2.1 - Smart Scheduling
Engineered an advanced timesheet system that converts natural time entries into precise hour calculations, supporting budget-conscious scheduling. Features automatic break calculations, overtime warnings, and intuitive error handling. It was designed to help directors with staff plan hours.
It was designed using advanced spreadsheet design practices, merging the use of formulas, code, and Google Sheets features (e.g. conditional formating) to be as responsive as possible.
Additional Innovations
Kitchen Menu Maker v1 & v2
Automated menu generation system that reduced table menu creation time from hours to 45 seconds or less. Ensures consistent formatting and professional presentation for daily resident menus. The second version added more customization and automatic week menu generation so that residents can know what to expect.
ConcatPDF
PDF concatenation tool with compression capabilities. Designed to easily join PDFs for free without relying on an online service so that internal documents could stay secure.
Required Document Reminder Bot
Automated system that provides a monthly reminder to directors to provide documents for upload to the corporate database and shows them what documents are already uploaded.
Budget Analysis Bot
Data analysis bot that inspects the budget spreadsheet for a department, runs forecasts to predict month spending at current rate, and emails the related director a formatted email with the current state and forecasts.