Projects.

Projects.

Projects, pipelines, and systems I have built.
Showing: All
Services
Tech Stack
Tags
yesid.dev — Portfolio Site

yesid.dev — Portfolio Site

The site you are looking at: a SvelteKit portfolio built slice by slice.

Services
Web Development
Tech Stack
SvelteKitSvelte 5TypeScriptTailwind …Vercel
portfoliowebsvelte

Transit Operations Data Pipeline

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

Services
Data Pipeline Architecture
SQL Development & Optimization
Tech Stack
PostgreSQLPythondbtPower BIApache Ai…
etltransitpostgresqldbt

Lorem Analytics Dashboard

Executive KPI dashboard tracking operational metrics across 12 departments.

Services
Analytics & Reporting Systems
Tech Stack
Power BISQL ServerPythonDAX
analyticsreportingsql-server

Lorem Database Migration

Zero-downtime migration from legacy MySQL to PostgreSQL for a SaaS platform.

Services
Database Engineering
SQL Development & Optimization
Tech Stack
PostgreSQLPythonAlembicMySQL
postgresqlmigrationschema

Lorem Query Optimizer

Automated SQL Server query analysis tool that identifies slow queries and suggests index improvements.

Services
SQL Development & Optimization
Database Engineering
Tech Stack
SQL ServerPythonSSMST-SQL
sqlperformancesql-server

Lorem Retool Admin Panel

Internal operations dashboard for managing inventory and approval workflows.

Services
Internal Tooling
Analytics & Reporting Systems
Tech Stack
RetoolPostgreSQLREST APINode.js
retooladminpostgresql