Data • Analytics • Leadership
Deniz Alp Özalp
Senior Manager – Data & Analytics
DWH/BI Consultant • İstanbul, Türkiye
With over 7 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 7 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
Enterprise Projects
Data warehouse, migration and BI consultancy projects
Türk Telekom Mobile & Broadband Data Warehouse
DWH ProjectAs Senior Manager on Türk Telekom Mobile and Broadband Data Warehouse projects, I am responsible for the end-to-end management of DWH operations, development activities, and transformation initiatives
Boubyan Bank – Data Warehouse Migration
DWH Migration ProjectAs part of Boubyan Bank Data Transformation Program, I contributed to the modernization of the existing Sybase IQ-based data warehouse and distributed physical data mart landscape into a Cloudera Hado
Ziraat Teknoloji – Cognos Reporting Processes
BI/Reporting ConsultancyI 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
Ulusal Faktoring - Data Warehouse Project
DWH ProjectDesigned and implemented a new MSSQL-based data warehouse for Ulusal Faktoring, fed by Oracle source systems. I was responsible for preparing the Dev and Prod SSIS/MSSQL environments, setting up the r
Tools & Applications
In-house tools and applications I built
Oracle-to-ANSI SQL Converter
Application DevelopmentLiveA 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 – ODI SQL-to-Mapping Converter
Application DevelopmentEaseDataPlay is an ETL automation tool we developed with the ODI SDK. It
ODI+ Deployment & Versioning Tool
Application DevelopmentA 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.
ODI Mapping Generator
Application DevelopmentODI Mapping Generator is a Spring Boot application I developed to create as-is extraction mappings in a standardized and repeatable way. Instead of building mappings manually in ODI Studio, users can
Open Source
Open source projects shared with the community
oxtract
Open Source / Developer Tooloxtract is a command-line tool I wrote in Go to replace slow JDBC-based export utilities. It connects directly to Oracle via OCI using the godror driver, eliminating the Java/JDBC overhead and allowin
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