Олеся

Olesia Lelet Data Analyst
[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section) Lviv, Ukraine, remote

[open contact info](look above in the "contact info" section) github.com/OlesiaLelet t.me/lllllll_o

Summary
Data Analyst with hands-on experience in SQL (BigQuery), Tableau, Excel/Google Sheets, and Python. I work
with data end-to-end - from extracting and transforming it with SQL (JOINs, CTEs) to preparing reliable
datasets and building clear, business-focused dashboards in Tableau. I also use Python (Pandas, NumPy,
Matplotlib, Seaborn) for data processing, analysis, and visualization. I focus on understanding the “why”
behind the numbers, not just reporting them. I’m comfortable working with imperfect data and turning it
into structured, usable datasets, as well as translating it into clear, actionable insights for stakeholders. With
a background in pharmacy, I bring a strong sense of context and user behavior, which helps me interpret data
more thoughtfully and accurately.

Experience
02/2026 – Present Data Analyst
Analyzed e-commerce datasets using SQL and Python to identify customer
•

purchasing patterns and business opportunities.
Developed SQL queries to extract and aggregate data from relational databases.
•

Performed exploratory data analysis and data cleaning using Pandas.
•

Built Power BI dashboards to visualize KPIs, sales performance, customer
•

retention, and revenue trends.
Conducted cohort analysis to evaluate customer retention over time.
•

Designed and analyzed A/B testing scenarios using statistical hypothesis testing.
•

Created clear visualizations and presented insights to support business decision-
•

making.
Projects:
Analytics of sales of an online shop using SQL, Python, and Tableau.
•

A/B testing using statistical methods in Python and visualisation that
•

demonstrates key conversion metrics.
SQL projects – developed analytical SQL queries for data extraction, aggregation,
•

and business insights.
Tableau Projects – built interactive dashboards to visualize KPIs, trends and A/B
•

testing.
Python Projects – exploratory data analysis of sales of an international company.
•

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
Project Management tool — Trello
Other Tools — Jupyter Notebooks, Google Analytics, Excel, Git, knowledge of SDLC, Waterfall, Agile
concepts (Scrum, Kanban)
Languages — English (Upper-Intermediate)
 Previous experience
2022 – 2026 Pharmacist
Lviv, Ukraine Company Znahar
Dispense prescription medications accurately and efficiently
•

Provide patient counseling on medication usage, dosage, and side effects
•

Review prescriptions for accuracy and potential drug interactions
•

Maintain patient records and ensure confidentiality.
•

Collaborate with healthcare professionals to optimize patient care
•

Manage inventory and ensure proper storage of medications
•

Ensure compliance with pharmacy laws and regulations
•

Education
2018 – 2023 Master’s Degree in Pharmacy
Lviv State Medical University named after Danylo Halytsky

Additional education
2026 Data Analyst course
Mate Academy

2026 Data Manipulation in SQL
DataCamp

2026 Joining data in SQL
DataCamp

2026 Intermediate SQL
DataCamp

2026 Data Visualisation: Empowering Business with Effective Insights
Tata Group (Forage) — Certificate of Completion

2024 Frontend Development (mentorship program)
Developed responsive web interfaces using HTML, CSS, and JavaScript
•

Implemented modern layout techniques (Flexbox, Grid) and basic interactivity
•

Worked with mentor feedback to improve code quality and best practices
•

Achievements
2026 SQL Problem Solving
Solved 100+ SQL problems on DataCamp and LeetCode

Fitness Achievement
Trained consistently in the gym (3x/week for 2 years)