Roland Szirmai
Founder & Principal Consultant at BI-Lingual Analytics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Hungarian Native or bilingual proficiency
-
English Full professional proficiency
Topline Score
Bio
Credentials
-
Power BI to the People
Professional AdvantageAug, 2019- Sep, 2024 -
Effective Communication
Australian Institute of ManagementJan, 2019- Sep, 2024 -
Data Analyst Associate
MicrosoftMay, 2021- Sep, 2024
Experience
-
BI-Lingual Analytics
-
Australia
-
E-Learning Providers
-
1 - 100 Employee
-
Founder & Principal Consultant
-
Jul 2021 - Present
-
-
-
3M
-
Germany
-
Chemical Manufacturing
-
1 - 100 Employee
-
Business Analyst - Systems and Insights
-
Sep 2019 - Present
Key responsibilities: • Implementing Power BI reporting for ANZ HCBG to drive data-driven decisions • Educating Sales and Marketing Team members about using modern analytics tools • Elevating HCBG’s data acumen by facilitating education sessions • Leading regional and global data projects to ensure more accurate reports and forecasting • Building data visualisations to support the local business • Introduce POS (Indirect Sales) reporting to allow team members to assist commercial and customer excellence Achievements • Significantly reduced the amount of time needed to produce monthly reports • Upskilled a group of data super-users who form the Data COE for HCBG • Managed to help business to bounce back after pandemic to pre-lockdown levels within 3 months • Combined 7 different data sources (systems) data to prepare a holistic view for the sales team • Implemented Business Partnering from the Analytics Team • Active participant and contributor of 3M Power BI User Group by sharing analytics best practices Show less
-
-
-
Active Tree Services
-
Australia
-
Environmental Services
-
100 - 200 Employee
-
Commercial Analyst
-
Jul 2017 - Sep 2019
Key responsibilities• Setting up and maintaining Monthly Financial Dashboards for the Management• Managing NSW, ACT and NT contracts data integrity and creating reporting structure• Process harmonization over different Power Authorities’ contracts• Creating automated reports based on business needs and Business Partnering• Scenario analysis for different vegetation management options and other ad-hoc scenario modelling• Work with relevant dept (IT / Dev) to offer technical resolutions and translate requirements into applications • Responsible for the development of a Junior Business Analyst and sharing the Best Practices with other AnalystsAchievements• Reduced preparation time of the Monthly Dashboards by 50% by standardizing and automating• Creating new SharePoint site for NSW contracts that helps business to maintain data integrity, less manual adjustment needed• Automated B2B reporting that can reduce administrative workload of contract managers, free up 1 day per month• Creating scenario analysis for different contracts that helps management to choose more profitable options Show less
-
-
Business Analyst
-
Jul 2016 - Jul 2017
-
-
-
-
Financial Planning Analyst
-
Apr 2015 - Jan 2016
Key responsibilities• Consolidation of 3 countries and local currencies into USD • Analysis and forecasting for a 140m USD sales regional P&L with 5 different business groups• Operating and strategic planning involvement with key business partners• Support management decision making to reach profitable growth and achieve given targets• Process and system harmonization, best practice implementation from regional networks• Foster collaboration among Divisions and Business Units to reach financial expectations• Several CEE regional project involvement on COGS and OPEX improvement• Business Partnering for Consumer Business Group and Human Resources• Key member of the Employee Engagement Team (6 person), responsible for corporate sport activitiesAchievements• Created standard reporting structure achieved 20% more accurate monthly forecast • Leading a group of 3 analysts, distributing workload based on individual improvement needs• Recognised as a key member in the internal communication team responsible for communication enhancement between countries and Business Units • Productivity improvement by 9% based on newly implemented OPEX analysis and strategy • Consumer Business Group met and exceeded yearly local currency goals by double digit growth and USD profitability rate of 15% using insights on portfolio structure• First point of contact from Finance for the CEEMEA regional leadership, CFO had more time to focus on strategy execution Show less
-
-
Business Analyst
-
Apr 2012 - Apr 2015
Key responsibilities• Daily/Weekly/Monthly report creation based on Month End Closing results• Data analysis from customer and product portfolio point of view• Data cleansing and manipulation from different CRM systems• Support management, sales and marketing people to achieve outstanding results• Be the first point of contact for internal customers from Finance department• P&L analysis from Sales to Profit for Industrial and Consumer Business groups• Process developments, best practice implementation and sharing• Regional project involvement on Sales and COGS reporting• Key member of the Employee Engagement Team (3 person), responsible for corporate sport and out of office activitiesAchievements• Creating a completely new reporting structure for 3M Hungary from the grounds, based on business leaders’ needs• Mapping different CRM systems’ data to be able to create valuable insights to business • Reducing COGS by 2-5% using product portfolio pricing strategies• Training for non-finance colleagues on P&L reading and Excel, PowerPoint use on a quarterly basis• Employee of the year in 2013, voted by supervisors and management operating committee• Standardized reporting structure reduced monthly forecasting time by 2 days• Involving new technologies (like cloud computing) in the way how finance communicate with business• Support Finance team to improve productivity by organising MS Office related trainings• Became the face of Finance Team within organization, and be the first point of contact for questions like Sales and COGS analysis, OPEX planning, AR-Customer analysis• Industrial and Consumer Business Groups grew sales by double digit and increased profit ratio year by year Show less
-
-
-
PwC
-
Professional Services
-
700 & Above Employee
-
Consultant - Indirect Taxes
-
Feb 2011 - Apr 2012
Key responsibilities • Tax consultancy for large and multinational companies on indirect taxes • Tax compliance in connection with VAT/GST • Tax advisory on environment related fees for Hungarian companies • Specialized in Duties and VAT/GST, and product classification (TARIC coding) Achievements • Responsible for Authorised Economic Operator projects, all customers are certified • Took part in all internal trainings on Hungarian taxes (PwC Tax Academy), finished with great results • Responsible for environment protection related taxes and fees • Attended PwC CSR programs as a key team member Show less
-
-
-
-
Tax Intern
-
Sep 2010 - Dec 2010
Key responsibilities • Tax consultancy for large and multinational companies on indirect taxes • Tax compliance in connection with VAT/GST • Tax advisory on environment related fees for Hungarian companies • Specialized in Duties and VAT/GST, and product classification (TARIC coding) Achievements • Responsible for Authorised Economic Operator projects, all customers are certified • Took part in all internal trainings on Hungarian taxes (PwC Tax Academy), finished with great results • Responsible for environment protection related taxes and fees • Attended PwC CSR programs as a key team member Show less
-
-
Education
-
2011 - 2013
Budapest Business School
MsC, Finance -
2016 - 2016
Australian Pacific College
Certificate IV, Project Management -
2007 - 2011
Budapest Business School
BsC, Economics and Management
Community
