Position: BI Analyst/ Power BI Engineer
Category: SQL
English level: fluent
Years of experience: 2.5

Main projects

Operational and financial performance analyzing (Worldwide online retailer)
- Data extracting, cleaning, and preprocessing (store names, many fields connected to a certain store, not preprocessed data) – Power Query, Python
- 30+ dashboards visualizing (sales splits by store, product, date, sales costs, and profits dynamics, etc.) –
Power BI

Analytical Platform for Financial Time Series Cyclicity Analysis
- Developed system for data gathering from investing.com, data transformations, and window
correlations comparison analysis for revealing patterns of the highest similarity to the current indices
dynamics
- using: Postgres, Power BI

Financial Indices Forecasting (Online booking service)
- Data analytics based on processed data (correlations, season indices) – Power Query, Python
- Dashboard’s preparation – Power BI

Social network activities analytics
- Data extracting, cleaning, and preprocessing – Power Query, Python
- Analytics (users’ distribution by age, degree, location, gender, etc, word frequency analysis (NLTK))
- Visualizations (pie-charts, histograms, pivot tables, etc)
- 2,5+ years of BI experience
- Data analysis and visualization expertise with Power BI
- Strong knowledge of PostgreSQL
- Practical experience in data processing, reporting, and ETL
- Proficient in querying data sets using SQL, building and maintaining data pipelines using SQL and Python
- Analytical thinking capabilities
- System thinking, ability to receive, structure, and systemize information