SYSTEMS THAT

VEHICLES TRACKED 1,247 DEMO · STM-STYLE

AVG DELAY 47.3s 87.6% COVERAGE

ROUTES LIVE 186 OF 227 TOTAL

VEHICLES TRACKED 1,247 DEMO · STM-STYLE

AVG DELAY 47.3s 87.6% COVERAGE

ROUTES LIVE 186 OF 227 TOTAL

I make data tell the truth.

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

See how I build → Book a 20-min intro call

yesid@transit:gold> DEMO

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
INNER 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	28
80	51.7	24
121	18.4	22
51	44.9	19
165	27.6	17

5 rows · 0.023s · demo data

Regenerates the metrics + query results. Simulated STM-style pipeline data, not a live feed.

yesid@transit:gold> DEMO

route	avg_delay_s	vehicles
24	32.1	28
80	51.7	24
121	18.4	22
51	44.9	19
165	27.6	17

5 rows · 0.023s · demo data

Regenerates the metrics + query results. Simulated STM-style pipeline data, not a live feed.

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

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.

Services

01 / SERVICE

Databases & SQL

Queries that run in seconds, not minutes

02 / SERVICE

Pipelines & Automation

Your data arrives clean, on time, every morning

03 / SERVICE

Dashboards & Analytics

Decisions in 15 minutes, not 2 days

04 / SERVICE

Websites & E-commerce

A storefront as fast as the systems behind it

View all services →

Services

About

Yesid.

Freelance Digital Solutions Developer

I take data, make it tell stories, and build the systems it moves through.

→ More about me

STOP 01 · LANGUAGES

STOP 02 · EDUCATION

Champlain Regional College, Lennoxville

DEC, Accounting & Management Technology

Bishop's University

B.Sc. Computer Science, minor in Business Administration

STOP 03 · LOCATION

Montreal

STOP 04 · INTERESTS

Projects

Transit: live buses and reliability for Montréal and Ottawa

Live bus positions and reliability history for Montréal's STM and Ottawa's OC Transpo, from a data pipeline I built and run alone.

Services

Pipelines & Automation

Databases & SQL

Dashboards & Analytics

Websites & E-commerce

Tech Stack

+12 more

8 880 tests in the October 26, 2026 CI snapshot

30 s configured live refresh interval

71 304 checks before STM history publication, October 26, 2026

1 533 buses observed on both maps, October 26, 2026, 7:30 a.m. ET

Café Arona: a bilingual Shopify storefront in progress for a family business

Introducing the business now and preparing for day-to-day management.

Services

Websites & E-commerce

Dashboards & Analytics

Tech Stack

+1 more

yesid.dev-design: a shared visual foundation for products with different jobs

One visual foundation, room for different products

Services

Websites & E-commerce

Tech Stack

yesid.dev: a three-language site, edited in one place, published on purpose

My professional site in English, French and Spanish, edited in Directus and published to Vercel with one deliberate action.

Services

Websites & E-commerce

Databases & SQL

Tech Stack

+9 more

3,655 tests in the October 26, 2026 CI snapshot

180 prerendered pages in the October 26, 2026 build

90 sitemap URLs in the October 26, 2026 snapshot

0 visitor requests to the editorial CMS

01 / 04

View all projects →

Projects

Let's build somethingthat moves.

Database, pipeline, dashboard, website: wherever it's stuck, that's where we start.

Get in touch View on GitHub

Terminus

yesid@terminus:~/destinations

// where to next?

CONTACT Start a project together GO -> YESID About the builder cd -> BLOG Writing and field notes cd -> GITHUB REPO GitHub · open-source work GO ->

Initialize connection ->

SYSTEMS THAT

Services.

Services.

About.

About.

STOP 01 · LANGUAGES

STOP 02 · EDUCATION

STOP 03 · LOCATION

STOP 04 · INTERESTS

Projects.

Transit: live buses and reliability for Montréal and Ottawa

Café Arona: a bilingual Shopify storefront in progress for a family business

yesid.dev-design: a shared visual foundation for products with different jobs

yesid.dev: a three-language site, edited in one place, published on purpose

Projects.

Let's build somethingthat moves.

Terminus.

Terminus.

Services

Services

About

About

Projects

Projects

Terminus

Terminus