Business Intelligence: Azure Synapse, SSAS Tabular, Power BI, DAX, SQL Server, SSIS, Datenmodellierung
Aktualisiert am 23.05.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.06.2024
Verfügbar zu: 100%
davon vor Ort: 0%
SQL
Power BI
Azure
SSAS Tabular
SSIS
MS SQL Datenbankadministration
Synapse
Deutsch
Muttersprache
Englisch
Verhandlungssicher
Spanisch
Grundkenntnisse

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 Jahr 5 Monate
2023-02 - heute

BI Support

BI Consultant Python T-SQL Scrum ...
BI Consultant
  • Migration of business logic (Synapse) to facilitate data mesh architecture.
  • Supporting migration of architecture (Synapse vs. Databricks).
  • Development/adjustments of Power BI Reports.
Azure Synpase Power BI Theobald DevOps
Python T-SQL Scrum parquet
Carl Zeiss AG
Wien
1 Jahr 6 Monate
2023-01 - heute

BI Support

BI Consultant T-SQL DAX Parquet
BI Consultant
  • Harmonization of multiclient queries in Power BI. Adaptation of ETL pipeline in Synapse.
  • Deployment and adaptation of ISV BI models (sales, finance, inventory, purchase, ...).
  • Direct collaboration with Microsoft Dynamics F&SCM consultants.
Azure Synapse Power BI DevOps Dynamics F&SCM
T-SQL DAX Parquet
Wikotool Group
Wien
3 Jahre 5 Monate
2021-02 - heute

BI Support

BI Consultant T-SQL DAX parquet
BI Consultant
  • Design of client scalable ETL process, model structure and permission concept.
  • Development of ETL processes and analytical model based on Microsoft technology.
  • Enabling key users to analyze various datamarts including: sales, orders, shipment,
  • invoice, credit notes, inventory and purchase in Power BI and Excel.
Azure Synapse Power BI Business Central DevOps
T-SQL DAX parquet
Dr. Oetker
Wien
5 Jahre 7 Monate
2018-12 - heute

BI Support

BI Consultant DAX T-SQL MDX
BI Consultant
Datawarehouse adaptations in T-SQL.
Continuous BI support (SSAS, Power BI, Paginated Reports).
MS SQL Datenbanken MS SQL Server Analysis Services Power BI Power BI Paginated Reports
DAX T-SQL MDX
Hefel Textil GmbH
Wien
4 Jahre 1 Monat
2019-01 - 2023-01

BI Support

BI Consultant T-SQL DAX MDX ...
BI Consultant
Design and development of an analytical data model and corresponding ETL processes
with a focus on contribution margin analysis. Enabling users to analyze complex

intercompany CM allocations with planned/actual comparisons in Excel and Power BI.


Design and development of an extensive Order-to-Cash analytical model based on SAP
R/3. Enabling users to track Orders through delivery, shipment, invoice and payment
processes AND vice versa. Design and development of a two dimensional permission
concept.
MS SQL Server Analysis Services MS SQL Datenbanken Power BI Report Server SAP R/3 SSAS MS SQL Server Integration Services
T-SQL DAX MDX VBA
Lenzing AG
Lenzing

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 10 Monate
2016-09 - 2019-06

Informations- und Kommunikationssysteme

Bachelor of Science in Engineering (BSc), FH Technikum Wien
Bachelor of Science in Engineering (BSc)
FH Technikum Wien

Specialization: Machine Learning

Bachelor Thesis: "Degree program recommendation based on multinomial Naive Bayes"

2 Jahre 10 Monate
2012-09 - 2015-06

Marketing & Sales

Bachelor of Arts in Business (B.A.), FH Wien der WKW
Bachelor of Arts in Business (B.A.)
FH Wien der WKW
Bachelor thesis: "Erfolgsfaktor Erlebnishandel im kundenfrequenzschwachen Einzelhandel der Bekleidungsindustrie"

Position

Position

I am helping people organize their data structures and data streams so that they can operate more efficiently. I started out in 2019 mainly working on on-prem solutions. Since 2021 my focus shifted to cloud based architectures (Microsoft Azure stack). I am dedicated and passionate about the solutions I am developing. Colleagues, clients and supervisors enjoy working with me. I am a hands-on person with an IT and business related academic background.

Kompetenzen

Kompetenzen

Top-Skills

SQL Power BI Azure SSAS Tabular SSIS MS SQL Datenbankadministration Synapse

Schwerpunkte

T-SQL
Fortgeschritten
Power BI
Fortgeschritten
Azure Synapse
Fortgeschritten
Databricks
Basics
SQL Databank
Fortgeschritten
SSIS
Fortgeschritten
SSAS Tabular
Fortgeschritten
SSAS Multidimensional
Basics
DevOps
Fortgeschritten

Branchen

Branchen

Textilindustrie -> Herstellung und Verkauf

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 Jahr 5 Monate
2023-02 - heute

BI Support

BI Consultant Python T-SQL Scrum ...
BI Consultant
  • Migration of business logic (Synapse) to facilitate data mesh architecture.
  • Supporting migration of architecture (Synapse vs. Databricks).
  • Development/adjustments of Power BI Reports.
Azure Synpase Power BI Theobald DevOps
Python T-SQL Scrum parquet
Carl Zeiss AG
Wien
1 Jahr 6 Monate
2023-01 - heute

BI Support

BI Consultant T-SQL DAX Parquet
BI Consultant
  • Harmonization of multiclient queries in Power BI. Adaptation of ETL pipeline in Synapse.
  • Deployment and adaptation of ISV BI models (sales, finance, inventory, purchase, ...).
  • Direct collaboration with Microsoft Dynamics F&SCM consultants.
Azure Synapse Power BI DevOps Dynamics F&SCM
T-SQL DAX Parquet
Wikotool Group
Wien
3 Jahre 5 Monate
2021-02 - heute

BI Support

BI Consultant T-SQL DAX parquet
BI Consultant
  • Design of client scalable ETL process, model structure and permission concept.
  • Development of ETL processes and analytical model based on Microsoft technology.
  • Enabling key users to analyze various datamarts including: sales, orders, shipment,
  • invoice, credit notes, inventory and purchase in Power BI and Excel.
Azure Synapse Power BI Business Central DevOps
T-SQL DAX parquet
Dr. Oetker
Wien
5 Jahre 7 Monate
2018-12 - heute

BI Support

BI Consultant DAX T-SQL MDX
BI Consultant
Datawarehouse adaptations in T-SQL.
Continuous BI support (SSAS, Power BI, Paginated Reports).
MS SQL Datenbanken MS SQL Server Analysis Services Power BI Power BI Paginated Reports
DAX T-SQL MDX
Hefel Textil GmbH
Wien
4 Jahre 1 Monat
2019-01 - 2023-01

BI Support

BI Consultant T-SQL DAX MDX ...
BI Consultant
Design and development of an analytical data model and corresponding ETL processes
with a focus on contribution margin analysis. Enabling users to analyze complex

intercompany CM allocations with planned/actual comparisons in Excel and Power BI.


Design and development of an extensive Order-to-Cash analytical model based on SAP
R/3. Enabling users to track Orders through delivery, shipment, invoice and payment
processes AND vice versa. Design and development of a two dimensional permission
concept.
MS SQL Server Analysis Services MS SQL Datenbanken Power BI Report Server SAP R/3 SSAS MS SQL Server Integration Services
T-SQL DAX MDX VBA
Lenzing AG
Lenzing

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 10 Monate
2016-09 - 2019-06

Informations- und Kommunikationssysteme

Bachelor of Science in Engineering (BSc), FH Technikum Wien
Bachelor of Science in Engineering (BSc)
FH Technikum Wien

Specialization: Machine Learning

Bachelor Thesis: "Degree program recommendation based on multinomial Naive Bayes"

2 Jahre 10 Monate
2012-09 - 2015-06

Marketing & Sales

Bachelor of Arts in Business (B.A.), FH Wien der WKW
Bachelor of Arts in Business (B.A.)
FH Wien der WKW
Bachelor thesis: "Erfolgsfaktor Erlebnishandel im kundenfrequenzschwachen Einzelhandel der Bekleidungsindustrie"

Position

Position

I am helping people organize their data structures and data streams so that they can operate more efficiently. I started out in 2019 mainly working on on-prem solutions. Since 2021 my focus shifted to cloud based architectures (Microsoft Azure stack). I am dedicated and passionate about the solutions I am developing. Colleagues, clients and supervisors enjoy working with me. I am a hands-on person with an IT and business related academic background.

Kompetenzen

Kompetenzen

Top-Skills

SQL Power BI Azure SSAS Tabular SSIS MS SQL Datenbankadministration Synapse

Schwerpunkte

T-SQL
Fortgeschritten
Power BI
Fortgeschritten
Azure Synapse
Fortgeschritten
Databricks
Basics
SQL Databank
Fortgeschritten
SSIS
Fortgeschritten
SSAS Tabular
Fortgeschritten
SSAS Multidimensional
Basics
DevOps
Fortgeschritten

Branchen

Branchen

Textilindustrie -> Herstellung und Verkauf

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.