Available for Backend Internship · 2026

Satyendra
Yadav

Backend developer with hands-on experience in Node.js, Express.js & PostgreSQL. I build scalable APIs, optimise databases, and ship reliable systems.

View Projects Get in Touch
#1200+
codeforces
7.5
CGPA
Minor
Entrepreneurship
Featured Work

Projects

02
★ Featured
MERN Stack Blog — Content Management System

Developed a dynamic full-stack blogging platform featuring a secure administrative dashboard. Built to handle rich text content, user authentication, and seamless CRUD operations with a responsive UI.

  • Architected a NoSQL database schema using MongoDB for flexible blog post structures and user profiles
  • Integrated JWT-based authentication and secure password hashing with bcrypt for protected admin routes
  • Developed a robust backend with Express.js managing image uploads, post filtering, and category-based sorting
  • Built a responsive React frontend utilizing state management for real-time content updates and persistent sessions
  • Implemented an interactive dashboard for creators to write, edit, and delete posts with live preview capabilities
MongoDB Express.js React Node.js JWT Bcrypt Mongoose Multer Redux/Context API
→
01
★ Featured
Expense Splitter — Full-Stack REST API

Built a production-grade Splitwise-like platform from scratch. Designed and implemented a complete RESTful backend with multi-table transactional logic, session management, and a React frontend.

  • Designed normalised PostgreSQL schema across 6 tables: Users, Friends, Groups, Expenses, ExpenseSplits, Balances
  • Implemented atomic transactions (BEGIN/COMMIT/ROLLBACK) ensuring balance consistency across expense splits & settlements
  • Built 15+ REST API endpoints with proper HTTP status codes, CORS, cookie-based auth sessions
  • Enforced bidirectional friendship inserts and symmetric balance entries in single transactions
  • React frontend with protected routes, real-time balance reconciliation, and "Settle Up" flows
Node.js Express.js PostgreSQL React REST API bcrypt pg Pool Transactions CORS
→
02
Course Registration Portal — Node.js Backend

End-to-end course registration system with server-side rendered views, session-based auth, and critical business logic for slot conflict detection, credit limits, and capacity checks.

  • Implemented SQL injection–safe parameterised queries throughout the entire backend
  • Built role-based access control differentiating Student and Instructor flows
  • Enforced multi-constraint registration logic: slot clash, 24-credit cap, capacity, duplicates
  • Instructor override mode: allows registration past credit limit with explicit warning
  • Session middleware (isAuthenticated) protecting all dashboard & registration routes
Node.js Express.js PostgreSQL EJS Templates Sessions dotenv SQL Injection Prevention
→
03
Vector Indexing & RAG Pipeline — pgvector + LLM

Built a Retrieval-Augmented Generation system over a 1000-movie IMDB database using pgvector in PostgreSQL. Benchmarked HNSW vs IVFFlat index performance across multiple distance metrics.

  • Generated vector embeddings using SmolLM2 (135M) via Ollama for 1000+ movie overviews
  • Implemented approximate k-NN search with Euclidean, Cosine, Inner Product, and Manhattan distance operators
  • Benchmarked No-Index vs HNSW vs IVFFlat (lists=100) for build time and query latency
  • Built complete RAG pipeline: embed query → retrieve top-k → inject into LLM prompt → generate answer
PostgreSQL pgvector Python psycopg2 Ollama HNSW IVFFlat RAG LLM
→
04
Database Query Plan Analysis & Indexing

Deep-dive investigation into PostgreSQL query planning, simulating real production incidents. Analysed sequential scans, bitmap index scans, nested loop joins, and the NULL semantics of NOT IN vs NOT EXISTS.

  • Reproduced and resolved a slow-query incident on a 10,000-row IPL deliveries table using B-tree index creation
  • Measured insert overhead with vs without primary key constraints using EXPLAIN ANALYSE
  • Demonstrated NULL-handling pitfalls of NOT IN under three-valued SQL logic, compared to NOT EXISTS
  • Triggered and explained Bitmap Index Scan, Index Nested Loop Join, and partial index scenarios
PostgreSQL EXPLAIN ANALYSE B-tree Index Query Planning Bitmap Scan Nested Loop Join SQL
→
05
Big Data Fraud Detection — Apache Spark

Parallelised analysis of large-scale transaction datasets using PySpark to detect fraudulent user behaviour patterns. Implemented both RDD and DataFrame APIs for different analytical tasks.

  • Processed movie co-watch sessions using Spark RDDs to generate pairwise similarity scores and top-5 co-occurrence rankings
  • Analysed millions of UPI/card transactions using DataFrame API to flag users by transaction count, city spread, and failure rate
  • Defined multi-criterion suspicion rules: >5000 transactions OR >10 distinct cities OR >50 failed transactions
PySpark Apache Spark RDD API DataFrame API Python Big Data Distributed Computing
→
Technical Stack

Skills

⚙️
Backend
Node.js Express.js REST API Design Session Auth bcrypt Middleware
🐘
Databases
PostgreSQL pgvector SQL Transactions Query Optimisation Indexing pg / psycopg2
⚛️
Frontend
React React Router Vite HTML/CSS EJS REST Fetch API
🔬
Data & ML Infra
PySpark Apache Spark Vector Embeddings RAG Pipelines Ollama Python
Academic Background

Education

B.Tech, Computer Science & Engineering · 2024–2028
  • Codeforces 1200+
7.5
CGPA
Jawahar Navodaya Vidyalaya
Intermediate · 2021–2023
87.50%
Percentage
Jawahar Navodaya Vidyalaya
Matriculation · CBSE · 2021
91.2%
Percentage

Let's Build Together

Open to backend internship opportunities. Skilled in Postgres, Express.js & Node.js

y0307satyendra@gmail.com LinkedIn GitHub