freelance digital infrastructure - Montreal

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

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.

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.

Services.

Databases & SQL

Queries that run in seconds, not minutes

Pipelines & Automation

Your data arrives clean, on time, every morning

Dashboards & Analytics

Decisions in 15 minutes, not 2 days

Websites & E-commerce

A storefront as fast as the systems behind it

View all services →

Services.

About.

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

Guess where I am?

Montreal

-

STOP 04 · INTERESTS

Projects.

yesid.dev

yesid.dev secondary view

yesid.dev

My own site, run like client work: the CMS is the source of truth, the edge serves generated content, and every claim is locked by a test.

Websites & E-commerce

Databases & SQL

3,151 tests guarding the build

0 CMS calls per visit

650 bilingual strings, locked by a test

Transit Operations Data Pipeline

An end-to-end ELT pipeline processing real-time transit data for a regional operator.

Pipelines & Automation

Databases & SQL

Dashboards & Analytics

Websites & E-commerce

30s Real-time refresh cycles

99.9% Pipeline uptime

01 / 02

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.

Terminus.

yesid@terminus:~/destinations

// where to next?

01 STACK Tools and architecture cd ->02 CONTACT Start a project together GO ->03 YESID About the builder cd ->04 BLOG Writing and field notes cd ->05 GITHUB REPO GitHub · open-source work GO ->

Initialize connection ->