Andy K

Data Architect and BI Platform Lead with 15+ years designing, governing and optimizing enterprise analytics platforms on Microsoft Fabric, Power BI Premium, Azure and Databricks.

Power BI / Fabric Platform Lead, Architect & Admin - Estée Lauder Companies

(2017-04)

Award: Recognized for architecting a unified data platform on Microsoft Fabric for a global retail business. It cut data redundancy by 40% through OneLake Shortcuts and improved report performance by 60% using Direct Lake.

• Architected end-to-end analytics solutions on Microsoft Fabric (OneLake, Lakehouse, Data Factory, Direct Lake) aligned to the enterprise data strategy.
• Designed integration patterns for SAP ERP (ECC/S/4HANA), SAP HANA and SAP BW: extraction to the Lakehouse, SAP connectors through the gateway, and semantic models for finance, supply chain and sales reporting.
• Delivered Azure Databricks solutions using Delta tables, Unity Catalog and SQL Warehouses, choosing Import, DirectQuery or Direct Lake per workload.
• Built solutions on Azure SQL Database and Oracle, including Oracle client configuration on gateways, query folding and source-side views to push transformations upstream.
• Built and scaled Power BI Report Server from proof of concept to production, migrating on-prem SSRS reports to PBIRS with minimal user impact.
• Defined the Power BI Premium to Fabric migration strategy and executed the capacity and workspace migration.
• Set modeling standards (star schema, composite models, aggregations, incremental refresh) and reusable semantic layers.
• Established the Fabric/Power BI governance framework: tenant settings, workspace naming and ownership standards, and capacity assignment rules.
• Implemented semantic model endorsement (Promoted/Certified) so users rely on a single trusted version of key metrics.
• Applied Microsoft Purview sensitivity labels, lineage and data classification; enforced RLS, OLS and least-privilege workspace roles through Entra ID security groups.
• Monitored audit and activity logs for compliance, and partnered with IT security and data governance teams on policy enforcement.
• Set up service principals and Power Automate flows for secure, governed report scheduling outside Power BI.
• Tuned slow-running SQL queries against Databricks, Azure SQL, Oracle and SQL Server using execution plans, indexing, partition pruning and query folding to reduce refresh and report load times.
• Diagnosed slow reports end to end with DAX Studio server timings, Performance Analyzer, Power Query diagnostics, gateway logs and the Capacity Metrics app to isolate bottlenecks at the source, gateway, model or visual layer.
• Optimized semantic models and DAX measures with Tabular Editor, Bravo and VertiPaq Analyzer, reducing model size and query duration.
• Made on-premises data gateway configuration changes for performance gains: clustering and load balancing, spooling to SSD, mashup container memory and concurrency tuning, and version upgrades across non-prod and prod. These shortened refresh durations and reduced refresh failures.
• Took proactive steps on capacity health: Capacity Metrics app reviews, utilization and throttling alerts, off-peak refresh scheduling, background job smoothing, and autoscale. These prevented throttling during peak business periods.
• Deployed and customized FUAM (Fabric Unified Admin Monitoring) to centralize activity, inventory, capacity and refresh data in a Lakehouse for tenant-wide visibility.
• Built an end-to-end stale-object cleanup solution. It uses Admin/Scanner REST APIs and activity logs to find unused workspaces, reports and semantic models, notifies owners through Power Automate, and archives then deletes after approval. This reduced tenant clutter and freed capacity.
• Automated admin tasks (user provisioning, workspace audits, refresh monitoring) with PowerShell and Power BI/Fabric REST APIs.
• Developed an executive leadership dashboard showing platform adoption, active users, capacity utilization, refresh success rates and top content, used by senior leadership for platform investment decisions.
• Led cross-functional teams of BI developers, data engineers and analysts; ran code reviews, workshops and mentoring on DAX, modeling and design.
• Implemented CI/CD with Azure DevOps/Git and deployment pipelines across Dev, UAT and Prod.
• Defined the Copilot strategy for reporting and the agent roadmap, and deployed Fabric data agents through API connectors.

Sr. Manager, Data & Analytics (SAP BusinessObjects / Power BI Admin) - MillerCoors

(2013-08 - 2017-03)

• Administered the SAP BusinessObjects platform and, from its 2015 launch, the Power BI service, including workspace setup and on-premises data gateway configuration.
• Oversaw deployment and configuration of reports and dashboards across the organization; analyzed usage metrics to improve the user experience.
• Controlled user access and permissions in line with security policy; onboarded and trained users.
• Ran regular performance tuning of reports, SSAS models and SQL queries with data engineering teams.
• Implemented data governance policies and documentation standards for BI processes.
• Integrated BI platforms with enterprise systems including SAP HANA and SQL Server.

Manager, BI Platforms (SAP BW, BusinessObjects, HANA, Microsoft BI) - EMC

(2010-04 - 2013-07)

• Managed SAP BW, BusinessObjects, SAP HANA and Microsoft BI (SSRS, SSAS, SSIS) platforms, including maintenance and change management.
• Consolidated legacy report servers onto SSRS; coordinated SQL Server upgrades and moved large reporting databases with minimal user impact.
• Built automated deployment for report artifacts using PowerShell and TFS, introducing version control and repeatable releases.
• Created performance tuning playbooks for SSRS, SSAS and SSIS; tuned T-SQL queries, indexes and views, and optimized MDX for complex tax hierarchies.
• Streamlined report request and approval workflows for business users.
• Trained 50+ analysts and tax application owners on SSRS usage, security and troubleshooting.

Assistant Project Manager / BI Developer & SQL DBA - Cognizant Technology Solutions

(2005-11 - 2010-03)

• Developed SSIS packages for tax data ETL with error handling and retry logic.
• Supported SSRS reports and authored MDX measures for SSAS models; assisted with capacity planning and backup/restore.
• Led an SSRS migration across multiple Windows Server and SQL Server versions with phased cutovers and automated rollbacks, completed within SLA with no data loss.
• Reduced average report load time by 40% through SQL indexing, SSAS processing optimization and report redesign.
• Automated role-based access provisioning for SSRS, cutting manual provisioning time by 70%.
• Designed an automated monitoring and alerting system that preempted capacity issues and prevented two major outages.

Master's / MBA - Information Technology

Bachelor's - Computer Applications

Post Graduate Diploma - Computers