Daisy Ge Email & Phone Number

Canada

Canada

Toronto, Ontario, Canada

222 Bay Street, Toronto

Mississauga, Ontario, Canada

- Initiated the project of predicting condo prices for third party and successfully customized the solutions for client’s retail location selection and service territory mapping. - Responsible for large-scale real estate listings data acquisition, data validation and integration by converting raw data formats using Excel VBA and building the MS Access database to consolidate multiple data sources and support large-scale data updates using SQL queries. - Leveraged prepared datasets to… Show more - Initiated the project of predicting condo prices for third party and successfully customized the solutions for client’s retail location selection and service territory mapping. - Responsible for large-scale real estate listings data acquisition, data validation and integration by converting raw data formats using Excel VBA and building the MS Access database to consolidate multiple data sources and support large-scale data updates using SQL queries. - Leveraged prepared datasets to build multiple linear regression models in R and analyzed correlation and multi-collinearity between factors to improve the model accuracy.- Visualized and articulated the relationship between condo sold prices and multiple factors with various plots in Excel dashboard and pivot tables presented the results to management and clients.- Significantly improved the efficiency of data management by automating the process of data quality control, which flagged and filtered incorrect data inputs in VBA for future use. Show less

China

- Manipulated, extracted and sorted monthly expenses data with SQL database queries and further created a dynamic dashboard that allowed for easier visualization trends and segmentation- Evaluated the relationships between sales and other variables by using R to construct multiple linear regression models to help improving business efficiency and performance- Refreshed business sales content which provides detailed expense, profit and reserve calculation that created an easily… Show more - Manipulated, extracted and sorted monthly expenses data with SQL database queries and further created a dynamic dashboard that allowed for easier visualization trends and segmentation- Evaluated the relationships between sales and other variables by using R to construct multiple linear regression models to help improving business efficiency and performance- Refreshed business sales content which provides detailed expense, profit and reserve calculation that created an easily accessible benchmark for the field sales team and improved results Show less