The incumbent system comprised four, disparate and aging databases that managed very large amounts of similar data, in different ways. Added to this, the workflow required manual input from knowledgeable and experienced individuals in order to function. Not only did this require a lot of administration from MLA staff, but it also resulted in repeated and often complex queries about input data, thus slowing access to information. As a foundation for their future vision, MLA required a new cloud-based solution that would integrate existing data into a single and secure system, flexible enough to meet its growing needs.
Over a six month period, Servian partnered with MLA to determine the requirements and design and implement a solution. The existing data was migrated into a cloud-based data warehouse, by way of an AWS Data Lake. A structured transformation framework was implemented, along with a validation process, to automate as much of the workflow as possible. Systems were aligned with MLA’s policies for security and data backup, and the process also included a large mapping exercise to unify the quality and format of data collection codes. As well as addressing MLA’s day-to-day enquiries and project challenges as they arose, Servian ensured a smooth handover, with training, workshops and documentation.