In my applied and freelance projects, I design ETL/ELT workflows to ingest, clean, transform, validate, and integrate data using Python, SQL, Pandas, and PySpark.
I processed and validated 200,000+ clinical encounter records and medication catalogs containing 46,000+ products, with reusable checks for data quality and exception reporting.
I built an automated healthcare catalog data agent that validates EANs, researches unknown products through web scraping, and reconciles records using exact, fuzzy, and cosine-similarity matching. It generates Salesforce-ready import files and validation outputs.
I also processed and cleaned 17M+ prescription records for downstream use. For my financial data science thesis project, I built regression and time-series models to analyze S&P 500 behavior and presented results at the National Congress of the Mexican Mathematical Society.
