Professional profile

Sjors van Diepen

Senior Business Intelligence Analist, Financial Markets at De Nederlandsche Bank

Amsterdam, North Holland, Netherlands

Professional profile

Financial Markets Operations Expert | Specializing in Data & Reporting | Power BI & Python | Treasury Management System Wizard | Let's connect! #FinancialMarkets #DataAnalytics #TreasuryManagement

Professional experience

Senior Business Intelligence Analist

De Nederlandsche Bank

Jul 2022 - Present

Financial Markets - Data & Reporting Team

Empowering the business by providing tailored insights and data-driven solutions to streamline their operations

Subject Matter Expert:

  • Dashboarding
  • Process Automation
  • Regulatory Reporting (like MER & MESRAP)
  • Power Platform, Power Automate
  • Power BI (PL-300), Power Query M, DAX, Power BI Services, MS Fabric
  • Python, SQL, Git, ADO

Functional Application Manager

De Nederlandsche Bank

May 2019 - Jun 2022 · 3 yrs 2 mos

Financial Markets - Investment Operations

First point of contact for Changes and Incidents for all Financial Markets software, mainly the Treasury Management System; WallStreet Suite

  • Identifying and defining business requirements
  • Configuring the Treasury Management System to streamline processes
  • Collaborating cross-functionally within projects with both business and IT teams
  • Engaging with vendors and external consultants for custom software solutions, upgrades, and migrations
  • Managing data migration during significant projects to ensure seamless transition
  • Ensuring accurate master data management, including client and instrument data
  • Implementing and maintaining access management protocols

Middle Office & Back Office

De Nederlandsche Bank

Apr 2016 - Apr 2019 · 3 yrs 1 mo

Financial Markets - Investment Operations

Running daily operational tasks like cash management, collateral management, reconciliations and matching and monitoring all kind of transactions

Subject Matter Expert:

  • Treasury Management System
  • Client Services; Cash and Custody
  • Collateral Management
  • Cash Management, Nostro, Vostro
  • Reconciliations and Investigations
  • Automation, STP
  • MS Excel + VBA

Platforms:

Target 2, T2S, Swift (MT/MX), CLS, Euroclear, Bloomberg, FX-all, WallStreet Suite, Calypso

Financial Products:

Fixed Income, Equity, Repos, ABS, FRN, Futures, IRS, FX Derivatives, Deposits, Securities Lending

Graduation internship: Digital Client Portal

De Woonschakel

Sep 2015 - Mar 2016 · 7 mos

Investment analysis digital client portal

Internship: Treasury Operations

KAS BANK N.V.

Sep 2014 - Jan 2015 · 5 mos · Amsterdam Area, Netherlands

Securities Borrowing & Lending

Running operations, tasks like:

  • Booking, archiving and monitoring of trades.
  • Checking trades with counterparties across the world.
  • Processing of incoming recalls.

Internship: Assistant Accountant

Admi-Lux

Oct 2010 - Apr 2011 · 7 mos · Hoorn

Academic background

MSc, Business Process Management and IT

Open Universiteit

2018 – 2021

The programme consists of a pre-master and a master's programme with the following courses:

  • Business Intelligence
  • IT Governance
  • Enterprise Architecture
  • Rule-Based Design
  • Business Processes
  • Thesis

BSc, BBA, Finance & Control

Amsterdam University of Applied Sciences

2011 – 2016

Minor in Investing

Amsterdam University of Applied Sciences

2013 – 2014

Course overview Minor in Investing (Advanced)

  • Investment Advice and Management Theory (AEBT)
  • Investment Advice and Management Skills (AEBV)
  • Behavioural Analysis (GAN)
  • Ethics (ETH)
  • Products (PSP)
  • Technical Analysis (TAN)
  • Value Based Management (VBM)
  • Financial Research
  • Paper

MBO level 4, Administrator

ROC Horizon College

2009 – 2011

Professional certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Microsoft

Issued Jan 2024 · Expired Jan 2026

Credential ID 1439920A3C95C1F7

Verify Certificate

Lean Six Sigma, Green Belt

De Nederlandsche Bank (DNB)

Issued Jun 2018

ACI Treasury Operations Certificate

ACI Financial Markets Association

Issued May 2018

Credential ID EKP-0063-8900-3631-5740

Verify Certificate

Areas of expertise

Dashboarding Process Automation Regulatory Reporting Power Platform Power Automate Power BI Power Query M DAX Power BI Services Microsoft Fabric Python SQL Git Azure DevOps Treasury Management System Collateral Management Cash Management Reconciliations and Investigations Automation STP MS Excel + VBA Accounting Finance

Let's connect

View my complete professional profile on LinkedIn.

Open LinkedIn profile