# Alfie Roberts — AI Workflow Consultant

> Alfie Roberts is an AI workflow consultant who helps PR and communications agencies automate repetitive processes — coverage tracking, measurement reporting, media intelligence, and insight generation. Previously AI and Advanced Analytics Lead at Ketchum (Omnicom Group), where he built measurement systems for brands including P&G, Samsung, and Danone, winning an AMEC Gold Award for Best Use of New Technology (2023). He now works independently with agencies on automation and data problems that off-the-shelf tools can't solve.

## Services
- AI workflow automation
- Measurement and reporting systems
- Media intelligence pipelines
- AI-assisted research and insight tools
- Coverage tracking infrastructure

## Projects
- Danone Measurement Platform — Measurement platform tracking Danone brand performance across PR and influencer campaigns. Won AMEC Gold Award for Best Use of New Technology (2023). https://amecorg.com/awards/winners-2023/
- KR Sensing — Early-warning system for P&G Beauty monitoring social, news, academic, and policy sources in real-time with anomaly detection. Seven composite indicators feed a 0–100 risk score.
- Samsung Earned Media Tracker — Automated data collection from 15+ sources with executive dashboards. Cut monthly reporting time from days to hours.
- Train Delay Predictor — ML model that predicts train delays before they are announced, catching 76% of incidents. https://github.com/RogueSergeant/ML_Coursework_Train_Incident_Prediction
- Supplies for Ukraine C.I.C. — Platform to coordinate medical supply deliveries to Ukraine. £80k+ raised. https://www.suppliesforukraine.com/
- Oracle Ad Spend Forecaster — Regression models predicting quarterly ad spend trends. Forecasts directly shaped sales strategy.
- JSON to PySpark Schema Generator — Python tool that generates PySpark schemas from complex nested JSON. https://github.com/RogueSergeant/AutomatedJsonSchemaCreation

## Key Facts
- AMEC Gold Award winner (Best Use of New Technology, 2023)
- Previously AI and Advanced Analytics Lead at Ketchum (Omnicom Group)
- Specialises in Python, machine learning, Azure, large language models, and agentic workflows
- Ethical stance: will not automate to replace people — only to free teams from repetitive admin
- Based in the UK, works with agencies nationally

## Skills
Python, SQL, PySpark, Machine Learning, NLP, Azure, Power BI, Data Pipelines, Large Language Models, Agentic Workflows

## Brands
Samsung, Amazon, Oracle, McLaren, Henley Business School, Booking.com, Danone, American Express, Queen Mary University, P&G

## Contact
- Email: alfie@alfieroberts.co.uk
- LinkedIn: https://www.linkedin.com/in/alfie-roberts-129568131/
- GitHub: https://github.com/RogueSergeant
- Book a chat: https://calendly.com/alfie-alfieroberts/coffee-chat
- Website: https://alfieroberts.co.uk