
NYTrafficTicket CRM and website
May 2026 – Present
A decade-old legal CRM made fast and safe, on production. Still shipping.
- Cut the slowest staff search from 11.6 s to 0.74 s by replacing leading-wildcard scans with anchored index lookups.
- Reduced contact search from a 91,000-row full table scan to roughly 300 to 560 rows read, confirmed live on production.
- Fixed SQL injection, CSRF, and unauthenticated file-download holes across the PHP/MySQL codebase.
- 114 merged pull requests and 667 commits, 56 percent of everything committed to the repository, every one through peer and supervisor review.
- Began as a summer internship and continued past it. I am now one of the two developers the firm runs the system on.
- PHP
- MySQL
- Cloudflare
- Backblaze B2
- Claude Code







