Full-stack architecture from schema to investor portal
Avelon Ventures is a multi-sector investment platform and private client portal built to manage investor onboarding, capital allocation tracking, and legal compliance workflows in one unified system. I architected and delivered the platform end-to-end using Next.js 16 (App Router), React 19, TypeScript, Prisma v6, and Supabase PostgreSQL.
Rather than treating the database and the interface as separate handoffs, I designed the relational schema, server mutations, authentication boundaries, and client visualizations together so every financial state transition remains auditable and predictable.
Relational data modeling & KYC verification pipeline
Investment onboarding requires strict document traceability before capital allocation or profit distribution can occur:
- Prisma v6 & Supabase PostgreSQL Schema: Modeled relational entities spanning investor profiles, multi-tier investment packages, capital commitment ledgers, and compliance audit trails with strict foreign-key constraints and indexed status queries.
- Multi-Page Legal Stamp & KYC Uploads: Engineered the verification workflow supporting government identity validation (
NID/Passport) and multi-page legal stamp document uploads, routing submissions into an administrative review queue before unlocking portfolio transactions. - Role-Gated Sessions with NextAuth.js v5: Implemented encrypted session management and route-level authorization separating public investment calculators, verified investor portals, and executive back-office controls.
Portfolio telemetry & administrative operations
Once verified, investors and administrators interact with live financial state through dedicated operational surfaces:
- Interactive Return & Allocation Analytics: Built responsive financial projections and sector distribution charts using Recharts, translating raw ledger records into clear ROI timelines.
- Executive Back-Office Console: Created administrative review tables with multi-column filtering, KYC approval/rejection state machines, and disbursement ledger reconciliation.
Foundation in high-concurrency financial backends
The architectural patterns in Avelon Ventures build directly on my earlier work engineering a real-time financial and live bidding platform for a UAE-based client (React, Redux, Ant Design, Node.js, Prisma, and PostgreSQL), where I independently owned both backend and frontend systems:
- 53+ Production REST APIs: Designed and implemented over 53 parameterized endpoints supporting compound filtering, multi-field sorting, cursor/offset pagination, and transactional balance updates.
- WebSocket Live Bidding & Atomic Claim Locking: Engineered a real-time WebSocket leaderboard where active bids broadcast instantaneously across connected clients, backed by atomic database locking so the millisecond a participant claims an asset, concurrent requests are deterministically rejected.
- Single-Device Session Enforcement: Built hardware-fingerprinted session gating ensuring a single account can only maintain one active authenticated device session at any given time, automatically revoking stale tokens upon new login.
Scope & delivery
Both platforms were engineered end-to-end — from initial requirements analysis and entity-relationship modeling to REST/WebSocket API implementation and responsive production UI. All financial figures and investor records depicted in the interactive preview are illustrative mock data.