Skip to content
Marcus Prgin
Selected work / project field

Distributed Rate Limiter

View on GitHub ↗

A distributed Go and Redis rate limiter with hierarchical quotas, exact concurrent enforcement, and a quota-leasing hot path benchmarked at 45.7 ns/op.

  • Built a distributed rate limiter in Go and Redis with sliding-window and token-bucket algorithms, cost-weighted requests, and hierarchical user, tenant, and global quotas
  • Reduced Redis round trips by approximately 80% for sustained hot keys through centrally accounted quota leasing; benchmarked the allocation-free lease path at 45.7 ns/op, approximately 1,900× faster than the recorded in-process Redis-backed path
  • Verified exact enforcement under contention by admitting exactly 100 of 500 concurrent requests at a configured limit of 100; developed 131 tests and eight benchmarks with 86–96% coverage across core packages
  • Built a GitHub Actions CI pipeline with race detection, real-Redis integration tests, linting, benchmarks, Docker smoke tests, and Prometheus/Grafana observability exercised through k6 load scenarios
Jun 2026 – Aug 2026 · Go, Redis, Lua, Docker, Prometheus, Grafana, k6

SQL Query Engine

View on GitHub ↗

Predicate pushdown and projection pruning cut I/O up to 94%. A 16 KB HyperLogLog sketch cut distinct counts to O(1) memory at ~0.8% error.

  • Cut I/O up to 94% on wide CSVs by implementing predicate pushdown and projection pruning — pushing filters to the scan and reading only referenced columns
  • Cut distinct-count memory from O(n) to O(1) at ~0.8% error by replacing exact counts with a 16 KB HyperLogLog sketch (as used by Redshift and BigQuery)
  • Added an approximate top-k aggregate on a Count-Min Sketch (fixed 110 KB) returning the most frequent values in sub-linear memory regardless of distinct-value count
May 2026 – Aug 2026 · Python, pytest, pyarrow

AI Code Security Agent | ResolvePR

Live demo ↗View on GitHub ↗

A full-stack GitHub security agent that transforms pull request webhooks into inline CWE findings through a Go scanner, Next.js dashboard, and PostgreSQL-backed pipeline.

  • Built a full-stack GitHub security agent in Go, Next.js, and PostgreSQL that transforms pull request webhooks into inline CWE findings to improve and suggest ways to decrease security vulnerabilities
  • Deployed the application across three managed cloud services, including Google Cloud Run for the containerized Go scanner, eliminating manual server management and allowing each layer to scale independently
  • Cut false positives with a validation layer that rejects off-diff, low-confidence (below 87%), malformed, and duplicate findings before anything is posted to the PR
  • Integrated GitHub App authentication, pull request webhooks, inline review comments, Check Runs, Neon PostgreSQL, and an LLM analysis pipeline into a single developer-security workflow
  • Secured the pipeline with HMAC-SHA256 webhook verification and idempotent scans, backed by Neon Postgres and a Next.js triage dashboard
May 2026 – Sep 2026 · Go, Claude API, GitHub API, tree-sitter, Next.js, Neon PostgreSQL, Google Cloud
Experience / selected impact

Software Engineering Intern | Enzuzo

Built and improved full-stack revenue and analytics systems serving 30,000+ customer accounts while resolving performance, data-integrity, and security issues.

  • Built a full-stack sales dashboard using TypeScript and React Router that uses projected and current customer data to rank upsell opportunities, increasing monthly recurring revenue by $50K
  • Resolved feedback from customers and senior engineers by moving SQL queries into scheduled Cloudflare D1 rollups, reducing load and improving performance for customers
  • Improved the ingestion pipeline using hourly cached data and falling back to validated data during API failures to prevent dataset corruption, improving 30,000+ customer accounts
  • Audited the customer-facing analytics platform and identified query logic, caching, and testing issues that fixed 50+ reported bugs when resolved
  • Closed a cross-tenant IDOR vulnerability by authorizing requested customer identifiers against authenticated account groups and adding regression coverage for unauthorized access
Waterloo, Ontario · May 2026 – Aug 2026 · TypeScript, Node.js, React Router, SQL, Cloudflare D1, Cloudflare Workers
About / Marcus Prgin

Software engineer, undergrad

I’m a CS undergrad from Ontario, Canada, working across Go, Python, TypeScript, JavaScript, and SQL — with React and Next.js on top and Kubernetes, Terraform, Docker, Cloudflare, and Vercel underneath. I’m drawn to statistics and security: building secure full-stack applications, designing databases, and writing efficient SQL queries.

Ontario, Canada
Education / University of Guelph

Bachelor of Computing, Computer Science Co-op (Honours)

University of Guelph — currently in year two, expected to graduate in May 2030.

Guelph, Ontario · Expected May 2030
Gallery / behind the build

Gallery

Coming soon.

Let’s build something!

Email ↗LinkedIn ↗GitHub ↗
Résumé / preview
Download PDF
Marcus Prgin résumé