Portfolio Description

Background and History

The Aboriginal Housing Management Association (AHMA) has 25 years of expertise in advancing housing rights for Indigenous Peoples. They are Canada’s first Indigenous grassroots housing authority. AHMA members manage over 95% of all Indigenous housing units located off-reserve in BC. AHMA administers funds for almost 10,000 Indigenous individuals and families living in urban, rural, and northern parts of the province. 

AHMA members provide a spectrum of culturally safe housing, including affordable housing units, homeless shelters, transition homes, supportive housing, and assisted living facilities. Many of AHMA’s members also offer support services, including homelessness prevention, parenting skills, mental health programs, and substance use support, complex care, and more. In terms of scale, AHMA members make up over one-third of Indigenous housing providers in Canada.

The Problem

Our client used Excel technology to manage the portfolio disposition of the units they own under the Rural Native Housing (RNH) program. The excel based solution proved to be valuable, and AHMA wanted to make it available to their community-based organization partners.

Their challenges were:

  • Their existing process was inefficient and cumbersome. 
  • They did not have a good way of sharing the technology with their partners.
  • They were looking for a more robust solution than simply emailing the Excel tool to their members.

Our Solution

AHMA engaged Spot Solutions to transform the excel based solution into a web application. The solution needed to automate their workflows and provide scalability and extensibility to community partners. The Portfolio Planner Portal that Spot developed innovates housing management for AHMA and their partners. We developed the tool using various technologies such as C#, MS SQL server, Visual Studio, ASP.NET MVC, Bootstrap, and JQuery.

The Impact 

AHMA and its partners now have an easy way to determine the optimal disposition options for the properties they own. The web solution provides support in the decision-making process and will provide adaptation of future programs. They were able to replace their manual process with an easy-to-use application with a user-friendly interface designed to be accessible to all users, regardless of their technological proficiency.

Now they can:

  • Data enter housing information.
  • Maintain housing stock information.
  • Configure and manage indicators.
  • Calculate disposition outcomes.
  • Perform what-if analysis.
  • Run reports.