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.
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Language
English
Fluent
Work Experience
Capstone Project at Here Technologies
March 1, 2025 - November 4, 2025Designed 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, 2025Engineered 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, 2023Processed 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, 2022Integrated 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, 2025Extracted 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, 2025BS in Mathematics & BS in Statistics and Analytics at The University of North Carolina at Chapel Hill
August 1, 2021 - May 1, 2024MS in Applied Data Science at The University of Chicago
September 1, 2024 - December 1, 2025BS in Mathematics & BS in Statistics and Analytics at The University of North Carolina at Chapel Hill
August 1, 2021 - May 1, 2024Qualifications
Industry Experience
Software & Internet, Professional Services, Healthcare, Financial Services, Transportation & Logistics
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Hire a Data Scientist
We have the best data scientist experts on Twine. Hire a data scientist in Chicago today.