Johannes Merkel

Holistic excellence along the entire data value chain

Johannes Merkel
Berlin, Germany

Experience

Apr 2021 - Aug 2022
1 year 5 months
Berlin, Germany

Expert Partner | Data Strategy

diconium GmbH

  • AI Strategy Innovation Management, Automotive (04/2022 – 08/2021): Concept and creation of the AI Innovation Pipeline for the evaluation and prioritization of 200+ AI projects in the field of vehicle data.

  • Data Lobbying, Automotive (04/2021 – 08/2022): Management and communication of regulatory compliance, participation in standardisation processes, participation in public consultations and preparation of position papers for data initiatives across all brands, especially in the area of EU regulation on data generation, data use, data transfer and data marketplaces.

Oct 2018 - Present
6 years 5 months
Berlin, Germany

Independent Management Consultant

Johannes Merkel - Data Driven Consulting

  • Management Reporting App, Real Estate (01/2024 – 01/2025): Development and implementation of a management reporting system. Managing the design of key performance indicators (KPIs) within Power BI and Data Fabric. Establishment of a KPI governance framework to maintain data integrity and creation of a comprehensive KPI glossary and index, streamlining reporting practices and improving organizational transparency based on International Business Communication Standards (IBCS) for planning and forecasting processes.

  • Pro Bono Consulting, Radikale Töchter e.V. (01/2022 - 06/2023): Transformation and automation of business processes to support the doubled growth of the company. Creation of a multi-year business plan for the implementation of analogue and digital workshops and the sale of products via the web shop. Creation of an automated accounting system and the resulting reporting system. Supporting and improving web shop operations, tender management with public funders and managing new hires and interns.

  • Data Brokerage Strategy and Business Modelling, Automotive (05/2021 – 12/2021): Support of the CEO with PMO activities and development of a data strategy around data driven use cases. Derivation of a business model, implementation plan including calculation of a business case to estimate sales and profit potential. Scaling and supporting use cases until go-live.

  • Product Owner Automation of Account Receivable, Legal-Tech (01/2021 – 04/2021): Recording of accounting processes and transfer of manual activities to automated invoicing on the legal-tech platform. Steering the development team, setting up the reporting system and handover to the organization.

  • Co-Founding RemPro, Training & Consulting (03/2020 – 10/2020): Start-up support for the development of a training and workshop provider to support companies in their transition to agile and decentralized working. Development of internal IT processes and design of workshops in agile project management.

  • B2B Platform Governance, Automotive (01/2020 – 03/2020): Orchestration of data product portfolio and creation of data management processes (contract generation, handling of data protection, release of data for B2B). Definition and alignment of B2B customer segments and their relationships with special focus on data. Implementation support as proxy product owner for API marketplace development activities within external data governance.

  • API Marketplace Product Owner, Automotive (04/2019 – 03/2020): Orchestration of a data product portfolio and creation of data management processes. Definition and alignment of B2B customer segments and their relationships with special focus on data. Implementation support as proxy product owner for API marketplace development activities within external data governance.

  • PMO & Digital Transformation, Automotive (11/2018– 03/2019): Development and control of the project management office for the digital supply chain. Onboarding and monitoring of 20 projects with 150+ FTE. Transformation of the project management organization into SAFe (Scaled Agile Framework for enterprises).

Aug 2014 - Jul 2018
4 years
Munich, Germany

Manager | Digital Practice & Head of Digital Lab

goetzpartners Management Consultants GmbH

  • Carve-Out & Sell-Side M&A Support, Telecommunications suppliers (08/2017– 07/2018): Support of the sell side to accommodate the carve-out of two non-core technology business units. Conducting workshops, feasibility study and development of stand-alone business case. Project management of the internal due-diligence of one carve-out with 10+ different cross-functional workstreams

  • Digitization & Automation Strategy, Telecommunication supplier (01/2017 – 05/2017): Definition of automation of C-level workforce reporting, requirement workshops and sprint planning. Development of mobile internal performance reporting MVP, conducting security audits and integration in Enterprise Architecture. Setup of internal employee communication and process documentation.

  • Operational Efficiency Program, Real Estate Service Provider (10/2016 – 04/2017): Stream lead for data management and data quality streams in operational efficiency program to leverage a cost saving of 30 mEUR and build the foundation of digital transformation. Setup and tracking of enabler measure to track financial impact of measure business case and validation of operational KPIs. Implementation of ISO 8000 data quality and enterprise data management processes.

  • PMO & BI Reporting, Telecommunication Provider (04/2015 – 09/2016): Setup of PMO governance, processes and tools to support 3 bnEUR cost improvement program. Financial baselining, business case validation, top-down and bottom up target setting Development and Implementation of financial reporting in Hyperion Business Intelligence tool environment to support the cost improvement methodology. Process support and workflow integration for degree of implementation, operational & financial KPIs and continuous C-level reporting. Roll-out and communication in 10+ operating countries.

  • Digital Lab, Consulting (08/2014 – 07/2018): Establishment of the "Digital Lab" as an idea incubator for digital solutions in the consulting environment (Data Science, Robotic Process Automation, Digital Strategy). Expansion of the partner network and implementation of solutions for internal process improvement (teambarometer and r2 network manager) and project support (data crawling pipelines and big data reporting solutions).

Aug 2012 - Jul 2014
2 years
Munich, Germany

Senior Consultant | Big Data & Corporate Performance Management

avantum Consult AG

  • Quality Management, Telecommunication Supplier (06/2013–07/2014): Introduction of a group-wide E2E Quality Management to improve Cost of Poor Quality by 30 MEUR. Design and development of key performance indicator systems and governance processes through to implementation support for automation in Oracle Essbase reporting environment.

  • Financial Reporting & Planning, Construction (02/2013–05/2013): Implementation of the ETL interface between SAP/R3 FI and IBM Cognos TM1 for business segment reporting including the setup of the SQL staging area and stakeholder management between corporate IT and finance departments.

  • Personnel Reporting & Planning, Tourism (08/2012 – 01/2013): Conception and implementation of the personnel planning tool based on IBM Cognos TM1 with interfaces to the integrated corporate planning, setup of the SQL staging area and development of the ETL components.

Apr 2009 - May 2012
3 years 2 months
Munich, Germany

Consultant | Restructuring Practice

goetzpartners Management Consultants GmbH

  • Restructuring, Telecommunication Supplier (01/2012–05/2012): Restructuring support including controlling of measures and organizational reorganization. Responsible for building the reporting tool for monitoring the HC reduction from 75,000 to 64,000 employees and managing the interface to the business case and financial reporting.

  • One P&L Reporting, Telecommunication Supplier (09/2011–01/2012): Creation of the "One P&L" to create transparency and enable control of product profitability across 7 regions, 120 countries and 20 product clusters. Modeling of the proof of concept and implementation support of the implementation in the internal Oracle Essbase reporting environment

  • Operational Efficiency, Coating Service Provider (03/2011 – 08/2011): Design of an innovative customer profitability calculation and validation in workshop format. Increase of results by 10% by eliminating unprofitable customer relationships based on the implemented model adjustments.

  • Change Management, IT Services (11/2010–02/2011): Implementation of an information portal and reporting system as part of the global change management project Execution and evaluation of surveys with 2,500 participants and monitoring of the communication strategy.

  • Restructuring, Automotive (09/2009–09/2010): Restructuring support including bank reporting. Responsible for the development of the measure controlling and PMO tracking tool with integrated financial modelling and planning based on Jedox PALO.

  • Financial Planning, Automotive (04/2009 – 08/2009): Implementation of the integrated financial planning including development of the Open Source CPM and BI environment to reduce planning time and increase planning accuracy. Responsible for implementation and organizational handover of the tool environment.

Summary

Ich bin Brückenbauer zwischen Management, Fachbereich und IT. Ich verstehe es, mit klarer Kommunikation und logischem Verstand praktische Lösungsansätze erfolgreich umzusetzen. Meine Leidenschaft gilt der ganzheitlichen digitalen Transformation, dem Corporate Performance Management und der Business Intelligence.

Languages

German
Native
English
Advanced

Education

Oct 2001 - Jun 2009

Technische Universität Dresden

Diplom · HF Medieninformatik