Analyst

The candidate is an HR Controlling Analyst with extensive experience in data analysis and reporting. He has a strong background in statistical methods and decision making for managers. The candidate has worked for various companies, including MOL GBS Slovakia, IPTIQ by Swiss Re, and Piano Software, where he has been responsible for analyzing data, creating reports, and conducting benchmark studies. He is highly skilled in using Excel, VBA, SQL, and other software tools for data manipulation and reporting. The candidate is fluent in German and English and possesses excellent analytical, logical, and presentation skills. He is also experienced in training and leading courses in Excel and VBA.

04/2021 - Present: HR Controlling Analyst

• Responsible for creating and managing HC/FTE reporting for the entire Slovnaft Group.
• Calculation of monthly provision closings.
• Develop and analyze new reports and analysis related to FTE and PTE.
• Support HR and controlling business partners in FTE and PTE matters.
• Key contact and support in the planning process for FTEs in the business plan.
• Part of the PTE planning team for the creation of the 2022 business plan.
• Member of Slovnaft Internal Academy, leading Excel courses for employees.

12/2019 - 02/2020: Senior Business Analyst

• Provide technical leadership and best practices in designing and deploying complex data models and processes.
• Analyze and synthesize business requirements and conceptualize processes.
• Translate business and data requirements into data models.
• Lead partner workshops for data integration processes.
• Produce and document business and system requirements.
• Collaborate with developers to implement requirements.

03/2019 - 10/2019: Data Analyst

• Analyze revenue and usage data trends using SQL.
• Conduct benchmark studies using SQL.
• Create reports for existing and potential customers using SQL.
• Prepare reports on general findings and trends using SQL.
• Collaborate with internal and external partners to explain findings.

08/2018 - Present: Volunteer MS Excel Trainer

• Lead Excel classes for beginner and intermediate levels.

07/2017 - Present: Data and Reporting Analyst

• Responsible for regular reporting using Excel, VBA, and SQL.
• Programming VBA codes.
• Updating existing VBA macro programs.
• Creating and updating SQL queries.
• Trainer for Microsoft Excel and VBA macros for Amazon employees.
• Support colleagues with Excel and SQL problems/questions.

01/2016 - 05/2017: Financial Advisor

• Acquire new clients.
• Conduct financial analysis and create financial plans.
• Manage existing clients.

05/2011 - 06/2016: Senior Data Analyst

• Process data from market research studies for clients worldwide.
• Create analyses and reports using statistical software like SPSS or TOM/Dimensions.
• Develop and update VBA macros for specific client requests.
• Use MS Excel for data management and editing.
• Clean data to ensure accurate study results.

09/2010 - 04/2011: Account Manager

• Acquire new clients.
• Manage existing clients.
• Create and consult proposals for online advertising campaigns.

Languages:

• Fluent in German and English.

Computer Skills:

• Expert in MS Excel, including formulas and pivot tables.
• Advanced skills in VBA, including writing macros and tools.
• Advanced SQL skills for data manipulation and query writing.
• Intermediate skills in SAP for running queries and customizing reports.
• Intermediate skills in MS Power BI for updating and creating reports.
• Advanced skills in SPSS for data editing, cleaning, and analysis.
• Advanced skills in TOM/Dimensions for data editing and report creation.