Skip to content

← 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.