Lorand Karolyi
Verified Expert in Engineering
Data Analyst and Developer
Budapest, Hungary
Toptal member since July 9, 2021
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
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
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
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.
Plant Financial Controller — Life Sciences Division
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.
Costing Lead — Energy Services
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.
Costing Analyst — Nalco Water
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.
Controlling Intern — Supply Chain
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.
Sales Advisor
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.
Experience
Showcase Project — Data Visualization
https://www.gocloudtoday.com/tryGoal:
‣ 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/tryGoal:
‣ 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.
Education
Bachelor's Degree in Business Administration and Management
Corvinus University of Budapest - Budapest, Hungary
Certifications
Microsoft Certified Trainer
Microsoft
Microsoft Certified Professional
Microsoft
Skills
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
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