Hi, I'm

Andrés González Ortega

Actuary · UNAM

I trained as an actuary at UNAM, and since then I haven't stopped building: a transformer trained on Proust, data platforms on GCP, AI agents over Mexican regulation, production APIs. Every project starts with a question I can't answer yet and ends with something that works.

Featured Projects

6/28
Actuarial Regulation Assistant
ActuarialGCP

Actuarial Regulation Assistant

LISF and CUSF together span over a thousand articles, and interpreting them requires navigating interrelated provisions. This agent indexes the full text of both laws and returns contextualized answers with exact article references, with no hallucinated citations. It includes an interactive explorer to browse all 510 LISF articles and 1,833 CUSF provisions with cross-references as active links. Access code: actuaria-claude.

Claude SDKFastAPILISFCUSF+2
Mexican Actuarial Suite
ActuarialGCP

Mexican Actuarial Suite

There is no open-source actuarial library built for Mexican regulation. suite_actuarial fills that gap: eight insurance domains (life, P&C, health, pensions, reserves, reinsurance, regulatory, configuration) with EMSSA-09 mortality tables, CNSF circulars, and SAT tax articles built into the design. It installs with pip, deploys with Docker, and exposes REST endpoints alongside a bilingual Next.js dashboard.

PythonPydanticNext.jsFastAPI+5
Flight Analytics: Aviation Data and Dashboards
Data EngineeringFirebase

Flight Analytics: Aviation Data and Dashboards

Airlines generate millions of records on flights, delays, revenue, and fleet utilization. Analyzing that data requires choosing the right database for each question. This project takes 5.74M real airline operation records, analyzes them in PostgreSQL to understand how to optimize queries from the engine level, migrates them to BigQuery to compare both database paradigms, and presents the findings in an interactive dashboard: route map, delay patterns, revenue concentration, and fleet performance.

PostgreSQLBigQueryPythonDocker+6
APIs for Analysts
Data EngineeringGCP

APIs for Analysts

If you work with Fed rates, Banxico exchange rates, or World Bank indicators, you already consume APIs without knowing it. This interactive platform teaches what happens between your request and your data: latency, errors, authentication, caching. A playground with live data, labs for breaking things on purpose, and what-if scenarios on mortality and economic data.

Next.jsTypeScriptFREDBanxico+2
SIMA: Integrated Actuarial Modeling System
ActuarialGCP

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
ActuarialVercel

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

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