Skip to content
View prathamagrawal's full-sized avatar
🌟
Working
🌟
Working
19 followers · 12 following

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Block or report prathamagrawal

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
prathamagrawal/README.md 
██████╗ ██████╗  █████╗ ████████╗██╗  ██╗ █████╗ ███╗   ███╗
██╔══██╗██╔══██╗██╔══██╗╚══██╔══╝██║  ██║██╔══██╗████╗ ████║
██████╔╝██████╔╝███████║   ██║   ███████║███████║██╔████╔██║
██╔═══╝ ██╔══██╗██╔══██║   ██║   ██╔══██║██╔══██║██║╚██╔╝██║
██║     ██║  ██║██║  ██║   ██║   ██║  ██║██║  ██║██║ ╚═╝ ██║
╚═╝     ╚═╝  ╚═╝╚═╝  ╚═╝   ╚═╝   ╚═╝  ╚═╝╚═╝  ╚═╝╚═╝     ╚═╝

Software Engineer · Data Infrastructure · AI Systems

Email LinkedIn GitHub Kaggle Phone

> whoami

pratham = {
    "role"      : "Software Engineer @ Affinsys.ai",
    "location"  : "Bangalore, India",
    "education" : "B.Tech CS (Data Science) · VIT Vellore · CGPA 9.25",
    "focus"     : ["Data Infrastructure", "LLM Systems", "Distributed Architecture"],
    "prev"      : "SDE Intern @ CME Group",
    "open_to"   : "SDE-1 / Data Engineer roles · Bangalore / Delhi NCR",
}

Building systems where data pipelines meet intelligence — from NLQ→SQL platforms to event-driven warehouses, I ship infrastructure that scales and sticks.

> experience --verbose

🏢 Affinsys.ai  ·  Software Engineer  ·  Jan 2024 – Present

Service What I Built Impact
DBOps LLM-driven system using Claude to synthesize executable ETL pipelines from natural language, with schema validation & iterative correction loops Reliable NL→ETL at scale
Datalens NLQ→SQL analytics platform with secure sanitisation, metadata-driven query gen, reusable chart catalogs & 15+ dynamic chart types ↓ 80% dashboard creation time
Analytics End-to-end service powering 20+ dashboards & 200+ charts with real-time insights, materialized SQL views, and an automated report scheduler for 100+ recurring reports ↓ 40% query overload
Archival Distributed archiving across 10+ services — referential integrity, failover strategy, purge algorithm, MinIO → AWS S3 migration Zero data loss guarantee
Eventlogger High-performance event-driven data warehouse aggregating from 10+ services (AMQP/NATS) into 40+ tables with async writes Rapid cross-service analytics

🏢 CME Group  ·  SDE Intern  ·  May 2023 – Nov 2023

  • Re-engineered critical report & email generation algorithms → ↑ 30% performance
  • Built advanced data extraction & processing tools → ↓ 40% latency

> projects --pinned

🗄️ Mirror-DB

Kubernetes · PostgreSQL · PgBouncer · Helm

Enterprise-grade PostgreSQL HA cluster with:

  • ⚡ Sub-minute automatic failover
  • 🔌 70–90% connection overhead reduction via PgBouncer
  • 🔄 Multi-tier sync/async replication across 4-node cluster
  • 🏷️ Dynamic service discovery with automated pod labeling
  • 📊 Comprehensive monitoring stack

🪵 LogHive

Python · RabbitMQ · Redis · PostgreSQL · Docker

Scalable log archival system built for the long haul:

  • 🌊 Handles petabyte-scale data
  • ✅ 99.99% reliability with advanced compression
  • 📈 Adaptive consumer scaling & producer rate limiting
  • 🛡️ Prevents system overload under burst traffic

> tech_stack --list-all

┌─────────────────────────────────────────────────────────────────┐
│  LANGUAGES        Python · Golang · C · C++ · SQL               │
│  DATABASES        PostgreSQL · Oracle · MongoDB · Data Warehouse │
│  STREAMING        Kafka · RabbitMQ · NATS · AMQP                │
│  DATA SCIENCE     Apache Airflow · Spark · Hadoop · Astro        │
│  CLOUD & INFRA    AWS · Docker · Kubernetes · GitHub Actions     │
│  OBSERVABILITY    Tableau · Materialized Views · Custom Metrics  │
│  AI/LLM           Claude API · NLQ→SQL · ETL Pipeline Gen        │
└─────────────────────────────────────────────────────────────────┘

Python Go PostgreSQL Kafka Docker Kubernetes AWS Apache Spark Apache Airflow Redis RabbitMQ MongoDB

> achievements --highlight

🏆  Chairperson @ IET-VIT
    └── Hosted technical events · 25% net profit · Mentored 200+ members

🥉  3rd Place · TRI-NIT Hackathon 2023
    └── Project: Clusterbase

🥇  Sponsor Track Winner · Devspace 2022 by CSI-VIT
    └── Project: Sportlight

🎖️  Google Cloud Computing Foundations — Certified
🏅  Kaggle Contributor — 4× Bronze Medal (Notebooks & Datasets)

> github --stats

   
"Ship infrastructure that outlasts the sprint."

Open to SDE-1 & Data Engineer roles · Bangalore / Delhi NCR

Email Me Connect

Pinned Loading

  1. mirror-db mirror-db Public

    This repository contains a comprehensive PostgreSQL High Availability setup using **pg_auto_failover** with **PgBouncer** connection pooling on Kubernetes. The cluster provides automatic failover, …

    Shell

  2. LogHive LogHive Public

    Python 2 1

  3. ClusterBase ClusterBase Public

    Forked from 1407arjun/TRINIT-Conda-Activate-Venv-DEV04

    Clusterbase is a system that is easily configurable on the number and type of parameters and clustering rules, where in the clustering happens in real time with the values dynamically provided by t…

    TypeScript

  4. Crypto2csv Crypto2csv Public

    Crypto2csv is a python package accessible via command line for accessing crytocurrencies data in a readable csv format.

    Python 1

  5. sportlight sportlight Public

    Forked from 1407arjun/sportlight

    A solution for highlights extraction for sports games by The Unknowns.

    JavaScript

  6. Analysing-Olympics-Dataset Analysing-Olympics-Dataset Public

    Jupyter Notebook 3