ADVEC Boston
Admin portal that runs an entire church
Centralizes events, members, giving, and volunteers for a church in Boston in one place.
Strategy
ADVEC Boston had been juggling registrations, finances, pastoral visits, and book sales across spreadsheets and disconnected tools. Each team worked in isolation with no shared visibility, no audit trail, no unified day-of-event check-in.
The replacement had to run from pastors' and volunteers' phones, in two languages, and feel native. We set out to consolidate the church's entire operational stack into a single role-based portal — modular, installable as a PWA, and as legible to a first-time volunteer as it is to a seasoned operations lead.
Design
A PWA that feels native on iPhone — floating iOS-style dock, View Transitions, safe-area-aware chrome, light/dark theming, per-user timezone, and a custom visual identity that's distinct from generic admin templates.
- Public registration at /r/<slug> with payment-screenshot validation, waitlist, and day-of check-in
- MCEA: auto-assigned pastoral visits using radius-based geofencing around each pastor's home base
- Bookstore POS with camera ISBN scanning, per-preacher sessions, password-gated public report links
- Bilingual (PT-BR default · EN), light/dark theme, per-user timezone, custom visual identity end to end
Technology
Built on a battle-tested core — Express 5 + React 19 + PostgreSQL + Drizzle. Each module is permission-gated, every action is audit-logged, and the entire stack ships through a three-app GHCR + Dokploy pipeline.
- Auth via Postgres-backed sessions (scrypt), CSRF, per-IP and per-phone rate limiting, full audit log
- PWA + Workbox for installable, offline-aware experiences across all roles
- CI/CD: GHCR images + Dokploy three-app split (prod, staging, per-PR previews)
- Twilio + Resend + Google Maps + radius-based geofencing for the MCEA module
Analytics
The Analytics module centralizes the KPIs leadership actually cares about: registrations, confirmed payments, completed MCEA visits, active events. Trend charts by period, top-5 events by registrations, MCEA completion mix, communication opt-out rates, and 'things to look at this period' cards that surface meaningful changes without opening a single report. CSV export and a print view for leadership meetings.
