Projects

Out of hours mileage tracking

Cummins were paying a sizeable monthly subscription for tracking software on their fleet of vehicles, but the reports generated were hard to interpret and thus they didn't help to keep track of the out of hours mileage of the fleet.

To overcome this issue, I built data pipelines to automatically extract data from the reports and present it in a clear dashboard format. Cummins can now easily keep track of out of hours (and working hours) mileage!

Sustainability Report of the Year Finalist

Cummins had their carbon emissions measured for three years, and each time were left unsatisfied with the level of insight generated by the analysis.

By performing bespoke analysis, and getting first-hand insight into their operations, I helped Cummins produce a GHG Corporate Standard emissions report that finally provided the insight they required to put together an impactful and achievable emissions reduction strategy.

We were delighted when the report was shortlisted for Sustainability Report of the Year at the UK Green Business Awards 2025! Sadly we didn't take home the trophy, but it was a tremendous achievement to be up there with names like Microsoft, Ovo Energy, and the deserving winners Ofi!

Vehicle and plant costs

As an aggregates haulage and processing business, UKAP relies on accurate, timely, and digestible data on plant and fleet costs to operate.

UKAP had historically gotten this information from its accounting system, but always found it clunky and time consuming to use.

I built a data pipeline that provides a live connection to their accounting system and displays data in clear charts that can be interpreted and interrogated with slicers and filters.