Essex County Council

Partnering to accelerate digitisation


As a local authority and government body, Essex City Council is the keeper of year's worth of data, being required to store records while making them easily available and secure. The council decided to find an archiving solution that would finalize its move to the cloud.

Challenge

The council needed to move four terabytes of data (or 10 billion data entries) and design a reporting solution that would simplify retrieving information, while keeping the records secure.

Solution

Fujitsu built the council an archive solution on Oracle autonomous database to export legacy data and store it safely in the cloud. It also designed a custom reporting solution for the archive.

Outcomes

  • Transferred legacy data quickly and within budget
  • Saved costs with the new archiving solution
  • Simplified information retrieval with a custom support solution
The delivery time was exceptional, that was the fastest I've seen something completed. This Fujitsu solution is far better than what we had.

Nick Pimm, Project Manager, Essex City Council

4 TB data migrated

8 months to build the archive and transfer the data

About the customer

Essex County Council is a local government body within the county of Essex. It collaborates with other local, regional and national bodies to deliver services and represent the best interests of the people within the county. It has 75 councillors elected from 70 divisions, and serves a population of almost 1.5 million, making it one of the largest local authorities in England.

Living up to high expectations

For local authorities, serving the population means, among others, protecting their privacy, offering resources quickly, and sharing information based on sensitive data securely. Not having the right tools to achieve this means letting down a lot of people precisely at the time when they need help. Taking this mission seriously, Essex County Council collaborated with Fujitsu to migrate to an Oracle SaaS application (HCM, Finance, Procurement and EPM) ensuring the best possible information management system for all projects.

The final piece of the puzzle was to safely store the legacy data. As a government body, the council is required to store records for a set period as mandated by business need or legislation, such as the Freedom of Information Act (FoI) 2000 and the Data Protection Act 2018.

Protecting information with compliance and security

In June 2022, Fujitsu started working with Essex County Council to construct a static archive solution as part of its migration to the cloud. Fujitsu, using its Oracle CloudScale tools and accelerators, built the solution on Oracle autonomous database, using Oracle APEX as the user interface. This allowed the council to export legacy data and store it safely on Oracle Cloud Infrastructure (OCI).

The work had to be done quickly and reliably. According to Nick Pimm, Project Manager at Essex County Council, the council and Fujitsu had worked together for years and the relationship is an example of true collaboration. “The results of the entire Oracle project, including the archive, are clear. The delivery time was exceptional, that was the fastest I’ve seen something completed. This Fujitsu solution is far better than what we had,” he comments.

Fujitsu even helped the council with an unanticipated legacy solution problem. “This was an unplanned, emergency piece of work. Fujitsu helped us get out of a challenging situation on that,” says Pimm. “A lot of that depended on Fujitsu’s goodwill but there was never any doubt in my mind they would help,” adds Benjamin Sutherland, Programme Manager at Essex County Council.

Serving the citizens

Perched on top of the brand-new archive is a custom reporting solution designed by Fujitsu, which was contracted to host the application suite and provide an application management service. This solution is used mostly for answering FoI requests in a timely and reliable manner.

Fujitsu has also been helping the council with knowledge acquisition and preparing for running the archive without external support for security and patching. To better serve its citizens and be more responsive to their requests without relying on a third party, the council wants to be self-sufficient and have the ability to write new reports beyond what Fujitsu delivered.

Fujitsu will be leaving the solution in great hands. Commenting on the long-lasting relationship, Sutherland says: “We really had a one-team feel with Fujitsu. We did a big programme and you’re not going to get away without some issues, but there was a real sense of maturity across the teams and we were able to work through all that stuff together.”

Related Customer stories

DELTA Fiber
In just under a month, Fujitsu found a solution to extend the reach and capabilities of ServiceNow. DELTA Fiber could now generate specifications with a few clicks of a button and pass the time savings on to partners and customers.
Schneider Electric
The world’s largest ServiceNow ITOM deployment provides Schneider Electric with comprehensive visibility and control, significantly reducing risk exposure, and cuts down incident resolution times from hours to minutes.
Zona Franca Barcelona
Zona Franca is creating the DFactory, Barcelona’s hub for the most prominent companies that will lead Industry 4.0. Fujitsu provides the 5G connectivity that enables hyper innovation to succeed.
Abertis Mobility Services
Abertis Mobility Solutions (AMS) collaborates with Fujitsu for more innovative, smarter and connected roads. Fujitsu’s Cloud Service for Microsoft Azure enables a connected, intelligent and transformed business environment.
Estonian Health Insurance Fund
After running half a year on Microsoft Azure Cloud which enables global citizen access to pharmaceutical services, the Estonian Health Insurance Fund now achieves about triple the innovation rate that they used to do just two or three years ago.
State capital Potsdam
Trusted advisor for the cloud strategy
Universidad Católica de Murcia
As UCAM's on-premises data center is now connected to the AWS cloud the university no longer has to worry about potential disasters. UCAM now has high availability for its critical infrastructure services, providing continuing support and services to thousands of students and staff.
INFORMA D&B
INFORMA D&B collaborates with Fujitsu to incorporate Explainable AI for the financial-commercial information industry.
Helsinki University Hospital
Helsinki University Hospital (HUS) has innovated with a partner ecosystem to develop a unique digital solution that makes home dialysis treatment simpler and more sustainable for both patient and professional.