my name is

Ajay Thomas — Data Analyst

Data AnalystOpen to data & software roles · India / RemoteVellore, IN

I turn messy data into numbers you can trust.

CS undergrad at VIT (CGPA 9.01) who turns messy operational data into numbers people can act on — SQL funnels, data-quality checks, automated reporting and LLM-assisted analysis, each with its sample size and caveat.

about me!

what's up

DEV IDCLASS OF 2027

AJAY
THOMAS

Data Analyst

base
Vellore, IN
gpa
9.01
access
root
status
open

I'm a CS undergrad who gets a little too excited when a number looks surprising, because it usually means a bug. I check the denominator, the duplicates and the export format before I believe a result.

These days that means SQL funnels and window functions in PostgreSQL, data-quality checks in Python, and dashboards that show every rate with its n and caveat.

AJAY.DEV

vellore · open 24/7

  • records / day20K+
  • report time1h → mins
  • bank clients41K
  • transcripts8K
  • DQ checks32
  • VinHack builders300+

GPA9.01

TOTALhire me

thank you, come again!

SQLPythonPandasPostgreSQLStreamlitLLM evaluation

education

B.Tech in Computer Science and Engineering

Vellore Institute of Technology (VIT) · Vellore, India · GPA 9.01 · Expected March 2027

Sacred Heart International School

Class XII, ISC: 91.6% · Class X, ICSE: 94.3% · 2021 – 2023

the resume bits

where I've worked

Jun 2025 – Jul 2025Chennai, India

Software Developer Intern

Securra Health

  • Cut report generation and verification from ~1 hour to minutes for 20K+ records/day by automating daily, weekly and monthly reports with SQL Server queries served through FastAPI.
  • Replaced manual reporting for senior management by building ETL pipelines (SQL Server → Pandas → OpenPyXL) that produce pivot-based XLSX reports for any custom date range.
Jan 2026 – PresentVellore, India

Secretary

VinnovateIT — Technical Club, VIT

  • Delivered VinHack 2026, a 30-hour hackathon for 300+ builders in 120+ teams, coordinating volunteers and faculty.
  • Shipped the Next.js + MongoDB portal for B3 to 200+ participants in 45+ teams, leading 4 developers.
  • Led digital marketing for MessIT, VIT's hostel mess-menu app with 50K+ downloads.

selected projects

things I've built

Project 01
call-campaign analytics · sql

CallOps

Call-campaign analytics on real public data: SQL funnels on 41K bank telemarketing clients, call-quality detection on 8K call-center transcripts, and a multi-model outcome audit.

  • Estimated that a 5-redial cap keeps 96% of conversions for 85% of calls, using SQL funnels and a per-attempt hazard analysis (CTEs, window functions) on 41K real bank clients.
  • Flagged severe mid-call silences in 20% of calls, with transcript samples suggesting silent form-filling, by detecting gaps with LAG() over 7.9M word-level timestamps.
  • Caught a false “7× worse” ASR-failure result for one call domain by tracing it to a different ASR export format, then measured failure stretches with per-pipeline thresholds and gaps-and-islands SQL.
  • Audited outcomes on a 200-call stratified sample with 3 AI models (Claude, DeepSeek, TypeSafe Jev; κ 0.73–0.79), routing the 27% where they disagree to human review.
  • 32 automated data-quality checks (schema drift, sentinel values, SHA-256 dedup that caught 204 duplicate transcripts) behind an 8-tab Streamlit dashboard that shows every rate with its n and caveat.
PythonPostgreSQLSQLStreamlitLLM APIs
redial-cap.svg
CallOps redial cap analysisShare of conversions kept and share of calls spent if redials are capped at call 1, 2, 3, 5 or 8. Capping at call 1 keeps 49.6% of conversions for 39.0% of calls; call 2, 75.7% for 61.2%; call 3, 88.0% for 73.5%; call 5, 96.0% for 85.4%; call 8, 98.8% for 92.6%.Where should redials stop?40%60%80%100%12345678cap redials at call #conversions keptcalls spentcap at 5: 96% keptfor 85% of calls
Project 02
llm fine-tuning · qlora

VIT Bot

A fine-tuned Qwen3.5-4B that speaks VIT student culture in five roast-y persona modes, built end to end on a laptop: scrape, clean, distill a dataset, fine-tune, export, serve.

  • Built a 3,449-example, 5-mode chat dataset by distillation: 50K cleaned r/Vit posts (PII-scrubbed, 488K comments as private context) became prompts for a teacher LLM, for about $4 in API calls under a hard budget cap.
  • Fine-tuned Qwen3.5-4B with 4-bit QLoRA in Unsloth on an 8 GB laptop GPU in 40 minutes (21M trainable parameters, loss on assistant turns only); validation loss fell from 2.59 to 2.35 with no overfitting.
  • Compared base and fine-tuned replies on held-out prompts with the adapter switched on and off under the same seed: the base model kept generic chatbot habits that the fine-tune dropped.
  • Merged and quantized to a 2.6 GB Q4_K_M GGUF running at ~14 tokens/s on CPU with llama.cpp, published on Hugging Face, with a Telegram bot and systemd deployment for a free ARM VM.
PythonUnslothPyTorchLoRA / QLoRAllama.cppHugging Face
vit-bot · /lawyer
Project 03
ai data analyst · nl-to-sql

Intelletrics

AI data analyst for CSV/Excel: ask a question in plain English and it writes SQL, runs it read-only against your data in SQLite, and shows which source columns the answer came from.

  • Deployed natural-language-to-SQL platform tested on 100K+ row datasets: grouped aggregates, rankings, time trends and window functions, with generated SQL run read-only and source-column attribution.
  • Pandas handles the automatic profiling — missing values, distributions and quartiles — while the question-answering runs as SQL.
  • Multi-provider LLM insights kept reliable with Pydantic validation and 60 pytest tests in GitHub Actions CI.
PythonSQL (SQLite)PandasFastAPINext.jsLLM APIs
intelletrics.vercel.app
Intelletrics landing page
Project 04
rag · retrieval

Freshness-Aware RAG

Retrieval-augmented generation that keeps answers grounded in the latest web scrapes while still answering questions about what a page used to say.

  • Versions chunks with content hashes so only changed content is re-embedded (MiniLM, ChromaDB), with SQLite holding the version history for historical queries.
  • Covered by 50+ pytest tests.
PythonSentence-TransformersChromaDBSQLiteFastAPI
architecture.svg
Freshness-Aware RAG architectureAPScheduler triggers a scrape through Firecrawl or HTTP. Text is chunked and each chunk hashed with SHA-256. Change detection compares against live rows: unchanged chunks are skipped, added and removed chunks are versioned in SQLite, and only added chunks are embedded with MiniLM into ChromaDB. FastAPI serves live retrieval from ChromaDB, Gemini-grounded answers, and change history from SQLite.FASTAPIAPSchedulerevery 6h · on demandScrapeFirecrawl · HTTPChunk + hashSHA-256 → chunk_keyDetect changesdiff vs. live rowsSQLitechunk_versionsscrape_runsEmbedlocal MiniLM modelChromaDBlive vectors only/historylineage/querytop-k/answerGemini-groundedsame hash→ skipadded / removed ↓only newchange history
Project 05
meeting ai · calendar

Brievo AI

Gemini-powered meeting assistant that turns transcripts into structured summaries and action items, with Google Calendar integration.

  • Extracts structured JSON summaries and action items from meeting transcripts with the Gemini API.
  • Google Calendar integration through OAuth, with Firebase for auth and meeting history.
PythonFastAPIGemini APIReactFirebase
brievo-ai.vercel.app
Brievo AI landing page

the toolbox

what I work with

PythonSQLPostgreSQLSQL ServerSQLitePandasNumPyExcelStreamlitFunnel analysisData cleaningETLLLM APIsLLM evaluationNL-to-SQLRAGFastAPIMongoDBTypeScriptC++JavaDockerGitHub ActionsAWS

Languages

Python, SQL, TypeScript, JavaScript, C++, Java

Data Analysis

Pandas, NumPy, funnel analysis, descriptive statistics, data cleaning, ETL, Excel (pivots, OpenPyXL)

AI / ML

LLM APIs (Claude, Gemini, DeepSeek), Claude Code, prompt engineering, LLM evaluation, RAG, NL-to-SQL, LoRA/QLoRA fine-tuning (Unsloth), GGUF / llama.cpp

Data & Tools

PostgreSQL, SQL Server, SQLite, MongoDB, FastAPI, Streamlit, Git, Docker, GitHub Actions CI, AWS

DSA

118 LeetCode problems (71 Medium, 6 Hard), including 11 SQL

say hi

let's build something

Open to data analyst and software roles starting 2027, internships and interesting side projects. The fastest way to reach me is email