Synergy
A shared points-and-recognition system for every student club in my MBA program, with QR check-in and live quizzes, and an access model that's actually hard to cheat, not just a leaderboard with a QR code taped to a poster.
- Next.js
- Supabase (Postgres
- RLS)
- TypeScript
Every club in my MBA program tracked participation its own way. Some didn't track it at all. There was no shared record of who showed up where, no consistent way to reward it, and no real protection against the obvious cheat: someone screenshots a QR code and shares it in a group chat.
I built Synergy as one shared points economy across every club. Students earn Synergy Points by checking in at events with a QR code, or by playing live quizzes ("Surge"). Points add up into standing tiers (Ember, Volt, Current, Plasma), so participation has a visible shape to it, not just a number. And everything a student does across every club lands in one permanent record instead of being siloed per club.
The QR check-in was the part that needed real thought. A static code defeats itself the moment someone screenshots it, so the token is computed, not stored: a rotating code over a 90-second window, so a screenshot goes stale within minutes. There's a 15-minute scan window and a soft geofence check (a flag, not a hard block, because campus GPS isn't reliable enough to lock someone out over a weak signal). And a database-level rule enforces one scan per person per event, so that guarantee lives in the schema itself, not just in code that could be worked around.
While building that, I found a real gap in my own design: the database function that generates the rotating token had no explicit access grant on it, which meant it silently inherited Postgres's default "anyone can call this" permission. An unauthenticated caller could have pulled the raw secret behind the whole check-in system. I found it and fixed it before anyone could exploit it, and it's now a rule I apply to every function like it: a database function needs an explicit grant, same as a table, and you can't assume something's private just because nobody's supposed to know it's there.
Synergy is the largest, most finished thing I've built: well over a hundred commits, live, actually branded, and used by real clubs today.
Building it meant designing an access-control scheme from scratch, catching a real security gap in my own work before it shipped, and carrying it all the way from backend to a polished, actually-used product.
Outcome
Live, 100+ commits, used across every FMS club
More work
Solar Sahay
A free rooftop solar calculator for Indian homes. It uses your electricity bill and state to estimate system size, subsidy and payback, in English, Gujarati or Hindi.
The Garba Arts Admin
An internal ops tool for a dance class business, replacing a shared Excel sheet with real lead tracking, fee handling, and role-based access, refined over 90+ rounds of feedback from the actual owner.
Upasthiti
A mobile-first attendance PWA I built for an NGO, designed to survive patchy field signal and to stop depending on one person's personal spreadsheet.
Want to talk about work like this?
Get in touch →