Marco S.-Business Analyst, Data Warehouse Developer

Power BI development, SparkSQL development, MS Fabric migration

Consulting, prototype development and training for data integration and data mapping with Altova MapForce, XML Schema and XSLT

• Business analysis and DWH architecture for risk controlling.

• DWH design and development based on MS SQL Server, integration of data from FIS® Cross-Asset Trading and Risk Platform (formerly Front Arena), development in T-SQL and Python (template engine Jinja2), modeling and automation with Data Vault, star schema modeling in the data mart.

• Analysis of risks (e.g., stress tests) by changing approx. 200 parameters grouped by scenarios. Analysis either using values predefined in the database or through interactive changes in the MS Power BI report.

• Reporting with MS Power BI, training and implementation, migration of SSRS (SQL Server Reporting Services) reports.

• Methodology: Scrum with Jira.

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

• Development with DAX.

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

• Methodology: Scrum with Octane.

• 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 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 with Microsoft Power Automate.

• Support with the migration from SSAS and MS SQL Server to Databricks.

• Close, continuous collaboration with distributed teams in India.

• Methodology: Scrum with Jira, ITIL.

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

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

• Methodology: Scrum, ITIL.

• Initially full-time, followed by part-time work (approx. 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 different applications in the field of power plant planning and construction.

• Technical responsibility for interface design and data flows.

• Part-time assignment (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 analyses.

• Use of R and Shiny to visualize and forecast marketing and market data in the real estate sector.

• Migration of SSRS reports to MS Power BI.

• Replacement of 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 assignment.

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

• Creating interfaces with Talend as well as 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.

• Carrying out ETL development and data integration to provide legally required 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 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 management for software development and statistical modeling.

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

• Assumption of sub-project management in the BI/Analytics field.

• 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 management for software and database development, data analysis, and ensuring data quality and data 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.

• Responsibility for data integration, data quality and consistency.

• Technical project management 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-employed work focused on BI, DWH and software projects for international clients.

• Execution of 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 the financial budget data of the federal states.

• Performing time series analyses and forecasts for budget and financial indicators.

• Project management with responsibility for database and software development as well as data analysis and data quality assurance.

• Use of 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 monitoring competitors in the technology sector based on patents and inventive step.

• Design and implementation of an ontology-based expert system based on 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 assess technological developments.

• Development of an analytics system for comparing usage profiles in map searches.

• Implementation of reports and analyses with Oracle DB and Oracle Reports.

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