Костянтин

Konstantin Gustera
Junior Data Analyst
Ovruch, Zhytomyr, Ukraine | [open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section)
LinkedIn: [open contact info](look above in the "contact info" section)
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