Tetiana

TETIANA LOZOVA
Junior Web 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 Web Analyst with practical experience in digital analytics, tracking user journeys, and
optimizing conversion funnels. Proficient in processing raw GA4 logs using BigQuery (SQL)
and building interactive dashboards in Tableau and Google Sheets. Skilled in data cleaning,
exploratory analysis, and A/B testing to identify traffic drop-offs and drive marketing ROI.
Backed by a strong engineering background focused on analytical thinking and process
optimization.

SKILLS
HARD SKILLS
Data Analysis: Product & UX Analysis, Advertising Campaign Analysis, A/B Testing,
Requirements Gathering
Math & Stats: Probability Theory & Mathematical Statistics, Data Cleaning & Validation
Web & Product Metrics: Sessions, Users, Conversion Rate (CR), Bounce Rate, Time on
Page
Business & Marketing Metrics: CTR, LTV, Retention, Churn, ARPU
Data Presentation: Data Visualization, Data Storytelling

TOOLS
Excel
Google Sheets
DBeaver
Jupyter Notebook
BI Tools: Tableau, Power BI, Looker Studio
Python: Pandas, NumPy, Matplotlib, Seaborn
Web Analytics: GA4 (Google Analytics 4) logs, BigQuery

SOFT SKILLS
Analytical Thinking
Problem Solving
Team Collaboration
Adaptability
Communication Skills

PROJECT EXPERIENCE
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]

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

Website Redesign A/B Testing & Web Behavior Analysis| | [View on GitHub]
Tools: Python, Pandas, Jupyter Notebook
Experiment Analysis: Conducted A/B test analysis in Python using Z-tests ($p < 0.0001$)
to evaluate website redesign impact on Conversion Rate, Session Duration, and Pages
Visited per session.
User Behavior Insights: Discovered a statistically significant conversion uplift (+34.65%)
and identified traffic anomalies in the 25–34 age segment.
BI Visualization: Built an interactive multi-page Power BI dashboard with demographic
slicers to present user behavior metrics and web optimization 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

WORK EXPERIENCE
JSC “Ukrainian Railways” | 2010-2024
Technological Engineer / Engineer
Analyzed technical processes, data, 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