Data · BI · IT & Business Analyst · SQL Server · Python · Power BI · BPMN
15 years in industry. Since 2022 I turn requirements from production into working solutions, test them with the users and check the results in the data.
For 15 years I have worked in industry, where the answer to almost every problem is in the data. My job has always been to collect it, read it and find out what it is telling us.
Requirements and change analysis · since 2022
- Gather and analyse requirements from operators and production staff
- Turn them into specifications for an external Siemens programmer, including data inputs such as the exact fault timestamps for the history analysis or an inventory of drives (name, converter type, serial number)
- Test every change on site with the operators (user acceptance), explain the change to them after go-live and keep the documentation up to date
- Example: an unclear fault message and a manual reset made the kiln wait 10 to 60 minutes for maintenance. After the change, operators see the cause and reset the fault from the control room in about 20 seconds.
Operational data, collection and analysis
- Collect and record energy consumption for each production line
- Analyse alarm and signal histories from the control system (AVEVA InTouch, Siemens S7 PLCs in TIA Portal) to find the root cause of faults, filtering the records until the data explains what happened
- Example: a kiln stopped calculating its fuel dose. By filtering the previous day's signal records I traced it to a single sensor that never sent its "open" signal. One missing data point stopped the whole calculation. That is why I check data before I trust it.
Data and BI · now
- End-to-end project on real Czech energy data: Python, SQL Server star schema, T-SQL analysis, Power BI (in progress)
- I bring what many junior analysts are still learning: domain knowledge of industry and energy, and the habit of proving a number before reporting it
Technical education in power electrical engineering, automation and computer systems.
Open to data / BI analyst, IT / business analyst and application specialist roles · Olomouc region · Brno · Prague · hybrid
Change request process analysis (business / IT analysis)
How does an operator's request become a tested change in a production control system, and how could the process work better?
- Process: as-is and to-be in BPMN 2.0, gap analysis with 5 improvements, system context diagram
- Specification of a real change: functional and non-functional requirements, business rules, acceptance criteria
- Testing: user acceptance test with the actual results and a traceability matrix from requirement to test
- Also: user stories with MoSCoW priorities, RACI matrix
- Result of the change: the operator resets the fault from the control room in about 20 seconds instead of 10 to 60 minutes
Energy Crisis Cost Analysis (data / BI)
How much did the 2021–2023 energy crisis cost a Czech company, and could it have been hedged?
- Finding: in 2022 the Czech day-ahead market traded electricity worth 7.5× more than in 2020, while the volume grew only 8 %. The price did almost all of it.
- Company cost: the all-in electricity price of the model company (simulated load) rose from 1.62 CZK/kWh in 2020 to 7.19 CZK/kWh in 2022, including distribution, renewables support and tax
- Pipeline: Python download, cleaning, SQL Server star schema (7 tables), T-SQL analysis (CTE, window functions, weighted averages), Power BI (in progress)
- Data: 43,848 hourly prices from OTE-ČR, EUR/CZK and repo rate from ČNB, regulated prices from ERÚ. Real public data, no Kaggle.
- Quality: 27 data-quality tests, and the exchange rates are cross-checked against the ČNB REST API (JSON) on 6 edge-case days: 6 of 6 match
- Outlier ≠ error: a price spike of 844 EUR/MWh on 12 Dec 2024 traced to a Dunkelflaute in Germany, verified against the raw source and kept in the data
- Start with the user. First I find out how people really do the work today, then I propose a change.
- Verify, then trust. Every result is executed and cross-checked by a second, independent query or source.
- Document decisions. Grain of every table, KPI definitions, specifications, decision records (ADRs).
- Explain it simply. Findings with numbers, written for the person who decides, not for another analyst.
T-SQL · CTE · window functions · star schema · data quality testing · ETL · REST API (JSON) ·
requirements analysis · BPMN 2.0 · process analysis · specification · user acceptance testing ·
technical documentation · Siemens TIA Portal / SCADA
| Certificate | Issuer | Date | Verify |
|---|---|---|---|
| IBM Data Analyst Professional Certificate (11 courses) | IBM · Coursera | Jan 2026 | verify |
| Microsoft Power BI Data Analyst Professional Certificate (8 courses) | Microsoft · Coursera | May 2026 | verify |
| Microsoft SQL Server Professional Certificate (5 courses) | Microsoft · Coursera | Jun 2026 | verify |