Back to work
Amazon

Fleet Procurement Optimization

Led a cross-functional global team of analysts and scientists to develop a predictive procurement model, saving £80M+ in capital expenditures in 2024

£80M+

in optimal procurement decisions driven

Overview

Managing a fleet of over 15,000 vehicles across multiple regions required constant procurement decisions: when to buy, what to buy, and where to deploy. The fleet included large vans, standard vans, ICE vehicles, and an expanding EV programme. Decision-making was fragmented across spreadsheets, gut feel, and siloed regional teams with no unified view of demand, station constraints, or total cost of ownership.

I built a Python-based optimization model that ingested demand profiles, geographical constraints, station capacity limits, driver availability, maintenance schedules, and EV-ready routes to recommend the optimal vehicle mix for each region. The model provided recommendations on optimal procurement decisions for purchasing large vans vs standard vans, ICE vans vs EV vans, evaluating trade-offs across total cost of ownership including fuel/charging costs, maintenance, depreciation, regulatory incentives, route distances, payload requirements, and charging infrastructure availability.

The model was deployed serverlessly on AWS using Lambda and API Gateway, enabling on-demand execution and scenario planning. Model results were fed into a QuickSight dashboard for real-time tracking, giving leadership visibility into fleet composition, utilization gaps, and procurement recommendations. The cross-functional team of analysts and scientists I led delivered £80M+ in capital expenditure savings in 2024.

System Architecture

Data Sources
Telematics APIsRoute Planning SystemsStation Capacity DataDriver AvailabilityEmissions Targets
Ingestion
AWS LambdaEventBridgeS3 Landing Zone
Optimization Engine
Python (PuLP/SciPy)Constraint SolverScenario Modelling
Storage
S3 Data LakeRedshiftDynamoDB
Serving Layer
API GatewayLambda FunctionsCached Results
Presentation
QuickSight DashboardsExecutive ReportsScenario Planner

Key Deliverables

  • Fleet procurement optimization model recommending optimal vehicle mix (large vans, standard vans, ICE vs EV)
  • Constraint-based solver factoring demand profiles, geographical coverage, station capacity, driver availability, and EV-ready routes
  • Scenario planning tool allowing leadership to model what-if procurement strategies
  • Serverless deployment on AWS (Lambda + API Gateway) for on-demand model execution
  • QuickSight dashboard for real-time tracking of fleet composition, utilization rates, and procurement recommendations
  • Cost-benefit analysis engine comparing TCO across vehicle types including maintenance, fuel/charge costs, and depreciation
  • Automated weekly reporting pipeline replacing 20+ hours of manual data aggregation

Tech Stack

PythonPuLP / SciPySQLAWS LambdaAPI GatewayS3RedshiftQuickSightDockerEventBridge

Impact

£80M+

capital expenditure decisions driven

15K+

vehicles in fleet

4

vehicle classes optimized

2024

savings identified in year