David Guo Email & Phone Number

Toronto, Ontario, Canada

• Led the development of an AI-powered tool using large language models (LLM) to support portfolio management for investment advisors at RBC Wealth Management.
• Incorporated advanced techniques such as agentic AI and retrieval-augmented generation (RAG) to enhance the efficiency, accuracy, and insights provided by the tool.
• Developed a custom anomaly detection algorithm that identified financial trends, leading to more accurate and informed decision-making for portfolio management.
• Collaborated with cross-functional teams to integrate the AI tool with existing systems, resulting in a solution that is estimated to increase advisor efficiency by at least 20% and save over 200,000 hours of time.

British Columbia, Canada

• Developed a web application using R Shiny to visualize, analyze, and navigate through single-cell transcriptomic data (ISNAP: Integrated Single-cell NAvigation Portal)
• Performed single-cell transcriptomic and network analysis on cardiomyocyte scRNA-seq data using R packages such as SCENIC and Seurat to discover novel transcription factor co-expression networks

British Columbia, Canada

• Developed a custom server-side automated pipeline to analyze and visualize genomic and transcriptomic data using R and Python
• Collaborated with researchers in other labs to help set up various bioinformatics pipelines on high-performance computing systems

Vancouver, British Columbia, Canada

Undergraduate Teaching Assistant for UBC's introductory computer science course on systematic programming design (achieved 99% final grade in the course)

• Developed interactive lab tutorials for graduate bioinformatics course STAT540 (Statistical Methods for High Dimensional Biology) using R and Jupyter
• Expanded lecture slides using updated data visualization packages (‘dplyr’ and ‘ggplot2’) and reorganized content to improve code consistency and formatting using ‘xaringan’ in R Markdown
• Lecture topics focused on statistical inference such as: two-groups comparisons, linear regression, ANOVA, and linear models using ‘limma’

British Columbia, Canada

• Developed automated pipelines for high-throughput biological data using R and Python for differential gene expression analysis, pathway and network analysis, and data visualization
• Improved bash scripts to automate RNA-seq workflow and set up cloud computing capabilities on AWS to improve task efficiency
• Collaborated with bioinformaticians to implement novel bioinformatics infrastructure using Git for file management and version control on local servers

British Columbia, Canada

• Collected genomic data from databases to study evolution of imprinted genes
• Examined genetic lineage of imprinted genes in plants using sequence alignment programs such as MUSCLE and RAxML
• Compiled data into phylogenetic tree analyses and compared sequence homology among several plant species

Doctor Of Medicine - Md

Bachelor Of Computer Science - Bcs (Ics)

Dean's Scholar (2023W) • Awarded to students who achieve >90% on 27 percentage-graded credits Relevant Coursework: CPSC 210: Software.

Bachelor Of Science - Bsc, Integrated Sciences (Genetics And Statistics)

Graduation with Distinction • Dean's Honour List during full-time studies • Extended degree for 12-month co-op term at adMare.