I automate the repetitive work that eats a team's day, in a small business or a larger company: invoices typed into the ERP by hand, the same customer questions answered over and over, reports copied between spreadsheets. I came to IT from logistics operations, so I start from the process and pick the tool after, sometimes a model, often a plain script.
Everything here is something I built and run. Write-ups, with what went wrong, live on alexguardiola.dev.
- pbip-audit-skill: audits a Power BI project from its files (broken fields, slicer sync, DAX, accessibility) and cites the file and line of every finding. Runs as a Claude Code plugin, a command or a GitHub Action, offline.
- invoice-tray-demo: invoices and delivery notes to an ERP-ready CSV. Every field cites the text it came from, and anything doubtful goes to a person.
- whatsapp-support-demo: a WhatsApp support bot that only answers what it can cite from the business's own documents and hands the rest to reception.
- homelab-ai-assistant: ask my home server questions from an Apple Watch. Read-only by voice; anything that changes something needs a tap on Telegram.
- pi-kitchen-assistant: a Telegram kitchen assistant for two on a Raspberry Pi, with recipes, pantry and shopping list.
- QRFleet: fleet damage reports from a QR on the vehicle to a signed PDF in the office inbox, built end to end for a logistics company.
n8n · Python · Power Automate and Power BI · Next.js · FastAPI · PostgreSQL · Docker · local models with Ollama when the data is private