David Morgan-Gumm
Selected Work

Projects & Initiatives.

A showcase of major architectural implementations, platform migrations, and community contributions.

Community Project

sql_squared

Founded and manage a thriving data community. We host podcasts, publish technical articles, and organize regular events to foster knowledge sharing and networking among data professionals.

Website Blog Podcast YouTube
sql_squared brand abstract
Personal Project

Plastic Crack

Warhammer Collection Management App

The ultimate tool for Warhammer enthusiasts. Track your miniatures with AI-powered photo recognition, get personalised painting guidance, discover real-time market pricing and deals, and connect with a community of fellow hobbyists. Currently in closed beta.

Visit Site Join Beta

Smart Collection Tracking

AI-powered photo recognition and detailed progress tracking.

AI Painting Guidance

Personalised colour schemes and techniques based on your models and skill level.

Market Intelligence

Real-time pricing, deal alerts, and collection value tracking from multiple retailers.

Community Features

Share your work, get feedback, and connect with fellow Warhammer enthusiasts.

Microsoft Fabric Enterprise Implementation

Led the strategic implementation and migration to Microsoft Fabric for an enterprise organization. Consolidated disparate data workloads into a unified SaaS analytics platform, enabling seamless data engineering, data science, and real-time analytics capabilities.

Stack
Microsoft FabricOneLakeData EngineeringPower BISynapse Data WarehousingData ScienceSpark
Impact
  • •Unified analytics platform
  • •Reduced infrastructure complexity
  • •Accelerated time-to-insight
Enterprise Master Data Management with Tamr & Microsoft Fabric

Designed and implemented an enterprise Master Data Management solution using Tamr on top of Microsoft Fabric, enabling AI-powered entity resolution and deduplication of critical business data. Built automated pipelines to master golden records across key business domains and publish authoritative data to downstream third-party services and applications via event-driven and API-based integrations.

Stack
TamrMicrosoft FabricOneLakeAzure Data FactoryREST APIsPythonSQLEvent-driven ArchitectureData Governance
Impact
  • •Golden record mastering across key business domains
  • •Automated publishing to 3rd party services & applications
  • •Improved data consistency and reduced duplication across the platform
Global Azure Synapse Platform Architecture & Delivery

Architected and delivered a comprehensive Azure data platform serving 1000+ users across 12+ countries. The platform processes large daily data volumes with a high degree of data quality improvement and major performance optimization. Features real-time analytics, automated data validation, and enterprise-grade security.

Stack
Azure Synapse AnalyticsAzure Data Lake Storage Gen2Azure Data FactoryAzure Logic AppsPower BI PremiumAzure SQL DatabasePythonKQLAzure DevOps
Impact
  • •Performance improvement
  • •£100k+ annual cost savings
  • •1500+ global users
LinkedIn Job Market Analytics & Whitespace Reporting

Built an enterprise-grade data warehousing solution ingesting and analysing daily global LinkedIn job market data using Azure Data Explorer. Integrated Azure Language and Cognitive Services to automatically extract, normalise, and map skills and industries from job postings, enabling accurate whitespace reporting that highlights unmet talent demand and emerging hiring trends for business intelligence teams.

Stack
Azure Data Explorer (Kusto)Kusto Query Language (KQL)Azure Language ServicesAzure Cognitive ServicesAzure FunctionsPower BIPythonREST APIs
Impact
  • •Daily job market data ingestion & processing
  • •AI-powered skills & industry mapping via Azure Cognitive Services
  • •Whitespace reporting to surface unmet talent demand
Global Telephony Platform Integration Suite

Developed comprehensive real-time integrations with multiple global telephony platforms using event-driven architecture. Built scalable ETL pipelines processing call data for in-depth analysis, global reporting, and business intelligence across international markets.

Stack
REST APIsAzure FunctionsAzure SQL DatabasePower BIEvent-driven ArchitectureC#Python
Impact
  • •Multi-platform integration
  • •Real-time call analytics
  • •Global reporting capabilities
SAP ByDesign ERP Integration Platform

Engineered robust, enterprise-scale data integration pipelines connecting SAP ByDesign ERP system with downstream financial reporting and forecasting tools. Implemented automated data validation, error handling, and reconciliation processes ensuring 99.9% data accuracy.

Stack
SAP ByDesign APIsAzure Function AppsMicrosoft FabricFinancial Reporting ToolsSOAPPythonETL PipelinesData Validation
Impact
  • •99.9% data accuracy
  • •Automated reconciliation
  • •Enterprise-scale integration
Salesforce Data Lake & Analytics Platform

Implemented a comprehensive batch and real-time ETL solution for ingesting Salesforce sales data into Azure Data Lake. Built dimensional data models, implemented data governance frameworks, and created self-service analytics capabilities for business users.

Stack
Azure Data FactorySalesforce APIsSOQLAzure Data Lake StorageAzure SynapsePower BIPythonSQL
Impact
  • •Self-service analytics
  • •Data governance framework
  • •Real-time sales insights
Enterprise Database DevOps & CI/CD Platform

Established comprehensive Database DevOps practices and implemented automated CI/CD pipelines for database changes across multiple environments. Reduced deployment risks by 90%, improved release velocity by 80%, and implemented automated testing frameworks.

Stack
Azure DevOpsCI/CD PipelinesSQL Server Data Tools (SSDT)GitPowerShellAzure SQL DatabaseAutomated Testing
Impact
  • •90% risk reduction
  • •80% faster deployments
  • •Automated testing framework