Hi, I'm Farhan 👋
I find broken operations and ship the software that fixes them.

Senior Analyst, Supply Chain Process Improvement at Loblaw. The role sits between software and product: find where the operation leaks time or money, interview the people stuck dealing with it, scope the smallest product that fixes it, ship it, and measure adoption.

See what I've built Say hello
Experience & education across
LoblawAmazonUniversity of CalgaryErasmus Rotterdam

Selected work

Things I've shipped

Five internal products from the day job at Loblaw. Told plainly, numbers included.

Loblaw · 2026 · in production

A driver scheduling app that runs daily dispatch

Distribution centre fleet dispatch ran on spreadsheets and memory. I designed, built, and shipped the replacement end to end: discovery with dispatchers and transport supervisors, an MVP scoped to the day-one workflow, a Python and MySQL build behind a web front end, and deployment on a Linux VM I administer. It passed internal security review before rollout, with static analysis running in CI, and every release since has been driven by what users asked for once they had it.

Now the system of record for daily dispatch. Next up: folding live telematics data into the same view.

Loblaw · 2025 – now · in flight

An internal yard management system

Four distribution centres run their yards on vendor software that never quite fit how the work actually happens. I'm leading the replacement, a custom internal product: discovery with the operators who live in the yard every day, workflows and a data model built from what they showed me, and ownership of scope, sequencing, and a phased rollout across stakeholder groups who rarely want the same thing.

In flight now. The goal is simple to say and hard to do: one system all four sites trust more than the tool it replaces.

Loblaw · 2026 · shipped

A dwell-time suite for every banner and region

Thirteen Power BI pages on the enterprise semantic model, custom DAX underneath, covering every banner and region combination. Scoped around the questions district managers actually ask: which stores are holding trailers, where the pattern is getting worse, and what changed this week. It replaced ad-hoc pulls with one standard view.

Now the standard view district managers and transport leadership use to track store-level dwell.

Loblaw · 2026 · shipped

Delay billing, made auditable

Delay charges were validated by hand and settled by argument. I engineered DAX interval-overlap measures that reconcile actual dock activity against planned appointment windows, so every charge traces back to the exact overlap math behind it instead of someone's recollection of the afternoon.

Delay charge validation went from a manual dispute process to an auditable, data-backed one.

Loblaw · 2025 · shipped

The data layer under everything else

International freight ran on spreadsheets and manual reports. I engineered the Python and SQL pipelines that unify vendor, carrier, shipment, and cost data into one modeled source of truth, then built self-serve tools on top: a freight cost calculator that replaced manual rate estimation (roughly $50–60K a year of analyst time back), a carrier allocation model, a PO baseline calculator, and a detention and demurrage dashboard. Along the way I root-caused a double-counting defect quietly misstating cost attribution and wired an automated reconciliation check into the pipeline so it can't silently recur.

The foundation behind roughly $55–65K a year in cost avoidance. The manual reporting it replaced is gone.

There are smaller ones too, and a couple that didn't work. Ask me about those. They're usually the better stories.

The dollar figures are annualized estimates against pre-tool baselines. Happy to walk through how they're calculated.

Career progress

The journey so far

I joined supply chain with no formal tech background, taught myself to code properly, rebuilt manual processes into automated tools, and grew into owning them. Promoted to Senior Analyst eight months in.

Jun 2026 – Present

Senior Analyst, Supply Chain Process Improvement

Loblaw Companies Limited · Calgary, AB · Hybrid
  • Build the internal software and analytics the supply chain team relies on to run daily operations. The role sits between software and product: find the leak, interview the people stuck with it, scope the smallest product that fixes it, ship, and measure adoption.
  • Designed, built, and shipped a full-stack driver scheduling app, now the system of record for daily dispatch: user discovery, MVP scoping, Python and MySQL build, Linux VM deployment, and post-launch iteration.
  • Shipped a 13-page Power BI dwell-time suite on the enterprise semantic model with custom DAX, now the standard view for district managers and transport leadership.
  • Engineered delay-billing analytics with DAX interval-overlap measures, turning delay charge validation from a manual dispute process into an auditable one.
  • Run product intake and prioritization for tooling across the network: size the cost of the problem, prototype fast, ship, and let adoption decide what survives.
Oct 2025 – Jun 2026

Analyst, Supply Chain

Loblaw Companies Limited · Calgary, AB · Hybrid
  • Owned analytics and internal tooling for international freight, carrier performance, and landed cost. Inherited a workflow run on spreadsheets and rebuilt it into pipelines, dashboards, and self-serve tools.
  • Engineered the Python and SQL data layer unifying vendor, carrier, shipment, and cost data into one modeled source of truth, the foundation for $55–65K in annual cost avoidance.
  • Shipped the Power BI reporting suite (custom DAX) that became how leadership tracks carrier performance, vendor exceptions, and landed cost, fully replacing recurring manual reporting.
  • Built self-serve decision tools on that layer: freight cost calculator, carrier allocation model, PO baseline calculator, detention and demurrage dashboard.
  • Root-caused a double-counting defect in cost attribution, patched the model, and added an automated reconciliation check so the failure mode can't silently recur.
  • Ran the analysis behind a replenishment redesign that cut lead-time variance 12%, packaged as business cases and one-page memos that set leadership priorities.
2023 – 2024 · 2 terms

Operations Intern

Amazon (Amazon Robotics sites) · Vancouver, BC
  • Shipped production Power BI dashboards on multi-source data models, giving operators real-time KPI visibility and cutting roughly 400 hours of manual reporting per site each year.
  • Built a VBA automation tool consolidating Pack/Pick metrics (cycle time, WIP, takt time, QPH) from 9+ fragmented systems into one instrumented view.
  • Queried 5,000+ operational records weekly across 9 systems, feeding the analysis that cut fulfillment cycle time 10% while holding 98% accuracy.
  • Partnered with operations, engineering, and quality to ship process changes worth an estimated $30–45K annually.
Sep 2023 – Dec 2023

Exchange Semester · BSc International Business

Erasmus University Rotterdam · Rotterdam, Netherlands
  • Global strategy and international business through the Rotterdam School of Management.
  • Recipient of the Canadian International Mobility Grant for outstanding academic performance.
Sep 2020 – Dec 2024

Bachelor of Commerce (BCom)

University of Calgary · Calgary, AB
  • Coursework across supply chain, operations, data analytics, and business process management.
  • International Entrance Award · President's Admission Scholarship · First-Year Scholar (95%+ average).
About

A little about me

I'm happiest when I find a broken process, figure out why it's broken, and build the thing that fixes it for whoever's stuck dealing with it.

At Loblaw that's meant turning messy operational data into software people actually rely on: a full-stack scheduling app that runs daily dispatch, Power BI suites that became how leadership tracks the network, Python and SQL pipelines that pulled fragmented data into one place. The approach doesn't change: talk to the people doing the work, find where the system is leaking time or money, scope the smallest thing that fixes it, and ship.

"I think about internal tools the way a PM thinks about a product. Who's the user? What are they actually trying to get done? And is the thing I built getting used, or is it sitting there? A clean dashboard nobody opens isn't a win."

I got here without a formal tech background. I taught myself to code properly, rebuilt manual processes into automated systems, and grew into owning them, with a promotion into the senior role eight months in. If you're building anything in supply chain, logistics, or ops software, or you just want to compare notes, I'm always happy to talk.

Toolkit

How I build

◆ Analytics & data

Power BI (DAX)Data modelingSQL Python (pandas, NumPy)Excel · Power QueryDynamic arrays

▲ Building

ReactFastAPIMySQL · PostgreSQL Linux VM deploymentCI & static analysisJavaScriptVBA

● Product & program

Discovery & researchRequirementsScoping & prioritization KPI definitionPost-launch analysisAI-assisted workflows
🎓 Foundations of Project Management · Google / Coursera · Feb 2023
$100K+
Annual cost avoided & saved
400+
Hours of manual work killed / yr
6+
Internal products shipped
9+
Systems unified into one source
Get in touch

Let's fix something broken together.

Happy to compare notes on supply chain, logistics, or ops software, or to talk through any of the work on this page. Fastest way to reach me is email. I reply to everything.

farhanforhad4@gmail.com
LinkedIn ↗ 587-583-3331 ↗ Resume ↓