APSI has a small administrative team, but as the association that manages, educates and certifies all ski instructors wanting to work in Australia, at certain times of year they have an extremely business membership base.
All the ski resorts who employ ski-instructors need to know their skill levels and be assured that they are who they say they are. Members, potential members and employees are from all over the world, preparing to to converge on the Australian Ski fields for a few short months. A burst of activity.
Prior to the season start, members have to be contacted and educated on latest practices, status of accreditations, renew or purchase membership, book into training courses of different categories, of different levels, running on set dates in various locations, and pay for it based on the individuals existing profile. Ski instructors trained overseas need to have their skills assessed and appropriately matched with Australia accreditation levels. Everyone has to receive their ID cards and any uniforms and other physical products.
And there's more than 10,000 members.
And it was all done on a stand-alone database system and spreadsheets.
Over the years we've changed this;