Code Poetry Portfolio

Online Booking Tool

The online booking tool is used by salon clients to schedule their hair, nail or other personal service appointment. This development project was a rewrite of an existing classic ASP and VB6 application that features a more modern and streamlined user interface. The business requirements included:

• Complex scheduling rules. Users can only schedule appointments with technicians who perform that selected service, who are working during the date requested, on days when the Salon is open, and when they aren't already scheduled. Also required resources must be available, and a service may require multiple steps that involve other technicians.
• Color themes. Salons can select a color theme to match their existing branding.
• Credit card validation. Some services require credit card entry to hold an appointment.

Technology:

The online booking tool uses the following technologies:

• ASP.NET 4
• VB.NET
• SQL Server 2008 R2

This application was built for Salbei.

hList Vacancy Search Tool

The public uses hList Search to find affordable housing vacancies in Minnesota. The hList application consists of two pieces:

• An application that allows landlords to advertise their affordable housing vacancies in Minnesota.
• A search tool that allows housing seekers to search these vacancies based on location, rent amount, bedroom size and other attributes.

hList was built for HousingLink. The search tool is publicly available.

Unique Features:

The data entry portion of the application uses some fairly sophisticated validation rules to prevent incorrect data. It also performs some data cleaning routines to make some address and name data consistent. The search tool features an embedded PDF report that includes only the selected records on a previous page.

The newest version features the search criteria page implemented as a Sitefinity control, as HousingLink's new website uses Sitefinity CMS. It also allows location searches via a Google Map, and users can also optionally register to receive notification via email or text of new vacancies matching their search criteria.

Technology:

The hList application uses the following technologies:

• ASP.NET 3.5
• VB.NET
• SQL Server 2008
• SQL Server Reporting Services
• Web Services
• Google Maps API
• Ajax

Financial Aid Application

Financial Aid Independent Review provides objective, comprehensive and affordable financial need analysis to private schools. The online application allows parents to complete their financial aid application via a wizard-like process, guiding them through the complex financial information gathering process.

Unique Features:

When users have completed their financial aid request, they are prompted to pay a fee to submit their application, so credit card processing is part of the application. 

Technology:

The application uses the following technologies:

• ASP.NET 4.0
• VB.NET
• SQL Server 2008
• Integration with Authorize.NET

Online Survey Application

The custom survey application is used by an executive coaching firm to capture feedback from various participants on their coaching clients. It consists of three pieces:

• Survey authoring. Survey authors can use templates or create survey questions from scratch. Survey authors also define who will be permitted to participate in each survey.
• Survey taking. Survey participants complete surveys over the internet.
• Status and reporting. Survey managers can check on the progress of a survey. When the survey is closed, survey results can be downloaded into a special database that permits the manager to generate reports.

Technology:

The survey application uses the following technologies:

• ASP.NET 2
• VB.NET
• SQL Server 2005
• SQL Server DTS
• Microsoft Office VBA

Field Sales Quotation Application

The field sales quotation application allows sales people to gather window measurements and other specifications, and then generate a sales quote which can be printed for a customer in their home.

The application must perform a number of complex calculations to arrive at the correct pricing. The system also shows users their sales schedule, and helps them to track other information about the sales process.

Technology:

The field sales quotation application uses the following technologies:

• VB.NET
• Windows Forms 2.0
• SQL Server 2005

It was originally deployed on Pocket PCs, but has since been upgraded to Tablet PCs.

Field Worker Scheduling Application

The Logistical Choice application allows lawn care contractors to create an online schedule for their field workers, which can then be downloaded to field workers, eliminating a trip to the office. It consists of two pieces:

• Back-office Scheduling. Contractors schedule their field workers, track customers, and feed data to their accounting system using a web-based application.
• Field time-tracking and invoicing. Field workers enter their time, track the materials used on a job, and generate invoices from a Windows Mobile phone.

In addition to designing and building the application, I also created the help system.

The application was built for HYDROLogic.

Unique Features:

Logistical Choice features a drag-and-drop web interface for adjusting a worker's schedule. It also allows back-office workers to create an export of completed work orders, which can then be imported into QuickBooks.

Technology:

The Logistical Choice application uses the following technologies:

• ASP.NET 1.1
• VB.NET
• SQL Server 2000
• SQL Server DTS
• SQL Server Replication
• Windows Mobile
• .NET Compact Framework

Other Applications

Here are some other applications I've written:

• Issue tracking system.
• Zip code search for finding the closest store given a zip code.
• Volunteer tracking system.
• Seminar registration system
• Resource library

Technology:

Some of the technologies used in the above applications include:

• ASP.NET 2.0
• VB.NET
• SQL Server 2005
• Full-text indexing
• Flash integration with .NET
• Web services

In addition, I've worked on technology upgrade projects:

• Classic ASP to ASP.NET rewrites
• ASP.NET 1.1 to ASP.NET 2.0 upgrades
• SQL Server 2000 to SQL Server 2005/2008 upgrades
• VB6 to VB.NET rewrites