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

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

Loblaw · 2026 · in production

A driver scheduling platform for Loblaw's transport network

Driver dispatch across the transport network ran on shared Excel macro workbooks: no history, version conflicts, drivers told of changes by one-off messages. I designed, built, and shipped the replacement end to end: discovery with dispatchers and transport supervisors, a first release scoped to the one tab everyone fought over and the full platform built out around it, a Python and MySQL build behind a web front end, hours-of-service checks before a run is booked, pay approval, and deployment on a Linux VM I administer. One platform, configurable per distribution centre, instead of one spreadsheet per site.

Live in production and in use, after enterprise security review. Read the case study →

Loblaw · 2026 · shipped

A freight allocation tracker that answers one question: what's left?

Contracted ocean space sat in one place and weekly volume in another, and the master grid was a picture pasted into a workbook, so nothing could read it. I built a single-file browser tool: drop in the weekly forecast and every lane shows allocation, booked, forecast and what's still available, week by week. It handles both ways the contracts are written, annual awards per lane and weekly pools shared across a service, and it flags volume moving outside any allocation instead of quietly counting it.

No server, no install, and the workbook stays in the browser. One upload refreshes every lane. Read the case study →

Loblaw · Since 2025 · v7.4

A storage and detention calculator you can audit line by line

Shipping lines start their free-time clocks from different dates, and the weekly storage report meant working those rules out by hand for every container. I built a browser tool that reads the Excel export, identifies the line from the bill of lading, and calculates last free day, dray storage and container detention per container. Before trusting it, I reconciled it row by row against the hand-built weekly report and fixed every gap the comparison exposed.

200 of 200 on last free day and on detention in that reconciliation, and 193 of 200 on storage, with the other seven traced to one rate the source file applied inconsistently. Rule changes get the same row-by-row recheck.

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. See the reports →

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. See the report →

Loblaw · 2026 · published

A driver manager dashboard for trips, pay and attendance

One Power BI report that puts trips, miles, pay and attendance side by side for every driver: mileage pay, fuel surcharge and accessorial pay, days worked against vacation and sick time, and miles per driver by period against target. Filter it by date, driver, operational group or pay code, then drop to trip detail, trip legs and accessorial lines. Hours requested against hours paid get their own page, and a glossary keeps the definitions in one place.

Published in the Power BI Service and refined through stakeholder feedback rounds. See the reports →

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.

Smaller, still useful

Weekly load ID generator

A small FastAPI and React app that turns three weekly reconciliation files into one SQL script, with every mapping in a config file. It only writes the script. By design it never connects to the transport system, so a person reviews it and runs it.

IPT document checker

Automated about 95% of a manual document verification step, saving roughly 4 hours per person per week.

Fleet utilization report

Vehicle mileage in Power BI on one rolling 12-column grid: this period and last by week, older periods collapsed, lowest-mileage units called out. It goes out as a PDF every Sunday.

There are others 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 the full-stack driver scheduling platform for the transport network, live in production and in use after enterprise security review: user discovery, 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 platform for the transport network, 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 ↓