Ruoshi(Rush) Zhao

Data Analyst at ConnectureDRX
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
St Louis, Missouri, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Information Technology & Services
    • 100 - 200 Employee
    • Data Analyst
      • Mar 2022 - Present

    • United States
    • Advertising Services
    • 100 - 200 Employee
    • Data Analyst (Center for Experiential Learning: Practicum Project)
      • Jan 2021 - May 2021

      • Conduct background research and analyze existing data sets of patients and healthcare providers with Python to determine trends of the market and correlations between 80 variables. • Create dashboards, define thresholds for notification of potential market opportunities and build predictive models with R to detect more valuable patients and healthcare providers • Analyze users' behavior flow on websites by Google Analytics and find significant parameters for user conversions. • Translate insights into marketing strategies, visualize findings to ad-hoc reports and present to product manager. Show less

    • United States
    • Higher Education
    • 100 - 200 Employee
    • Teaching Assistant
      • Jan 2021 - May 2021

      Teaching Assistant of the course Machine Learning Tools for Prediction of Business Outcomes Teaching Assistant of the course Machine Learning Tools for Prediction of Business Outcomes

    • Data Analyst, CenterPoint Energy project
      • May 2020 - Dec 2020

      • Interviewed department leaders and senior executives to collect business challenges, documented user stories for 50+ digital services requirements and translated strategic proposals to digital solutions in the analytics framework • Designed Data Mapping Diagrams to track data relationships to explain and incorporate data from external resources • Implemented the automatic data integration pipeline within SSIS to extract 300K+ historical data from SAP HANA and migrate data to OLAP database for analytics purposes, collaborated with QA teams on data validations and productions • Partnered with business and DevOps teams to design appropriate views, add calculating fields and dynamic parameters, and develop Tableau Dashboards to help clients track utility activities and find the operational opportunity volumes • Created the root cause analysis across electricity systems based on abnormal activities reflected in daily dashboards • Developed Time Series Regression Model to monitor and forecast the seasonality data to track the customer behaviors regarding electricity utilization, which forecasting model helped leadership teams to prevent the utility stealing activities Show less

    • Insurance
    • 1 - 100 Employee
    • Data Analyst
      • May 2019 - Aug 2019

      • Conducted qualitative and quantitative analysis to carry out precision marketing for the given loan products • Developed data architecture flows to incorporate data from multiple systems and extract 20M+ raw data to AWS S3 using different API tools and deserialized JSON data for data cleansing and transformation inputs • Designed and tracked ETL pipeline by leveraging AWS EMR (PySpark), HDInsights, Glue, and Monitoring Services to control the data quality and ETL efficiency, managed 20M+ rows of customer data. • Performed ad-hoc analysis model to study the market trends to discover valuable features for customer segmentation and applied Hypothesis Testing to determine the relationship between customer behaviors and product categorizations • Trained classification models using R with select significant features to track customer behaviors and operational strategy to recommend loan products for leadership teams, monitored model accuracy in KS and ROC models • Implemented go-to-market strategy and delivered the customized sales channels to customers within the new market segmentation and created A/B testing to evaluate the marketing effect, resulting in a rising customers inquiry rate of 60% Show less

Education

  • Washington University in St. Louis
    Master's degree, Business Analytics
    2020 - 2021
  • Rensselaer Polytechnic Institute
    Bachelor of Science - BS, Applied Mathematics
    2017 - 2020

Community

You need to have a working account to view this content. Click here to join now