Skip to content
JC
Portrait of Jonathan Carpio Arellano

San Francisco, CA

I’m Jonathan Carpio Arellano, a software engineering student at San José State University and an engineering intern on the Digital Transformation team at San Francisco International Airport (SFO).

I build data pipelines, dashboards, and web and mobile apps. I’m bilingual in English and Spanish, and years of customer-facing work in Venezuela, Panama, Peru, and the U.S. taught me to build for the person on the other side of the screen.

Selected work

Things I’ve built

A mix of work from my internship at SFO and personal projects: data pipelines, AI infrastructure, and apps people use every day.

Data engineering · Security analytics

Vulnerability intelligence pipeline and dashboards

SFO Cybersecurity · 2026

The reporting the SFO Cybersecurity team now uses to plan daily patching, built to replace a manual Excel process. A scheduled PowerShell pipeline keeps CrowdStrike Falcon data fresh, a star-schema Power BI model joins it to Active Directory, KACE patching, and the CISA KEV catalog, and the report flags which CVEs have a deployable patch, which need manual work, and which machines are missing EDR or patch coverage.

  • PowerShell
  • SQL Server
  • Power BI
  • DAX
  • CrowdStrike Falcon API

Internal project at San Francisco International Airport. No public code.

AI infrastructure · Agents

Self-hosted AI lab: a multi-agent dev team

Personal project · Sep 2026 – present

A self-hosted software-engineering team of AI agents running on an ASUS Ascent GX10 (NVIDIA GB10) that serves Qwen3.8-27B locally, so planning, coding, testing, and review never leave the machine. A spec-driven loop (requirements → design → code → tests → review) gives each agent its own isolated git worktree, and changes merge only after pytest passes and a human approves. Agents are sandboxed with NVIDIA NemoClaw/OpenShell, with secrets and network access locked down.

  • Python
  • FastAPI
  • vLLM
  • Docker
  • Linux

Runs on my own hardware. Write-up coming soon.

Mobile · React Native

Motiff: an AI-powered coach for students

Personal project · In progress

A cross-platform iOS and Android app built with React Native and Expo in a pnpm monorepo, with custom Expo config plugins for native iOS builds and an Android release pipeline on EAS Build. Supabase handles auth and Postgres, and the app integrates AI edge functions, PostHog analytics, and Sentry crash reporting.

  • TypeScript
  • React Native
  • Expo
  • Supabase
  • EAS Build

Web · Next.js

Calendra: a scheduling app

Personal project · 2025

A scheduling app built with Next.js and TypeScript. Clerk handles sign-in, Drizzle ORM and server actions talk to a Neon Postgres database, and the Google Calendar API syncs bookings. Deployed on Vercel; a small project that let me go deep on the App Router, typed database access, and shipping a polished UI end to end.

  • Next.js
  • TypeScript
  • Clerk
  • Drizzle ORM
  • Neon Postgres
  • Tailwind CSS

Experience

Where I’ve worked

Engineering and IT roles first, then the customer-facing jobs that shaped how I build.

  1. Student Design Trainee II (Software Engineering Intern), CITO – Digital Transformation

    Jun 2026 – Present

    San Francisco International Airport · San Francisco, CA

    • Design the ingestion pipeline for SFO Cybersecurity’s vulnerability program: scheduled PowerShell jobs pull CrowdStrike Falcon API data with atomic file replacement and failure alerting, so downstream reports never break on a bad run.
    • Design a star-schema Power BI model that unifies CrowdStrike Falcon Spotlight, Active Directory, KACE patch management, and the CISA Known Exploited Vulnerabilities catalog, replacing a manual Excel process.
    • Develop the multi-page Power BI report the Cybersecurity team uses to plan daily patching; SQL over KACE patch tables flags which CVEs have a deployable patch and which need manual remediation.
    • Reconcile endpoints across Active Directory, CrowdStrike, and KACE with tiered hostname matching to surface machines missing EDR or patch-management coverage.
    • Extend reporting to servers with a risk dashboard that tiers 120 in-scope servers by CPU, memory, storage, and OS support status and flags the 26 critical hosts to fix first.
    • Define SFO’s first API-access process after flagging plaintext credentials in a vendor setup script, proposing a secrets vault and dedicated service account as the reusable standard.
  2. Student Design Trainee, Strategic Initiatives

    Jul 2025 – Oct 2025

    San Francisco International Airport · San Francisco, CA

    • Ran discovery sessions with stakeholders across airport operations to map existing processes, document requirements, and identify automation opportunities aligned with SFO’s digital transformation strategy.
    • Built an Excel knowledge base cataloging SFO’s TSA-mandated systems, their owners, dependencies, and criticality to prioritize modernization work. Invited back the next summer for an expanded engineering role.
  3. Application Development Intern

    Sep 2023 – Mar 2024

    San Mateo County Transit District (SamTrans) · San Carlos, CA

    • Led four interns migrating 1,000+ users’ files to OneDrive, validating permissions and training staff along the way.
    • Configured SharePoint Online sites and Lists and automated migration status tracking with Power Automate.

Before software

Sales, production, merchandising, and retail across Venezuela, Panama, and California, 2017–2022. Different industries, same habit: learn what the customer actually needs first.

  • Merchandiser

    Apr 2021 – Jan 2022

    PepsiCo · Benicia, CA

    Serviced high-volume grocery accounts on a fixed route, kept shelves, coolers, and displays stocked and rotated, and was the face of Pepsi for store managers.

  • Machine Operator

    Aug 2020 – Apr 2021

    Del Monte Foods · Lathrop, CA

    Ran palletizer, labeling, and casing lines, owned end-of-shift production reports, and followed lockout/tagout procedures on every changeover.

  • Executive Sales Representative

    Aug 2017 – Aug 2018

    Interwelt Travel Assistance · Caracas, Venezuela

    Grew travel-insurance sales through daily visits to travel agencies, trained agency staff on the company’s policy software, and represented the company at international tourism conventions.

  • Intern

    Mar 2017 – Aug 2017

    Interwelt, Asistencia Mundial al Viajero · Panama City, Panama

    Wrote the procedural manuals the company used to open new international locations and evaluated new business opportunities.

Plus retail roles at Mara Biomarket (2018–2019) and, after moving to the U.S., at Carnicería Rositas in Manteca, California (2020).

About

From Caracas to San Francisco

Four countries, a dozen jobs, and one constant: I like understanding people before I build for them.

I grew up in Caracas, Venezuela, where my first business was a computer and a printer my mother bought me in high school. I printed homework for neighbors and made copies for classmates, and I learned early that technology is only useful when it solves a real problem for a real person.

After studying foreign trade at Universidad Simón Bolívar, I worked in travel insurance across Latin America: first as an intern in Panama, then as a sales executive in Caracas, training travel agencies on our software and representing the company at international conventions. In 2019 I moved to the United States, learned English at my local community college, and worked merchandising, production, and retail jobs while I planned my way into tech.

In 2023 I joined Year Up’s application development track, landed an application development internship at SamTrans, and started computer science classes at Diablo Valley College, where I graduated with a 3.95 GPA. Today I’m finishing a B.S. in Software Engineering at San José State University and working as a software engineering intern at San Francisco International Airport, building the data pipelines and dashboards the Cybersecurity team relies on every day.

Outside of work I’ve spent years volunteering: more than four years as a camp counselor in Venezuela, and more recently with an outreach committee in Benicia preparing food bags for unhoused neighbors. I like building things that make someone’s day a little easier.

Jonathan Carpio Arellano smiling at an outdoor restaurant table
Based in
San Francisco, CA
Languages
English and Spanish
Worked in
Venezuela, Panama, Peru, and the U.S.
Studying
B.S. Software Engineering, SJSU, Dec 2027

How I work

Built for the person on the other side

Bilingual, customer-first, and grounded in context. Here’s what that means in practice.

  • Bilingual and bicultural

    I’m fluent in English and Spanish, and I’ve sold, trained, and supported customers in both. I can sit with a stakeholder, understand the real request, and turn it into requirements without losing the nuance.

  • Customer service, practiced for years

    Before engineering I spent years face to face with customers: travel agencies in Caracas, store managers on a PepsiCo route, shoppers at the register. I learned to listen first, follow through, and treat every handoff like someone is waiting on it.

  • Context before code

    Selling to travel agencies in Caracas, writing expansion manuals in Panama, and starting over in California taught me that the same product lands differently in different places. I start with discovery, map how people actually work, and ship the version that helps them.

Skills

What I work with

Languages

  • Python
  • TypeScript / JavaScript
  • Java
  • SQL
  • PowerShell
  • C++
  • HTML / CSS

AI & ML

  • PyTorch
  • Hugging Face
  • vLLM
  • Ollama
  • RAG (pgvector)
  • Agent orchestration
  • Claude Code
  • OpenClaw

Frameworks

  • React
  • React Native
  • Expo
  • Node.js
  • Next.js
  • FastAPI

Data & platforms

  • Power BI / DAX
  • SQL Server
  • PostgreSQL
  • SharePoint
  • Power Automate
  • Power Apps

Developer tools

  • Git
  • Docker
  • Linux
  • npm / pnpm
  • Jira
  • VS Code
  • PyCharm
  • Cursor
  • Codex

Spoken languages

  • English (fluent)
  • Spanish (native)

Education

Where I’ve studied

  • San José State University

    Sep 2025 – Dec 2027 (expected)

    B.S. in Software Engineering

    San Jose, CA

    GPA 3.61

  • Diablo Valley College

    May 2025

    A.S. in Computer Science

    Pleasant Hill, CA

    GPA 3.95

  • Year Up

    2023

    Application Development track

    Workforce program for underrepresented adults; led to the SamTrans internship

  • Universidad Simón Bolívar

    2017

    Associate degree in Foreign Trade

    Venezuela

Contact

Let’s build something that helps people.

I’m based in San Francisco and happy to talk about software, data, and products that serve real users. In English or en español.