Back to Developers
Waris Khan

Waris Khan

Data Analyst

Bangalore 85 · Excellent

About

Data Analyst skilled in turning raw, messy datasets into clear, decision ready insights. Experienced in SQL, Python, Excel, and Power BI for data cleaning, exploratory analysis, and dashboard development. Worked on real world datasets across airline operations, e-commerce, and healthcare, building custom KPIs such as occupancy rate, revenue per flight, and product performance metrics where standard measures were unavailable. Key contributions include identifying underperforming flight routes through revenue and utilization analysis, uncovering weak correlation between discounts and customer engagement, and analyzing patient data to highlight high risk health segments. Strong ability to work with incomplete data, structure ambiguous problems, and translate analysis into actionable business insights. Seeking Data Analyst roles focused on solving real business problems using data.

Skills & Expertise (21)

SQL Advanced
8.6/10
5
Years Exp
Python Advanced
8.4/10
5
Years Exp
Power BI Advanced
8.1/10
4
Years Exp
Data Cleaning Advanced
8.0/10
5
Years Exp
Exploratory data analysis Advanced
8.0/10
5
Years Exp
Matplotlib Reporting Data Validation Problem Solving Data Interpretation KPI development Git Jupyter Notebook MySql Charts Pivot Tables Excel DAX Data Transformation NumPy Pandas

Work Experience

Data Analyst

Amazon

Present - Present

Analyzed 1,400+ Amazon product records to study the impact of pricing, discounts, and ratings on customer engagement. Built an interactive Power BI dashboard to compare category performance and identify high engagement products. Found that ~48% discounted products still achieved 27M+ ratings with ~4.1 average rating, indicating discounts did not reduce customer trust. Observed that higher discounts did not consistently increase engagement, highlighting weak correlation between pricing and demand. Designed a proxy performance metric (ratings × review count) to evaluate product success in absence of revenue data. Derived actionable insight: product ratings and quality signals influence engagement more than discount levels.

Data Analyst

Airline

Present - Present

Analyzed ~30,000+ flight records across multiple datasets (flights, seats, bookings) to address low occupancy and revenue inconsistency. Designed key business KPIs such as occupancy rate and revenue per flight to evaluate operational performance. Used SQL (joins, aggregations, GROUP BY) to analyse route level performance and uncover inefficiencies in seat utilization. Identified high demand routes (e.g., DME ↔ KHV) and underperforming routes through revenue and occupancy analysis. Derived actionable insights: including route optimization, capacity reallocation, and pricing strategy improvements.

Data Analyst

Healthcare

Present - Present

Analyzed patient health data across 5,100+ records to identify key factors associated with stroke risk. Cleaned and prepared data (handled missing BMI values, encoded categorical variables) for reliable analysis. Explored relationships between age, hypertension, heart disease, and glucose levels. Found that age and pre-existing health conditions showed stronger association with stroke risk than lifestyle factors. Performed comparative and distribution analysis to identify high risk patient segments.

Education

Bachelor of Computer Applications - Presidency College

2022 - 2025 · Afghanistan

Class XII (ISC) - Saint Mary's School

- 2021 · Afghanistan

Class X (ICSE) - Saint Thomas School

- 2019 · Afghanistan

Certifications

Deloitte Data Analytics Virtual Program

Forage · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMay 2026