Software & Data Architecture at Scale

A systematic value investing platform that values 60,000+ companies a day over a 5 TB+ database.

The problem

Methodically and systematically valuing every company in the market at once, with daily recomputation on price changes plus quarterly/annual reports, without the system buckling.

Stack decision

Re-architecting the stack from MySQL to PostgreSQL and from Pandas to Polars to make real-time computation viable; billion-row tables with a partitioning scheme to optimize queries.

The technical challenge

Designing a generic data module that generalizes to any asset type and its edge cases (different markets, reporting frequencies) over a 5 TB+ database.

Impact

Real-time daily valuation of 60,000+ companies on a dedicated server with 300+ GB of RAM and 10+ TB of disk. The backbone of Baboon Technologies’ investment fund.

A multi-client agentic chat engine with RAG, external tools and generative BI, isolated per client.

The problem

Give each client an assistant that answers any question about their documents and data, connects to their tools and generates charts and dashboards, while keeping data isolated.

Stack decision

FastAPI + LangChain/LangGraph, RAG indexing with pgvector and Cohere Rerank, orchestration of several LLMs by quality/price (OpenRouter, Gemini, Deepseek) and tools via MCP/FastMCP. Fully traceable with Langfuse.

The technical challenge

During indexing, automatically clustering information, detecting discrepancies and allowing manual curation; and isolating data by project_id in a reusable multi-tenant engine.

Impact

A reusable engine in production for several clients (financial Q&A, margin and profitability monitoring with charts).

A platform for at-home therapists with a slot optimizer that minimizes travel and waiting time.

The problem

Cutting travel and waiting time for at-home therapists, bringing several roles (therapists, patients, centers, guardians, admin), clinical records, calendar and payments into a single platform.

Stack decision

Next.js/React + FastAPI/SQLAlchemy on PostgreSQL; Stripe (recurring payments and Connect), Google Calendar (two-way sync) and OpenRouteService for real distances/times.

The technical challenge

The slot optimizer: it scores (0–100) each therapist’s gaps and places every patient in the best one using real locations, penalizing dead waiting time and travel.