Germo Görtz - BI Developer

Recommended expert

Berlin, Germany

Experience

Jul 2023 - Present

2 years 7 months

BI Developer

Rhenus Logistics

Business intelligence development in the logistics sector.
Migrating existing reporting and analysis solutions from Cognos to Microsoft BI.
Using Microsoft SQL Server, SSAS, Power BI, and other Microsoft BI platform components.

Mar 2023 - Jul 2023

5 months

BI Developer

softwareONE

BI development and migration projects in the Microsoft BI environment.
Migration from SSAS OLAP to SSAS Tabular to Power BI Premium.
Migrating an on-premise data warehouse to a data lakehouse.
Using Microsoft SQL Server, SSAS, Power BI, and lakehouse technologies.

Nov 2022 - Dec 2022

2 months

Microsoft BI / Data Modeling Coach

TÜV Rheinland i-sec GmbH

Coaching on data modeling with SSAS and Power BI.
Coaching on Microsoft BI and Microsoft SQL Server.
Advising on best practices for data models, DWH layers, and reporting.

Sep 2022 - Dec 2022

4 months

Microsoft Power BI Consultant

Kerkhoff Experts GmbH

Conducted a quick scan for procurement.
Designed and built a spend cube with Microsoft Power BI.
Supported analysis, visualization, and evaluation of procurement data.

May 2022 - Jan 2023

9 months

Microsoft BI Architect and Developer

Nomura Asset Management Europe KVG mbH

Built a new data warehouse and migrated data and processes from an existing DWH.
Designed and implemented ELT processes with AnalyticsCreator.
Used Microsoft SQL Server (on-premise) as the DWH platform.
Used AnalyticsCreator for DWH, ELT, and SSAS structures.
Employed DataHandwerk for automated, versioned documentation.
Used Antora for Docs-as-Code documentation.
Versioned code with Git.

Mar 2022 - Apr 2022

2 months

Microsoft BI Consultant

Betty Barclay

Support for Microsoft SQL Server and Business Intelligence.
Building and customizing DWH and reporting solutions.
Use of Microsoft SQL Server (on-premise) and Power BI.
Use of BimlExpress to automate DWH/ETL development.
Version control with git.

Jan 2022 - Apr 2022

4 months

Microsoft BI Consultant

Roller

Support for Microsoft SQL Server and Business Intelligence in a retail environment.
Building and customizing DWH and reporting components.
Use of Microsoft SQL Server (on-premise) and Power BI.
Use of BimlExpress to generate SSIS/DWH structures.
Version control with git.

Aug 2021 - Jun 2022

11 months

Microsoft BI Consultant

SYSKRON - im House of Krones

Support for Microsoft SQL Server and Business Intelligence.
Building and further development of DWH and reporting solutions.
Use of Microsoft SQL Server (on-premise) and Power BI.
Use of DataHandwerk for automated, versioned documentation.
Use of Antora for docs-as-code.
Version control with git.
Use of Jira for task and project management.

Aug 2021 - Dec 2021

5 months

Microsoft BI Architect and Developer

abcfinance

Design and proof of concept for a comprehensive "Source-to-Target" documentation of the central data warehouse across multiple layers (including Data Vault, star schema, tabular models).
Building a versioned documentation solution enriched with metadata and business information.
Providing interfaces for business units to administer and use the documentation.
Linking the documentation with information from source systems within ETL/ELT processes.
Support for implementation of the solution and introduction of a suitable tool.
Development of processes and workloads to generate and update the documentation.
Use of Microsoft SQL Server (on-premise).
Use of DataHandwerk, Antora, git, and TFVC.

Apr 2021 - Jun 2021

3 months

Power BI Expert

Peter Hahn GmbH

Conducting and facilitating workshops on BI requirements.
Advising on the creation of mappings and BI implementations.
Translating business requirements into technical BI solutions.
Collaborating with other subprojects and providing results.
Use of Microsoft SQL Server (on-premise) and Power BI.
Use of TFVC for version control.

Feb 2020 - Mar 2021

1 year 2 months

Microsoft BI Architect and Developer

MEAG - Munich ERGO Assetmanagement GmbH

Development of a reporting tool with Power BI for automated report generation from SimCorp Dimension.
Replaced Excel-based reporting with an automated BI reporting system.
Built DWH, ELT processes, and SSAS structures with AnalyticsCreator.
Developed individual modules in Python and PowerShell.
Used Microsoft SQL Server (on-premise).
Utilized AnalyticsCreator and Power BI.
Managed versions with git.

Nov 2019 - Dec 2019

2 months

Microsoft BI Architect and Developer

Würth Logistics AG

Created a reporting data warehouse with AnalyticsCreator for logistics data.
Built a SQL Server DWH and an analytical database (SSAS Tabular) as the basis for flexible reporting with Power BI or other front ends.
Coached internal developers to independently extend the DWH using AnalyticsCreator.
Connected an operational logistics DWH (Oracle) as the main data source; planned additional connections (e.g. SAP).
Used Microsoft SQL Server (on-premise), AnalyticsCreator, and git.

Sep 2019 - Present

6 years 5 months

Microsoft BI Architect and Developer

iconcare (BInovis & Visality)

Architected and developed Microsoft BI solutions in healthcare, hospital, and logistics environments.
Developed and improved the Hospital Process Analyzer for managing hospital processes.
Optimized OR planning and control, focusing on early detection and handling of process issues.
Carried out process and time analyses (e.g. OR times, OR turnover times, OR utilization, staff utilization).
Built and used a data warehouse with Microsoft SQL Server.
Created reports and dashboards with Microsoft Power BI.
Used Microsoft Fabric for modern cloud-based BI architectures.
Developed smart home solutions for "assisted living" using smart meters and time analyses of power consumption.
Used HomeAssistant, IoT approaches, and MQTT.
Used Microsoft SQL Server (on-premise) and Python for data processing and automation.

Sep 2019 - Mar 2020

7 months

Microsoft BI Developer

Swisscom

Imported and processed data from ServiceNow for reporting.
Connected to ServiceNow via API using Python.
Built a data warehouse in Microsoft SQL Server to integrate and transform the data.
Created an analytical database with SSAS.
Developed reports with Power BI.
Used AnalyticsCreator for DWH, ELT, and SSAS.
Used Microsoft SQL Server (on-premise), AnalyticsCreator, git, and Jira.

Oct 2018 - Sep 2019

1 year

Microsoft BI Architect and Developer

Provinzial Nord-West

Set up a new data warehouse as a Microsoft BI analytics platform.
Hosted the new DWH on Microsoft Azure, based on Microsoft SQL BI technologies.
Used Microsoft SQL Server (relational, SSAS, SSIS) on-premise and in the Azure cloud.
Used Power BI and AnalyticsCreator.
Worked with big data scenarios.
Used Jira and git for project and code management.

Aug 2018 - Oct 2018

3 months

Microsoft BI Architect and Developer

ZEISS Group

Analysis and optimization of throughput times for production steps.
Redesigned an existing Power BI solution into a data warehouse and SSAS Tabular architecture to optimize performance and extend analysis capabilities.
Combining logic in the data warehouse (Microsoft SQL Server) and in SSAS Tabular.
Built data warehouse, ELT processes, and SSAS structures using AnalyticsCreator.
Used Microsoft SQL Server (on-premise), AnalyticsCreator, Power BI, TFVC, and Git.
Supported the use of Microsoft Azure services, migration of SSAS solutions to Azure, and ETL/ELT tasks.

Nov 2017 - Jul 2018

9 months

Microsoft BI Architect and Developer

Adecco Germany Holding SA & Co. KG

Extended an existing data warehouse by adding a "Candidate Cube".
Gathered business requirements and created specifications.
Implemented technical solution including ETL processes using SSIS.
Built cubes with SSAS and reports with SSRS.
Used AnalyticsCreator for data warehouse, ELT, and SSAS.
Prepared for a possible migration to Azure.
Used Microsoft SQL Server (relational, SSAS, SSIS) on-premise, Power BI, AnalyticsCreator, and TFVC.

May 2017 - Nov 2017

7 months

Microsoft BI Architect and Developer, Data Scientist

Adam Opel GmbH

Project "Churn Prevention" for predicting churn rates (switching to other manufacturers) and analyzing customer behavior.
Used Data Vault, data mining, and prediction methods.
Built data warehouse and ETL processes with Microsoft SQL Server (relational, SSAS, SSIS).
Visualized and reported using Power BI.
Created data warehouse, ELT, and SSAS structures with AnalyticsCreator.
Used TFVC or Git for version control.

Apr 2017 - May 2017

2 months

Power BI Consultant

Kuhn und Bülow Versicherungsmakler Group

Set up the foundations for statistics and reports using Power BI.
Created analyses for policyholders, insurers, claims, and premiums based on operational system data.
Used Power BI.
Used TFVC for version control.

Sep 2016 - Dec 2016

4 months

Microsoft BI Architect and Developer

airberlin

Project "Customer Segmentation, Ancillaries" to analyze customer segments and ancillary services.
Built data warehouse and analytics solutions with Microsoft SQL Server 2014 (relational, SSAS, SSIS) on-premise.
Used Jira and TFVC for project management and version control.

Jul 2016 - Jun 2017

1 year

Microsoft BI Architect and Developer

Kelvion

Architecture and programming of SSAS databases for a planning system in connection with Tagetik.
Use of Microsoft SQL Server 2016 (relational, SSAS, SSIS, SSRS) on-premise.
SAP integration with cMORE/Connect for SAP (Theobald SAP Integration).
Use of cMORE/XL (XLCubed), Targit, and Power BI as frontends.
Version control with Git.

Jun 2016 - Jul 2016

2 months

Microsoft BI Consultant / Data Mining Specialist

proXcel GmbH

Support in analyzing, processing, and evaluating complex data sets of a production process.
Use of the Microsoft BI analytics platform and data mining methods.
Use of Microsoft SQL Server and analysis tools in the BI environment.

May 2016 - May 2016

1 month

Microsoft BI Consultant

Heraeus Kulzer

BI support in the Microsoft BI analytics platform environment.
Use of Microsoft SQL Server (relational, SSAS, SSIS) on-premise.
Version control with TFVC.

Mar 2016 - Sep 2018

2 years 7 months

Microsoft BI Architect and Developer

ZEISS Group

Work in the BICC (BI Competence Center) for dashboards and BI analytics platform.
Building ETL processes, data warehouse, and reports (dashboards) for project controlling with Datazen.
Importing data from SAP and Essbase.
SAP integration with cMORE/Connect for SAP (Theobald SAP Integration).
Use of Datazen and Microsoft SQL Server (on-premise).
Use of TFVC.
Main project from 03/2016 to 04/2016, then ongoing support until 09/2018 including migration to ServiceNow.

Jun 2015 - Mar 2016

10 months

Microsoft BI Architect and Developer, Data Scientist

Volkswagen Gebrauchtfahrzeughandels und Service GmbH (VGSG)

Work in the BI Competence Center for Volkswagen Commercial Vehicles.
Data mining and use of neural networks to predict market values (residual value management) and sales volumes for used Volkswagen commercial vehicles and leased vehicles.
Projects DML (Data Mining Leasing) and DM VGSG (Data Mining VGSG, young used vehicles).
Use of Statistica for data mining and neural networks.
Building visualizations with Tableau (standard reports, dashboards, decision support).
BI development with Microsoft SQL Server (relational, SSAS, SSIS) on-premise.
Use of Wherescape and TFVC or Jira.
Scientific background documented, among others, in publications on predicting residual values with artificial neural networks.

Aug 2012 - May 2015

2 years 10 months

Microsoft BI Architect and Developer

Henkel AG & Co. KGaA

Project SCOUT (Supply Chain Optimization Unified Toolbox) in the supply chain area.
Development of metrics and analysis applications for:
Inventory
Order to Cash
Physical Distribution
Forecast Accuracy
Product Availability
Days of Supply
Slow Mover Detection for financial write-downs.
Migration and especially extension of an application from SAP BW to Microsoft SQL Server.
BI design and development with Microsoft SQL Server 2012 on-premise (focus on SSAS, datamarts, also SSIS).
Reporting with XLCubed.
SAP integration with cMORE/Connect for SAP (Theobald SAP Integration).
Use of TFVC.

Oct 2011 - Apr 2012

7 months

BI Developer

MTS (Mobile TeleSystems OJSC)

Project for purchase controlling and procurement performance management.
Topics: Procurement Performance Management (PPM), spend control, supplier consolidation.
Development of analytical solutions with Microsoft SQL Server and SSAS (on-premise).
Use of DWH and OLAP technologies to analyze purchasing and supplier data.

Feb 2011 - May 2012

1 year 4 months

Microsoft BI Architect and Developer

Nestlé Suisse S.A

Project "Dynamic Planning Framework - Dynamic Forecast".
BI concept, design and development with Microsoft SQL Server 2005/2008 (ETL, staging, data warehouse).
Performance tuning of DWH and reporting components.
Activities include: requirements analysis, concept design, communication with business units, development, documentation, testing, performance optimization, maintenance and consulting.
Use of Microsoft SQL Server 2005 and 2008 R2 (on-premise).

Nov 2010 - Dec 2019

9 years 2 months

Microsoft BI Architect and Developer

DRK Kliniken Berlin

Build and further development of a hospital data warehouse.
Concept and implementation of analytical applications for:
Materials management
Occupancy information
Operations and DRG information system
Construction and investment controlling
OR management (planning, utilization, turnover times, etc.)
Monthly reporting
Financial planning and projections.
Migration of BI applications from SQL Server 2000 to SQL Server 2008 R2.
Training of users and ongoing support.
Current regular support to ensure operations until full migration to a clinical DWH of the HIS vendor.
Data sources include: Orbis (HIS) and others.
Activities include: planning, controlling, requirements analysis, concept design, communication with business units, performance optimization, reporting, documentation, testing.
Use of Microsoft SQL Server 2008 R2 (relational, SSAS, SSIS, SSRS), Microsoft Access, Cubeplayer and Subversion.

Nov 2010 - Feb 2011

4 months

Microsoft BI Architect and Developer

otto group

Project P4P CoreDWH (datamarts and reports) for multichannel retail, financial services and service.
BI concept, design and development with Microsoft SQL Server.
Activities: requirements analysis, concept design, communication with business units, development, documentation, testing, performance optimization, maintenance and reporting.
Use of Microsoft SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise.

Sep 2010 - Nov 2010

3 months

Microsoft BI Architect and Developer

Krones AG

Migration of an order entry statistics from SAP BW to Microsoft SQL Server.
BI design and development with Microsoft SQL Server.
Conducting requirements analyses.
Use of Microsoft SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise.
SAP integration with cMORE/Connect for SAP (Theobald SAP Integration).
Use of TFVC (presumably) for version control.

Jan 2010 - Aug 2010

8 months

Microsoft BI Architect and Developer

Henkel AG & Co. KGaA

Projects GLOBIS (Global Business Information System) and COLOR (Common Local Profitability Reporting).
BI design and development with Microsoft SQL Server.
Requirements analysis and design.
Use of Microsoft SQL Server 2008 R2 (relational, SSAS, SSIS) on-premise.

Oct 2008 - Dec 2009

1 year 3 months

Microsoft BI Architect and Developer

Rudolf Wöhrl AG

Collaboration in the BI team (controlling, finance, IT).
Development of applications for personnel controlling and workforce planning.
Migration from Microsoft SQL Server 2000/2005 to SQL Server 2008 (on-premise).
Setup of reporting system with Bissantz DeltaMaster.
Use of Subversion (presumably) for version control.
Working with various data sources.

Oct 2005 - Aug 2012

6 years 11 months

Microsoft BI Architect and Developer

Bezirkskliniken Mittelfranken, Ansbach

Design and implementation of analytical applications for controlling and HR in psychiatric hospitals.
Focus on controlling and central HR.
Development of applications for:
Financial controlling
Business planning
Personnel data controlling
Occupancy controlling
Medical controlling of psychiatric and somatic cases.
Ongoing support of BI applications.
Migration from Microsoft SQL Server 2000 to SQL Server 2005 and 2008 (on-premise).
Data sources including: Orbis (KIS), PWS (personnel data), Excel and others.
Use of Microsoft SQL Server (2000, 2005, 2008), MSAS/SSAS, DTS/SSIS.
Use of Bissantz DeltaMaster and Subversion.

Oct 2005 - Dec 2011

6 years 3 months

Microsoft BI Architect and Developer

HGC GesundheitsConsult GmbH

Freelance work as a business analysis (BI) expert in hospitals.
Partner history: GfS (Gesellschaft für Standortsicherung) → HGC GesundheitsConsult GmbH → Vendus.
Project contents:
Hospital controlling
Medical controlling.
Design and development of data models, analysis methods and reporting systems including for:
Market and competition controlling of medical services
Service structure and KPI comparisons (benchmarking)
Referrer controlling
Controlling of medical treatment paths / care paths
Financial controlling
Case-based cost accounting (case gross revenue, contribution margins, full costs)
Business planning
Personnel data and occupancy controlling
Service comparisons within corporate groups/clinic networks.
Data sources: various, including SAP, Orbis, text files, Excel.
Use of Microsoft SQL Server (2000, 2005, 2008) relational, MSAS/SSAS, DTS/SSIS (on-premise).
Use of Bissantz DeltaMaster and Subversion.

Sep 2005 - Jan 2009

3 years 5 months

Microsoft BI Architect and Developer

Landwirtschaftliche Rentenbank

IT application development in the area of data warehouse and OLAP.
Design of production processes (workflows, use of Subversion), development standards and test concepts.
Further development of the data warehouse and OLAP applications.
Migration from Microsoft SQL Server 2000 to SQL Server 2005.
Situation and requirements analysis of business needs.
Development of business and technical concepts.
Planning and conducting training for practical work with OLAP databases.
Main focus areas: IAS and HGB financial statements, controlling, money trading and securities issuance.
Data sources: iSeries (AS 400).
Activities: requirements analysis, design, communication with business units, development, documentation, testing, performance optimization, maintenance and reporting.
Use of Microsoft SQL Server 2000 (relational, MSAS, DTS) and SQL Server 2005 (relational, SSAS, SSIS, SSRS) on-premise.
Use of MIS Plain, Datawarehouse Explorer and Subversion.

Sep 2004 - Oct 2004

2 months

Microsoft BI Architect and Developer

ID GmbH

Development of an analytical add-on module for a DRG grouper including scenario and cost modules.
Data sources include Section 21 data, IMC data or other formats, optional case-related cost data.
Use of Microsoft SQL Server 2000 (relational, DTS, MSAS) on-premise.
Use of Excel and Cubeware Analysesystem as frontends.

Jan 2004 - May 2004

5 months

BI Architect and Developer

MIS GmbH

Design and implementation of the "§21-DRG-Analyse" for hospitals.
Industry: healthcare / hospitals.
Data sources: Section 21 data, IMC data, evaluation data from DRG groupers, optional case-related cost-performance data.
Data warehouse: Microsoft SQL Server.
ETL: T-SQL, DTS.
OLAP databases: Microsoft Analysis Services (MSAS), MIS Alea.
Frontends: MIS Onvision, MIS Plain.

Jan 2004 - Apr 2004

4 months

BI Architect and Developer

VzE - Verein zur Errichtung evangelischer Krankenhäuser

Design, modeling and management of relational and analytical databases for medical controlling, DRG controlling and reporting.
Coaching on using various frontends (MIS Plain, MIS Onvision) to create reports.
Conducting training on software use and working with the databases.
Data sources: various (including Section 21 data, manual sources, SAP).
Data warehouse: Microsoft SQL Server.
ETL: T-SQL, DTS.
OLAP databases: Microsoft Analysis Services (MSAS).
Frontends: MIS Onvision, MIS Plain.

Jan 2003 - Apr 2010

7 years 4 months

Microsoft BI Architect and Developer

Vivantes GmbH - Netzwerk für Gesundheit

Setup and management of the central financial and DRG reporting system for a hospital group.
Business units include controlling, cost center accounting, quality and process management.
Technical design, modeling and management of the central financial and DRG reporting systems.
Coaching users on using the frontends for reporting.
Ongoing support as well as conducting training and workshops for working with OLAP databases.
Migration from Microsoft SQL Server 2000 to 2005.
Data sources include SAP, Excel, text files, Access.
Activities: requirements analysis, design, communication with business units, development, documentation, testing, performance optimization, maintenance and reporting.
Use of Microsoft SQL Server 2000 (relational, MSAS, DTS) and SQL Server 2005 (relational, SSAS, SSIS) on-premise.
Use of Bissantz DeltaMaster, Softpro CubePlayer, MIS Plain, MIS Onvision, MIS Integration Framework and Subversion.

Sep 2001 - Dec 2003

2 years 4 months

BI Architect and Developer

KCC (via MIS GmbH)

Design, development and support of the "DRC" (Diagnosis Related Costs) for various cost accounting views in hospitals.
Objective: cost calculation similar to DRGs (revenue side) including contribution margin calculations.
Deployment of the DRC solution in various hospitals.
Data sources: different systems depending on the hospital.
Data Warehouse: Microsoft SQL Server.
ETL: T-SQL, DTS, Microsoft Access, Microsoft Excel.
OLAP databases: Microsoft Analysis Services (MSAS).
Frontends: MIS Onvision, MIS Plain.

May 2001 - May 2004

3 years 1 month

BI Architect and Developer

Medienhaus Aschendorff (via MIS GmbH)

Design and implementation of an advertising information system (AIS) for a newspaper publisher.
Design, modeling and support of the analytical database and its ETL processes.
Extension of an existing data warehouse (VIVAinfo based on VI&VA) to populate the analytical database.
Support and training for using MIS Plain for reporting.
Data sources: VI&VA (SAP-based operational extension for publishers) and other sources.
Data Warehouse: Microsoft SQL Server.
ETL: T-SQL and DTS.
Analytical database: Microsoft Analysis Services (MSAS).

Jan 2001 - Dec 2001

1 year

BI Architect and Developer

MIS GmbH

Design and implementation of the "MIS Business Solution for Hospitals".
Data Warehouse: Microsoft SQL Server.
ETL: T-SQL, DTS.
Analytical databases: MIS Alea, Microsoft Analysis Services (MSAS).

Sep 2000 - Mar 2002

1 year 7 months

BI Developer

Märkische Oderzeitung (via MIS GmbH)

Setup of an advertising information system (AIS) based on VI&VA data for a publisher.
Data sources: SAP, VI&VA.
ETL: Microsoft Access, Microsoft Excel.
Analytical database: MIS Alea.
Frontend: MIS Alea Excel Integration.

Dec 1999 - Sep 2000

10 months

Technical Project Lead / BI Architect

Deutsche Telekom (via MIS GmbH)

Migration of an analytical application from MIS Alea to Microsoft Analysis Services (then MS OLAP Services) while keeping the existing reporting.
Technical project lead for the migration.
Data Warehouse: Microsoft SQL Server.
ETL: T-SQL, DTS.
Analytical databases: MIS Alea and Microsoft OLAP Services.
Frontend: MIS Alea Excel Integration.

Sep 1999 - Sep 2004

5 years 1 month

Full-time BI Architect and Developer

MIS GmbH

Permanent position as a BI Architect and Developer in a consulting firm.
Responsibilities:
Customer and project acquisition, initial contact meetings and presentation of services offered.
Supporting prospects at events, conducting acquisition workshops.
Preparing proposals and performing situational analysis at the client's site.
Gathering business and technical requirements.
Developing business and technical concepts.
Conducting concept workshops.
Implementing analysis and reporting systems.
Taking on project responsibility and technical project leadership.
Implementing solutions using common database technologies and programming languages.
Aligning solutions with the project team and customers.
Designing and delivering customized client training.
Multiple migrations from MIS Alea to Microsoft Analysis Services 2000 (MSAS).
Executing numerous BI projects in various industries (e.g., healthcare, publishing, telecommunications, energy, insurance, banking).

Summary

BI architect and developer with Microsoft BI AISBERG – analytical information systems and consulting in healthcare (and other industries). Excellence through skilled craftsmanship instead of assembly line, technocracy instead of democracy, trust in experts. As a medical cyberneticist, I am "cybernetic in thinking and acting": I analyze target vs actual, identify different paths, consider causes and effects, detect disturbances and react to them. Social skills, quick comprehension, and ambition ensure that technical requirements are understood precisely and implemented with maximum customer satisfaction: competent, goal-oriented, out-of-the-box and nonconformist thinking, analytical, precise, responsible, independent, fast, effective, and efficient.

Skills

Business Intelligence (Bi, Business Analysis), Including Requirements Analysis, Architecture, Design, Setup And Implementation Of Data Warehouses (Dwh), Data Lakehouses (Databricks, Data Lake), Elt (Extract, Load, Transform), Etl, Data Models, Analytic Methods, Planning Systems, Reporting Systems, And Implementation Of Business Processes And Logic
Automated Versioned Documentation With Datahandwerk Docsgenerator (Combining Technical And Business Documentation; Asciidoc, Antora; Docs As Code)
Technical Implementation Of Regulatory Requirements (Historization, Versioning, Data Lineage, Gdpr, Etc.)
Automation Of Data Import And Export, Elt, Code Generation, Dwh And Documentation
Microsoft Sql Server, Including Ssas (Sql Server Analysis Services), Ssis (Sql Server Integration Services), Ssrs (Sql Server Reporting Services)
Microsoft Azure And Various Azure Services Around The Microsoft Bi Platform
Other Software And Technologies Around The Microsoft Bi Platform And For Development
Programming And Query Languages For Databases: Transact-sql (T-sql), Mdx (Multidimensional Expressions), Dax (Data Analysis Expressions)
Datahandwerk-toolkit-mssql (Open-source Project, Including Database Documentation Generator)
Git (Version Control System); All Projects Versioned By Default, Preferably On Gitlab
Software And Technologies For Creating And Maintaining Documentation, Especially Antora (Docs As Code) Based On The Asciidoc Markup Language
Preferred Front Ends: Microsoft Power Bi (Microsoft Front End For Reporting), Xlcubed (Excel Add-in For Ssas)
Azure Devops For Devops, Agile Project Control, Issue Tracking, And Code Versioning
Microsoft Fabric And Power Bi Services (Cloud-based Bi Platform Built On Onelake)
Data Modeling With Dimensional Modeling (Dm) As Part Of The Business Dimensional Lifecycle Methodology By Ralph Kimball
Data Modeling Following Data Vault
Deep Experience With Multidimensional Databases (Olap, Cubes, Dimensions) Since 1999, As Well As With Tabular Databases (Ssas Tabular, Power Pivot, Power Bi) And Pragmatic Use Of Tabular And Olap Depending On Requirements
Use Of Mdx For Multidimensional And Tabular Models, And Dax For Ssas Tabular

Languages

German

Native

English

Advanced

Russian

Elementary

Education

Pirogov Russian National Research Medical University

Diploma in Medicine, Biophysicist, Medical Cyberneticist · Medical Cybernetics · Moscow, Russian Federation

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Vitali Haberkorn