I have considerable experience developing various types of web sites, including data-driven ones. Since January 2008, I've worked full-time as a web applications developer with Milwaukee-based Executive Director, Inc. (EDI), an association management company. I've worked with roughly 25 different clients there, developing web applications that interact with their client relationship management (CRM) systems.
My two backend programming languages of choice are C# / ASP.NET and PHP. I've also used Microsoft SQL Server, MySQL, and Microsoft Access to provide database support to sites. Below is a partial list of web sites I've developed or collaborated on outside of EDI.
PreserveCW
The front page of the PreserveCW web site
PreserveCW is a non-profit formed to keep a former summer camp in operation. Working with the specifications from chairman of the organization, I designed and developed this site. It features an interactive / social-networking section where registered visitors can share memories, upload photos, or search for friends from their time at camp. The organization's mailing list is also maintained through the web site, and is configured so that the chairman of the organization can easily maintain content.
This site was developed using PHP and MySQL. It's located at http://www.preservecw.org.
Photography by Joanna
The wedding portfolio page
Photography by Joanna is a professional wedding and event photography business based in Milwaukee, Wisconsin. I was asked to design a portfolio site that showcased the range of services they offered, while maintaining an elegant looking interface consistent with overall brand identity of the business.
This site was created with Macromedia Flash, primarily because it was the best tool to produce the desired smooth image transitions and animations.
This site is located at http://www.photobyjoanna.com.
Connection 47
Book search results, using an MS SQL Database and z39.50
Connection 47 is an online book exchange. While a student at Pomona College, I collaborated with two other students to create the site. It allows students to find other students buying or selling academic books that they need. In addition to title, author, and subject searching, you can also search for the books needed by a certain course.
Connection 47 was developed using C#, ASP.NET, and Microsoft SQL Server. It also uses the z39.50 protocol to interface with the a Library of Congress database to provide accurate information about books posted on the site.
The site is located at http://www.connection47.pomona.edu.
On The Loose
List of upcoming trips, retreived from an Access database
On The Loose is the outdoors and camping club of the Claremont Colleges. I redesigned their site, adding an online trip database. Before this, trip organization and registration was inconsistent -- some trips were organized via e-mail, others in person. The new system provided a central repository for all trip information, allowing trip leaders to post information about upcoming trips while simultaneously allowing participants to browse and register for trips. Trip leaders could also use the site to track participants and make sure they paid any necessary trip fees.
The site was developed using ASP with a Microsoft Access database.
The site is located at http://www.on-the-loose.com.
The Student Life
Book search results
The Student Life is the Pomona College student newspaper. Their web site originally consisted of static HTML pages. Every week, when a new issue was published, the webmaster had to spend several hours converting text and documents from Word or Pagemaker into HTML pages.
I redesigned their site, introducing a database model. As each issue of the newspaper was published, reporters and columnists were responsible for uploading their articles to the site (via an easy-to-use web form). Editors could then proofread and edit the articles before approving them for posting to the web site.
The site was written using PHP with a Microsoft SQL Server database.
The site is located at http://www.tsl.pomona.edu.
Episcopal Diocese of Fond du Lac
Resources for clergy and members
This was my first database site. Launched in 1998, the site includes a fairly simple content management scheme. Parishes within the diocese are all given their own space on the web site, and can edit their page through a WYSIWYG interface (using DHTML that was cutting edge back in 1998). Those with access can also post events to the diocesan calendar or add to a list of parish and clergy resources.
I developed this site entirely on my own, using ASP (VBScript) and a Microsoft Access database. The graphic design of the site leaves something to be desired -- but I think it's pretty impressive that the site has been able to keep operating, using my original design model and code, for almost 10 years.
The site is located at http://www.episcopalfonddulac.org.
Camp Webb
The front page
In 2003, I designed from scratch a new web site for the summer camp where I worked for several summers. The site is fairly simple, using just HTML and SSI. My original design for the site is still in use, although the content is now managed by the camp director, who I trained to use Macromedia Contribute to make changes.
I used Photoshop to create the basic template design used throughout the site. The coolest (in my opinion) part of the site is the interactive map of the camp, which was created using Macromedia Flash, which pops up images of different parts of the camp when you mouse over them.
The site is located at http://www.campwebb.org.
ConPortal
I developed ConPortal while working as a student supervisor for Pomona College's Information Technology Services department. As a supervisor, I was one of the people responsible for keeping our campus IT help desk staffed, which proved to be a fairly difficult task -- our student employees' busy schedules led to a lot of shifts being dropped or missed. ConPortal was designed to remedy this, by moving all staffing and scheduling online. At the beginning of each semester, employees signed up for shifts through the web site. When they needed to switch or drop a shift, they did that through the web site, which then sent out automatic e-mail notifications to other employees about newly-opened shifts. The system drastically improved our desk staffing situation.
ConPortal was written with PHP and a MySQL database. The site is only accessible to users on the Pomona College network.