Sky Allinott

- Lead data analytics for the Care-First auto insurance reform. - Leverage cloud platforms to deploy R Shiny applications which improve organization efficiency. - Implemented a > 5TB SQL server to streamline and enhance our data capabilities and reporting. - Created the excess profit policy following legislative action to determine if insurers earned excess profits; returning any excess to Albertans. - Conduct actuarial research such as the impact of driver training on predicted loss cost per vehicle. - Create loss development factors to adjust incurred losses to ultimate for the Alberta auto industry.

- Reviewed inefficiencies in Alberta’s GRID rating system and championed reforms to the system. - Worked with internal and external stakeholders on a variety of projects. - Conducted forecasts on KPIs using seasonal ARIMA, ETS, and STL time series models. - Improved data transparency with the public by utilising SQL and Power BI dashboards for our website. - Lowered expenses >$10,000 per year by reviewing machine learning filings/conducting studies internally. - Utilised Git for version control, documentation and project management. - Created an annual survey into the industry’s usage of Artificial Intelligence and Machine Learning. - Presented economic studies and complex statistical topics monthly to our board. - Provided the data and narrative for multiple reports published on our website.

- Constructing a rich panel dataset (4 million rows, 100+ features) on Edmonton and Calgary real estate. - Created measures on crime, transit accessibility, development activity, pollution levels and more. - Insight: Half the properties in the City do not live within 1 kilometre of a grocery store.

- Improved class instruction by presenting common class misunderstandings to the instructor.

- Determined if City initiatives to reduce permit timelines were successful using internal permit data. - Communicated the success and failure of these initiatives regularly to senior leadership. - Shared with the public by Mayor Amerjeet Sohi and the City of Edmonton twitter account. - Improved team forecasting by introducing machine learning methods for model selection in R. - Saved time for the team by implementing a script that pulled external data and published it to Google Sheets.

- Implemented a database of client requests and information to improve efficiency and reduce errors.

- Thesis: Effect of LRT Expansion on Neighbouring Property Valuations: Evidence from Edmonton Alberta - Quantified the effect by distance to the station, project stage, and property value quantiles. - Insight: Nearest properties depreciated 5%, while further properties appreciated as much as 12%.