Medallion ETL Pipeline – Bronze, Silver, Gold Data Architecture
Python ETL pipeline that ingests mixed-format data, standardizes it across layered stages, and produces analytics-ready datasets.
I’m an M.S. in Information Systems candidate at California State University, Long Beach and a USC alum. I focus on nonprofit IT, data systems, and lightweight automation using tools like Google Workspace, Airtable, and Google Apps Script.
Recently, I’ve supported arts and community organizations across Los Angeles and Long Beach by building Airtable systems for grant tracking and reporting, onboarding teams to Google Workspace, and automating workflows that reduce manual work.
I’m especially interested in using data and automation to support better decision-making and help small teams scale their impact.
My approach is simple. Clean systems, clear documentation, and practical solutions that save time.
A couple of recent builds and experiments.
Python ETL pipeline that ingests mixed-format data, standardizes it across layered stages, and produces analytics-ready datasets.
Python command-line tool that analyzes text files and generates word and character frequency reports.
Notes on systems, automation, and graduate school.
Jan 20, 2026
Most of my work with nonprofits starts the same way: Too many tools. Too many spreadsheets. Not enough structure. Over time, I’ve learned that the problem is...
Read articleDec 17, 2025
One of the most important ideas I’ve been learning in my MSIS journey is this: Large language models are powerful, but they don’t know your data. That’s where...
Read articleAug 25, 2025
On Saturday, August 23rd, 2025, I attended orientation for the MSIS program at CSULB. Sitting in a classroom again felt a little surreal. It has been years...
Read article