Лариса

Larysa Shulzhenko
Junior Data Analyst

CONTACTS__________
Phone: [відкрити контакти](див. вище в блоці «контактна інформація») Email: [відкрити контакти](див. вище в блоці «контактна інформація») Telegram: @Lara7803
LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація») Location: Kharkiv, Ukraine

SUMMARY__________
Junior Data Analyst with a background in internal audit and law. During my studies, I completed projects
involving business metrics analysis and exploratory data analysis (EDA) using SQL, Python (Pandas), Excel,
and Google Sheets. Experienced in working with large volumes of information, data validation, and preparing
reports for management. Seeking a Junior Data Analyst position to apply my analytical skills to real-world
business problems.

HARD SKILLS__________
- SQL (joins, aggregations, subqueries) - Exploratory Data Analysis (EDA) - Data Storytelling
-Data cleaning and preparation - Descriptive statistics - Data aggregation
-Data Visualization - A/B testing
-Microsoft Excel (Pivot Tables, VLOOKUP, Power Query)
-Business metrics analysis (conversion rate, ARPU, retention, MRR, LTV, churn)

TOOLS__________
PostgreSQL, MySQL, BigQuery, Pandas, NumPy, Seaborn, Matplotlib, Tableau, Looker Studio, Google Sheets,
MS Excel, DBeaver, Google Colab, Jupyter Notebook, GitHub

PROJECT EXPERIENCE__________
Fintech Company Business Metrics Analysis
Tools: Google Sheets, SQL
- Conducted exploratory data analysis (EDA) and identified key business metrics.
- Cleaned and prepared data for analysis.
- Wrote SQL queries to calculate business metrics.
- Analyzed refunds, fraudulent transactions, and geographical distribution.
- Built a KPI dashboard, identified potentially promising markets (the UK, India, and Germany), and
developed recommendations for reducing refunds and monitoring fraud.

Developer Survey Analysis (Stack Overflow Survey)
Tools: Python (Pandas), Google Colab
- Loaded and explored a large developer survey dataset using Pandas.
- Cleaned the data and handled missing values.
- Calculated measures of central tendency to analyze the data.
- Performed data grouping, filtering, and aggregation.
- Identified trends in developers’ salaries, technologies, and experience, and prepared analytical tables.

WORK EXPERIENCE__________
Deputy Head of Internal Audit Department
APK Corporation LLC | 2000–2021
- Analyzed expenses and the efficiency of financial and resource utilization.
- Prepared analytical calculations and recommendations for management on cost optimization.
- Independently created an Excel register of over 1,200 land lease agreements, including landlord
information, contract terms, and rent payment calculations.

EDUCATION__________
2026 — Data Analytics Course, GoIT IT School
2002 — Law Degree (Qualified Lawyer), Kharkiv H. S. Skovoroda State Pedagogical University

LANGUAGES__________
English — pre-intermediate Ukrainian — native