YUNFEI WU
Canberra,ACT
Summary
A highly motivated and detail-oriented professional with a solid theoretical foundation and extensive work experience in data analysis and market research, resilient and flexible, proficient in SQL, PYTHON, and QuickSight; A team player with strong coordination and project management skills, meticulous and detail-oriented with an analytic and organized mind, equipped with fluent verbal and written communication skills in English and Mandarin.
Overview
4
4
years of professional experience
Work History
Financial Analyst
University of Canberra
11.2023 - Current
- Data Analysis: Collected, analyzed, and modeled data to conduct annual unit costing analysis; Leveraged SQL, Python, and Excel to extract and process complex data, customizing reports to meet stakeholder needs and creating dashboards with Power BI and Tableau to enhance data accessibility.
- Dashboard Development: Developed visual dashboards to identify profitable and loss-making units and calculated break-even points for each unit/program, supporting faculty in optimizing teaching plans for the upcoming year.
- Financial Planning: Utilized forecasting models to lead the annual student load planning and forecasting process, projecting metrics such as commencing student headcount, EFTSL, and revenue. Provided financial analysis for the DVCA department to support decisions on launching new courses and setting performance targets.
- Strategic Reporting: Compiled bi-weekly SLAM (Student Load Action and Monitoring) reports to senior management, comparing current enrollment trends with past data, offering insights that supported strategic decisions on enrollment targets and market strategies.
- Compliance Reporting: Worked with government education agencies to prepare and clarify required reports; Coordinated with Deloitte, EY audit teams, and finance staff to extract and deliver required data reports for audits.
- Model Development: Collaborated with the Data team to design and develop an internal Load Plan Forecast Model, overseeing model flow and calculation logic to improve forecast accuracy.
- Cross-functional Collaboration: Actively engaged with third-party vendors and various internal departments to refine forecasting models and data collection processes, enhancing analytical precision.
Data Analyst
Zero Markets
05.2020 - 05.2023
- System Development: Collected and organized the development requirements from various departments, developed systems with the IT department, and adjusted and optimized the system according to the feedback; assisted in designing and developing a campaign portal, so as to facilitate marketing personnel to view marketing data conveniently
- Data Processing & Analysis: Participated in diverse marketing projects of the company, performed marketing data collection, summarized the most effective advertising channels through data analysis and generated corresponding reports; extracted the company's core revenue data using SQL and PYTHON, and made a Dashboard with QuickSight for managers to monitor monthly/annual revenue and develop KPIs; designed A/B test, interpreted and analyzed the test data, tracked the whole process, and output the test result document of A/B test
- Cross-department Cooperation: Worked closely with the business department to fully understand the data analysis requirements based on business scenarios, adjusted the dimensions of data reports, provided comprehensive data support for business departments, generated customized reports and presented data with QuickSight or Tableau as required
- Customer Research: Monitored and analyzed the browsing tracks of customers on the company website to find out preferences(Login time, product content) of customers in different countries, proposed suggestions on website and advertisement modification to the development department and marketing department
- Technical Support: Used hubspot to help overseas teams (Brazil/Korea) design and launch workflow, and successfully conduct secondary marketing to customers
- Regular Presentation: Delivered reports and presentations to the team members and company stakeholders to propose business insights, report marketing campaign results and present product optimization suggestions.
Education
Master of Commerce - Big Data & Finance
University of Sydney
Australia12.2019
Bachelor of Business Administration -
Jiangnan University
China06.2017
Skills
- Technical: SQL, Python, AWS, Tableau, SPSS, Power BI, Microsoft Office Suite
- Professional Qualities: flexibility, resilience, communication, coordination and project management skills
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Financial Analyst
University of Canberra
11.2023 - Current
Data Analyst
Zero Markets
05.2020 - 05.2023
Master of Commerce - Big Data & Finance
University of Sydney
Bachelor of Business Administration -
Jiangnan University
Similar Profiles
Traci WardTraci Ward
Executive Assistant to Director/Office Manager at University of CanberraExecutive Assistant to Director/Office Manager at University of Canberra
Jonathan WardJonathan Ward
Business Development Manager – Health Research Institute at University of CanberraBusiness Development Manager – Health Research Institute at University of Canberra
Takumi Daniel KonnoTakumi Daniel Konno
Manager for Middle East and North Asia at University of CanberraManager for Middle East and North Asia at University of Canberra