Personal information hidden

Andrii Konovalov
DATA ANALYST

[open contact info](look above in the "contact info" section)
[open contact info](look above in the "contact info" section)
Telegram
LinkedIn
Barcelona, Spain: Remote / On-site

​
SUMMARY
Data Analyst with a technical background since 2021, experienced in end-to-end data analysis
— from data extraction and cleaning to visualization and insights generation. Proficient in SQL,
Python (Pandas), Excel, and Power BI/Tableau. Skilled in A/B testing and business metrics
analysis. Combines strong analytical thinking with client-facing experience to deliver
actionable, data-driven solutions. English — Upper-Intermediate.

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: English (Upper-Intermediate), Spanish (Intermediate), Ukrainian (Native)

EXPERIENCE
Data Analyst (Training / Projects Experience), Sep 2025 - Present
●​ Worked with SQL to extract and analyse data from databases using BigQuery (JOINs,
CTEs, window fn-s.)
●​ Cleaned and prepared datasets for analysis using Excel and Python.
●​ Created dashboards in Tableau to visualize business data.
●​ Performed data analysis in Python (Pandas) and built visualizations to identify trends.
●​ Constructed A|B test analysis and evaluated results for statistical significance.
●​ Identified patterns in data and derived basic business insights.
●​ Completed practical projects based on real-world business scenarios.
PORTFOLIO
Project 1 (SQL Project) – Data collection to analyze account creation trends, email activity
(sends, opens, clicks), and user behavior across sending intervals, verification, and
subscription status.
●​ Link to review
​
Project 2 (Tableau Projects) – A set of Tableau projects including interactive dashboards for
analyzing KPIs, user behavior, and trends. Worked with data cleaning, data modeling, and
visualization to deliver clear insights.
●​ Link to review

Project 3 (Python Project) – Analyzed A|B test results using Python, applying z-test to assess
statistical significance of key metrics. Transformed raw data into actionable insights, enabling
informed product decisions.
●​ Link to review

PREVIOUS EXPERIENCE

Front-End Developer (Freelance), Apr 2023 - Present
●​ Developed responsive web applications
●​ Fixed bugs and improved existing functionality
●​ Collaborated with clients
Mentor JavaScript (GoIT EdTech), Nov 2022 - Feb 2024
●​ Mentored students in JavaScript
●​ Reviewed code and provided constructive feedback
●​ Reviewed homework and helped students debug issues
Sales manager - Online stores promotion manager (LLC Planeta Instrument), 2010 - 2018
●​ Managed and promoted online stores in the tools/equipment niche
●​ Led customer communication and sales processes
●​ Grew two online stores to Top-3 positions in Ukraine by sales in their category

EDUCATION
Kherson State University 2002 - 2007​
Master-equivalent Degree in Technical and Pedagogical Education ​
(Engineering, Drawing & Automotive Studies)

ADDITIONAL EDUCATION
●​ Data Analyst course at Mate academy
●​ Practicing SQL and analytical problem-solving on LeetCode
●​ Front-End Development programming course at GoIT
CERTIFICATES