About Me

Hello! My name is Ting and I am a recent graduate from the University of British Columbia (UBC) where I studied mathematics and economics. I am currently working as a reporting & analytics intern at British Columbia Investment Management Corporation (BCI), where I am developing a web application to track the progress of ETL pipelines. I did a co-op in the same team at BCI about 1.5 years ago and designed and developed an ETL pipeline which computes client returns and portfolio contributions. The pipeline is doing pretty well and there have not been any errors so far!

I am passionate about data and machine learning, and have developed a wide range of data-related skills, including Python, SQL and Tableau. I am also proficient in Java, C++, HTML, Javascript, CSS and Matlab, and have exposure to AWS cloud technologies. (Fun Fact: I wrote this website using HTML, Javascript and CSS!) I am excited to bring my skills and experience to new challenges and opportunities, and am always looking for ways to grow and improve.

In my free time, I enjoy exploring different cuisines in the city. I believe that food is not just about nourishment, but also about culture, tradition, and memories. I also love travelling during holidays, where I get to explore the beauty of the world.

Please feel free to browse through my portfolio and contact me if you have any questions or opportunities. Thank you for visiting!

Skills

Programming: Python (NumPy, Pandas, Scikit-learn, SciPy, NLTK, Matplotlib, PuLP) , Java , C++ , Matlab

Frontend: HTML , CSS , Javascript

Data: Microsoft Excel , SQL , Microsoft SQL Server , Tableau

Tools: GitHub , Amazon Web Services (AWS)

Mathematics: calculus, linear algebra, statistics, probability theory, ordinary & partial differential equation, numerical approximation, linear programming/optimization, number theory

Computer Science: machine learning & data mining, data structure, computer algorithm & analysis, computer vision

Economics: microeconomics, macroeconomics, econometrics, money & banking, international finance, economics of taxation, game theory

Experience

Reporting & Analytics Intern

British Columbia Investment Management Corporation
Jan 2023 - Present

Developed a reporting tracking web application using Python (Flask) for the backend, and HTML, Javascript and CSS for the frontend, resulting in increased efficiency
Implemented real-time data visualization by integrating SQL queries to display live results directly from the database to the application, providing stakeholders with up-to-date information
Enhanced application security by implementing user authentication

Data Analyst

Vancouver School of Economics Undergraduate Society
Jul 2022 - Present

Decreased projected surplus by 50% by creating a budget sheet using Excel and proposing budget improvements through critical data analysis
Prepared a quarterly report which includes financial performance and recommendations for future actions to internal and external stakeholders, resulting in increased transparency
Created infographics on economics-related topics and shared as an educational resource with 1000+ economics students

Reporting & Analytics Co-op (Data Engineer + Data Scientist)

British Columbia Investment Management Corporation
Sep 2021 - Apr 2022

Designed and developed a scalable ETL pipeline to compute client returns and portfolio contributions using Python (Pandas) and SQL by pulling data from 10,000,000+ rows in 10+ tables on Microsoft SQL Server
Created an interactive Tableau performance dashboard for individual clients that is updated daily and used in client meetings by Department Head
Migrated part of an ETL pipeline from R to Python, reducing code runtime by ~90%

Research Assistant

UBC Sauder School of Business
Jun 2021 - Jun 2022

Collected personal and corporate data of 1000+ billionaires through sources such as Wikipedia and press articles in business media to assist with research on exploring the role of tax avoidance in explaining inequality
Formatted raw data and fixed/removed incorrect/duplicate entries to construct a user-friendly database

Imagine Orientation Leader

UBC Science Student Engagement
Jul 2020 - Dec 2020

Supported a group of 9 incoming students, as part of a large-scale faculty welcome event with 2000+ attendees, with their transition into UBC and throughout the first term by sending bi-weekly check-in emails and answering inquiries
Fostered social connections amongst 100+ students by contributing to Canvas discussion boards
Conducted a friendly online welcome session on Orientation Day to incoming students
Recognized as an outstanding leader and invited by the Department of Mathematics to Meet Your Major event

Projects

Ting's Personal Portfolio (This Website!)

HTML, CSS, Javascript

Designed and created a personal website which showcases past experience and projects
Implemented styles to enhance the aesthetics of the website

The Impact of Consumer Reviews on Product Sales

Python (NLTK), Jupyter Notebook, regression, natural language processing (NLP)

Analyzed the impact of consumer reviews on the sales of Amazon video game products using regression based on 1.5 million review data and 40,000 product data
Applied natural language processing (NLP) to analyze consumer review sentiment
Increased model robustness by conducting heterogeneity tests to identify the effect of product features on product sales

Maximization of University of British Columbia’s Undergraduate Tuition Revenue

Python (PuLP), Jupyter Notebook, linear programming/optimization, sensitivity analysis

Investigated the factors affecting UBC’s tuition revenue and developed a linear program to optimize revenue
Conducted an in-depth sensitivity analysis on shadow prices, slack values, and other parameters to evaluate the impact of changes on revenue outcomes

Titanic - Machine Learning from Disaster

Python (Pandas, Scikit-learn, Matplotlib), Jupyter Notebook, machine learning

Conducted a comprehensive analysis of factors potentially impacting passenger survival rates through the creation of various plots
Applied KNN model to predict the survival rate of passengers, achieving an accuracy of ~70%

To-Do List

Java, API, data structure

Created a to-do list application that effectively tracks and manages tasks, which increases productivity
Extracted the latest prices of selected stocks using JSON API
Enhanced robustness by employing a hierarchical data structure and incorporating try-catch statements for error handling