Portfolio

Gaurav Sharma

Data Analyst · Data Science · Machine Learning

I turn messy, inconsistent data into dashboards and recommendations people actually act on. Python, SQL, Power BI, and applied LLM / fine-tuning work.

About

At Carrier Compiler, I built Power BI dashboards tracking enrollment, revenue, and performance across a multi-course ed-tech catalog — using SQL to extract and query the data and Excel to clean it before it reached a chart.

On my own projects I go end-to-end: a churn dashboard on 7,043 telecom customers that isolated a ~65% churn high-risk segment and produced six prioritized retention recommendations; a two-page Superstore sales dashboard with a 15-day forecast; and an exploratory analysis of 5,000 movies testing whether critical acclaim predicts revenue (it doesn't — ~0.03 correlation; budget is the real driver).

I also spent two years teaching Maths and CBSE Computer Science to students aged 11–18, which is where I actually learned the skill that matters most in this work: explaining what a number means to someone who doesn't want the methodology, just the answer.

Outside core analytics, I build with LLMs and fine-tune small models (LoRA/PEFT) — not to chase the hype, but because understanding how the models work makes me faster at knowing when not to reach for one.

Skills

Analysis & BI

SQL / PostgreSQL Power BI Power Query / DAX Tableau Excel Data Cleaning Statistics

Programming

Python Pandas Git EDA

ML / AI

PyTorch LangChain RAG Vector DBs LoRA / PEFT fine-tuning

Experience

Human Resources Intern

Cook N Klean · Remote
  • Managed recruitment and hiring for ~25–30 candidates across multiple departments.
  • Coordinated candidate sourcing, resume screening, interview scheduling, and recruitment communication.
  • Evaluated candidates on job requirements, skills, and role suitability.

Computer Science & Math Teacher

Self-Employed · Agra, India · Hybrid
  • Taught Mathematics (Grades 6–10) and Computer Science (Grades 11–12), building conceptual understanding and problem-solving skills.
  • Mentored 20 students through personalized instruction and exam preparation.
  • Achieved an 80% pass rate, with all 20 students passing with excellent marks.

Human Resources Intern

The Entrepreneurship Network · Remote
  • Recruited 20+ candidates across Data Analyst, Data Science, and Machine Learning roles.
  • Screened and evaluated 50+ resumes per week for technical skills and role suitability.
  • Managed candidate shortlisting and initial talent evaluation.

Data Analyst Intern

Carrier Compiler · Remote
  • Built interactive Power BI dashboards on sales data for a multi-course ed-tech platform, tracking course-wise enrollment, revenue, and performance trends.
  • Used SQL to query and extract data, and Excel to clean and preprocess raw datasets.
  • Performed statistical analysis and designed visualizations letting stakeholders compare performance across a large course catalog.

Projects

Telecom Customer Churn Dashboard

End-to-end Power BI dashboard on 7,043 IBM Telco customers. Engineered tenure/charge-band features, authored DAX for churn & retention rate. Found month-to-month contracts churn at 43% vs. 3% for two-year contracts; isolated a ~1,100-customer, ~65%-churn high-risk segment and delivered 6 prioritized retention recommendations.

Power Query · DAX · Power BI

Superstore Sales Dashboard

Two-page Power BI dashboard on 5,901 Superstore transactions (2019–2020) with a 15-day sales forecast and region-level profit analysis. Solved real data-prep issues — locale date formats and #N/A handling — for a clean, refresh-ready model.

Power BI · DAX

Movie Industry EDA

End-to-end exploratory analysis on the TMDB 5000 Movies dataset, parsing nested JSON columns (genres, cast, crew). Tested whether critical acclaim drives box-office success — found a weak ~0.03 correlation, with budget the strongest predictor — and shipped the finding as a structured report with 5+ visualizations.

Python · Pandas · Matplotlib · Seaborn

SQL Data Analysis Project

A SQL-based analysis of global layoff trends across companies, industries, stages, and countries — a complete workflow from raw data to cleaned, query-ready tables and findings.

SQL

AirBnB Tableau Project

Tableau-based BI project analyzing Airbnb listing performance, pricing patterns, and revenue trends, including the workbook and source dataset.

Tableau

Excel Data Analysis Project

Professional Excel-based BI project analyzing bike purchase behavior across customer demographics, income levels, education, region, and product ownership patterns.

Excel

F1 Lap Time Predictor

Collects and prepares Formula 1 race-lap data via a FastF1 pipeline, then evaluates an XGBoost model for lap-time prediction.

Python · FastF1 · XGBoost

EduLora — Text Fine-Tuning

Lightweight educational fine-tuning pipeline for Qwen3 0.6B. Reads source documents from PDF, TXT, DOCX, and EPUB, cleans and normalizes the text, and builds a supervised chat dataset.

Python · LoRA / QLoRA

AI Multi-Research Agent

A four-stage multi-agent research pipeline: a search agent, a reader/scraper agent, a writer chain, and a critic chain work together to turn a topic into a structured report.

Python · LangChain · Streamlit

Knight-Sight

Image-based Automatic Number Plate Recognition (ANPR) for vehicle detection, license plate localization, and OCR, with a Streamlit dashboard and a YOLOv8 training utility.

Python · YOLOv8 · Streamlit

HR Analytics

Employee attrition analysis on a structured HR dataset, visualizing key workforce trends through a Power BI dashboard.

Power BI

Madhav Store Dashboard

Sales and business performance dashboard for an e-commerce dataset, combining order-level transaction details with customer and geographic metadata.

Power BI

Education & Certifications

B.Tech, Computer Science & Engineering

Dr. A.P.J. Abdul Kalam Technical University
  • Participated in Smart India Hackathon (SIH) — Early Wheat Disease Detection System.
  • Top 10 finalist at Deepsight Hackathon among 50 teams.

10+2, Central Board of Secondary Education

Attended iSmart Session — exposure to AI/ML, Python, communication

Certifications

Introduction to Agent Skills — Anthropic Prompt Engineering and AI Agents with ChatGPT — LinkedIn