Description

With over eight years of experience in data analytics, including over six years in the banking sector, my expertise includes comprehensive data analysis skills, particularly data visualization, mainly using Tableau, as well as database queries and other advanced analytical methods. In recent years, I have also increasingly focused on project management, ensuring that all relevant project requirements are effectively captured, documented, and stakeholders are properly managed.

My focus areas are:

- Implementation of comprehensive Reporting Setups

- Data Visualization

- Analytics & Analysis

- Project Management

Domaines d’expertise

Langues

Allemand
Bilingue ou natif
Anglais
Capacité professionnelle complète

Préférences en matière de lieu de travail

Accepte de travailler sur site

Berlin (jusqu’à 50 km), Hamburg (jusqu’à 50 km), Frankfurt am Main (jusqu’à 50 km), Köln (jusqu’à 50 km), München (jusqu’à 50 km)

DocMorris N.V.
Analytics Engineering & BI Solutions for Logistics & Business Teams
E-COMMERCE
mars 2025 - Aujourd'hui (1 an et 3 mois)
Berlin, Allemagne
GOALS & SUCCESSES:
1. Development of a Shipping Carrier Dashboard for the internal Logistics Team
-> Improved transparency of carrier performance metrics, enabling data-driven carrier negotiations and the implementation of corrective measures (e.g. pre-sorting) to measurably enhance delivery performance
2. dbt model restructuring and clean-up of 20+ models
-> Reduce dbt model complexity and interdependencies, improving maintainability, execution performance, and overall pipeline reliability
3. GA4 data-based Dashboard migration from Looker Studio to Tableau
-> Conduct detailed analysis of GA4 field usage and redesign the data layer in dbt to provide performant, Tableau-ready data sources

TASKS:
Designed and implemented a ZIP-code-to-region and shipping carrier distribution center mapping, enabling geospatial performance visualization and network analysis
Conduct an in-depth analysis of existing dbt models and dependencies, refactoring the model layer by removing redundant models, reworking existing ones, and introducing new models where required
Deliver analytics on high-volume datasets across core business domains, processing millions of records from Order, Sales, Product, and Marketing systems
Work in close collaboration with stakeholders across all tasks and initiatives
Tableau software DBT Data analysis Looker Studio
Nays GmbH
Re-Order Alarm Dashboard
E-COMMERCE
juillet 2025 - septembre 2025 (2 mois)
Berlin, Allemagne
GOAL & SUCCESS:
-> Development of a Reorder Alarm Dashboard in Tableau to improve forecasting of required product quantities and optimal reorder timing

TASKS:
Analysed current inventory levels including pre-orders and backorders using SQL
Calculated item-specific reorder thresholds to optimize replenishment timing
Developed a Tableau dashboard with reminder logic and a traffic-light system to highlight items requiring reorder
Tableau Data analysis MySQL
Solaris SE
Refinement and implementation of a 50+ KPI external reporting setup
BANQUE & ASSURANCES
mai 2024 - Aujourd'hui (2 ans)
Berlin, Allemagne
GOAL & SUCCESS:
Complete the implementation of a comprehensive 50+ KPI reporting landscape within just four months
→ Delivered a fully operational reporting framework covering 600K+ customers and their card transactional data by the beginning of Q4 2024
→ Achieved successful validation and approval by all internal and external stakeholders
→ Secured the bank’s contractual guarantee agreements

TASKS:
Effectively managed internal and external key stakeholders to gather, document, and oversee all KPI requirements
Translated 50+ KPI specifications into SQL code, ensuring readiness for testing and seamless report integration
Processed over 600K customer records and 1.7M+ card transaction data points using Snowflake
Developed dbt models to integrate the reporting framework
SQL Projektmanagement Stakeholder Management Reporting Data Analysis