35 to 4
Head-office team after automation at a UK retail concessions business of 100+ people. The business went on to have its most profitable year.
Sales reporting that moved the numbers
An automated sales reporting suite contributed to sales revenue more than doubling at the same business.
Hundreds of hours a month
Saved by replacing manual self-billing, remittances, credit notes and reconciliations with controlled one-click outputs.
UK retail concessions business · 100+ employees
A head office that could run with four people
As Head of Trade & Data I led trade, data, finance systems and commercial operations, with three direct reports. Using TM1, Excel and Dynamics NAV, I automated work across finance, sales analysis, brand management and product enrichment so that, after Covid, work previously done by a 35-person head office could be run by four. The business went on to have its most profitable year.
I automated the monthly management account packs, board KPIs and sales reporting. The sales reporting suite contributed to sales revenue more than doubling. I also built automated sales and stock reports — best sellers and slow-moving lines — so brand partners could decide what to send without waiting for the team to tell them. That information had not existed before.
TM1 · Excel · Dynamics NAV · Management packs · Board KPIs
Same retail business
Self-billing, journals and a month-end built from scratch
I set up and ran month-end, purchase-to-pay, billing, payroll, budgeting and reconciliations end to end, creating the processes from scratch. Journal postings were automated into Dynamics NAV from standard templates, which cut both the time taken and the number of errors.
The manual weekly upload of hundreds of self-billing invoices and remittances was replaced with an automated process. Earlier in the same business I had already replaced manual self-billing invoices, remittances, credit notes and reconciliations with controlled one-click outputs, saving hundreds of hours of work a month.
Dynamics NAV · Self-billing · Journals · Reconciliations · Month-end
Same retail business
Dynamics NAV 2009 to Dynamics 365
After around five years implementing and developing Dynamics NAV / Business Central, I carried out the migration from NAV 2009 to Dynamics 365, including the data migration and testing, alongside the finance processes already built there.
Dynamics NAV · Business Central · Dynamics 365 · Data migration · Testing
PE-backed live entertainment group · UK and US finance
US forecasting and budgeting on one TM1 model
I designed and built the US forecasting and budgeting system in IBM Planning Analytics / TM1 for around 30 users across 20+ venues and multiple business units, moving US financial data off inconsistent spreadsheets onto one controlled planning and reporting model. I owned that work end to end: discovery with stakeholders, requirements, design, build, testing, go-live, training and Level 2/3 support, coordinating finance, partners and vendors.
I also supported UK and US finance processes for budgeting, forecasting, payroll, ticketing and P&L reporting, provided production support for a large finance user base, and improved automated finance workflows using TM1, Excel, Power Query and wider automation tooling.
IBM Planning Analytics / TM1 · PAW / PAfE · Excel · Power Query · Training and L2/L3 support