Analyst

Der Kandidat ist ein HR Controlling Analyst mit umfassender Erfahrung in der Datenanalyse und im Reporting. Er verfügt über einen fundierten Hintergrund in statistischen Methoden und Entscheidungsfindung für Manager. Der Kandidat hat für verschiedene Unternehmen gearbeitet, darunter MOL GBS Slovakia, IPTIQ by Swiss Re und Piano Software, wo er für die Analyse von Daten, die Erstellung von Berichten und die Durchführung von Benchmark-Studien verantwortlich war. Er ist sehr versiert im Umgang mit Excel, VBA, SQL und anderen Softwaretools zur Datenmanipulation und Berichterstellung. Der Kandidat spricht fließend Deutsch und Englisch und verfügt über ausgezeichnete analytische, logische und Präsentationsfähigkeiten. Er hat auch Erfahrung in der Schulung und Leitung von Kursen in Excel und 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.