Xinyi Ruan

About Xinyi Ruan

I am a data-driven analyst with cross-disciplinary training in social data analytics (M.S, Brown University, 2025) and statistics (M.A, Columbia University, 2024), with a strong foundation in financial mathematics and statistics from UC Santa Barbara. My academic and professional journey centers on transforming complex datasets into actionable insights that inform strategy, reduce inefficiencies, and support high-stakes decision-making.In my internships at Maxima Value Consortia and Beryl Consulting Group, I developed dashboards and predictive models that clarified investment portfolio performance, optimized data pipelines, and produced macroeconomic analyses on topics such as supply chain disruption and U.S.–China trade dynamics. Previously, at Haitong Securities and Huatai United Securities, I supported IPO readiness by structuring due diligence frameworks, reconciling financial schedules, and producing industry risk analyses that streamlined filings and informed client strategy.Beyond industry, I have led academic research projects, including an LA crime study that integrated SQL-based public datasets, applied time-series and NLP techniques, and visualized results through Python and geospatial mapping to communicate pandemic-era shifts in crime.I am proficient in SQL, Python, R, MATLAB, SAS, Power BI, Tableau, and Excel, and bring a track record of combining quantitative rigor with clear communication to deliver insights across finance, policy, and business domains. My goal is to bridge data science and real-world decision-making, helping organizations clarify performance drivers, anticipate risks, and improve decision speed.

Experience

1. Data Analyst Intern

   The Beryl Consulting Group Llc

   Aug 2025 — Present

   Financial Data Research: Conducted data-driven research on market trends, industry benchmarks, and financial analytics, particularly an outline on US-China supply chain disruption, tariffs, and AI, to inform client advisory projects.• Large-Scale Data Analysis: Analyzed complex datasets to uncover patterns, correlations, and anomalies, producing a report on 10-year US Treasury bond yield trends that supported macroeconomic risk assessment.• Predictive Modeling: Developed and tested statistical models in Python to forecast outcomes and optimize advisory strategies, improving data-backed recommendations.

Education

• Brown University

  Master of Science - MS, Social Data Analytics

• St. John Paul II School

  High School Diploma

• Columbia University

  Master's degree, Statistic

• UC Santa Barbara

  Bachelor of Science - BS, Financial Math and Stats