Real-Time Operational Performance Dashboard
Consolidated real-time data from 130+ machines into a single Power BI dashboard, improving stakeholder visibility by 25% — independently recognized as a company-wide best-practice example.
- Power BI
- SQL
- ETL
Senior Data Analyst
Ahmet Can Özdemir
Turning data into decisions — 3.5+ years designing dashboards, KPI frameworks, and automated reporting systems at Turkish Aerospace.
3.5+
Years in Data & Analytics
75+
Dashboards & Reports Shipped
3
Certifications
About
I'm an Industrial Engineering graduate (Hacettepe University, High Honor) who found his footing in data. Before graduating, I did a Work & Travel program in the US, followed by an Erasmus exchange in Logistics & Supply Chain Management at the University of Duisburg-Essen. I then joined Turkish Aerospace as a Data Analyst on the Digital Transformation team, building real-time data infrastructure — and for the past 3.5+ years since, I've stayed on that Data Analyst track, now as a Senior Data Analyst, designing dashboards, KPI frameworks, and automated reporting systems used across teams and leadership levels.
Outside of work, I lead from the front — three years on my university's diving club board (the last as chairman, now a certified SSI Dive Master), and more recently on the road, finishing my first marathon at 26. More on both further down.
I enjoy the moment where a messy dataset turns into a dashboard someone actually uses to make a decision — and I'm always looking for the next problem like that to solve.
Experience
Jul 2024 — Present
Senior Data Analyst, Turkish Aerospace
Partnered with cross-functional stakeholders to translate business needs into scalable data models and KPIs. Designed an automated performance-tracking dashboard (Power BI) that improved stakeholder visibility by 25% and was independently recognized as a “world-class” best-practice example by external assessors. Built resource-planning dashboards via automated ETL pipelines (+15% efficiency), ran root-cause analysis that cut a rising cost metric by 10%, and built dynamic inventory reports that reduced fulfillment delays by 20%.
Nov 2022 — Jul 2024
Data Analyst, Digital Transformation, Turkish Aerospace
Led the design of a real-time data-instrumentation architecture connecting 60% of operational touchpoints. Built real-time monitoring dashboards (Grafana, SQL, ETL), increasing operational efficiency by 30%. Designed an RFID-based asset-tracking system that reduced loss incidents by 20%.
Education
B.Sc. Industrial Engineering, Hacettepe University
GPA 3.54/4.0, High Honor. Erasmus+ exchange in Logistics & Supply Chain Management, University of Duisburg-Essen (Germany).
Certifications
McKinsey Forward · SSI Dive Master · English C1 (iTEP)
Continuous learning alongside full-time work, spanning business problem-solving, leadership under pressure, and language proficiency.
Skills
Analysis & BI
- SQL
- Python
- DAX
- Power BI
- Power Query
- Report Builder
- Grafana
- Tableau
Data & ETL
- MS SQL Server
- PostgreSQL
- BigQuery
- Stored Procedures
- Scheduled Jobs
- Node-RED
Cloud
- Azure Data Factory
- Azure SQL
- Snowflake
- AWS RDS
Analytics Methods
- Root-Cause Analysis
- A/B Testing
- Statistical Analysis
- Trend & Variance Analysis
- KPI Design
- Data Modeling
Other
- Docker
- Claude Code
- AI-Assisted Analytics Workflows
- Jira
Projects
RFID-Based Shelf-Life Material Tracking
Built a preventive asset-tracking system with RFID and Node-RED, cutting material loss incidents by 20% by moving tracking from reactive to proactive.
- Node-RED
- MQTT
- SQL
Root-Cause Analysis on a Rising Cost Metric
Used SQL-driven analysis to isolate the drivers behind a rising cost trend, enabling targeted process changes that delivered a 10% reduction.
- SQL
- Root-Cause Analysis
This Portfolio
Designed and built this site end-to-end with Next.js, deployed on Vercel.
- Next.js
- TypeScript
SSI Dive Master
Leading underwater, and in the room
Three years on the board of Hacettepe University's Underwater Sports Club, the last as chairman. I organized dive trips and club events, assisted instructors in training new divers, and mentored the next generation of board members. As an SSI Dive Master — the highest rating I've reached, with 100+ logged dives — I lead certified divers on guided dives: reading conditions, keeping a group calm, and making the call when it matters.
- 3 years on the board
- Chairman, final year
- 100+ dives logged
- SSI Dive Master
Marathon
3:30 — exactly on target
At the 2025 Istanbul Marathon, I set a goal — a 3:30 finish — and hit it exactly. Running is where I practice the same discipline I bring to a messy dataset: set a target, build a plan, and execute against it. Not a one-off — I train and race year-round, chasing the next number.
- 2025 Istanbul Marathon
- 3:30 finish — goal hit exactly
- Races year-round