Work History
Education
Skills
Languages
Leadership & Extracurriculars
Timeline
Awards
Generic

Xuhaoran Duan

Milsons point,NSW

Work History

New York Real Estate Data Analysis (Course Project

University of Sydney
10.2024 - 11.2024
  • Cleaned and pre-processed large-scale property transaction data in R to ensure data integrity and reliability.
  • Built multiple linear regression models to identify key drivers of housing prices.
  • Applied variable selection techniques (stepwise, backward/forward) to refine models and improve predictive performance.
  • Produced an HTML report using R Markdown, effectively communicating findings and investment insights to a non-technical audience.

Data Analyst — Stock Time Series Forecasting

09.2024 - 10.2024
  • Conducted time series stationarity tests and applied ARIMA models on TCL stock price data.
  • Assessed model performance and identified the limitations of ARIMA forecasting for financial data.
  • Suggested alternative modeling approaches (e.g., machine learning models) to improve predictive accuracy.
  • Delivered a technical report summarizing methodology, evaluation results, and recommendations.

Education

Bachelor of Liberal Arts and Science - Financial Mathematics & Statistics

University of Sydney
01.2026

Skills

  • Programming & Tools: R, Python, SQL, Excel

  • Data Manipulation & Analysis: Proficient in Excel (formulas, pivot tables, Power Query, Power Pivot), Python (pandas, numpy), R, and strong foundation in statistics (hypothesis testing, regression, significance testing)

  • Database Management: Strong SQL skills for querying, cleaning, and optimizing large datasets; familiar with data warehouse concepts and data modeling

  • Data Visualization: Skilled in building dashboards and visualizations using R(GGplot) and Tableau

  • Statistical Modeling & Machine Learning: Knowledge of regression, classification, clustering, and time series forecasting; experienced in model evaluation and feature engineering

Languages

English (Fluent, IELTS 7.0), Mandarin (Native)

Leadership & Extracurriculars

Football Referee, Eastern Suburbs Football Association (ESFA) Officiated competitive matches; demonstrated leadership, decision-making, and conflict resolution skills.

Timeline

New York Real Estate Data Analysis (Course Project

University of Sydney
10.2024 - 11.2024

Data Analyst — Stock Time Series Forecasting

09.2024 - 10.2024

Bachelor of Liberal Arts and Science - Financial Mathematics & Statistics

University of Sydney

Awards

- IELTS (Overall 7.0), - Australian Football Referee (ESFA Certified), - National Second-Level Athlete in Sprinting (China) – Recognized for high-level athletic performance and discipline

Similar Profiles

CREATE PROFILE
Xuhaoran Duan