Олена

OLENA DUBOVSKA
DATA ANALYST
Location: Kyiv, Ukraine Email: [открыть контакты](см. выше в блоке «контактная информация»)
Phone: [открыть контакты](см. выше в блоке «контактная информация») Linkedin: [открыть контакты](см. выше в блоке «контактная информация»)
SUMMARY
Junior Data Analyst with experience transforming complex datasets into actionable business insights. Skilled in data
wrangling, trend analysis, and building data-driven narratives to support operational and strategic decisions. Strong
communicator capable of presenting findings to technical and non-technical audiences. Proven success in projects
analyzing customer behavior, market trends, and performance metrics. Enthusiastic about contributing to a data-driven
team
HARD SKILLS
Data Collection, Cleaning, and Preprocessing Excel and Data Manipulation
Statistical Analysis and Visualization A/B Tests
SQL, Python Problem-Solving and Critical Thinking
Tableau, Amplitude, Looker Studio Excellent Communication and Collaboration Skills
PROFESSIONAL EXPERIENCE
Manager, 02.2025 - Present
Ukrzaliznytsia, Wagon-Service Branch
Prepare detailed technical specifications for procurement items (spare parts, materials) based on production needs,
regulatory requirements, and engineering standards.
Analyze historical usage data to support cost-effective procurement planning.
Upload and maintain technical documentation in the IT-Enterprise ERP system, ensuring accuracy and data integrity.
Contribute to standardization of technical requirements, reducing preparation time by 20%.
Head of Supply and Sales Department, 06.2024 - 02.2025
Ukrzaliznytsia, Darnytsia Railcar Repair Plant
Managed procurement and distribution of industrial materials and components, ensuring timely supply and
uninterrupted production.
Analyzed supply chain data and historical demand to optimize inventory and reduce surplus stock by 15%.
Developed procurement plans and coordinated tender documentation in compliance with internal and legal
standards.
Oversaw contract execution with suppliers and monitored KPIs for delivery and cost efficiency.
Lead Specialist, 10.2019 - 06.2024
Ukrzaliznytsia, Passenger Company Branch
Collected and analyzed technical data on passenger railcar repairs to support planning and budgeting.
Improved internal planning software to accelerate the calculation of material and technical resource needs, reducing
processing time and enhancing accuracy.
Coordinated with technical teams to ensure compliance with maintenance standards.
Supported modernization by preparing technical justifications for new equipment proposals.

PROJECTS
User Funnel and Cohort Analysis Dashboard in Tableau
Tools: Tableau, Excel
Description: Developed an interactive dashboard to track user behavior across three key product milestones —
registration, trial start, and first payment. The goal was to identify drop-off points, calculate conversion rates, and support
product decisions with actionable insights.
My tasks: Processed and structured raw event-level data containing timestamps and user actions. Built a dual-axis
monthly chart combining registration volumes with delayed trial conversion metrics. Designed a full-funnel chart
visualizing absolute counts and conversion percentages between user stages.
Result: Delivered a clean, insightful dashboard published on Tableau Public. Helped stakeholders clearly understand
conversion bottlenecks and behavior trends. Provided a scalable template for future cohort or retention analysis.
 Marketing Campaign Performance Dashboard in Looker Studio

Tools: Google Looker Studio, PostgreSQL
Description: Designed an interactive marketing analytics dashboard using Google Looker Studio, based on data
retrieved from a PostgreSQL database via a custom SQL query. The goal was to analyze ad campaign
effectiveness and key performance metrics across different campaigns and time periods.
My tasks: Connected Looker Studio to PostgreSQL. Built three key visualizations:
Dual-axis combo chart with ad display date (by month) on the X-axis, plotting Ad Spend and ROMI on separate
Y-axes.
Line chart showing the number of active campaigns per month.
Heatmap table with campaign names as and key metrics (Ad Spend, CPC, CPM, CTR, ROMI).
Applied dynamic filters for campaign name and ad display date to allow flexible exploration by stakeholders.
Result: Delivered a clear, actionable marketing dashboard that highlights both budget efficiency and performance
ROI. Enabled data-driven decisions for campaign optimization based on real-time trends and key cost-efficiency
metrics. Developed a reusable template for future campaign-level performance tracking.

EDUCATION
IT School "GoIT" — Data Analysis
03.2025 – 08.2025
Ukrainian State University of Railway Transport — Master’s Degree in Computer Engineering
09.2016 – 12.2017

LANGUAGES
English - intermediate
Ukrainian - native