Analyst

Uchazeč je analytik controllingu lidských zdrojů s rozsáhlými zkušenostmi v oblasti analýzy dat a reportingu. Má silné zázemí ve statistických metodách a rozhodování pro manažery. Kandidát pracoval pro různé společnosti, včetně MOL GBS Slovakia, IPTIQ by Swiss Re a Piano Software, kde byl zodpovědný za analýzu dat, vytváření reportů a provádění srovnávacích studií. Je vysoce kvalifikovaný v používání aplikací Excel, VBA, SQL a dalších softwarových nástrojů pro manipulaci s daty a tvorbu zpráv. Kandidát hovoří plynně německy a anglicky a má vynikající analytické, logické a prezentační schopnosti. Má také zkušenosti se školením a vedením kurzů v programech Excel a 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.