Personal information hidden

OKSANA PANCHYSHYN
JUNIOR DATA ANALYST
LVIV, UKRAINE

Phone: [open contact info](look above in the "contact info" section) email: [open contact info](look above in the "contact info" section) Telegram: @jaebumbom
GitHub: https://github.com/Sanaai15 Linkedin: [open contact info](look above in the "contact info" section)

SUMMARY
Junior Data Analyst with hands-on experience in data analysis, data cleaning, and reporting gained through
educational and personal projects. Skilled in SQL, Python (Pandas), Google Sheets, and BigQuery for transforming
raw data into meaningful insights. Experienced in analyzing user behavior, building cohort analyses, and creating
data-driven reports.

SKILLS
HARD SKILLS
SQL (data extraction, filtering, joins, aggregations, cohort analysis), DBeaver;
Python, Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook;
Data Visualization, Tableau Public, Power BI, Google Sheets, Excel, Pivot Tables;
A/B Testing & Statistical Analysis, Cohort Analysis, Segmentations, Product & Business Metrics

SOFT SKILLS
Analytical Thinking, Problem Solving, Attention to Detail, Critical Thinking;
Communication Skills, Team Collaboration, Adaptability, Organization Skills;
Time Management, Continuous Learning, Clear Writing, Data Storytelling;

PROJECT EXPERIENCE
User Retention Analytics
Link to project: https://github.com/Sanaai15/User-Retention-Analytics-SQL-Google-Sheets-
Objective:
Analyze user retention and evaluate acquisition quality by comparing promotional and organic user
groups.
Tasks Performed:
Extracted and prepared data from a relational database using SQL.
Cleaned and transformed date fields with different formats.
Calculated user cohorts and customer tenure.
Computed retention metrics and cohort-based KPIs.
Built interactive cohort tables and retention reports in Google Sheets.
Compared retention performance of promotional and organic users.
Identified patterns in user behavior and acquisition effectiveness.
Tools & Technologies:
SQL
DBeaver
Google Sheets

Key Skills Applied:
Cohort Analysis
Retention Rate Analysis
Data Cleaning
Data Transformation
Data Aggregation
User Behavior Analysis

User Conversion Analysis & A/B Testing
Tools: Python (Pandas, NumPy, SciPy), Jupyter Notebook, GitHub
Project Overview:
Analyzed the effectiveness of a promotional campaign offering a 50% discount on subscriptions by conducting
an A/B test on user conversion data.
Tasks Performed:
Processed and cleaned a dataset of nearly 20,000 user records, correcting data types and standardizing
timestamp formats.
Prepared experimental and control groups for analysis and calculated baseline conversion metrics.
Performed statistical hypothesis testing using a two-tailed t-test.
Calculated 95% confidence intervals to assess the reliability and significance of the results.
Interpreted experiment outcomes and evaluated the impact of the campaign on user conversion behavior.
Results:
Identified a statistically significant increase of 2.8 percentage points in conversion rate for the variant group.
Rejected the null hypothesis (p < 0.05), confirming that the observed improvement was attributable to the
campaign rather than random variation.

WORK EXPERIENCE
AmoreShop (january 2024 - april 2026)
Online Order Manager
Responsibilities:
Managed the full order processing cycle, including order preparation, verification, and customer
handover.
Monitored order statuses and maintained data accuracy within the company’s internal system.
Communicated with customers to provide support and resolve inquiries.
Handled exceptional cases and identified effective solutions to operational issues.
Skills Gained:
Analytical approach to problem-solving and process optimization.
Ability to independently research information and quickly understand new topics.
Strong attention to detail when working with operational data.
Effective communication and customer-focused mindset.
Time management and multitasking in a fast-paced environment.

EDUCATION
2026 2023-2024
IT School "GoIT" | IT School "GoIT" |
Certification: Data Analytics Certification: UI/UX Designer

LANGUAGES
English - Upper intermediate
Ukrainian - Native