- Enthusiastic about leveraging data and LLM for actionable business insights and solutions
- Solution Engineer and GTM at AI Startups
- Ex-Intern at Budweiser & TikTok & BCG
- MS in Business Analytics @ UC Davis
- Contact me via yingxuanbian1122@gmail.com
-
LiveX AI, AI Solution Engineer (Palo Alto, CA, Aug 2025-Dec 2025)
Architected multimodal and LLM-powered customer-support and churn control agents, built orchestration logic and API integrations, and led end-to-end deployment across chat, voice, and backend systems. -
Alexander Tutoring & Andromeda, AI Data Scientist (San Francisco, CA, Aug 2024–Jun 2025)
Developed a churn prediction model and a star tutoring evaluation model using Python, PCA, and random forest to enhance accuracy, while also applying RAG and LLMs to extract actionable insights from tutorial session data. -
OSCR AI, Market Analyst Intern (San Francisco, CA, Nov 2024–Feb 2025)
Conduct market research and competitive analysis to refine the product-market fit for a content marketing SaaS product, and collaborate on growth strategies that have generated 80+ leads. -
Budweiser Asia Pacific, Trade Marketing Summer Intern (Shanghai, China, Jul 2023–Sep 2023)
Led the creation of an information-sharing platform and built 20 Power BI dashboards that reduced analysis time by nearly 50%, and optimized a coupon distribution system via advanced Excel analysis to save 34% in costs. -
Boston Consulting Group, Business Analyst Intern (Remote, Aug 2022–May 2023)
Conducted revenue data analysis across four projects using Excel, delivering actionable benchmarking insights and creating 20+ charts and workflow diagrams that supported strategic decision-making. -
Una Brands Capital, Industry Analyst Intern (Shenzhen, China, Dec 2021–May 2022)
Developed research frameworks with Excel and web crawling to analyze Chinese sellers on Amazon and provide strategic project recommendations, while converting 12% of 1K potential sellers into actionable leads. -
ZhongAn Insurance, Platform Product Manager Intern (Shanghai, China, Dec 2021–Feb 2022)
Analyzed competitor designs and produced 5 PRDs to guide product revisions, coordinating with business leaders to resolve over 50 issues, and conducted A/B testing that boosted link click rates by 34% and page visits by 28%.
-
Finance GraphRAG Engine (Apr 2025–May 2025) Engineered a Python-based RAG pipeline that converts SEC 10-K filings into a Neo4j knowledge graph and uses LangChain + OpenAI to power financial Q&A, with a Streamlit interface for rapid prototyping.
-
E-commerce Customer Churn Prediction & Segmentation ML Project (Jan 2025–Mar 2025) Built an XGBoost model with 98% recall using SMOTE and 20+ engineered features, and segmented users via K-Means and RFM to drive targeted retention strategies projected to reduce churn by 35%.
-
Airbnb New User Analysis Data Management Project (Oct 2024–Dec 2024)
Designed and implemented a SQL-based data pipeline to integrate and clean 1M+ records across five datasets, and conducted EDA to improve booking predictions by 20%. -
Recommendation System Based on Steam User Comments (Oct 2023–Dec 2023)
Performed sentiment analysis on comments from 25K users across 3K games and developed a Collaborative Filtering Model using Factorization Machine and DNN to address the cold start problem. -
Hotel Prediction Business Analytics Project (Mar 2023–May 2023)
Selected variables using Step AIC and PCA to predict cancellations with logistic regression and time series methods, and design incentive mechanisms and an overbooking solution. -
Loan Default Prediction Project (Nov 2022–Dec 2022)
Analyzed Lending Club data using various ML techniques to predict loan defaults, ultimately identifying Random Forest as the most effective model with an AUC of 71%.
- University of California Davis, MS in Business Analytics
Aug 2024 - July 2025 - The Chinese University of Hong Kong, BBA in Applied Economics
Sep 2020 - May 2024 - University of Notre Dame, Exchange Semester
Jan 2023 - May 2023
- Podcaster (~5.8K Subscription, 50K+ Listens)
- Vice President of Cooking Pioneer Club
- Student Assistant for Center of Innovation and Entrepreneurship
- Member of Peer Psychological Counseling Team
- Programming & Tools: Python, SQL, R, AWS, GCP, PySpark, Kafka, Shell, Git, Stata, dbt, Databricks, MongoDB, Confluence, Jira
- Analytics: Power BI, Tableau, ETL, MS Excel, A/B Testing, Statistical Analysis, Data Visualization, Exploratory Data Analysis, Data Mining & Manipulation, Machine Learning, Deep Learning, LLM application (RAG, MCP, API), Prompt Engineering


