BI Analyst
Overview
Short Summary
The candidate is a Business Intelligence Analyst with experience in investment banking, energy sector, financial and audit services. He has expertise in data analysis, creating data models, and developing dashboards using Microsoft Power BI. He has also worked as a Financial Controller and Power BI Specialist, where he prepared reports, budgets, and analyzed performance indicators. The candidate has a Master's degree in Management and a Bachelor's degree in Business Administration. He is fluent in English and has intermediate knowledge of German and basic knowledge of Chinese Mandarin. He has strong communication, presentation, and time-management skills. In his free time, he enjoys trading stocks, exploring Asian culture, and engaging in various sports and outdoor activities.
Work Experience
Business Intelligence Analyst | 01/22 - present | Company A
- Team leader of 2 back-end developers in the data warehouse team.
- Analyzing data and creating data models in the MS Azure ecosystem.
- Front-end developer specializing in creating various dashboards for management, sales, trading, operations, and finance departments.
- Responsible for monthly P&L evaluation for internal sales team and fees from various company products.
- Helped automate certain processes in the CRM system, saving the company 250k CZK in paid provisions.
- Calculating rewards for external investment intermediaries on a monthly and quarterly basis.
Linking business requirements with IT development, writing user stories, and supervising project priorities.
Financial Controller & Power BI Specialist | 02/21 - 01/22 | Company B
- Regular preparation of monthly, quarterly, and annual reports, budgets, and analyses.
- Created documents and presentations for the supervisory board and the board of directors.
- Prepared performance indicators and economic analysis of the long-term plan.
- Responsible for reporting for ENBW and presenting quarterly statements to the board of directors.
- Elaborated commentary on established long-term plans.
- Planned, analyzed, and managed agendas for the services department.
- Transformed old databases used in MS Excel into Power BI.
Prepared dashboards and reports in Power BI for various segments of the company.
Junior Audit Consultant | 09/17 - 12/19 | Company C
- Worked on audits in the automotive, manufacturing, and banking sectors.
- Responsible for multiple sections and deadlines for reporting.
- Utilized MS Excel extensively and handled set workloads.
- Conducted audits independently on understaffed clients.
Communicated with clients, obtained documents, and conducted financial analysis.
Graduate Research Assistant | 07/17 - 07/18 | Company D
Conducted presentations and analytical research on various macroeconomic topics.
Administrative Assistant and Back Office Support | 06/14 - 09/14 | Company E
Handled paperwork, communication, and collaboration with various business departments.
Master's Degree in Management | 09/18 - 01/21 | University F
- Equis accredited program with a GPA of 3.73.
Specialized in entrepreneurship and innovations.
Exchange Semester at National Taiwan University | 02/20 - 08/20 | University G
Enrolled at the College of Management with a GPA of 3.6.
Bachelor's Degree in Business Administration | 09/14 - 05/18 | University H
Equis accredited program with a GPA of 3.67.
Portfolio Analyst/Trader | 12/19 - present | Company I
- Actively trading and finding opportunities in undervalued companies in the stock market.
- Developing strategies to limit risk within trades.
Conducting technical and fundamental analysis on various companies.
Entrepreneurship Project Competition (3rd place) | 09/19 - 12/19 | University F
- Worked in a multinational team to identify potential entry opportunities into the Czech market.
- Prepared qualitative research, elevator speech, and business plan.
Presented the project to various investors and business angels.
Rent Me With Ease, MBA Business Project | 02/20 - 06/20 | University G
- Worked in a multinational team to identify potential entry opportunities into the Taiwanese market.
- Developed ideas for potential entry opportunities into the Taiwanese market.