Custom Development Case Studies

Confidential Reporting System: Agile Development by Solvd

A large government department required a new site for all their staff to be able to report any incidents, issues, or wrong doings in a confidential manner. The system needed to be very secure so that each user only had access to their own reports and there needed to be a top level management structure who could review all reports in order to assess them, add comments, allocate a category to each report and determine whether the subject of the report warranted taking further.

After an initial requirements session Solvd quickly produced a working prototype using Microsoft ASP.NET and Microsoft SQL Server 2005 to help the customers ascertain certain detailed requirements of the system. Solvd created a role structure which determined what screens each role could see on the site. To make the system even more secure Solvd developed a unique identifier id for each report and an encrypted password function for each person using the system. Included is a reminder option for people who have forgotten their password which locks users out after a certain number of attempts. Solvd then developed a management reporting system so that certain roles could view and update reports. This was enhanced with a detailed search facility enabling managers to search using different categories such as user name, report name, type of reports and date criteria. Solvd also provided a Management Information Statistics (MIS) function for the system to help the customers keep a track on numbers of incidents reported and under what category. The system was developed rapidly and Solvd were on hand to help ensure the system was implemented smoothly and on time.

The customers were extremely pleased with the system and provided some excellent feedback. They were particularly impressed with the way after a only an initial 2 hour requirement session Solvd were able to produce a good first cut demo in a quick time so that they could present it to their senior management. Additionally, the system went live with no issues and to this day has proved a great success.