Projects.

Production work at LC Waikiki, from the first SQL Server data warehouse to Google Cloud and GenAI. For each project: the problem, the approach and the result.

All projects

Status is written out on every row; the marks are only there for quick scanning.

Status
ActiveCompletedArchivedFeatured

  1. 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.

    • Data platform
    • Data quality
    • Analytics-ready data
    • Orchestration
    • Cloud

    Role

    Design and lead · Senior Data Engineering & Data Architecture Group Manager

  2. 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.

    • Analytics-ready data
    • Decision support
    • Data quality
    • Data observability
    • Cloud

    Role

    Program lead · Data Solution Architect

  3. P—03

    Active

    Featured

    Contract-Driven Data Platform with GenAI-Assisted Onboarding

    New data sources join through validated YAML contracts; LLM agents work at design time only, so production runs stay deterministic.

    • Data contracts
    • GenAI
    • LLM evaluation data
    • AI-ready data
    • Data governance
    • Data pipelines

    Role

    Architecture and hands-on development · Data Solution Architect

  4. P—04

    Completed

    Fashion Retail Competitive Intelligence & GenAI Trend Platform

    Competitor price, stock and colour data for 20+ brands in ~95 markets, normalized with LLMs: pricing and assortment decisions from 1 week to 1 day.

    • GenAI
    • AI-ready data
    • Decision support
    • Data platform
    • Cloud

    Role

    Design and build · Data Solution Architect

  5. P—05

    Completed

    Dataflow Development with Apache Beam (Java)

    A real-time Pub/Sub to BigQuery pipeline via the Storage Write API, and a bulk BigQuery to SQL Server pipeline with initial-load and append modes.

    • Data pipelines
    • Data platform
    • Cloud

    Role

    Pipeline development · Data Solution Architect

  6. 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.

    • Decision support
    • Analytics-ready data
    • Data platform
    • Cloud

    Role

    Migration · Senior Data Engineering & Data Architecture Group Manager

  7. 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.

    • Data pipelines
    • Orchestration
    • Data platform
    • Analytics-ready data

    Role

    Program lead · Big Data Management & Data Architecture Manager

  8. P—08

    Completed

    Data Governance, Metadata Management and MDM

    Data governance, metadata management and master data management (MDM) across 100+ source systems, with data catalog and lineage tooling.

    • Data governance
    • Data lineage
    • Data quality

    Role

    Implementation · Big Data Management & Data Architecture Manager

  9. 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.

    • Data platform
    • Data pipelines
    • Analytics-ready data
    • AI-ready data

    Role

    Built the team and platform · Data Engineering Team Lead

  10. 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.

    • Data platform
    • Analytics-ready data
    • Data pipelines

    Role

    Redesign and high availability · Data Architect

  11. 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.

    • Decision support
    • Analytics-ready data
    • Data platform

    Role

    Cluster design · Senior Business Intelligence Developer

  12. 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.

    • Decision support
    • Analytics-ready data

    Role

    Built the semantic layer · Senior Business Intelligence Developer

  13. P—13

    Completed

    SSIS Framework for ETL Pipelines

    Metadata-driven SSIS ETL framework with dependency tracking, error handling, restartability and automated alerts, adopted by 80+ pipelines.

    • Data pipelines
    • Orchestration
    • Data observability
    • Data quality

    Role

    Framework development · Senior Business Intelligence Developer

  14. 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.

    • Analytics-ready data
    • Decision support
    • Data platform

    Role

    Design · Senior Business Intelligence Developer

If this sounds like your problem, write to me.