Dante Bertolutti

Okanagan College — BCIS, graduating April 2026

Major projects from my degree.

Bachelor of Computer Information Systems coursework focused on full-stack architecture, databases, systems analysis, object-oriented programming, algorithms, computer networks, and iOS development. These two projects pushed the work the furthest.

COSC 471

Project Maverick — MarketSight

Machine-learning stock prediction platform combining a FastAPI backend, XGBoost models, and a React/TypeScript frontend with real-time charts.

My Contributions

Added prediction confidence scores in the inference API, built the predictions page, aligned frontend types with backend schemas, parameterized SQL date queries to reduce injection risk, fixed CI lint and type-check issues, authored Streamlit acceptance-test docs and final project documentation.

FastAPIXGBoostReactTypeScriptPostgreSQLViteRechartsDockeruvpytestruffmypy
Project Maverick stock chart and prediction dashboard

COSC 416

Canada-wide DBMS Cybersecurity Monitoring

Group 5 Cybersecurity project building an Oracle-backed monitoring system for Canada-wide DBMS traffic — schema, performance tuning, stress testing, backup/recovery, and a Flask web dashboard surfacing traffic analysis, threat intelligence, and infrastructure metrics.

My Contributions

Designed and tuned the Oracle schema (tables, indexes, views, grants, verification queries) and built the Flask dashboard with a tabbed UI for Traffic Analysis, Threat Intel, Performance Tuning, and Infrastructure. Wrote Oracle data export, JSON builder, deploy and refresh scripts, plus performance tuning docs and a DBML schema diagram.

OraclePL/SQLPythonFlaskHTMLCSSShell
COSC 416 cybersecurity DBMS monitoring dashboard

Personal Projects

A full-stack platform I built end-to-end.

Outside of coursework, my biggest build — a security-hardened social platform taken from database schema to shipped UI and self-hosted in production.

Personal Project — 2025–Present

AllGearNoGame

Full-stack, security-hardened social platform for sports-gear reviews

Designed, built, and self-hosted a production-grade social platform for sports-gear reviews — TypeScript end-to-end, from a PostgreSQL/PostGIS schema to a React 19 UI, behind a zero-inbound-port Cloudflare Tunnel. A per-sport feed across 18+ sports mixes structured 1–5★ gear reviews with discussions, threaded comments, fuzzy gear search over a seeded 2,886-item catalog, and a peer-conferred credibility system.

Engineering Highlights

  • End-to-end TypeScript in a pnpm + Turborepo monorepo: Next.js 16 / React 19 frontend, NestJS API, Drizzle + PostgreSQL 17 / PostGIS, and a Valkey cache — a single Drizzle schema is the source of truth, with types flowing into both API and UI.
  • Secure auth (better-auth): Argon2id hashing, OAuth-ready social login, HIBP breached-password rejection, Postgres-backed sessions, and a BFF pattern where Next.js holds the httpOnly cookie and talks to the API server-to-server.
  • OWASP-aware hardening: strict CSP + security-header suite (HSTS, X-Frame), CSRF Origin allow-list backing SameSite cookies, Valkey-backed rate limiting, server-side ownership checks (no IDOR), and AES-256-GCM encryption of OAuth tokens at rest.
  • Database performance audit with EXPLAIN (ANALYZE, BUFFERS) against ~145k synthetic rows; partial, trigram (GIN), and GiST indexes, Valkey cache-aside, and keyset pagination — every hot query verified sub-millisecond.
  • Peer-conferred "Cred" reputation system: readers attach weighted assessments to posts; cred rolls up per-sport and globally into a 5-tier ladder, monotonic by design so it can't be farmed. PostGIS geography + GiST powers "near me" facility ranking.
  • Self-hosted on Linux via Docker Compose (separate dev/staging/prod stacks) behind an outbound-only Cloudflare Tunnel — no inbound ports, no exposed IP — with multi-stage non-root images, Pino structured logging, GlitchTip/Sentry, and health/readiness probes.
TypeScriptNext.jsReactNestJSDrizzle ORMPostgreSQLPostGISValkeyTailwind CSSDockerpnpmTurborepoCloudflare Tunnelbetter-auth
AllGearNoGame sports-gear review platform — feed cards, star ratings, and credibility tiers

Personal Infrastructure

Self-hosted infrastructure I designed and operate.

Networking, storage, DNS, VPN, and reverse-proxied applications — built from the ground up and operated as a long-running production environment.

Personal Project — 2025–Present

Self-Hosted Home Infrastructure

Enterprise-grade network and self-hosted services stack

Designed, deployed, and operate a full enterprise-grade network and self-hosted infrastructure stack from the ground up. Ubiquiti UniFi networking, a 60TB Synology RAID 6 array, a Linux Mint application server, Cloudflare-managed DNS with API-driven DDNS, WireGuard VPN, and Nginx-proxied web apps — designed so non-technical operators can run it without me on-site.

Engineering Highlights

  • Layer-2/3 design across UDMP, dual USW Pro Max distribution switches, a USW Flex 2.5G edge switch, 5× U6 Mesh APs, and a 10G SFP+ backbone with seamless roaming.
  • 60TB Btrfs RAID 6 array on a Synology DS1525+ — chose RAID 6 over RAID 5 for two-drive fault tolerance on the long-life storage tier.
  • STP root-bridge priority intentionally assigned with explicit tiers across distribution and edge switches for deterministic failover.
  • Cloudflare API-token DDNS against the zone directly — eliminated reliance on third-party DDNS providers.
  • Nginx reverse proxy fronting multiple self-built web apps (GolfTracker, TrainingQuest, TodoList) with a catch-all default_server returning 444 to harden against unintended host headers.
  • WireGuard VPN with per-user configs, QR-code provisioning, and multi-user access — migrated from OpenVPN for better cellular performance and lower overhead.
  • DNS-level filtering via AdGuard Home (Docker on Synology) with Quad9 + Cloudflare DoH upstream; 2FA on Ubiquiti and DSM admin; UPnP disabled; hardened SSH.
  • Roadmap: VLAN segmentation (Trusted / IoT / Camera) with inter-VLAN firewall rules, UniFi Protect camera deployment, 10GbE direct NAS-to-workstation link, multi-site VPN to a secondary BC↔Mexico property.
UniFiUbiquitiSynologyBtrfsRAID 6Linux MintNginxCloudflareWireGuardDockerAdGuardSFP+10GbE
Home infrastructure collage — UniFi networking, Synology NAS, and self-hosted services