Senior @ Carleton College — BA Economics, Minors in Data Science & Public Policy

Abrar Hasanat

Strategy · Analytics · Operations

I build dynamic BI pipelines, engineer quantitative supply chain models, and optimize cross-functional operations. Seeking full-time roles in Management Consulting and Product Management for 2027.

Explore Case StudiesView GitHub Engine Room
Core Credentials

What I bring to the table

A working toolkit across strategy, operations, and the technical layer that connects them — built through applied coursework, certifications, and real engagements.

Earned & Target Certifications

  • Microsoft Power BI Data Analyst (PL-300)
  • Lean Six Sigma Green Belt (CSSC)
  • Professional Scrum Master I (PSM I)
  • Google Project Management Professional
  • IBM Business Analyst Professional
  • PMI CAPM Certification (In Progress)
  • AWS Certified AI Practitioner (In Progress)

Strategy & Operations

  • Financial Modeling & Valuation
  • Agile (Scrum) & DMAIC Frameworks
  • Enterprise Analysis & Business Cases
  • Pricing Optimization & Market Research
  • Project Lifecycle & Risk Management
  • UAT Testing & Change Management

Data & Technical Stack

  • Microsoft Power BI
  • Advanced Excel
  • SQL & R
  • AWS Cloud
  • Workday ERP
  • Next.js & Tailwind
Featured Case Studies

Selected engagements

Each project below moves from the operating problem, to the method used to solve it, to the measurable result — the same structure a case team would use in a client debrief.

Dashboard mockup — Bay Oceania C&T Ltd.
Commercial Strategy · Power BI

Commercial Tender Pipeline & Power BI Analytics

Bay Oceania C&T Ltd.

Problem
Tender opportunities were tracked across disconnected spreadsheets, making it difficult for the commercial team to prioritize high-value bids or spot bottlenecks before deadlines.
Methodology
Designed a centralized data model in Power BI, built DAX measures to score opportunities by value and win-probability, and automated a refreshed pipeline view for weekly leadership reviews.
Strategic Impact
The new pipeline surfaced high-value opportunities early and cut proposal turnaround time, giving the commercial team a single source of truth for prioritization.
$15M+
High-value opportunities captured
20%
Turnaround time reduction
Interact with Live DashboardView Raw Code on GitHub
Dashboard mockup — TAA Services / Carleton ERP
Operations · Lean Six Sigma

Operational Team Capacity & Backlog Optimization

TAA Services / Carleton ERP

Problem
Ticket backlog and uneven team capacity were slowing service delivery, with no structured process for isolating root causes or validating fixes before rollout.
Methodology
Applied DMAIC methodology to map the intake-to-resolution process, identify capacity constraints, and lead structured Workday ERP user acceptance testing ahead of go-live.
Strategic Impact
Backlog volume and cycle time dropped as capacity was reallocated to verified bottlenecks, and UAT findings prevented several defects from reaching production.
DMAIC
Methodology
Workday
ERP UAT cycles led
Interact with Live DashboardView Raw Code on GitHub
Dashboard mockup — Independent Research
Valuation · Quantitative Modeling

Economic Strategy & Valuation: Quantitative Market Entry Model

Independent Research

Problem
Entering a new market requires weighing demand signals, competitive positioning, and capital requirements together, but most public models treat these in isolation.
Methodology
Built a quantitative valuation model combining market-sizing, discounted cash flow, and sensitivity analysis to stress-test entry scenarios under different demand and pricing assumptions.
Strategic Impact
Produced a defensible, scenario-tested recommendation framework for market entry timing and investment sizing, grounded in transparent, auditable assumptions.
Multi-case
Scenarios modeled
DCF + Sensitivity
Core method
Interact with Live DashboardView Raw Code on GitHub