Ashar Shamim

Ashar Shamim

Business Analytics grad student | Data → Decisions

Hi, my name is Ashar Shamim. I'm studying for my MS in Business Analytics at UMass Amherst's Isenberg School of Management — welcome to my portfolio!

🟢 Open to Summer / Fall 2026 internships · OPT/CPT eligible

Previously at

About

I'm a Business Analytics graduate student at UMass Amherst's Isenberg School of Management, maintaining a 4.0 GPA. My background spans grant administration, commercial sales, and product development across healthcare, energy, and hospitality — industries most MSBA students haven't worked in yet. That cross-functional exposure shapes how I approach data: I build analyses that are useful to the people making decisions, not just technically correct.

I'm actively pursuing Summer / Fall 2026 internships in analytics, operations, or AI automation, and I'm OPT/CPT eligible. If you're looking for someone who can move fast between a SQL query and a stakeholder presentation, let's talk.

Education

Master of Science in Business Analytics

University of Massachusetts Amherst — Isenberg School of Management · GPA: 4.0/4.0

Jan 2026 – May 2027

Bachelor of Business Administration

Institute of Business Administration (IBA), Karachi · GPA: 3.25

June 2024

Projects

Five end-to-end analyses, from spreadsheet models to production-style dashboards. Click a skill below to filter.

01
City Comparison Dashboard screenshot

Excel & VBA

City Comparison Dashboard

Interactive Excel dashboard comparing 15+ U.S. cities across salary, cost of living, healthcare and safety indices. Built with dynamic slicers, VBA macros and conditional formatting.

View Project →
02
COVID-19 regression analysis screenshot

Python · OLS Regression

COVID-19 Case-to-Death Analysis

OLS regression model (R²=0.767) with 14-day lag variable to quantify how case surges predicted hospital deaths across Pakistan's four pandemic waves.

View Project →
03
Equity analysis chart screenshot

Python · Financial Analytics

Equity Analysis: Fashion & Apparel

Correlation and rolling-volatility analysis of TPR, RL, CPRI, PVH and NKE from 2019–2025. Key finding: fashion peers move 2× more in sync with each other than with Nike.

View Project →
04
Dastgyr retail analytics dashboard screenshot

Power BI · DAX

Dastgyr Retail Analytics Dashboard

Multi-page Power BI dashboard tracking 833M GMV across 5,408 customers and 288 sellers. Includes order cancellation driver analysis, city-level segmentation and promotional impact modeling.

View Project →
05
Hotel management dashboard screenshot

SQL · Power BI

Hotel Management System

Relational database schema and Power BI dashboard for Hotel UMass tracking 35K+ reservations, revenue by room type, occupancy trends and staffing metrics.

View Project →

Experience

Click a role to read more.

Skills

Click any tool to see which projects use it.

Languages & Tools

Analytics & Visualization

SPSS GA4 Looker Studio Figma

Certifications

Microsoft Excel Collegiate Challenge (MECC) — Regional Participant, Sacred Heart University, 2026