Profileimage by Marco Skulschus DWH / BI / XML Berater from Zug

Marco Skulschus

not available until 03/31/2024

Last update: 25.01.2024

Business Intelligence & Data Science Consultant

Company: Comelio Swiss GmbH
Graduation: Dipl. Ökonom
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional) | French (Limited professional) | Italian (Elementary)

Attachments

2024-01-01-Profil-DE-Marco-Skulschus_250124.docx
2024-01-01-Profile-EN-Marco-Skulschus_250124.docx

Skills

Summary
Marco Skulschus studied economics in Wuppertal, Germany und Paris, France and works since 2002 as trainer and lecturer, since 2006 as Business Intelligence / Data Mining consultant, and since 2008 also as technical project manager for business analytics, Data Mining, and production/process data.
He is author of more than a dozen books covering topics like software development (Java, PHP) and database development (Oracle, MS SQL Server) as well as XML technologies (XML Schema, XSLT, and XSL-FO) as well as empirical social research and data analysis. Currently, 15 books plus nearly 20 quick references are in print. He sold over 100.000 copies until today.
He works as a trainer and lecturer on topics like databases, Business Intelligence / Data Mining using R, IBM SPSS, Minitab, MS SQL Server or Oracle, and XML technologies. The trainings take place mainly in Germany, Austria, and Switzerland but a short list of topics can also be booked in English language in other European countries.

Skills
  • Databases: MS SQL Server and Oracle for OLAP / BI / Data Warehousing / Data Mining, and Data Science applications
  • Data Science: R, Minitab, SAS JMP, IBM SPSS
  • Reporting: MS Power BI using Analysis Services Tabular Model, DAX
  • Software: T-SQL, PL/SQL, PHP, Java, Python
  • XML: XML Schema, XSLT, XSL-FO, Altova MissionKit, oXygen
  • Planning: UML, BPMN, Oracle Data Modeler, Sparx Enterprise Architect
  • Ontologies using OWL, RDF Schema, and Protégé

Activities
  • Data modelling, Semantical engineering, Data Vault modelling, XML modelling
  • DB development, DB application development
  • Multivariate data analysis, statistical modelling, and Data Mining
  • OLAP / Data Warehousing, Business Intelligence, data integration
  • Data Mining and machine learning
  • Project management, development, consulting, and coaching


In the roles of consultant and technical project manager he conceives and builds either Business Intelligence / OLAP systems for server-based data analysis, single statistical analyses and Data Mining models or XML-based reporting solutions either for data integration or single source publishing in mass document generation.
The projects are carried out for clients in Europe (mainly in the German-speaking world and neighboring countries).


Since 2008, he works as a consultant and technical project manager in various sometimes also internationally organized projects. He supports companies and organizations building Business Intelligence systems for business analysis (sales, marketing or market research, and production) or other database-/XML-related systems, and reporting solutions.

Tasks
·       Data and software modeling
·       Algorithm definition and model design for statistical analysis and Data Mining
·       Interface design and definition for import/export scenarios
·       Requirements analysis and specifications
·       Technical project management
 Tools
·       Databases: MS SQL Server and Oracle
·       Programming: PHP, PL/SQL, T-SQL, XSLT
·       Data analysis: R, IBM SPSS (Modeler), Minitab, Data Mining in MS SQL Server and Oracle
·       Enterprise Architect
·       Talend Open Studio, Altova Mapforce, MS SQL Server Integration Services
 


Business Intelligence
  • OLAP and Data Warehousing
  • MS SQL Server Analysis/Integration/Reporting Services
  • Statistics and Data Mining using MS SQL Server und Oracle

Statistics
and Data Mining
  • Descriptive and inferential statistics
  • Time Series Analysis, Regression Analysis
  • Multivariate Analysis and Data Mining
  • Statistical analysis and Data Mining using R
  • Statistical analysis and Data Mining using IBM SPSS
  • Data Mining using MS SQL Server and Oracle
  • DOE and SPC using Minitab

Databases
  • Microsoft SQL and T-SQL
  • Oracle SQL and PL/SQL

XML
  • Modeling using XML Schema and ontologies using OWL, Protégé
  • Transformation using XSLT, XSL-FO
  • XML and databases and XML in Java, .NET, and PHP
  • Altova MissionKit (XML Spy, StyleVision, Mapforce) and oXygen XML Editor

Project Management
  • UML and BPMN
  • Requirements Analysis using Use Cases
  • Enterprise Architect

Project history

Local Availability

Only available in these countries: Germany, Austria und Switzerland
Deutschland: Bevorzugt Städte, die mit dem Zug (ICE / IC) erreicht werden können. Österreich: Wien Schweiz: Zürich, Zug, Luzern

Other

Seminarthemen Methoden der Datenanalyse Allgemeines Lineares Modell (bspw.: Regressionsanalyse, (M)AN(C)OVA, Logistische Regression) Multivariate Verfahren (bspw. Clusteranalyse, Diskriminanzanalyse, Faktorenanalyse, Strukturgleichungsmodellierung, Conjoint-Analyse, Multidimensionale Skalierung, Zeitreihenanalyse) Data Mining (bspw.: Entscheidungsbäume, Künstliche Neuronale Netze, (Sequenz)-Cluster-Analyse und Assoziationsanalyse) Ingenieurstatistik (bspw.: Versuchsplanung und –auswertung, Statistische Prozess- und Qualitätskontrolle) Software Analyse, Visualisierung und Programmierung mit R IBM SPSS Statistics JMP Ingenieurstatistik: Minitab Datenbanken MS SQL Server T-SQL Data Warehousing mit Integration /  Reporting / Analysis Services Oracle SQL und PL/SQL OLAP und Data Warehousing Data Mining
Profileimage by Marco Skulschus DWH / BI / XML Berater from Zug Business Intelligence & Data Science Consultant
Register