Ally Quiz
This internal testing suite was a project given to me by my Operations Manager. Since there were minimal tools immediately available, and I wanted to provide the fastest turnaround time, I went ahead and used PHP and mySQL to form the backbone. Graphics were XML-SVG that were output to PNG. This initial prototype was ready and working in a week, and an expanded version was ready the same month.
The database was designed to allow over a million questions and over one thousand answers to each one. In addition, the user would only receive a maximum of five questions a day, each which were randomized based on the day and the user, so that advocates could not share answers. Finally, when initially answering a question incorrectly, the correct answer would be shown. However, when reviewing their score history, only their incorrect response would be shown for the last period of 7 days, in case there was a dispute. The ranking board would only display an employee's number, not their name. If an employee chose to opt-in to name ranking, their name would be displayed to all others that had also opted in.
After I completed the second prototype the project was handed over to the official IT department. I had been maintaining my team lead duties while preparing this web application, and simply had more time for reviewing financial regulations after it was completed.