Mario Aragón Valderrama

Reporting Automation: Redesigned the monthly reporting consolidation system in Power Query, replacing a fragmented process with a single Combine from Folder architecture feeding a unified Data Model in Excel.

Interactive Reporting: Built interactive R Markdown reports for weekly tracking of mediator performance and Motor fleet analysis, comparing Agent and Broker channels by territorial division with dynamic filtering.

Optimization Modelling: Developed and maintained coefficient optimization models for commercial targets (NP/GWP) across the SME and Retail segments, including diagnostic tools to detect and clean corrupted data.

Commercial Performance & Distribution Analyst (Internship) at Zurich Insurance (2026-02 – 2026-09)

• Reporting Automation: Redesigned the monthly reporting consolidation system in Power Query, replacing a fragmented process with a single Combine from Folder architecture feeding a unified Data Model in Excel.
• Interactive Reporting: Built interactive R Markdown reports for weekly tracking of mediator performance and Motor fleet analysis, comparing Agent and Broker channels by territorial division with dynamic filtering.
• Optimization Modelling: Developed and maintained coefficient optimization models for commercial targets (NP/GWP) across the SME and Retail segments, including diagnostic tools to detect and clean corrupted data.
• Market Share Analysis: Produced territorial market share analyses and presentations (Excel, PowerPoint) supporting commercial strategy across Motor, Home, Global and SME business lines.
• Time Series Forecasting: Applied time series forecasting techniques, mainly ARIMA, to premium series, building train/test validation pipelines to improve forecast accuracy.

BASc in Statistics – Universitat de Barcelona (UB) / Universitat Politècnica de Catalunya (UPC) (2022 – 2026)