Available for data analyst roles · Bangalore

Turning raw tables into decisions worth acting on.

I'm Divya, a data analyst who cleans messy datasets, builds dashboards people actually use, and explains what the numbers mean in plain language. SQL, Python and Power BI are my main tools.

View projects Email me
 
 
0
churn rate
0
revenue lost
0
customers
Divya S
01

About

I'm an MCA graduate (2026) with a foundation in statistics and data analysis, and hands-on experience turning spreadsheets and databases into dashboards that hold up under real questions from stakeholders.

My work spans the full pipeline: cleaning and validating messy data, writing SQL to answer specific business questions, building interactive Power BI and Excel dashboards, and explaining findings to people who don't want to read a query. I've applied this across restaurant, retail, telecom and gaming datasets.

Currently based in Bangalore and looking for data analyst roles where I can keep doing this — closer to real business decisions.

0
End-to-end analytics projects shipped
0
Records analyzed in restaurant EDA internship
0
MCA CGPA (/10)
02

Skills

sql_and_querying

  • Advanced SQL
  • CTEs & Subqueries
  • Joins
  • Window functions
  • Query optimization

python_and_etl

  • Pandas / NumPy
  • Data profiling & cleaning
  • Snowflake (familiar)
  • dbt (familiar)

visualization

  • Power BI + DAX
  • Excel (pivots, interactive reports)
  • Matplotlib / Seaborn
  • Plotly

analysis

  • Root cause analysis
  • A/B testing
  • Data reconciliation
  • Stakeholder communication
03

Projects

Customer Churn Analysis Dashboard in Power BI
Project 01

Customer Churn Analysis Dashboard

Structured and validated telecom churn data in MySQL, resolved data-quality issues in the TotalCharges field, then built SQL logic to calculate churn KPIs across contract types, payment methods and tenure. The Power BI dashboard tracks churn rate, revenue lost, and customer segments in real time.

SQLMySQLPower BIDAX
View repository
Retail Sales Analytics Dashboard in Power BI
Project 02

Retail Sales Analytics Dashboard

Built an interactive Power BI dashboard analyzing sales, profit margin and discount impact across regions, categories and products. Regional revenue analysis and profit-vs-discount scatter views surfaced where discounting was actually eroding margin.

SQLPower BIDAX
View repository
Walmart Sales and Inventory Dashboard home screen built with Streamlit
Project 03

Walmart Sales & Inventory Dashboard

An interactive Streamlit app for sales performance and inventory optimization — restocking recommendations, overstock risk flags, and demand trends, built entirely in Python.

PythonStreamlitPandas
Open live app
Cookie Cats A/B test retention comparison chart
Project 04

Cookie Cats A/B Testing Analysis

Statistical analysis of a mobile game's gate-placement experiment. Used chi-square testing on retention data to evaluate whether moving the game's first paywall actually changed player engagement.

PythonChi-SquareSeaborn
View repository
ROC curve comparing Logistic Regression, Random Forest and HistGradientBoosting models Random Forest feature importance chart for churn prediction model
Project 05

Quick-Commerce Churn Prediction

An end-to-end ML project for a growth use case: predicting which customers on a quick-commerce app will stop ordering in the next 30 days. Built a SQL feature-engineering layer (CTEs, window functions) on top of raw order data, then trained and compared Logistic Regression, Random Forest and HistGradientBoosting models — evaluated on ROC-AUC, PR-AUC and F1, with feature importance surfaced for the growth team to act on.

Pythonscikit-learnMySQLFeature Engineering
View repository
04

Experience

Dec 2024 – Jan 2025

Data Analyst Intern

Cognifyz Technologies · Data Analytics & Visualization
  • Ran exploratory data analysis on 9,551 restaurant records to identify cuisine trends, city-wise distribution and pricing patterns
  • Cleaned and validated raw data to prepare it for accurate analysis
  • Evaluated how online delivery availability relates to restaurant ratings across segments
  • Built visualizations in Pandas, Matplotlib and Seaborn and translated findings into business insights
Restaurant customer experience analysis charts
Aug 2026

Data Visualisation Job Simulation

Tata Consultancy Services · via Forage
  • Completed a simulation building data visualizations for a TCS client scenario
  • Prepared discussion questions for a simulated client leadership meeting
  • Created visuals aimed at supporting executive decision-making
05

Education & certifications

Master of Computer Applications

Acharya Institute of Technology, Bengaluru
2026 · CGPA 8.70/10

Bachelor of Computer Applications

Bangalore University
CGPA 8.09/10

Data Analysis Certification

Tutedude
June 2025