Olena

OLENA RUBANENKO
Odesa, Ukraine • [відкрити контакти](див. вище в блоці «контактна інформація») • LinkedIn • GitHub • Tableau • LeetCode
__________

Data analyst with nearly three years of self-driven experience in data analysis, primarily focusing on
Python programming, SQL, and data visualization using tools like Tableau. With an extensive
portfolio of personal projects demonstrating a commitment to mastering the craft, transitioning my
passion into a career in data analysis is my goal.

PERSONAL PROJECTS
__________

Data Preprocessing, Building Permit
Goal: preprocessing for further analysis and modeling by handling missing values, data type
conversions, and other necessary adjustments.
Techniques:
Mode imputation, Unavoidable Missing Data, Forward filling, Mean imputation, Non-informative
Value imputation
Link: https://github.com/Subzerowitch/Data-Preprocessing

Exploratory Data Analysis, Adidas Sales
Goal: analyze the sales data to identify trends and patterns.
Techniques:
Data Preparation using Pandas, Correlation Matrix using Seaborn, Trend Analysis using Matplotlib,
Visualization using Matplotlib, Simple Linear Regression using Sklearn, Dashboard in Tableau
Link: https://github.com/Subzerowitch/EDA
Viz: https://public.tableau.com/app/profile/olena.rubanenko/viz/AdidasSales2020-2021/Dashboard1?publish=yes

Visualizing COVID-19 Statistics with SQL Data Analysis
Goal: extract valuable insights from a COVID-19 dataset by employing SQL queries.
Techniques:
Filtering , Aggregate functions and Grouping, Joining tables , Temporary tables and views
Link: https://github.com/Subzerowitch/ProjectCovid-19
Viz: https://public.tableau.com/app/profile/olena.rubanenko/viz/Covid-19_16878630219010/Dashboard1

Python Project, Web Scraping Multiple Pages on Amazon
Goal: scrape data from the Amazon Best Sellers page for Kindle eBooks.
Techniques:
HTTP requests, Parsing the HTML content , Extracting relevant information, Reading and writing data to
CSV, Writing test cases
Link: https://github.com/Subzerowitch/Amazon_Web_Scraping

Bike Path Usage Analysis and Prediction (Poisson Regression)
Goal: predict the number of riders on one path based on the number on another path.
Techniques:
Exploratory Data Analysis, Correlation Matrix and Feature Selection , Outlier Capping, Model Building and
Evaluation, Model Visualization, RMSE
Link: https://github.com/Subzerowitch/Poisson-Regression

EDUCATION
__________

Bachelor of Arts For Teaching: Spanish Language And English Literature 2014
Kherson State University, Ukraine

SKILLS & OTHER
__________

• Python (Pandas, Sklearn, Matplotlib, • Languages (English, Spanish, Ukrainian,
Seaborn, Russian)
Numpy, Pygame, Unittest, BeautifulSoup) • Communication
• Pycharm • Teamwork
• MS SQL • Problem Solving
• PostgreSQL • Rapid Skill Acquisition
• Azure Data Studio • Time Management
• Jupyter Notebook • Critical Thinking
• Tableau • Empathy
• Excel • Conflict Resolution
• Command Line Interface • Attention to Detail
• Linear Algebra (Basics) • Cultural Sensitivity
• Statistics • Decision Making

WORK HISTORY
__________

• Part-Time English/Spanish Teacher at Private School (2015-2017)

• Customer Service Agent (Promoted to Team Leader of Customer Support Department)
Online-store of gold bars, Belize City (2017-2020, Remotely 2021-2022)

• ESL Kindergarten Teacher in China, Beijing (2020-2021)

• English to Spanish Interpreter (Freelance)