Business Intelligence Consultant
In the period from September 2005 through August 2006, consultancy work was delivered through Oracle Denmark (where the work was performed on-site in Ballerup) involving two complete Oracle tracks depending on the context: partly Oracle BI EE as a unified solution capable of handling both data processing and reporting within the same toolchain, and partly a setup where Oracle Warehouse Builder managed ETL and data integration while Oracle Discoverer was utilized for reporting. Oracle Database and transformation logic in PL/SQL formed the foundation, while Raptor (the predecessor to SQL Developer) served as a practical tool for testing queries directly against the database before implementation. Deliveries were driven in collaboration with other consultants and client stakeholders, ensuring solutions were operationally stable and extensible without data quality and predictability becoming an afterthought.
The task was solved as a consultancy delivery from Oracle Denmark during the period from September 2005 through August 2006, aiming to establish and maintain a complete BI delivery on the Oracle platform (covering data processing, integration, and reporting) in a manner that was operationally stable and extensible, ensuring that data quality and predictability were not things discovered only when something went wrong.
Two complete tracks were utilized depending on the context: Oracle BI EE functioned as a unified solution handling the entire flow within the same toolchain, while an alternative track consisted of Oracle Warehouse Builder for ETL and integration combined with Oracle Discoverer for reporting. In practice, both tracks could deliver an end-to-end solution but with different distributions of responsibility and components.
A central part of the work involved the implementation and maintenance of ETL and data integration, using Oracle Warehouse Builder and Oracle BI EE as tools to realize the data flow. Oracle Database and PL/SQL formed the foundation for the data foundation and transformation logic, allowing data to be structured and transformed to withstand repeated runs, debugging, and ongoing changes without the solution becoming fragile or opaque.
Reporting was handled either directly in Oracle BI EE (when the OBIEE track was chosen) or via Oracle Discoverer in combination with OWB, focusing on keeping reporting close to a consistent data foundation so that consumption did not become dependent on random extracts or manual intermediate calculations.
As a practical part of the delivery, Raptor (the predecessor to SQL Developer) was used to run queries directly against the database, allowing logic and results to be validated before being placed into the tools, which reduced implementation friction and made errors more visible early in the process.
The work was performed on-site in Ballerup, and the primary interfaces were other consultants and the client's relevant stakeholders, suiting a consultancy setup where clarifications, prioritizations, and changes typically need to be translated quickly into adjustments in data flow and reporting without losing context along the way.
Oracle Denmark was the Danish branch of the Oracle Corporation (which provides database technology and associated platforms and tools for data integration, reporting, and enterprise IT). In practice, Oracle Denmark served as the framework for consultancy deliveries on the Oracle stack, where one meets product, platform, and professional services within the same ecosystem—reflecting Oracle's description of itself as a provider of a complete technology stack (database, platform, and cloud).
Official site: https://www.oracle.com/