Dusan is available for hire
Hire DusanDusan Nosal
Verified Expert in Engineering
BI Analyst and Developer
Location
Bratislava, Bratislava Region, Slovakia
Toptal Member Since
October 31, 2022
Dusan is a BI analyst and developer with experience across multiple business areas—banking, real estate, insurance, municipality, newspapers, and cinemas. He is passionate about the entire process of designing BI solutions, from analyzing source data through the design and creation of data warehouses, ETL processes, and data marts to the final visualization. Dusan's background is primarily with Microsoft and Oracle BI tools.
Portfolio
Syngenta - Digital Product Engineering
SSRS Reports, SQL Server Reporting Services (SSRS), SQL, Dashboards...
Joseph Smith & Sons, Inc.
SharePoint, Excel 365, Excel 2010, Data Structures, Data Integration, Reporting...
Freelance Clients
Microsoft SQL Server, Oracle Database, Analytics, Finance...
Experience
Availability
Part-time
Preferred Environment
Microsoft Power BI, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Oracle Database, SQL Server Management Studio (SSMS), SSRS Reports
The most amazing...
...achievement is an end-to-end build of a financial data mart for a client in the banking sector.
Work Experience
SSRS Reports Developer
2023 - 2023
Syngenta - Digital Product Engineering
- Developed eight paginated reports using the Power BI Report Builder tool. The development work included advanced groupings, aggregations, expressions, and maps displaying.
- Prepared datasets for paginated reports as queries over PostgreSQL database containing tables with data stored in JSONB format.
- Embedded paginated reports into Power BI Desktop reports with binding dataset parameters into report filters.
Technologies: SSRS Reports, SQL Server Reporting Services (SSRS), SQL, Dashboards, Microsoft Power BI, Microsoft Report Builder, PostgreSQL, Pagination, Reporting, Data Analytics
Consultant
2023 - 2023
Joseph Smith & Sons, Inc.
- Developed a master Excel reporting spreadsheet that combined various source data Excel files submitted daily by different facilities.
- Implemented the new reporting Excel spreadsheet. Saved approximately one hour per day since the reporting was daily and was done manually prior.
- Analyzed source data Excel files from different facilities with a completely different structure but bearing the same information to unify them in a single report.
Technologies: SharePoint, Excel 365, Excel 2010, Data Structures, Data Integration, Reporting, Data Analytics
Business Intelligence Analyst | Developer
2020 - 2022
Freelance Clients
- Analyzed the requirements to be covered by final reporting and available data sources.
- Designed logical and physical data model of a new financial data mart and developed the data mart on Microsoft SQL Server 2019. The data mart was to cover around 2000 attributes and 100 reports.
- Participated in an extension of existing financial data mart built on Oracle Database 19c. Analyzed the current solutions for reporting based on SAS language to acquire all the requirements.
- Examined new data sources and reconciled balances from the new data sources to the general ledger balances. Designed and developed all data flows from data sources to final reports.
Technologies: Microsoft SQL Server, Oracle Database, Analytics, Finance, Relational Database Design, T-SQL (Transact-SQL), SQL, SQL Stored Procedures, Microsoft Excel, Data Engineering, ETL, Business Intelligence (BI), Data Analysis, Data Transformation, Data Cleansing, Financial Data, Data Reporting, Economics, Investments, Commercial Banking, Oracle SQL Developer, SQL Server Management Studio (SSMS), Git, Functional Analysis, Data Modeling, Data Warehousing, Databases, Reports, Excel 365, ETL Tools, Relational Databases, Data Pipelines, Database Architecture, RDBMS, SQL Server DBA, Data Architecture, BI Reporting, Microsoft Dynamics 365, Excel 2010, Data Structures, Data Integration, Reporting, Data Analytics, Warehouses
Senior Business Intelligence Consultant
2018 - 2019
ICA Group
- Created a Power BI dashboard showing near real-time data (refreshing every 15 minutes) from more than 40 SQL servers.
- Migrated approximately 40 reports from SAP BusinessObjects to SQL Server Reporting Services, including changes in the original source data.
- Migrated a data warehouse (DWH) from one Microsoft SQL server to another, including the replication of all database objects—tables, views, Integration Services (SSIS) catalog, environments, jobs, etc.
- Built and maintained over 100 ETL processes in SQL Server Integration Services to feed a DWH using dynamic connections to 40 Microsoft SQL Servers.
- Analyzed data sources and processes in AWS and prepared functional analysis, which resulted in designing a new DWH.
Technologies: Microsoft SQL Server, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL (Transact-SQL), SQL, SQL Stored Procedures, Microsoft Excel, Analytics, Data Engineering, ETL, Business Intelligence (BI), Data Analysis, Dashboards, Data Visualization, Data Transformation, Data Cleansing, Data Reporting, Relational Database Design, Microsoft Access, SQL Server Management Studio (SSMS), Git, Functional Analysis, Data Modeling, DAX, Data Warehousing, Databases, Reports, Excel 365, ETL Tools, Relational Databases, Data Pipelines, Azure, Database Architecture, RDBMS, SQL Server DBA, Data Architecture, Power Query, BI Reporting, Dashboard Design, Excel 2010, Data Structures, Data Integration, SSRS Reports, Reporting, Data Analytics, Warehouses
Senior Business Intelligence Consultant
2017 - 2018
Sogeti
- Analyzed a municipality client's requirements for a dashboard and its alignment with available source data.
- Developed a DWH based on Microsoft SQL Server 2012, ETL process in SQL Server Integration Services, and data mart using SQL Server Analysis Services.
- Devised a dashboard in the Power BI desktop tool using SQL Server Analysis Services cube as source data.
Technologies: Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Power BI, T-SQL (Transact-SQL), SQL, SQL Stored Procedures, Microsoft Excel, Analytics, Data Engineering, ETL, Business Intelligence (BI), Data Analysis, Dashboards, Data Visualization, Data Transformation, Data Cleansing, Data Reporting, Relational Database Design, SQL Server Management Studio (SSMS), Git, Functional Analysis, Data Modeling, DAX, Data Warehousing, Databases, Reports, Excel 365, ETL Tools, Relational Databases, Data Pipelines, Database Architecture, RDBMS, Data Architecture, Power Query, BI Reporting, Dashboard Design, Excel 2010, Data Structures, Data Integration, Reporting, Data Analytics, Warehouses
Senior Procurement Analyst
2013 - 2017
Johnson Controls
- Migrated reports from Microsoft Access to Microsoft SQL Server, resulting in a 50% saving on time spent on reports preparation.
- Extracted and consolidated data from multiple ERP systems such as Oracle, SAP, and iScala monthly.
- Analyzed data and created global regular and ad hoc supply chain management reports using Microsoft Excel, Access, Power BI, and SQL Server.
Technologies: Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft Access, T-SQL (Transact-SQL), SQL, SQL Stored Procedures, Microsoft Excel, Analytics, ETL, Business Intelligence (BI), Data Analysis, Dashboards, Data Visualization, Data Transformation, Data Cleansing, Financial Data, Data Reporting, Finance, Economics, SQL Server Management Studio (SSMS), Functional Analysis, Databases, Excel VBA, Reports, Excel 365, ETL Tools, Relational Databases, Data Pipelines, Database Architecture, RDBMS, Data Architecture, Power Query, BI Reporting, Dashboard Design, Excel 2010, Data Structures, Data Integration, SSRS Reports, Reporting, Data Analytics, Warehouses, Data Warehousing
Asset Management Data Analyst
2010 - 2013
Hewlett Packard Enterprise
- Processed manual database updates according to requests received through email or the Remedy ticketing tool.
- Requested mass updates, database cleanups, and adjustments through IT tickets.
- Exported data from FactoryTalk Asset Centre and Remedy tools; created reports in Microsoft Excel.
Technologies: Asset Center, BMC Remedy, Microsoft Excel, Data Analysis, Data Reporting, Reports, Excel 365, Excel 2010, Reporting, Data Analytics
Experience
Near Real-time Data Dashboard
A near real-time data Power BI dashboard for a chain of cinemas. The dashboard was refreshed every 15 minutes and showed actual data of sold tickets and bar products in 40 cinemas.
The project entailed the preparation of a data mart based on Microsoft SQL Server 2016, an ETL process using SQL server integration services, bringing data from 40 Microsoft SQL servers and a Power BI desktop in direct query mode.
The project entailed the preparation of a data mart based on Microsoft SQL Server 2016, an ETL process using SQL server integration services, bringing data from 40 Microsoft SQL servers and a Power BI desktop in direct query mode.
Financial Data Mart
An end-to-end solution for a financial data mart for a client from the banking sector.
The data mart consisted of 70 tables and a complex ETL process based on 100 stored procedures and was about to cover around 20 financial reports.
The development of this solution passed through the following phases:
-Functional analysis of requirements to be covered by financial reports
-Analysis of data sources, design of logical and physical data model
-Development of the new data mart on MS SQL Server
The data mart consisted of 70 tables and a complex ETL process based on 100 stored procedures and was about to cover around 20 financial reports.
The development of this solution passed through the following phases:
-Functional analysis of requirements to be covered by financial reports
-Analysis of data sources, design of logical and physical data model
-Development of the new data mart on MS SQL Server
Power BI Dashboards
Power BI dashboards displaying employee performance for a municipality client. The analysis of the client's requirements and their alignment with source data comes from an internal application daily.
The data warehouse was modeled and developed on MS SQL server. Over the data warehouse, a small data mart in SQL server analysis services has been deployed and used as a source for Power BI dashboards.
The data warehouse was modeled and developed on MS SQL server. Over the data warehouse, a small data mart in SQL server analysis services has been deployed and used as a source for Power BI dashboards.
Education
2004 - 2009
Master's Degree in Finance, Banking, and Investments
University of Economics in Bratislava - Bratislava, Slovakia
Skills
Tools
Microsoft Power BI, Excel 2010, Microsoft Access, Microsoft Excel, Git, Power Query, BMC Remedy, Microsoft Report Builder
Languages
SQL, T-SQL (Transact-SQL), Excel VBA
Paradigms
ETL, Functional Analysis, Business Intelligence (BI)
Storage
Microsoft SQL Server, SQL Server Management Studio (SSMS), Data Integration, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Stored Procedures, Databases, Relational Databases, Data Pipelines, Database Architecture, RDBMS, Oracle SQL Developer, SQL Server DBA, PostgreSQL
Platforms
Oracle Database, Azure, SharePoint
Other
Dashboards, Data Visualization, Data Transformation, Data Cleansing, Data Reporting, Reports, Excel 365, BI Reporting, Dashboard Design, Data Structures, Reporting, Data Analytics, Finance, Economics, Analytics, Relational Database Design, Data Engineering, Data Analysis, Financial Data, Data Modeling, DAX, Data Warehousing, ETL Tools, Data Architecture, SSRS Reports, Warehouses, Commercial Banking, Investments, Asset Center, Microsoft Dynamics 365, Pagination
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring