Marco Skulschus

Business analysis for risk controlling.

Development of a data warehouse based on MS SQL Server with data from the FIS Cross-Asset Trading and Risk Platform (formerly Front Arena).

Implementation of ETL and transformation logic with T-SQL and Python (Jinja2 template engine).

Modeling and automation of data structures with Data Vault.

Creation of reporting and analysis reports with Microsoft Power BI, including training and onboarding of users.

Migration of IBM Cognos Report Studio reports to Microsoft Power BI with Oracle DB as the data source.

Development of analyses and data queries with Oracle SQL and PL/SQL.

Analysis and preparation of data from various business processes for reporting and management decisions.

Part-time assignment (approx. 25–50%).

Replacement of existing MS SQL Server Analysis Services OLAP cubes and multidimensional SSRS solutions with an Azure-based solution using SSAS Tabular Model and Microsoft Power BI.

Development and optimization of SQL Server databases and data integration with Azure Data Factory and Power Query/M.

Analysis and visualization of data from Microsoft Dynamics CRM in Power BI.

Automation of processes and workflows with Microsoft Power Automate.

Support for migration from SSAS and MS SQL Server to Databricks.

Close, continuous collaboration with distributed teams in India.

Work initially full-time, later part-time (approx. 50%).

Enhancement and modeling of a data warehouse solution based on Snowflake and SnowSQL.

Data integration for contract, customer, and market data using Python and XSLT.

Building and maintaining reporting and analysis processes with Microsoft Power BI.

Initially full-time, then part-time (about 50%).

Consulting and development for a document management and XML single-source publishing approach.

XML data integration and transformation with Altova MapForce, XSLT, and Python between various applications in power plant planning and construction.

Technical responsibility for interface design and data flows.

Part-time engagement (about 25%).

Modeling, designing, and building a self-service BI platform based on MS SQL Server 2017, Azure Data Lake, Azure Data Factory, and Microsoft Power BI.

Developing an Analysis Services Tabular model (SSAS) and DAX models for reports and self-service analysis.

Using R and Shiny to visualize and forecast marketing and market data in the real estate sector.

Replacing existing T-SQL and MDX calculations in SSAS with DAX-based models.

Conducting analyses for marketing, sales, and market data in a hybrid Azure and on-premises setup.

Part-time role.

Data Vault modeling and building a central data platform for customer, business, risk, and payment data using Oracle.

Creating interfaces with Talend and additional Java and PL/SQL-Apex programming for various banking systems.

Developing an enterprise data warehouse with SQL, PL/SQL, Java, and Xtext for the automatic generation of Data Vault structures.

Analyzing and optimizing data throughput and query performance.

Performing ETL development and data integration to provide mandatory and regulatory reports.

Building an analysis system for globally collected market and financial data for credit insurance.

Integrating data and defining interfaces between different source systems and advising on data quality.

Using MS SQL Server (T-SQL, SSIS, SSAS) and Oracle (PL/SQL) for OLAP and data mining.

Developing statistical models to calculate probability of default using Naive Bayes, Bayesian networks, artificial neural networks, and logistic regression.

Programming and visualizing the models with R and R/Shiny.

Using XSLT, XML Schema, Altova MapForce, and Integration Services for data integration, quality checks, and transformation.

Design and development of a multilingual intranet reporting system for structured financial products.

Execution of multidimensional time series analysis and forecasting of market data and customer demand.

Technical project leadership for software development and statistical modeling.

Use of Oracle DB, PL/SQL, Oracle OLAP and Oracle Data Mining, as well as R and Java.

Taking on a subproject lead role in the BI/analytics environment.

Development of a multilingual evaluation system for employee surveys with up to 400 million records per survey.

Implementation of dynamic report generation and team-level analysis with up to 10,000 individual reports in Microsoft PowerPoint.

Integration of statistical methods such as correlation, cluster analysis, discriminant analysis, logistic regression and other regression techniques.

Technical project leadership for software and database development, data analysis, and ensuring data quality and integrity.

Use of MS SQL Server (SSIS, SSRS, SSAS), .NET, VBA and XML Schema.

Built a data warehouse for insurance services, including modules for online reporting, forecasting, and fraud detection.

Responsible for data integration, data quality, and consistency.

Technical project management and coaching for software and database development as well as statistical data analysis.

Used MS SQL Server (SSIS, SSRS, SSAS) and .NET.

Employed MDX, DMX, and T-SQL for complex analyses and forecasting models.

Self-employed work focused on BI, DWH, and software projects for international clients.

Carried out consulting and development projects in the database and reporting area at the Miami location.

Built a data warehouse with interactive reporting and complex data integration for federal state budget financial data.

Performed time series analysis and forecasting for budget and financial metrics.

Led projects with responsibility for database and software development, data analysis, and ensuring data quality.

Used MS SQL Server (SSIS, SSRS, SSAS), T-SQL, .NET, VBA, XML, and OWL.

Developed complex reports and OLAP cubes, as well as integration processes for heterogeneous data sources.

Developed an ontology-based expert system for monitoring competitors in the technology sector, based on patents and level of invention.

Designed and implemented the ontology-based expert system using Oracle DB, Java, PHP, XML and OWL.

Used XSLT and XSL-FO for presentation and document preparation.

Technical project lead responsible for data modeling, software and database development.

Performed data and text analyses to assess technological developments.

Developed an analysis system to compare usage profiles in map search.

Implemented reports and analyses using Oracle DB and Oracle Reports.

Programmed in Java and PL/SQL to implement business logic and map functions.