Rachel (Chengjie Ren)

https://sites.google.com/view/rachel-ren

adl94j@r.postjobfree.com San Diego, CA, 92122 858-***-**** Highly self-motivated data scientist and data analyst with 3+ years of experience Robust professional and technical skills applying data mining to deliver reports and actionable insights Refined bilingual communicator with strong critical thinking and problem-solving skills SKILL

Tools: MySQL SQL Server Python Excel AWS R SPSS Tableau Power BI Tableau Google Analytics Spark Business Analysis: Business Strategy Digital Marketing Ecommerce (Funnel model) Lifetime Value Cohort Analysis Data Analysis: Machine Learning Time Series NLP Web Scraping Optimization Salesforce CRM Statistics (Hypothesis Testing, ANOVA) A/B Testing Hadoop Real time analysis Contest: UCLA Extension Hackathon: 1st place (Sentiment Analysis) UCLA Extension 3rd place (Predictive Analysis) Certificate: Advanced SQL (2020) Business Analysis (2019) Advanced NLP (present) WORK EXPERIENCE

Data Analyst Intern San Diego, CA

Skinny Gene Project Healthcare Nov 2020 - present Leading 20k+ demographic and healthcare data to automate data manipulation process, increase data visibility, proactively track participants health condition, and segment participants to improve participation rate in our healthcare program

• Data Integration and Visualization: Collaborating with different insurances companies, integrating 20k+ health data to generate 10+ interactive leads/outcome reports using Excel (Pivot Table) and Tableau (Detail-oriented), summarizing and demonstrating results based on statistical indicators to the manager

• Pipelines Optimization: Conducting research and data management on ZOHO CRM, including data quality and validation check, data integration automation, data tracking, and improving data process efficiency by 10%

• Modeling and KPI Analysis: Performing hypothesis testing and Machine Learning (Python/R) models (Random Forest/XGBT) based on 20+ healthcare indicators to detect data patterns and deliver most important factors on people’s participation

Data Analyst Intern Remote

EFORTLES Inc. Accounting Startup Nov 2020 - present Applying quantitative analysis, data mining and data modeling to develop potential clients based on company’s marketing campaign and cooperating with cross-functional teams to support business growth

• Data Collection Automation: Automating data collection pipelines from Youtube, Twitter by leveraging web scraping techniques and API to collect 60k+ potential client data and increasing efficiency by 70% (Python)

• Data Mining and Documentation: Developing deep analytical insights around product usability, business logic, and the end-to-end experiences across 60k+ data and documenting user guidelines (payment, sales, MySQL database architecture) on Notion to support platform upgrade by collaborating with cross-functional teams (Design/Software engineers)

• Data Modeling: Implementing Text mining, data extraction and ad-hoc analysis to develop and segment clients (Logistic Regression/K-means++) for better pinpointing small business owners to deliver company’s accounting services Analyst Assistant and Teaching San Diego, CA

AUPAIR IN AMERICA full-time Oct 2018 - May 2019

Quantified and identified student performance data to solve ad-hoc problems to improve teaching process

• Framework Design: Customized service using Excel based on students’ behavior data and achieved a 96% satisfaction rate

• Actionable solutions delivery: Engaged in the task-oriented team and delivered data-driven insights to optimize curricula EDUCATION

University of California, Los Angeles Los Angeles, CA Data Science Certificate GPA: 4.0/4.0 Mar 2020 - Mar 2021 National Kaohsiung University Kaohsiung

Exchange Program: Financial Management GPA: 3.96/4.0 July 2016 -Jan 2017 Qingdao University Qingdao, China

Bachelor’s degree: International Economics GPA: 3.91/4.0 Sept 2014 - June 2018