SELECT * FROM candidates WHERE role IN ('Data Analyst', 'Data Scientist', 'Business Analyst') AND name = 'Akshita Singh';
namerolesummarystatus
Akshita Singh Data Analyst / Data Scientist B.Tech. student at NIT Allahabad who builds end-to-end ML pipelines — from raw retail and customer data to deployed Streamlit dashboards. Strong in SQL, Python and predictive modelling, with a growing daily SQL practice habit. open_to_work
-- about

Who I am

Data is only valuable when it leads to better decisions. I enjoy exploring data, developing predictive models, and creating analytical solutions that bridge technical methods with business objectives. I'm currently building expertise in machine learning, deep learning, and business analytics while working on projects that demonstrate practical impact.

-- SELECT * FROM skills

What I work with

Languages

Python SQL C++

Machine Learning

Supervised / Unsupervised Learning Deep Learning Feature Engineering Time-Series Forecasting NLP (basics)

Libraries & Frameworks

Scikit-learn TensorFlow / Keras XGBoost Pandas / NumPy

Analytics & Visualisation

Power BI Tableau Excel Matplotlib / Seaborn
-- SELECT * FROM projects ORDER BY relevance DESC

Projects

Rossmann Store Sales Forecasting — LSTM & XGBoost

Built an end-to-end retail sales forecasting pipeline on 1.01M rows of historical data from 1,115 Rossmann stores, comparing LSTM and XGBoost on identical feature sets. Engineered lag features, rolling statistics, promotions and holiday variables per-store to eliminate cross-store data leakage. Tuned XGBoost achieved MAE 570, RMSE 799, R² 0.928, while the LSTM hit 12.27% MAPE — a 66.4% improvement over the naive baseline. Deployed as an interactive Streamlit dashboard with store-level forecast simulation, a promo toggle, and model comparison across all 1,115 stores.

PythonXGBoostLSTMStreamlit

Airline Loyalty Churn Prediction & Retention Intelligence

Built an XGBoost-based churn prediction and segmentation system on airline loyalty data covering 16,737 customer records. Engineered features from recency, flight frequency, redemption ratio and seasonal engagement trends, achieving 97% classification accuracy and a 0.97 ROC-AUC on imbalanced data through threshold tuning. Added KMeans clustering for customer segmentation and shipped an interactive Streamlit dashboard for churn analysis and retention strategy reporting.

PythonXGBoostKMeansStreamlit

Customer Segmentation & Marketing Analytics

Segmented 2,200+ customers into four behavioral groups using K-means clustering on engineered demographic and spending features, then built an interactive Streamlit dashboard translating cluster insights into targeted marketing recommendations..

PythonPCAStandardScalerKMeansStreamlit

Retail Sales Dashboard (Microsoft Excel)

Built an interactive Excel dashboard to analyze retail sales performance using Pivot Tables, Pivot Charts, and Slicers. The dashboard enables dynamic exploration of sales trends, customer demographics, regional performance, and sales channels while demonstrating data cleaning, visualization, and dashboard design skills..

Microsoft Excel Pivot Tables Pivot Charts Slicers Data Cleaning Dashboard Design
-- SELECT COUNT(*) FROM problems_solved GROUP BY platform

SQL practice tracker

0
TOTAL PROBLEMS SOLVED · LIVE
saved ✓
Numbers are entered manually since LeetCode, DataLemur, HackerRank and StrataScratch don't offer a public API for solved counts
-- SELECT * FROM education

Education

B.Tech. in Mechanical Engineering

Motilal Nehru National Institute of Technology, Allahabad · CGPA 7.49 (74.9%)
2023 – 2027

Senior Secondary (Class XII), CBSE — 89.2%

Kendriya Vidyalaya IIT, Kanpur
2022

Junior Secondary (Class X), CBSE — 93.8%

Kendriya Vidyalaya IIT, Kanpur
2020
-- SELECT * FROM leadership, achievements

Beyond the classroom

Networking Lead, Co-Coordinator & Team Member

TEDxMNNIT 2025, Renaissance 2025, Culrav & E-Cell MNNIT — led speaker outreach and professional networking for 100+ attendee events, managed crowd coordination for the annual cultural festival, and drove partnership outreach for entrepreneurship initiatives.
2025

Top 100 — HackHazards25

Secured a top 100 position among 2,900+ teams and 5,700+ solo hackers as part of the frontend development team for an AI-powered dataset generation platform.
Feb 2025