Анна

[открыть контакты](см. выше в блоке «контактная информация»)
Anna [открыть контакты](см. выше в блоке «контактная информация»)
Telegram @anettsavchuk

Savchuk LinkedIn [открыть контакты](см. выше в блоке «контактная информация»)
Lviv, Ukraine
DATA ANALYST


SUMMARY
Detail-oriented Data Analyst currently completing a degree in Information Technologies in Business. Proficient in
SQL, Python, and BI tools (Tableau, Looker Studio), with a strong focus on data extraction, cleaning, and
visualization. Experienced in building practical data solutions and developing clear dashboards for real-world
retail and service businesses. Known for a persistent approach to troubleshooting and a reliable commitment to
delivering accurate, timely results. Passionate about transforming messy data into structured reports that help
understand business processes.
SKILLS

● Spreadsheets: Pivot Tables, Data Cleaning, Visualization
● SQL: Advanced Queries, Window Functions, Query Optimization, Common Table Expressions (CTE)
● Python: Pandas, NumPy, Matplotlib, Seaborn, Exploratory Data Analysis (EDA)
● Tableau: Interactive Dashboards, Data Storytelling, Publishing
● Statistics: Sampling, Hypothesis Testing, Correlation, Statistical Significance
● A/B Testing: Planning, Analysis, Reporting
● Other Tools: Jupyter Notebooks, Google Analytics, Excel, Git
● Languages:Ukrainian (native), English (Intermediate)

Portfolio:
Project 1 (SQL-Data-Analysis-Tasks ) – A comprehensive collection of SQL scripts addressing diverse business
scenarios, including email marketing performance, lifecycle tracking, and cumulative revenue forecasting.
Demonstrated proficiency in Google BigQuery, utilizing advanced CTEs, Window Functions, and conditional
aggregations to ensure data integrity and avoid join-induced data duplication (fan-out).
● Link to review https://github.com/anechkasavchukk/SQL-Data-Analysis-Tasks

Project 2 (E-commerce Sales Analytics: Python) – Executed end-to-end data pipeline processing, cleaning,
and exploratory data analysis (EDA) on large-scale global transaction logs. Successfully resolved parsing
anomalies (including null traps), handled systematic missing categorical indicators, and implemented strategic
multi-source data merges using Pandas and NumPy to protect core financial metrics.

● Link to review: https://github.com/anechkasavchukk/Ecommerce-Sales-Analytics-Python

Project 3 (Tableau Data Visualization & BI Portfolio) – A diverse collection of interactive dashboards and
business intelligence reports tracking operational efficiency, marketing ROI, and user behavior.

● Key Dashboards Included:
 ○ Cohort Analysis: Customer retention and engagement tracking using cohort grids to monitor
user lifecycle stages.
○ SEO & Session Analysis: Web analytics dashboards examining traffic sources, user sessions, and
performance metrics.
○ Dynamic Content Trends: Data storytelling dashboards focusing on media content metadata
and distribution.
● Link to portfolio: https://public.tableau.com/app/profile/anna.savchuk6598/vizzes

Project 4 (E-commerce Sales Analysis: SQL + Python + Tableau) – An end-to-end business analysis of
transactional data. Extracted and normalized raw data via BigQuery, conducted deep exploratory analysis and
statistical hypothesis testing in Python, and designed an interactive Executive Tableau Dashboard to monitor
sales dynamics and category-level profitability.
● Link to review https://github.com/anechkasavchukk/Sales_Analytics

Project 5 (A/B Testing: Statistical Significance Analysis) – Statistical significance analysis of 4 distinct
product A/B tests for an e-commerce platform's interface using a two-proportion z-test (statsmodels).
Processed raw event-level data (~800K rows) in Python, filtering and breaking down results by user segments:
country, device, and traffic channel.
● Link to review
https://github.com/anechkasavchukk/AB-testing-sifnificance-analysis#ab-testing-statistical-significance-a
nalysis

EDUCATION
Institution: Ivan Franko National University of Lviv
Qualification and Degree: Bachelor's Degree in Economics (Major: Information Technologies in Business)
Dates Attended: 2023 - 2027

ADDITIONAL EDUCATION
● Data Analyst course at Mate academy

ACHIEVEMENTS
● Wrote an article ‘COMPREHENSIVE ANALYSIS AND MODELING OF BUSINESS PROCESSES OF A
SERVICE ENTERPRISE USING BPMN NOTATION IN THE CONDITIONS OF DIGITALIZATION (USING THE
EXAMPLE OF A SEWING STORE) ’ https://www.business-navigator.ks.ua/journals/2026/85_2026/118.pdf
in May 2026]