Костянтин

Konstantin Gustera
Junior Data Analyst
Ovruch, Zhytomyr, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)
LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація»)
SUMMARY
Junior Data Analyst transitioning from operations management and engineering into data analytics. Experienced in business processes,
logistics, resource optimization, and operational data. Hands-on practice in SQL, Python, Google Sheets, Tableau, Power Query, data
cleaning, visualization, cohort and retention analysis, and sales performance analysis. Seeking a Junior Data Analyst position to apply
analytical skills and contribute to data-driven decision-making.

HARD SKILLS
SQL • Python • Data Analysis • Data Cleaning & Validation • Statistics • A/B Testing • Data Storytelling • Cohort Analysis • Customer
Retention Analysis • Sales Performance Analysis • Data Visualization

TOOLS
MySQL • Pandas • NumPy • Excel • Google Sheets • Power Query • Tableau • Looker Studio • Power BI • BigQuery • Matplotlib • Seaborn
• Jupyter Notebook

PROJECT EXPERIENCE
Customer Retention & Cohort Analysis
Tools: SQL, Google Sheets
Description: Analyzed customer retention using cohort analysis and retention-rate metrics. Extracted, transformed, and analyzed
customer data to identify retention patterns.
Tasks: Prepared customer data, grouped users into cohorts, calculated retention metrics, and analyzed retention patterns across cohorts.
Result: Identified retention patterns and structured customer cohorts for clearer performance analysis.
Sales Performance Dashboard
Tools: SQL, Tableau
Description: Analyzed sales data using SQL and created an interactive Tableau dashboard for business performance monitoring. Visualized
key metrics and sales trends.
Tasks: Prepared and analyzed sales data, calculated key performance metrics, built visualizations, and assembled an interactive
dashboard.
Result: Presented key sales trends and business insights through an interactive dashboard.

WORK EXPERIENCE
Head of the Department of Architecture and Urban Planning — Ovruch City Council | 2026–Present
• Manage departmental operations and coordinate team activities.
• Work with administrative processes, planning, and operational information.
Machine Fleet Operations Engineer — AGRO-STANDART LLC | 2019–2025
• Managed agricultural machinery operations and optimized maintenance costs.
• Coordinated procurement and logistics of spare parts and worked with suppliers.

EDUCATION
GoIT — Data Analyst | Professional training
Donetsk National Technical University — Mining Engineering | 2011–2017

LANGUAGES
Ukrainian — Native | English — Pre-Intermediate