Ігор

IHOR BILAN
Junior Data Analyst
[open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section) | Kropyvnytskyi, Ukraine
[open contact info](look above in the "contact info" section) | github.com/linikin31

SUMMARY
Junior Data Analyst with hands-on experience in SQL, Python, data cleaning, exploratory data analysis, and dashboard
development gained through educational projects. Worked with datasets containing 49,000+ records, identified trends and
patterns, and presented findings through analytical reports and visualizations. Previous experience in sales developed a
strong understanding of customer needs, sales operations, inventory processes, and accurate daily reporting.

HARD SKILLS & TOOLS
SQL, Python, Data Cleaning, Data Validation, Exploratory Data Analysis, Statistical Analysis, Data Visualization, Dashboard
Development, Reporting, Data Storytelling, Business Metrics
Pandas, NumPy, Matplotlib, BigQuery, Excel, Google Sheets, Tableau, Git

PROJECT EXPERIENCE
Stack Overflow Developer Survey Analysis — Educational Project
Tools: Python, Pandas, Matplotlib
Analyzed 49,000+ survey responses to examine salary differences, remote-work patterns, and Python adoption. Cleaned
missing and inconsistent values, grouped respondents by key characteristics, and visualized major trends.
Key findings:
● Python adoption was highest among developers aged 18–24 (40%), gradually declining with age.
● The 75th percentile of annual compensation reached $120,596, with Software Development the leading industry
among top-earning remote professionals.
● The United States, Germany, and India accounted for the largest share of survey respondents.
Result: Prepared a structured analytical report summarizing compensation, demographic, and technology-adoption
patterns.
Streaming Service Churn & Revenue Analysis — Educational Project
Tools: SQL, Google Sheets, Tableau
Cleaned and analyzed streaming-service data, calculated churn and revenue-related indicators, and built an interactive
dashboard comparing content types, countries, devices, and subscription plans.
Key findings:
● Series drove the most views (210), closely followed by documentaries (197) and movies (193).
● The USA, France, and Germany together accounted for over 60% of total views, forming the core audience.
● Average watch time exceeded 85 minutes with an 8.33% churn rate; subscription preferences varied by country
(UK leaning Basic, Germany and France leaning Premium).
Result: Delivered a structured dashboard highlighting audience behavior and churn-related patterns to support retention
and content decisions.

EDUCATION
Volodymyr Vynnychenko Central Ukrainian State University — Bachelor's degree, Practical Psychology (2014–2018)
Volodymyr Vynnychenko Central Ukrainian State University — Master's degree, Education Establishment Management
(2018–2019)
IT School GoIT — Data Analyst Program (2025–2026)

LANGUAGES
English — Pre-Intermediate | Ukrainian — Native