Skip to content
Deepanshu.
Resume

Hello, I'm

Deepanshu

Software Engineer · distributed systems & databases

I like the layers most people import. I built a SQL engine from the page up, studied Raft through a working replicated store, and ship backends that never trust the client.

Portrait of Deepanshu

Live system

Crash the leader.

A real Raft cluster is running in your browser — the consensus protocol behind etcd and Kubernetes. Kill any server and watch the survivors agree on a new leader.

Term
0
Leader
Committed
0

Tip: click any server to crash it — click again to bring it back.

Event log

  1. Waiting for the first election timeout…

The protocol I studied hands-on in LOCKSTEP · deterministic simulation, entirely in your browser

Internship experience

Where I've shipped

Two SDE internships — a server-authoritative contest platform and a GPS-free delivery engine.

  1. 123OfAI · Software Engineer Intern

    May – Jul 2026 · Bangalore

    Server-authoritative contest platform and an ML system-design studio.

    leaderboard ranking
    O(N) → O(log N)
    first-load JS across 220+ pages
    96 KB
    • Built a contest platform that grades untrusted user code in isolated sandboxes against server-held hidden tests, so test cases and answers never reach the client.
    • Replaced full-scan leaderboard aggregation with Redis sorted-set updates, and made grading writes idempotent so duplicate submissions and Redis outages fall back to the durable store instead of corrupting scores.
    • Shipped an ML system-design studio where deterministic rule checks gate LLM rubric evaluation across 6 segments; code-splitting with SSG + ISR kept first-load JS at 96 KB.
    • TypeScript
    • Express
    • Redis
    • Azure Table/Blob
    • Next.js 14
    • React Flow
    • Azure OpenAI
  2. Decklar · Software Engineer Intern

    May – Jul 2025 · Ahmedabad

    Sole engineer on a GPS-free, spoof-resistant proof-of-delivery engine.

    verdict accuracy on ground-truth runs
    95%
    in production in Germany
    Live
    • Verifies deliveries from ambient Wi-Fi scans alone: filters unstable access points, matches each survivor to its nearest-RSSI reference points in a multi-year wardrive database, and centroids them into a fix.
    • Clusters the reconstructed track into dwell-scored stops and returns a 4-verdict, confidence-scored output contract.
    • Shipped the customer-facing feature: a route/date picker that runs the engine on demand and plots the track with color-coded stops.
    • Python
    • pandas
    • NumPy
    • FastAPI
    • React 19
    • TypeScript
    • Leaflet

Projects

Built from first principles

A database engine you can run below, a consensus study, and an ERP in production.

Relational database engine from scratch

PRQLite

Mar 2025

Every layer hand-written in ~4,500 lines of C++17, from the character-level SQL scanner down to the pwrite() syscall. No parser generator, no embedded engine.

  • Four-stage query path: lexer → recursive-descent parser → semantic analyzer → Volcano-style iterator executor.
  • Slotted-page storage, a buffer pool with pin-count eviction, and RAII page guards over a reader–writer page table.
  • Write-ahead logging and BEGIN / COMMIT / ROLLBACK transactions backed by undo-based rollback.

● Live demo

A TypeScript browser port of the C++ engine, checked byte-for-byte against the real REPL. Run a query and watch it move through every stage.

users(id INT, name TEXT, active BOOL)

-- users is seeded with alice, bob, carol, dave and eve.
-- Pick a preset or write SQL, then Run.

Run a query. Each tab lights up as the statement passes through that stage — tokens from the lexer, the tree from the recursive-descent parser, the analyzer's checks, the Volcano operator plan, and every tuple the executor pulls.

Storage · 4 KB slotted pages

users · 260 B per row · 5 live tuples · metadata page 0

page 1 · 2772 B free

live deleted (slot zeroed, space never reclaimed) room for another row

  • C++17
  • CMake
  • Docker
  • GitHub Actions
Source

Raft-replicated key-value store

LOCKSTEP

Nov 2024

A fault-tolerant key-value store on the Raft consensus protocol, used to study consensus hands-on.

  • Leader election, quorum log replication and repair of divergent follower logs after node failures.
  • The consensus core sits behind ports and adapters, so the same node runs over gRPC or an in-memory transport.
  • A 21-case Jest suite fault-injects leader crashes mid-replication and asserts the logs converge.
  • TypeScript
  • gRPC
  • Protocol Buffers
  • Jest
Source

Full-stack ERP for InduBindu's made-to-order workflow

Enterprise Production & Order Management System

Feb 2026

Replaced manual Excel tracking for a made-to-order manufacturer with role-based dashboards.

  • Processes 1000+ orders a day end to end.
  • Integrates real-time Shopify webhooks, two courier APIs (Shiprocket, Delhivery) and barcode-based tracking.
  • React
  • Node.js
  • Shopify webhooks
Source

Skills

Tools I reach for

Languages

  • TypeScript
  • JavaScript
  • Python
  • C++
  • SQL

Frontend

  • React
  • Next.js
  • Angular
  • HTML/CSS
  • Tailwind
  • React Flow
  • Leaflet
  • Vite

Backend

  • Node.js
  • Express
  • NestJS
  • FastAPI
  • REST
  • gRPC / Protocol Buffers
  • WebSockets
  • Webhooks

Databases

  • PostgreSQL
  • Redis
  • Azure Table Storage (NoSQL)
  • MongoDB

Testing & Automation

  • Jest
  • Supertest
  • Playwright
  • pytest
  • Selenium
  • Cucumber (BDD)
  • Robot Framework
  • Postman

Cloud, DevOps & AI Tools

  • Azure (Blob, Table, OpenAI)
  • Docker
  • Linux
  • Git
  • GitHub Actions CI/CD
  • Claude Code
  • GitHub Copilot

Concepts

  • Distributed consensus
  • Concurrency
  • Database internals
  • System design
  • DSA

Education

The fundamentals

IIT Jodhpur, and the roles I took on there.

Indian Institute of Technology, Jodhpur

Aug 2023 – Apr 2027 (expected)

B.Tech. in Computer Science and Engineering

CGPA

9.17 / 10

Coursework

  • Data Structures & Algorithms
  • Operating Systems
  • Databases
  • Computer Networks
  • Distributed Systems
  • Object-Oriented Programming
  • Software Engineering
  • Machine Learning
  • May 2026 – present · IIT Jodhpur

    Overall Coordinator, Career Development Cell

  • Aug – Nov 2025 · IIT Jodhpur

    Teaching Assistant, Data Structures & Algorithms

Contact

Get in touch

Let's build something that doesn't fall over.

Email is the fastest way to reach me.

deepanshu280607@gmail.com

Jodhpur, India

Thanks for visiting

If something here resonated, I'd love to hear from you.