02Data platform · Generative AI

Market price intelligence platform

Weekly public data, parsed into a 52-week forecast the buying team takes into supplier negotiations.

Forecast horizon
52 wk
Products covered
100s

Colombia's statistics office publishes wholesale food prices every week, in files made for people to read: layouts shift between releases, units change from sheet to sheet, and there is no API. Meanwhile the buying team negotiated with suppliers with no outside reference for what the market was doing.

The platform reads every release reliably, keeps years of history for hundreds of products, forecasts each price 52 weeks ahead, and has an AI model generate automated insights. It started as an internal tool and is now a secure web app the buyers take into supplier negotiations.

The Market price intelligence platform demo (interactive with JavaScript on)

How it's built

The tools, the architecture and the engineering numbers, one line each.

03Applied AI · Guardrails

AI assistant for business data

Numbers the model makes up
Zero
Embedded/Vector DB
Golden queries

A Telegram assistant for questions about sales, inventory and purchasing. Every figure it gives comes from a query it actually ran.

View full case study: AI assistant for business data

05Multi-agent · Local-first

Personal AI operating system

Before anything it can't undo
Asks first
Git is the source of truth
Markdown

The memory is markdown in Git, so it outlives the runtime that reads it.

View full case study: Personal AI operating system

Market price intelligence platform

How it's built

Role
End-to-end engineer, from design to operation
Running
In production since 2026

Built with

  • PythonIngestion, models and the web app
  • PolarsFast, memory-light data processing
  • Delta LakePrice history with safe weekly updates
  • XGBoost · LightGBMPrice forecasting
  • FastAPIThe web app's backend
  • HTMXInteractive pages without a heavy front end
  • Anthropic APIGenerates the automated insights

How it fits together

From a weekly PDF bulletin to a price reading the buyers act onDANE bulletins are scraped and unit-normalised into a medallion lake. A 52-week forecast runs per product with model selection by multi-horizon MAPE. A language model writes the reading of each series once into the Gold layer, and the authenticated FastAPI application serves it to the commercial team from memory.SOURCEINGESTLAKEINTELLIGENCEDELIVERYno re-runDANE SIPSA bulletinsweekly · formatted forhumansUnit normalisationper-sheet, not globalScrape + parseschema drift toleratedMedallion lakeDelta Lake · upsertsBronze / Silver /Goldper-product seriesModel selectionmulti-horizon MAPE52-week forecastXGBoost · LightGBMLLM readingone paragraph per seriesCommercial teamsupplier negotiationFastAPI + HTMXauthenticated, on theinternetInsight storeGold table, read once
From a weekly PDF bulletin to a price reading the buyers act on

By the numbers

Forecast horizon for every product
52 wk
Products, with years of history each
100s
Automated tests running in CI
100s
AI-generated insights, whenever the input data is the same
Reused