Михайло

MYKHAILO SUMMARY
KHARCHENKO Analyst with 20+ years of experience in finance: financial analysis, budgeting,
and economic planning.
Data Analyst
Skilled in SQL, Excel, Tableau, and Looker Studio for data analysis, dashboard
CONTACTS development, and business reporting.
Currently transitioning into a Data Analyst role and leveraging extensive
[відкрити контакти](див. вище в блоці «контактна інформація») financial analytics experience to support business and product data analysis.
[відкрити контакти](див. вище в блоці «контактна інформація»)
LinkedIn PROJECT EXPERIENCE
Telegram
Zvenygorodka, Ukraine SaaS Revenue and User Retention Dashboard: Cohort Analysis
and MRR Dynamics
HARD SKILLS Tools: Tableau
SQL (BigQuery, DBeaver) Description: Analyzed the financial performance of a SaaS product (June 2022
Tableau
– May 2023) with revenue of 1.33M, 8,463 users, and ARPPU of 157.49. Built
waterfall charts, MRR trend analysis, and cohort retention tables with gradient
Looker Studio color coding.
Excel (Advanced: Pivot Tables,
Task: Create a comprehensive dashboard to analyze revenue dynamics, new
VLOOKUP)
MRR, and cohort-based user retention by identifying periods of negative growth
Statistical Analysis and critical customer churn points.
Data Cleaning and Wrangling
Result: Revealed a revenue peak of 162,260 (December 2022), New MRR
Python (pandas, data analysis) decline from 44,085 to 17-27K, and a 64% cohort retention rate drop over 9
Google Analytics 4 months.
Predictive Modeling
Data Visualization Expansion Campaign Dashboard
Tools: Looker Studio, Tableau
Description: Analyzed the effectiveness of the "Expansion" advertising
SOFT SKILLS campaign (April-Summer 2022). Combined budget dynamics with ROMI
profitability indicators, showing an inverse relationship between spending and
Team Work returns.
Analytical Thinking Task: Analyze the effectiveness of the advertising campaign by tracking
Attention to Detail spending dynamics, ROMI, and the trend of reducing active campaigns.
Creativity Result: Created a dashboard that revealed the inverse relationship between
Good Communication spending and ROMI, campaign consolidation from 8 to 1-2, and provided
detailed statistics for advertising strategy optimization.
LANGUAGES
WORK EXPERIENCE
Ukrainian - native
English - intermediate State Enterprise "Zvenyhorodka Forestry"
Role: Chief Economist 2000 – 2024
EDUCATION
• Analyzed financial performance datasets using Excel and statistical
2024-2025 methods
IT School GoIT • Built financial reporting models to monitor company KPIs
Fullstack Developer / Data Analyst • Optimized operational expenses by 15% through financial data analysis
1997-2003 • Automated reporting processes improving decision-making efficiency
Uman State Agrarian Academy
Master's degree in Accounting and Auditing