Герман

German Rusanov SUMMARY
DATA ANALYST SUMMARY
Data Analyst with skills in SQL, Python (Pandas, NumPy),
da.german.rusanov​@gmail.com Tableau, and Google Sheets. Experienced in data cleaning,
[open contact info](look above in the "contact info" section) analysis, and visualization to support business decisions.
Background in sales, marketing, and CPA advertising with
Okhtyrka, Ukraine / remote hands-on experience analyzing campaign performance,
Telegram customer behavior, and revenue metrics.
Skilled in working with e-commerce and sales data,
Github building dashboards, and delivering clear insights. Able to
LinkedIn work independently in challenging conditions.

EDUCATION EXPERIENCE

Bachelor's Degree in Cybersecurity CRM Analyst
(incomplete) Hay Credito
Kharkiv National University of Radio 02/2026 – 04/2026 | Remote
Electronics • Analyzed contact center performance across funnel stages
2014 – 2018 | Kharkiv, Ukraine (registration, processing, approval) to identify trends and
conversion drivers
• Built SQL-based analytics and reports to track key metrics,
SKILLS including conversion rates, call effectiveness, and loan
issuance
Spreadsheets • Applied last-touch attribution to evaluate operator
Pivot Tables, Data Cleaning, performance and optimize communication strategies
Visualization.
Data Analyst
SQL Self-Employed
Advanced Queries, Window Functions, 11/2025 – 01/2026
Query Optimization, Common Table Analyzed sales and e-commerce data to identify trends
•

Expressions (CTE) and customer behavior
Built dashboards using Google Sheets, SQL (BigQuery),
•

Python Python, and Tableau
Pandas, NumPy, Matplotlib, Seaborn, Cleaned and transformed multi-source datasets for
•

Exploratory Data Analysis (EDA) reporting and insights

Tableau Media Buyer
Interactive Dashboards, Data Everad
Storytelling, Publishing 01/2021 – 02/2022
Managed Facebook Ads and Google Ads campaigns
•

Statistics Analyzed CPA, ROI, and conversion performance
•

Sampling, Hypothesis Testing, Created ad creatives and landing content
•

Correlation, Statistical Significance.
Call-Center Team Leader
A/B Testing Everad
Planning, Analysis, Reporting 06/2020 – 01/2021
Supervised a sales team and monitored KPIs
Other Tools
•

Analyzed results and conducted performance reviews
Jupyter Notebooks, Google Analytics,
•

Excel, Git

Languages
English (Upper-Intermediate)
Sales Manager
Everad
11/2017 – 06/2020
Managed inbound/​outbound customer communications
•

and identified client needs
Presented products and handled the full sales cycle
•

Worked with sales metrics and performance tracking
•

Portfolio
Project 1 (Spreadsheets)⁠
Sales dynamics analysis by category, product, and country
Tools: Google Sheets, Pivot Tables
Visualized sales trends and built a dynamic dashboard
•

Applied ABC analysis to identify high-impact products
•

Project 2 (SQL)⁠
E-commerce Analysis & Visualization
Tools: BigQuery, SQL, Looker
Analyzed user behavior and segmented customers by
•

traffic source
Queried and cleaned multi-table datasets to extract
•

insights on conversions

Project 3 (Python)⁠
E-commerce Data Analysis Dashboard
Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, Tableau
Created a structured analysis report with visualizations
•

and business insights
Analyzed revenue and key metrics across categories,
•

devices, and countries

Project 4 (SQL, Python, Tableau)⁠
E-commerce Sales Performance & Statistical Analysis
Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, SciPy,
Google Colab, Tableau
Analyzed 91 days of session-level e-commerce data
•

Identified key revenue drivers, regional trends, and top
•

product categories
Applied statistical testing and evaluated marketing
•

channel performance

Project 5 (A/B Testing, Python, SQL, Tableau)⁠
A/B Test Statistical Significance Analysis
Tools: BigQuery, SQL, Python, Pandas, SciPy, Google Colab,
Tableau
• Aggregated session-level data and calculated KPI
conversion rates
• Validated experiment (SRM) and ran two-sample Z-tests at
total and segment levels• Identified statistically significant
funnel changes across devices, channels, and countries
• Prepared a Tableau-ready dataset and built a dashboard
for control vs test comparison
Project 6 (Python, SQL, Data Engineering)⁠
Job Market Data Pipeline & Telegram Bot
Tools: Python, Pandas, BeautifulSoup, Requests,
PostgreSQL/​CSV, Telegram Bot API
• Built end-to-end data pipeline for collecting вакансии
from multiple sources
• Implemented HTML parsing and reverse-engineered
GraphQL API for data extraction
• Cleaned, normalized, and merged datasets (~1500+
records) with structured features (salary, skills, location,
etc.)
• Developed skill extraction and normalization logic
(SKILL_MAP) for analytics and filtering
• Created Telegram bot for job recommendations with
filtering and ranking logic based on skills

Project 7 (Django, Vue, PostgreSQL, Docker) Comments
SPA⁠
Full-Stack Web Application
Tools: Python, Django, Django REST Framework, Vue 3,
PostgreSQL, Docker, WebSocket
Built a full-stack SPA for threaded commenting with real-
•

time updates via WebSocket
Implemented REST API with Django REST Framework
•

including pagination, sorting, and nested serializers
Developed JWT-based CAPTCHA validation and XSS
•

protection with Bleach sanitization
Configured multi-container deployment with Docker
•

Compose and deployed to Railway

ADDITIONAL EDUCATION
Intermediate SQL⁠

Statistics⁠

SQL Advanced⁠

Data Analyst Full-Time Course⁠

ACHIEVEMENTS
Winner of City Physics Olympiad in 2009

Winner of City Football Cup in 2013