📚 Tabla de Contenidos
Hi, I'm Andre (Jharol André Vilca Ramos), double-degree student in Industrial Engineering and Data Science, broadcasting from Lima, Perú 🇵🇪. I build SQL pipelines, models and dashboards that turn messy operational data into actionable insights — applying industrial engineering rigor to data science problems.
I'm a restless reader: I devour papers on AI fairness, behavioral economics, psychology of decision-making, environmental engineering, legal informatics, and fitness science — whatever catches my attention today.
- 🎓 Student: Industrial Engineering + Data Science (dual track)
- 📍 Based in: Lima, Perú
- 🏢 Target role: Analista de Datos Junior / Practicante BI
- 📊 Daily driver: Python (Pandas, scikit-learn, statsmodels), R (XGBoost, Stan/brms), TypeScript
- 🗄️ BI stack: SQL (DuckDB: CTEs, window functions, star schema), Power BI (DAX), Looker Studio
- 🧪 Research interests: AI ethics & fairness, decision neuroscience, behavioral economics, environmental sustainability, legal informatics, fitness science, ensemble methods for prediction
- 📝 Academic writing: LaTeX (IEEE, APA 7), reproducible reports with DOI on Zenodo and ResearchGate — see Publications
| Project | Description | Status | Stack |
|---|---|---|---|
dashboard-demanda-delivery |
Star schema in DuckDB, 10 SQL marts, 17 data-quality rules and tests; Power BI (DAX) + public Looker Studio · DOI | ✅ v1.0.0 | SQL · DuckDB · Power BI · Looker Studio |
demanda-delivery-v2 |
Price elasticity of demand in food delivery (456K obs.): OLS, panel FE, IV, splines · DOI | ✅ v3.3.0 | Python · statsmodels · linearmodels · LaTeX |
A.N.D.R.E. |
Ensemble stacking predictor for football matches (World Cup 2026) | ⚡ Active | R · XGBoost · Stan/brms · plumber |
dophamine |
Offline-first wellness app: nutrition, training & biometrics tracker with weekly insights · site · web app | 🚀 v0.3.0 | TypeScript · React Native · SQLite |
theyso |
Self-hosted remote control for Claude Code / OpenCode from your phone: local server + Flutter app, no cloud in between | 🚀 v0.1.2 | Python · WebSockets · Flutter · Tailscale |
LaTeX Templates |
Academic writing templates following IEEE and APA 7 standards | ✅ Maintenance | LaTeX · IEEE · APA 7 |
Elasticidad precio-demanda en el servicio de delivery de comidas: evidencia desde datos transaccionales (2026). Working paper, v3.3.0.
Price elasticity of demand on a food delivery platform with 456,548 week × center × meal observations: OLS, two-way fixed effects, IV 2SLS, restricted cubic splines and quantile regression. Main finding: elasticity is not a single number — it varies with price level, category, week and identification strategy.
Dashboard de demanda en delivery: SQL (DuckDB), Power BI y Looker Studio (2026). Software, v1.0.0.
Data layer and dashboards for the same 456,548-row dataset: star schema, 10 business queries with CTEs and window functions (ABC, cohorts, promotion index, price deciles), 17 quality rules that stop the pipeline, and tests that reconcile every figure with the study above.
Informe Técnico: Caracterización Fisicoquímica de Suelos Urbanos del Parque Kennedy (2026). Technical report.
Right now, Andre is deep-diving into:
- Industrial Engineering + AI — optimizing systems with data-driven decisions
- Causal inference — counterfactuals for real-world impact
- xG/football analytics — ensemble methods for match prediction
- AI in legal docs — NLP for contract analysis (side quest)
- Decision neuroscience — what the brain tells us about choice
- Fitness science & nutrition — data-driven wellness tracking
