Building tools that solve real problems.

My name is Guillem Rovira Herrero. Started in chemical engineering. Traded exothermic reactions for distributed systems. Both blow up if you're not careful. Now I build PySpark pipelines, ETL systems, and cloud architectures at EIT Urban Mobility. Spending my nights building products, using agents, and trying to catch up with the latest "best AI model" of the week.

Co-founded Urbix. Learned more in two years than in four years of university.

Scroll down. The projects are more interesting than I am. ↓

  • Language: Python (all day, every day)
  • Backend: FastAPI, SQLAlchemy, SQLite/Postgres
  • Frontend: HTML, Tailwind CSS, Alpine.js
  • Deploy: Docker, nginx, single VPS
  • CI/CD: GitHub Actions
  • Testing: Pytest with fixtures
  • Logging: Structured JSON, correlation IDs
  • Pair programmer: Claude Code (it doesn't complain)

Projects

Focused tools, each solving one problem well.

Nexus Live

PySpark intelligence platform. Static analysis, execution graph extraction, lineage tracking, and LLM-assisted explanation of Spark ETL code.

Understanding transformations at every stage.

Rosetta Live

AI citation tracking analytics. Know when and how AI models reference your brand, content, or products.

Decoding AI citations like the Rosetta Stone.

Shinkansen Live

Sub-second CLI for Jira. Navigate boards, create issues, and manage sprints without leaving the terminal.

Bullet train speed, bullet train precision.

Lighthouse Planned

Slack attention autopilot. Surfaces what needs your response and silences the rest.

Cuts through the fog to show the safe path.

Vesalius Planned

WordPress health monitoring. Uptime, performance, and security checks for your sites.

Mapping your site's vital systems.

Alexandria Building

Cloud spend autopilot. Detects waste, suggests rightsizing, tracks costs across providers.

Managing resources efficiently.

Samarkand Building

Supply chain simulator. Model disruptions, test scenarios, and optimize logistics flows.

Where supply chains converge.

Medici Planned

Shopify ERP. Inventory, orders, and fulfillment in one place for growing stores.

Renaissance-level commerce operations.

Pantheon Planned

Construction admin, offline-first. Daily logs, submittals, and RFIs that work without signal.

Built to last.

Yam Building

Jenkins CI/CD copilot. Pipeline insights, failure analysis, and suggested fixes from your terminal.

Continuous automation relay.

Hammurabi Planned

Legal case manager. Track cases, deadlines, documents, and client communications.

Organizing laws systematically.

The name

Temujin was the birth name of Genghis Khan. In Turkic/Mongolian, it means "blacksmith." In Spanish, that's Herrero. That's my surname. No empire ambitions (for now), just forging tools.