Produced 10+ market research reports to analyze online video & streaming media industry and competitors to support decision making.

Selected metrics, created and maintained 5+ visualization dashboards in Tableau by building data pipelines connected to SQL database to monitor daily users’ behaviors and product performance.

Preprocessed (cleaning, transforming, and checking) the data in Python, applied statistical models and machine learning algorithm using Pandas and Scikit-learn to conduct explanatory and predictive analysis, to understand the effective elements to the business.

Collaborated with product team to implement A/B testing to improve product features, increasing users’ engagement rate by 20% and premium member conversion rate by 15%.

Automatically scraped financial data using Python Beautiful soup, eliminating redundancy and improving efficiency by 75%.

Conducted exploratory and explanatory analysis in Excel (pivot table and advanced functions) and Python (pandas) to the bond market data, and analyzed 5+ municipal bonds to predict the risks and future returns.

Tracked and predicted securities market trends of different industries and stock price trend of firms to support investment assessment.

Provided consultations for 100+ clients and developed potential clients by offering tailored financial portfolio products and maximizing clients’ financial benefits.

Explored sales and consumers data of financial management products using linear regression model in SPSS, and targeted customers in different areas to increase sales by 10% MoM.

Conducted cluster analysis in Excel to identify potential clients, increasing deposits by $20K.