Skip to content
View selina-bian-1122's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report selina-bian-1122

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
selina-bian-1122/README.md

Hi, This is Selina Bian! 👋

  • 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

🧑‍💼 Professional Experience

  • 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%.


📊 Key Projects

  • 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%.


🎓 Education

  • 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

🏉 Leadership & Organizations

  • 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

💼 Skills

  • 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

Pinned Loading

  1. FinAgent_GraphRAG FinAgent_GraphRAG Public

    Forked from YuwenAprilYang/FinAgent

    Jupyter Notebook 1

  2. CruzHacksDentist_PoweredByLLM CruzHacksDentist_PoweredByLLM Public

    A Web Application with information gathering and chatbot functions, leveraging API, LLM and vibe coding tool

    JavaScript 2

  3. Vocabulary-built-on-Interest Vocabulary-built-on-Interest Public

    Forked from CillianW/Vocabulary-built-on-Interest

    A web application that helps you learn new vocabulary by generating word cards with meanings, examples, audio pronunciations, and images, then automatically adding them to Anki.

    Python 1

  4. telegram-voice telegram-voice Public

    A Streamlit application for recording, transcribing, and organizing voice notes with tags.

    Python 1

  5. Game_Recommendation_System Game_Recommendation_System Public

    A Recommendation System based on Sentimental Analysis and Neural Collaborative Filtering for STEAM Gamers

    1

  6. Hotel-Cancellation-Prediction Hotel-Cancellation-Prediction Public

    Predict Hotel Cancellation and Tackle Overbooking Issues

    1