Ayhan Demirci

• dbt modeling on Microsoft Fabric (main day-to-day work): medallion lakehouse on Delta Lake, dimensional models, dbt + Soda tests in CI/CD • Application owner of Hightouch (reverse ETL): built the platform from scratch, syncs to Facebook Ads and Adobe Campaign • Contributed to the Synapse-to-Fabric migration: ported Synapse pipelines to dbt models, re-modeled a legacy Data Vault warehouse into medallion on OneLake • PySpark notebooks in Fabric; CI/CD on Azure DevOps; infrastructure as code with Terraform • Fabric operations: monitoring, incident fixing, capacity (CU) cost tracking and optimization

• Production monitoring & incident handling: daily and nightly job runs ($Universe scheduling); killed hung jobs on the Linux servers, fixed root causes and relaunched flows — customer files had hard delivery deadlines • SQL / PL-SQL performance tuning: execution plans, indexing, partitioning to shorten load windows • Data reconciliation between source systems and the warehouse; investigated discrepancies reported by clients • Reruns and backfills of historical data after upstream corrections, without disrupting the daily batch • Reporting with SAP BusinessObjects and Power BI (transaction and financial reports) • Managed an offshore development team; 2nd/3rd line support (ISMP, JIRA) Key project: redesigned the full ETL flow for a source-database migration (mappings, tables, indexes, views, output files, reports, testing) — no production incidents at cutover.