Юлія

Yuliia Sharmankina
Data Analyst
[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section) Ukraine, Kyiv LinkedIn

SUMMARY
Detail-oriented Data Analyst with expertise in SQL, Python, Excel, and interactive dashboards. Proven track
record in managing high-volume operational datasets, automating reporting workflows, and identifying
process bottlenecks. Skilled in cross-functional collaboration, digital tool implementation, and translating
operational data into actionable insights to drive efficiency and continuous improvement.

EXPERIENCE
Data Analyst 01/2026 – Present
WireChord
Designed SQL workflows (CTEs, Window Functions) to clean, aggregate, and
•

integrate multi-source operational data for daily and weekly performance
tracking.
Built interactive Tableau dashboards and automated spreadsheet trackers to
•

monitor operational KPIs and resource utilisation, identifying a 12% bottleneck in
workflow efficiency.
Conducted A/B tests using Python (SciPy) to evaluate platform changes,
•

confirming statistical significance before implementation.
Implemented RFM analysis for customer segmentation, enhancing targeted
•

marketing strategies.
Automated Google Sheets reporting with Pivot Tables and complex formulas,
•

saving several hours weekly.
Used Python (Pandas, Seaborn) for exploratory data analysis, revealing growth
•

opportunities in specific regions.
Streamlined routine reporting pipelines using automated Excel models and
•

formulas, saving several hours weekly and supporting digital process
optimisation.
Operations & Data Coordinator 04/2025 – 02/2026
MyDentist
Managed high-volume scheduling and operational records using specialised
•

software, maintaining 100% data accuracy, system integrity, and GDPR
compliance.
Collaborated with operational teams and site supervisors to resolve workflow
•

bottlenecks, optimise dynamic resource allocation, and improve daily service
delivery.
Maintained accurate medical and operational records, supporting internal
•

reporting through meticulous data entry and organisation.
Digital Marketing Specialist 05/2023 – 02/2025
HowLite Dental Lab
Developed marketing strategies that achieved a 20% increase in sales and brand
•

recognition through targeted multi-channel campaigns.
Conducted competitor benchmarking and consumer behavior analysis to identify
•

trends, delivering detailed reports to optimise campaign ROI.
Managed end-to-end email and social media marketing, utilising engagement
•

metrics to refine content plans and boost lead generation.
Oversaw visual identity and corporate events, ensuring brand consistency while
•

managing project timelines and stakeholder communication.

EDUCATION
Bachelor Degree in Practical Psychology 2017 – 2021
Borys Grinchenko Kyiv University

SKILLS
Spreadsheets SQL
Pivot Tables, Data Cleaning, Visualization Advanced Queries, Window Functions, Query
Optimization, Common Table Expressions (CTE)
Python
Pandas, NumPy, Matplotlib, Seaborn, Exploratory Tableau
Data Analysis (EDA) Interactive Dashboards, Data Storytelling,
Publishing
Statistics
Sampling, Hypothesis Testing, Correlation, A/B Testing
Statistical Significance Planning, Analysis, Reporting

Other Tools Languages
Jupyter Notebooks, Google Analytics, Excel, Git English (Advanced), Ukrainian (Fluent), Russian
(Fluent)

ADDITIONAL EDUCATION /
Data Analyst Course
Mate Academy
Digital Marketing Course
Hubspot Academy
Comprehensive Internet Marketing Course
Udemy

PORTFOLIO
E-commerce Sales User Behavior Analysis
SQL Project
Built a clean user dataset tracking sign-ups, email engagement, and paid subscriptions to analyse growth
trends and segment users by region and activity.
Executive Sales & Traffic Analytics
Analysed raw e-commerce data using SQL, Python, and Tableau to track sales trends, group customers by
purchasing behavior, and deliver actionable business insights.
A/B Test Analysis
Python & Tableau Project
Analysed A/B test results to measure the feature's impact on user conversion, driving data-backed decisions
for product improvements.