# Tender for Datawarehouse Implementation Services

> Contract award record from UK public-sector procurement sources.

## Key facts

- Public buyer: UNIVERSITY COLLEGE LONDON
- Contract winner: Barrachd Limited
- Award value: £3,000,000
- Tender value: £1,500,000
- Award date: 22 November 2016
- Published: 18 January 2017
- Contract start: 19 December 2016
- Contract end: 18 December 2019
- Stage: awarded
- Procurement category: services
- Notice ID: 16d12e31-2e0a-4c18-8cdc-a79894d1fe8d-125870
- OCID: ocds-b5fd17-1daffc3a-adca-11e6-9901-0019b9f3037b

## Description

UCL has purchased IBM Datastage and IBM CDD to act broadly as the technology underpinning applications integration and data warehousing across the IT estate\. It operates a number of applications, including Oracle E-Business Suite for Financials and soon to be HR, SITS for Student Management, Research and Estates applications\. UCL would like to contract an organisation to partner with for the development of the central data-warehouse and potentially the implementation of an Operational Data Store \(ODS\) for the HR implementation project\. Data for the central data-warehouse will be transferred from and to multiple database types, including other data-warehouses and datamarts\. The transfers may require complex data transformations\. They will capture data in both real-time and batch modes\. The success of this project will critically depend on a partner with exceptional data modelling skills and experience of developing data-warehouses, especially within the HE sector\. Based on their experience and skill, the bidder will be expected to develop data-models for the data-warehouses that meet current needs but also accommodate future needs where these can be reasonably foreseen or expected\. Thus the data models developed need to be durable and flexible\. The bidder will be required to develop appropriate documentation and configuration activities and deployment plans to help infrastructure architects and operational teams to understand the deliverable\. The documentation should enable those not familiar with the installation to i\) reapply the solution in a new clean environment with the same configuration as that provided by the bidder and ii\) development staff to understand the configuration and development that has been undertaken\. Additional information: OJEU Reference: 2016/S 170-306589

## Related contract awards

- [Request for Proposal For Implementation Partner for Robotic Process Automation Project](/contracts/ocds-b5fd17-eaf7dea8-664f-45ba-af13-d7ddce506f24): UNIVERSITY COLLEGE LONDON
- [ITT for UCL ExCiteS Social Enterprise Consultant](/contracts/ocds-b5fd17-1a2ff4dd-1bbd-4cd0-825a-e2ae8f4e7306): UNIVERSITY COLLEGE LONDON
- [EDTech Participant Co-ordination and Liaison](/contracts/ocds-b5fd17-39863cf8-1dd5-4f16-8459-4f3b22a2690b): UNIVERSITY COLLEGE LONDON
- [1339/MH Data Visualisation Tool](/contracts/ocds-b5fd17-446192cf-adc9-11e6-9901-0019b9f3037b): UNIVERSITY OF SHEFFIELD
- [1323/MH Consultancy for Implementation of a Planning Tool in TM1](/contracts/ocds-b5fd17-3d48256c-adc9-11e6-9901-0019b9f3037b): UNIVERSITY OF SHEFFIELD
- [Student number planning and fee forecasting software](/contracts/ocds-b5fd17-5a30dcc0-adc9-11e6-9901-0019b9f3037b): THE UNIVERSITY OF BIRMINGHAM

## Source

[View the original notice on Contracts Finder](https://www.contractsfinder.service.gov.uk/Notice/16d12e31-2e0a-4c18-8cdc-a79894d1fe8d-125870)