Featured Projects

6/27

SIMA - Integrated Actuarial Modeling System

Valuing life insurance reserves requires connecting mortality projection, product design, and regulatory capital in one continuous flow. SIMA handles it end-to-end: Lee-Carter mortality projection, commutation tables, reserve valuation for three products, and RCS capital requirements with stress testing under LISF. Deployed on Google Cloud.

PythonFastAPIReactLee-Carter+4

GMM Explorer - Major Medical Expenses

Pricing major medical insurance without real claims data is guesswork. This project processes 5.1M claims and 95.9M insured-years from CNSF open data (2020-2024), classifies them into three hospitalization levels with AI, and calculates the net premium via frequency-severity adjusted for medical inflation. The output: an interactive tariff calculator on Vercel.

Next.jsPythonActuarialGMM+5

Data Analyst Portfolio

A data analyst is evaluated by the range of problems they can solve, not just the tools they know. This portfolio brings together 7 end-to-end projects: e-commerce cohorts, actuarial reserves, A/B testing, executive KPIs, and financial risk analysis. All deployed with interactive dashboards.

PythonSQLStreamlitNext.js+2

CreditGraph: Topological Credit Risk Analysis

Traditional credit analysis treats each loan as independent, but guarantee chains, circular guarantees, and ownership concentration create correlated exposure invisible to relational models. CreditGraph models a 500-client portfolio as a Neo4j graph, processes data with PySpark on Databricks, scores with Platt-calibrated LightGBM, and runs topological stress tests that reveal structural risk patterns hidden from SQL.

Neo4jPySparkDatabricksCypher+3

GCP Data Platform for Insurance

An insurance claim travels a long path between the event and the model that prices it. Automating that flow produces faster, more reliable, and more consistent data. This project builds every segment on GCP: real-time ingestion with Pub/Sub and Beam, dimensional warehouse in BigQuery, Dagster orchestration, Terraform infrastructure, and a Tweedie GLM that turns clean data into actuarial premium. Six stages, one continuous flow.

BigQueryTerraformPub/SubApache Beam+4

IMSS Pension Simulator + Fondo Bienestar

Most Mexican workers do not know which pension regime they are enrolled in or what they will actually receive at retirement. This R Shiny app resolves that ambiguity: enter salary, contribution weeks, and expected AFORE return to get estimated benefits under Ley 73, Ley 97, and Fondo Bienestar, with sensitivity analysis and a downloadable report.

RShinyIMSSAFORE+1

Skills

Languages & Tools

Python TypeScript R SQL Bash Advanced Excel Git LaTeX

Cloud & DevOps

GCP Cloud Run Cloud SQL BigQuery Docker GitHub Actions Secret Manager PostgreSQL

Actuarial Science

Life Insurance Property Insurance Lee-Carter Reserves (BEL) SCR Regulation (LISF/CUSF) Mortality Tables IMSS Pensions

Data Science & ML

scikit-learn PyTorch XGBoost GLM Monte Carlo Simulation Bayesian Inference Pandas Streamlit

Web Development & AI

FastAPI React Astro Tailwind CSS Claude Code Anthropic API Plotly

Quantitative Finance

Derivatives Black-Scholes Portfolios (Markowitz) VaR Forward Curves Financial Mathematics

Education

B.S. in Actuarial Science

National Autonomous University of Mexico (UNAM)

Faculty of Sciences · 2021 – 2025

100% credits completed, degree in progress