Bálint Bognár

Developed a new end-to-end reporting system that uses up-to-date technologies for the logistics department of the company.

• Collaborated with the IT team to define the structure of the data warehouse and datamart tables behind the reporting system.
• Integrated data from multiple data sources (databases, Excel spreadsheets, online Sharepoint folders) into analytical frameworks for comprehensive reporting purposes.
• Reduced report turnaround times by automating manual procedures through the implementation of ETL workflows with tools like MS SQL Server and Power BI.
• Developed complex but robust SQL scripts to extract relevant information from large datasets.
• Examined the accuracy of data using Pandas framework in Python.
• Cleansed and analyzed data with the help of data modeling and visualizations to draw actionable insights.
• Provided ad-hoc reports for executive leadership team to support informed decision-making and provide insights into business performance.
• Created dashboards in Power BI to monitor and track key performance indicators.

• Queried data from Oracle databases.
• Cleaned and transformed data in Python and Power BI.
• Created visualizations and presenting them in business reports and interactive dashboards in Power BI to help clients gain helpful insights and make the best possible decisions with the help of data.
• Developed database-queries in Kusto query language for IT Security analysis.
• Gained useful experience in agile work environment.