Web platform for San Francisco Family Child Care providers to report vacancies and connect with families seeking care. Includes provider portal with roster tracking, financial assistance eligibility screener, and CA regulation compliance checking.
- Trilingual (EN/ES/ZH)
- Real-time compliance warnings
- Embeddable widgets
Interactive scenario-based policy simulator for San Francisco's early childhood education system. Explores 5 policy scenarios — from expanding subsidies to 200% AMI families, to stabilizing a system losing capacity faster than it can build. Shows trade-offs, costs, who benefits, and who's harmed for each approach.
- 5 policy scenarios
- $781M Baby Prop C tracking
- Zero dependencies / works offline
Interactive map dashboard of 1,144 licensed child care facilities across San Francisco. Filter by facility type, license status, capacity, and contract status with color-coded markers and summary charts.
- 100% location coverage
- 6 facility types
- Responsive design
Geographic supply-and-demand analysis of San Francisco's early childhood education system. Compares licensed capacity against estimated need across 11 supervisor districts, 5 corridors, and 27 ZIP codes — with census-based demand projections for the ELFA expansion to 200% AMI.
- 4 geographic lenses
- 27 ZIP codes
- ELFA gap analysis
Comprehensive analysis toolkit for California child care data from the Resource & Referral Network spanning 1996 to 2023. Covers licensed supply, cost of care, income, labor force, and demand across all 58 counties.
- 52,000+ records
- 58 counties
- 6 data categories
Automated pipeline that extracts data from county-level child care portfolio PDFs, normalizes it into clean longitudinal datasets, and generates an interactive dashboard for exploring trends and comparisons.
- 5-step automated workflow
- Resume after errors
- Interactive dashboard
Automated system for downloading, organizing, and analyzing meeting documents from the San Francisco Department of Early Childhood. Extracts metadata, deduplicates files, and enables intelligent querying across the full archive.
- Smart deduplication
- Metadata extraction
- Query system
Chrome extension built for R&R staff who work daily inside the MyChildCarePlan system. Started as a URL decoder — pasting a long MCCP link to quickly identify which agency, provider, or parent record it pointed to. Evolved into a workflow engine: one-click email lookups across Intercom and WordPress, automated Intercom tagging, parent record search by city name, provider UUID lookups, and a reference copier for parent landing pages. Built because the tools staff use every day weren't designed to talk to each other — so I made something that sits in between and closes the gaps.
- 20+ input types auto-detected
- 1,568 CA cities mapped
- Zero API calls — fully offline data
Prototype for a redesigned homepage for California's statewide child care search platform. Features a dual-pathway design letting families either search independently or connect with an expert for guided help.
- Dual-pathway UX
- Stakeholder presentation deck
- Before/after analysis
Command-line tool for analyzing 5-ball juggling rhythm through real-time microphone audio analysis. Detects catches, tracks timing consistency, and provides session-over-session statistics.
- Real-time audio analysis
- Metronome mode
- Session history & stats