Web Application Development

Web applications have several benefits over desktop applications. The software is installed in one location on a server, and users are able to access the application from any device which has a web browser. For most applications, users do not have to install any additional software and may access the application from any machine. SSL technology, password authentication, and other techniques help secure the applications to protect the information locked inside. Also, since the application is in one location, managing updates to all users is automatic.

Past Projects
HealthSum

HealthSum Web Application

WSU - Field Disease Investigation Unit

SumTech took over failing project meant to analyze health events in cattle. We gathered a complex set of requirements and developed a novel system to process health events into a meaningful set of data. We boosted performance of previous approach. Imports improved from taking an hour to a minute. Reports improved from taking dozens of minutes to a couple seconds.



6/2012

Washington State University

Administration Application

WSU - Biomedical Communications Unit

Developed database-driven application to manage administrative needs for self-sustaining unit which provides paid services. Before building our system, this group had minimal reporting information from which to make management decisions, and most of the information was paper-based rather than stored electronically. The application we built has modules that manage revenue, orders, workflow, online orders, and file management.



2/2012

Washington State University

Laboratory Administration Database

WSU - Veterinary Clinical Pharmacology Laboratory

Developed database-driven application to manage administrative needs for self-sustaining unit which provides paid services. The application manages workflow, produces financial reports, and aids technicians in completing their tasks. Spreadsheets and Word documents were converted to a database application in which redundant data only needs to be entered once. The application was originally created using SQL Server connected to a MS Access front-end. The front-end was later moved to a web-based system. The work capacity for the group increased 5-fold after implementing this application.



5/2010

Timecards App Screenshot

Time Card Tracker using Text Messaging

Phos Painting

Time cards are difficult to manage for their mobile painting crews. This application allows employees to send text messages to clock in and clock out. Employees check that their hours are correct through a web interface, and there they may request changes where necessary. The bookkeepers can make updates and see the total hours worked for each employee. Total hours are calculated for regular and OT pay, as well as hours for different insurance conditions.



3/2010

Veterans of Modern Warfare

Membership Form, Database and Administration Application

Veterans of Modern Warfare

As a growing national organization, VMW needs an efficient way of tracking membership, chapters, dues, etc. SumTech created an online membership application that submits information to a database for storage. Several validations are used to test that valid information is being entered. Administrators can review, update, add, and delete membership information through an MS Access program. Also, the users can use the power of MS Access queries to find useful statistics about their organization.
Later, the MS Access front-end was converted to a web application.



2/2009

InPrayer.US

In Prayer for Washington State Website and eNewsletter

In Prayer for Washington State

People wanting to know how to specifically pray for Washington State have a place to go. This site is designed to be updated weekly and have newsletters e-mailed to members with the site’s new information. Persons may subscribe and unsubscribe to the newsletter on a weekly basis. The facilitators of In Prayer send a MS Word document to SumTech, who then converts the information to published on the web. Each newsletter is stored in a database for archiving so members may review past newsletters.



10/2008

Living Faith Fellowship

Worship List Documentation Program

Living Faith Fellowship

LFF keeps commonly sung hymns and songs stored in a box for the worship team to reuse each week they are needed. SumTech created a database list of all the songs available in the box, their various keys, and their composers. Now reports of what songs are available can be printed sorted by their first line, title, or key of composition. Volunteers can update the database when new songs are added to or removed from the box.



1/2007