Anil K.

Power Bi Sme & Lead Bi Developer @City of Fort Worth

Fort Worth, TX, US

Acted as a strategic liaison between business stakeholders and BI teams, gathering complex financial and operational requirements to deliver scalable, actionable Power BI solutions aligned with business goals.• Built and maintained enterprise-grade dashboards in Power BI by integrating data from SAP, Salesforce, RPM, and Databricks Delta Lake, enabling end-to-end visibility into customer spend and financial performance.• Designed an Intelligent Customer Alias Grouping solution using SQL, Power BI, and Power Apps, providing leadership with a unified customer view and reducing data redundancy by 45%.• Automated cross-platform data validation processes using Python and Power Query, improving data accuracy to 99% and accelerating business decision-making by reducing manual checks by 60%.• Developed and optimized Data Quality Insights dashboards to detect anomalies, null values, and mismatches across core financial systems, proactively supporting audit readiness and operational efficiency.• Embedded AI-driven forecasting and anomaly detection into Power BI dashboards using Microsoft Fabric, providing forward-looking financial insights and enhancing portfolio performance analytics.• Implemented end-to-end data governance frameworks using Microsoft Fabric and Azure Synapse, ensuring enterprise-wide data consistency, traceability, and access control.• Architected high-performance data models and streamlined ETL pipelines across Power BI, SSIS, and Synapse Analytics, reducing refresh times by 35% and supporting real-time insights at scale.• Defined reusable data modeling and MDM standards for enterprise reporting, aligning master data from SAP and cloud systems to deliver consistent and trusted analytics.• Drove a 30% increase in BI report adoption by delivering intuitive, user-focused dashboards that empowered non-technical stakeholders with self-service insights into customer and quote accuracy.