Work
State Dashboard and State PTD
120Water
120Water is a startup that provides water service line testing and
monitoring services. I built two dashboards for them, one for
administrators at the state level to report on submissions from
public water systems, and one for the public to view the lead
status of their service lines. The dashboards were built in React
with TypeScript and used a combination of Northquad's propriearty
Python API framework, and their Java Spring Boot API. View
Indiana's public dashboard
here.
Webhook Event System
Olio
Olio, a client of NorthQuad, needed a way to manage webhooks from
various EMR systems. I built a system that would receive webhook
events, use AWS S3 and SQS to store and queue events, and then
send the events to the appropriate EMR system. The system was
built in Python with a proprietary framework built on FastAPI, and
leveraged features of S3 and SQS so as not to have to manage
retention periods and retries manually. I also built a testing UI
with vanilla JavaScript (why use a framework when you don't need
to?) and Bootstrap.
Communication Throttler
Zotec
Zotec, another NorthQuad client, needed a way to throttle
communications to garauntors to control call-center volume and
adhere to TCPA regulations. I built a configurable system with AWS
Lambda and SQS that would receive communication requests, then
throttle them or delay them using SQS invisibility timeouts. I
also built load-testing suite in Python to ensure the system could
handle the expected load (I did not use Locust, but am aware I
could have).
Azure DevOps SQL Reviewer
TriMedX
I built a system that would review SQL scripts for best practices
and company style standards. It would then comment on the pull
request and fail the build if necessary. The system was built in
Python and used the Azure DevOps REST API to interface with the
build system.