Azure Synapse Analytics Experts in Frankfurt

As a freelance IT lecturer and IT coach, I specialize in teaching individuals concepts like Cloud Computing, Business Intelligence, Python Programming and Agile Frameworks. My goal is to simplify complex technical concepts into practical, actionable knowledge. Through my extensive experience as an IT consultant in various sectors and roles I know about the importance of IT training - for companies and employees alike.

• Advising on the use of analytics and BI tools and services in the Microsoft Azure stack (e.g. MS Fabric, Synapse Workspaces and dedicated SQL pools, SQL Database, PostgreSQL, Snowflake, Databricks, Data Factory, SSIS, Analysis Services, Function Apps, Power BI, ML)
• Independently designing analytics solutions with Python, SQL, etc.
• Designing and implementing ETLs and data pipelines
• Creating and maintaining APIs
• Independently applying CI/CD, testing, and version control
• Data modeling
• Model development and optimization
• Anomaly detection with AI
• Predictive analytics

Used technologies:

• Snowflake
• Fabric
• Azure Synapse Analytics
• Azure DataFactory
• Azure Data Lake
• Azure DevOps
• Databricks
• Spark
• CI/CD
• SQL Database
• Python
• Power Platform

• Implementation of specified DevOps solutions to automate infrastructure (Terraform, Bicep, CloudFormation, Ansible) on-premises datacenter (Ovirt, Proxmox, Ceph Cluster, MinIO) and private cloud.
• Administration, configuration and implementation of CI/CD DevOps pipelines (GitLab, GitFlow) to support development process (Artifactory, Prometheus, Istio, service mesh, Helm Chart, OpenShift (Red Hat Enterprise) / Kubernetes cluster), Red Hat Satellite.
• Administration, setup, monitoring and patching of Linux infrastructure based on Red Hat Enterprise for Dev, Test and QA.
• Use of Scrum and Kanban methods.
• Administration, configuration and implementation of security standards for deploying on Dev, Test, QA and Prod stages of the new ePA applications.
• Development of new plugins and add-ons needed on current infrastructure.
• Database support.
• Data analytics support (Python, Spark, Pandas, Power BI, Splunk Enterprise).
• Implementation of best practices for DevSecOps and BizDevOps using GitOps (ArgoCD), Streamlit framework, Semaphore Ansible UI.
• Configuration and testing of iperf, uperf, sysbench using benchmark-operator for external source data and IoT/MDM devices, creating reports via ELK / OpenSearch.
• Building a new Databricks platform to collect and analyze big data from different sources and IoT devices into Hadoop framework (Python, Pandas, PySpark, Power BI, Apache Airflow).
• Building backend data aggregation and processing to automate configuration deployment between different OpenShift clusters and big data framework (Python, Pandas, PySpark, Apache Spark, PostgreSQL, Django 2, Ansible Automation, Jira JSM).
• Building a new ML pipeline platform using Kubeflow, TensorFlow, KServe.
• Data extraction, transformation and loading from different data sources including structured and unstructured data to analytic DWH / big data cluster using Python, Pandas, Polars, Power BI, Django backend and PostgreSQL.
• Setup of new DevOps Test and QA HashiCorp Vault cluster for PKI and IAM.
• Configuration and testing of automated patching based on CVSS score, SIEM-integrated CVEs.
• Use of Nexpose and InsightVM to scan vulnerability events in network, host, container and application.
• Design and implementation of secure and scalable AWS architectures including VPC, EC2, S3, RDS and Route53 and similar setups on Azure and GCP.
• Automated system provisioning and deployment using CloudFormation templates.
• Configuration of IAM roles, policies and permissions to ensure secure access control.
• Patch management, backup automation and disaster recovery setup on AWS infrastructure.
• Monitoring and optimization of system performance using AWS CloudWatch and AWS Trusted Advisor.
• Support of VMware services (vSphere, Aria, Horizon) and the virtual desktop environment.
• Development and maintenance of CI/CD pipelines using Jenkins, GitLab CI/CD and AWS CodePipeline with interface to Nutanix.
• Configuration of AWS CloudWatch to monitor application performance and system events.
• Planning and execution of migration of on-premises applications to AWS cloud platforms.
• Deployment of containerized applications using Docker and Kubernetes in AWS environments.
• Deployment of internal software packages between availability zones using AWS CodeDeploy.
• Building and deploying ML models using Scikit-learn, XGBoost and Spark MLlib including hyperparameter tuning, model evaluation and production deployment.

• Global marketing analytics for Hitachi Energy as part of a global data modernization initiative aiming to enhance data retention, historical data availability and provide Eloqua's 2-year retention for remote interaction reporting and analytics.

• Analyzed Eloqua's default retention policy and identified risk of data loss for records older than two years.

• Designed and implemented historical data preservation strategy by creating transformed tables in the target data platform to archive older data while ensuring data quality dashboards.

• Collaborated with the Power BI team to re-point dashboards from raw Eloqua imports to the newly created archival layer.

• Leveraged Jira to track and manage data engineering tasks, bugs, and feature requests across Agile sprints; coordinated backlog prioritization and task assignment to align data pipeline development with business needs.

• Power BI dashboard optimization:

• Worked closely with business stakeholders to assess and understand reporting needs for reverse customer data.

• Designed and implemented incremental refresh in Power BI to ensure daily updates without full data reloads.

• Collaborated with Azure data engineers to optimize data processing and publication pipelines.

• Stakeholder communication & data modeling:

• Acted as liaison between Group Data Office and Technology Office to align data modelling standards.

• Gathered requirements from data engineering team and participated in weekly status meetings to provide implementation updates and resolve blockers across teams in Germany, Poland, and India.

• Documentation & quality assurance:

• Prepared end-to-end technical design documentation, data flow diagrams, and Power BI audit guides for future reference.

• Participated in UAT sessions with business users to validate data outputs and report accuracy.

• Design and development of modern cloud DWH & data platforms
• Data Vault automation
• Implementation of ELT and CI/CD processes
• Requirements analysis and data modeling
• Building an automated cloud data platform as a reference architecture for financial risk controlling (Snowflake, Data Vault, DBT, Python, GitHub) 2024-10-01 – 2025-06-30, Zurich
• DWH further development, operations and cloud migration (Data Vault, DBT, SAP Data Services, Alteryx, SQL Server, Azure Synapse) 2023-03-01 – 2025-06-30, Frankfurt
• Implementation of a global cloud data platform (Data Vault, WhereScape, Snowflake, AWS, Scrum) 2021-04-01 – 2023-12-31, Cologne
• Proof of concept for a global cloud data platform (Data Vault, Snowflake, Synapse, WhereScape, Azure, Scrum) 2022-04-01 – 2022-07-31, Bonn
• Implementation of a cloud data platform (Data Vault, Snowflake, WhereScape, AWS) 2021-07-01 – 2022-04-30, Karlsruhe
• Big data integration of all source systems related to the ITSM process (Data Vault, Snowflake, WhereScape, AWS, Scrum) 2021-01-01 – 2021-05-31, Prague
• Development and operation of a global self-service BI platform to display around 150 corporate KPIs (Data Vault, WhereScape, Postgres, Jenkins, Talend, AWS, Scrum) 2018-11-01 – 2020-12-31, Frankfurt
• Implementation of a DWH for price management and capacity forecasting in long-distance passenger transport (SAP BODS, SQL Server, AWS) 2017-10-01 – 2018-11-30, Frankfurt
• Introduction of SAP BODS and migration of the existing DWH (SAP, BODS, HANA, Oracle, Cognos) 2017-05-01 – 2017-10-31, Rastatt

• Jira administration.
• Jira workflow implementation and management.
• Jira rules definition and process monitoring.
• Mobica project (see project list).