Simon Guo Email & Phone Number

Canada

Vancouver, British Columbia, Canada

Created and authored effective prompts tailored to various use cases by leveraging ChatGPT and refining Large Language Models to learn customer behaviours and insights. Generated detailed reports on prompt quality analysis and provided actionable insights for the product team.Directed the optimization phase of a newly designed pricing product, delivering customizable and automatic revenue or margin-based optimization. Achieved significant profit lift through optimization and automation improvements, substantially reducing manual work and boosting efficiency.Offered expert data consulting services and delivered advanced modelling solutions to clients, ensuring data-driven decision-making and enhanced business outcomes.

Vancouver, British Columbia, Canada

Improved and maintained the existing pricing solution for one of America's leading food distributors with optimization and automation enhancements, reduced more than half of the manual work and boosted the efficiency and effectiveness of the modelling results.Built the scalable Python-based analyzing and debugging tool that can illustrate the connections across different tables in the PostgreSQL database on Amazon RedShift, through efficiently parsing SQL and BASH scripts.Created informative documentation and reports for inquiries and investigations, while narrowing the knowledge gap between the client-facing team and the data scientist team.

Vancouver, British Columbia, Canada

Managed and delivered lab sessions for a computer science course on algorithm analysis methods,searching and sorting algorithms, basic data structures, graphs and concurrency. Prepared lab content and live-coding questions as substantial supplements for course materials and provided sample solutions and post-mortem feedback to students and instructors for each lab session. Received 100% favourable rating from the students for being well prepared, helpful, considerate, easily understood and effective instructor.

Waterloo, Ontario, Canada

As a former member of the Health Data Science Lab, studied and researched the health data science projects, and built various machine learning and statistical models (e.g., logistic regression, random forest, LASSO regression) regarding personalized mortality prediction, with in-depth exploratory data analysis on the eICU Collaborative Research Database. Based on the published research, applied Patient Similarity Metric with a focus on analyzing similar patients. Models were built both with Python and R in Google Colab and R Studio.

Waterloo, Ontario, Canada

Led the Instructional Support Assistant (ISA) team as the returning ISA, provided helpful bash, PHP and python scripts for automotive managing assignment submission pipeline through Markus and terminal. Managed the graduate student markers and held weekly marking meetings, and designed the marking schemes with instructors for each assignment. Developed a time-series model and visualization tool for analyzing the student submission rate and submission average with the ISA teammate.

Guelph

Created an automated AI prediction program which determines the next steps in data analysis under Multiplex Barcode Research and Visualization Environment based on historical records. Improved the coding script for learning user behaviours and blocking potential hackers on the website to ensure the security of barcoding research data. Built Jira Service Desk with custom integrations on API to raise the efficiency of retrieving information from the research projects by automating the process of ticketing and project management.

Guelph

Waterloo, Ontario, Canada

Managed tutorials for first-year computer science course which introduces algorithms and data structures to tackle various real-world issues. Prepared tutorial slides and live-coding questions as substantial supplements for course materials, and provided sample solutions and post-mortem feedback to students for each assignment. Accurately marked assignments provided feedback to instructors on the design of assignments and proctored and marked the exams.

Toronto, Canada Area

Assisted with the data protection project and technical support in the IT department to all the employees in both Toronto and U.S. sections. Created the auto-updating interactive webpage of office floorplans and collection of system information with scripts using the Active Directory. Acquired experience in a fast-growing data-related company with various clients all over North America and gained knowledge of data science and data analysis.

Master'S Degree, Data Science, 95%+

Honours, Co-Operative Program, Data Science, 80%+