Data Engineer

Lowell – Raunow Consulting ApS
November 2021-Present
Data Engineer

• Data Engineer working as an external consultant for Lowell on establishing a cloud-based data analytics platform on Microsoft Azure.
• Main role is supporting the data migration and data architecture development on Microsoft Azure. This includes tasks such as database backup, maintenance of database servers and data migration pipelines, writing and review of documentation and maintenance of reports monitoring various aspects of cloud resource usage and access.
• Constructing and maintaining reports monitoring active directory access, data quality checks, azure resource usage and data movement pipelines.
• Implementing a data retention procedure for an on-prem SQL database and the downstream data lake o Building an azure function used for comparing and identifying discrepancies between glossary terms that are registered in Azure Purview in multiple environments. 
• DevOps and CICD design and setup.

Technological highlights: Data Factory, Databricks, MS SQL Server, Azure SQL Server, Azure Synapse Analytics, Powershell scripting, PowerBI, Azure DevOps, GitHub.

Danske Bank – Raunow Consulting ApS 

Marts 2022 – Present
Data Architect

• Working in direct support of high-level design architecture by producing architectural documentation and verification and viability POCs.
• Assessed the viability of using Spline package (https://absaoss.github.io/spline/) to track data lineage on AWS Data Lakes.
• Contributed to submitting documentation describing how target data architecture complies with the client’s Enterprise Data Architecture principles.
• Created data flow diagrams describing a variety of the systems implemented in the client’s overall data architecture.  

Technological highlights: Draw.IO, Microsoft Visio.

NpInvestor.dk – Raunow Consulting Aps 

November 2022 – December 2022
Data Engineer

• Data Engineer working as an external consultant on the underlying data infrastructure of the website. 
• Fixed a data update issue, collected, and filled in historical data that was missing because of said issue. 
• Monitored and verified the adequate performance of the cloud resources on which the website infrastructure was built to rule out the possibility of this infrastructure being the cause of website downtime.

Technological highlights: AWS EC2, AWS RDS.

Elixir Tools and Data Services Registry – DTU
November 2022 – December 2022
Student Assistant

• Student Assistant participating in the expansion of the Elixir Tools and Data Services Registry, specifically the bio.tools registry.
• Identified and added over 200 new tools to the registry.
• Contributed to maintaining up to date ORCID identifiers for the underlying publications of the registered tools.

Technological highlights: GitHub, CRAN.

PROSYS Group – DTU
January 2018 – July 2018
Master Student

• Master thesis on the study of multi-mineral precipitation in fermentation broths with the aim of creating a software tool that can predict the kinetics of mineral precipitation in the broths, a project that was a collaboration between the group and Novozymes.
• I performed the precipitation experiments, collected, and analysed the data generated and used it to establish the mathematical models to be implemented in the software tool.
• In the first phase I performed titration experiments on and proof of concept design to validate the modelling approach used.
• In the second phase I moved on to using an experimental broth composition for the experiments and managed to successfully predict mineral precipitation within the broth.
• Initially water analysis kits were used to measure ion concentrations, however these proved to be largely inaccurate, so the final measurements were done using ICP-MS instead.
• I was commended by my supervisors for being able to handle both data acquisition (experiments and analysis) and data modelling for the project.

Technological highlights: MatLab, pH titration, ICP-MS, Fermentation Processes.

Department of Pharmacy – KU
November 2012 – June 2013
Master Student

• Master thesis on developing a chemometrics-based model that can detect and quantify particle segregation in pharmaceutical powders using NIR-Spectroscopy. The project was part of the move towards establishing tools to ensure good manufacturing practices in the pharmaceutical industry. 
• I conducted the experimental part of the project on a mixture of cellulose and caffeine to establish a proof of concept for the model. The experiments were done for varying particle sizes of the two components. I used various custom experimental setups to test the viability of the model.
• I used a chemometrics-based approach for the model development. This involved using tools such as MatLab and LatentiX for chemometric analysis. The viability of the model was assessed by comparing model predictions to actual initial concentrations for the experimental setups. 

Technological highlights: LatentiX, MatLab, Chemometrics, NIR-Spectroscopy.

Organic Chemistry Department – “Politehnica” University of Timisoara
September 2010 – June 2011
Bachelor Student

• Bachelor thesis on the synthesis of asymmetric tioethers with pharmaceutical properties and the design of an installation for diethylchlorosuccinate production.
• I conducted organic synthesis experiments in an attempt to obtain novel tioethers with pharmaceutical properties.
• I used diethyl chlorosuccinate as a reactant for etherification. The various methods I tried out in it's synthesis led to the publication of an article in the University’s chemical bulletin.
• As part of the project requirements, I also designed an installation for the synthesis of diethyl chlorosuccinate. The installation design consisted of mass and thermal balance calculations for the synthesis reaction and the construction of a diagram for the entire production process.

Technological highlights: AspenHySis, Organic Chemistry, Gas Chromatography, GC-MS, Thin-layer Chromatography, IR-Spectroscopy.

Region H – Bartholin Institute 

July 2015 – September 2015 

Research Assistant

• Research Assistant working on a research project to develop immunotherapeutic treatments for Type I Diabetes.
• As a research assistant I participated in daily tasks necessary for the continuation of the project: cell culturing, isolation of immune factors from animal blood plasma through Gel-Chromatography, administration of treatment to laboratory animals and monitoring treatment performance, in-vitro experiments on antibody function.
• I successfully recovered and processed months-worth of experimental data from NOD-mouse treatments that had been poorly collected.

Technological highlights: Gel Chromatography, Affinity Chromatography, ELISA.

Photonics Department – DFM A/S
January 2015 - Marts 2015
Research Assistant

• Research Assistant working in support of the company’s role as a provider of metrological standards and consulting.
• I built a graphical user interface for a mass flow meter device that is used for the mixing of gas standards. This first required the calibration of the device and implementation of said calibration into the graphical user interface. The entire work was done using Python.
• I validated a tuneable light filter by interfacing it with a spectrophotometer and a CCD camera and taking measurements of colour standards. The entire setup was built and automated using MatLab. 

Technological highlights: Python, MatLab, UV-VIS Spectroscopy.