Skip to content
View harshithbandari's full-sized avatar

Block or report harshithbandari

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
harshithbandari/README.md
Profile views
wave

Hi, I'm Harshith Bandari


About Me

I'm a Data & Business Analytics student who turns raw, messy data into decisions people can act on. I like owning the full loop β€” cleaning data, validating it statistically, building predictive models, and translating the results into dollars and clear recommendations. Currently open to analytics internships.

  • πŸ”­ Building end-to-end analytics projects across churn, NL-to-SQL, NLP, healthcare, and supply chain
  • πŸ“Š Past work: marketing analytics at IAMRATAN β€” funnel analysis, CAC/LTV, and attribution
  • 🧠 Comfortable across the stack: SQL β†’ Python β†’ machine learning β†’ Tableau dashboards
  • 🎯 I care most about the "so what" β€” the business decision behind the number
  • 🌱 Always sharpening my skills in stats, ML, and data storytelling

πŸ› οΈ Tech Stack

Languages & Databases

Python SQL SQLite

Data & Machine Learning

pandas NumPy scikit-learn SciPy Matplotlib

BI & Tools

Tableau Streamlit Git GitHub


πŸš€ Featured Projects

SQL Β· Python Β· scikit-learn Β· Tableau

End-to-end pipeline that predicts churn and quantifies the revenue at risk.

  • πŸ’° Identified ~$544K/year in retainable revenue from the high-risk segment
  • 🎯 Churn model reaches ROC-AUC 0.85 (76% accuracy, 74% precision)
  • πŸ“Š Chi-square validation + risk-scoring + a live Tableau dashboard

Python Β· SQL Β· Streamlit Β· pytest

Turns plain-English business questions into safe, read-only SQL, then returns tables and charts.

  • 🧩 Deterministic, schema-aware parser: 5 metrics Γ— 8 dimensions, correct multi-table JOINs
  • πŸ›‘οΈ Read-only safety layer blocks destructive queries; auto-injects LIMIT
  • βœ… 17 passing unit tests + an interactive Streamlit app

Python Β· scikit-learn Β· NLP

NLP pipeline that turns thousands of free-text reviews into decisions.

  • 🎯 Sentiment model at 87.9% accuracy (TF-IDF + Logistic Regression, weak supervision from star ratings)
  • 🧠 KMeans theme discovery + aspect-based sentiment to rank pain points
  • 🚨 Auto-flags feature requests and urgent reviews into a triage queue + dashboard

Python Β· Classification

Healthcare classification model that predicts appointment no-shows and scores patients by risk, so clinics can target reminders where they matter most.

Python Β· Time-Series

Supply-chain project forecasting demand and optimizing inventory levels to balance stockouts against holding costs.


πŸ“Š GitHub Activity

GitHub Streak
Contribution Graph

🀝 Let's Connect


Open to data & business analytics internships. Let's turn data into decisions. πŸ“Š

Pinned Loading

  1. nl-sql-analytics-engine nl-sql-analytics-engine Public

    Ask business questions in English β†’ safe read-only SQL + charts. Interactive BI dashboard over a 16.5K-row e-commerce warehouse, with a deterministic parser and a validated safety layer. Python + S…

    Python

  2. review-intelligence-nlp review-intelligence-nlp Public

    NLP pipeline for review sentiment, themes, and triage.

    Python

  3. customer-churn-analytics customer-churn-analytics Public

    End-to-end customer churn analytics: SQL, Python, machine learning, and a Tableau dashboard.

    HTML

  4. demand-forecasting-inventory demand-forecasting-inventory Public

    Demand forecasting & inventory optimization: Python time-series analysis (supply chain).

    HTML

  5. coffee-brand-growth-dashboard coffee-brand-growth-dashboard Public

    Coffee-brand growth & customer analytics dashboard.

    HTML

  6. streamly-subscription-analytics streamly-subscription-analytics Public

    Subscription growth & retention analytics (MRR, NRR, churn, cohorts) with a Power BI-styled dashboard.

    HTML