Willi Ziegenhagel

Data Analyst

Barsinghausen, Germany
Experience
Sep 2023 - Present
1 year 11 months
Frankfurt, Germany

Data Analyst

  • Project: Process analysis and optimization (Industry: Banking)
  • Technologies: SQL, Celonis
  • Analysis of process data
  • Data preparation with SQL
  • Development of reports & dashboards in Celonis
May 2023 - Aug 2023
4 months
Leipzig, Germany

Dashboard Designer and Power BI Expert

  • Project: Dashboard development for web and app analytics (Industry: Insurance)
  • Technologies: Power BI, DAX, RLS
  • Design of target-group specific dashboards
  • Development of data models, DAX
  • Development of reports & dashboards in Power BI
  • Implementation of row-level security
Oct 2022 - May 2023
8 months
Hamburg, Germany

Interim BI Manager & Product Owner

  • Project: Building data platform (Industry: E-Commerce)
  • Technologies: AWS Redshift, Python, Power BI, DAX, RLS
  • Support in developing a data strategy
  • Product Owner for multiple data products
  • Development of data models, reports, DAX, RLS in Power BI
  • Development of SQL views for data preparation
Mar 2022 - Oct 2022
8 months
Zeven, Germany

BI Consultant

  • Project: Building marketing reporting platform (Industry: Baby products)
  • Technologies: Microsoft Power Platform, Power BI
  • Development of data model and loading processes
  • Development of reports and dashboards with Power BI and integration into marketing reporting platform.
Mar 2022 - Oct 2022
8 months
Regensburg, Germany

Data Consultant

  • Project: Implementation of a new CRM (Industry: E-Commerce)
  • Technologies: Microsoft Dynamics CRM, Azure Data Factory
  • Responsible for the data migration stream.
  • Gathering and systematizing business requirements and dependencies.
  • Breaking down work packages into sensible functional and technical units.
Mar 2020 - Feb 2022
2 years
Stuttgart, Germany

Senior Analytics Consultant

Kaiser X Labs GmbH

  • Project: Data strategy consulting (Industry: Insurance)
  • Technologies: Power BI, Oracle, MicroStrategy, Adobe Analytics
  • Responsible for identifying, prioritizing and implementing analytical use cases.
  • Gathering and systematizing business requirements and dependencies.
  • Breaking down work packages into sensible functional and technical units.
  • Competent contact person for analytics topics.
  • Analysis of customer behavior with the goal of improving products.
  • Development of key metric models to guide teams.
Oct 2018 - Feb 2020
1 year 5 months
Wolfsburg, Germany

Business Analyst & Scrum Master

Hexad GmbH

  • Project: Development of an application for predicting machine failures (Industry: Automotive)
  • Technologies: Jira, Postman, PowerPoint
  • Responsible for the Scrum process and its correct implementation.
  • Advising the Product Owner on formulating requirements.
  • Facilitating Scrum rituals (Daily, Planning, Review, etc.).
  • Removing obstacles for the development team.
Dec 2017 - Sep 2018
10 months
Wolfsburg, Germany

Scrum Master / Requirements Manager / BI Analyst

Hexad GmbH

  • Project: Development of a sales cockpit (Industry: Automotive)
  • Technologies: OpenText Analytics Studio, Oracle 11.1, Atlassian Jira
  • Responsible for the Scrum process and its correct implementation.
  • Advising the Product Owner on formulating requirements.
  • Facilitating Scrum rituals (Daily, Planning, Review, etc.).
  • Analyzing requirements for feasibility (data analysis).
  • Designing data architecture and models.
Jan 2017 - Nov 2017
11 months
Heilbronn, Germany

BI Consultant

mayato GmbH

  • Project: Building an internal corporate planning (Industry: Retail)
  • Technologies: IBM TM1, Exasol
  • Requirements management, design and implementation of an application for internal corporate planning (cost center and cost type planning), including management dashboard and interface for adjusting permissions.
Jul 2015 - Dec 2016
1 year 6 months
Braunschweig, Germany

BI Consultant

mayato GmbH

  • Support in project management for creating a data lake pilot in the project 'Building a data lake for consolidating global enterprise data' (Auto bank, Braunschweig).
  • Requirements management, design and consulting in the context of Big Data technologies (Hadoop, Cloudera tools, Impala, Hive, Spark, Oozie, Sqoop) for the same project.
  • Building a data warehouse for risk management in SAP BW in the project 'Building an analytical data warehouse for risk management' (Auto bank, Braunschweig).
  • Focus on development and quality assurance of delivered solutions for the data warehouse project.
  • Technologies used included Hadoop (Cloudera tools, Impala, Hive, Spark, Oozie, Sqoop) and SAP BW.
Mar 2014 - Jun 2015
1 year 4 months
Paderborn, Germany

BI Consultant

mayato GmbH

  • Project: Modernization of corporate planning (Industry: Food industry)
  • Technologies: SAP BW, SAP BW-IP
  • Development of a planning application for sales and demand planning.
Summary
  • Focus on data analysis and visualization
  • Several years of experience in business intelligence projects
  • Certified data strategy consultant
  • Certified Data Analyst (Microsoft Power BI Data Analyst)
  • Industry experience in automotive, insurance and retail
  • Tools: Power BI, Tableau, SQL, R, Python
Languages
German
Native
English
Advanced
French
Elementary
Education
Mar 2010 - Feb 2014

Hanover University of Applied Sciences and Arts

Business Informatics · Hanover, Germany

Sep 2005 - Jul 2008

Deutsche Telekom AG

IT Systems Sales Specialist

Certifications & licenses

Data Strategy Consultant

datentreiber.de

Microsoft Power BI Data Analyst

Microsoft

Professional Scrum Master

Scrum.org

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions