This project came right from the top—straight from the brain our fearless CEO. He wanted to be able to slice and dice our Alumni population and figure out where they lived, when they graduated, and what they majored in. Of course, he wanted it all online, so everyone else could join in the fun.

With the help of SQL-whiz and all-around excellent human being, Gracie Roberson, I was able to fulfill that vision. Gracie wrote the code to dredge all the requisite data from our sprawling Enterprise (yes, that’s enterprise with a capital E) Advance database and dump it into our SQL Server in a much friendlier format.

From there, I used ASP.Net 2.0 and C# to piece together the web app. The .Net code generates the statistics needed to power the CSS-based bar graphs. Some flash components—DIY Map and InfoSoft’s Pie Chart—fill in the areas where CSS dare not tread. Finally, Microsoft’s new AJAX framework provides real-time sorting of the data.

At the end of the day, our CEO was very pleased.

← Back to the portfolio