Gabor Prokay

I assessed the current state of a legacy data warehouse solution, designed a new architecture using recent technologies and industry best practices, and proposed a new way of working to handle business intelligence.

In the second phase, we implemented the proposed architecture using various Azure technologies (Synapse Analytics, Data Lake, and Power BI) and our custom ETL tool (EtLast) to implement an automated data extractor and history builder, create a reporting database, and implement legacy key financial (mainly Excel) reports as Power BI interactive reports.

I also hosted multiple workshops about modern BI solutions, including an Azure tech stack and Power BI.

An Azure cloud-based data warehouse project using Azure Data Lake Gen2, ADF, synapse analytics, and our custom ETL, EtLast, to replace a legacy solution. Redesigned and rebuilt existing Power BI reports to use the new data warehouse and modernize the UX.

.NET Framework WCF and ASP.NET Web Forms-based Spotfire server management software. This solution was a distributed software with a load-balanced central server and agents installed on Spotfire host servers. It was capable of installing updates and extensions and copying content between Spotfire servers. My responsibility was to define the functional specifications and then design and implement the back-end APIs and agents.

A custom connector for TIBCO Spotfire built with WinForms. Earlier versions of Spotfire did not support SAP BW Connectors, and the first official solution has had many limitations. Our goal with this project was to enable loading data from all SAP BW objects. I was responsible for implementing the UI and data loading and SAP BW query generation mechanisms during this project.

ASP.NET Web API and Angular-based application to support moving SKU production between producing plants. During this project, I helped to define the complete workflow with the client during several interviews with key personnel as a first phase. After that, I designed and delivered the software solution, which implemented the workflows, managed users, and master data.

This was a complete solution that included data from all kinds of data sources (MySQL, Excel, CSV, and MS SQL) into a datamart (MS SQL) while consolidating data across all the source systems. My responsibility was to define the data sources and loading frequencies with the client and then implement the ETL processes required to load all data into an MS SQL datamart. Designing the tabular model and Power BI reports was also my task during this project.

A complete overhaul of an existing restaurant management software, using the latest Angular and ASP.NET Web API versions. I was responsible for designing the solution's architecture and implementing a floor planner and table availability calculation functionalities.