Savings and accurate reports with help of new Data Warehouse
Sogeti builds Extract, Transform and Load (ETL) processes to collect and process data from multiple resources.
HSE Procurement works with vast amount of suppliers and vendors, for all aspects of purchasing. From stationary to syringes and x-ray machines to hospital dinners, HSE purchasing is a complicated and a large undertaking. As with any large organisation, the HSE have multiple systems, which store this information across many regions and facility types. Because of this, the HSE undertook a large project to consolidate as much logistics activity, as possible, into a central National Distribution Centre (NDC).
HSE required a Data Warehouse to hold purchasing information from all parts of the HSE. To achieve this, Sogeti and HSE designed a Data Warehouse to hold this information. Sogeti built Extract, Transform and Load (ETL) processes on Microsoft SQL Server and SQL Server Integration Services, to collect and process data from multiple data sources, like SAP. The ETL processes transform the data from these multiple sources, into a more homogenous format. Views were created to extract and process the data in the Warehouse, so that the HSE QlikView visualisation team can display the data in an easily readable format.
Sogeti built a robust ETL, Data Warehouse and .Net solution to allow HSE to report accurately on their procurement data on a national level and to view individual purchases at a granular level. The system is designed with robust error handling to allow it to run with minimal support or intervention. HSE procurement can analyse purchasing data, find savings opportunities, and then Project Manage the creation and running of frameworks and contracts, in a .Net application, to realize savings.
The Health Service Executive (HSE) is responsible for the provision of health and personal social services for everyone living in Ireland, with public funds.
HSE is Ireland's largest employer with over 67,000 direct employees, and another 40,000 in funded health care organisations. It has an annual budget of over €13 billion, more than any other public sector organisation.