Main tasks include consultation and implementation of Data Vault 2.0 architectural solutions, specification of such projects, architectural/entity modelling, implementation and pre-sales. Platforms range from Azure to Snowflake and on-prem.Main customers & industry during Netum-time:1. Medium sized Finnish welfare area with 15+ source systems and a multi yearMulti-year Data Vault 2.0 modelling and implementation project that produced the data structure for their business & knowledge based reporting. During the project we gathered process information i.e. of their hospital & doctor/personnel functions, access of treatment, effectiveness of visits & overall gathered a comprehensive image of the treatment given in the area. Used code automation & conceptual modelling to handle the large data model and keep metadata based documentation of the DV 2.0 architecture.Worked as a primary developer, measure & calculations specifier and data architect for the environment. Additionally helped the project management from a technical point of view (specific definitions for implementation, workload estimates and customer interviews). Main methods included WhereScape DV Express (conceptual model based code automation) & Data Vault 2.0 creation. Snowflake cloud solution.2. Finnish welfare area with over six source systems (well decentralized, both data and expertise). During the project we gathered process information i.e. of their hospital & doctor/personnel functions, access of treatment, effectiveness of visits & overall gathered a comprehensive image of the treatment given in the area. Used conceptual model to combine the various source systems & business definitions under one architecture that created the data model itself. Then this centralised solution provided datasets for dozens of PBI reports & over 150 measures. In the project I worked as a leading technical manager, data modeller & data architect. On-prem SQL-data solution.

Main tasks include consultation and implementation of Data Vault 2.0 architectural solutions, specification of such projects, architectural/entity modelling, implementation and pre-sales.Main customer & industry during Cerion-time:1. Finnish welfare area with over six source systems (well decentralized, both data and expertise). During the project we gathered process information i.e. of their hospital & doctor/personnel functions, access of treatment, effectiveness of visits & overall gathered a comprehensive image of the treatment given in the area. Used conceptual model to combine the various source systems & business definitions under one architecture that created the data model itself. Then this centralised solution provided datasets for dozens of PBI reports & over 150 measures. In the project I worked as a leading technical manager, data modeller & data architect.

Consulting on how to manage a business based on information & how to utilize data and analytics at its best. Specialized in product (ownership of) WhereScape tools & software as well as implementing Data Vault environments. Functioning also as an implementing developer and architect with the Microsoft, WhereScape and Azure data tools.Main customer & industry during Fellowmind-time:Large prepared food manufacturer; Multi-year Data Vault 2.0 modelling and implementation project that produced the data structure for their business & knowledge based reporting. Primary developer and data architect for the environment & technical project lead. WhereScape DV Express (conceptual model based code automation) & Data Vault 2.0 creation.Additionally, I mentored newer developers in the magic of cloud based & automated data warehousing.

Consulting on how to manage a business based on information & how to utilize data and analytics at its best. Specialized in product (ownership of) WhereScape tools & software as well as Data Vault implementations. Functioning also as an implementing developer and architect with the Microsoft, WhereScape and Azure data tools.Customers & industry cases:1. Large prepared food manufacturer; Multi-year Data Vault 2.0 modelling and implementation project that produced the data structure for their business & knowledge based reporting. Primary developer and data architect for the environment & technical project lead. WhereScape DV Express (conceptual model based code automation) & Data Vault 2.0 creation.2. National airfield services and personnel/security provider; 2nd main developer on the project with quite complex business cases and logic + medium sized data with fast refresh rates & need for fast updates to report as well! Dimensional model datamart in Azure cloud + Power BI reports for it. Tight production schedule and happy customer (note recommendation from Otto Sardén).

Consulting on how to manage a business based on information & how to utilize data and analytics at its best. Functioning also as an implementing developer and architect with the Microsoft, WhereScape and Azure data tools.Customers & industry cases:1. Large (private) prepared food manufacturer; Multi-year Data Vault 2.0 modelling and implementation project that produced the data structure for their business & knowledge based reporting. 2ndary developer and data architect for the environment & project(management wise). WhereScape DV Express (conceptual model based code automation) & Data Vault 2.0 creation.2. National airfield services and personnel/security provider; 2nd main developer on the project with quite complex business cases and logic + medium sized data with fast refresh rates & need for fast updates to report as well! Dimensional model datamart in Azure cloud + Power BI reports for it. Tight production schedule and happy customer (note recommendation from Otto Sardén).3. Large private glass manufacturing company; Star schema modelling, reporting & exact specs for their production lines. 2ndary developer & business definer.

Consulting on how to manage a business based on data, analytics and AI. Functioning also as an implementing developer with the Microsoft & Azure data tools.Customers & industry cases:1. Nationwide private childcare chain; Developed a star-schema data mart & PBI reporting on it for them. (On-prem SQL)2. National airfield services and personnel/security provider; 2nd main developer on the project with quite complex business cases and logic + medium sized data with fast refresh rates & need for fast updates to report as well! Dimensional model datamart in Azure cloud + Power BI reports for it. Tight production schedule and happy customer (note recommendation from Otto Sardén).

Business Intelligence and analytics emphasized junior consultant working for HR Analytics team at CGI Finland.Mentionable projects/fields:1. Did a presales PBI-dashboard with measures for university of applied sciences, which they ended up buying from CGI.2. HR-analytics, modelling and measures for various customers. (Note recommendation from Minna Hirvonen) Various PowerBI POCs and demos. Also worked as the administrator for document management and customer contact sites. Additionally during employment, I studied and worked with DAX and the basics of R.

Trainee in HR Analytics team: Working on data validation, testing, document management, scrum and product developmental tasks such as creating POCs.During traineeship I also made a thesis for the company, in which I created Occupational Healthcare Dashboards with authentic customer data. The grade for this thesis project was 5 (on the scale of 1 to 5, 5 being the highest grade).

The firm was a small recruitment startup where I worked on a marketing & publicity project and made market research for various subjects.

Re-packaging and sales renovation also on multiple summers before this.

Military Service of 12 months in the armored brigade of Parola.