Wojciech Szczołek

Senior Financial Analyst

Umiejętności

SAS (program) SQL Developer Excel, Word, PowerPoint

Języki

angielski
biegły
rosyjski
podstawowy

Doświadczenie zawodowe

Deutsche Bank Polska S.A
data scientist
Management reporting in SAS DI.
Gap Year
vagabond
The Royal Bank of Scotland (RBS)
team leader
- Leading the team in all areas of it’s performance,
- delivering Head Office reports on behalf of local customers,
- preparing Balance Sheet and completing Finance Reports
- preparing P&L for Branches on a monthly basis,
- analyse P&L variances,
- implement Lean solutions.
PBS Polska sp. z o.o. Agencja Deutsche Banku
Expert of Business Intelligence
- Preparing MI reports for internal client basing on Oracle Data Warehouse and SAS,
- calculating revenues on a monthly basis for sales network,
- implementing New Data Warehouse as a Golden Source for Branch in Poland,
- performing SIT and UAT tests for new tools.
The Royal Bank of Scotland Group
Senior Financial Analyst
- Conducting finance activities migration from United Arab Emirates to Poland,
- profit and loss Head Office reporting according to legal (DNB) requirements,
- customer profitability variance analysis,
- ensuring compliance with financial reporting standards, legal, SOX, regulatory and supervisory and RBS requirements,
- process automating.
- Regulatory reporting system integration.
The Royal Bank of Scotland Group
Financial Analyst
- General Ledger Systems integration project for the Group,
- identifying breaks and finding solutions,
- getting several trainings in London,
- giving trainings of new Reporting System for local users in Russia and Korea,
- accountancy reporting lines integration for Denmark and Sweden,
- designing business and functional specification of Reporting Tool for finance MI and Group Reporting purposes,
- solving ad-hock Data Warehouse issues.
ABN AMRO Bank Polska
Basel 2 Reporting Specialist
- Basel 2 Risk Weight Assets reporting according to IFRS regulations,
- Data Quality Management Committees coordination,
- Basel 2 process migration (remotely and locally) from several countries. Local trainings in Kazakhstan, Uzbekistan, Dubai, Luxemburg, Netherlands.
- coordinating and monitoring of Basel 2 home reporting process for units in Kazakhstan and United Arab Emirates,
- participating in process migration to MIS Data Warehouse,
- creating RWA simulations,
- coordinating and taking responsibility for data sourcing activities performed by team for the whole region.
Robert Kubacki
Robert Kubacki · współpracownik
wystawiono
Wojtek to profesjonalista. Zanim wykona zadanie szuka najbardziej optymalnego rozwiązania. Doskonale identyfikuje i likwiduje "wąskie gardła" w organizacji.

Szeroka wiedza ekonomiczna jaka posiada, sprawia, że rozmowy z Wojtkiem nigdy nie są nudne.
Elavon Financial Services Ltd.
Operations and Customer Service Specialist
- preparing and reviewing turnover reports,
- accountancy supervising,
- heading of migration process of rejected transactions from western Europe HUB to Warsaw, team coordination,
- workouts, automation.

Szkolenia i kursy

• Client Acceptance and Anti-Money Laundering (CAAML)
• Complying with Economic Sanctions
• Computer Based MiFID Awarness Programme (CBMAP)
• BASEL II Awareness Programme
• Operational Risk Management (ORM)
• Język SQL w bazie danych Oracle / NobleProg
• MS Access - Zbieranie i konsolidacja informacji / Altkom Akademia

Edukacja

Logo
Ekonomia, magisterskie
Uniwersytet Warszawski
Logo
Zarządzanie i marketing, magisterskie
Uniwersytet Warszawski

Specjalizacje

Bankowość
Analiza/Ryzyko
Bankowość
Bankowość detaliczna
Finanse/Ekonomia
Kontroling
IT - Rozwój oprogramowania
Programista VB
IT - Rozwój oprogramowania
Inne

Zainteresowania

International policy, travelling, volleyball

Inne

- experience in multinational environment,
- very good knowledge of Excel, PL SQL, programmatic skills (Visual Basic),
- experience in Data Warehouse processing (Oracle Discoverer),
- basic SAS,
- preference for work in variable project environment,
- wide economics knowledge,
- outstanding analytical skills,
- wide view on organisation performance.

Grupy

Uniwersytet Warszawski
Uniwersytet Warszawski
Uniwersytet Warszawski, założony w 1816 roku, jest największą polską uczelnią i jednocześnie jedną z najlepszych w kraju.