Vasyl

VASYL KYRYCHUK
DATA ANALYST
Location: Lviv, Ukraine (Remote / Office / Hybrid) | Phone: [відкрити контакти](див. вище в блоці «контактна інформація») | Email
Telegram | LinkedIn | GitHub | Tableau

SUMMARY
Data Analyst with a strong technical background in IT support and network administration and a Master's-equivalent degree in
Mechanics and Applied Mathematics. Skilled in SQL, Python, and Tableau for data extraction, exploratory data analysis (EDA),
statistical analysis, and data visualization. Completed end-to-end analytics projects, including e-commerce data analysis and A/B
testing. Experienced in solving technical problems and working with IT infrastructure, applying a structured and analytical approach to
data-driven decision-making.

SKILLS
Spreadsheets & BI: Pivot Tables, Data Cleaning, Visualization, Tableau Public, Power BI
SQL: Advanced Queries, Window Functions, Joins, Aggregations, CTEs
Python: Pandas, NumPy, Matplotlib, Exploratory Data Analysis (EDA)
Statistics & A/B: Hypothesis Testing (Z-test), Sample Ratio Mismatch (SRM), Statistical Significance
IT Infrastructure: System Administration, Network Setup (LAN/Switches), Server Diagnostics, Access Management
Tools & Languages: Google Colab, Jupyter Notebook, Git, GitHub | English (Intermediate), Ukrainian (Native)

EXPERIENCE
Data Analytics Projects 2026 – Present
• Data Extraction & Transformation: Querying relational databases using SQL (JOINs, CTEs, Window Functions) to extract, clean,
and aggregate metrics.
• Exploratory Data Analysis & Statistics: Analyzing user behavior in Python (Pandas, NumPy); conducting A/B test analysis,
hypothesis validation, and Z-tests.
• Reporting & Dashboards: Designing interactive Tableau dashboards to track business KPIs (AOV, Retention, LTV) and
communicating insights to stakeholders.
IT Support & Network Administration 2013 – 2024
Self-employed
• Server & Network Infrastructure: Installed, configured, and maintained Microsoft Windows Server systems, user access
permissions, switches, routers, and local networks (LAN).
• Hardware & Systems Maintenance: Assembled, upgraded, and diagnosed desktop computers, hardware defects, operating
systems, and core business software.
• Security & CCTV: Installed and configured video surveillance systems and related software.

PORTFOLIO PROJECTS
E-commerce Data Analysis
Performed end-to-end e-commerce data analysis using SQL (BigQuery), Python (Pandas), and Tableau. Extracted and cleaned data,
calculated key business metrics (Revenue, Conversion Rate, Average Order Value), analyzed customer behavior, traffic channels, and
devices, and created an interactive business dashboard.
GitHub project: Ecommerce-Data-Analysis
A/B Testing & Statistical Analysis
Conducted statistical analysis of an A/B experiment using Python (SciPy). Performed data validation, checked Sample Ratio Mismatch
(SRM), applied two-sample Z-tests, interpreted statistical significance, and visualized results in Tableau.
GitHub project: A-B-Test-Analysis
EDUCATION ADDITIONAL EDUCATION
Ivan Franko National University of Lviv (2000 – 2005) • Mate academy — Data Analytics Course
Master's Degree in Mechanics & Applied Mathematics • Harvard University — CS50: Introduction to CS
Faculty of Mechanics and Mathematics • Power BI Course

ACHIEVEMENTS
• Marathon Swimming (13 km): Completed an extreme 13 km open-water swim, demonstrating discipline and physical stamina.
• Charity Run: Completed the Krayna Uzhhorod 10 km charity run.