sujon.dev
All projects
FULL-STACK WEB · POSTGRESQL

Avelon Ventures

Full-stack investment portal and real-time financial ledger — combining relational Prisma schemas, KYC verification workflows, and atomic concurrency controls.

Role
Full-Stack Product Engineer · End-to-End Architecture
Category
FULL-STACK WEB · POSTGRESQL
Stack
Next.js 16PostgreSQLPrismaNextAuthWebSockets
avelon // next.js + prisma + postgres
Illustrative concept · Interactive KYC, Prisma ORM & WebSocket lock
System Architecture & Engineering Highlights
  • End-to-end Next.js 16 (App Router), Prisma v6 & Supabase PostgreSQL architecture
  • Multi-page legal stamp KYC verification pipeline & NextAuth.js v5 session gates
  • Interactive Recharts portfolio analytics & administrative ledger reconciliation
  • Built on proven financial backend patterns: 53+ REST APIs & WebSocket atomic locks

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.

What’s next?

Let’s make something good.

Have a project, a technical idea, or simply want to say hello? My inbox is always open.