Upgrade Post project
Profileimage by Mathias Fiedler Business Intelligence Developer (Power BI, DAX, Tabular Editor, Power Query, SQL, Excel) from Berlin

Mathias Fiedler

Berlin
available

Last update: 26.08.2024

Business Intelligence Developer & Data Analyst

Company: Mathias Fiedler - Analysis & Automatisation
Graduation: Master of Science in Business Administration (SDU)
Hourly-/Daily rates: show
Languages: Danish (Full Professional) | German (Native or Bilingual) | English (Full Professional)

Keywords

Attachments

Lebenslauf-Mathias-Fiedler-GER-202301_012623.pdf

Skills

  • Highly data-driven Business Intelligence Developer with strong competencies in process automation, competitive intelligence and data analysis
     
  • Hands-on experience in developing intelligent decision-making tools to increase gross margin and ensure scalable growth (i.e. distribution, procurement, pricing or inventory management)
     
  • Hands-on experience transforming and consolidating data from heterogenous sources such as APIs, SQL Server, flat and excel files
     
  • Strong technical skills in SQL (i.e. Correlated Queries, Nested Subqueries, Common Table Expressions, Window Functions)
     
  • Knowledge in object-oriented programming and data analysis with Python (pandas, selenium, pulp, sklearn, tkinter, seaborn & matplotlib)
     
  • Development of web crawling solutions to subsequently build customized price and inventory intelligence tools based on acquired external as well as internal data
     
  • Creative out-of-the-box thinking due to a strong understanding of economic interrelations as well as technical challenges combined with an entrepreneurial spirit
     
  • Structured working method, with final product and the WHY at the forefront. In doing so, close communication with stakeholders to determine respective needs and achieve the desired objective together

Project history

07/2021 - Present
Business Intelligence Developer & Data Analyst
Analysis & Automation - Mathias Fiedler (Other, < 10 employees)
  • Further development of process automation & data analysis with Python (pandas, regex, built-in modules) and SQL (i.e., Correlated Subqueries, CTE, Window Functions)
  • Further Development of object-oriented programming in Python – inventory management, ERP, competitor intelligence
  • Introduction to linear programming (pulp)
  • Introduction to machine learning (supervised learning: knn, decision tree and regression analysis with scikit-learn)
03/2020 - 06/2021
Head of Business Intelligence
Blue City A/S (Consumer goods and retail, 50-250 employees)
  • Conceptualization, development, and implementation:
    • Automatized B2B offer handling – standardization, requirements and purchase price calculation as well as automatized reporting with purchase recommendations for individual traders (Python, SQL, Excel, VBA)
    • Web crawling and product database matching for dynamic price intelligence and competitor monitoring (Python, VBS, Excel)
    • Comprehensive C-Level dashboard landscape along the whole value chain of the company (SQL, Power BI Desktop & Server)
  • Establishment and development of a team of three BI Analysts
    (one senior, one intermediate, one junior)
09/2015 - 02/2020
Business Intelligence Manager
Blue City A/S (Consumer goods and retail, 50-250 employees)
  • Conceptualization, development, and implementation:
    • Automatized refurbishment-prioritization for all workshops and technicians based on internal transaction data (SQL, Excel, VBA)
    • Data-driven inventory intelligence tool for automatized product (re-)distribution for ten locations in Denmark and Sweden (Excel, VBA)
    • Sales-bonus-system with corresponding visualization and weekly reporting for ten sales locations with a staff of approx. 100 employees (Power BI, Excel, VBA)

Certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Microsoft
2022
IBM Certified: Analyzing Data with Excel (DA0130)
edX
2022

Local Availability

Open to travel worldwide
Reisebereitschaft vorhanden, allerdings muss überwiegender Teil der Anstellung remote möglich sein.
Profileimage by Mathias Fiedler Business Intelligence Developer (Power BI, DAX, Tabular Editor, Power Query, SQL, Excel) from Berlin Business Intelligence Developer & Data Analyst
Register