← Aman Kumar Limited · RegisterNotes to the accounts · SCRD
Featured · product · 2026 · Shipped
Sponsorship Scorecard
A secure scorecard brand teams use to judge sponsorships against a locked template, with exact scoring and immutable versions.
- Role
- Solo — architecture, data layer, UI, security
- Solo
- Outcome
- A secure scorecard brand teams use to judge sponsorships against a locked template, with exact scoring and immutable versions.
- Links
- Private codebase — described below
- Stack
- Next.js 16 · Supabase (Postgres 17, TOTP MFA) · decimal.js · TanStack Table · Playwright + axe
Problem
Sponsorship evaluations lived in Excel. There was no locked template, no audit trail and no consistent pass/fail rule.
What I built
- Invitation → password → mandatory TOTP MFA → workspace.
- A template builder: once published, weights and thresholds are frozen.
- Instant totals on screen. The server recomputes the official result with exact rational arithmetic, and pass means strictly above the threshold.
- Immutable versions. An amendment creates V2 or V3 and keeps the previous values.
- A legacy Excel archive: upload → validate or quarantine → parse with provenance → review.
- Every write goes through a validated database RPC, and RLS is on every table.
Risk factors
- Built for one client's workflow; generalising the template builder would take more product work.
This is a portfolio, not an offer of securities. No shares exist. Figures are about shipped work.