SYSTEMS THAT

VEHICLES TRACKED 1,247 STM · LIVE
AVG DELAY 47.3s 87.6% COVERAGE
ROUTES LIVE 186 OF 203 TOTAL
Data that tell the truth.

Building reliable infrastructure for teams that can't afford downtime.

See how I build → Let's talk

yesid@transit:gold> LIVE
SELECT
  d.route_short_name,
  round(avg(f.delay_seconds)::numeric, 1)
    AS avg_delay_s,
  count(DISTINCT f.vehicle_id)
    AS vehicles
FROM gold.latest_trip_delay_snapshot f
JOIN gold.dim_route d
  USING (provider_id, route_id)
WHERE f.delay_seconds IS NOT NULL
GROUP BY d.route_short_name
ORDER BY vehicles DESC
LIMIT 5;
route avg_delay_s vehicles 24 32.1 2880 51.7 24121 18.4 2251 44.9 19165 27.6 17
5 rows · 0.023s · updated 30s ago
Refreshes metrics + query results from the live pipeline
CONNECTED LIGNE ORANGE yesid.dev v2.0 SCROLL ↓
LAT 45.5017°N LNG 73.5673°W SRC Sherbrooke, QC VIA Lennoxville, QC DST Montréal, QC NODE berri-uqam STATUS active
SEC—02 MANIFESTO MTL—QC
0
80
160
240
320
400
480
PROCHAIN / NEXT 02:47
QUAI / PLATFORM 2
DIRECTION: CENTRE-VILLE
yesid@mtl :~$ cat manifesto.md
I BUILD THE
INFRASTRUCTURE
YOUR OPERATIONS RUN ON.

Projects.

Projects.

Transit Operations Data Pipeline
30s Real-time refresh cycles
PG ·PY ·DBT ·BI ·AIRFLOW
Lorem Analytics Dashboard
2 days
15 min Reporting across 12 depts
BI ·SQL ·PY ·DAX
Lorem Database Migration
500 GB Zero-downtime migration
PG ·PY ·ALEM ·MY
01 / 03
View all projects →

Services.

01 / SERVICE
SQL Development & Optimization
Queries that run in seconds, not minutes
3x faster avg query improvement
02 / SERVICE
Data Pipeline Architecture
Your data arrives clean, on time, every morning
99.9% pipeline uptime
03 / SERVICE
Analytics & Reporting Systems
Decisions in 15 minutes, not 2 days
2d → 15m reporting turnaround
04 / SERVICE
Database Engineering
Zero-downtime migrations while you sleep
500GB+ migrated safely
05 / SERVICE
Internal Tooling
Your team stops copying between spreadsheets
80% less manual data entry
06 / SERVICE
Web Development
A frontend that matches your backend quality
100 Lighthouse performance
View all services →

Services.

Terminus.

Terminus.

yesid@terminus:~/destinations
// where to next?
01 CONTACT Start a project together GO ->02 EXPLORE GitHub · open-source work GO ->03 READ Why I Left ORM for Raw SQL cd ->04 READ Designing a Star Schema from Scratch cd ->05 ABOUT Yesid O. · Montreal cd ->
 
Montreal, QC
UTF-8
5 destinations
Initialize connection ->