Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Timeline
Generic

Goran Shoan

Data Engineer/Data Analyst
Stockholm

Summary

Detail-focused Data engineer and Data Analyst with more than 10 years of experience. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Data on both On-premis and Cloud environments

Overview

10
10
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
5
5
Languages

Work History

Data Manager

European Centre For Disease Prevention And Control
8 2023 - 07.2024
  • Optimized database performance with regular maintenance, updates, and optimizations.
  • Created and maintained PowerBI reports, Databases, and Tables
  • Evaluated potential software solutions against established criteria, recommending options that met organizational needs most effectively.
  • Conducted thorough audits of existing databases, identifying areas for improvement and addressing discrepancies as needed.
  • Trained team members in best practices for data handling, improving overall productivity and data integrity.

Data Analyst

Naturvårdsverket/the Swedish Environmental Protect
04.2024 - Current
  • Created a new Business intelligence Environment from Start.
  • Assisted in data modelling.
  • Created PowerBI reports and Database tables.
  • Participated in requirements meetings to understand business needs.
  • Established consistent naming conventions and metadata standards for improved organization and searchability of data resources.

System Architect BI

Sveriges Lärare/Sweden's Teachers' Union
08.2021 - 08.2023
  • Created data models for the data warehouse
  • Worked with business requirements
  • Led efforts to standardize development processes across teams, fostering a more cohesive working environment and promoting best practices adoption.
  • Worked with Data warehouse, ETL, PowerBI, SQL, Azure and Kimball modelling


Business Intelligence Developer & analyst

Karolinska Universitetssjukhuset
03.2019 - 10.2021
  • Fullstack development in IBM planning analytics, SSIS, Tableau and SQL
  • Developed and managed dashboards using Tableau processed by SSIS from the datawarehouse
  • Generated reports, updated spreadsheets, and presented results.
  • Translated complex technical concepts into easily understandable terms for non-technical stakeholders during presentations and meetings.

BI/DW Developer

Finansinspektionen
06.2016 - 03.2019
  • Business Intelligence development using SAS as ETL tool and as visualization tool
  • Participated in regular SQL code reviews, ensuring high-quality standards were consistently met across all development efforts.
  • Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
  • Optimized database structures for efficient data storage and retrieval.

Business Intelligence Consultant

Knowit
12.2015 - 04.2016
  • Business intelligence development using SAS software
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Collected data from wide-ranging sources.

Business Intelligence Consultant

NextBridge Group AS
04.2014 - 08.2014
  • Business intelligence development using SQL-server
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Collected data from wide-ranging sources.
  • Handled massive quantities of business intelligence data

Education

Master's degree - Information Technology (Systemvetenskap)

Lund University
Lund Swede
01.2011 - 04.2013

Bachelor's degree - Information Technology (Systemvetenskap)

Lund University
01.2008 - 04.2011

Skills

Data Engineering

Snowflake

DevOps

SQL Databases

Tableau

ETL processes

Statistics and SAS

Data and Analytics

SQL and Databases

Business Intelligence

PowerBI

ADF

SSIS

Kimball

DAX

Python

Certification

Microsoft Certified: Power BI Data Analyst Associate

Accomplishments

    Snowflake

  • Hands-On Essentials: Data Engineering Workshop
  • Hands-On Essentials: Data Application Builders Workshop
  • Hands-On Essentials: Data Lake Workshop
  • Hands-On Essentials: Collaboration, Marketplace & Cost Estimation Workshop
  • Hands-On Essentials: Data Warehousing Workshop

Timeline

Data Analyst

Naturvårdsverket/the Swedish Environmental Protect
04.2024 - Current
Microsoft Certified: Power BI Data Analyst Associate
06-2023
Microsoft Certified: Azure Fundamentals
11-2022

System Architect BI

Sveriges Lärare/Sweden's Teachers' Union
08.2021 - 08.2023

Business Intelligence Developer & analyst

Karolinska Universitetssjukhuset
03.2019 - 10.2021

BI/DW Developer

Finansinspektionen
06.2016 - 03.2019

SAS Certified Base Programmer

04-2016

Business Intelligence Consultant

Knowit
12.2015 - 04.2016

Business Intelligence Consultant

NextBridge Group AS
04.2014 - 08.2014

Master's degree - Information Technology (Systemvetenskap)

Lund University
01.2011 - 04.2013

Bachelor's degree - Information Technology (Systemvetenskap)

Lund University
01.2008 - 04.2011

Data Manager

European Centre For Disease Prevention And Control
8 2023 - 07.2024
Goran ShoanData Engineer/Data Analyst