Marco Skulschus-Business Analyst, Data Warehouse Developer

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 using Data Vault.

Building reporting and analysis reports with Microsoft Power BI including user training and onboarding.

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

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

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

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

Replacing 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 as well as 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 using Microsoft Power Automate.

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

Close, continuous collaboration with distributed teams in India.

Initially full-time, later part-time engagement (approx. 50%).

Enhanced and modeled a data warehouse solution based on Snowflake and SnowSQL.

Integrated contract, customer, and market data using Python and XSLT.

Set up and maintained reporting and analysis processes with Microsoft Power BI.

Worked full-time initially, then part-time (approx. 50%).

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

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

Technically responsible for interface design and data flows.

Part-time role (approx. 25%).

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

Development of an Analysis Services Tabular Model (SSAS) and DAX models for reports and self-service analysis.

Use of R and Shiny for visualizing and forecasting marketing and market data in the real estate sector.

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

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

Part-time assignment.

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

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

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

Analyzing and optimizing data throughput and query performance.

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

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

Data integration and interface definition between various source systems, as well as 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 credit default probabilities with 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, data quality checks and transformation.

Designed and developed a multilingual intranet reporting system for structured financial products.

Conducted multidimensional time series analysis and forecasts of market data and customer demand.

Led technical projects for software development and statistical modeling.

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

Took on sub-project leadership in the BI/analytics area.

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

Implemented dynamic report generation and team-based analysis with up to 10,000 individual reports in Microsoft PowerPoint.

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

Provided technical project management for software and database development, data analysis, and ensured data quality and integrity.

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

Building a data warehouse for insurance services with modules for online reporting, forecasting and fraud detection.

Responsibility for data integration, data quality and consistency.

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

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

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

Self-employment focusing on BI, DWH and software projects for international clients.

Execution of consulting and development projects in database and reporting environments at the Miami location.

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

Conducting time series analyses and forecasting for budget and financial metrics.

Project leadership with responsibility for database and software development, data analysis and ensuring data quality.

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

Development of complex reports and OLAP cubes as well as integration processes for heterogeneous data sources.

Development of an ontology-based expert system for competitive intelligence in the technology sector based on patents and level of innovation.

Design and implementation of an ontology-based expert system using Oracle DB, Java, PHP, XML, and OWL.

Use of XSLT and XSL-FO for presentation and document preparation.

Technical project management with responsibility for data modeling, software, and database development.

Conducting data and text analyses to evaluate technological developments.

Development of an analysis system for comparing usage profiles in map search.

Implementation of reports and analyses using Oracle DB and Oracle Reports.

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