Andre Garon Rico
Financial Data Engineer & FP&A Systems Architect
Anaplan Certified · SAP BW/BPC · Python · AI forecasting
Charlottesville, VA · LinkedIn · GitHub · 📄 Résumé (PDF)
I build the systems finance runs on. At Klabin, one of Brazil’s largest pulp-and-paper companies, I spent a decade building the SAP data warehouse and then the FP&A area on top of it, cutting the close and reporting cycle from about 4 days to less than 1. Since then I’ve built large-scale data platforms and machine-learning pipelines for genomic research at Penn State and the University of Pennsylvania, and 12true, a household finance platform built on a double-entry ledger.
What I bring
- Finance from the inside: budgeting, consolidation, CAPEX, intercompany and management reporting. Registered accountant in Brazil (CRC-SP).
- Engineering at scale: enterprise data warehouses, pipelines over billions of genetic variants, and full-stack platforms with more than 1,700 automated tests.
- AI applied to decisions: forecasting, machine-learning models and LLM assistants that work on real, governed data.
🌐 Prefer a website? The same portfolio, with navigation and search: andrerico.github.io/AndreRico
📘 Writing
| Project | What it is | Stack |
|---|---|---|
| SaaS Handbook | Open book on managing and operating SaaS for small teams; the repo is its own example. 📖 Read online | Quarto · GitHub Actions · Pages |
| Bioinformatics Handbook | Open book on bioinformatics for human genetics: from molecular biology to GWAS, rare variants, pharmacogenomics and knowledge graphs. 📖 Read online | Quarto · Mermaid · GitHub Pages |
💰 Finance & data platforms
| Project | What it is | Stack |
|---|---|---|
| 12true | Personal project: cross-border household finance platform on a double-entry ledger, with bank sync, receipt reading, US tax organizers and an AI assistant. In production · ~1,700 tests · 46 ADRs | Python · Django · PostgreSQL · React · TypeScript · Plaid · LLMs |
| FP&A: area and platform | Built Klabin’s FP&A area into the data warehouse (2016–2018), then led it full time (2018–2021): close and reporting cycle from ~4 days to <1, CAPEX, intercompany, EBITDA attribution | SAP BW-IP · BPC · HANA · AWS |
| Data warehouse & BI | 10 years on Klabin’s SAP BI platform: one enterprise data warehouse, BW 3.5 → 7.4 on HANA, ML talent intelligence for HR, security and automation | SAP BW · HANA · ABAP · Pentaho · Hadoop/Hive |
🧬 Genomic data systems
| Project | What it is | Stack |
|---|---|---|
| Biofilter | Persistent biological knowledge platform; its data powers the 13.8M-node knowledge graph behind DRIVE-KG | Python · SQL · ETL · CLI/API |
| IGEM | Gene–exposure knowledge base and public website for gene–environment research | Python · Docker |
| MyNHANES | Downloads, normalizes and harmonizes NHANES survey data across cycles into a local database, ready for analysis | Python · Django · SQLite |
| Penn Medicine BioBank research | Statistical genetics and ML on a 260,000+ participant biobank: hearing loss, cardiology and breast cancer | Python · HPC/GPU · ML |
| PharmCAT | Team member on an open-source tool that turns genotypes into prescribing recommendations; cross-platform testing and pipeline templates | Open source · VCF · cloud platforms |
📄 Publications
- Prado-Rico JM, Bargues-Carot A, …, Rico ALG, Hall MA, …, Huang X. Neuron-derived circulating miRNAs reveal lead (Pb) as a key component of metal mixtures exposure. medRxiv (preprint), 2026.
- Rajagopalan A, Nguyen TA, Guare LA, Rico ALG, …, Ritchie MD, Hall MA, Romano JD, Setia-Verma S. DRIVE-KG: Enhancing variant-phenotype association discovery in understudied complex diseases using heterogeneous knowledge graphs. Pacific Symposium on Biocomputing, 2026.
- Rajagopalan A, Nguyen TA, Guare LA, Rico ALG, …, Setia-Verma S. DRIVE-KG: Enhancing variant-phenotype association discovery in understudied complex diseases using heterogeneous knowledge graphs. medRxiv (preprint), 2025.
- Bargues-Carot A, Prado-Rico JM, …, Rico ALG, Hall MA, …, Huang X. MicroRNA expression in asymptomatic welders: implications for biomarker discovery for environmentally-linked neurodegenerative disorders. medRxiv (preprint), 2025. PMID 39990579.
- Rico ALG, Palmiero N, Ritchie MD, Hall MA. Integrated exposomic analysis of lipid phenotypes: leveraging GE.db in environment by environment interaction studies. Pacific Symposium on Biocomputing, 2025. (first author)
- Zhou J, Rico ALG, Guare L, et al. Flexibly encoded genome-wide association study identifies novel nonadditive genetic risk variants for cardiometabolic traits. medRxiv (preprint), 2023.
- Zhou J, Guare L, Rico ALG, Gonzalez Zarzar T, Palmiero N, Assimes TL, Setia-Verma S, Hall MA. Flexibly encoded GWAS identifies novel nonadditive SNPs in individuals of African and European ancestry. medRxiv (preprint), 2023.
🛠️ Toolbox
| Area | Tools and skills |
|---|---|
| Planning & EPM | Anaplan (Certified Model Builder) · SAP BPC · SAP BW-IP · driver-based planning · financial modeling |
| Finance | FP&A · close & consolidation · budgeting & forecasting · CAPEX · intercompany & managerial costing · US cross-border tax reporting (FBAR, 8938, PFIC) |
| Data engineering | SQL · SAP BW 7.4 on HANA · PostgreSQL · data warehousing & modeling · ETL (Pentaho) · Hadoop / Hive · Parquet |
| Analytics & ML | Python (pandas, statsmodels) · statistical modeling · ML on HPC/GPU clusters · Tableau · BusinessObjects |
| AI | LLM integration (tool use, document parsing, assistants) · AI coding agents |
| Software | Django · React · TypeScript · REST APIs · Docker |
| Cloud & practices | AWS · Linux · Agile · ADRs · data governance & PII protection |
Currently learning: SAP Analytics Cloud Planning · Databricks · dbt · Anaplan PlanIQ
→ Career path, education and languages
This repository follows the practices of the SaaS Handbook: decisions live in adr/, and the site is published by GitHub Actions on every push to main.