Amaan khan

• Developed an aggregated design for frequenty used complex measures, ensuring query performance and data
accuracy in semantic models.
• Resolved the query limit issues and reduced the load times for complex queries from 4 minutes to under 30 seconds
in direct lake semantic models.
• End-to-end handling of huge data from source to destination through various ETL (Extract, Transform, Load)
processes in fabric, ensuring 99.9% data accuracy.

• Cut complex Direct Lake semantic model query times from 4 minutes to under 30 seconds (8x faster),
eliminating query-limit failures and enabling near-instant dashboard access for business users.
• Re-architected aggregation designs for high-usage semantic measures, sustaining data accuracy while
raising query throughput for enterprise-scale Power BI workloads.
• Engineered distributed, large-scale ETL orchestration in Azure Data Factory, improving pipeline scalability
and reliability across enterprise data processing.

• Led the end-to-end migration from Azure Synapse to Microsoft Fabric (pipelines, Spark notebooks,
datasets, semantic models), modernizing the analytics platform with no disruption to downstream
reporting.
• Re-engineered ETL across Bronze, Silver, and Gold medallion layers, reducing processing time by 40% and
operational costs by 25%.
• Built 10+ interactive Power BI reports that cut manual reporting effort by 60% and expanded self-service
insight access for business stakeholders.
• Designed dimensional and tabular Analysis Services models enabling near real-time aggregation for
enterprise analytics.
• Deployed AI-powered conversational and workflow automation agents, boosting developer productivity
and accelerating data-driven decisions.
• Automated CI/CD with custom PowerShell tooling, cutting deployment time by 50% and improving
DevOps reliability.

• Led the migration from Azure Synapse to Microsoft Fabric, including conversion of data pipelines, spark notebooks,
datasets, and semantic models to Fabric-native components.
• Optimized ETL processes within the platform using Medallion Architecture, reducing data processing time by 40%
and cutting operational costs by 25%.
• Developed and maintained tabular models in Analysis Services, enabling near real-time aggregation and analysis.
• Developed 10+ interactive Power BI reports, empowering stakeholders with actionable insights and reducing
manual reporting efforts by 60%.
• Designed and deployed AI-powered automation solutions, including conversational and workflow automation AI
agents to improve developer productivity and data-driven decision-making.
• Designed CI/CD pipelines and developed custom PowerShell scripts, automating deployments and reducing
deployment time by 50%, improving DevOps efficiency.