Marco Skulschus-Business Analyst, Data Warehouse Developer

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

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

Setting up and maintaining reporting and analysis processes with Microsoft Power BI.

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

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

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

Technical responsibility for interface design and data flows.

Part-time assignment (approx. 25%).

Modeling, design and development of 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 industry.

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 engagement.

Data Vault modeling and building a central data platform for customer, business, risk and payment data based on 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 to automatically generate Data Vault structures.

Analyzing and optimizing data throughput and query performance.

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

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

Data integration and interface definition between different source systems, as well as consulting 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 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, data quality checks and transformation.

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

Execution of multidimensional time series analyses and forecasts 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.

Assumed sub-project leadership in the BI/analytics environment.

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

Implementation of dynamic report generation and team-based 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.

Building 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.

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

Using MDX, DMX, and T-SQL for complex analysis and forecasting models.

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

Carrying out consulting and development projects in the database and reporting environment at the Miami location.

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

Conducting time series analyses and forecasts on budget and financial metrics.

Project management responsible for database and software development, data analysis, and ensuring data quality.

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

Developing 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 tech sector based on patents and level of invention.

Designing and implementing an ontology-based expert system using Oracle DB, Java, PHP, XML, and OWL.

Using XSLT and XSL-FO for presentation and document processing.

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

Performing data and text analyses to assess technological developments.

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

Implementing reports and analyses with Oracle DB and Oracle Reports.

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