Bernd S.

Business Data Analyst | PowerBI & Microsoft SQL Server

Avatar placeholder
Berlin, Germany

Experience

May 2022 - Present
3 years 8 months
Berlin, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

think-cell Software GmbH

  • Performance optimization/reporting centralization by building data models using SSMS (SQL) & SSAS (DAX) & data integration via SSIS
  • Optimization and expansion of the current PowerBI dataset (running parallel until the SSAS data model was finished)
  • Expansion of current reporting (after building the SSAS data model, migrating the reporting to the SSAS source)
  • Regression analyses, cohort analyses, price/volume analyses, success analyses of strategy projects
  • Training internal colleagues
Jan 2022 - Present
4 years
Cologne, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

Volvo Car Germany GmbH

  • SSAS: Adjusting the central data model, calculating the needed measures and calculated columns with DAX (e.g., time intelligence, projections, rolling forecasts, etc.)
  • SSMS: Creating/optimizing views based on the existing DB structure to simplify the data model
  • SSIS: Integration of decentralized data sources (SQL Server, CSV, XLSX)
  • MS PowerBI: Creating automated, audience-specific daily reports for sales & marketing, after sales, production planning, finance, etc. (including exec summaries and detailed analyses)
  • PowerBI/modelling/DAX training for internal analysts
  • Project planning and management, as-is analysis, requirements management (1st step)
Dec 2020 - Oct 2021
11 months
Munich, Germany

Developer Microsoft PowerBI (part-time)

Avantgarde Talents GmbH

  • Developing a daily sales dashboard to manage account managers and recruiters
  • Data modeling, creating a data model
  • Developing relevant measures in collaboration with the KAM lead
  • Creating specific and flexible sales dashboards
  • Checking data consistency
  • Migrating to a new data source (2nd project)
Mar 2020 - Dec 2021
1 year 10 months
Munich, Germany

Team Lead Business Intelligence | Microsoft PowerBI

Korian Deutschland AG

  • Building the company-wide reporting and analytics system using Microsoft PowerBI (Desktop and Online Service) for the board of directors, executive management, regional/area and facility management, and departments like HR, operations, marketing
  • About 20 standard reports for all relevant user groups and special topics, e.g., balanced scorecards and forecasting models
  • Operating model for the accurate allocation of centrally booked costs
  • Creating a central data pool in the PowerBI Online Service by integrating data via PowerBI dataflows (data sources among others SAP BW, MS Dynamics, MS OneDrive, company network, industry systems like DAN, Cannyline, IS Social, Geocon)
  • Structuring and mapping financial and non-financial data from various source systems, including defining and creating primary and foreign keys
  • Modelling datasets based on the dataflows, including automated updates
  • Calculating the needed measures, including defining them with relevant stakeholders to align inconsistent calculation logic within the company
  • Creating audience-specific daily, weekly, and monthly reports on all relevant company topics (care, assisted living, outpatient services, HR scheduling, recruiting, marketing & sales), including automated updates
  • Conducting internal training and ongoing coaching of the four-member team, and building a PowerBI community within the company
Oct 2017 - Feb 2020
2 years 5 months
Munich, Germany

Senior Manager Business Intelligence & Controlling

Hubert Burda Media Holding KG – CFO Office

  • Product owner for the Burda Digital Data Hub (building a group-wide enterprise DWH including a self-service BI tool)
  • Leading a team of six internal and external developers
  • Acting as a link between the board, business unit MDs, profit center departments, and IT (requirements management, design, implementation, optimization, data provisioning)
  • Developing, optimizing, and automating distribution of audience-specific dashboards (board, management, departments) via Microsoft Power BI
  • Harmonizing measurement methods across the group, and analyzing, adjusting, and implementing a consistent posting logic
  • Data protection coordinator/ISO for the corporate controlling area
Sep 2015 - Sep 2017
2 years 1 month
Unterföhring, Germany

Senior Controller Digital Entertainment

ProSiebenSat.1 Digital GmbH

  • Creation of business cases and commercial implementation of new business models and strategic initiatives (e.g. business case for Joyn, investment case TVSmiles)
  • Coordination, operational support and monitoring of the entire planning process
  • Ongoing forecasts, regular variance analysis and discussions with departments to optimize specific websites (Prosieben.de, Sat1.de, etc.)
  • Development and optimization of controlling tools to analyze traffic and sales KPIs
May 2013 - Aug 2015
2 years 4 months
Munich, Germany

Manager Finance & Operations

Burda Intermedia Publishing GmbH

  • Automation of the entire monthly reporting (financials, business-specific KPIs)
  • Analysis and support in managing the business unit (performance analysis, business cases, profitability reviews, benchmarking, identifying potential)
  • Coordination, operational support and consolidation of audience reach and financial planning
Feb 2012 - Feb 2013
1 year 1 month
Munich, Germany

CFO Assistant

Your Family Entertainment AG

  • Monthly reporting including P&L, balance sheet, forecast, cash flow planning and relevant KPIs
  • Technical and content revision of the asset valuation system
  • Creation of the business and project plan for launching a free-to-air TV channel
Jul 2011 - Dec 2011
6 months
Guangzhou, China

Assistant to the Executive Chamber Manager

Deutsche Auslandshandelskammer Süd- & Südwestchina

Oct 2010 - Jun 2011
9 months
Munich, Germany

Working Student Business Intelligence

Scout24 Holding GmbH

Apr 2010 - Sep 2010
6 months
Munich, Germany

Working Student Product Management Multi-Asset Products

Wealth Management Capital Holding GmbH

Aug 2009 - Mar 2010
8 months
Munich, Germany

Working Student Group Accounting & Application Management

Scout24 Holding GmbH

Sep 2008 - Aug 2009
1 year
Nuremberg, Germany

Working Student Product Management & Sales Support

Cortal Consors, BNP Paribas

Jun 2006 - Aug 2007
1 year 3 months
Munich, Germany

Working Student Receivables Management

BMW Financial Services

Skills

  • Reporting/modelling: Power Bi, Tableau, Qlikview, Sap Business Objects, Oracle Hyperion (Planning, Reporting Studio, Smartview, Hfm), Microsoft Excel (Among Others Excellent Analytics, Thinkcell), Ssas, Ssms, Ssis
  • User/database Languages: Sql, R (Tidyverse), Spss, Talend Open Studio
  • Project Management: Scrum, Jira, Confluence

Languages

German
Native
English
Advanced
Spanish
Intermediate
French
Elementary
Chinese
Elementary

Education

Apr 2009 - Mar 2011

University of Regensburg

Master of Science in Economics · Economics · Regensburg, Germany

Sep 2007 - Feb 2008

University of Zaragoza

Zaragoza, Spain

Oct 2005 - Mar 2009

University of Regensburg

Bachelor of Science in Economics · Economics · Regensburg, Germany

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

Similar Freelancers

Discover other experts with similar qualifications and experience

William N.
William N.

Product Owner Frontend

View Profile
Germo G.
Germo G.

BI Developer

View Profile
Marco S.
Marco S.

Business Analyst, Data Warehouse Developer

View Profile
Reinhold S.
Reinhold S.

Senior Software Developer

View Profile
Vitali H.
Vitali H.

Power BI Expert

View Profile
Petru K.
Petru K.

Architect & Technical Team Lead & Senior Developer

View Profile
Thomas R.
Thomas R.

BI Consultant and Power BI Developer

View Profile
Yannick R.
Yannick R.

Power Platform Developer

View Profile
Kai P.
Kai P.

Microsoft Azure Synapse and Power BI Developer

View Profile
Stefan C.
Stefan C.

SSIS Development

View Profile
Gurpreet D.
Gurpreet D.

Digital Finance Consulting – Advanced Data Analysis

View Profile
Henok A.
Henok A.

Founder and Managing Director

View Profile
Axel B.
Axel B.

Microsoft Fabric & Power BI Developer

View Profile
Stefan D.
Stefan D.

BI Consultant in Controlling

View Profile
Susanne M.
Susanne M.

PO CRM

View Profile
Mohamed A.
Mohamed A.

Full Stack Data Professional (Freelance) BI Expert Data Engineer BI Strategy

View Profile
Willi Z.
Willi Z.

Data Analyst

View Profile
Andre W.
Andre W.

PRINCE2® Foundation Examination

View Profile
Ronny H.
Ronny H.

Senior Business, IT and Data Analyst, Portfolio Analyst

View Profile
Guido K.
Guido K.

Power BI Report Developer

View Profile
Moez S.
Moez S.

Data Engineer

View Profile
German P.
German P.

Microsoft BI Specialist

View Profile
Kerstin B.
Kerstin B.

Reporting and Analytics for HR

View Profile
Martin T.
Martin T.

Interim Controller

View Profile
Torsten G.
Torsten G.

BI consultant

View Profile
Dieter W.
Dieter W.

Freelancer

View Profile
Alexander Z.
Alexander Z.

Senior Data Architect & Data Engineer

View Profile
Olga M.
Olga M.

External IT Consultant BI and DWH

View Profile
Jonathan S.
Jonathan S.

AI Consultant

View Profile
Friedemann J.
Friedemann J.

Freelance Interim CFO

View Profile