Aníbal Valencia Medina

Senior Data & Analytics Engineer — Energy & Insurance · Oracle/SQL · Python · Power BI/Qlik · ML & LLM

Senior BI/Data Engineer across power distribution and insurance. Founder of Ai4G, where I build production-grade data platforms and AI features for brokers and carriers. I turn Oracle/SQL + Python + Power BI/Qlik into audit-ready analytics—standardized KPIs, validated datasets, and executive dashboards. I also deliver ML (forecasting, anomaly detection, classification) and LLM features (RAG, function calling) that plug cleanly into existing BI stacks. English/Spanish, remote.

Industries: Power Distribution/Utilities, Insurance (Broker/Binder, Agro), Operations Analytics, Regulatory Reporting

Core: Data Engineering, BI, ETL/ELT, Data Modeling, Data Analysis, Data Quality, Audit-ready Reporting, Observability

Databases & SQL: Oracle, SQL Server, PL/SQL/T-SQL, Partitioning, Indexing, MVs, Views

Python & Tooling: pandas, NumPy, scikit-learn, XGBoost/LightGBM, Typer CLI, YAML config, MLflow/DVC

Time Series & Anomaly: SARIMAX/ARIMA, Prophet, Isolation Forest, change-point detection

LLMs & GenAI: GPT/Grok/Gemini/Claude/Llama/Mistral · RAG, embeddings, vector DBs (pgvector/FAISS/Chroma), function calling

BI: Power BI (DAX, Power Query, RLS, performance), Qlik (data model & publishing)

Insurance KPIs: Premium (written/earned), Loss Ratio, Combined Ratio, Claim Cycle Time, Churn/Lapse

Pipelines & Ops: CI/CD, Scheduling/Monitoring, Metadata/Lineage, Alerts, Documentation

Languages: English (professional), Spanish (native)