Сергій

SERHII ZANOZA
D A T A A N A L Y S T

I have skills in data analysis, more than 15 years of experience in financial
[open contact info](look above in the "contact info" section)
analysis and modeling, including the development of business plans and
[open contact info](look above in the "contact info" section)
comparing the effectiveness of various strategies. I am able to use various tools
Linkedin and methods to make data-driven decisions. I have skills in using PostgreSQL and
Pathon for data manipulation and query creation, as well as in using BigQuery for
Telegram
large-scale data processing and analysis. I have experience in creating interactive
Kyiv, Ukraine dashboards using Tableau or Looker Studio, and I have experience in data
manipulation and visualization using Google Sheets and Microsoft Excel.

HARD SKILLS PROJECT EXPERIENCE
PostgreSQL Creating an interactive dashboard in Tableau for revenue analysis
Python (Pandas) Practical work with PostgreSQL and data visualization using Tableau:
Advertasing companies Prepared the data in PostgreSQL: combined the data into a consolidated table, calculated the
analysis first month of payment, the last month of payment, the previous month of payment, and the
Product Analysis payment amount.
Analysis of investment The dashboard includes key metrics such as MRR, Paid Users, ARPPU, New Paid Users,
attractiveness New MRR, Churned Users, Churn Rate, Churned Revenue, Revenue Churn Rate, MRR
Business plan Expansion, MRR Contraction, Customer Lifetime (LT), Customer Lifetime Value (LTV).
development Creation of a funnel chart that displays user steps
Financial modeling Practical work with data visualization using Tableau:
TOOLS Creation of a funnel chart that displays user steps;
Google Sheets Creation a chart with the number of registrations and conversion rate from registration to
Bigquery trial in each month of registration;
Looker Studio Creation of an interactive dashboard using Actions and Parameters: creating a graph with
Tableau the average number of days from registration to a user's step in each month of registration;
1C: ERP 8.3 when a user selects any of the steps in the funnel chart, this graph (with the number of
MS Excel days) is rebuilt and displays the number of days from registration to the selected step.

SOFT SKILLS WORK EXPERIENCE
Analytical skills Wind Solar Energy-1 LLC, Kyiv (Solar and wind energy)
Vision of the future Head of Financial Analysis and Planning Department
Self-development, 2017- 2025
Adaptability to conditions Analyzing the external and internal market of electricity, creating dashboards in Tableau
and Looker Studio, close cooperation in the implementation of new projects;
Analysis of investment attractiveness of new projects on construction of solar and wind
LANGUAGES
power plants;
English - Upper- Analysis of financial performance indicators, CF, PL, BS, currency control, loan portfolio
Intermediate analysis, receivables control;
Ukrainian - Native Pricing analysis with suppliers, general contractors and buyers;
Development of business plans and preparation of presentations for investors;
Main achievements:
EDUCATION Assistance in the development of an 8 MW solar power plant project from concept to
IT School GOIT commissioning, with the main responsibilities being investment attractiveness analysis,
DATA Analyst financial modeling, and loan raising, that contributed to the successful achievement of the
2024 result
Assistance in the development of a 25 MW wind power plant project from idea to sale of
Kyiv National the project at the stage of ready to build. Main responsibilities: analysis of investment
Economic University attractiveness, financial modeling, preparing presentations and dashboards for investors,
Management of financial audit of the project for sale. My hard work contributed to the successful
organizations achievement of the result.
Master degree,
1999 - 2004