Streamlining Data Audits and Data Integrity at the FIU Foundation
From the Nominator
We are currently using Blackbaud Raiser’s Edge NXT as our CRM. To maintain data integrity and make sure that data coming into our system meets our set business rules and data entry standards, we used to run manually several queries, plus another system tool (RE Queue) that would run multiple queries on a scheduled time. We had a total of 100 queries that would output the data inconsistencies to later be corrected. This tool serves to automate this process and consists of several stored procedures created in SQL that run multiple queries and returns data that is not aligned with specific business rules. The reports runs daily and when inconsistent data is found it allows for the operator to drill down on the granular data to be corrected.
From the Judges
The judges were impressed by the great refinement of the systems, which resulted in a significant improvement in ROI for the team. The meticulous attention to detail and strategic adjustments made by the nominator showcased their ability to optimize resources and generate more impactful outcomes.