Олена

.

Aspiring Data Analyst with strong analytical thinking, 15 years of experience in the
pharmaceutical field, and ongoing training in data analytics at GoIT. Skilled in SQL,
BigQuery, Google Sheets, Tableau, Looker Studio, Amplitude. Solid understanding
of data visualization, business metrics, and data-driven decision-making. Seeking to
transition into data analytics to leverage analytical skills and support business
insights.

Project experience
Olena
OT

Tymchyshyn Sales & Logistics Dashboard
Tools: Tableau, Excel, PostgreSQL
Cluj-Napoca, 400357 Romania Description: Built dashboards to analyze sales, profit trends, and shipping logistics.
Visualized time series, profitability by sub-category and shipping mode, and mapped
[open contact info](look above in the "contact info" section) LinkedIn Telegram shipping times.
Key tasks: Developed time series and KPI metrics, segmented data, implemented interactive
[open contact info](look above in the "contact info" section)
filters, and created geographic visualizations.
Result: Improved visibility into sales dynamics, profitability, and delivery efficiency for
decision-making .
Marketing Campaign Performance Dashboard
Hard skills Tools: SQL, Looker Studio, Excel
Description: Designed dashboard to track ad spend, CPC, CPM, CTR, and ROMI across
campaigns and periods.
• SQL Key tasks: Processed campaign data, built time series for spend and ROMI, created KPI
• Python for Data Analysis tables, and added campaign/date filters.
• Data Cleaning & Preparation Result: Enabled marketing team to optimize budgets and improve ROI with data-driven
• Statistics & Probability insights.
• ETL processes
• Data Visualization Work history
• A/B Testing

Self – Employed (registered) July 2024 - Current
Tools • Maternity leave (no active operations during this time)
• Self-education (online courses / reading professional literature / working on projects)

• DBeaver Trade Marketing Specialist
• BigQuery Lex Marketing LLC June 2020 - October 2023
• Tableau • Collected and analyzed retail data to support promotional strategies.
• Amplitude
• Worked with neural network tools to automate product recognition and tested AI
• Google Sheets models to improve accuracy and efficiency.
• Google Analytics
Pharmacist

Soft skills Pharmaceutical Industry (Various Companies) 2005 - 2020
• Over 15 years of professional experience in pharmaceutical retail and healthcare.

• Analytical thinking & problem- • Delivered patient counseling and pharmaceutical care in compliance with medical
solving standards.
• Attention to detail and accuracy
• Communication & teamwork across Education
departments
05.2025-11.2025 09.2006-06.2012
• Adaptability and fast learning of new
IT school GoIT Danylo Halytsky Lviv National Medical University
tools
Data Analysis Master's Degree in Pharmacy
• Time management & ability to
prioritize tasks
Languages
English – Intermediate
Ukrainian - Native

.