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

Abrar Hasanat

Business Analysis & Operations

I study economics at Carleton and build tools for business decisions. My projects range from apparel trade research to demand forecasting. Seeking full-time consulting and product management roles starting in 2027.

Credentials

Credentials

  • Lean Six Sigma Green Belt (CSSC)
  • Professional Scrum Master I (PSM I)
  • Google Project Management Professional Certificate
  • IBM Business Analyst Professional Certificate
  • Microsoft Power BI Data Analyst Professional Certificate
  • PMI Certified Associate in Project Management (CAPM) (In Progress)
  • AWS Certified AI Practitioner
  • CFA Program Level I Candidate (May 2027)

Operations

  • Financial modeling and valuation
  • UAT and data validation
  • Process mapping
  • Vendor SLA scoring

Tools

  • Next.js and TypeScript
  • Python and PostgreSQL
  • IBM Cognos and Power BI
  • Workday ERP

Work and projects

May 2026 - Present

Bangladesh Apparel Trade and Worker Protection

Examines US apparel sourcing after Rana Plaza using 120 UN Comtrade records. Connects the trade results to published research on worker protection.

Research scope
120
Official trade records
2010-2019
Calendar years
HS 61 + 62
Apparel chapters
Tech Stack
PythonUN ComtradePolicy ResearchRecharts
Outcomes
  • Validated real US-reported import data and documented historical preference exposure.
  • Decomposed the change in Bangladesh's US apparel market share.
  • Separated sourcing patterns from causal and worker welfare claims.
June 2026

Enterprise Financial Valuation Engine

Built a valuation tool with sensitivity analysis and equity research memo export.

Impact Metrics
25 cells
Sensitivity grid
PDF
Equity memo export
Tech Stack
Next.jsTypeScriptPythonDCF Modeling
Outcomes
  • Calculated a 25-cell sensitivity grid for discount rates and terminal growth.
  • Added a downloadable memo with the scenario inputs and valuation results.
August 2026

Agile Velocity and Probabilistic Capacity Forecaster

Built a release-planning demonstration with synthetic sprint history and RICE feature scoring.

Impact Metrics
10,000
Monte Carlo trials
P50, P80, P90
Forecasts
Tech Stack
PythonMonte CarloRICE Framework
Outcomes
  • Ran 10,000 Monte Carlo trials to estimate release milestones from synthetic sprint data.
  • Ranked candidate features using RICE scores.
January 2026

Synthetic Demand Forecasting Model

Built a weekday demand baseline using synthetic e-commerce orders. Tested each forecast against later observations and compared expected demand with a reorder threshold.

Impact Metrics
42 months
Synthetic order history
21 days
Supplier lead time
Tech Stack
PythonPostgreSQLIBM Cognos
Outcomes
  • Analyzed 42 months of synthetic order history.
  • Calculated forecasts using only earlier observations, with measured error and a 21-day reorder-threshold check.
Bay Oceania C&T Ltd.Business Development AnalystJune 2026 to August 2026

Tender Pipeline

Completed an unpaid, supervised remote internship in tender qualification, pipeline analysis, and market-risk assessment, supported by Carleton College Career Center funding.

Impact Metrics
15+
Tender opportunities reviewed
50+
Enterprise prospects organized
20%
Turnaround reduction
Tech Stack
Power BIExcel
Outcomes
  • Reviewed 15+ commercial construction and public-procurement opportunities using contract value, expected margin, and bid-feasibility criteria.
  • Built an Excel and Power BI tracker to organize 50+ enterprise prospects and support pipeline review.
  • Mapped the tender workflow and presented recommendations associated with a 20% shorter proposal turnaround.
TAA ServicesConsulting Analyst ExternOctober 2025 to December 2025

Research Team Planning

Completed an unpaid Carleton Career Center externship focused on supervised training in workforce planning, cost analysis, and vendor evaluation.

Impact Metrics
3x
Planned research team expansion
Tech Stack
ExcelVendor SLA scoring
Outcomes
  • Translated a planned 3x research-team expansion into phased staffing scenarios.
  • Modeled annual cost and time-to-fill across internal-hiring and agency-support options.
  • Applied an SLA scoring framework to compare agencies and identify 3 potential partners.
Carleton College Registrar’s and Provost’s OfficeSeptember 2023 to Present

Workday ERP Migration Support

Supported the migration from Colleague to Workday ERP.

Impact Metrics
15%
Transcript backlog reduction
Tech Stack
Workday ERPUATData validation
Outcomes
  • Supported the Colleague to Workday ERP migration.
  • Performed UAT and backend data validation.
  • Reduced the transcript processing backlog by 15%.
Wishing Star by ShantuFounderJune 2021 to August 2023

Cross-Border E-Commerce Operations

Founded a cross-border e-commerce business and managed procurement and fulfillment through August 2023.

Impact Metrics
45%
Year-over-year revenue growth
+$18.9k
Revenue increase
Tech Stack
Supplier ManagementOrder Fulfillment
Outcomes
  • Increased year-over-year revenue by 45% (+$18.9k).
  • Retain passive ownership; day-to-day operations are independently managed by the local team.
Stargate TechMax LTD.Executive Assistant to the CEOMay 2021 to June 2023

Executive Reporting

Mapped reporting workflows across finance and administration departments.

Impact Metrics
3.5 working weeks
Previous reporting cycle
11 working days
Updated reporting cycle
Tech Stack
Process Mapping
Outcomes
  • Reduced the reporting cycle from 3.5 working weeks to 11 working days.
  • Trimmed product processing times by 15% by standardizing workflows and handoffs.

Dashboards and case studies

ResearchInteractive tool

Bangladesh Apparel Sourcing

Observed US import trends, supplier comparisons and chapter composition after Rana Plaza. Descriptive evidence with documented limits.

120 official records2010-2019Reproducible analysis
FinanceInteractive tool

Enterprise Financial Valuation Engine

DCF modeling with 5x5 WACC and growth sensitivity grids and memo export.

25-cell sensitivity gridPDF memo export
OperationsInteractive tool

Agile Velocity and Capacity Forecaster

Monte Carlo release forecasts with RICE prioritization.

10,000 trialsP50, P80, P90RICE scoring
OperationsCase study

Tender Pipeline

Unpaid, supervised remote internship project in tender qualification and pipeline analysis.

15+ opportunities reviewed50+ prospects organized20% shorter turnaround
OperationsCase study

Workday Migration Support

UAT and backend data validation for the Colleague to Workday migration.

15% backlog reductionUATData validation