Mikołaj Kanarkowski
Verified Expert in Engineering
Software Developer
Wrocław, Poland
Toptal member since June 18, 2020
Mikolaj is a hands-on data professional who’s worked in a range of industries including banking, business, and telecommunications to name a few. When he encounters a problem, his strategy is to divide into smaller, separate chunks because it’s far easier to focus on one small thing rather than trying to resolve all issues at once. Mikolaj particularly enjoys creating solutions that enable companies to be more productive.
Portfolio
Experience
- SQL - 5 years
- T-SQL (Transact-SQL) - 5 years
- ETL - 5 years
- SQL Server Integration Services (SSIS) - 4 years
- SQL Server Reporting Services (SSRS) - 4 years
- Database Design - 3 years
- Column-oriented DBMS - 2 years
- Database Modeling - 1 year
Availability
Preferred Environment
Visual Studio, SQL Server Management Studio (SSMS), Git, Microsoft SQL Server
The most amazing...
...project I've worked on was creating a data warehouse with an emphasis on the customers. It empowered analysts to make more sophisticated analyses.
Work Experience
Business Intelligence Developer
Objectivity
- Analyzed clients' SQL server environments to suggest changes, improvements, possible risks, and the best practices to follow.
- Suggested data warehouse designs and architecture types.
- Prepared data models, data and created ETLs to satisfy data analysts.
- Rewrote and simplified queries/stored procedures.
- Prepared requirements for a data warehouse.
DWH/BI Developer
Ryanair
- Participated in the creation of the biggest data mart in the company.
- Optimized T-SQL queries and procedures (especially ColumnStore indexes) to meet the allowed processing time.
- Helped business analysts to write more efficient queries.
- Automated ETL processes using SSIS.
- Maintained and developed various data marts.
Business Intelligence Consultant
Client Solutions
- Maintained and developed data warehouses for the biggest telecommunication companies in Ireland.
- Explained complex ETL logic to clients in a clear manner.
- Shortened the time of daily ETL jobs to meet clients' demands.
- Prepared and created ETL processes.
- Resolved ETL issues.
Business Intelligence Developer
Vulcan
- Created and designed reports for the entire organization using SSRS and Power BI.
- Collected requirements from business owners and product managers.
- Maintained and developed existing business intelligence solutions.
- Wrote queries in T-SQL and MDX.
- Automated ETL processes using SSIS.
Business Intelligence Developer
Itmagination
- Carried out a data migration involving a few billion records for a bank.
- Maintained data quality during the whole process (over 700 rules).
- Created reports in SSRS to visualize data quality, states of various processes, and so on.
- Implemented ETL processes pursuant to the analysis developed by business analysts.
- Analyzed customer requirements and prepared analytical documents.
Junior Business Intelligence Developer
TC Concept
- Implemented reports in SSRS (e.g., margins bills, costs planning, creating rankings of sales representatives, financial analysis, and so on).
- Maintained and developed existing data warehouses (mainly based on ERP, CRM, and financial systems).
- Created requirements, specifications, and analyses of the business needs of customers.
- Maintained everyday contact with clients (chief executives, CFOs, accountants, people from the controlling departments, and IT administrators).
- Created tools in Microsoft Excel macros (VBA).
Experience
Build of an Enterprise Data Warehouse
Due to our efforts, the analysts were empowered to create various sophisticated analysis regarding hundreds of thousands of customers across multiple attributes.
Education
Bachelor's Degree in Organizational Management
Wrocław University of Science and Technology - Wrocław, Polan
Certifications
Azure Data Engineer Associate
Microsoft
Microsoft Exam 767: Implementing a Data Warehouse
Microsoft
MCSE: Data Management and Analytics
Microsoft
MCSA: SQL 2016 Database Development
Microsoft
Skills
Tools
Git, Visual Studio, SSAS, Subversion (SVN), Microsoft Power BI, MariaDB ColumnStore
Languages
SQL, T-SQL (Transact-SQL), Visual Basic for Applications (VBA)
Storage
SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Database Modeling, Column-oriented DBMS, SQL Server Data Tools (SSDT), Microsoft SQL Server, SQL Server Analysis Services (SSAS), Azure SQL
Paradigms
Database Design, ETL
Platforms
Azure
Other
ELT
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring