Михайло

MYKHAILO
KHARCHENKO
Data Analyst
Summary

My role as a Data Analyst involves uncovering and analysing data for
research. Proficient in statistical analysis and building predictive models to
identify trends and patterns. I have experience using SQL, Tableau and Excel to
create visualizations and reports that support business decision-making. I am
eager to bring a fresh perspective and strong problem-solving abilities to a
Data Analyst role.

Project Experience

SaaS Revenue and User Retention Dashboard: Cohort Analysis and MRR Dynamics
Tools: Tableau
Description: The "SaaS Revenue and User Retention Dashboard: Cohort Analysis and
Contacts
MRR Dynamics" analyzes the financial performance of a SaaS product from June 2022
[відкрити контакти](див. вище в блоці «контактна інформація») to May 2023 with revenue of 1.33M, 8,463 users, and ARPPU of 157.49. The waterfall chart
[відкрити контакти](див. вище в блоці «контактна інформація») shows a revenue peak of 162,260 in December 2022 with subsequent decline to
136,945, where orange blocks indicate periods of negative growth. The New MRR chart
Linkendin
demonstrates a sharp decrease from 44,085 in June 2022 to stabilization at 17-27K.
Telegram The cohort retention table with gradient color coding displays retention rates from 0
Zvenygorodka, Ukraine to 9 months. The best-performing June 2022 cohort shows a decline from 44,085 to
15,975 users over 9 months.
Hard Skills Task: Create a comprehensive dashboard to analyze revenue dynamics, new MRR,
and cohort-based user retention by identifying periods of negative growth and
Statistical Analysis
critical customer churn points to optimize retention strategy.
Data Cleaning and Wrangling
Result: A dashboard was created revealing a revenue peak of 162,260 (December
Predictive Modeling 2022), New MRR decline from 44,085 to 17-27K, and a 64% cohort retention rate drop
DBeaver over 9 months.

SQL Expansion Campaign Dashboard

Tableau Tools: Looker Studio, Tableau
Looker Studio Description: The dashboard demonstrates the effectiveness of the
Excel "Expansion" advertising campaign (April-Summer 2022). The visualization
combines budget dynamics (green bars, peak of 6 million in April) with the
ROMI profitability indicator (blue line, max 100), showing an inverse
Soft skills
relationship - as spending decreases, ROMI becomes unstable. A separate
Team Work chart tracks the reduction of active campaigns from 8 (September 2020) to
1-2, while a detailed table reveals daily statistics of key performance metrics
High Analytics Skills
for optimizing the advertising strategy.
Attention to detail
Task: Analyze the effectiveness of the "Expansion" advertising campaign by
Creativity tracking spending dynamics, ROMI, and the trend of reducing active
Good communication campaigns. Prepare conclusions on advertising budget optimization and
provide recommendations for improving CTR and reducing conversion costs
Languages (CPC/CPM)

English - intermediate Result: A dashboard was created that revealed the inverse relationship
Ukrainian- native between spending and ROMI, campaign consolidation from 8 to 1-2, and
provided detailed statistics for advertising strategy optimization.

Work Experience
Education
State Enterprise "Zvenyhorodka Forestry"
2024-2025
Role: Chief Economist 2000 – 2024
IT School GoIT
Analysis of the company's financial and economic
Fullstack Developer / Data Analyst
performance indicators.
1997-2003 Development of budgets and financial plans, monitoring their
Uman State Agrarian Academy implementation.
Master’s degree in Accounting and Preparation of reports for management and government
auditing authorities.
Achievements: Optimized expenses by 15% through the
implementation of new financial analysis models; automated
the financial reporting processes.