SERVICES

Visualization & Analytics

Process Automation

│ 🐍 Python • 🕷️ Web Scraping │ 🔌 APIs • ⚙️ ETL • 🗄️ SQL │ 📦 Pandas • ⚡ Dask

│ 📊 Power BI (DAX) • 📈 Looker Studio │ │ 🐍 Python • 📐 Modeling • 🗄️ SQL │ │ 📗 Advanced Excel│

│🔄 N8N │ 🤖 IA │ 🐍 Python │ 🔌 APIs │ 💬 Telegram │ 📧 Google Workspace │ 🏢 ERP (Odoo)

PROJECTS AND EXPERIENCE

✅ Software adopted in PMG 2024 🏛️ Municipality of Lota 🎯 Lean Government + KPIs 🏷️ GovTech · Python (Tkinter) · SQL

Central Planner Software (PMG 2024)

✅ Web App + 2 functional ETLs 🚗 Chilean automotive sector 🎯 PDF Scraping → Clean data for BI 🏷️ React · Gemini · Selenium

I have transformed real data into concrete solutions

18M+ records | 🤖 Applied Artificial Intelligence | $2B+ analyzed

FIELD SALES ASSISTANT

Chilean Public Market Analysis

📊 18M records · 71 variables · 4 years 💰 +$2 billion CLP in analyzed transactions 🎯 3 deliverables: SME Report + Public Dashboard + Funnel Methodology

✅ 2 dashboards: Corporate + Personal 🚗 Chilean insurance benchmark 🎯 Score 0-100 (IEC + Time + Coverage) 🏷️ InsurTech · Power BI · DAX

🤖 AI (Gemini) + Telegram + ERP Odoo ⚡ Product queries for field sales 📧 Quotes sent via email 👤 Customer registration and validation 🏷️ Telegram bot connecting sales reps with the ERP in real-time.

benchmark analysis of auto insurers

Telegram bot that connects sellers with the ERP in real time

IT Consulting Benchmark on Instagram

✅ Non-parametric statistical analysis 📊 10 Chilean IT consulting firms 🎯 Scraping + LLM + Google Trends 🏷️ Python · SciPy · Apify · Power BI Subtitle: Misleading Metrics and Market Trends.

2024 Management Improvement Program of the Municipality of Lota.

Multidimensional Scoring System.

Chilean Automotive Ecosystem

Data Pipelines - Web App + ETLs to extract and clean automotive sector data.

Misleading Metrics and Market Trends.

Market Opportunity Analysis

ABOUT ME

🌍 LANGUAGES

🌐 Spanish — Native (Chile) 🌐 Portuguese — Intermediate (Brazil) 🌐 English — Intermediate

🎓 EDUCATION

• Management Control & Information Systems Engineer

• Bachelor in Information Systems

• Diploma in Agile Project Design and Management

🔧 TECH STACK

Analysis & BI: Python 🐍 • SQL 🗄️ • Advanced Power BI (DAX) 📊 • Looker Studio 📈 • Advanced Excel 📗

Data Engineering: ETL ⚙️ • APIs 🔌 • Web Scraping 🕷️ • Pandas • Dask

Automation: N8N 🔄 • Python scripts 🤖 • Integrations • Power Automate

Areas of expertise

💰 Corporate Finance • 📊 Management Control • 📈 Business Analytics • 🎯 KPI Design • 💹 Profitability Analysis • 📐 Financial Modeling • 📉 Applied Statistics

Scaling decisions with data and replacing manual tasks with autonomous systems"

📈MEASURABLE IMPACT

18M+ records processed | $2B+ CLP analyzed | 50% ↓ reduction in analysis time | +15K anomalies detected | Software adopted in the public sector | Business unit created from scratch