NRMA - Customer Case Study

The NRMA organization provides a Community Grants Program annually, and when the NRMA came to SSW the records in a legacy database were difficult to report on and maintain. One of the key issues faced by the NRMA community grants team was keeping the records of organizations consistent across several years, when it is common for office bearers to change, and for each organization to create separate registrations making reporting difficult if not impossible for periods beyond the current year. The solution provided by SSW comprised a custom website written in Microsoft ASP.NET Dynamic Data and with an SQL Server backend. Reporting was built on top of Microsoft Reporting Services. A key feature of the system was a mechanism to identify "re-registration" events when someone tries to register for an organization that is already in the system. NRMA now have a secure database for recording the community grants data which is easier to use and maintain that the old system. This system incorporates a mechanism that avoids most cases of organization duplication, and so reporting is reliable across multiple years for the same organization. NRMA have successfully used the system for the first year of its operation, and are looking forward to using it for the next and subsequent years. We used these technologies: Microsoft ASP.NET Dynamic Data, SQL Server, and Microsoft Reporting Services.