Bilal Syed Abdali

● Cut reporting production time from weeks to minutes by building an end-to-end ETL workflow in Power BI, Power Query (M) and Python to automate generation of 6 quarterly Ontario Builds templates across 8,000+ projects. ● Built a variance and project progress dashboard presented to the Assistant Deputy Minister using Power BI, Power Query (M), DAX, Python, analyzing 1,518 projects across 4 completion measures to flag delays and surface data-quality issues. ● Built a Python forecasting system in Power BI to automate payment scheduling across ~$400M, replacing a manual Excel process and keeping forecasts accurate as actuals roll in. ● Consolidated claims, allocation, and project data across 1,518 projects into an executive Power BI dashboard using advanced Power Query (M), advanced DAX, enabling monthly performance tracking and decision-making for the Ministry Office. ● Retired outdated semantic models and established a reusable data foundation by engineering ETL pipelines in Power Query and Power BI Dataflows, consolidating funding, allocation, and payment data across 5,000+ projects. ● Launched a SharePoint analytics hub and standardized divisional Power BI dashboard templates, centralizing governance resources and reporting standards for ~40 staff.

●​ Built ETL workflows using Python, Excel, and MySQL to extract student records from spreadsheets and LMS databases, transform raw data into standardized formats, and load outputs into class enrollment and diploma generation. ●​ Developed dashboards and operational reports to track student onboarding, assignment submissions, grading activity, overdue work, and school-level performance across 5,000+ users and 95+ partner schools. ●​ Optimized MySQL queries for the LMS grading system, improving data-retrieval efficiency by 20% and significantly speeding up report generation for teachers and administrators. ●​ Restored LMS database following critical improper deletions, recovering access to essential course materials for approximately 500 affected students. ●​ Built and maintained the React frontend for the LMS serving 5,000+ users across 95+ partner schools, improving UX across desktop and mobile platforms.

●​ Implemented a Node.js platform integrating with the government’s CMS API, reducing compile time for front-end web page structures by 90%. ●​ Converted static curricula PDFs into interactive web pages using the ministry’s CMS, improving accessibility and navigation for educators and students province wide.

o​ Related Coursework: Data Structures & Algorithms, Artificial Intelligence, Object-Oriented Programming, Software Testing and QA