Ahaan Abrar

Business Analyst @Wiltshire Council

Lead analytics across 600K+ housing records spanning Temporary Accommodation, Rough Sleeping, and Homelessness Prevention, supporting operational and senior-level decision-making.Designed and own 12+ Power BI dashboards, including a comprehensive Rough Sleeping intelligence dashboard integrating demographics, health indicators, housing history, and accommodation pathways, improving case visibility by 30%.Developed a Python-based machine learning model to analyse Rough Sleeping patterns, forecast monthly RS growth trends, and predict likelihood of individuals re-presenting the following month, achieving ~85% classification accuracy.Enabled earlier intervention through risk scoring and pattern detection, contributing to a 15–20% improvement in targeted prevention activity.Streamlined SQL and reporting pipelines, reducing manual reporting effort by 35% and saving 20+ hours per month across teams.