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.
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.
We did the initial market research for an idea potential. We also researched new technologies which could be used to support building the idea.
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.
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.