Areesha Naeem

ABOUT ME

I'm

Most people drown in data. I find the story inside it.

I'm a Data Analyst specializing in Power BI, SQL, and Python — with hands-on experience turning messy, large-scale datasets into dashboards and insights that help people make real decisions. I completed a Data Analyst internship at Pakistan Aeronautical Complex (PAC), Kamra, where I built automated KPI dashboards and reports for operational teams.

Here's what that looks like in practice:

Analyzed 186.9M in supply chain revenue across 7 suppliers and 16 SKUs to surface delay patterns and underperforming routes
Built an HR dashboard tracking 1,470 employees across 6 KPIs to support workforce planning and retention strategy
Cleaned and explored an 11,252-row dataset in Python — handled missing values, outliers, and inconsistencies to deliver actionable insights
Queried 11 relational tables using 12 complex SQL queries to identify top artists, genres, and high-value customers

My toolkit:

Databases: SQL (MySQL, PostgreSQL)
Programming: Python — Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn
Data Visualization: Power BI (DAX, Power Query, Drillthrough), Tableau, Excel Dashboards
Tools: Power Query, Pivot Tables, Data Cleaning, Git, Jupyter Notebook

WHY HIRE ME?

186.9M Revenue Analyzed

Built a supply chain dashboard tracking gross revenue, profit margins, shipment delays, and supplier performance across 7 suppliers and 16 SKUs

1,470 Employees. 6 KPIs.

Designed an HR analytics dashboard measuring attrition rate, department headcount, gender diversity, and tenure to support workforce planning

11,252 Rows. Zero Guesswork.

Cleaned and analyzed a large messy dataset in Python using Pandas, Matplotlib, and Seaborn — from raw inconsistent data to clear business recommendations

Real Industry Experience

Completed a Data Analyst internship at Pakistan Aeronautical Complex (PAC), Kamra — built automated Power BI reports and KPI dashboards for operational engineering teams

Full Analytics Stack

Power BI · DAX · Power Query · SQL (MySQL, PostgreSQL) · Python · Excel · Tableau — end-to-end from raw data to executive dashboard

Top 5% of Batch

BS Computer Science at COMSATS University Islamabad — CGPA 3.50/4.00, ranked in the top 5% of the batch, with IBM certification in Data Analysis with Python

EDUCATION

BS Computer Science

COMSATS University Islamabad, Attock Campus

Top 5% of batch · CGPA 3.50 / 4.00

2022 – 2026

Higher Secondary School Certificate (HSSC)

Fazaia Degree College ARF Kamra

87% — Board Examination

2018 – 2020

WORK EXPERIENCE & INTERNSHIPS

Data Analyst Intern

Pakistan Aeronautical Complex (PAC), Kamra

Power BI · SQL · Python · Excel · DAX · KPI Reporting

Cleaned and pre-processed production and operational datasets using Python and Excel, ensuring data accuracy and consistency for downstream reporting
Built interactive Power BI dashboards and automated Excel reports to track 10+ KPIs across manufacturing and operational units, reducing manual reporting effort for engineering teams
Wrote optimized SQL queries to extract and transform data from relational databases, supporting cross-functional teams in identifying production bottlenecks
Collaborated with operations and engineering teams to translate business requirements into analytical dashboards, improving visibility into production performance

Jul 2025 – Aug 2025

PROJECTS

E-Commerce Sales Dashboard

Power BI · DAX · Excel

HR Analytics Dashboard

Power BI · DAX · SQL

Store Sales Dashboard

Excel · Pivot Tables · Slicers · Annual Report

Music Store SQL Analysis

SQL · PostgreSQL · 11 Tables · 12 Queries

Python EDA Project

Python · Pandas · Seaborn · 11,252 Rows

Super Store Sales Forecasting

Power BI · Time-Series · Forecasting

HR Dashboard — Advanced

Power BI · Power Query · 3-Page Report

Supply Chain Dashboard

Power BI · 186.9M Revenue · 3M+ Shipments

Violence Against Women Analysis

Power BI · Geographic Maps · Trend Analysis

AI Skills vs Job Risk

Power BI · AI Analytics · Workforce Data

Food Delivery Dashboard

Power BI · Operations Analytics · Multi-page

CERTIFICATIONS

IBM Data Analysis with Python Certificate

Data Analysis with Python (DA0101EN)

IBM · Cognitive Class · IBM Developer Skills Network

Completed IBM's official Python data analysis course covering data cleaning and preprocessing with Pandas, Exploratory Data Analysis (EDA), data visualization using Matplotlib and Seaborn, and statistical analysis and pattern recognition.

Verify Certificate

Power BI Monthly Challenge — Data Visualization

Power BI Developer Club

Completed a hands-on monthly dashboard challenge focused on real-world data analysis and visualization. Built and submitted a fully interactive Power BI dashboard judged on design, insight quality, and technical execution.

TECHNICAL SKILLS

Databases

MySQL
PostgreSQL

Programming

Python
Pandas
NumPy
Matplotlib
Seaborn
Scikit-learn

Data Visualization

Microsoft Power BI
Tableau
Excel Dashboards

BI & Analytics Tools

DAX (Data Analysis Expressions)
Power Query
Pivot Tables
Jupyter Notebook
Git

Analytics Techniques

Exploratory Data Analysis (EDA)
Data Cleaning & Preprocessing
Time-Series Analysis
Sales Forecasting
KPI Design & Reporting
Statistical Analysis

Domain Experience

HR Analytics
Supply Chain Analytics
E-Commerce Analytics
Business Intelligence (BI)
Dashboard Development

ABOUT ME

I'm