Summary
Overview
Work History
Education
Skills
Work Skills
Tableau Skills
Certification
Timeline
Generic

Andrée Roos

Senior Tableau/Data Engineer Consultant
Gothenburg

Summary

Andrée is a senior business intelligence consultant with a wide knowledge around IT and Analytics. He has great knowledge of tools as well as defining processes and can take all roles ranging from project leader to developer. His main knowledge revolves around Tableau, Alteryx, AWS, Exasol, SAS, Web Analytics, Statistics and general programming. He is one of very few certified Tableau trainers in Sweden and have managed classes all around Scandinavia. He is comfortable in several roles ranging from solution architect and business development to system development. He is skilled, self-going, full of creativity, curious, motivated and generates a positive attitude around projects. He has worked in several areas: retailing, telecom, financial, logistics, biomed, bank, energy, transport, traffic etc. where he have been taking different roles.

Overview

25
25
years of professional experience
6
6
years of post-secondary education
4
4
Certifications
2
2
Languages

Work History

Tableau Architect / Mentor / Developer

Universum
07.2024 - Current
  • Providing expert guidance in using Tableau to automate a costly manual process. This was done by creating an architecture from source data to programmatically generate reports in Powerpoint.
  • Building Tableau datasources using source data from Snowflake and Salesforce environments.
  • Creating Python scripts for automated Powerpoint exports.
  • Building up company Tableau competence assisting with dashboard building.

Tableau / MS SQL / SAS Developer

Nordax
02.2024 - Current
  • Creating and maintaining dashboards aiming at reducing credit risk.
  • Creating and optimizing MS SQL and SAS data flows.
  • Cleaning up and optimizing existing MS SQL structure
  • Importing external data through API's. (SCB)

Senior Tableau Developer

Novamedia
08.2022 - Current

About the customer

Novamedia sets up and operates postcode lotteries worldwide to raise funds for charity


Role

  • Mentoring and assisting in the process of converting Qlik-reports into Tableau dashboards.
  • Leading training for Tableau Explorers


Tools/Services

Tableau Desktop, Tableau Online, Tableau Bridge, PostgreSQL

Tableau Architect / Developer

Apoteket AB
12.2017 - Current

About the customer

The second largest pharmacy retailer in Sweden


  • Responsible for implementing Tableau in the organization both from a technical standpoint as well as building building processes. Managing the entire Tableau system, building analyses in cooperation with business.
  • Implementing advanced analytics including AWS workflows used for analyzing large datasets. Leading and developing several analytical areas such as: Market basket analysis, Network analysis, Linear regression, Trade areas, Geographical competitor analysis etc.
  • Leading training with separate groups -> Viewers, Explorers, Creators
  • Assisting business in achieving analytical goals in a role as business analyst
  • Building an analytical community through Teams and regular social sessions.

Business areas

Financial ,Purchasing, Logistics, Sales, Store localization, Internet


Tools/Services

Tableau Desktop, Tableau Server, Oracle, Exasol,Tableau API, TabPy, TabJolt, Google Analytics, Google Geocoding API



Tableau Presale Activities

Several customers
01.2014 - Current

Role

  • Tableau presale and upstart activities.
  • Including Testing, Devloping, Mentoring, Demonstrating , Developing Tableau for different stakeholders
  • Assignments usually between 1-6 months
  • Often competing with other BI vendors.


Customers

Apoteket AB, Ericsson, Lindex, Kapp-Ahl, ICA-banken, White Architects, Stena Metall, Belid...

Tableau Trainer

Tableau Software
01.2014 - Current

About the customer

One of the worlds largest business intelligence applications


Roles

  • Leading official Tableau training sessions in Sweden and Norway.
  • Training sessions were both in Fundamental and Intermediate levels.

Tableau Trainer

ICA Sverige
04.2022 - 10.2022

About the customer

Sweden's largest retailer


Role

  • Working with a group that assist stores with marketing analytics.
  • Tableau training and mentoring
  • Helping out with technical issues around Tableau Dashboards


Senior Tableau Developer

Volvocars
01.2021 - 08.2022

About the customer

A unit within Volvocars that analyzes marketing efforts worldwide.


Role

  • responsible for creating dashboards aiming towards analyzing email marketing efforts. Mainly working with Salesforce Marketing Cloud data.
  • Working with the integration of financial account data from SAP
  • Being part in starting up a large project aiming at creating a large analytical platform towards Marketing & Brand data

Tools

AWS, Athena, Snowflake, Tableau Desktop, Tableau Server, Salesforce Marketing Cloud, Google Analytics, AWS S3, AWS Glue, Alation, Alteryx Designer

Tableau Developer/ Mentor

NWT
01.2018 - 06.2022

About the customer

NWT Media is one of Sweden's leading media houses


Role

  • Presale and upstart activities
  • Training sessions for different stakeholders.
  • Building a foundation for further development of the Tableau platform

Tableau Architect / Trainer / Developer

ICA Sverige
04.2017 - 02.2019

About the customer

Sweden's largest retailer


Role

  • Being leader establishing Tableau platform and processes in a large deployment covering ca 2000 users. Setting up processes, technical foundation and training in an effort to create a complete selfservice business intelligence environment.
  • Building up processes around training and social networking around the Tableau products as well as leading training sessions within several parts of the organization.
  • Assisting junior analysts/developers in modelling very large datasets in a way that Tableau can handle.
  • Performance testing through Tabjolt.
  • Working with security hardening and penetration testing.

Tools

Tableau Server, Tableau Desktop, Tabjolt, AirWatch , Okta, Cloudera

Tableau Performance Optimization

Optilon
11.2016 - 05.2017

About the customer

Implementing planning software for optimizing supply chains.


Roles

  • Helping out with a complicated Tableau application aiming at optimizing permformance with IKEA's supply chain strategy
  • Assisting with general Tableau development

Tableau Developer / Mentor / Trainer

Ericsson AB
04.2015 - 01.2016

About the customer

Department within Ericsson performing Performance Management.


Role

  • A pilot project introducing Tableau in the performance management area.
  • Supporting efforts in internal marketing around the Tableau platform. Leading sessions towards the chinese and american business units.
  • Creating and assisting with analytical dashboards measuring programming performance, bugs and tracking equipment versioning.

Tableau Developer

Volvocars
01.2015 - 01.2016

About the customer

A unit within Volvocars that analyzes sales


Role

  • Creating dashboards aiming towards analyzing sales data withing Volvocars.

Tools

Tableau Desktop, Tableau Server, MS SQL Server

Tableau Developer / Presale

Polygon
08.2014 - 08.2015

About the customer

A major worldwide player in property damage control, providing solutions to prevent, control and mitigate all kinds of property damage


Role

  • Presale and upstart activities
  • Training sessions for different stakeholders.
  • Building a foundation for further development of the Tableau platform
  • Creating dashboards within finance and sales

SAS Programmer

Volvofinans Bank
01.2011 - 07.2012

About the customer

Bank with focus on financing car purchases


Role

  • SAS Programmer within different parts of the organisation
  • Participating in large project to migrate from MS SQL Server to SAS Financial Data Model.
  • Creating risk analysis through Visual Basic for Applications (VBA)

SAS Developer

Statoil
01.2010 - 08.2011

About the customer

A Norwegian state-owned multinational energy company


Role

  • SAS Programmer creating dataflows and SAS-programs aimed at analyzing oil prospecting

SAS Developer

Posten Norge
01.2009 - 06.2010

About the customer

Posten Norge Group is a Nordic group for mail handling and logistics


Role

  • SAS Programmer creating dataflows and analytics for logistics
  • Participating in a project to accommodate the change from weighting to counting letters.


SAS Developer / Administrator

Telia Mobile
01.2006 - 12.2009

About the customer

A major mobile operator by revenue and customer base


Role

  • SAS Programmer within different parts of the organizations
  • Assisting analytical efforts within the company through SAS
  • Maintaining the SAS database and ETL processes.

Analyst / Programmer

Ecowin / Reuters
01.2000 - 01.2006

About the customer

Retrieval and sales of financial and economic data


Role

  • Parsing websites for data through C#-programming
  • Creating Excel add-on for assisting data retrieval using VBA
  • Creating programs/statistical algoritms for validating data using C#


Education

Bachelor of Science - Statistics And Economics

Handelshögskolan I Göteborg
Göteborg
01.1992 - 01.1998

Skills

    Tableau / Alteryx

AWS

Statistics

Programming

MS SQL

General Database

Work Skills

Project Leader / BA - Leading business intelligence, Team Lead

Tableau - Advanced visualizations, Predictions, Modelling Python, Advanced mapping, Embedding, Metadata Repository/API

Tableau Server/Cloud - Updating, Monitoring, Scheduling, Exporting visuals, Triggering schedules/Extracts through batch-scripts/Powershell / Python, Load Testing, Slack streaming, Security Hardening

Alteryx - Advanced use, Spatial, Statistics, Macros, Batch Macros, Iterative Macros, Custom Python Tools

Power BI - Data visualization / dashboards

Exasol - LUA/Python scripting, Virtual Connections, DB Admin 

Salesforce - CRM Analytics, Prediction, Optimization with Einstein Discovery

AWS - EC2, Linux, Security Groups, S3, AWS Glue, Lambda functions, Policies/Roles

SAS - SAS Base, Data Integration Studio, Enterprise Guide, Statistical Functions

Programming - Python, Batch script, Powershell, C#, Visual Basic

Databases- Snowflake, Oracle,...and more

Statistics - Clustering , Linear Regression, Market Basket Analysis, t-test, similarity scoring, factor analysis, PCA, decision trees

Advanced mapping - Map services (Mapbox / WMS), Creating custom map areas, using Google map API, drivetime isochrones

General - Microsoft Office, Excel, Teams, Onenote, Apache Drill, Mapbox, DBeaver, 


Tableau Skills

Teaching - Courses for all levels  Creator / Explorer / Viewer

TabPy - Using Python functions (dynamic network graphs / predictions etc.

Market Basket Analysis - Creating dynamic analysis using large datasets (apriori / itemsets)

Tableau Built-in predictions - Bayes, Linear Regression

Advanced graphics / Flow charts - Using sinus / sigmoid functions

Tableau Repository - Analyzing Tableau Server interaction, usage reports, creating BI success measures

Advanced mapping - Map services (Mapbox / WMS), Creating custom map areas, using Google map API, drivetime isochrones

Embedding - Embedding visuals in custom web solutions

Tableau Server - Updating, monitoring, scheduling, exporting visuals, triggering schedules/extracts through batch-scripts/powershell / Python

Web Data Connector -  Creating custom data connectors

Load Testing -  Creating custom data connectors

Security Hardening -  Applying configuration to secure in-house server environment

Tableau Cloud -  Understanding pros/cons of using Tableau Cloud instead of Tableau Server


Certification

Tableau Desktop Qualified Associate

Timeline

Tableau Architect / Mentor / Developer

Universum
07.2024 - Current

Tableau / MS SQL / SAS Developer

Nordax
02.2024 - Current

Senior Tableau Developer

Novamedia
08.2022 - Current

Tableau Trainer

ICA Sverige
04.2022 - 10.2022

Exasol Certified Associate

01-2022

Senior Tableau Developer

Volvocars
01.2021 - 08.2022

Tableau Desktop Qualified Associate

01-2021

Tableau Developer/ Mentor

NWT
01.2018 - 06.2022

Tableau Server Qualified Associate

01-2018

Tableau Architect / Developer

Apoteket AB
12.2017 - Current

Tableau Architect / Trainer / Developer

ICA Sverige
04.2017 - 02.2019

Tableau Performance Optimization

Optilon
11.2016 - 05.2017

Tableau Certified Trainer

01-2016

Tableau Developer / Mentor / Trainer

Ericsson AB
04.2015 - 01.2016

Tableau Developer

Volvocars
01.2015 - 01.2016

Tableau Developer / Presale

Polygon
08.2014 - 08.2015

Tableau Presale Activities

Several customers
01.2014 - Current

Tableau Trainer

Tableau Software
01.2014 - Current

SAS Programmer

Volvofinans Bank
01.2011 - 07.2012

SAS Developer

Statoil
01.2010 - 08.2011

SAS Developer

Posten Norge
01.2009 - 06.2010

SAS Developer / Administrator

Telia Mobile
01.2006 - 12.2009

Analyst / Programmer

Ecowin / Reuters
01.2000 - 01.2006

Bachelor of Science - Statistics And Economics

Handelshögskolan I Göteborg
01.1992 - 01.1998
Andrée RoosSenior Tableau/Data Engineer Consultant