01 / Profile · Workforce planning · Data analysis · Excel automation

Deivids
Bergmanis

Workforce planner turned analyst.

I analyse operations data and build Excel and Python tools that take the manual work out of planning. One of them cut my scheduling time by 70%.

Now
WFM Scheduler (analytics & tools), bet365
Before
Playtech Live, 5 yrs
Base
Latvian, living in Malta
Portrait of Deivids Bergmanis
Fig. 01Sliema, Malta

02 / Selected work

All projects →

Work projects are described in prose, with names and figures withheld. Anything with data uses public or synthetic data.

WorkShippedAnonymised
Aug – Sep 2026

IEX data-prep automation

Schedulers clean a raw NICE IEX export by hand before every schedule; automating it cut my scheduling time per cycle by 70%.

My time per cycle −70%

  • Excel
  • Power Query
  • VBA
  • NICE IEX
WorkShippedAnonymised
Sep 2024 – Present

Scheduler toolkit

Payroll, stakeholder presentations and schedule amendments were manual and repetitive; small tools built on one pattern cut them by 40–50%.

Time on these tasks −40–50%

  • Excel
  • VBA
  • Power Query
  • Formulas
WorkIn progressAnonymised
Oct 2026 – Present

Event-driven volume analysis

Base volumes swing with the sporting calendar; a tool combining past volumes with upcoming events to support forecasters.

  • Excel
  • Power Query
  • Formulas
  • Pivot tables

03 / Experience

Workforce planning · iGaming live operations
  1. Nowbet365Sliema, Malta
    1. Workforce Planning Scheduler – Present · 2 yrs 1 mo
      Used here
      • WFM scheduling
      • NICE IEX
      • Excel
      • VBA
      • Power Query
      • Build Excel tools (Power Query, VBA) that automate scheduling work; one cut my own time per scheduling cycle by 70%, with a team rollout next.
      • Automate recurring work (payroll, stakeholder presentations, schedule amendments), cutting the time spent on it by 40–50% on average.
      • Analyse rotation patterns and schedule adherence to spot coverage risks and improve future rosters.
      • Schedule a subset of teams in NICE IEX across phone, chat and email, and coordinate training schedules across teams.
  2. Playtech Live LatviaRiga, Latvia · 4 roles5 yrs 2 mos

    Progressed from on-camera presenting to owning scheduling and capacity planning for a high-volume live studio.

    1. Live Schedule & Planning Specialist – · 3 yrs 9 mos
      Used here
      • WFM scheduling
      • EZShift
      • Capacity & headcount planning
      • Excel
      • Owned monthly and long-term scheduling in EZShift for a high-volume live studio in a regulated environment.
      • Produced capacity plans and staffing scenarios for headcount growth, agreeing hiring timing with Operations and Talent Acquisition.
      • Through COVID-19, rebuilt schedules around distancing limits, curfews and weekly rule changes while keeping minimum staffing so tables stayed live.
    2. Floor Manager · 1 mo
      • Ran the live floor, covering adherence, escalations and shift coverage, at minimum staffing as COVID-19 procedures changed.
    3. Trainer – · 3 mos
      • Trained new presenters on procedures, quality standards and live-production readiness, under COVID-19 restrictions.
    4. Game Show Host – · 1 yr 1 mo
      • Hosted live game shows, adapting delivery to audience feedback within compliance procedures.
  3. Education
    1. Riga Technical College – Professional higher education (1st level, EQF level 5), Computer Engineering
    2. Saulaines Profesionālā vidusskola – Vocational programme, Computer Engineering

04 / Skills

Skills link to the projects that use them

Data & automation

Workforce planning

  • WFM scheduling
  • NICE IEX1 project →
  • EZShift
  • Capacity & coverage planning

Web & dev tools

  • HTML/CSS/JS
  • Git & GitHub
  • Jira

Currently learning

  • SQL
  • Power BI

05 / About

I started in live operations at Playtech Live in Riga as a game show host, then trained new presenters and ran the studio floor.

From 2021 I owned scheduling and capacity planning for the studio in EZShift, and that's where spreadsheets started turning into tools.

At bet365 in Malta I still schedule some teams, but most of my time now goes on ad-hoc analysis and on Excel tools (VBA, Power Query) that automate planning work.

I'm deepening my data skills with SQL and Power BI, and I write up my work here as case studies.

Off the clock: tracked gym training, running and non-fiction.

06 / Contact

Let's talk about planning, data or automation.

Latvian, based in Malta. Always happy to compare notes on workforce planning, scheduling data and Excel automation.