Code Poetry Portfolio

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

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.

Technology:

The hList application uses the following technologies:

• ASP.NET 3.5
• VB.NET
• SQL Server 2008
• SQL Server Reporting Services
• Web Services
• Embedded maps from Google

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 upgrades
• VB6 to VB.NET rewrites