Data Analyst · BI · Operations Analytics

Facundo Zayas

3+ years turning complex operational data into KPI dashboards and strategic decisions — aviation scheduling, people analytics, and ops tooling.

Berlin · open to work
SQL · Power BI · DAX
EN · ES · PT
IT Salary Analysis SQL
10 strategic business questions answered on a global IT salary dataset — remote vs in-office pay gaps, salary evolution by year, and top-paying role/experience/location combinations. Uses window functions and outlier filtering for reliable insights.
SQL MySQL Data Analysis Salary Benchmarking
2025
HR Headcount & People Analytics Power BI
4-page Power BI dashboard for HR stakeholders — headcount evolution 2016–2019, turnover drivers, salary quartile analysis, gender equity, and manager span of control. Built with Power Query, DAX measures, and a custom calendar dimension.
Power BI DAX Power Query People Analytics
2025
4Padel Berlin — Inventory System AI-Assisted Build
Identified an operational gap at a real padel club — no shift-to-shift stock visibility, reactive restocking, no accountability trail. Designed and shipped a full solution using AI-assisted development: defined requirements, iterated via prompting, and deployed a working web app connected to Google Sheets as live backend. Used by 9 staff daily — eliminated stockout events that previously occurred up to 5 days/month.
AI-Assisted Development Prompt Engineering Google Sheets API Operations
2025
E-commerce Orders Analysis SQL Power BI
End-to-end analysis of an e-commerce orders dataset — customer retention, cohort analysis, RFM segmentation, and Pareto revenue concentration. Built with window functions, CTEs, and a Power BI dashboard.
SQL Power BI Cohort Analysis RFM
2025
Operations & Sales Analyst
4Padel Berlin
Berlin, Germany
Apr 2025 – Present
  • Designed and deployed an inventory system (Google Sheets + AppSheet + Apps Script) tracking 25–30 SKUs in real time with automated low-stock alerts — eliminating stockout events that previously occurred up to 5 days/month.
  • Developing a demand forecasting model to project monthly court booking volumes and estimate revenue using seasonal trend analysis.
Airline Scheduling Analyst
Aerolíneas Argentinas
Buenos Aires, Argentina
Aug 2022 – Apr 2025
  • Planned and optimized annual flight schedules for a 52-aircraft narrow-body fleet (~300 daily flights), achieving 5% YoY improvement in fleet utilization across Operations, Maintenance, Commercial, and Airport teams.
  • Built a 5-minute interval slot utilization model for Buenos Aires Aeroparque — reduced hub peak slot requirements from 34 to 30 (-12%).
  • Optimized departure windows on high-demand routes, enabling +20% average fares and 95% load factor on Bariloche routes during the 2024 peak season.
  • Built executive Power BI dashboards (utilization, OTP, seat distribution, manpower) and maintained SQL/Power Query pipelines supporting daily and strategic decisions across Operations and Commercial.
Process Improvement Analyst
Aerolíneas Argentinas
Buenos Aires, Argentina
Sep 2021 – Aug 2022
  • Market and route performance analysis across 6 regional countries using DDS and OAG datasets (+1M records), identifying demand trends for network strategy decisions.
  • Analyzed demand, competition, and scheduling feasibility for the Buenos Aires–Rome route relaunch and capacity expansions on São Paulo (+50%) and Santiago (+40%).
  • Mapped end-to-end schedule publication workflow, identified handoff bottlenecks, and implemented changes that reduced cross-team errors from 12% to 5%.
BI & Data
  • SQL · MySQL
  • Power BI
  • DAX
  • Power Query
  • ETL pipelines
Tools
  • Excel (advanced)
  • Google Sheets
  • Apps Script
  • AppSheet
  • Python (learning)
Domain
  • KPI Design
  • Data Modeling
  • Fleet Scheduling
  • Process Improvement
  • Operations Research
Languages
  • Spanish (native)
  • English (C1)
  • Portuguese (B1)
  • German (A2)