Hi, I’m Yuanchi Guo, a data analyst with strong Python, SQL, and BI skills. I specialize in extracting, validating, and visualizing complex datasets, automating reporting workflows, and building forecasting dashboards to drive data-informed decisions. I enjoy translating data insights into actionable business recommendations and collaborating with cross-functional teams to deliver reliable analytics solutions.

Yuanchi Guo

Hi, I’m Yuanchi Guo, a data analyst with strong Python, SQL, and BI skills. I specialize in extracting, validating, and visualizing complex datasets, automating reporting workflows, and building forecasting dashboards to drive data-informed decisions. I enjoy translating data insights into actionable business recommendations and collaborating with cross-functional teams to deliver reliable analytics solutions.

Available to hire

Hi, I’m Yuanchi Guo, a data analyst with strong Python, SQL, and BI skills. I specialize in extracting, validating, and visualizing complex datasets, automating reporting workflows, and building forecasting dashboards to drive data-informed decisions.

I enjoy translating data insights into actionable business recommendations and collaborating with cross-functional teams to deliver reliable analytics solutions.

See more

Language

English
Fluent

Work Experience

Capstone Project at Here Technologies
March 1, 2025 - November 4, 2025
Designed a 3D alignment model integrating Iterative Closest Point (ICP) and feature-based matching, achieving RMSE < 0.01 across 14 map tiles for downstream autonomous driving analytics. Built and tested a Graph Neural Network leveraging geometric and topological features to improve spatial matching and prediction accuracy. Enhanced spatial preprocessing and feature extraction from point cloud data through densification and interpolation, improving geometric consistency and model readiness for large-scale automation.
Data Scientist Intern at Cmind Inc
September 1, 2025 - September 1, 2025
Engineered automated data preprocessing pipelines in Python and SQL to integrate 10K+ weekly stock datasets, reducing manual effort by 40% and producing high-quality training data. Analyzed multi-dimensional financial datasets using Python (Plotly) and Tableau to uncover short-term performance patterns, anomalies, and correlations, supporting data quality improvement and investment analytics. Standardized data workflows with automated validation and consistency checks, enabling reproducible analytics. Collaborated on NLP preprocessing and data validation workflows across 1,000+ CEO/CFO transcripts, improving data consistency and feature quality. Fine-tuned GPT-based transformer models on earnings call transcripts to extract sentiment and evasiveness embeddings, integrating into a predictive framework for post-earnings stock movement with a 9% performance gain.
Data Scientist Intern, Air Ticketing Department at Ctrip.com
July 1, 2023 - July 1, 2023
Processed and standardized 1M+ flight timestamp records from multiple data sources using Python-based anomaly detection and time-series preprocessing to improve data integrity and feature consistency. Trained logistic regression and decision tree models to evaluate source accuracy, then developed a dynamic weighting algorithm to combine predictions and improve overall arrival-time forecast accuracy by 8%. Visualized prediction errors and discrepancies across data sources, revealing reliability patterns that informed weighting adjustments and data-quality improvements presented to the analytics team.
Data Analyst Intern at Wangding (Chengdu) Technology Ltd.
July 1, 2022 - July 1, 2022
Integrated and cleaned multi-hospital healthcare data using SQL and Python preprocessing, generating standardized datasets for modeling and analysis. Applied PCA for dimensionality reduction and risk stratification, visualizing outcomes in Power BI dashboards for 5,000+ patients to assist clinicians in early diagnosis and intervention planning.
Data Analyst Intern at Cmind Inc
September 1, 2025 - September 1, 2025
Extracted and integrated 10K+ weekly updated stock records from multiple MongoDB databases using Python and SQL, automating data ingestion and cleaning for downstream analytics. Automated Excel and Power BI reporting workflows, reducing manual preparation time by 40% and ensuring consistent, validated datasets for weekly performance reviews. Built Tableau dashboards to visualize stock performance trends across sectors, market cap groups, and time periods, enhancing data accuracy and accessibility for trend analysis. Worked with a technical teammate to refine data preparation and validation processes, improving the timeliness and reliability of weekly reporting. Summarized analytical findings and market insights in weekly newsletters and internal reports, supporting data-driven decision-making.

Education

MS in Applied Data Science at The University of Chicago
September 1, 2024 - December 1, 2025
BS in Mathematics & BS in Statistics and Analytics at The University of North Carolina at Chapel Hill
August 1, 2021 - May 1, 2024
MS in Applied Data Science at The University of Chicago
September 1, 2024 - December 1, 2025
BS in Mathematics & BS in Statistics and Analytics at The University of North Carolina at Chapel Hill
August 1, 2021 - May 1, 2024

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Professional Services, Healthcare, Financial Services, Transportation & Logistics