Amit Bendale

Analyst 1 - Business Intelligence @Graebel Companies, Inc.

Aurora, CO, US

Developed and enhanced SQL reports in SSMS using complex stored procedures, integrating them into Microsoft Fabric Server and Databricks for scalable data management.• Collaborated with Data Engineering team to troubleshoot and resolve critical issues in backend PySpark queries, ensuring accurate and reliable data availability in fact tables, thereby improving data integrity, enhanced report accuracy, and streamlined ETL process for more efficient BI reporting.• Automated performance KPI tracking dashboards using Power BI, reducing manual efforts by 30%. Collaborated directly with stakeholders to gather strategic requirements and improved the existing Client Dashboard in Power BI, leveraging complex DAX queries to create more insightful analytics.• Modified the existing data model by creating summary tables for frequently used measures for faster data retrieval, implemented RLS (Row Level Security) to reduce data load for specific users. Modified data source connections in Power Query, reducing data processing time by approx. 26%.• Designed parameter-driven paginated reports in Power BI Report Builder, providing dynamic insights for executive leadership.• Queried Qualtrics data in databricks to calculate metrics like survey response rate, NPS score, and customer satisfaction %.• Streamlined project execution using Azure DevOps, ensuring effective progress tracking and timely delivery of reports.