Summary
Skills
Work History
Education
Certification
Languages
Overview
Timeline
Work Availability
Selected Migration Method (short)
Tools & Tech
Earlier Experience
web

Oleg Shatunov

Prague

Summary

BI Analyst focused on Tableau → Apache Superset migration and decision-driven dashboards. Hands-on with Superset (SQL Lab, native filters, RBAC, Docker/Preset), Tableau, Power BI, SQL, and Python. Turn messy operations data into clear KPIs and easy-to-use dashboards.

Skills

BI & Dashboards:

  • Apache Superset (SQL Lab, native filters, RBAC, cross-filtering), Tableau, Power BI

Data:

  • SQL (joins, aggregations, window functions), Python (pandas/EDA), Excel

Migration:

  • Audit → metric mapping → rebuild → side-by-side validation → usability → docs

Security/Modeling:

  • RLS basics, role design, dataset permissions; familiar with Data Vault

Ops & Delivery:

  • Stakeholder communication, scope control, short demos, clear docs

Infra:

  • Docker (Superset), Git (basic)

Work History

BI Analyst - Operations & Data Insights

UPS Czech Republic
Prague, Czech Republic
05.2024 - Current
  • Built Power BI dashboards for delivery KPIs, route efficiency, and simple what-if planning.
  • Highlighted bottlenecks and helped planners rebalance loads, improving on-time delivery.
  • Turned daily ops questions into clear KPIs and visuals used in planning huddles.

Freelance BI Analyst & Data Consultant

Self-Employed
Czech Republic (Remote)
01.2021 - Current
  • Designed interactive dashboards in Power BI & Tableau using SQL, DAX & Excel.
  • Applied Python for data cleaning and exploratory analysis (pandas/EDA).
  • Developed KPI reporting and performance analytics for sales, operations, and ESG metrics.
  • Translated complex datasets into visual insights for non-technical stakeholders.
  • Superset (last 3–4 months): Docker/Preset setup, SQL Lab metrics, native filters & scope, RBAC; rebuilt prior Tableau/Power BI dashboards in Superset to validate parity and UX.
  • Selected Projects: ER Overload Predictor (healthcare); Sustainable Sales Tracker (ESG); Airline On-Time Performance.

Independent Financial Market Analyst & Educator

Various Investment Firms & Proprietary Trading Desks
Remote
01.1999 - 01.2022
  • Conducted quantitative market analysis and forecasting using historical data and pattern recognition.
  • Developed Excel dashboards and reporting tools; later integrated Power BI for visualization.
  • Delivered training & insights to traders on risk, performance, and market analytics.

Education

Master of Science - Mechanical Engineering

Ulyanovsk State University
Russia
06-1990

Certification

  • Coursera Specialization: Business Intelligence & Data Analytics, Power BI, SQL, ETL
  • Quantium: Retail Analytics with SQL, R, and BI dashboards

Languages

English
Full Professional
Russian
Native or Bilingual
Czech
Professional Working

Overview

27
27
years of professional experience
1
1
Certificate

Timeline

BI Analyst - Operations & Data Insights

UPS Czech Republic
05.2024 - Current

Freelance BI Analyst & Data Consultant

Self-Employed
01.2021 - Current

Independent Financial Market Analyst & Educator

Various Investment Firms & Proprietary Trading Desks
01.1999 - 01.2022

Master of Science - Mechanical Engineering

Ulyanovsk State University

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Selected Migration Method (short)

• Audit Tableau dashboards (charts, filters, calcs, sources).
• Rebuild metrics in Superset SQL Lab; confirm definitions.
• Recreate charts & native filters; set scope/cascades; cross-filtering where useful.
• Side-by-side validation (numbers, filters, trends) + usability pass.
• Handover: short guide + quick demo.

Tools & Tech

  • BI: Apache Superset (Docker/Preset, SQL Lab, native filters, RBAC), Tableau, Power BI
  • Data: SQL (Postgres/BigQuery-style), Python (pandas), Excel
  • Practices: KPI design, RLS basics, RBAC roles, data-quality checks, staging views, change logs

Earlier Experience

Flight Operations Planning & Analytics, Volga-Dnepr Airlines Ireland (1990–1998)
Planned global cargo missions and built simple Excel metrics for planning/turnaround; foundation for later analytics work.

Oleg Shatunov