Остап

Ostap Polukainen
Prague, Czech Republic — — [открыть контакты](см. выше в блоке «контактная информация»)

SKI L LS
SQL: data querying, transformation, validation. SELECT, JOINs, subqueries, aggregations,
window functions, experience with PostgreSQL.

PowerBI: DAX measures, Power Query transformations, KPI design, M language (intermediate).

Excel: PivotTables, XLOOKUP/lookups, forecasting tools, advanced formulas.

Python: pandas, numpy, requests, pyspark, matplotlib. Data manipulation, cleaning, and
automation scripting.

P ROJE CT S
Power BI projects: E-Commerce Sales Analytics
- Designed star schema data models and automated data transformations via Power
Query across online store datasets.
- Built interactive dashboards delivering trend analysis, product performance metrics,
and regional sales comparisons.
- Implemented DAX measures for dynamic KPI calculations and multi-dimensional
ltering.
Excel project:
- Built and automated a -week rolling cash- ow forecast model, structuring weekly
in ows, out ows, and cash position data for repeatable nancial reporting.
Python and econometrical projects:
- Performed end-to-end data analysis on large datasets (energy consumption –
, healthcare costs), including data cleaning, transformation, and exploratory
analysis using pandas and NumPy.
- Developed automated analytical work ows and visual reports with matplotlib.
- Applied statistical modeling to identify and quantify key drivers within complex
datasets
Financial analysis of company:
- Analyzed years of structured nancial data for LINEA NIVNICE a.s. including
pro tability margins, cash ow dynamics, and operational risk factors, built a
performance summary.

E DUCATI ON
Masaryk University, Brno. / - /
Bachelor — Finance and Law

LA NGUAGE S
English: B , IELTS ( . ).

Czech: B , Masaryk University certi cate.
fi
2
0
fl
2
fi
4
2
2
3
fl
2
6
5
+
1
4
3
2
9
0
2
fl
7
0
2
2
2
2
1
fi
8
3
fi
0
0
5
7
6
2
0
fl
2
6
fl
fi
2
0
0
0