CASE STUDY / FUNCTIONAL DEMONSTRATION
From scattered spreadsheets to connected operations.
A management system for a motorsport association, covering accounting, member registration and race management.
- ROLE / End-to-end engineer
- TYPE / Association management platform
- SCOPE / API + admin + member portal
The starting point
The association relied on spreadsheets across its administrative workflows. The goal was to transition to a modern system capable of handling multiple sides of the organization together.
My contribution
I designed and built the system end to end: architecture, backend API, administration interface and a unified portal. Shared TypeScript types, tRPC and Zod schemas connect the applications through a common data contract.
Connecting the workflows
A Fastify API uses tRPC and Drizzle with PostgreSQL. Two React applications cover administration and a portal for members and other participants. Session authentication uses better-auth. Storage and electronic invoicing sit behind interfaces for S3-compatible storage and ARCA.
Keeping the financial records consistent
Charges and payments post balanced journal entries, and account balances are calculated from those entries. The demonstration includes 36 charges and 8 payments across 12 fictional members. All entries balance, and the API’s 1,321 tests passed against isolated PostgreSQL databases.
What this case study shows
These are screenshots of the running application with fictional data, captured locally. They demonstrate implemented workflows, not production adoption. Email and fiscal integrations use mocks in this demonstration; live tax submissions and business outcomes have not been verified.
Inside the application
Real screens from a local demonstration. Names, amounts and transactions are fictional; screenshots open at full size.
Explore charge management
