# Richard Cai

> Software Engineer

Location: New York, New York, United States
Profile: https://flows.cv/richardcai

Member of Technical Staff at Cockroach Labs

## Work Experience
### Software Engineer @ Kalshi
Jan 2022 – Present | New York City Metropolitan Area

### Member Of Technical Staff @ Cockroach Labs
Jan 2021 – Jan 2022 | New York, New York, United States
SQL Experience

### Software Engineer Intern @ Google
Jan 2020 – Jan 2020
Google Flutter

### Software Engineer Intern @ Cockroach Labs
Jan 2020 – Jan 2020 | New York, New York
SQL Features

### Software Engineering Intern @ Amazon
Jan 2019 – Jan 2019
· Redesigned DynamoDB table containing advertiser campaign configuration records to support publishing changes in constant time instead of linear time
· Created AWS Lambda to write published campaign change records to S3
· Configured data pipeline to load records into Redshift daily to be joined with existing campaign metadata
· Wrote SQL scripts comparing the performance metrics of the campaign before and after the changes

### Software Engineering Intern @ Zynga
Jan 2019 – Jan 2019
· Migrated core advertising data processing ETL from Pentaho to Databricks reducing run time from 2 hours to 30 minutes allowing the advertising team to make advertising budget allocation recommendations before noon
· Setup ETL deployment pipeline to automate regression tests using mock data
· Developed Airflow ETLs to collect and process millions of in-app user events and report data using Vertica SQL tables

### Undergraduate Research Assistant - Software Developer @ University of Waterloo
Jan 2018 – Jan 2018 | Waterloo, ON
• Developing features for Mechanical TA - a Django based web application to support automated peer evaluation
• Implemented CAS authentication for student logins
• Deployed web application on university servers using Apache allowing the app to be used for university courses

### Software Developer @ Tangam Systems
Jan 2018 – Jan 2018 | Waterloo, Ontario, Canada
• Prototyped a casino table management progressive web app using Ionic 2, MongoDB and Node.js that allows users to manage table recommendations while on the casino floor
• Implemented calculation for capacity and labour percentage of casino tables using C# and SQLite
• Created settings components and file uploader for an analytics page in Angular 2
• Refactored Angular 2 components to replace depreciated Http module with HttpClient module

### Freelance Software Developer @ Upwork
Jan 2017 – Jan 2017
• Created several web scraping and data collection scripts using Python libraries including scrapy and Selenium
• Developed a program to download phone lists from Box and upload the lists to Stratics using the API
• Developed a program to generate a sports league website using HTML and CSS from Excel data using Python
• Worked on an automation script for filling out user forms with proxy support using Python, httplib

### Automation Developer @ Imagine Communications
Jan 2017 – Jan 2017 | Toronto, Canada Area
• Developed a library and regression testing scripts for setting and verifying parameters greatly
   reducing time spent on manual regression testing using Python and Jenkins
• Designed test strategies and workflow for a new product, created library interfaces and code structure
• Created a script to automatically create a documentation website for our Git repository using Sphinx and Jenkins
• Developed a library for capturing, transferring and analysing packets from a remote server using Python


## Education
### Bachelors of Computer Science in Computer Science
University of Waterloo

### Master of Science - MS in Computer Science
Georgia Institute of Technology


## Contact & Social
- LinkedIn: https://linkedin.com/in/cai-richard

---
Source: https://flows.cv/richardcai
JSON Resume: https://flows.cv/richardcai/resume.json
Last updated: 2026-04-13