Tetiana

TETIANA LOZOVA
Junior Data Analyst
tel: [open contact info](look above in the "contact info" section) e-mail: [open contact info](look above in the "contact info" section) location: Kharkiv, Ukraine
[open contact info](look above in the "contact info" section)
https:t.me/Tetiana132

SUMMARY
Junior Data Analyst with practical experience in data analysis, SQL querying, Python, and
dashboard creation. Experienced in cleaning and analyzing datasets, identifying trends,
calculating business metrics, and presenting insights through visualizations. Completed
projects involving A/B testing, e-commerce analytics, and survey data analysis. Bringing
strong problem-solving skills and 14 years of engineering background focused on process
improvement and analytical thinking.

SKILLS
HARD SKILLS
SQL
Python
A/B Testing
Product Analysis
Advertising Campaign Analysis
Probability Theory & Mathematical Statistics
Requirements Gathering
Data Visualization
Data Cleaning & Validation
Data Storytelling
Business Metrics: Conversion, ARPU, LTV, Retention, Churn, CTR
TOOLS
Excel
Google Sheets
DBeaver
Jupyter Notebook
BI Tools: Tableau, Power BI , Looker Studio
Python: Pandas, NumPy, Matplotlib, Seaborn
BigQuery
SOFT SKILLS
Thinking
Problem Solving
Team Collaboration
Adaptability
Communication Skills

PROJECT EXPERIENCE
E-commerce Data Analysis Project | [View on Google Drive]
Tools: Google Sheets, SQL, DBeaver
Completed a full-cycle data analysis project as part of a training program:
Performed data cleaning and exploratory data analysis (EDA)
Wrote SQL queries using JOINs and aggregate functions
Calculated key business KPIs (revenue, conversion rate, average order value, etc.)
Built an interactive dashboard in Google Sheets to visualize business metrics
Formulated analytical insights and business recommendations
Stack Overflow Developer Survey Analysis | [View on Google Drive]
Tools: Python, Pandas, Jupyter Notebook
Analyzed large real-world developer survey dataset using Pandas
Performed data cleaning, handling missing values, filtering, and grouping
Calculated descriptive statistics (mean, median, mode) and percentiles
Measured Python adoption rates and remote work distribution
Conducted compensation analysis by country for Python developers
Identified top-paid professionals and analyzed their education levels
A/B testing | [View on Google Drive]
Tools: Python, Pandas, Jupyter Notebook
Analyzed a product experiment testing the impact of a 50% discount message on
subscription conversion
Calculated experiment metrics, conducted a two-proportion z-test, and visualized
results with 95% confidence intervals to evaluate statistical significance
The analysis compared the conversion rates between the control and experimental groups
and evaluated whether the difference was statistically significant based on the calculated
p-value and confidence intervals.

E-commerce Funnel Analysis | BigQuery & Tableau | [link to Tableau Public]
Data Engineering: Processed raw GA4 logs in BigQuery using SQL (CTEs, Window
Functions) to model the full customer journey.
Funnel Visualization: Developed an interactive Tableau dashboard to track conversion
from session_start to purchase via dual axes.
Insight Generation: Identified a critical drop-off between session start and product view,
redirecting marketing focus to landing page optimization.
KPI Tracking: Analyzed Conversion Rates and user behavior to optimize marketing budget
and improve ROI. [link to Tableau Public]

WORK EXPERIENCE
JSC “Ukrainian Railways” | 2010-2024
Technological Engineer / Engineer
Analyzed technical processes and optimized workflows
Worked with documentation and technical reporting
Collaborated with cross-functional teams
Improved operational efficiency

EDUCATION
IT School GoIT | 2025-2026
Data Analytics Program
National Technical University “Kharkiv Polytechnic Institute”| 1999 – 2005
Master’s Degree in Mechanical Engineering

LANGUAGES
English -intermediate
Ukrainian- native