Marco Skulschus
Business Analyst, Data Warehouse Developer
Experience
Jan 2024 - Jun 2025
1 year 6 monthsDü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 monthLindenberg 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 monthsHanover, 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 monthsZug, Switzerland
Managing Director, BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio Swiss GmbH
Jun 2021 - Dec 2023
2 years 7 monthsStans, 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 monthsBerlin, 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 monthMunich, 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 monthsBerlin, Germany
Web Developer
Comelio GmbH
- PHP web development, PostgreSQL, XML integration, XSLT, Bootstrap.
Apr 2020 - Jul 2020
4 monthsMü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 yearVienna, 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 yearsMunich, 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 monthsMunich, 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 yearsKiel, 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 monthsHamburg, 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 yearParis, 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 yearsVienna, 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 yearGeneva, 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 yearsBerlin, 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 yearMunich, 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 yearsBerlin, 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 yearStuttgart, 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 yearsChennai, India
BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio Business Solutions, Pvt. Ltd
Jan 2010 - Dec 2013
4 yearsMiami, United States
BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio, Inc.
Jan 2010 - Dec 2011
2 yearsBusiness Intelligence Specialist, Team Lead
Santander Consumer Bank AG
- Key technologies: Oracle DB, Oracle OLAP, PL/SQL.
Jan 2008 - Dec 2009
2 yearsBerlin, 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 yearBerlin, 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 yearBerlin, 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 yearBochum, 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 yearParis, 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 yearsBerlin, Germany
BI / DWH Developer, Data Analyst, Business Analyst, Data Engineer
Comelio GmbH
Languages
German
NativeEnglish
AdvancedFrench
IntermediateItalian
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
Similar Freelancers
Discover other experts with similar qualifications and experience
