Guided by the needs of the community, residents and businesses, Windsor (Connecticut) Police Department (WPD) employs 68, of whom 55 are sworn personnel serving on a 24\/7, 5-2 schedule on a 28-day cycle. Everyone\u2019s schedule\u2014from Chief to clerks\u2014is managed and reported.<\/p>\n
Seeking more time for supervising and investigating, Detective Sergeant William Freeman needed to automate staff scheduling because constant changes often kept him and nine supervisors deskbound several hours a day.<\/p>\n
Freeman explains a problem typical to law enforcement scheduling: \u201cCommunity requests for extra coverage, staff\u2019s sick or vacation days, and emergencies usually invoke overtime. In Windsor, contracts require overtime be offered\u2014by seniority in each category\u2014first to qualified staff on their day off, then to those just coming off shift, and finally to other sworn officers.<\/p>\n
Microsoft Excel for staff scheduling was time-consuming and very difficult to constantly amend. Excel turned out no reports and offered no way to export staff hours worked into the town\u2019s payroll software.<\/p>\n
\u201cStaff scheduling in Microsoft Excel was completely inadequate to set up or \u2018see\u2019 our overtime priorities, to organize the call-in process for supervisors, or to report and prove our contract compliance. Filling each overtime slot could take 15 to 20 minutes\u2014up to two hours per shift. Multiply that times ten supervisors and managers every day for a year. In June 2010, I began searching for employee scheduling software to help harvest back those lost management hours.\u201d<\/p>\n
Freeman previewed many staff scheduling programs online. He says, \u201cOur needs are unique, but Snap Schedule staff at Business Management Systems immediately understood them. Snap Schedule is very powerful and complete for most police scheduling needs, but unique WPD priorities required a custom plug-in. BMS worked religiously to meet our schedule.\u201d<\/p>\n
Business Management Systems (BMS) develops the Snap Schedule line of shift scheduling software. It also develops Business Appointment Manager, software to manage large volumes of appointments, locations, and equipment.<\/p>\n
Snap Schedule software and the custom plug-in offer schedulers a screen to specify a date (e.g., June 13) for which search out under-staffed shifts. The software applies WPD\u2019s contract priorities and prioritizes qualified staff for each slot. It then compiles a sequential call-list by timeslot for supervisors.<\/p>\n
WPD initially purchased 15 Snap Schedule licenses, the plug-in, and several customized reports, including a WPD-specific Cruiser Checklist Report that displays assigned officers and their patrol districts, supervisors and dispatchers, and an equipment status checklist for every operational police cruiser on any day. BMS worked closely with WPD during deployment to ensure smooth installation and ease of staff learning.<\/p>\n
Because the immediate results were highly favorable (see below), WPD upgraded to Snap Schedule Premium. Based on Microsoft SQL Server, the premium version empowers additional users and lets users see each other\u2019s schedule changes on-screen in real time.<\/p>\n
Freeman relates, \u201cSnap Schedule\u2019s customer service helped sell us on the wisdom of this upgrade,\u201d says Freeman. \u201cBMS had proved they would make our investment pay out.\u201d At WPD\u2019s request, Snap Schedule staff developed an additional plug-in to allow export of hours worked, overtime, and time off to the town\u2019s MUNIS payroll system from Tyler Technologies.<\/p>\n
Freeman reports easy deployment, with Snap Schedule staff rapidly responding to installation questions. Snap Schedule\u2019s tools sped the import of old Excel spreadsheets to help populate staff records. Freeman quips, \u201cMy hardest task was deciding which color to use for which status.\u201d<\/p>\n
Even staff without computer skills picked up Snap Schedule willingly and without difficulty. Supervisors use the Roster Report daily to see clearly which staff will be where, when, and with which skill sets. Supervisors report saving many hours over previous software solutions. They devote more time to training officers and delivering hands-on benefits to Windsor residents.<\/p>\n
\u201cThe dynamics of this software are phenomenal,\u201d says Freeman. \u201cIt gives us visibility and overviews we never had. Schedule misunderstandings are nearly impossible, except when there\u2019s human error. This new clarity helped us reduce overtime pay mistakes by 90 percent.\u201d<\/p>\n
Tests of the Snap Schedule Premium\/MUNIS payroll interface are very positive. Freeman says, \u201cAutomated transfer of hours worked, shift scheduling, and overtime data into MUNIS will save our admin staff many hours every week. That data import will happen in minutes.\u201d<\/p>\n
\u201cMy original need,\u201d says Freeman, \u201cwas to put myself and other supervisors \u2018back in service\u2019 by spending less time on shift scheduling and managing overtime. We need to be out on call so we can ensure situations are handled properly, do spot checks, supervise Dispatch, and monitor prisoners. Now we can do much more of what Windsor residents care about.\u201d<\/p>\n
Freeman sums up, \u201cIf the Snap Schedule software hadn\u2019t already sold itself on its merits, their customer service would have. BMS gives us answers the same day we ask\u2014usually within a couple of hours. They\u2019re definitely team players.\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"