a
anzohferate13

Xavier Ferate

@anzohferate13

Enterprise Power BI Consultant and Data Analyst

Chili
Anglais, Espagnol
Certaines informations sont présentées en anglais.
À propos de moi
Hi, I'm Javier, a Systems Engineer & Senior Data Analyst specializing in Microsoft Power BI, automated ETL, and executive reporting. I partner with executives and CFOs to turn complex data (SQL, ERP, Excel) into fast, single-source-of-truth dashboards. Core expertise: • Certified Star Schema modeling & sub-second query speeds • Advanced DAX: Financial KPIs, cohorts, & analytics • Automated Power Query pipelines (zero manual tasks) • 100% unrestricted .PBIX file ownership Message me directly to discuss your project requirements!... Plus d’infos

Compétences

a
anzohferate13
Xavier Ferate
hors ligne • 

Voir mes services

Tableaux de bord des données
I will create an interactive power bi dashboard and kpi reports
De15 $US / projetPlus de détails
Analyse BI
I will fix dax formulas and optimize your power bi model
De20 $US / projetPlus de détails

Expérience professionnelle

Chubb

Senior Data Analyst and Power BI Specialist

Chubb • Temps plein

Jan 2021 - Mar 2026 • 5 yrs 2 mos

Engineered automated Power BI reporting environments and semantic data models for commercial insurance and risk underwriting portfolios at Chubb. Developed advanced DAX metrics and automated ETL pipelines connecting multi-source databases to optimize claims analysis, portfolio profitability, and executive KPI visibility. Key achievements: • Built relational Star Schema models that unified policy, premium, and claims transaction tables into unified reporting layers. • Designed automated executive dashboards tracking combined ratios, loss severity, and renewal retention rates. • Replaced legacy manual reporting processes with self-service automated Power BI models, saving 25+ hours per financial close cycle.

Zurich_Insurance Group

Lead BI Architect and Senior Data Analyst

Zurich Insurance Group • Temps plein

May 2015 - Aug 2020 • 5 yrs 3 mos

Led enterprise Business Intelligence architecture and automated reporting pipelines for multi-million dollar insurance and underwriting portfolios at Zurich. Engineered high-performance Power BI models and advanced DAX formulations to track loss ratios, claims severity, combined ratios, and risk solvency indicators across large-scale data environments. Key contributions: • Architected normalized Star Schema data models connecting SQL databases and core insurance systems, cutting executive closing cycles by 80%. • Programmed complex DAX measures for dynamic time-intelligence, underwriting performance, and financial reconciliation. • Enforced robust data governance and sub-second VertiPaq query optimization for senior management and risk committee reviews.