I have substantial experience in data analysis and reporting. My skill set encompasses the ability to analyze both financial and business data, coupled with expertise in MS Excel for data manipulation and analysis. Currently I also use Python scripts in Jupyter Notebooks to analyze data.I'm proficient in using SQL to extract and prepare data for comprehensive analysis and excel in creating clear and visually appealing data visualizations. Additionally, I specialize in identifying root causes behind shifts in Key Performance Indicators (KPIs) and am well-versed in visualization and reporting tools like Power BI and Apache Superset.Collaboration with data warehouse teams to ensure data quality and optimize storage is another aspect of my professional background. Furthermore, I have managed a Javascript ETL repository for daily data loading.In addition, I have managed small teams of data analysts (3-6), providing mentorship, fostering their growth, and assisting in resolving their everyday challenges, illustrating my hands-on approach to team leadership and data analysis.
-
Senior Data AnalystCofidis SlovakiaBratislava, Sk
-
Data AnalystMobilyze Nov 2023 - PresentBratislava, Slovakia⭐ created Power BI reports for customers to show the status of the market and analyze their performance⭐ used Jupyter Notebooks to load, transform and analyze data -
Financial Planning And Analysis ManagerVacuumlabs Jun 2021 - Jul 2023Bratislava, Slovakia🎯 led a team of analysts delivering financial planning, forecasting, revenue predictions, budgeting, controlling, cash flow impacts, hiring and sales pipeline predictions🎯 managed a Javascript ETL loader to get up-to-date data and visualize it using Apache Superset and PowerBI in appealing and easy-to-read dashboards -
Data Analyses Team Lead And Data EngineerO2 Slovakia May 2014 - May 2021Bratislava, Slovakia🔋 led a team of analysts, deepened theirs and company's understanding of data, looked for new data sources to enrich customer knowledge, combined data from various parts of company🔋 executive board presentations, keeping a close watch on financial and business KPIs using Power BI dashboards, finding and explaining root causes of upward/downward trends🔋 translated business needs to the IT and DWH teams, cooperating closely with all sides for data to be both stored efficiently and ready to be used by business users in their desired manner🔋 aided Data Engineers in creating data structure and make ETLs and business usage more efficient -
Data Analyst At Marketing DepartmentO2 Slovakia Nov 2009 - May 2014Bratislava, Slovakia✔️ used SQL to fetch, transform and aggregate financial, sales, mobile network and other business data from database✔️ played with data mostly using MS Excel✔️ created easy to read graphs and data visualisations
-
ConsultantErnst & Young Aug 2007 - Oct 2009Bratislava, SlovakiaIT security audits juniorFinancial and accounting data analyses
Viktor Franek Education Details
-
Management Information Systems And Services
Frequently Asked Questions about Viktor Franek
What company does Viktor Franek work for?
Viktor Franek works for Cofidis Slovakia
What is Viktor Franek's role at the current company?
Viktor Franek's current role is Senior Data Analyst.
What schools did Viktor Franek attend?
Viktor Franek attended Univerzita Komenského V Bratislave.
Not the Viktor Franek you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial