Marco Skulschus

Business Analyst, Data Warehouse Developer

Zug, Switzerland
Experience
Jan 2024 - Jun 2025
1 year 6 months
Düsseldorf, Germany

Business Analyst, Data Warehouse Developer

NRW Bank

  • Business analysis for risk controlling.
  • DWH development based on MS SQL Server, data from FIS® Cross-Asset Trading and Risk Platform (formerly Front Arena).
  • Development in T-SQL and Python (Jinja2 template engine).
  • Modeling and automation with Data Vault.
  • Reporting with MS Power BI, training and rollout.
  • Key technologies and methods: MS SQL Server, Data Vault, UML, T-SQL, Python, FIS Cross-Asset Trading and Risk Platform, MS Power BI.
  • Project scope: 50-100%.
Aug 2023 - Aug 2024
1 year 1 month
Lindenberg im Allgäu, Germany

MS Power BI Developer, Data Warehouse Developer

Liebherr-Aerospace Lindenberg GmbH

  • Migrated QlikSense reports to MS Power BI and redeveloped reports following reporting guidelines.
  • Further developed a DWH in MS SQL Server with SSIS, SSAS, T-SQL.
  • Visualized and analyzed production, machine and ERP data.
  • Key technologies: MS SQL Server, Analysis Services Tabular Model (SSAS), MS Power BI, DAX.
  • Project scope: 25-50% (Detail: 75% part-time).
Jun 2022 - Dec 2023
1 year 7 months
Hanover, Germany

MS Power BI Developer, Oracle Developer

HDI / Talanx AG

  • Migrated IBM Cognos Report Studio to Microsoft Power BI using Oracle DB as data source.
  • Developed with Oracle SQL and PL/SQL.
  • Analyzed data from business processes.
  • Key technologies: Oracle DB, MS Power BI.
  • Project scope: 25% (Detail: 25-50% part-time).
Jan 2022 - Present
3 years 7 months
Zug, Switzerland

Managing Director, BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer

Comelio Swiss GmbH

Jun 2021 - Dec 2023
2 years 7 months
Stans, Switzerland

MS Power BI Developer, Data Warehouse Developer

SoftwareOne AG

  • Replaced existing MS SQL Server Analysis Services OLAP cubes and SSRS reports with an Azure-based solution using SSAS Tabular and MS Power BI, including SQL Server database development and MS Azure Data Factory with Power Query/M for data integration, analysis, and visualization of Microsoft Dynamics CRM data.
  • Automated processes with MS Power Automate.
  • Supported migration from SSAS and MS SQL Server to Databricks.
  • Collaborated continuously with teams in India.
  • Key technologies: MS SQL Server, SSAS Tabular Model, MS Power BI, DAX, statistics with R.
  • Project scope: 50-100% (Detail: full-time then 50% part-time).
Jul 2020 - Oct 2020
4 months
Berlin, Germany

XML Consultant

Cornelsen Verlag GmbH

  • Consulting and development for a digitalization project of schoolbooks.
  • XML single-source publishing with DITA, oXygen, XSLT and Schematron, technical consulting, quality assurance.
  • Modeling with BPMN/UML.
  • Key technologies (table): XML single-source publishing with oXygen, DITA, XSLT, XML Schema/Schematron.
May 2020 - May 2021
1 year 1 month
Munich, Germany

Data Warehouse Developer

E.ON Energie Deutschland GmbH

  • Further developed and modeled a Data Warehouse solution with Snowflake and SnowSQL.
  • Data integration with Python/XSLT for contract, customer and market data.
  • Key technologies: Snowflake DB, SnowSQL, Python/XSLT, MS Power BI.
  • Project scope: 100% (Detail: full-time then 50% part-time).
May 2020 - Aug 2020
4 months
Berlin, Germany

Web Developer

Comelio GmbH

  • PHP web development, PostgreSQL, XML integration, XSLT, Bootstrap.
Apr 2020 - Jul 2020
4 months
Mülheim, Germany

Data Integration Specialist, Team Lead

Siemens Gas and Power GmbH

  • Consulting and development for document management and XML single-source publishing.
  • XML data integration and transformation with Altova MapForce, XSLT and Python across applications for power plant planning and construction.
  • Key technologies (table): XML data integration, Altova MapForce, Python.
Jun 2019 - May 2020
1 year
Vienna, Austria

Data Warehousing Specialist

Bundesrechenzentrum GmbH Arbeitsmarktservice

  • Modeled and developed Data Warehouse with Oracle (legacy) and MS SQL Server for labor market data using Data Vault modeling.
  • T-SQL and MDX programming and SSAS for OLAP.
  • Automation and modeling with WhereScape Red and WhereScape 3D.
  • Key technologies: MS SQL Server, Oracle, WhereScape Red, WhereScape 3D, T-SQL, PL/SQL, MDX, SSAS.
  • Project scope: 100%.
Apr 2018 - Mar 2020
2 years
Munich, Germany

Business Intelligence Specialist

PlanetHome GmbH

  • Modeled, designed and developed a self-service BI platform based on MS SQL Server 2017 Azure (Azure Data Lake, Azure Data Factory) and MS Power BI.
  • Modeled with SSAS Tabular Model and DAX, and used R and Shiny for visualization and forecasting for marketing analyses in real estate and market data.
  • Replaced T-SQL and MDX calculations in SSAS with DAX.
  • Key technologies: MS SQL Server, MS Power BI, DAX, T-SQL and R, Azure Data Lake/Data Factory.
  • Project scope: 50%.
Apr 2018 - May 2019
1 year 2 months
Munich, Germany

Data Integration Specialist

Loyalty Partner GmbH (PayBack)

  • Developed configurable data integration solutions with SSIS and T-SQL for Navision on MS SQL Server 2014 for billing with PayBack partners and for the data warehouse.
  • Key technologies: MS SQL Server, T-SQL, SSIS, ETL.
  • Project scope: 50%.
May 2016 - Apr 2018
2 years
Kiel, Germany

Data Warehousing Specialist

HSH Nordbank AG

  • Data Vault modeling, created interfaces with Talend and added Java/PL/SQL Apex programming to various banking systems to build a central data platform for statistical analysis of customers, deals, risks, payments and regulatory reporting.
  • Documented domain-specific language for automatic generation of Data Vault structures in an Oracle Enterprise Data Warehouse with SQL, PL/SQL, Java, Xtext.
  • Analyzed and recommended improvements for throughput and query performance.
  • Key technologies: Oracle DB, PL/SQL and Apex, Java, ETL, Data Vault.
  • Project scope: 100%.
Jan 2016 - Apr 2016
4 months
Hamburg, Germany

Business Intelligence Specialist, Data Warehousing Specialist

Toolport GmbH

  • Modeled and built a Data Warehouse for e-commerce and marketing analyses.
  • Designed, consulted and executed with MS SQL Server using Data Vault, and developed OLAP cubes with SSAS.
  • Data integration and quality control via SSIS and reporting with SSRS and Power BI.
  • Extended and displayed in R/Shiny for forecasting/segmentation.
  • Time series analysis, regression and cluster analysis.
  • Project management: SCRUM, Jira.
  • Key technologies: MS SQL Server, SSAS, SSIS, SSRS, MS Power BI/Shiny, Data Vault, Data Warehousing, T-SQL, R.
  • Project scope: 100%.
Jan 2015 - Dec 2015
1 year
Paris, France

Data Science Specialist

Atradius Credit Insurance N.V.

  • Analytics system for global market and financial data, including data integration, regression models, classification and time series analysis for credit insurance.
  • Consulting and coaching for data acquisition, interface definition and data quality.
  • MS SQL Server, T-SQL, OLAP and data mining with SSAS and SSIS.
  • Oracle, PL/SQL programming.
  • Developed statistical models for default probability using Naive Bayes, Bayesian networks, neural networks, logistic regression, R programming, data mining in MS SQL Server and Oracle, visualization in R/Shiny.
  • XSLT, XML Schema, Altova MapForce and SSIS for data integration, quality and transformation.
  • Key technologies (table): MS SQL Server/T-SQL, Oracle DB/PL/SQL, R and data mining.
Mar 2014 - Feb 2016
2 years
Vienna, Austria

Team Lead, Reporting Specialist

Österreichische Beamtenversicherung ÖBV

  • Automatic generation of 500+ PDF documents and reports from a Data Warehouse with customer and claims data and XML interfaces.
  • Project management including tech consulting, data modeling, coaching.
  • Oracle DB, PL/SQL, XSLT, XML Schema, Altova StyleVision for presentation and Talend for data integration.
  • Project management: SCRUM, Jira, sub-project lead.
  • Key technologies (table): Oracle DB and PL/SQL (Apex), Altova MissionKit (StyleVision), XSL-FO, reporting, XML Schema/Schematron.
Jan 2013 - Dec 2013
1 year
Geneva, Switzerland

Team Lead, Business Intelligence Specialist

EFG Bank AG

  • Multilingual intranet reporting system for structured financial products.
  • Multidimensional time series analysis and forecasting of market data and customer demand.
  • Technical project lead for software development and statistical modeling.
  • Sub-project lead.
  • Key technologies: Oracle DB, PL/SQL, Oracle OLAP/Data Mining, R, Java.
Jan 2012 - Dec 2013
2 years
Berlin, Germany

Data Science Specialist, Team Lead

Bundesministerium für Wirtschaft und Innovation Hochschule für Philosophie München

  • Ontology-based survey system for multidimensional and interactive questionnaires.
  • Integrated standard analyses (descriptive stats, tests, correlation) and multivariate methods like regression, MDS, clustering.
  • Overall project lead (with Comelio GmbH).
  • Technologies used (detail): MS SQL Server, .NET, OWL, XSLT, XSL-FO.
  • Key technologies (table): ontology-based survey, Oracle, PL/SQL, Java, OWL, R and data mining, XML Schema/Schematron.
Jan 2012 - Dec 2012
1 year
Munich, Germany

Reporting Specialist, Team Lead

Logit Management Consulting GmbH

  • Multilingual analysis system for employee surveys with up to 400M records per survey.
  • Dynamic report generation and team-level analysis with up to 10,000 individual PowerPoint reports including correlation, clustering, discriminant analysis, logistic and other regressions.
  • Technical project lead for software/DB dev, data analysis, quality, integrity.
  • Sub-project lead.
  • Software used: MS SQL Server (SSIS, SSRS, SSAS), .NET, VBA, XML Schema.
  • Key technologies (table): MS SQL Server, SSRS, C#, VBA, T-SQL.
Jan 2011 - Dec 2012
2 years
Berlin, Germany

Data Science Specialist, Team Lead

Gesellschaft für Konsumforschung (GfK) GmbH Coca Cola AG

  • Interactive analysis system with complex retail product placement calculations (for Coca Cola).
  • Mobile survey for ~600 people to capture in-store product placements.
  • Technical project lead for software/DB dev, data analysis and quality.
  • Software used: MS SQL Server (SSIS, SSRS, SSAS), MS Access, VBA, .NET.
  • Key technologies (table): MS SQL Server, SSAS, SSIS, SSRS, Data Warehousing, T-SQL.
Jan 2011 - Dec 2011
1 year
Stuttgart, Germany

Business Intelligence Specialist, Team Lead

AOK Baden-Württemberg

  • Data Warehouse for insurance claims, including modules for online reporting, forecasting and fraud detection plus data integration/quality.
  • Technical project lead and coaching for software/DB dev, data analysis.
  • Software used: MS SQL Server (SSIS, SSRS, SSAS), .NET.
  • Key technologies (table for AOK AG): MS SQL Server, SSAS, SSIS, SSRS, MDX, DMX, T-SQL.
Jan 2010 - Dec 2015
6 years
Chennai, India

BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer

Comelio Business Solutions, Pvt. Ltd

Jan 2010 - Dec 2013
4 years
Miami, United States

BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer

Comelio, Inc.

Jan 2010 - Dec 2011
2 years

Business Intelligence Specialist, Team Lead

Santander Consumer Bank AG

  • Key technologies: Oracle DB, Oracle OLAP, PL/SQL.
Jan 2008 - Dec 2009
2 years
Berlin, Germany

Business Intelligence Specialist, Data Integration Specialist, Team Lead

Deutscher Bundesrat

  • Data Warehouse with interactive reporting and complex data integration for state budgets.
  • Time series analysis and forecasting.
  • Project lead with DB/software dev and data analysis, quality.
  • Software used: MS SQL Server (SSIS, SSRS, SSAS), T-SQL, .NET, VBA, XML, OWL.
  • Key technologies (table): MS SQL Server, SSAS, SSIS, SSRS, MDX, DMX, T-SQL, C#.
Jan 2008 - Dec 2008
1 year
Berlin, Germany

Data Science Specialist, Team Lead

T-Systems AG

  • OLAP/analytics system for HR and health data with various multivariate analyses.
  • Technical project lead with DB/software dev and data analysis.
  • Key technologies: Oracle DB and OLAP, PL/SQL, Java, R.
Jan 2007 - Dec 2007
1 year
Berlin, Germany

Data Science Specialist, Team Lead

Teles AG

  • Ontology-based expert system for technology monitoring based on patents and invention complexity.
  • Technical project lead with DB/software dev and data modeling.
  • Technologies used (detail): Java, PHP, Oracle DB, XML, OWL, XSLT, XSL-FO.
  • Key technologies (table): Oracle DB, Java, PL/SQL, XSLT, OWL ontology-based expert system.
Jan 2006 - Dec 2006
1 year
Bochum, Germany

Data Science Specialist, Team Lead

SchürmannSpannel AG

  • Expert system for factory building analysis and evaluation including usage simulation and interactive evaluation/survey.
  • Project lead with DB/software dev and data analysis.
  • Winner of the “Future Competition Ruhr Region”.
  • Technologies used (detail): MS SQL Server, .NET, XML, OWL.
  • Key technologies (table): MS SQL Server, C#, T-SQL, XSLT, OWL ontology-based expert system, XML Schema.
Jan 2005 - Dec 2005
1 year
Paris, France

Reporting Specialist

Maporama SA

  • Analysis system to compare usage profiles in map search.
  • Key technologies: Oracle DB, Oracle Reports, Java, PL/SQL.
Jan 2000 - Dec 2022
23 years
Berlin, Germany

BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer

Comelio GmbH

Languages
German
Native
English
Advanced
French
Intermediate
Italian
Elementary
Education

Bergische Universität Wuppertal

Diplom · Economics, Business Informatics · Wuppertal, Germany

Université de Sorbonne I

Licence · Paris, France

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions