BI Analyst

Kandidát je analytik Business Intelligence se zkušenostmi z investičního bankovnictví, energetiky, finančních a auditorských služeb. Má zkušenosti s analýzou dat, vytvářením datových modelů a tvorbou ovládacích panelů pomocí Microsoft Power BI. Pracoval také jako finanční kontrolor a specialista Power BI, kde připravoval reporty, rozpočty a analyzoval ukazatele výkonnosti. Kandidát má magisterský titul v oboru managementu a bakalářský titul v oboru obchodní administrativy. Hovoří plynně anglicky a má středně pokročilou znalost němčiny a základní znalost čínské mandarínštiny. Má dobré komunikační, prezentační a časové dovednosti. Ve volném čase rád obchoduje s akciemi, poznává asijskou kulturu a věnuje se různým sportovním a outdoorovým aktivitám.

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.