Data • Analytics • Leadership
Deniz Alp Özalp
Senior Manager – Data & Analytics
DWH/BI Consultant • İstanbul, Türkiye
With over 5 years of experience across telecommunications, banking and finance sectors, I lead end-to-end data warehouse projects from architecture to delivery. I actively take on both technical leadership and strategic management roles. Committed to continuous growth, I closely follow industry innovations and guide my team accordingly.
About Me
About
With over 5 years of experience across telecommunications, banking and finance sectors, I lead end-to-end data warehouse projects from architecture to delivery. I actively take on both technical leadership and strategic management roles. Committed to continuous growth, I closely follow industry innovations and guide my team accordingly.
What I Work With
Technical Skills
Data Integration & ETL
Databases
Big Data & Analytics
BI & Reporting
Programming
Data Modelling
Infrastructure & DevOps
Leadership
What I've Built
Projects
Türk Telekom Mobile & Broadband Data Warehouse
As Senior Manager I led Türk Telekom's mobile and broadband data warehouse projects
Boubyan Bank – Data Warehouse Migration
In Kuwait, we migrated Boubyan Bank's Sybase data warehouse to a Cloudera Hadoop
Ziraat Teknoloji – Cognos Reporting Processes
I provided consultancy for the operational processes of the Cognos reporting system serving the bank's business units. I advised on an application that automated manual dev→uat→prod report migrations
Oracle-to-ANSI SQL Converter
LiveA web application that automatically converts Oracle-specific SQL syntax (outer join operators, DECODE, ROWNUM, etc.) into ANSI-standard SQL. Designed for use during data warehouse migration projects to accelerate legacy query modernisation.
EaseDataPlay – ETL Automation Tool
EaseDataPlay leverages the ODI SDK to automatically convert insert-select and
ODI+ Deployment & Versioning Tool
In ProductionA deployment and versioning automation platform for ODI environments. Manages full Dev→UAT→Prod pipeline with version-controlled ODI object promotion, native integration with Bitbucket, GitHub, and GitLab, and a configurable rules engine for deployment quality gates.
Ulusal Faktoring – Data Warehouse Project
Designed and implemented a MSSQL-based data warehouse fed from Oracle source
Career
Experience
Senior Manager
@ MindtechTürk Telekom — Mobile & Broadband DWH
- End-to-end management of Mobile & Broadband DWH — 900+ TB data, 5,000+ daily ETL jobs, 2,000+ active users.
- Led ODI migration to new server environment using EaseDataPlay automation.
- Scaled the team from 5 to 22 engineers across delivery, QA, and operations.
- Resolved 1,000+ production defects; achieved 30%+ improvement in ETL completion time.
Senior DWH/BI Consultant
@ MindtechUlusal Faktoring · Ziraat Teknoloji · Boubyan Bank
- Ulusal Faktoring: Built a greenfield DWH on MSSQL — data modelling, SSIS ETL pipelines, reporting layer.
- Ziraat Teknoloji: Cognos reporting consultancy — report development, performance tuning, user training.
- Boubyan Bank: Migrated Sybase DWH to Cloudera Hadoop; built Enterprise DWH on MSSQL (Inmon 3NF) with Informatica.
- EaseDataPlay: Co-developed the in-house ETL automation platform (ODI SDK, Java, Vue.js).
Data Engineer
@ STY AUTO- Built MSSQL-based data models and ETL pipelines for automotive maintenance kit assembly optimisation.
- Developed Python automation scripts for data processing and reporting.
MSSQL Admin / Developer
@ FreelanceOnline gaming platforms
- MSSQL database design, performance tuning, replication, and query optimisation for online gaming platforms.
Knowledge Transfer
Training & Mentoring
Advanced MSSQL Training
2022Turkcell
Delivered Advanced MSSQL training to a group of 30 professionals at Turkcell. Topics covered included query optimisation, advanced T-SQL, index management, and performance tuning. Achieved a 100% satisfaction rate in post-training surveys.
Academic Background
Education & Certifications
M.Sc. Management Information Systems
Istanbul University
B.Sc. Education Faculty
Istanbul Aydın University
Certificates
BilgeAdam Academy — SQL Server Querying and Development
Get In Touch
Contact
I am always open to new projects, collaborations, or career opportunities.