Работала в 2 компаниях 1 год 1 месяц
Образование, IT
Project experience
GoIT
Образование
5 месяцев
09.2023 - 02.2024
I have successfully completed the course and defended the final project
I have fulfilled 30 technical projects in the field of data analysis
Revenue Metrics Dashboard
https://public.tableau.com/app/profile/olha.boiko/viz/Final_project_2_17087790523350/Dashboard1
This dashboard is designed to assist product managers in monitoring income trends and conducting high-level analyses of project revenues. The dashboard includes metrics such as MRR, the number of paid users, ARPPU, new paid users per month, MRR from new users, churned users, churn rate, churned revenue, revenue churn rate, expansion revenue, contraction revenue, Lifetime (LT) and Lifetime Value (LTV). The data has been processed using PostgreSQL, and visualization has been performed in Tableau Public.
Google Store Analysis Dashboard
https://lookerstudio.google.com/s/nMEWlHPPTGo
The focus of the project is to analyze the publicly available dataset of the Google Merchandise Store. The analysis includes examining the primary user engagement metrics, identifying the most popular activities of users on the website, presenting the most visited pages, and dividing users into segments based on their country, gender, and device category. The report was generated using Google Analytics 4 data and Looker Studio as a visualization tool.
Cohort Analysis of User Retention
https://docs.google.com/spreadsheets/d/1YCA8yHRy-z3Xkw73KHyejukfNxa0t1_PrfLHFGz4M1A/edit#gid=1435993419
The data showcased in these cohort analysis tables pertain to user and product retention rates, and are derived from the game users dataset. To facilitate ease of use, the tables can be filtered based on user device language and game type. The presentation is crafted using Google Sheets' pivot tables, built-in functions, and slicers for optimal convenience.
QA Engineer
Infopulse / Інфопульс
IT
6 месяцев
12.2021 - 06.2022
Manual testing of Microsoft Power Apps web and desktop applications.
Writing of test documentation: test suites, test cases, bug reports.
Analysis and clarification of business requirements.
Major achievements:
- Improved the quality of the developed applications by finding and reporting about 200 bugs, which have led to significant improvements in the quality of the applications developed;
- Successfully organized and conducted customer acceptance sessions;
- Co-authored testing strategy documentation to ensure the highest efficiency and accuracy in the testing processes.
Ключевая информация
SQL (MSSQL, MySQL, PostgreSQL)
Python (Pandas, Matplotlib)
Google Sheets
Big Query
DBeaver
Jupiter
Tableau
Looker Studio
Amplitude
MS Power BI
MS Power Apps
Azure DevOps
Slack
Cohort analysis
Marketing Analytics
A/B testing
Agile/Scrum methodology
Manual testing techniques
Училась в 3 заведениях
Державний навчально-науковий заклад післядипломної освіти "Дипломатична академія України імені Геннадія Удовенка при Міністерстві закордонних справ України"
Комерційна дипломатія
Київ, 2013
Estonian School of Diplomacy
European Integration
Tallinn, 2011
Київський національний університет імені Тараса Шевченка
Інститут філології, переклад
Київ, 2007
Владеет языками
Английский
свободно
Может проходить собеседование на этом языке
Может проходить собеседование на этом языке
Немецкий
средний
Французский
средний
Украинский
родной
Может проходить собеседование на этом языке
Может проходить собеседование на этом языке
Курсы, тренинги, сертификаты
GoIT Data Analyst course
Data analysis, processing and visualization
Ольга
Ольга
Junior data analyst
Киев
полная занятость
Характер работы: удаленная работа, гибридная
Обновлено 2 месяца назад