Code Poetry Portfolio

Curanotis Pastoral Care Management

Curanotis allows church staff, clergy, and volunteers to "close the loop" with regard to Pastoral Care communications and operations.  With Curanotis, everyone at your parish that is involved with your Pastoral Care ministry can have secure, 24 x 7 access to up-to-date information about the people you are serving.  Once you begin using Curanotis you will be able to easily track who is being visited and interacted with from your computer or mobile device so that vital information does not "fall through the cracks".  

Technology:

The application takes advantage of the following technologies:

• ASP.NET 4.7
• VB.NET
• SQL Server 2016
• HTML 5
• Bulma.io
• Selenium UI Tests
• MSTest Unit Tests
• Automated deployment (application and database) via Azure DevOps 

HousingLink Vacancy Search and Data Entry Tool

The public uses HousingLink's main Search Tool to find affordable housing vacancies in Minnesota. The 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.

This application 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 system also adds some data automatically via XML feeds from select property management companies

The newest version is built on top of Sitefinity, and features search options that allow for multiple selection (such as multiple bedroom sizes and multiple accessibility feature options). 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 application uses the following technologies:

• ASP.NET 4.6
• VB.NET
• C#
• SQL Server 2014 
• Web Services
• Google Maps API
• Geocoding Distance Calculation
• HTML 5
• TSQL-T Unit Tests
• Automated deployment (application and database) via Azure DevOps

ePassing Online Obituary Service

ePassing allows family and friends to create online obituaries for loved ones who have passed away.

Technology:

The application takes advantage of the following technologies:

• ASP.NET 4.7
• VB.NET
• SQL Server 2014
• HTML 5
• Integration with several third party APIs (including Google Maps, Braintree, and Xero)
• Selenium UI Tests
• MStest Unit Tests
• Automated deployment (application and database) via Azure DevOps

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 2014
• Integration with Authorize.NET 
• Automated deployment via Azure DevOps

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.

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.

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 4 
• VB.NET
• SQL Server 2008 
• Microsoft Office VBA

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