Use Case: Calculating Snow Removal

Prince George’s County Department of Public Works and Transportation required an enterprise software accounting solution that would help manage resources and costs when responding to emergency conditions that were unpredictable, uncertain in duration, unknown in intensity, and could potentially cost the county millions of dollars – all created by Mother Nature. Such conditions include hurricanes, tornadoes, ice and snow storms, all emergencies where being diligent, resourceful and cost effective matter, as they impact the safety of the community.

Our team designed and implemented a custom software solution (StormTrak), that embodied the concept of tracking event related costs and non-event related activities used to manage emergencies. Prince George’s County had a long list of needs, especially after a blizzard in 1996 that exposed serious gaps in service, a shortage of funds, and an inability to collect on potential FEMA reimbursements. The StormTrak accounting software would ultimately impact several thousand employees, keep track of each cost related detail impacting county funds, and deliver emergency services to hundreds of thousands of people in the community they serve. The county could no longer rely on disjointed stovepipe solutions, nor could they risk losing FEMA funds for the sake of the community.

The Challenge…

Needed a simple method to generate FEMA reports:  The county wanted not only a long list of features, but also recognized that there were likely features that would be beneficial that would be mandated by the Federal government (FEMA). One of the challenges was that FEMA could change its reimbursement guidelines at any time. Prince George’s County needed a way to be able to keep pace and remain flexible to support changing FEMA guidelines and procedures.

Needed a short Learning Curve:  Another challenge would be the computer skills of the data entry and reporting personnel. Since the software would likely only be used during emergencies, there is the potential for long periods of time to lapse between storms. Consequently, the solution needed to be extremely easy for the user to follow, with built in “Easy button” style features and mouse-over help to minimize keystrokes and maintain a high degree of accuracy.

Needed to Integrate with existing systems:  Then there was a need for the software to share data with other county-licensed databases, such as their personnel system, roadway pavement sensors, Fleet / AVL systems and the public website call center.

Needed data in easy-to-use formats:  Lastly, the county needed to be able to extract data for reports in nearly unlimited ways without requiring a programmer. They wanted to easily accommodate new accountability reports and have a standard fare of pre-formatted templates.

The Approach & Solution…

Flexible and accepted FEMA Reports:  To address the continually evolving guidelines from FEMA, we made each field available for filter, sorting, and grouping, and summarized all numeric columns. We further took the date and time periods – and allowed the user to define a snapshot in time — which would extract costs for all activity that occurred within that time slice. All columns were exportable – making it easy to share the data for use in desktop applications.

Simple GUI leads to Short learning curve:  To minimize the end user learning curve, we modeled the design of each data entry screen to use a clean, consistent format. This made it easy for users to learn the keystrokes behind one screen, which parlayed into the confidence that they could navigate any screen. We built in help text (mouse over) and popup help screens, organizing data so that the “required” content was easily recognizable and non-mandatory content could be found on secondary screens.

Seamless Integration & Easy-to-use formats:  To solve the requirement for sharing data with multiple systems, we allowed connectivity to the StormTrak dataset via XML. The StormTrak solution shares data with  Fleet / AVL, the call center and with ADP maps, and content can be exported to popular user platforms including: PDF, XLSX, CSV and RTF.

Summary of Solution …

  • Event / project driven
  • Cost accounting – tracking costs clustered by events or projects
  • Web based GUI (ASPX / .NET / SQL) using DevExpress
  • Managed hosting on US-based servers with 99.9+% up-time
  • Map connectivity via Google Map API
  • Weather retrieval via NWS (National Weather System) API
  • Supports unlimited users, currently at 200+ users
  • Combines pre-formatted and ad hoc reports
  • Ad hoc reports are fully customizable to user and can be exported to common formats (XLSX, PDF, RTF, CSV,TXT)
  • Multiple region / county installations
  • Accommodates batch / offline importing of data
  • Exports contacts (people) and organization data to XLSX, CSV, TXT
  • ODBC connection to MS Access
  • Manages multi-million dollar efforts
  • Allows for contact, meeting, and non-project activities to be tracked
  • Initial release 1996 in Oracle followed by 2 major releases in 2005 (web) and 2013 (web hosted)
  • 4 tier user permission hierarchy with different menus for different levels of access
  • Annual training classes provided / user manuals and video reference
 Cycon began supporting Prince Georges County beginning in 1996 as a software solution provider.  Cycon continues to partner with the County provide SME (subject matter expert) services and self-sustainable solutions.