Michał Bzunek, PhD

Business Intelligence Expert at Smarketer GmbH
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Szczecin, Zachodniopomorskie, Poland, PL
Languages
  • angielski Full professional proficiency
  • polski Native or bilingual proficiency
  • niemiecki Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Go Beyond the Numbers: Translate Data into Insights
    Coursera
    Jul, 2023
    - Nov, 2024
  • Google Advanced Data Analytics Capstone
    Coursera
    Jul, 2023
    - Nov, 2024
  • Google Advanced Data Analytics Specialization
    Coursera
    Jul, 2023
    - Nov, 2024
  • Regression Analysis: Simplify Complex Data Relationships
    Coursera
    Jul, 2023
    - Nov, 2024
  • The Nuts and Bolts of Machine Learning
    Coursera
    Jul, 2023
    - Nov, 2024
  • The Power of Statistics
    Coursera
    Jul, 2023
    - Nov, 2024
  • Foundations of Data Science
    Coursera
    Jun, 2023
    - Nov, 2024
  • Get Started with Python
    Coursera
    Jun, 2023
    - Nov, 2024
  • Survival Analysis in Python
    DataCamp
    May, 2023
    - Nov, 2024
  • Marketing Analytics: Predicting Customer Churn in Python
    DataCamp
    Apr, 2023
    - Nov, 2024
  • Statistical Techniques in Tableau
    DataCamp
    Apr, 2023
    - Nov, 2024
  • Data Processing in Shell
    DataCamp
    Mar, 2023
    - Nov, 2024
  • Data Storytelling Concepts
    DataCamp
    Mar, 2023
    - Nov, 2024
  • GitHub Concepts
    DataCamp
    Mar, 2023
    - Nov, 2024
  • Introduction to Shell
    DataCamp
    Mar, 2023
    - Nov, 2024
  • Understanding Data Engineering
    DataCamp
    Mar, 2023
    - Nov, 2024
  • Introduction to Git
    DataCamp
    Feb, 2023
    - Nov, 2024
  • Introduction to Version Control with Git
    DataCamp
    Feb, 2023
    - Nov, 2024
  • Google Ads Search Certification
    Google
    Jan, 2023
    - Nov, 2024
  • Analyzing Data in Tableau
    DataCamp
    Dec, 2022
    - Nov, 2024
  • Case Study: Analyzing Customer Churn in Tableau
    DataCamp
    Dec, 2022
    - Nov, 2024
  • Connecting Data in Tableau
    DataCamp
    Dec, 2022
    - Nov, 2024
  • Creating Dashboards in Tableau
    DataCamp
    Dec, 2022
    - Nov, 2024
  • Exploratory Data Analysis in SQL
    DataCamp
    Oct, 2022
    - Nov, 2024
  • Intermediate SQL Server
    DataCamp
    Oct, 2022
    - Nov, 2024
  • Introduction to SQL Server
    DataCamp
    Oct, 2022
    - Nov, 2024
  • Introduction to Tableau
    DataCamp
    Oct, 2022
    - Nov, 2024
  • Time Series Analysis in SQL Server
    DataCamp
    Oct, 2022
    - Nov, 2024
  • Intermediate SQL
    DataCamp
    Sep, 2022
    - Nov, 2024
  • Joining Data in SQL
    DataCamp
    Sep, 2022
    - Nov, 2024
  • Introduction to SQL
    DataCamp
    Aug, 2022
    - Nov, 2024
  • Object-Oriented Programming in Python
    DataCamp
    Aug, 2022
    - Nov, 2024
  • Introduction to Regression with statsmodels in Python
    DataCamp
    Jul, 2022
    - Nov, 2024
  • Cluster Analysis in Python
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Data Scientist with Python Track
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Introduction to NumPy
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Introduction to Statistics in Python
    DataCamp
    Jun, 2022
    - Nov, 2024
  • Case Study: School Budgeting with Machine Learning in Python
    DataCamp
    May, 2022
    - Nov, 2024
  • Machine Learning with Tree-Based Models in Python
    DataCamp
    May, 2022
    - Nov, 2024
  • Machine Learning with scikit-learn
    DataCamp
    May, 2022
    - Nov, 2024
  • Unsupervised Learning in Python
    DataCamp
    May, 2022
    - Nov, 2024
  • Data Analyst with Python Track
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Intermediate Data Visualization with Seaborn
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Statistical Thinking in Python (Part 1)
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Statistical Thinking in Python (Part 2)
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Streamlined Data Ingestion with pandas
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Working with Categorical Data in Python
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Working with Dates and Times in Python
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Writing Functions in Python
    DataCamp
    Apr, 2022
    - Nov, 2024
  • Analyzing Police Activity with pandas
    DataCamp
    Mar, 2022
    - Nov, 2024
  • Cleaning Data in Python
    DataCamp
    Mar, 2022
    - Nov, 2024
  • Data Manipulation with Python
    DataCamp
    Mar, 2022
    - Nov, 2024
  • Exploratory Data Analysis in Python
    DataCamp
    Mar, 2022
    - Nov, 2024
  • Introduction to Data Visualization with Matplotlib
    DataCamp
    Mar, 2022
    - Nov, 2024
  • Introduction to Data Visualization with Seaborn
    DataCamp
    Mar, 2022
    - Nov, 2024
  • ETL in Python
    DataCamp
    Feb, 2022
    - Nov, 2024
  • Finance Fundamentals in Python Track
    DataCamp
    Feb, 2022
    - Nov, 2024
  • Introduction to Portfolio Analysis in Python
    DataCamp
    Feb, 2022
    - Nov, 2024
  • Joining Data with pandas
    DataCamp
    Feb, 2022
    - Nov, 2024
  • Importing and Managing Financial Data in Python
    DataCamp
    Jan, 2022
    - Nov, 2024
  • Data Analysis in Excel
    DataCamp
    Dec, 2021
    - Nov, 2024
  • Finance Fundamentals in Spreadsheets Track
    DataCamp
    Dec, 2021
    - Nov, 2024
  • Loan Amortization in Spreadsheets
    DataCamp
    Dec, 2021
    - Nov, 2024
  • Manipulating Time Series Data in Python
    DataCamp
    Dec, 2021
    - Nov, 2024
  • Intermediate Python for Finance
    DataCamp
    Sep, 2020
    - Nov, 2024
  • Introduction to Financial Concepts in Python
    DataCamp
    Sep, 2020
    - Nov, 2024
  • Data Manipulation with pandas
    DataCamp
    Aug, 2020
    - Nov, 2024
  • Data Science for Everyone
    DataCamp
    Aug, 2020
    - Nov, 2024
  • Merging DataFrames with pandas
    DataCamp
    Aug, 2020
    - Nov, 2024
  • Financial Forecasting in Python
    DataCamp
    Feb, 2020
    - Nov, 2024
  • AI Fundamentals
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Data Science for Business
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Data Skills for Business Track
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Data Visualization in Spreadsheets
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Financial Analytics in Spreadsheets
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Financial Modeling in Spreadsheets
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Importing & Cleaning Data with Python Track
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Introduction to Databases in Python
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Introduction to Relational Databases in SQL
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Manipulating DataFrames with pandas
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Marketing Analytics in Spreadsheets
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Pivot Tables in Spreadsheets
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Python Programmer Track
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Spreadsheet Fundamentals Track
    DataCamp
    Jan, 2020
    - Nov, 2024
  • Python for Spreadsheet Users
    DataCamp
    Jun, 2019
    - Nov, 2024
  • Joining Data in SQL
    DataCamp
    Mar, 2019
    - Nov, 2024
  • Introduction to Data Science in Python
    DataCamp
    Feb, 2019
    - Nov, 2024
  • pandas Foundations
    DataCamp
    Feb, 2019
    - Nov, 2024
  • Intermediate Spreadsheets for Data Science
    DataCamp
    Nov, 2018
    - Nov, 2024
  • Intro to Python for Finance Course
    DataCamp
    Nov, 2018
    - Nov, 2024
  • Excel Statistics Essential Training: 1
    LinkedIn
    Aug, 2018
    - Nov, 2024
  • Learning Excel Cluster Analysis
    LinkedIn
    Aug, 2018
    - Nov, 2024
  • Cleaning Data in Python Course
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Data Analysis with Spreadsheets Course
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Intermediate Importing Data in Python
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Intermediate Python
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Introduction to Importing Data in Python
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Python Data Science Toolbox (Part 1) Course
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Python Data Science Toolbox (Part 2) Course
    DataCamp
    Jul, 2018
    - Nov, 2024
  • Python Fundamentals
    DataCamp
    Jul, 2018
    - Nov, 2024

Experience

    • Germany
    • Advertising Services
    • 100 - 200 Employee
    • Business Intelligence Expert
      • Jan 2023 - Present

      • Utilized dbt (Data Build Tool) to design and implement SQL and Python (Jinja) models, optimizing data workflows for enhanced analytics. • Automated procedures with Python and used essential libraries like pandas, NumPy, SciPy, Math, and scikit-learn in order to boost operational efficiency and data-driven insights. • Applied data engineering skills in Python to optimize connectors for accurate data retrieval, while enhancing error handling procedures crucial for various business operations. • Led data science initiatives, where I developed and deployed Python-based AI models that played a pivotal role in enabling data-informed decision-making processes, contributing significantly to project success and outcomes. • Proficiently used Tableau for creating insightful data visualizations and prepared data sources, including BigQuery and other platforms. • Collaborated effectively with stakeholders across all organizational levels to drive project completion, leveraging strong interpersonal skills to align business objectives and deliver results. • Successfully collaborated with external agencies/vendors to accomplish diverse projects and managed the data warehouse, showcasing effective partnership skills essential for project success and data infrastructure management Show less

    • Assistant Professor
      • Mar 2016 - Present

      • Delivering lectures, seminars and tutorials for both Polish and international students (also on weekends)• Designing, preparing and developing teaching materials.• Assessing students’ work, advising students, setting and marking examinations.• Undertaking personal research projects and actively contributing to the institution's research profile.• Participating in research projects and research teams.• Writing up research and preparing it for publication.• Providing a personal commitment to, and achievement in a particular scholarly area, participating in research projects and research teams, developing a record of publication.• Conducting blind reviews for ZPSB’s journal (“Firma i Rynek”), and recommending the manuscripts to be accepted with no revisions, accepted with revisions (minor or major), or rejected. Show less

    • Teaching and Research Assistant
      • Nov 2011 - Feb 2016

      • Preparing and delivering lectures for various college courses – related to the field of corporate finance.• Preparing course material for the students • Evaluating and grading examinations, assignments, or papers and record grades • Scheduling and maintaining regular office hours to meet with students.• Assisting with academic research.• Gathering and analyzing data.• Publishing scholastic papers.• Carrying out discussions and academic talks.• Assistsing in administrative duties. Show less

    • International Business Studies Manager
      • Nov 2011 - Feb 2016

      • Maintaining, managing, and building relationship with the ZPSB representatives and partners.• Administer contracts and agreements with partners.• Liaise regularly with partners to ensure contract requirements are being fulfilled and standards met.• Undertaking desk research of potential partners.• Managing and creating the International Business Studies website’s content.• Supporting creation of promotional materials.• Providing support for candidates in admission process, accommodation and visa procedures. • Carrying out administrative tasks related to the department, such as student admissions, induction programmes and involvement in committees and boards.• Attending the relevant educational expos. Show less

    • Adjunct Instructor
      • Oct 2008 - Nov 2011

      • Developed and delivered engaging lectures to graduate and undergraduate students on corporate finance topics.• Conducted in-depth research and published scholarly papers on finance-related subjects.• Maintained accurate records of student attendance, grades, and progress.• Designed and graded assignments that challenged students to apply critical thinking and problem-solving skills.• Developed and updated course materials to ensure relevance and quality of content.

    • Utilities
    • 1 - 100 Employee
    • Energy Data Scientist
      • Jul 2021 - Jan 2023

      • Developing and testing RES electricity production forecasting algorithms in python using datasets such as load, weather, historical, etc. • Using requests, BeautifulSoup and other Python libraries to extract desired data from various URLs in an automated way. • Conducting analyses, modeling and optimization procedures related to energy markets, using multiple analytical methods and energy domain expertise. • Reviewing data for accuracy, anomalies, unexpected patterns and completeness, consistency, and integrity using Pandas, Numpy and other Python libraries. • Generation of various reports and data visualization using Python packages like matplotlib and Seaborn. • Developing and testing electricity price forecasting algorithms, and arbitrage strategies using large datasets related to energy markets such as grid, load, weather, historical, forward markets etc. Show less

    • Poland
    • Renewables & Environment
    • 300 - 400 Employee
    • Data Analyst (Electricity Market Analyst / Wholesale Electricity Trading Specialist)
      • Jun 2020 - Jul 2021

      Employer - Columbus Obrót Sp. z o.o. (subsidiary company of Columbus Energy S.A., former Vortex Energy - Obrót Sp. z o.o.) • Developed and improved day-ahead and intraday production output forecasting models of renewable power generation (for both photovoltaic and wind farms) in python (using ML and ANN algorithms). • Created forecasting models and automated data reporting procedures which are required by Transmission System Operator and Distribution System Operators (DSOs) according to System Operation Guidelines (SOGL). • Automated processes and developed various economic plans, and models in order to support business operations, e.g. hourly price forward curve model. • Built models and analyzed data to discover trends and patterns using Python and R. • Prepared dashboards and stories for reporting. • Cooperated with business partners, DSOs and TSO. • Actively traded on the wholesale electricity market (DAM, XBID). Show less

  • CRB Sp. z o.o.
    • Szczecin, West Pomeranian District, Poland
    • Data Analyst
      • Mar 2016 - Jun 2020

      • Collaborated with clients to conduct initial assessments of complex situations and evaluate their financial positions. • Utilized Python, leveraging libraries such as NumPy, pandas, and Matplotlib, for data analysis to provide on-demand insights, enabling informed decision-making. • Developed metrics and interactive dashboards to distill raw data into actionable insights, particularly in the realm of corporate finance. This encompassed tasks such as business valuations, investment assessments, financial statement analyses, and financial projections. • Demonstrated critical thinking, problem-solving prowess, and a keen aptitude for data analysis e.g. using Python to extract meaningful information from datasets. • Produced comprehensive reports on data findings that influenced business performance and strategic direction. • Delivered tailored solutions and recommendations that precisely addressed clients' needs, contributing to their success. • Kept up-to-date with industry trends and developments by closely monitoring financial markets, assessing general economic conditions, and staying informed about emerging financial products. Show less

    • Finland
    • Higher Education
    • 500 - 600 Employee
    • Academic Exchange
      • Sep 2015 - Sep 2015

      In September 2015 I delivered lectures for following modules: • Financial Planning and Control • Management Accounting • Corporate Finance In September 2015 I delivered lectures for following modules: • Financial Planning and Control • Management Accounting • Corporate Finance

    • United States
    • 700 & Above Employee
    • Self Employed
      • Jul 2011 - Jan 2015

      • Offered a diverse range of tailored business consulting services, including but not limited to valuations, investment assessments, in-depth financial statement analyses, and precise financial projections. • Played a pivotal role in the formulation of comprehensive business plans and the development of strategic operational strategies. This encompassed conducting thorough market analyses and actively participating in fundraising efforts to secure vital resources. • Conducted extensive research and gathered critical information to inform strategic decision-making processes, ensuring that clients had access to the most up-to-date and relevant data. • Conducted rigorous financial analyses, utilizing advanced tools and techniques, to generate insightful reports that guided clients in their pursuit of financial growth and stability. Show less

    • Poland
    • Higher Education
    • 100 - 200 Employee
    • Teaching and Research Assistant
      • Nov 2010 - Sep 2011

      • Designed and delivered engaging lectures across a spectrum of college courses, ensuring effective knowledge dissemination to students. • Developed comprehensive course materials that enriched the learning experience and supported students' academic growth. • Conducted thorough evaluations of examinations, assignments, and papers, meticulously recording grades to provide constructive feedback to students. • Maintained a consistent schedule of office hours, creating an accessible environment for students to seek guidance, discuss coursework, and receive academic support. • Actively contributed to academic research initiatives, participating in data collection, analysis, and scholarly endeavors. • Authored and published scholarly papers that contributed to the academic discourse, disseminating valuable knowledge within the field. Show less

Education

  • Uniwersytet Szczeciński
    Doctor of Philosophy - PhD, Finance (Finanse)
  • Zachodniopomorska Szkoła Biznesu w Szczecinie
    M.A. (Magister - Mgr), Economics (Ekonomia)
  • Wyższa Szkoła Bankowa we Wrocławiu
    M.A. (Magister -Mgr), Finance and Accounting (Finanse i Rachunkowość)
  • Wyższa Szkoła Bankowa we Wrocławiu
    Postgraduate Studies (Studia podyplomowe), Banking (Bankowość)
  • Wyższa Szkoła Integracji Europejskiej
    B.A. (Licencjat - Lic.), Management and Marketing (Zarządzanie i marketing)

Community

You need to have a working account to view this content. Click here to join now