Hi, I’m

Adrián Gallardo

Data Analyst & Business Intelligence

I turn data into business decisions: Power BI dashboards, ETL with Power Query and SQL, and reporting for decision-making. Backed by a foundation in management control.

📍 Alicante, Spain · Open to new opportunities

Adrián Gallardo Muñoz

Data Analytics & Business Intelligence

My speciality: turning data into decisions. Dashboards, ETL and modelling with Power Query so the business decides on evidence, not intuition.

  • Interactive dashboards and data storytelling in Power BI
  • ETL and data modelling with Power Query and SQL
  • KPI reporting and dashboards for decision-making
  • Advanced Excel: pivot tables and data cleaning
  • Process and data-flow automation (Power Query, n8n)
  • Statistical analysis in R and first hands-on Machine Learning (thesis)
Power BIAdvanced ExcelPower QuerySQLPostgreSQLRMetabaseETLn8nAI (Claude)

Experience

Financial Controller

Grupo Vectalia · Feb 2026 — May 2026 · Alicante · Maternity-leave cover

  • Group budget consolidation: validated budgets against historical data and closely monitored variances.
  • Profitability analysis by business unit: financial ratios, operating margins and P&L insights.
  • Reviewed economic-financial feasibility studies supporting public-tender bids.
  • Executive reporting of financial KPIs to General Management for strategic decision-making.
Power BISAP BIERPExcel

Commercial & Industrial Controller

Vacavaliente EU · Jul 2025 — Dec 2025 · Elche

  • Automated administrative, commercial, logistics and financial processes.
  • Led the internal rollout of the Odoo ERP: bulk data migrations and end-user training.
  • Analysed business KPIs (sales, margins, promotions, ROI) and tracked budget-vs-actual variances.
  • Supported budgeting, forecasting and monthly closing; evaluated commercial investments and campaigns.
OdooGoogle SheetsExcelPower BI

Business Intelligence

Finetwork · May 2025 — Jun 2025 · Elda

  • Optimised SQL queries on PostgreSQL and structured data for reporting.
  • Built and administered Metabase reports and dashboards: activity, quality and processes.
  • Supported and trained business users on reporting tools.
PostgreSQLSQLMetabase

Banking Back-Office Specialist

NTT Data · Dec 2023 — Nov 2024 · Alicante

  • Settlement, reconciliation and closing control of Exchange-Traded Derivatives (ETDs) in domestic and international markets.
  • Daily, weekly and monthly reporting of activity data with advanced Excel and pivot tables.
  • Knowledge of the financial product and of the operations of a Tier 1 banking entity.
Advanced ExcelPivot tablesFinancial reporting

Sales Specialist

Leroy Merlin Spain · May 2022 — Sept 2022

  • Administrative and commercial management, sales analysis and stock-out detection — the experience that inspired my Bachelor’s thesis on data analysis for the company.
Excel

Projects

Real cases told the way they should be: a business problem, an analysis and a result. Grouped by type so you can quickly find what you’re looking for.

Academic projects

My end-to-end academic data-analysis work.

Master’s Thesis — End-to-End BI System for Altadis

Master’s Thesis — End-to-End BI System for Altadis

From data to decision: ETL in R, PostgreSQL Data Warehouse (star schema) and executive Power BI dashboards with clustering and predictive models. Grade: 8.5/10.

RPostgreSQLPower BIMachine Learning
View project
Bachelor’s Thesis — Leroy Merlin

Bachelor’s Thesis — Leroy Merlin

Sales and product-review analysis with R: logistic regression and text mining to reduce negative reviews versus the competition. Grade: 8/10.

RExcelStatistics
View project

AI & Automation

Real solutions in production with AI, n8n and integrations.

CTSA Field OS — Food-safety app

CTSA Field OS — Food-safety app

Real client application for CTSA Alimentaria (client project, JAKS brand): digitalises HACCP inspections, sampling, chlorine control and REVET with digital signature, automatic PDF and email delivery.

Next.jsSupabasen8nAI
View project
AI Voice Agent — Appointment booking

AI Voice Agent — Appointment booking

AI voice agent (Vapi + n8n) that answers a dental clinic’s phone and books appointments automatically: it understands the patient, checks the calendar and reserves the free slot. Real demo on AV Dental.

AIVapin8nAutomation
View project ↗
JAKS — Automation for SMEs

JAKS — Automation for SMEs

My automation and digital solutions brand: AI chatbots on WhatsApp, automated workflows, integrations and dashboards so businesses can scale without extra working hours.

AutomationAIn8n
View project ↗

Business Intelligence · Power BI

Segmentation, dashboards and data automation.

AV Dental Clinic — Customer segmentation in Power BI

AV Dental Clinic — Customer segmentation in Power BI

Customer segmentation to target marketing campaigns: identifying the target audience (women interested in aesthetic treatments during autumn and winter) from the patient history.

Power BIRExcel
View project
Dashboards & automations

Dashboards & automations

HR dashboard, database automation with Power Query and a world population & life expectancy analysis.

Power BIPower Query
View project

Certification

Verifiable SQL fundamentals, with the queries published on GitHub.

SQL Certification — NetflixDB exercises

SQL Certification — NetflixDB exercises

SQL certification (Udemy) and solved exercises on NetflixDB: JOINs, aggregations and subqueries, each with its query and explanation.

SQLSubqueriesJOIN
View project

Other projects · Web development

Web design and development.

AV Dental Clinic website

AV Dental Clinic website

Design and development of the clinic’s real website: responsive, WhatsApp and Google Maps integration, SEO and GDPR compliance.

Web developmentSEO
View project ↗

Education

Master’s Degree in Business Intelligence

UNIR · 2024 — 2025 · Official degree

Thesis: "From Data to Decision — an End-to-End BI System for Altadis".

Bachelor’s Degree in Business Administration and Management

University of Alicante

Thesis: sales and review analysis for Leroy Merlin with R (grade: 8/10).

English B1 (Cambridge)

Currently preparing B2

About Me

Adrián Gallardo

♟ Passionate about data and strategy.

My career bridges two worlds: financial management (budgets, profitability, reporting) and data analytics (BI, ETL, Machine Learning). That dual perspective means I don’t just build the dashboard — I understand what it means for the P&L.

I’m an Arena FIDE Master (AFM) of the International Chess Federation. Chess taught me to think in a structured way, anticipate scenarios and decide based on patterns — exactly what I apply to data every day.

I’m always learning: automation with n8n, improving my English towards B2, and anything that makes a process more efficient than it was yesterday.

Let’s talk

If you’re looking for someone who combines financial strategy, analytics and data-driven decision-making, get in touch.