CV - Raphael Zhu
Education
The University of British Columbia
Vancouver, BC
Master of Science: Major in Statistics
Sep 2020 - May 2022
International Tuition Award
The Ohio State University
Columbus, OH
Bachelor of Science: Honours Physics, Minor in Statistics and Mathematics
Aug 2016 - May 2020
Magna Cum Laude, James Smith Scholarship
Skills
- Software: Snowflake SQL, MS SQL, Azure, Tableau and Mode Analytics.
- Programming: SQL, Python, R, Java and C++; PowerShell, Zsh, Bash and Git.
- Field Knowledge: Data Quality Assurance, Data Migration, Data Engineering, Electronic Medical System, Machine Learning, Data Structure and Algorithms.
Experience
Budweiser APAC
Shanghai, CHN
Data Engineer / Data Scientist
Aug 2024 - Present
- Data Engineering: Optimized running performance of core data ETLs. Conducted systematic restructuring on core database.
- Business Intelligence: Participated in ABI data and reporting projects. Assisted in data mining and dashboard development.
Freelance / Contractor
Vancouver, CAN
Data Analyst / Consultant
Nov 2023 - July 2024
- Statistical Consultant: Offered professional statistical assistance for experiment design for research. Mainly for medical study and energy optimization.
- Financial Analyst: Provided fundamental and technical analysis by analyzing economic indicators, political events, monetary policy, and market sentiment.
- Educational Creator: Create educational content for trading in the financial market. Focusing on risk management, trading psychology, and trading strategy.
- Community Contributor: Create Pine-Script indicators used in TradingView software with detailed introductions. Have improved 10+ classic or traditional indicators for specific usage with more options. Translated Pine-Script indicators and strategies to Python-based quantitative framework.
City of Burnaby
Vancouver, CAN
Business Analyst
Sep 2022 - Sep 2023
- Data Science: Optimized data structure over multiple sources and categories. Provided in-depth analysis and dashboards.
- Business Solution: Assisted community projects and delivered solutions based on data analytics. Cooperated with engineers to improve CRM efficiency.
Yuyao Jewelry Co., Ltd.
Shanghai, CHN
Business Analyst & General Partner
Apr 2022 - Nov 2023
- Constructed a Gemstone and Jewelry consultant service between customers and sourcing partners.
- Built an international trading channel between Thailand, Sri Lanka, Pakistan and China.
- Ran ecommerce stores on various platforms including Taobao and Douyin.
- Promoted auction-grade hign-end jewelry from Thailand to Mainland China.
LucenFly
Vancouver, CAN
Co-Founder
May 2022 - Oct 2023
- SquareSpace-powered website design, development and maintainance.
- Gemstone/jewelry high-res photography.
- Design and construct product database and SKU system.
- Maintain and expand supply chain relationships.
Pacific Cloud Trading Inc.
Vancouver, CAN
General Partner
May 2022 - Present
- Founded custom jewelry brand 'LucenFly'.
- Conduct marketing analysis and draft sales strategy.
- Perform internal audits including expenditure controlling, balance sheet reporting and growth monitoring.
Lightyear Health, Team of Data Science
Walnut Creek, USA
Data Scientist Co-op
Sep 2021 - Dec 2021
- Data Migration: Migrated data to Snowflake data warehouse from HubSpot data lake. Created 30+ data schemas, and monitored the data mapping process.
- Quality Assurance: Designed, implemented and maintained 10+ quality assurance (QA) scripts to detect anomalies and ensure the integrity of clinical and sales data.
- Database Manipulation: Conducted data profiling, transformation, and restructuring with complex Snowflake SQL query and Python pipeline scripts.
- Reporting and Dashboard: Generated and maintained 10+ periodic dashboards to visualize sales growth, identify investments and inform internal decision-making.
- Data Analysis and Modeling: Optimized regional sales strategy and built a predictive diagnosis system with advanced machine learning models.
University of British Columbia, Department of Statistics
Vancouver, BC
Graduate Research Assistant
Sep 2021 - May 2022
- Project Content: R packages "Distplyr" and "Distionary" development with Professor Vincenzo Coia.
- Software Development: Provided 10+ infrastructure functions and test suites to aid software validation and deployment.
- Program Documentation: Created 10+ informative demonstration examples in the documentation files to enhance software users' coding experience and facilitate future software maintenance.
- Presentation and Knowledge-Sharing: Host department-wise seminar to share knowledge of statistical software development techniques and real-world applications.
University of British Columbia, Department of Statistics
Vancouver, BC
Graduate Academic Assistant
May 2021 - Aug 2021
- Support department's online teaching requirements and developments of learning resources for STAT courses.
- Apply innovative learning technologies (Canvas, WeBWorK, R) to traditional in-person classes.
- Provide reviews on course material and develop new questions for exams.
University of British Columbia, Department of Statistics
Vancouver, BC
STCS Consultant
Apr 2021 - May 2022
- Offer professional statistical assistance in short term for experiment design for research.
- Draft project planning and schedule for clients with personalized requirements.
- Provide explanations of statistical techniques, assistance in study designing and analysis of client's data set.
The Ohio State University, Department of Physics
Columbus, Ohio
Physics Tutor
Sep 2017 - Apr 2020
- Helped students understand concepts in Physics classes and inspired them to solve relative questions.
- Provided brief exam review sessions for groups of students who were attending Physics classes.
The Ohio State University, Holography Club
Columbus, Ohio
Membership and Holography Maker
Aug 2017 - Apr 2020
- Produced small sized holography works.
- Prepared and co-host the Holography Show.
Activities
Neural Network Meta-Signal | TradingView, Vancouver
Jan 2024 - Present
- Implemented and picked 10+ trend, momentum, volatility, and volume indicators. Constructed a signal system based on neural network models. The beta version provided 0.65+ Sharpe Rate and 80%+ non-leverage APY in the backtest.
Chartist RaphaelZ | YouTube, Vancouver
Apr 2024
- Provided basic introduction to financial investments.
- Produced educational content for risk management, trading psychology, and trading strategy.
- Illustrated the plan and execution of strategies.
Crypto Candlestick Patterns | TradingView, Vancouver
Nov 2023
- A crypto market version of traditional candlestick patterns, with Chinese language option.
- Improved the original *All Candlestick Patterns* indicator in signal illustration.
- Added more options for adjusting recognization's precision.
Distplyr and Distionary | R Packages, Vancouver
Apr 2022
- Distplyr: provides a grammar for manipulating the probability distributions under a clean and user-friendly framework.
- Distionary: provides distribution types as
dst_*()
family of functions and provides the basic objects to be manipulated under distplyr. - Presented and introduced the two packages to public.
NLP Project on Sentence Similarity | UBC, Vancouver
Nov 2021
- Cleaned up and preprocessing data with 400k+ entries from Kaggle's competition "Quora Question Pairs".
- Developed an 85%-accuracy LSTM with Word2Vec model for question pair classification based on sentence similarity.
- Researched on 1D-CNN embedding layer with class weights, TFIDF, and mover distance etc., 86% accuracy achieved.
Bayesian Predictive Analysis of S&P 500 Index | UBC, Vancouver
Apr 2021
- Exploratory data analysis and time series processing.
- Developed a Bayesian structural time series model for seasonal prediction on S&P 500 index with 84% accuracy.
- Built Gaussian process models in python for monthly prediction on S&P 500 index.
Survival Analysis on New Users Behaviour | UBC, Vancouver
Mar 2021
- Applied the survival analysis on the conversion rate of first purchasing of new users.
- Constructed a Cox PH model and an Aalen's Additive regression model to recognize the vital factors on users' behavior.
- Provided marketing strategy based on the key reported factors for specific targeted customers and markets.
Trajectory Analysis on Surgery Outcomes for Distal Radius Fracture | UBC, Vancouver
Mar 2021
- Collaborated in team and developed a longitudinal study focusing on the patients' evaluation of surgery outcomes.
- Drafted exploratory analysis and univariate analysis, using in-depth visualization and sufficient A/B tests.
- Preprocessed and restructured raw data with 1.5k+ entries for logistic regression and linear mixed effect models.
HCV Patients Identification with Machine Learning Model | UBC, Vancouver
Nov 2020
- Presented exploratory data analysis and missing values analysis on the hospital measurements of HCV patients.
- Built OvR/MvM multiclass logistic-regression-based classifiers with 95.4/96.4% accuracy for the patient recognition.
- Implemented a Naive Bayes Classifier with 93.81% accuracy as the benchmark for the multiclass classifier.
Materials and Sky | OSU, Columbus
Apr 2020
- A photographic project of a series with diagonal layout.
- Explore the collision between building materials and the sky.
- Explore the intersection between geometric structures and natural views.
Data I/O | OSU, Columbus
Oct 2019
- Completed the challenge of traffic analysis from Mobikit, for improving the safety function in auto driving.
- Conducted modification on nominal data, data cleaning and missing values analysis.
- Constructed logistic regression modelling and performed model selection.
DataFest | OSU, Columbus
Apr 2019
- Data modification, feature selection, exploratory data analysis and multiple hypothesis test with high power.
- Presented insights of the data and interpreted data visualization for non-academic audience.
- Offered specific suggestions regarding daily lifestyles of university athletes.
Mendel Programming Language | OSU, Columbus
Nov 2016
- Tested complied codes and maintained coding consistence.
- Designed an educational language based on JavaScript which could be compiled to low level subsets of JS and C.
- Kept the language as strictly typed, multi-paradigm, and compiled with modern and clean style.