Róbert Schmidt

I served as the main developer to provide an analytical data warehouse for one of the biggest entertainment companies in the world and their streaming platform. Streaming platforms are used for keeping a lot of information about customers and their behavior while using them.

The solution needed to process a massive amount of data and be well scalable because of significant peak hours as tens of thousands of users used the platform at the same time, and there was significant growth of users expected. We loaded, cleaned, and processed these data into a dimensional model with Azure Databricks and data were used for KPI dashboards and further analytics with Azure Analytics Services. I integrated several third-party services with the solution, and integration with Adobe Cloud Experience services received the required information in near real-time using Azure Functions and Event Grid. It provides an opportunity to build marketing strategies based on the actual interaction with the platform.

I was in charge of loading and processing KPIs and financial information about hundreds well known enterprises to create a fact-based assessment and benchmark for analytical purposes in Accenture. I loaded data from internal databases and external spreadsheets with ETL jobs using SSIS and transformed with T-SQL in Database. The outputs were delivered as dashboards in PowerBI to the upper management of the clients and the data model was used for further analytical purposes.