Skip to content
View ricardodreyes's full-sized avatar
0 followers · 2 following

Achievements

Achievement: Pull Sharkx2Achievement: Pair ExtraordinaireAchievement: YOLO

Achievements

Achievement: Pull Sharkx2Achievement: Pair ExtraordinaireAchievement: YOLO

Block or report ricardodreyes

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ricardodreyes/README.md

Hey, I'm Ricardo

Business analytics senior at USF, graduating December 2026, looking for my first data engineering/analytics role (resume). By day I build the Python pipelines behind Giraux Fine Jewelry's online store, including a NetSuite-to-Shopify catalog sync for 849 products. The projects below are mine start to finish.

What I work with: SQL, Python, dbt, DuckDB, PostgreSQL, pandas, scikit-learn, XGBoost, R, Tableau, Shopify, Vercel

Outside of work: lifting, and keeping tabs on San Francisco, which is where two of the projects below came from.

Selected work

  • SF Muni Equity Tracker: 28.7 million Muni arrivals joined to census tract income. Routes through the poorest tracts average 2.6 times the delay of the richest. Most of that gap is 3 cable cars, though. Live map.
  • SF Accountability Ledger: 12 reporting deadlines San Francisco wrote into its own laws, checked against primary sources every 2 weeks. It scores filed and findable separately. Live site.
  • gtm-warehouse: a dbt warehouse on DuckDB over my own cold outreach data. SCD type 2 lead history, a late-arriving reply fact, 76 data tests, and a synthetic dataset so anyone can run it.
  • aidep: Dependabot for AI APIs. Finds deprecated model and API usage in a repo and opens the migration PR.

Tech stack

Python SQL dbt DuckDB PostgreSQL pandas scikit-learn XGBoost R Tableau Shopify Vercel Git

Pinned Loading

  1. sf-muni-equity sf-muni-equity Public

    SF Muni on-time performance vs neighborhood income: Python/DuckDB pipeline and a React/Mapbox site with a live tracker

    JavaScript

  2. sf-equity-tracker sf-equity-tracker Public

    SF Accountability Ledger: whether San Francisco meets the reporting deadlines in its own laws

    Python

  3. gtm-warehouse gtm-warehouse Public

    SQL/dbt warehouse on DuckDB with SCD Type 2 history, incremental replies, 76 data tests, and a runnable synthetic example.

    SQL

  4. aidep-dev/aidep aidep-dev/aidep Public

    Dependabot for AI APIs: scans a repo for deprecated model and API usage, opens the migration PR, proves it held.

    TypeScript