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

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
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
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
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