Serhiy Dranko

Data Analyst

I turn raw data into clear business insights.

3+ years experience in analytics, reporting and ETL

Serhiy Dranko Serhiy Dranko
📍Location: Europe / Remote
📊Domains: E-commerce, Sales, Operations
🌐Languages: English / German / Ukrainian
✉️Experience: Data Analyst

projects

E-commerce Sales Delta Report

Automated daily report to track revenue changes

  • Python + Spark SQL + Azure + Delta Lake + Databricks
  • Compared day-to-day sales metrics
  • Transition from manual price analysis to fully automated push notification reports

Jira Effort Aggregator & Financial Mapper

Automated SQL pipeline to consolidate multi-level Jira worklogs into unified financial reports

  • Spark SQL + Databricks + Jira API (Tempo)
  • Normalizes complex hierarchies (Epic → Task → Sub-task) into flat financial views
  • Automated bottom-up cost allocation and expense type mapping

Global Sales Performance & Analytics System

Automated KPI monitoring for US, EU, and UA sales regions.

  • Python + Spark SQL + Azure + Databricks + Microsoft Graph API
  • Instant calculation of Conversion rates and Average Order Value (AOV) using Spark SQL.
  • Fully automated delivery via Microsoft Graph API with dynamic HTML tables and Excel attachments.

Global Sales Performance & Analytics System

Automated KPI monitoring for US, EU, and UA sales regions.

  • Python + Spark SQL + Azure + Databricks + Microsoft Graph API
  • Instant calculation of Conversion rates and Average Order Value (AOV) using Spark SQL.
  • Fully automated delivery via Microsoft Graph API with dynamic HTML tables and Excel attachments.

Skills

📊

Data Analysis

  • SQL (complex joins, window functions, aggregations)
  • Python (pandas, automation)
  • Data wrangling and exploratory data analysis (EDA)
⚙️

Data Engineering

  • Databricks, Spark SQL
  • ETL pipelines
  • Data integration and transformation
🛠️

Visualization

  • Data quality checks and validation
  • Delta Lake (Time Travel, ACID transactions), Apache Spark, Data Lakehouse
  • Debugging and troubleshooting data issues
  • Business dashboards

About Me

text

  • Write an Email
    • 🔗
  • My LinkedIn
    •
    🐙
  • More on Github
    •