Senior Consultant
In the period from April 2007 through June 2008, consultancy work was delivered through Miracle, where the focus was on developing and operating data warehouse and ETL deliveries in Oracle environments. The work was performed on-site, primarily at Islands Brygge for HK and later in the period at Maersk in Esbjerg, with a base in Ballerup. The delivery format ensured that clarifications and progress were driven in practice through collaboration with other consultants from Miracle as well as the client's stakeholders, ensuring that solutions could be implemented and function within the clients' operations rather than becoming incomplete design exercises.
The task was solved as a consultancy delivery from Miracle A/S during the period from April 2007 through June 2008, where the purpose was to establish and maintain a BI data foundation that could be used for reporting and analysis within the clients' environments—avoiding "one-off" solutions—and ensuring that deliveries were both operationally stable and understandable so they could be continued and developed subsequently.
At HK, a data warehouse for reporting on unemployment benefit payments was delivered. The work was performed in collaboration with colleagues, utilizing Oracle Warehouse Builder to build and maintain ETL processes on an Oracle database, allowing reporting to be based on a consistent and maintainable data foundation rather than ad hoc extractions.
A central part of the task was the development and maintenance of ETL processes, using Oracle Warehouse Builder and DataStage as tools for data management and integration. The focus was on ensuring data moved correctly from sources to the reporting layer, while ensuring runs could be executed stably, re-run in a controlled manner, and troubleshot without all knowledge residing with just one person.
Data modeling and continuous optimization of data flows were part of the delivery, where structures and transformation logic had to support reporting and analysis. The goal was to establish a model and flow that could withstand changes in the data foundation and requirements without complexity growing unnecessarily from release to release.
Solutions were developed for integrating data from various sources into analytical systems, including support and troubleshooting for existing BI solutions. In practice, this meant existing logic had to be understood quickly, discrepancies traced, and fixes implemented without creating hidden side effects in other parts of the data flow.
Later in the period, work was delivered at Maersk in Esbjerg, where the purpose was to establish a foundation for reporting on oil rig performance. The delivery involved structuring data and making it usable in reporting without inventing details about measurement points or KPI definitions that were not specified.
The work was performed on-site, primarily at HK on Islands Brygge and later at Maersk in Esbjerg, with a base in Ballerup. The primary interfaces were other consultants at Miracle and the client's stakeholders, ensuring that clarifications and prioritizations could be made close to both the delivery and its practical application.
Miracle A/S (including Miracle Projects) was during this period a Danish IT and consultancy house delivering advice and development across digital solutions and platforms. The task was solved in a classic consultancy context with deliveries at client sites. Today, Miracle appears as part of itm8, where the former Miracle 42 organization is included under the itm8 brand, meaning that in practice, one encounters the company as part of a larger Nordic IT group.
Official site: https://itm8.dk/brand/miracle42