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

NIKITA SHAMAIEV Summary
Junior 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 08/2025 – 05/2026 | Mykolaiv, Ukraine
Data & Quality Control - Monitored operational information for
•

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

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

BI & Visualization: Power BI, Tableau communication to support daily operations.
Spreadsheets: Excel, Google Sheets Humanitarian Sapper, THE MINES ADVISORY GROUP
Analytics: Data Cleaning, Data Validation, 09/2023 – 08/2025 | Mykolayiv, Ukraine
Exploratory Data Analysis, Statistics
Projects
Data: ETL, data transformation, KPI analysis
Explosive Violence Affecting Civilian Services in Ukraine ,
Education Python (requests, pandas), ETL, Tableau, GitHub Actions
Built an automated ETL pipeline that refreshes data every week via
•

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

analysis and visualization.
Bachelor's Degree in Journalism,
Analyzed incident patterns to identify trends in the impact of
Kyiv National University of Culture and Arts
•

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

sectors in Ukraine from 2022 to 2026.
Developed a Power BI dashboard to compare funding against
Languages
•

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

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

across the purchase funnel.
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.