YouTubeVideo
Featured Video
One of the latest videos published on my YouTube channel.
Open on YouTube →
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
InformaticaODISSISAirflow
Databases
Oracle DBPL/SQLOracle ExadataMSSQLT-SQLPostgreSQL
Big Data & Analytics
Cloudera HadoopAzure Fabric
BI & Reporting
OBIEECognosPowerBIGrafana
Programming
PythonJava.NETJavaScriptReactVue
Data Modelling
ErwinPowerDesignerOracle Data Modeler
Infrastructure & DevOps
DockerWindows ServerLinuxVMWare ESXi
Leadership
Team Management (5→22)Project PlanningEnd-to-End Delivery
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
ODIInformaticaOracleEaseDataPlayPowerdesignerOBIEE
Zurich Sigorta – ODI Platform Setup & Architecture
Platform SetupAt Zurich Sigorta I was responsible end to end for building the data integration platform from scratch and designing its architecture. The Oracle Data Integrator environment, the infrastructure it run
ODIOracleWebLogicLinux
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
ErwinInformaticaSQL ServerHiveImpala
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
IBM CognosOraclePL/SQLPostman
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
MSSQLSSISSSDT
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.
JavaScript
EaseDataPlay – ODI SQL-to-Mapping Converter
Application DevelopmentEaseDataPlay is an ETL automation tool we developed with the ODI SDK. It
JavaVueODI SDKODI
ODI+ Deployment & Versioning Tool (OctoDeploy)
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.
JavaODI SDKReact
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
JavaSpring BootODI SDKODIReact
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
GoOracleParquetDocker
Watch & Explore
Videos
Videos and playlists I publish about data, analytics, and technology.
Career
Experience
2023 – Present
Senior Manager
@ MindtechTürk Telekom · Zurich Sigorta · Azure / Microsoft Fabric
- Türk Telekom: End-to-end delivery of Mobile & Broadband DWH — 900+ TB data, 5,000+ daily ETL jobs, 2,000+ active users.
- Scaled the team from 5 to 22 engineers; led ODI 11g→12c and Informatica→ODI migrations using the in-house EaseDataPlay platform.
- Achieved 30%+ improvement in Mobile DWH ETL completion time via Oracle Exadata tuning; resolved 1,000+ defects; delivered the Flexible Reporting project and legacy platform decommissioning.
- Zurich Sigorta: End-to-end ODI platform setup and architecture — repositories, Studio, standalone agent installation, topology design (data servers, physical/logical schemas, contexts) and connectivity; OPatch security remediation for Qualys compliance; stood up the Oracle ODS environment.
- Azure / Microsoft Fabric: Go-to contact for the Do&Co team; built an internal Fabric lab and delivered knowledge-transfer sessions.
ODIOracle ExadataOBIEEAzure Fabric
2021 – 2023
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).
MSSQLSSISInformaticaIBM CognosHive/ImpalaPower BI
2019 – 2021
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.
MSSQLPython
2017 – 2019
MSSQL Admin / Developer
@ FreelanceOnline gaming platforms
- MSSQL database design, performance tuning, replication, and query optimisation for online gaming platforms.
MSSQL
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.
30 Participants100% Satisfaction
Academic Background
Education & Certifications
2023
M.Sc. Management Information Systems
Istanbul University
2018
B.Sc. Education Faculty
Istanbul Aydın University
Certificates
BilgeAdam Academy — SQL Server Querying and Development