Case studies are invaluable as they measure challenges versus solutions based on the insight of prospective or existing clients. Spence Software has met many potential clients over the years that had unique challenges to overcome. While many clients fit perfectly into the flexible nature of S2Web Corporate, some challenges need to be addressed independently.
When custom is the only option, Spence Software examines every element and provides an out of the box conceptual solution. Once thoroughly reviewed and tested, the client approves and the solution is rolled out. Following a roll out of a custom solution, feature set, or module Spence Software reaches out to their existing clients to measure it’s benefits.
Spence Software’s Client Primco Dene EMS operates Emergency Medical Services in remote industrial worksite locations in Alberta, British Columbia and Saskatchewan. Daily, the medical center welcomes many walk-in patients for some form of medical treatment. In addition, the medical center performs many types of mandatory workplace tests. For each patient visit, there was a substantial amount of data which had to be recorded on spreadsheets. On a weekly, monthly and quarterly basis, this data had to be consolidated into reports and charts.
This process was time consuming for the staff and difficult to manage. The solution was to take S2Web Corporate and modify the People and Medical forms to capture all the required data. Once that was completed, the existing employee and medical information was converted from spreadsheets to the web site database.
Finally, the security on S2Web was altered to allow the clients to login to retrieve the summary reports and charts that they needed without having any access to confidential medical records.
Nova Scotia Power is the main provider of electrical energy for Nova Scotia. The company wanted to perform an annual safety audit that could be applied to every business unit. A standard safety audit contains many questions, some which may or may not apply to an individual business unit. Previously, the HSE department would have to directly communicate with each business unit to determine what was to be audited as well as to ensure that the audit was completed properly.
This process was very labour intensive and difficult to monitor over the 140 different business units. The solution was to modify the S2Web Corporate Inspection module to make the business units more accountable for their own audits. This would make the remote monitoring of the audit easier to track for the HSE department.
At the beginning the of the year, each business unit defines what audit items they are committing to. As the year progresses, they enter in what they have done. At the end of the year, they are scored out of 100 to see how compliant each business unit is. The HSE department can monitor the progress of each business unit throughout the year to ensure that nobody falls behind. In addition, each business unit can use progress charts and reports to monitor all progress for all business units.
Each year, the audit questions are change and the previous year’s audit is archived.
Spence Software has several clients who have multiple companies using S2Web Corporate™ as their standard for safety management. Among them are Pyramid Corporation, PME Inc., Terus Construction, GCS Energy, NCSG and by far, the most challenging was Imperial Oil.
Imperial Oil needed a consistent platform from which to measure their 26 Esso branded re-sellers all of whom had several branches and varying scope of business. The Esso branded re-seller project start with a few key stakeholders representing the re-sellers and a team from Imperial Oil. S2Web’s platform was massaged to allow for each company to only see their information and their branches. This was especially difficult when it came to training. Each company had their own course list and even though they were the same course, expiration periods varied from company to company. Operation Advisors were only to see the results of entries not the entries themselves. The end result was buy-in from the re-sellers as it was a turnkey system and was easy to use. The Operations Advisors were happy as they had the numbers they needed at their fingertips and could make suggestions for improvement based on those numbers. The standard suite of modules was increased in 2017 to include Asset Management & Maintenance.