GS/PORTFOLIO

(Open to new roles)

ESGet in touch →

(Portfolio ©2026)
Data & AI Engineer

I turn scattered business data into dashboards and AI tools that people actually use, from the warehouse to the screen.

  1. 01AboutWho I am, what I work with
  2. 02Experience3 roles, 2022–now
  3. 03Work4 live demos
  4. 04ContactEmail, GitHub, LinkedIn

Gerardo Sanchez

Based in Monterrey, Mexico--:--:-- localScroll ↓
01

About

I studied physics at UANL. For my thesis I simulated gravitational microlensing and built a dataset of 223k light curves to train a machine-learning classifier. In industry I kept running into the same problem: the data exists, but nobody can see it.

At a food-manufacturing group in Monterrey, I led the data side of an ERP rollout and gave management its first live view of sales, production and costs. Now I freelance, building data warehouses on Google Cloud, dashboards and LLM-powered tools. On my own time I build Money on Rails, a budget analysis app on top of the YNAB API.

Currently
Freelance data & AI engineering
Building
Money on Rails
Based in
Monterrey, Mexico · open to remote work or relocation
02

Experience

Full résumé ↗
  1. 012025 – Now

    Independent Data & AI Engineer @ Corporate clients

    I build serverless data platforms on Google Cloud: Cloud Functions, Pub/Sub and BigQuery, modelled with dbt, with a Looker Studio dashboard for leadership on top. I shipped a Meta Conversions API service that sends offline sales back to Meta; it was in production within a week. I run and maintain what I ship under monthly service agreements.

    • GCP
    • BigQuery
    • dbt
    • Python
    • Looker Studio
    • Meta CAPI
  2. 022024 – 2025

    Lead Data Analyst @ TortiRegias · Nyjisa · Chilokia

    Led the data side of the Alpha ERP rollout across the group, working with every department head. Built a Power BI production dashboard and a maintenance dashboard (Dashboard de Mantenimiento) that gave management its first live view of operations. Shipped App Tarimas, which cut Walmart pallet labelling to about two minutes, and automated reports that took roughly two months of manual work a year.

    • SQL
    • Power BI
    • Python
    • Streamlit
    • React
  3. 032022 – 2023

    Undergraduate Researcher @ UANL · Facultad de Ciencias Físico Matemáticas

    Thesis on gravitational microlensing. Derived the lensing model from first principles, simulated it in Fortran over a wide parameter sweep, and produced 223k labelled light curves to train a classifier that detects microlensing events.

    • Fortran
    • Python
    • Machine learning
03

Work

04 live demos

01 / 05

Money on Rails

Money on Rails connects to YNAB and tells you what YNAB won't: an adherence rating for how closely you followed your plan, a plan-quality score for how well it's built (needs, wants and savings split, emergency fund, true expenses), and a chart of where each month's money went. The invite-only 1.0 shipped in September 2026. Try it on an invented household, no sign-in.

Type
Case study
Year
2026
Stack
Next.js, TypeScript, YNAB API, Postgres, ECharts, OpenAI
Signal
● Live · hover the screen to try it

Step inside →

TV: “IBM PCjr 4863 Computer” by Freepoly.org, CC BY 4.0
Rivera householdApr 2025 to Sep 2026, USD Alex RiveraSample householdAR

Sample data: an invented household, not connected to any YNAB account.About Money on Rails

Your month at a glance

‹August 2026›

Adherence Rating

How closely you followed your plan

+1 vs average of Aug 2025 to Jul 2026

Apr 2025floor 85Aug 2026

Plan Quality

How well it is built, last 3 months

Needs, Wants, Savings split61% / 16% / 23%
86
Emergency fund4.0 of 6 months
66
True expenses8 of 8 funded
100

Money in and out

Ticks: 12-month average

✓ Saved $2,206
Income$14,440−$687
Spending$12,084−$1,198
Paying down card debt$150+$17

Top groups

Home$2,786−$29
Savings and investing$1,900−$117
Kids$1,543+$36

Where the money went in Aug

Top sources and groups

ChartTable

Needs your attention

3 things to look at

  • ✦6 categories waiting for a bucket
  • ◔Emergency fund covers 4.0 of 6 months
  • ✦10 categories overspent in Aug

Needs, Wants, Savings

Assigned in Aug

NNeeds61%target 50%
WWants16%target 30%
SSavings23%target 20%
03.1

Index

No.ProjectTypeStackYearLink
01Money on RailsCase studyNext.js / TypeScript / YNAB API / Postgres / ECharts / OpenAI2026
02App TarimasCase studyReact / Ant Design / dnd-kit / Barcodes2025
03Sales dashboardDemo dashboardTypeScript / SVG / Astro2026
04Appointments dashboardDemo dashboardTypeScript / SVG / Astro2026
05gsanchez.meCase studyAstro / TypeScript / SVG filters / Cloudflare Workers2026
04

Contact

> say --hello