Releasing value from legacy databases – standardisation and access
Description of Project
Following some significant acquisitions our client faced the widespread challenge of integrating disparate databases and applications. A very large amount of untapped value was locked up in the data contained within these databases and applications. For example, extracting knowledge from an Historical Research Database could significantly reduce the cost of drug development by identifying, early on in its development stage, any adverse side effects to justify a prompt end to the work. The database was however available only to very few researchers and there was a lack of internal experts experienced in the use of the various data domains.
Our client wanted to merge standardised and validated data extracted from the Historic Research Database into a corporate data warehouse with much wider access to assist and support broader corporate goals of general projects integration and data mining. Such a project faced a number of challenges which Chaucer was asked to help overcome. These included finding data domain experts, identifying buried data and assessing its value, changing data logical structure and transferring the standardised version to a stable system, verifying and approving data to be moved to the new corporate data warehouse and resolving any anomalies.
Chaucer simplified the complexity of the project into two phases which it then systematically project managed in both business and IT environments to ensure value was maximised by:
1. Creation of a new historical database for incorporation into the new data warehouse, and the migration of all legacy data.
2. Identification of new clinical data throughout the corporation, classifying it and migrating the targeted data into the new database.
Chaucer’s Scope
- Project Management and leadership to provide rigour and discipline leading to best practice processes, tools and techniques to deliver the project on time and within budget
- Detailed project planning and work scoping including project resource scheduling, estimating and cost control, document management and project change control
- Implementing and integrating several new client methods and processes
- Developing the project organisation, roles, responsibilities and accountabilities plus a management reporting structure including weekly, monthly and ad hoc reports
- Project progress measurement, tracking and reporting
- The implementation and operation of project assurance processes so that client governance, corporate assurance and quality processes were implemented appropriately
- Risk Management including risk analysis &and the maintenance of a risk register together with the associated mitigation actions
- Communications program including stakeholder management and internal messaging
Benefits
Chaucer’s twenty years of experience with software projects enabled us to have a clear understanding of both the business and information technology agendas as a basis for defining and managing towards specific project goals and objectives which were delivered on time and within budget. Having both project management expertise, and the ability to understand sometimes complex technical content allowed.
Chaucer to act as a bridge between the clients IT organisation and all other business and service departments and to proactively recognise, report, address and resolve any material project issues and risks.
Chaucer’s unique project planning approach and work breakdown structure was adopted as best practice and input to other project processes, thus spreading best practice within the corporation and so adding value not only to this but many other similar projects and programmes. Chaucer’s involvement was seen as a key element in the timely success of this very important project which unlocked significant value for the client.
-
Clinical Trials and Relationship Management Read more
-
System Migration Read more
-
Global Document Management System (GDMS) - Implementation and Organisational Change Management in an Enterprise Wide Corporate Programme Read more
-
Managed Service Framework Read more
-
Set up, launch and develop commercial operations for on-line Bingo Read more
- Accreditations/Partners
