Ruoshi(Rush) Zhao
Data Analyst at ConnectureDRX- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
ConnectureDRX
-
United States
-
Information Technology & Services
-
100 - 200 Employee
-
Data Analyst
-
Mar 2022 - Present
-
-
-
Greater Than One
-
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
-
-
-
Washington University in St. Louis - Olin Business School
-
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
-
-
-
Joblogix-X Corporation
-
Houston, TX
-
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
-
-
-
Zhong An Fintech Research Institute
-
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 -
Rensselaer Polytechnic Institute
Bachelor of Science - BS, Applied Mathematics