Lorand Karolyi, Developer in Budapest, Hungary
Lorand is available for hire
Hire Lorand

Lorand Karolyi

Verified Expert  in Engineering

Bio

Lorand is a senior data analyst and developer with over five years of experience in business intelligence and analytics and a substantial knowledge base of finance and supply chain functions. A Microsoft Certified Data Analyst and Microsoft Certified Trainer, Lorand has delivered more than a dozen digital transformation projects. Lorand prides himself on being extremely flexible and having a "nothing is impossible" and "straight to the point, no-nonsense" mindset.

Portfolio

Ecolab
Microsoft Power BI, Azure, Azure SQL, Dynamics CRM 365...
Ecolab
SAP, SAP Business Intelligence (BI), AS/400, IBM Cognos, IBM Db2...
Ecolab
Finance, Corporate Finance, Inventory Cost Accounting, Financial Closing, SAP...

Experience

  • Data Analytics - 6 years
  • DAX - 6 years
  • Power Query - 6 years
  • Microsoft Power BI - 6 years
  • Azure Data Factory - 4 years
  • Azure SQL - 4 years
  • Microsoft Power Automate - 4 years
  • Azure Analysis Services - 4 years

Availability

Part-time

Preferred Environment

Microsoft Power BI, Azure SQL, Azure Analysis Services, DAX, Power Query, Excel Expert, Microsoft Power Automate, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Azure Data Factory, Azure Data Lake

The most amazing...

...thing I've ever delivered was a sales-and-profitability reporting system in Power BI, which was then deployed to more than 3,000 people across the organization.

Work Experience

Senior Digital Analyst — Digital Analytics

2018 - 2020
Ecolab
  • Served as a key facilitator in the digital transformation of the commercial finance and P&A functions.
  • Developed solutions replacing manual reporting for over 3,000 associates across Europe used for daily sales and profitability reporting by using cutting-edge business intelligence tools.
  • Leveraged the latest Microsoft analytics technologies and the "zero operations" mindset.
Technologies: Microsoft Power BI, Azure, Azure SQL, Dynamics CRM 365, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Azure Data Lake, Spark, Azure Data Factory, Azure Analysis Services, Power Query, DAX, Excel 365, Excel VBA, Microsoft Power Automate, Microsoft Power Apps, Microsoft Access, SAP, SAP Business Intelligence (BI), Master Data Management (MDM), Data Visualization, Data Modeling

Plant Financial Controller — Life Sciences Division

2017 - 2018
Ecolab
  • Served as a financial advisor for a key manufacturing plant in Europe.
  • Led the budgeting, monthly closing, performance monitoring, and several automation activities.
  • Introduced modern analytics solutions on top of a decades-old ERP landscape.
  • Upgraded the reporting capabilities of the IBM Db2 (AS400)-based ERP system with decommissioning some unsupported systems, still deployed in the 90s.
  • Built Power BI dashboards for the plant's financial management processes.
Technologies: SAP, SAP Business Intelligence (BI), AS/400, IBM Cognos, IBM Db2, Microsoft Power BI, Finance, Supply Chain Management (SCM), Corporate Finance, Excel 365, Office 365, Microsoft Access, SQL, Industrial & Manufacturing, Data Visualization, Data Modeling

Costing Lead — Energy Services

2016 - 2018
Ecolab
  • Standardized the financial processes in the region, consisting of 14 different countries.
  • Automated the monthly manual tasks related to month-end closing and coordinated the standard cost planning activities to Ecolab's most complex division.
  • Spearheaded the change towards Microsoft technologies and rolled out the first Power BI dashboards for the EU supply chain team, supporting the yearly budgeting activities.
Technologies: Finance, Corporate Finance, Inventory Cost Accounting, Financial Closing, SAP, SAP ERP, SAP Business Intelligence (BI), Excel 2016, Excel VBA, Microsoft Access, Microsoft Power BI, Data Visualization, Data Modeling

Costing Analyst — Nalco Water

2015 - 2016
Ecolab
  • Oversaw and was responsible for the execution and automation of the monthly actual cost calculation process.
  • Coordinated the standard cost planning and took responsibility for several SOX controls in the NW division.
  • Drove the development of a new VBA/Excel-based monthly cost calculation tool.
  • Deployed Tableau-based reports across the EU supply chain finance organization.
Technologies: SAP, SAP Business Intelligence (BI), Inventory Cost Accounting, SOX Compliance, Excel 2016, Microsoft Access, Tableau, Excel VBA, Data Visualization, Data Modeling

Controlling Intern — Supply Chain

2015 - 2015
Ecolab
  • Developed a procurement performance-tracking database.
  • Provided support in the execution of the yearly planning activity.
  • Completed ad-hoc tasks that supported several functions in the SCF team.
Technologies: Supply Chain, Supply Chain Optimization, Excel 2013, Microsoft Access, Planning, Excel VBA, SAP, SAP Business Intelligence (BI)

Sales Advisor

2014 - 2015
Vodafone Group
  • Contributed to Vodafone's pilot project of establishing a shop-in-shop retail model.
  • Outperformed sales targets in every period of my employment.
  • Gained key experience in customer aquisition and professional sales.
Technologies: Sales, Customer Experience Management, Customer Relationship Management (CRM), Customer Acquisition, Excel 2013

Showcase Project — Data Visualization

https://www.gocloudtoday.com/try
This showcase project has been created as a proof of concept for the Go Cloud Today service.

Goal:
‣ To create a showcase product that will show clients how fully cloud-based analytics can operate.

Details:
‣ Using "dummy" data created for a fully operational small retail business, we created sample analytics and visualizations that mimicked the actual products a small business would require.
‣ Multiple roles exist in this sample, in order to show, even within a small business, that focused data has real value and different roles must have significantly different interests so the entire company succeeds.

Lessons learned:
‣ Utilizing "dummy" data sometimes leads to complications people do not comprehend when working on real projects. This dataset has been continuously upgraded during the dashboard development to make the "dummy" data more "real." The outcome gives much more interesting details, however still cannot be analyzed via statistical tools as the data distribution is highly influenced by randomizing functions, which is not the case of real-world datasets.

Showcase Project — Data Modeling and ETL

https://www.gocloudtoday.com/try
This showcase project has been created as a proof of concept for the Go Cloud Today service.

Goal:
‣ To create a "dummy" dataset on which realistic looking Power BI dashboards can be designed on.

Details:
‣ A full analytics implementation was used with best practice tools and was tailored for cost-effective performance (SQL database, AAS, Power BI embedded).
‣ Row-level security is implemented via AAS to ensure proper data access from the reporting layer.
‣ Although Tabular Editor is not an official Microsoft tool, it has been promoted by Microsoft Power BI as a preferred external tool to edit data models easily. It is also much easier and simpler to use rather than the official SSDT through Visual Studio.

Lessons learned:
‣ Using AAS for DAX modelling is more beneficial for smaller clients rather than using Power BI because when it comes to performance, scaling an AAS server offers much more cost-effective options than Power BI Premium. It also gives better control over the data models, when work is shared within a team.
2013 - 2016

Bachelor's Degree in Business Administration and Management

Corvinus University of Budapest - Budapest, Hungary

JUNE 2021 - JUNE 2022

Microsoft Certified Trainer

Microsoft

DECEMBER 2020 - DECEMBER 2024

Microsoft Certified Professional

Microsoft

Libraries/APIs

Node.js

Tools

Microsoft Power BI, Power Query, Microsoft Access, Excel 2016, Tableau, Microsoft Power Apps, Power BI Embedded, Excel 2013, IBM Cognos

Languages

SQL, Excel VBA, Python 3, JavaScript

Paradigms

Database Design, ETL

Platforms

Azure SQL Data Warehouse, Azure, Dedicated SQL Pool (formerly SQL DW), Microsoft Power Automate, AS/400

Storage

Azure SQL, Database Architecture, IBM Db2, Master Data Management (MDM)

Frameworks

Spark

Other

Azure Analysis Services, DAX, Azure Data Factory, Data Analytics, Excel 365, Office 365, Dashboards, Data Visualization, Data Modeling, Excel Expert, Azure Data Lake, Small Business Management, International Trade, Finance, International Finance, Training, Supply Chain, Supply Chain Optimization, Planning, SAP, SAP Business Intelligence (BI), Inventory Cost Accounting, Corporate Finance, Financial Closing, Corporate Social Responsibility (CSR), Tax Accounting, Business Law, Sales, Customer Experience Management, Customer Relationship Management (CRM), Customer Acquisition, SOX Compliance, SAP ERP, Supply Chain Management (SCM), Industrial & Manufacturing, Dynamics CRM 365

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