Past Projects: MS SQL Server

HealthSum

HealthSum Web Application

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.

Washington State University

Administration Application

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.

Washington State University

Laboratory Administration Database

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.

Timecards App Screenshot

Time Card Tracker using Text Messaging

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.

Washington State University

Financial Tracking and Budgeting System

SumTech upgraded legacy MS Access financial tracking software to a more intuitive user design. We moved the database from MS Access to SQL Server and redesigned the user interface from scratch. We created several financial reports for finance personnel and high level reports for deans. We also worked with importing Excel tables of data into the database.

InPrayer.US

In Prayer for Washington State Website and eNewsletter

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.

Living Faith Fellowship

Worship List Documentation Program

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.

SumTech Business Solutions, LLC

Budgeting and Personal Finance Program

What used to be an Excel spreadsheet for assessing our family budget and how we spend our money was converted to an Access database as a more efficient and powerful tool. Receipts can be entered into the database using a display resembling a transaction register. Later, we transitioned the checkbook application to a web-based interface.