Особисті дані приховані

NIKITA SHAMAIEV Summary
Data Analyst Skilled in SQL, Python, BigQuery, Google Sheets, Power BI, and
Tableau. Experienced in cleaning, analyzing, and visualizing
[відкрити контакти](див. вище в блоці «контактна інформація») humanitarian and business data, with projects covering ecommerce
[відкрити контакти](див. вище в блоці «контактна інформація») funnels, marketing performance, and humanitarian funding.

Remote Work Experience
[відкрити контакти](див. вище в блоці «контактна інформація») Deputy Team Lead, THE MINES ADVISORY GROUP
github.com/shamaievn/data-analytics- 08/2025 – 05/2026 | Mykolaiv, Ukraine
portfolio Data & Quality Control - Monitored operational information for
•

accuracy and compliance with established procedures and
standards.
Technical Skills Reporting - Collected, structured, and transformed field information
•

SQL: PostgreSQL, BigQuery into operational reports supporting planning and decision-making.
Coordination - Organized workflows, task allocation, and team
Python: Pandas, data cleaning, EDA
•

communication to support daily operations.
BI & Visualization: Power BI, Tableau
Humanitarian Sapper, THE MINES ADVISORY GROUP
Spreadsheets: Excel, Google Sheets 09/2023 – 08/2025 | Mykolayiv, Ukraine
Analytics: Data Cleaning, Data Validation,
Exploratory Data Analysis, Statistics
Projects

Data: ETL, data transformation, KPI analysis Explosive Violence Affecting Civilian Services in Ukraine ,
Python (requests, pandas), ETL, Tableau, GitHub Actions
Education Built an automated ETL pipeline that refreshes data every week via
•

GitHub Actions keeping the analysis up to date
Data Analytics Course, GoIT Cleaned, transformed, and validated source data to prepare it for
•

02/2026 – 08/2026 analysis and visualization.
Analyzed incident patterns to identify trends in the impact of
Bachelor's Degree in Journalism,
•

explosive violence on civilian services.
Kyiv National University of Culture and Arts
01/2020 – 12/2024 | Kyiv, Ukraine Ukraine Humanitarian Funding Analysis , SQL, Power BI
Analyzed humanitarian funding and reported requirements across
Data Analyst Associate, DataCamp
•

sectors in Ukraine from 2022 to 2026.
SQL, Data Analysis, Python, Data Visualization Developed a Power BI dashboard to compare funding against
•

reported humanitarian needs.
Languages Created interactive visualizations and KPIs to help identify funding
•

Ukrainian gaps and differences across sectors.
Native Ecommerce Funnel Analysis , BigQuery, SQL, Tableau
Analyzed GA4 ecommerce event data to identify drop-off points
English
•

across the purchase funnel.
Upper-Intermediate
Built SQL transformations in BigQuery to aggregate user behavior at
•

session level.
Created an interactive Tableau dashboard with filters for traffic
•

source, campaign, device and landing page.
Identified key conversion patterns and performance differences
•

across acquisition channels.
Marketing Performance Analysis , Google Sheets
Cleaned and standardized marketing campaign data using Google
•

Sheets.
Built pivot tables and visualizations to compare campaign efficiency
•

and identify performance trends.
Evaluated campaign efficiency using metrics such as ROAS and
•

other marketing performance indicators.