Decisions.
Analytics platforms people can trust and afford: an 80 TB warehouse moved to BigQuery at 75% lower infrastructure cost, and GA4 metrics rebuilt in one Gold layer.
Three areas, one question: can we trust this data enough to decide?
Projects
Production work on this topic.
P—01
Completed
Featured
Enterprise Data Warehouse Migration to Google BigQuery
80 TB warehouse moved from SQL Server and a 15-node Cloudera cluster to BigQuery: $550K annual savings, 75% lower infrastructure cost, 7x faster workflows.
Role
Design and lead · Senior Data Engineering & Data Architecture Group Manager
P—02
Completed
Featured
GA4 Analytics Modernization: Gold Layer, Streaming and Anomaly Detection
GA4 analytics rebuilt on BigQuery with a Gold e-commerce model and drift checks: monthly cost $9K to $3K, heaviest queries 46 minutes to 8 seconds.
Role
Program lead · Data Solution Architect
P—06
Completed
Azure Reporting Platform for 1,200+ Business Users
Reporting platform for 1,200+ business users migrated to Azure Data Factory, Synapse, Analysis Services and Power BI; 2nd place, IDC Turkey Awards.
Role
Migration · Senior Data Engineering & Data Architecture Group Manager
P—11
Completed
OLAP Scaleout: Load-Balanced Multidimensional Cube Cluster
F5 load-balanced OLAP cluster for multidimensional cubes with 24/7 high availability: sub-second average response for 4,800 users, zero downtime.
Role
Cluster design · Senior Business Intelligence Developer
P—12
Completed
MS Multidimensional OLAP Cubes and the First Semantic Layer
LC Waikiki's first semantic layer and multidimensional OLAP cubes, giving business units centralized access to analytics.
Role
Built the semantic layer · Senior Business Intelligence Developer
P—14
Completed
Turkey's First Microsoft FastTrack Data Warehouse
Turkey's first Microsoft FastTrack data warehouse, built with Kimball dimensional modeling and star schemas; a Microsoft customer success story.
Role
Design · Senior Business Intelligence Developer
P—07
Completed
Cloudera Big Data ETL Offload Program
200+ high-load ETL processes rebuilt as ELT on Spark, Hive and Impala on a 15-node Cloudera cluster: about 12x faster on average, up to 30x.
Role
Program lead · Big Data Management & Data Architecture Manager
P—09
Completed
First Data Engineering Team, Hadoop Platform and Data Lake
The company's first data engineering team, a production 15-node Cloudera CDH cluster and a multi-source data lake feeding reporting and machine learning.
Role
Built the team and platform · Data Engineering Team Lead
P—10
Completed
Columnar Data Warehouse with SQL Server 2017
Enterprise data warehouse redesigned with columnstore indexes and Always On high availability on SQL Server 2017: up to 18x faster performance.
Role
Redesign and high availability · Data Architect
Architecture katas
Design studies, not delivered systems. Their figures are design assumptions.
K—05
Real-Time Fraud Decisioning for Instant Payments
Score every instant payment for fraud in 150 ms, keep each decision reproducible for seven years, touch the mainframe only through MQ.
Sector
Banking
K—06
BSS Modernisation and Real-Time Customer 360
Build a Customer 360 from change events of 14 systems without touching the mainframe, then retire billing by cohort over five years.
Sector
Telecommunications
K—07
Unified Marketing Intelligence on Google Cloud
One certified metric layer over a GA4 stream, four batch sources and the warehouse, so dashboards, an LLM and agents quote one number.
Sector
E-commerce marketing
K—08
Competitor Price and Markdown Intelligence Platform
Collect competitor pages within legal limits, match them to 120,000 SKUs with measured precision, advise on markdown timing with evidence.
Sector
Retail pricing
Publications
Articles and talks on this topic.
Working on something like this?