OpenSky | Leicestershire County Council | Waste Management Case Study

700,000+

Residents’ waste managed daily

Cost Savings

Increased Productivity & Reduced Costs

Time Savings

iWDMS saves days of work every month in time-consuming admin

100% Accuracy

Clean & Accurate Data

Scalable Reporting

Robust Reporting & Highly Scalable

Less Dependency

Reduces Key Person Dependencies

The Situation

Faced with a rapidly approaching End of Support threat for its Windows Server 2008 systems, the Leicestershire County Council engaged OpenSky to migrate its web-based Integrated Waste Data Management System (iWDMS) to Windows Server 2016, thus alleviating the risks associated with hosting a business-critical application on legacy software.

Leicestershire County Council engaged OpenSky to migrate its web-based Integrated Waste Data Management System (iWDMS) Application Servers from Windows Server 2008 instances to Windows Server 2016 before Microsoft discontinued support, thus alleviating the risks associated with hosting a business-critical application on legacy software.

About the Integrated Waste Data Management System

OpenSky’s iWDMS is a unique custom-built cloud-based system allowing for the gathering, transformation, management and reporting of data relating to the movement of waste from collection to disposal.

Leicestershire County Council opted to move to the latest version of Windows Server and SQL Server and migrate current applications to a newer Microsoft supported platform. Once the applications were verified to be fully functional on the latest Windows Server version, and when connectivity and interaction between key components was tested and verified, the new application and database servers were switched with the existing server

An Advanced and Highly Automated Strategic Waste Management Tool

IWDMS facilitates the tracking of waste from collection to disposal with accurate tracking, and effectively automates many of the daily waste management tasks that WLWA would be expected to complete.

The system provides standard and specialised reports such as vehicle reports, waste reports, contractor reports and WDF reporting as well as functionality for users to design and customise their own reports and dashboards. As waste management processes are automated by iWDMS, the system can run many of the daily operations automatically.

New maintenance plans were applied to ensure the database would perform optimally in the new SQL Server instance.

The best-practice architecture will allow Leicestershire County Council’s waste mangers to add functionality in line with changing regulatory requirements.

Key Functionality & Features

Customised cloud-based system.
Real-time insights & data tracking.
Standard & customised reports.
Configurable reporting to support waste data flow tonnages.
The iWDMS solution has streamlined processes while saving a significant number of days in administration every month.
Installation and configuration of iWDMS in-line with WLWA’s specific requirements.
The iWDMS solution automates WLWA’s waste data management processes and reduces the dependency on key people for the management of their in-house processes.

Through a fast and professional migration and support, OpenSky helped Leicestershire County Council maintain its Waste Management operations with full security, compliance and confidence.

IWDMS delivers the security, automation, and data management functionality the Council needs to work towards its UK and EU waste targets. Thanks to the task automation, automated reports, and high degree of usability, its staff are freed from personnel dependency on key tasks, and management have the data and analytics they need to make better strategic decisions needed to improve recycling and reduce landfill contributions.

Improved Security, with full support on the latest versions of Microsoft Windows Server and Microsoft SQL Server platforms
Faster and Better Performance thanks to the application and system upgrades.
Full Protection Against Threats and Breaches
Newer versions of Microsoft SQL Server introduce innovations that include high-availability features, scalability, and better management.