Mateusz Rac
Royalties Analyst, SM Publishing (Poland) Sp. z o.o.
Warszawa,
mazowieckie
Umiejętności
C#
Microsoft Excel
Wydawca muzyczny
SQLite
Bazy danych
VBA Excel
Języki
polski
ojczysty
angielski
dobry
Doświadczenie zawodowe
Royalties Analyst
- Preparing cash receipts journals (CRJs) and financial transaction forms (FTFs) files based on electronic documentation from CMOs and sub-publishers;
- Tracking unpaid royalties using external data sources (radio playlists, TV schedules, concert setlists, CISAC AVI-NET etc.);
- Manual matching of internal suspense - using societies’ databases - ZAiKS, PRS, OSA, ISWC-NET and previous SATV and EMI copyright systems. Developing proprietary solution of auto- and semi-manual matching tools;
- Working on UP files from societies;
- Worked on works registration files (developing tools for decoding CWR format);
- Preparation, maintenance and improvement of databases using SQLite technology, including SQL programming;
- Developing proprietary solution of local repertoire database (copyright data storing, generating ZAiKS registration forms, generating registration files for SATV system etc.); used technology: C#, SQLite.
- Tracking unpaid royalties using external data sources (radio playlists, TV schedules, concert setlists, CISAC AVI-NET etc.);
- Manual matching of internal suspense - using societies’ databases - ZAiKS, PRS, OSA, ISWC-NET and previous SATV and EMI copyright systems. Developing proprietary solution of auto- and semi-manual matching tools;
- Working on UP files from societies;
- Worked on works registration files (developing tools for decoding CWR format);
- Preparation, maintenance and improvement of databases using SQLite technology, including SQL programming;
- Developing proprietary solution of local repertoire database (copyright data storing, generating ZAiKS registration forms, generating registration files for SATV system etc.); used technology: C#, SQLite.
Edukacja
Grupy
Politechnika Warszawska
Politechnika Warszawska jest najstarszą polską uczelnią techniczną. Od ponad 180 lat kształci kolejne pokolenia inżynierów, wnosząc istotny wkład w rozwój nauk technicznych.