Yue Dai

Yue Dai

Business Analyst Intern
United States of America

نبذة عني

Business analytics graduate with experience in data analysis, predictive modeling, ETL, and dashboard development across finance and business contexts. Skilled in Python, SQL, R, Tableau, Power BI, Databricks, PySpark, A…

الخبرة

Business Analyst Intern

Baynovation LLC., San Jose, US
Jun 2023 - Aug 2023 · 2 أشهر

Studied leading SEO keyword searching websites and developed fee models to determine suitable features for company websites.
Analyzed CEO-company search trends using Google Trend and identified correlations, market impact, and competitor effects.
Researched current refinance trends and key players and analyzed customer preferences through questionnaire insights.
Developed ML-driven model for optimal loan refinancing timing, integrated the model with a break-even analysis considering costs and profiles, and conducted thorough research on real estate finance to enhance the accuracy and effectiveness of the model.
Constructed and tested data pipeline and fully automated and interactive Tableau dashboards for internal stakeholders, enabling future research on product optimization.

Data Analyst Intern

Wisdom Capital, Vancouver, BC
Jan 2022 - Aug 2022 · 7 أشهر

Conducted statistical analysis, including Pearson's chi-squared test, and built predictive models, including Multinomial Logistic Regression, in Python to identify associations on financial data.
Conducted exploratory data analysis to understand patterns and trends in product popularity and the correlation between web traffic and orders over time using Python data visualization tools such as Matplotlib and Seaborn.
Led three interns and managed the team to conduct strategic and competitive analysis of Wisdom Capital and its competitors, including analyzing value chain, product interface, profitability, target customer groups, and overall industry trends and regulatory policies.

Data Analyst Intern

Giant Interactive Group, Shanghai, CN
Oct 2021 - Dec 2021 · 2 أشهر

Gathered and cleaned user engagement data in SQL, conducted EDA to define project scope, performed statistical analysis, created data visualizations, built and tested XGBoost and K-means model in Python to provide prediction of customer behavior, with over 90% AUC-ROC.
Designed and implemented ETL solutions with over 200GB of data.
Maintained data infrastructure including building over 40 data tables, reconstructed the databased structure, improving the query efficiency about 50%.
Conducted and analyzed 3 A/B testing experiments to evaluate operational efficiency improvement.

Financial Analyst Intern

Noah Private Wealth Management, Shanghai, CN
Jun 2021 - Sep 2021 · 3 أشهر

Performed SQL queries to build data collection, storage, and processing infrastructure.
Analyzed business problems and converted report data to actionable items; delivered simplified and visualized analytical outputs.
Collaborated closely with cross-functional product and engineering team to extract meaningful business insights and create targeted marketing strategies based on their risk-return preferences.
Established a data exchange ecosystem for customers and defined roles and responsibilities for each stakeholder group.
Created detailed workflows for 10 end-to-end business processes.
Improved operational efficiency by 5%.

Business Analyst Intern

Baynovation LLC, San Jose, US
Jun 2023 - Aug 2023 · 2 أشهر

Studied leading SEO keyword searching websites and developed fee models to determine suitable features for company websites
Analyzed CEO-company search trends using Google Trend and identified correlations, market impact and competitor effects
Researched current refinance trends and key players and analyzed customer preferences through questionnaire insights
Developed ML-driven model for optimal loan refinancing timing, integrated the model with a break-even analysis considering costs and profiles and conducted thorough research on real estate finance to enhance the accuracy and effectiveness of the model
Constructed and tested data pipeline and fully automated & interactive Tableau dashboards for internal stakeholders, enabling future research on product optimization

Data Analyst Intern

Wisdom Capital, Vancouver, BC
Jan 2022 - Aug 2022 · 7 أشهر

Conducted statistical analysis (e.g., Pearson's chi-squared test), built predictive models (e.g., Multinomial Logistic Regression) in python to identify associations on financial data
Conducted exploratory data analysis to understand patterns and trends in product popularity and the correlation between web traffic and orders over time using Python data visualization tools such as Matplotlib and Seaborn
Led three interns and managed the team to conduct strategic and competitive analysis of Wisdom Capital and its competitors, which including analyzing value chain, product interface, profitability, target customer groups and overall industry trends & regulatory policies

Data Analyst Intern

Giant Interactive Group, Shanghai, CN
Oct 2021 - Dec 2021 · 2 أشهر

Gathered and cleaned user engagement data in SQL, conducted EDA to define project scope, performed statistical analysis, created data visualizations, built and tested XGBoost & K-means model in Python to provide prediction of customer behavior, with over 90 % AUC-ROC
Designed and implemented ETL solutions with over 200GB of data. Maintain data infrastructure including building over 40 data tables, reconstructed the databased structure, improving the query efficiency about 50%
Conducted and analyzed 3 A/B testing experiments to evaluate operational efficiency improvement

Financial Analyst Intern

Noah Private Wealth Management, Shanghai, CN
Jun 2021 - Sep 2021 · 3 أشهر

Performed SQL queries to build data collection, storage, and processing infrastructure. Analyzed business problems and converted report data to actionable items; delivered simplified and visualized analytical outputs
Collaborated closely with cross-functional product and engineering team to extract meaningful business insights and create targeted marketing strategies based on their risk-return preferences
Established a data exchange ecosystem for customers and defined roles and responsibilities for each stakeholder group. Created detailed workflows for 10 end-to-end business processes. Improved operational efficiency by 5%

المهارات

البحث السوقي بايثون (لغة برمجة) قاعدة بيانات SQL اختبار A/B تمثيل البيانات خوارزميات تعلم الآلة Pandas Scikit-Learn Pytorch SQL Tableau Excel Databricks Pyspark Power BI Git LaTeX SAS AWS Snowflakes Data Wrangling Database Management Time Series Forecasting Machine Learning Deep Learning Statistics PyTorch ggplot PySpark Snowflake Matplotlib Seaborn Hadoop Hive SQL XGBoost K-means SMOTE ETL Exploratory Data Analysis Feature Engineering Predictive Modeling Multinomial Logistic Regression Pearson's chi-squared test
الإبلاغ عن هذا الملف الشخصي؟