BALDEV SINGH

Data Quality Management & Reporting Integration: - Streamlined reporting processes by transitioning 80 existing reports from SSMS to Power BI datasets. This optimization reduced report execution time and simplified data refresh scheduling, eliminating the need for SQL Server Agent jobs. - Maintained an automated report distribution System, to distribute more than 150 Power Bi Reports to more than 500 stakeholders, based on DQM checks deployed on source datasets. The automation was built in Python, operating with the functionality of Teams and Email alerts and Power Bi Report extraction API, further Optimized with Multithreading, removing any delays due to serial execution. - Collaborated for the design and automation of a Data Quality Monitoring (DQM) framework, to monitor issues with over 100 key datasets and alerting the stakeholders on a regular basis. - led the creation of two Power BI telecommunications dashboards that streamlined device-level data management, tracked promotions and sales, and improved distribution, inventory, marketing, and customer engagement. These user-friendly tools drove significant revenue growth. The project encompassed extensive data extraction from relevant websites, transformation, and loading into SQL tables. Supply Chain Analytics: - Provide weekly insights, analytics, and business intelligence to facilitate decision-making and communicate findings to clients, delivering actionable conclusions. - Consolidated data sources at every step of device’s service and repair journey into a single source of truth table. - Tracked the device mis shipments from warehouse to retail via transaction data to identify the factors at fault. - Highlighted inefficient delivery vendors and retail stores to reduce the freight loss of $120M by 6%. Data Governance & Automation: - Development of 6 automated frameworks and more than 50 test scenarios to validate and ensure data accuracy of the Cubes deployed in SQL Server Analysis Services. This aided in ea