Project Portfolio & Impact Record
2025-2026
Evidence across 20+ projects in grocery fulfilment, supply chain, delivery, and customer-facing work: analytics platforms (hub + conversational assistant), operational analysis (true cost of fulfilment, network limits, routes and workload forecasting, live stock reporting, promotion profitability), partner-facing reporting and redesigns, direct client and stakeholder presentations (including exec-style readouts and Q&A), training and enablement, and an independently shipped app (Capture).
Get in touch
Core skills
What recruiters typically scan for, stakeholder-facing strengths first, then analytical depth and tooling. Detailed proof sits under each project on Projects.
Stakeholders, clients & communication
Analytics only lands when people trust the numbers and know what to do next. A recurring part of my work is managing stakeholders across commercial, operations, and tech, from discovery and prioritisation through readouts, adoption, and follow-up.
- •~15-month US secondment embedded with a retail partner: daily contact with operations leadership, internal analytics, and supply chain; mentored partner analysts and ran hands-on training.
- •Direct client-facing delivery: presented promotion profitability and cost analysis decks with methodology walkthroughs, Q&A, and alignment between commercial and fulfilment leadership.
- •Partner (non-client) contexts: prioritised reporting roadmaps from real usage, walked teams through forecasts and tooling so decisions stuck, and paired narrative + visuals with operational reality.
- •Enablement at scale: trained ~100 users on self-serve analytics; shipped documentation and landing flows so discovery matched how teams actually searched for insight.
Key Impact Highlights
Financial Impact
- Cost to Serve (fresh fulfilment): ~$1M/year
- Water Analysis - Geo Cubing: ~$550K/year saved
- Water Capping Recommendations: ~$300K-~$2M/year potential
- Bulky beverage promotions (partner CTS): ~$420K one FC (7 days); ~$560K two FCs; ~$1M rounded network-scale
Code Contribution
- Total Lines Written: ~200k lines
- Internal Looker (LookML): ~125k lines, ~750 commits (#1)
- External Looker (partner programme): ~45k lines, ~75 commits (#5)
- Python Framework: ~20k lines
- Analyticado: ~6.5k lines
Platform Reach & Usage
- Partners Supported: multiple partners
- Sites Supported: >100 (CFCs, MFCs, in-store)
- Partner Looker report runs: ~3k/month
- Top operational report: ~2k runs/month
- Analytics hub active users: ~100 users/month
Enablement & Automation
- Users Trained on Looker: ~100 users
- Partner reporting platform usage: 2x month-over-month
- GCP Cloud Functions: ~5 in production
Secondment to the US - Senior Analyst
Cincinnati, Ohio, USA
~15 months (2025-2026)
Spent ~15 months in the US with a strategic grocery partner, on site, helping them run leaner, cut cost, and improve performance across online ordering, warehouse, and delivery.
Impact & Contributions
- •Worked directly with operations leadership, internal analytics teams, and supply chain/logistics teams
- •Provided expertise across supply chain, e-commerce operations, warehouse automation, and inbound/outbound logistics
- •Built and deployed operational reporting; led analytical investigations into performance issues
- •Conducted audits and troubleshooting across systems and processes
- •Mentored partner team members on reporting tools, data interpretation, and building their own solutions
- •Delivered hands-on training and acted as a trusted advisor within the partner organisation
- •Presented analysis and recommendations directly to the client (including promotion profitability and cost work), with exec-style readouts and follow-up to align commercial and operations stakeholders
- •Delivered $2M in traceable cost savings (Cost to Serve, Water Limit Analysis)
- •Led multiple analytical workstreams, translating complex data into clear recommendations
Tools & Technologies
Looker / LookML, SQL, React.js, Google Workspace, Google Apps Script
Domain Coverage
Projects at a glance
Short snapshots below. Each card links to the matching Projects entry for the full narrative, impact lines, and skills & proof bullets.
Analyticado
Centralised analytics hub with ~100 monthly active users
Analyticado made trusted analytics easier to find. Dashboards, metadata, and usage signals sit in one searchable hub, supporting roughly 100 monthly active users and roughly a tenfold lift in engagement compared with the previous scattered entry points.
Impact snapshot
- ~100 monthly active users
- 10x increase in analytics engagement
K-AI - Conversational Analytics Assistant
One chat for sourced answers and conversational analytics
K-AI gives teams one place for sourced answers from internal docs and the dashboard catalogue, plus conversational analytics when the question is really about numbers. Routing is tuned so people land on trustworthy explores, long answers run reliably behind corporate proxies, and analytics owners could tighten…
Impact snapshot
- One assistant for sourced answers from docs and conversational analytics for metric questions
- Question routing tuned so people hit the right topic and avoid misleading chart picks
Live bulky inventory reporting
Live view of bulky stock versus how much you should hold
Operations dashboard from a secondment to the US for large, bulky products packed ready before picking. Uses live warehouse stock and compares it to levels recommended from sales forecasts and how many days of cover you want. Teams set cover and safety buffers, see shortfalls and excess, and refresh often. View-only…
Impact snapshot
- Connected slow periodic reports to same-day stock-versus-target decisions
- Let teams adjust how many days of cover they expect instead of one fixed rule
Bulky promotion cost-to-serve analysis
Whether big sales on heavy items actually made money after real costs
Compared baseline and promotion weeks for high-volume bottled water and multipack soda across partner FCs: pulled together orders, delivery cost per tote (driver, fuel, totes per route), tote fill from bulky volume, opportunity cost versus average basket profit, and incremental route pressure. Estimated on the order…
Impact snapshot
- ~$420K estimated site-level impact (7-day bulky beverage window)
- ~$560K combined two-FC downside versus baseline once water and soda were fully costed
Python Framework
Shared analytics automation platform with ~10 contributors
Shared Python toolkit automating data movement between Looker, Slack, BigQuery, and email. Helpers for common analysis, runs on Google's cloud, automated GitLab releases, secure credentials, and sensible job scheduling.
Impact snapshot
- ~20k lines of code
- ~10 contributors across the team
Cost to Serve Model
~$1M annual savings through operational optimisation
Model that spotted where fresh groceries cost too much to pick and deliver for a large grocery partner. Clear recommendations, major annual savings, and a version the client's team could run themselves. Presented the savings case and model logic to partner stakeholders to drive adoption.
Impact snapshot
- ~$1M annual savings for the partner
- Client self-service capability
Water Limit Analysis
~$550K saved with ~$2M+ further potential
Mapped limits on how much bottled water each area could receive across the client's network during a secondment to the US. Surfaced better caps and delivery routes that operations adopted. Presented findings to client leadership so recommendations translated into action.
Impact snapshot
- ~$550K/year in direct savings
- ~$300K-~$2M/year in recommended optimisations
Routes Predictor
Forecast delivery routes to plan staffing
Forecast from past patterns for how many delivery routes will run. Runs automatically on Google's cloud. More accurate between official planning cycles than the old rules of thumb.
Impact snapshot
- More accurate interim predictions
- Automated forecasting via GCP pipeline
OSP Insights Platform
Partner reporting with ~3k monthly report runs
Redesigned home pages and menus on partners' Looker reporting site. Clear paths through the numbers across multiple partners and 100+ sites. Included some of the most-used operational reports. Prioritised navigation and metrics with partner stakeholders based on real usage.
Impact snapshot
- 2x month-over-month usage increase
- ~3k report runs per month
Capture - Mobile Application
Cross-platform photo sharing app on iOS & Android
Independently shipped Capture on iOS and Android: shared photos surface after a delay, with subscriptions, one-time purchases, and ads configured end to end. Public metrics on this site show acquisition and retention moving as the product ships.
Impact snapshot
- Launched on both app stores (January 2026)
- ~100 downloads with ongoing growth
Workload Forecasting ML Models
Staffing optimisation across 15+ CFCs
Models that predict how busy warehouses will be and staffing needs at partner CFCs. Helps managers plan people and shifts ahead of time.
Impact snapshot
- Network-wide staffing optimisation
- Deployed across 15+ sites (CFCs)
Availability Breakdown
Used data to decide when delivery routes could open
Checked real booking behaviour against assumptions and showed where demand was missed. Explained delivery-slot and area-setup ideas clearly to leaders. Built charts that highlighted patterns and delivery areas that were too large or poorly sized.
Impact snapshot
- Stakeholder confidence for automated route-release decisions
- Revealed zone-sizing and demand-capture issues
In the Bag
Clearer view of orders and staffing needs
Live breakdown of orders and how much labour they imply. Shaped views around what operations asked for. Same-day monitoring for day-to-day decisions.
Impact snapshot
- Enabled tighter labour management
- Real-time performance visibility for partners
Geomapping Availability
Maps showed delivery-area and planning problems
Interactive maps for booking patterns and problem areas. Filters for time period, site, and slot-planning region. Surfaced issues such as oversized delivery zones.
Impact snapshot
- Exposed zone-sizing issues
- Informed route-release and slot-planning improvements