Johnny Lyu Email & Phone Number

- Created Machine Learning models (e.g. Random Forest Classifier) to predict customer behaviour for targeted marketing, leading to high conversion and sales growth through personalized offers, and targeted marketing.- Assist and build feature selection pipelines and select top significant features for the Machine Learning models.- Build the data migration and data cleaning workflows to transport data from HIVE to Bigquery through KNIME platform.- Set up the process to let data migration workflows, customer traits, flags, and tables automatically run or update each weekend to improve efficiency.- Contributed to Loyalty Customer Universe in building customer traits, flags, and events to enhance understanding of customer behaviours and find potential customers for marketing.- Supported stakeholders in decision-making through the delivery of adhocs, and lift analysis.

- Facilitated the Loyalty Customer Universe project by creating customer traits, flags, and events using GCP BigQuery (SQL) to enhance understanding of customer behaviors and identify potential customers for marketing initiatives.- Supported stakeholders' decision-making processes through ad hoc reports, and lift analysis.-Assist Other Data Scientists in ML model development.

Toronto, Ontario, Canada

- Utilized web-scraping package (Selenium, Scrapy) to scrape job details from various recruitment platforms, further cleansed and reconciled SQL databases on daily basis.- Extracted keywords from each job description using TF-IDF (NLP algorithm) and obtained trending keywords / required skillsets.- Monitored and analyzed job application status to further optimize clients’ job search on Jobster.io.- Prepared and visualized weekly clients’ job search activity dashboard using PowerBI.

Toronto, Ontario, Canada

-Help visualize the distribution of Covid-19 globally and create quick search click in EXCEL by using hloop, pivot table, data validation, sumif, etc.-Help analyze the credit in different groups with pandas python and use the packages, such as pandas and seaborn, to visualize the data and make a correlation heatmap.-Help visualize the dataset with Tableau through calculated formula method, making tables, and charts.-Present the project investigation such as how to develop an online educational platform. This is a groupwork and I searched the information about the benefits to set up a company in Cayman. In addition, set a headquarters or subsidiary in Cayman was also a topic in my presentation.