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

Toyota Boshoku America
Toyota Boshoku America implemented Oracle E-Business Suite to become radically more efficient. TBA now benefits from decreased manual labor and reduced inventory problems in manufacturing. The time to close accounting processes reduced from 45 days to just 3.
HMD Global
The provision of strategic RISE with SAP consultation services removed the burden of having to handle multiple vendors and contracts. HMD Global can now ramp up their manufacturing plants and deliver continuous improvements in business process efficiency, functionality, and automation.
Tri Petch Isuzu Group
Drive Success with Digital Transformation
Canadian Provincial Organization
Consulting delivers improved customer experience
PPP Green Complex Public Company Limited
Delivering the first green palm oil Producer in Thailand
Palkeet
Palkeet, the Finnish Government Shared Services Centre for Finance and HR, converted from SAP ECC to SAP S/4HANA, thus improved reporting capabilities and use more efficient order-to-cash processes.
SHOWA GLOVE
Through Fujitsu’s Application Management Services and implementation of S/4HANA, the team at SHOWA GLOVE was able to streamline their expansion process overseas. Furthermore, knowledge and skills are getting sharper.
Pfizer
Pfizer CentreOne’s achieved around 60% sales operation efficiency increases through process innovation and automation, and eliminated manual business processes and improved the accuracy of data capture.