Open for roles & projects

Turning data into insights, and ideas into websites.

I'm Mehwish, a Computer Science graduate building a career in data science and analytics. I also make dashboards and websites for people who need them.

9.25CGPA, B.E. CS
2+internships
5+projects built
1published paper
it-ticket-dashboard · from my Excel analysis
Tickets by request category
Ticket type and priority
Selected work

Projects that do something.

01

GDP & Productivity of Indian Cities

A Streamlit app for exploring GDP growth, employment trends and sector contributions across Indian cities. It has interactive line, bar and pie charts, city and year filters, an embedded Power BI dashboard, login and signup, and a feedback page.

PythonStreamlitPlotlyPower BI
02

Automatic Pothole Detection System

An end-to-end machine learning system. YOLOv8 detects potholes in real time (0.91 mAP@0.5 with YOLOv8s on a custom dataset of 2,000+ images), MiDaS depth estimation and 3D point clouds estimate volume, and a Streamlit app produces repair-cost estimates. Published in JETIR, 2025.

YOLOv8PyTorchMiDaSStreamlit
03

IT Ticket Analysis Dashboard

An Excel analysis of 97,498 IT support tickets handled by 50 agents (2016–2020): data cleaning, PivotTables, formulas and an interactive dashboard with slicers. It found demand grew 123% and about 30% of tickets had no priority assigned, then turned that into recommendations.

ExcelPivotTablesSlicersDashboards
04

Credit Card Analysis Dashboard

A customer and transaction analysis of credit card data using PostgreSQL, Jupyter Notebook and Power BI, with DAX measures for age groups, income groups and week-over-week revenue.

Power BIDAXPostgreSQLJupyter
05

Employee Management System

A full-stack app with Spring Boot REST APIs, Hibernate/JPA and MySQL. It covers employee and department management, validation, global exception handling, and a JavaScript dashboard connected to the API.

Spring BootMySQLJPAJavaScript

More projects are on my GitHub.

Writing

Learning in public.

Data AnalyticsMicrosoft ExcelData Visualization

Analyzing 97,000+ IT Support Tickets in Excel: From Raw Data to Business Insights

How I used Excel to analyze IT support operations, identify bottlenecks, evaluate agent performance, and build an interactive dashboard. 7 min read · October 2026.

Read on MediumMy Medium
Services

What I can build for you.

Websites

Portfolios, landing pages and small business sites that load fast and look right on phones.

Good for: freelancers, students, local shops

Dashboards & analysis

Raw data cleaned, analysed and shown in Power BI or Streamlit so decisions get easier.

Good for: teams drowning in spreadsheets

Web apps

Admin panels, forms and record systems with React, Django or Spring Boot and a real database.

Good for: internal tools and prototypes
1

Talk. Share the goal and who it's for.

2

Draft. You see a working draft early.

3

Launch. Tested, deployed and explained.

Background

For recruiters, the short version.

2021Started B.E. in Computer Science
Sep 2024Cloud app intern, Rooman
Nov 2024Data visualisation intern, Infosys. Built the GDP app
Apr 2025Pothole detection, published in JETIR
2025Graduated with 9.25 CGPA
May 2026Employee Management System, full-stack
Aug 2026Excel IT ticket analysis dashboard
NowLevelling up into data science, learning SQL

Experience

Data Visualisation Intern, Infosys SpringboardNov 2024 – Jan 2025 · Python, SQL, EDA, Power BIView certificate

Cloud Application Developer Intern, Rooman TechnologiesSep 2024 – Feb 2025 · REST APIs, cloud deployment, GitView certificate

Publication

“Automatic Pothole Detection System”, JETIR 2025Published research paperRead the paperPublication certificate

Education & skills

B.E. Computer Science, Maharaja Institute of Technology Mysore2021 – 2025 · 9.25 / 10

Python · SQL · Pandas · NumPy · Matplotlib · Power BI · Excel · MySQL · PostgreSQL · React · Django · Docker · GitCurrently levelling up in machine learning and analytics. Open to data science, analytics and software roles.

Contact

Let's build something useful.

Hiring, or have a project in mind? Send a note and I'll get back to you.