Gaurang Khurana // CS @ Waterloo

guest@gaurang.ca: ~

type help · play

market sim · $1M · 6 crypto · 6 indices · 6 stocks

cash

$1,000,000

portfolio

$1,000,000

P&L

+$0

leaderboard · 0 traders · save your run:

no runs yet — allocate, then save your P&L.

crypto = live prices (keyless public APIs, ~20s) · indices & stocks = simulation seeded from real levels, live during each exchange's market hours · +/− = buy/sell · invest your $1M from cash · not investment advice

experience

~/rbc

current

May 2026 – Present

Royal Bank of Canada

Technical Systems Analyst · Toronto, ON

Built real-time Power BI dashboards integrated with the ServiceNow REST API to consolidate ticket metrics across teams, eliminating ~65% of manual reporting workflows and enabling daily KPI tracking across 10+ service categories.
Provided hands-on technical support across Microsoft 365 (Teams, SharePoint, Outlook, Azure AD) and ServiceNow, resolving incidents and service requests while documenting resolution patterns to reduce repeat ticket volume by ~25%.
Analyzed ticket routing patterns and SLA compliance data to identify resolution bottlenecks, streamlining incident triage and escalation workflows and improving average response time by ~30%.

~/dataknobs

Sep 2025 – Dec 2025

DataKnobs

Software Engineer Intern · Seattle, WA

Built LLM-powered GEO evaluation pipelines (Python, FastAPI) analyzing webpage performance across generative search — automating extraction of entities, claims, and topical relevance and substantially cutting manual review cycles.
Implemented RAG with vector embeddings to ground analyses in verified source content, improving consistency and reducing hallucinations.
Designed backend orchestration + scoring (batch runs, caching, retries, logging) for systematic benchmarking and controlling inference cost at scale.

~/marshalls-consultancy

May 2025 – Aug 2025

Marshall Clinical Research Consulting

Software Engineer Intern · Edmonton, AB

Automated behavioral-health data pipelines (Python, Pandas, FastAPI) for ingestion, cleaning, and structuring — significantly reducing manual prep time.
Spearheaded semantic search via vector embeddings to accelerate literature synthesis and pattern discovery across substances and demographics.
Designed a privacy-first conversational chatbot (LLM APIs, structured prompts, safety rules) for anonymous addiction-awareness and self-reflection.

~/toshniwal-advisory

Jan 2025 – Apr 2025

Toshniwal Advisory Services

Quantitative Trading Intern · Remote

Built a centralized portfolio analytics platform (FastAPI + Next.js) consolidating multi-strategy portfolios — substantially reducing reconciliation time and improving sector-level visibility.
Led sector-exposure decomposition + rotation logic surfacing hidden concentration risk; guiding reallocations that improved returns vs. the prior workflow.
Designed an LLM-assisted analytics layer (Pinecone vector search) to contextualize sector moves, flag abnormal concentration/drift, and accelerate risk discussions.

education

BCS, Computer Science (Honours)

Statistics Minor

University of Waterloo

Elite & President’s Scholarship · $50,000 Group I Distinction · Waterloo Euclid Contest Bloomberg Market Concepts (BMC)

Sep 2024 – Aug 2029

Waterloo, ON

projects

~/bulkpilot — main

active

↗ repo

BulkPilot latest

Embedded Shopify App — Bulk Price Editor with One-Click Rollback

GraphQL Admin API App Bridge React Router 7 Polaris Prisma SQLite OAuth

250

variants per
API chunk

1-click

full
rollback

snapshot

every edit
persisted

live

before/after
preview

Bulk-edit product variant prices across a merchant's catalog with a live before/after preview, then undo any change — treating bulk edits like database migrations: preview → apply → roll back. Filter with Shopify's native search (vendor:, tag:), pick an adjustment (set / ±% / ±amount / round to .99), and apply.
Applies changes via the GraphQL Admin API (productVariantsBulkUpdate), grouped by product and chunked to the 250-variant API limit, with per-variant partial-failure handling.
Snapshot-based rollback: each operation persists prior prices via Prisma — rollback replays the snapshots to restore exact pre-edit prices, so a 500-variant markdown gone wrong is reversible in one click.
Built on Shopify's official embedded-app stack (React Router template, Polaris, App Bridge) running against a real Shopify development store.

~/quantcore — main

active

↗ repo

QuantCore

Real-Time Options Pricing & Risk Engine

C++ Apple Metal GPU pybind11 FastAPI Next.js WebSocket Monte Carlo

69×

GPU vs NumPy
@ 10M paths

<0.01%

pricing error
vs market

4.4ms

p99 WebSocket
latency

4.5%

VaR breach rate
5% nominal

C++ Black-Scholes + Monte Carlo pricing engine with analytic Greeks, validated to <0.01% against real market option prices via per-strike implied-vol inversion across 335 liquid SPY/AAPL options.
GPU-accelerated Monte Carlo (Apple Metal, Philox PRNG): 69× over vectorized NumPy at 10M paths, 23.5× at the typical 1M-path workload — full host↔GPU transfer included, M3 10-core GPU. CPU path also SIMD + multithreaded (3.8–4.1× over NumPy).
Portfolio VaR backtested on 4 years of real multi-asset data: breach rate 4.5% vs. 5% nominal over 851 days, captured the April 2025 tariff shock.
FastAPI WebSocket streaming to a Next.js scenario-analysis dashboard — p99 4.4ms end-to-end (localhost), validated end-to-end with Playwright.

~/codeshift — main

active

↗ repo

CodeShift

LLM Python 2→3 Migration Tool & Benchmark

parso LangChain Gemini 2.5 Flash Claude Sonnet 4.6 Python

95.1%

pass rate
41 cases

byte≡

Gemini = Claude
pass/fail results

pre-registered
test cases

2/41

shared failures
same root cause

Migration agent: parso-based analyzer (Python 2 can't be parsed by Python's native ast) + LangChain repair loop with a sandboxed test-feedback cycle.
41-case behavioral benchmark with a pre-registered failure taxonomy written before results were collected; every oracle bite-checked to fail on unmigrated source before measurement.
Gemini 2.5 Flash and Claude Sonnet 4.6 produced byte-identical pass/fail on all 41 cases (95.1%), both failures isolating a shared, cross-model inability to emit raise … from None during exception migration.

skills

Languages

Python

TypeScript · JavaScript

Java

C · C++ · C#

Swift

Racket · Lisp · Scheme

SQL · GraphQL · Cypher

HTML / CSS

AI / ML

TensorFlow · Keras

Scikit-learn

NumPy · Pandas

OpenCV · Matplotlib

LLM / Agents

LangChain

LangGraph

LlamaIndex

RAG

Vector Embeddings

Web

React · Next.js

Node.js

FastAPI

Flask · Django

Electron · SwiftUI

Tailwind CSS · Vite

Systems

Apple Metal GPU

SIMD / NEON

Multithreading

pybind11

Data & Cloud

PostgreSQL

Neo4j · Pinecone

Supabase

AWS (EC2) · Azure

Vercel · Render

Cloudflare Workers

Fly.io · Docker

BullMQ

APIs / Integrations

OpenAI · Gemini

Grok

Perplexity Sonar

Twilio · ElevenLabs

Spotify · VAPI

Tools & Libraries

Git · Bash · Linux

CI/CD

Cursor · Figma

Postman · JIRA

D3 · framer-motion · gsap

Jest · Selenium

BeautifulSoup

github

contribution activity @gkhurana21 ↗

less more