Skip to content
View sahil-mangla's full-sized avatar

Block or report sahil-mangla

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.

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
sahil-mangla/README.md

Sahil Mangla

Computer Engineering student at Thapar Institute of Engineering & Technology passionate about AI systems, machine learning, backend engineering, and database infrastructure.

I enjoy building production-ready software that combines machine learning, databases, distributed systems, and modern AI tooling. My recent work spans NLP, time-series forecasting, database administration, telemetry pipelines, MLOps, and open-source software.


Current Focus

  • Building production AI and data infrastructure
  • Designing scalable telemetry and monitoring systems
  • Exploring Agentic AI and Model Context Protocol (MCP)
  • Contributing to open source and production engineering projects

Selected Projects

Trend Discovery Engine

An NLP platform that analyzes Hacker News discussions to identify emerging technology trends.

  • Clustered 2,000+ Hacker News discussions into 85 semantic topics using Sentence Transformers, UMAP, and HDBSCAN.
  • Built forecasting pipelines using Linear Regression, XGBoost, and LSTM with MLflow experiment tracking.
  • Generated natural-language trend summaries using Gemini.

Stack: Python • PyTorch • Sentence Transformers • HDBSCAN • UMAP • MLflow • Streamlit


SQL Server Database Health Dashboard

Production-oriented database monitoring framework developed during my internship at DCM Infotech.

  • Built a modular health monitoring engine using SQL Server DMVs and Extended Events to analyze index fragmentation, storage utilization, transaction log health, and deadlock telemetry.
  • Designed a configuration-driven architecture with reusable T-SQL views, stored procedures, historical snapshot collection, and executive health reporting.
  • Developed a reproducible validation laboratory covering fragmentation, storage, Write-Ahead Logging (WAL), recovery models, deadlock detection, and end-to-end dashboard validation.

Stack: SQL Server • T-SQL • DMVs • Extended Events • Database Administration


Database Auditing & Backup Verification System

Database auditing and disaster recovery automation platform built during my internship.

  • Automated backup verification and restore validation across production databases.
  • Developed trigger-based field-level auditing using PostgreSQL and PL/pgSQL.
  • Implemented SHA-256 integrity verification for backup validation and disaster recovery workflows.

Stack: PostgreSQL • PL/pgSQL • Python • Docker


Open Source

I enjoy contributing to production-grade open-source software and learning from large engineering codebases.

Recent contributions include Codebase Memory MCP, Pytorch, where I investigated indexing failures on large repositories, identified memory bottlenecks, proposed production fixes, and contributed improvements to developer tooling.


Technologies

Languages

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

Machine Learning

PyTorch • Scikit-learn • XGBoost • LSTM • Sentence Transformers • HDBSCAN • UMAP • MLflow

AI Engineering

Gemini API • Prompt Engineering • Model Context Protocol (MCP)

Backend

FastAPI • REST APIs • Next.js • Streamlit

Database Engineering

SQL Server • PostgreSQL • Oracle Database • T-SQL • PL/pgSQL • Database Administration • Query Optimization • Backup & Recovery • Performance Monitoring

DevOps

Docker • Git • GitHub • Hugging Face Spaces • Firebase • Vercel


Achievements

  • 🏆 Winner — International AI for Sustainability Hackathon 2026 (1st Place among 200+ teams)
  • 🏆 Winner — TIET Business Hackathon 2024

Connect

Pinned Loading

  1. Dust-Shield Dust-Shield Public

    An interactive, browser-based 3D digital twin and operations control dashboard for the Electrodynamic Dust Shield (EDS) lunar mission. This application visualizes lunar orbit navigation, surface la…

    JavaScript

  2. TraffiTwin-AI TraffiTwin-AI Public

    TraffiTwin AI is an AI-powered, self-healing traffic digital twin designed to maintain continuous situational awareness for urban transportation networks during telemetry outages.

    Python

  3. trend-discovery-engine trend-discovery-engine Public

    TechIntel is an AI-powered technology intelligence platform that discovers, forecasts, and analyzes emerging trends from Hacker News discussions.

    Python

  4. Volt-AI Volt-AI Public

    Python