About me
Stay in the Know
Ing. Matěj Srna:
My name is Matěj Srna and I started my professional journey as an audit associate for APOGEO Audit during my studies at the University of Economics. After graduation, I started working for KPMG which further strengthen my knowledge and skill set. The work of audit associates relates not only to accounting but also to some portion of data.
In order to strengthen my skill set, I left KPMG and move to the private sector. I worked as Finance and Business analyst for a manufacturing company called Trouw Nutrition Biofaktory, ltd. I quickly realized that most of my work relates to the processing of data and creating reports for management.
I wanted to learn more effective and efficient ways how to gather, clean, and process large amounts of data.
In order to achieve my goal, I started a Software Development Academy course on Data Science. Even before the beginning of this course, I found an interest in Python (mainly because of 100 Days of Code: The Complete Python Pro Bootcamp for 2022). So I became a Business Intelligence analyst.
"Commit yourself to lifelong learning. The most valuable asset you'll ever have is your mind and what you put into it."
-Albert Einstein.
Education
09/2023 - Nowadays
-
University of Economics Prague - Prague, The Czech Republic - Data and Analytics for Business Management (MBA degree)
09/2015 - 06/2020
-
University of Economics Prague - Prague, The Czech Republic - Accounting and finance (Bachelor and Master degree)
09/2019 - 12/2019
-
Peter B. Gustavson School of Business, University of Victoria - Victoria, British Columbia Canada - Business and management
09/2017 - 02/2018
-
Vrije Universieit Brussel - Brusesels, Belgium - Business and management
09/2011 - 06/2015
-
OA Heroldovy Sady, Prague, The Czech Republic - Economic Lyceum
03/2023 - Nowadays
-
Business Intelligence Analyst & Project Manager - Byteca.com, ltd. Prague
-
Data transformation and BI reporting
-
TeamLeader
-
Using Python, Power BI - Dax, MS Azure SQL database, and Azure Platform
-
06/2023 - Nowadays
-
Consultant - INFA Partner, ltd. Prague
-
Data transformation and BI reporting
-
Consultation for Business Intelligence
-
Using Python, Power BI - Dax, MS Azure SQL database
-
08/2022 - Nowadays
-
Data Analyst - ThisOne, ltd. Prague
-
Data transformation and BI reporting
-
Using Keboola, Python, Power BI - Dax, MS Azure SQL database
-
11/2022 - 01/2023
-
Consultant/Professional - Analytics - Lidl Czech Republic, General partnership, Prague
-
Combining Data Science and Finance to meet business goals
-
Using MS Azure, Databricks, Python, SQL
-
09/2021 - 10/2022
-
Finance and Business Analyst - Trouw Nutrition Biofaktory, ltd. Prague
-
Finance and controlling with a focus on various analysis
-
Advanced Excel + Power BI - Dax
-
09/2020 - 08/2021
-
Audit Analyst - KPMG Czech Republic Audit, ltd. Prague
-
Statutory audit, administrative work
-
01/2020 - 07/2020
-
Audit associate - APOGEO Audit, ltd. Prague
-
Statutory audit, administrative work
-
05/2018 - 08/2019
-
Audit associate - APOGEO Audit, ltd. Prague
-
Statutory audit, administrative work
-
Work experiences
Knowledge and skills
Skills:
-
MS Word, MS Excel - Advanced
-
Power BI and Power Query
-
Python, MySQL
Courses:
-
Power BI and Power Query - Excel Town
-
100 Days of Code: The Complete Python Pro Bootcamp for 2022 - Udemy
-
Software Development Academy - Data Science
-
Complete 2022 Data Science & Machine Learning Bootcamp - Udemy
-
Power BI Masterclass - beginners to advanced - Udemy