System Archive

A directory of end-to-end data pipelines, custom web tools, and interactive dashboards designed for monitoring and evaluation.

Live System

Daily Output Log Tracker

A mobile web-based data logging system designed for field personnel to record client information and screening outcomes in real time. The platform includes an integrated output log for monitoring individual field activities, alongside an administrative dashboard featuring analytics, charts, and historical reporting tools for network-wide monitoring and evaluation.

HTML/CSS JavaScript Chart.js
Data Validation System

HTS Form Validation

A standalone Google Apps Script web application integrated with Google Sheets as a centralized database for HIV Testing Services (HTS) form validation. The system identifies incomplete fields, encoding discrepancies, and data quality issues prior to digital entry, enabling field personnel to review, correct, and track erroneous forms through a structured validation and correction workflow.

Google Apps Script Google Sheets Data Validation
Analytics & Viz

Annual Impact Report

A comprehensive visualization of year-over-year operational impact. Utilizes STATA for statistical regression modeling and Tableau for dynamic, interactive storytelling.

Tableau STATA Data Modeling
Data Management

Client Tracking Database

A secure, cloud-based repository for tracking client progression through the care cascade, ensuring high data fidelity and easy querying for monthly reporting.

Database Design Logic Systems