The Ontario Association of Social Workers (OASW) has migrated to IMIS Cloud EMS in 2022 and they were looking to expand their usage of IMIS by introducing self-serve member capabilities and automation.
The association knew they had data quality issues but was unsure of its extent. They were also lacking a common understanding of their data model which was preventing them from making progress in a structured way towards a trusted member database.
What we did
Analyzed core tables for completeness and data discrepancies
Took inventory of all lookup tables and list of values
Provided recommendations to address data quality and integrity issues (in concert with their IMIS provider)
Mapped core forms, staff and member views to database fields
Created an easy-to-use data model (in Miro format)