IT Systems Consultant (Maternity Cover)
During the period from March 2004 to August 2005, I provided maternity cover at Danmarks Radio, where the focus was on creating a stable data foundation by extracting and integrating data from a new license system into a data warehouse, while simultaneously building data flows for business areas via Oracle Warehouse Builder, and where reporting and consumption were addressed with Oracle Discoverer, ensuring consistency between the source system, data processing, and reporting in a setup delivered on-site at TV Byen, 2860 Søborg.
The task was performed at Danmarks Radio during the period from March 2004 to August 2005, where the goal was to establish a data foundation that could support reporting and follow-up in the license area, and where a central driver was making data from a new license system available in a data warehouse, so one could work consistently with payments, payers, and discrepancies instead of being dependent on manual extractions and local knowledge.
A significant part of the work involved sourcing systems and getting data from the new license system into the data warehouse environment, which in practice meant that the data foundation, mapping, and data deliveries had to be clarified and implemented so that data could be reused across different reporting needs without creating parallel truths.
A solution was modeled and populated covering license payments and license payers, focusing on identifying missing payments as part of the data foundation, so follow-up and reporting could be based on a structured model rather than being a separate, manual exception process.
Data flows for relevant business areas were implemented via Oracle Warehouse Builder, and the focus was on making ETL and data integration function stably so that deliveries could be executed predictably and adjusted when source data or needs changed.
Transformation logic was realized with PL/SQL where it made sense to keep logic close to the database, and where the goal was to implement rules and transformations in a way that could be troubleshot, documented, and continued without everything being locked to a single tool or individual.
Reporting was delivered using Oracle Discoverer, so consumers could work on a consistent data foundation, and reports could be built around the models and deliveries established in the data warehouse environment instead of pulling directly from source systems.
The work was performed on-site at TV Byen, 2860 Søborg, as maternity cover, and the primary interfaces were the DWH team (3 people) and the license team, which in practice meant that clarifications regarding data definitions, mappings, and reporting needs could be made close to both the data foundation and the domain, which is crucial in a license setup where small definitions quickly turn into large discrepancies.
Danmarks Radio (DR) is the national public radio and television broadcaster in Denmark, and DR produces and broadcasts radio and television programs as well as digital content services to a wide audience, making DR a central part of Denmark's media landscape with responsibility for a varied range of news, culture, entertainment, and specialized content.