Ajay Kumar Deekonda

I’m a Senior BI & Analytics Engineer with 12+ years delivering enterprise BI, analytics, reporting, and data warehousing solutions. I specialize in Power BI and Microsoft Fabric, building governed semantic models that turn business requirements into fast, reliable insights.

In my most recent role, I led analytics modernization at Novartis by migrating legacy SSRS reporting to Power BI while ensuring full GDPR compliance. I designed and optimized enterprise Power BI semantic models (Star Schema, advanced DAX, and performance tuning), cutting report query latency by 25% and improving dashboard performance and efficiency by 20%+.

I’ve successfully migrated 100+ SAP BusinessObjects (SAP BO) and SSRS reports to Power BI and Fabric, enabling self-service analytics for 500+ business users through governed datasets, Dataflows, and gateway architecture. I also built automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake—reducing reporting delivery timelines by 40% through workflow automation—and accelerated analytics modernization using Fabric Lakehouse patterns, OneLake integration, and centralized platform development.

Earlier, I delivered measurable value across client environments by engineering highly optimized DAX measures, integrating 45+ data sources via Power Query, improving data quality, and orchestrating enterprise ETL with Informatica. I bring a strong governance and operations mindset—using Agile Scrum, CI/CD, and access controls like Row Level Security—to help teams adopt analytics confidently.