Power BI Report Development

• Integrated data from various web analytics platforms (Adobe Analytics, Salesforce Marketing Cloud) into the client’s Azure environment to build a Marketing Efficiency Dashboard
• Brought loyalty program data into the client’s data lake using ADF
• Designed the loyalty interface with the business team
• Developed a loyalty data model to analyze hundreds of millions of records
• Created dimensional data models and data marts for Power BI
• Lead developer and driver of initiatives

Technologies:

• Azure Databricks
• Azure Data Factory
• Azure Delta Lake
• Git deployments via DevOps CI/CD pipelines

• Connected real estate data to the data analytics platform
• Developed a dimensional data model for Power BI

Technologies:

• Onboarded new data sources in the RAW and STG zones of the Delta Lake
• Built ETL pipelines using Azure Data Factory and Databricks
• Created data models in the CUR zone
• Kimball data warehouse modeling

• Developed a brand management cockpit for a leading German discount chain in an internationally focused use-case team
• Took on the additional role of “DevCoach” in the use-case team
• Served as “Pull Request Reviewer”

Technologies:

• Onboarded new data sources in the RAW and STG zones of the Delta Lake
• Built ETL pipelines using Azure Data Factory and Databricks
• Git-based data model creation in the CUR zone
• Kimball data warehouse modeling

• Optimized financial accounting by integrating professional articles into the intranet

Technologies:

• Linux server setup
• MongoDB as temporary storage
• Program development in Python

• Linked additional systems and data sources (telephony, LOGA, output management)
• Introduced Power BI technology in the company
• Assessed existing data
• Coordinated with business teams
• Conducted workshops
• Created DAX measures and Power Query transformations

Technologies:

• Database queries (MSSQL + PL/SQL) from the corporate data warehouse (DWH)
• Expanded data mart
• Developed ETL processes
• Power BI, Power BI Report Server
• Microsoft SQL Server stack (SSAS, SQL Server)

• Developed a hotel dashboard prototype for revenue forecasting

Technologies:

• Power BI
• Converted Crystal Reports reports into a Power BI data model
• Power BI data gateway

• Built an automated monitoring platform in a backlog processing task force
• Generated daily KPIs like backlog counts and productivity for over 10 departments
• Processed heterogeneous data sources (individual records from management and scheduling systems, aggregated telephony data, manual lists)
• Performed ad-hoc data analyses

Technologies:

• Set up a data lake architecture on AWS S3
• Developed department-specific data pipelines with Apache Airflow (AWS EC2 + Docker, Python, Bash scripts, boto3)
• Deployed infrastructure as code
• Built calculation logic on AWS EMR clusters with Apache Spark (Scala, Apache Hive, Apache Zeppelin, Apache Parquet)
• Full implementation in AWS Cloud
• 60% Python (data pipelines) / 40% Apache Spark + Scala (calculation logic)

• Analyzed staff capacity in case processing
• Studied processing times for cases
• Added filters by event, product, and team
• Created forecasts and trend analyses

Technologies:

• Power BI, Power BI Report Server
• Microsoft SQL Server stack (SSAS, SQL Server)

• Supported IT development and consulting projects in various areas