Business Analyst / Data Analyst / Project Manager (Junior/Internship)

RENTING XUE

646-***-**** ******@********.*** linkedin.com/in/renting-rosalie-xue

EDUCATION

Columbia University New York, NY

M.S. in Operations Research Sep 2024 - Dec 2025

• Business Analytics, Data Analytics (Web Scraping, Data Analysis & Visualization, Text Mining, Analysis of Networks, Machine Learning), Corporate Finance, Accounting & Investment Banking, Stochastic Model, Simulation, Optimization Models

University of Liverpool Liverpool, UK

B.S. in Mathematics. GPA: 77% (3.8/4). First Class Honour. Sep 2022 - May 2024

• Statistics, Financial Mathematics, Medical Statistics, Mathematical Biology, Networks, Game Theory

Xi'an Jiaotong-Liverpool University Suzhou, CN

B.S. in Applied Mathematics. GPA: 72%. First Class Honour. Sep 2020 - Jun 2022

INTERNSHIP EXPERIENCE

Trovares (Remote) New York, NY

Data Scientist Intern Sep 2024 - Dec 2024

• Developed an insurance fraud detection system leveraging machine learning models (LLM, KNN, logistic regression) with Cypher, xGT, and Python, trained on representative US health insurance fraud data.

• Visualized key patterns using interactive dashboards and dynamic visualizations within xGT and Python.

• Employed xGT to analyze extensive insurance fraud and healthcare data, uncovering metrics and patterns to refine health insurance policies and patient grouping strategies, enhancing Trovares' fraud detection and prevention capabilities.

His Majesty's Revenue and Customs (HMRC) Liverpool, UK Strategy Analyst Intern Nov 2023 - Dec 2023

• Developed a predictive model for UK alcohol consumption trends using R, trained with time-series data, creating 10+ scenarios to test the robustness and refine the model.

• Analyzed the impact of alcohol taxation on retail, society, and government revenue through model simulations and industry research.

• Led the composition of report and presentation with strategy choices and potential risks for government action.

The Very Group Liverpool, UK

Business Analyst Intern Sep 2023 - Nov 2023

• Analyzed 7.2 MB datasets, selecting 15+ parameters and visualized them over time using R and Excel.

• Identified 5 key dimensions with notable trends to assess changes in customer behavior during the pandemic.

• Led the composition of a report recommendation to enhance business structure and mitigate risks, based on an analysis of sales variations across products and changes in annual transactions and payment methods.

Dun & Bradstreet China Shanghai, CN

Data Analyst Intern Jan 2022 - Mar 2022

• Modified some parts of D&B’s analytical model with Microsoft Access and Excel to suit the dataset given. Processed and analyzed hundreds of customer datasets, improving the efficiency of the model.

• Double-checked the robustness of the model by tracing and detecting abnormal data and collaboration.

• Delivered accurate datasets and boosted the analysis of the customers' commercial creditworthiness.

RESEARCH EXPERIENCE

“Data-Driven Insights into NYC Uber & Taxi Ride Trends (2020-2024)" (at Columbia University) New York, NY Data Engineer & Analyst Oct 2024 - Dec 2024

• Developed a scalable data pipeline to process 50M+ ride records from NYC Taxi & Uber, utilizing Python, SQL, and Pandas, reducing data size by 80% and normalizing the datasets according to future usage for efficient analysis.

• Designed and optimized multiple SQL queries to store data and extract ride trends, including hourly demand patterns, weather impact on rides, and revenue analysis, improving query efficiency by 30%.

• Created interactive visualizations using Matplotlib & Geopandas, illustrating trends such as peak ride times, airport drop-off frequencies, and ride heatmaps, enhancing data storytelling. Received almost full mark for this project, way higher than average grades.

SKILLS

Python, SQL, Numpy, Matplotlib, Geopandas, Machine Learning, JavaScript, R Studio, Microsoft Access, Microsoft Excel, PowerPoint

Contact this candidate