data science, data storytelling, web development

Yufei Song

412-***-**** *************@*******.*** LinkedIn

EDUCATION

Carnegie Mellon University Pittsburgh, PA

M.S. in Information Systems Management GPA: 3.81 December 2025 Coursework: Distributed Systems, Time Series, Database Management, Machine Learning, Operations Research, Statistics University of Surrey - Surrey International Institute Dalian, China B.S. in Accounting and Finance GPA: 3.72 June 2024 Relevant Coursework: Python, R, Calculus, Linear Algebra, Statistics and Probabilities, Data Mining, Data Visualization SKILLS

Languages: Python (NumPy, Pandas, Matplotlib), Java, SQL, R, HTML, CSS Framework, & tools: Oracle Database, Git, Hadoop, Spark, Scikit-learn, MongoDB, Tableau, PowerBI, SPSS, Figma, Excel EXPERIENCE

Workshop Director CMU Data Science Club Apr. 2025 - Present Pittsburgh, PA Planned and led technical workshops on data science topics Presented and broadcasted engaging workshops to audiences across CMU and nationwide, reaching hundreds of participants Collaborate with departments and other clubs for joint workshops Strategy Intern, Platform Solutions Publicis Groupe Apr. 2024 - Jul. 2024 Shanghai, China Conducted data analysis and automation of market research and performance data on regular basis for top-tier clients Analyzed and visualized user behaviors data across social platforms to identify solutions and opportunities, delivered insights Supported cross-functional collaboration by holding workshops Data Analyst Intern, Patient Recruitment Waterdrop Jul. 2023 - Aug. 2023 Beijing, China Collected clinical trial data using SQL and developed dashboards and implemented data automation streamline reports Monitored market metrics, KPIs and conversion rates across different projects, identified issues and provided solutions Implemented financial projection and future enrollment number forecasting PROJECTS

PetFinder android & web service development, dashboard building Mar. 2025 - Apr. 2025 Designed and built an Android app with a backend Java web service to help users find adoptable pets using customizable filters Built RESTful endpoints with Java Servlets to fetch data from the Petfinder API and return JSON responses to the Android client Integrated Retrofit and GSON on the Android side for seamless client-server communication, and displayed pet information Implemented MongoDB Atlas to store logging data for each user request and created a dashboard to visualize key analytics CMU Study Compass Time series analysis, app design Apr.2025 Designed a time-series analytics tool to help CMU students and advisors identify academic risks based on study behavior data Engineered forecasting pipelines using ARIMA, SARIMA models to predict trends from variables of study patterns Performed exploratory data analysis to uncover correlations and implemented backtesting to validate model accuracy Designed the application prototype to enhance the student experience with clear academic insights and actionable study feedback Education Platform User Behaviour Recommendation System Data analysis, user behaviour Dec. 2022 Processed user, course, and login data using Pandas; cleaned data and implemented feature extraction to improve model accuracy Analyzed and visualized user activity patterns with Matplotlib heatmaps and histograms to uncover usage trends Built an item-based collaborative filtering model to deliver personalized course recommendations Music Comment Sentiment Analysis Based on User Comments Machine learning, NLP Jan. 2023 Processed 5,000+ user comments in Python with tokenization and frequency analysis to extract features for sentiment classification Built a sentiment classifier using transfer learning and attention mechanisms to detect positive, negative, and neutral tones Enabled negative comment filtering and personalized content delivery to enhance user experience and platform insights Enterprise Management Database Engineering & Analysis Project SQL, data analysis, Oracle database Dec. 2025 Designed and built a relational database with ER models, normalized structures Executed SQL queries to analyze employee skills, project progress, and work-hour trends ACTIVITIES & AWARDS

3rd Place & Team Lead, 2024 CMU IronViz Challenge Oct. 2024 Pittsburgh, PA Member, Summer Institute in Computational Social Science - CMU May 2025 Pittsburgh, PA