I am a Computer Science undergraduate who builds at the intersection of data, machine learning, and analytical engineering. My work focuses on transforming raw operational data into decisions-through rigorous exploratory analysis, interpretable predictive models, and dashboards that communicate findings with clarity.
🎓 Student Performance Prediction — ML Classification Pipeline
A binary classification system that predicts whether a student will pass or fail before the exam, using behavioural and socioeconomic features. Designed to enable early intervention rather than post-exam remediation — where help can still make a difference.
| Attribute | Details |
|---|---|
| Stack | Python · Scikit-learn · Pandas · Matplotlib · Seaborn · NumPy |
| Scale | 600 student records · 8 input features · 1 binary classification target |
| Performance | Logistic Regression 94.17% · Random Forest 93.33% · Decision Tree 90.00% |
| Evaluation | Stratified 80/20 split · Confusion Matrix · Classification Report · F1-score |
| Key Insight | Study hours = 44% feature importance (Random Forest) — top actionable predictor |
| Impact | Enables early identification of at-risk students before exam outcomes are fixed |
| Repository | github.com/chinmay2705r/Student-performance-prediction |
Feature importance analysis revealed that study hours alone explains 44% of the predictive signal. This is not just a model that works — it is a model that points at something a teacher can act on. That is the difference between an ML experiment and a useful system. Logistic Regression outperformed Random Forest, suggesting the underlying decision boundary is predominantly linear — simpler models win when complexity is not warranted.
☕ Coffee Shop Sales Analysis — Business Intelligence Dashboard
End-to-end business analytics on 149,116 real transactions across 3 NYC coffee shop locations covering January to June. Objective was to identify operational patterns, peak demand windows, and store-level performance differentials to surface actionable management insights.
| Attribute | Details |
|---|---|
| Stack | Microsoft Excel · Pivot Tables · SUMIF · COUNTIF · AVERAGEIF · Slicers · Charts |
| Scale | 149,116 transactions · 3 store locations · 6 months · $698,812 total revenue |
| Performance | 6-chart interactive dashboard · Sub-second slicer response · 7 business questions |
| Evaluation | KPI cards · Month/day slicers · Category and product-level breakdown |
| Key Insight | 9–10 AM peak demand window · Hell's Kitchen leads at $236,511 · Barista Espresso top product |
| Impact | Staffing, inventory, and marketing decisions directly derivable from dashboard output |
| Repository | github.com/chinmay2705r/coffee-shop-sales-analysis |
Peak revenue at 9–10 AM across all 3 locations is directly actionable for staffing rotations. Hell's Kitchen outperforms comparable stores not in footfall but in average transaction value — a signal worth investigating for replication. The dashboard answers 7 distinct business questions without any additional analysis required.
📊 Retail Sales EDA Dashboard — Python Analytics System
Exploratory data analysis on 500+ retail orders across 5 product categories and 4 Indian metro regions. Core objective was identifying the source of profit leakage and building a visual system that communicates findings clearly enough to drive a policy recommendation.
| Attribute | Details |
|---|---|
| Stack | Python · Pandas · Matplotlib · Seaborn · NumPy |
| Scale | 500+ orders · 5 product categories · 4 metro regions · 12 months |
| Performance | 6-chart dashboard — bar · line · pie · boxplot · scatter · KPI panel |
| Evaluation | Correlation matrix · Distribution analysis · Outlier detection · Profit margin tracking |
| Key Insight | 38% of orders with discounts above 30% were directly loss-making |
| Impact | 25% discount cap recommendation projected to reduce loss-making orders by 17% |
| Repository | github.com/chinmay2705r/sales-data-analysis |
A scatter plot of sales versus profit, coloured by discount level, revealed a clear loss cluster at high discount values. The correlation was strong enough to justify a direct policy recommendation. This is the kind of output that has business value — not just a model, but a finding that can be acted on in a meeting.
Kanpur Electricity Supply Company Limited (KESCo) · June 2026 – Present · Kanpur, Uttar Pradesh, India
KESCo is the primary electricity distribution utility for Kanpur city, operating 93 substations at 33kV, 543 feeders, 201 power transformers, and serving 7 lakh+ consumers. Currently contributing to the data analytics component of their Substation Information System (SIS) modernisation programme valued at ₹234 crore.
