Google Cloud โ๏ธ
In fall 2022, I interned at Google Cloud on the New Products Introduction team. There, I worked on a CLI tool in C++ to automate GCPโs testing suite for new products and increase engineering productivity.
Hi! I'm Andrew Yan.
Nice to meet you! ๐
I'm a student at Columbia University ๐ฆ studying Computer Science and Math ๐จโ๐ป. I am broadly interested in building and shipping software products, mathematical modeling, and early stage ventures. I am particularly interested in cybersecurity software, B2B application and infrastructure, and web3 startups.
In fall 2022, I interned at Google Cloud on the New Products Introduction team. There, I worked on a CLI tool in C++ to automate GCPโs testing suite for new products and increase engineering productivity.
In summer 2022, I interned at Vimeo as a security engineering intern on the Trust and Safety team. There, I developed a microservice to rate content moderation flags in Golang, Docker, and MySQL. My microservice was shipped to production and I really enjoyed learning more about microservice-driven architecture as well as the software tooling side of security.
In summer 2021, I worked as a cybersecurity intern at the U.S. Army Combat Capabilities Development Command Data & Analysis Center (DEVCOM-DAC). There, I applied my cybersecurity knowledge to producing proof-of-concept exploits and researching and demonstrating new attack surface areas including in machine learning. I was also exposed to unique security challenges in the military and found the internship extremely insightful and rewarding.
Built an e-sports analytics platform E-Insights using Node.js, web sockets, and sentiment analysis to analyze livestream comments in real-time.
E-Insights won Best E-Sports Hack at the 2020 Wallifornia ESports and MusicTech Hackathon, competing against participants from 22 countries and won coaching sessions with Leansquare Accelerator. Devpost submission here.
During winter break 2021, I set a goal to learn Golang and build a small project using it. I ended up building a web app simulating a courier management service using Go and Mux backend, PostgreSQL on AWS RDS (Relational Database Service) cloud database, and deployed it on AWS EC2.
You can check out the Github repo here. Feel free to add your name and location!
Between summer 2020 and spring 2021, I worked as a growth and software engineering intern with Quantime, an early stage productivity startup. There, I developed, coded, and shipped keyboard shortcuts feature and filtering mechanism from ideation to implementation in React, Material UI, Typescript, and Django. My features are used in thousands of instances monthly.
This experience was super formative for me, as I learned not just the technical aspects of a B2B SaaS startup, but also the operational aspects as well. I am very thankful for having awesome supervisors Suchit and Burke, who offered sage advice and words of wisdom along the way.
In fall 2021, I worked with Almaworks startup Bookshlf to design and code a simple mobile-friendly contest page using Bootstrap. Check it out here.
At the 2019 Management and Technology Summer Institute, I worked in a team of 5 to develop an iOS app and wristwatch combo in Swift that combats urban pickpocketing. Our product GeoSafety (no longer active) uses geofencing and open source urban crime datasets to keep tourists safe in unfamiliar cities.
GeoSafety was awarded Best Prototype out of 15 teams at the Management and Technology Summer Institute. GeoSafety has since spun down following privacy concerns related to location tracking.
On campus, I help run Almaworks, Columbia University's undergraduate-run startup accelerator. Our 70+ student startups have collectively raised more than $35M dollars from venture capital firms including Dorm Room Fund and Andreessen Horowitz and have graduated into programs such as Y Combinator and TechStars.
Within Almaworks, I led and now advise the Almaworks Fellowship, which brings together the top minds from universities accross the nation such as Columbia, MIT, Princeton, UPenn, and more to create a community of entrepreneurially-minded students. Almaworks Fellowship alumni have gone on to found their own startups, work in the tech industry in roles including RPM at Facebook and APM at Google, and include a Fulbright Scholar.
In spring 2021, I worked as a research assistant at the Columbia Cognition and Decision Lab. There, I applied Bayesian decision theory methodologies to study optimal stopping and multi-armed bandit problems in behavioral economics and operations research.
Using Python and SciPy, I coded 1000+ lines to process, analyze, visualize, and model over 300,000 entries of experimental data collected via Amazon Mechanical Turk. Models and techniques used include drift-diffusion models (DDMs), Markov chains, constrained optimization, and recursive utility.
In March 2021, I worked in a team setting to build a stochastic agent-based model using Python and Keras to model the spread of Vespa mandarinia. We applied statistical methods such as synthetic minority oversampling technique, random forests, Monte Carlo simulations, and random walk diffusion models. Paper was awarded Honorable Mention out of 10,000+ teams at the International MCM 2021.
Paper accessed here
In my senior year of high school, I worked in a team of 5 high school friends to research the U.S. electric truck market and develop mathematical models in Python to predict electric truck usage and infrastructure needs in the next two decades.
Our paper placed in the top 19% of 760 submissions at the 2020 MathWorks Math Modeling Challenge.
I am an adventure-seeker. So far, my favorite memories have been surfing in Peru as part of a homestay program, skydiving in Norway, riding a camel by the Great Pyramids, and floating in the Dead Sea. Some places I have been:
For me, reading and traveling go hand-in-hand in that they both expand your worldview. I've compiled a list of books I have read and would like to read. Feel free to contribute. Hereโs to more adventures. US Travel heatmap courtesy of Ten Pages.
Outside of coding, math modeling, and entrepreneurship, I enjoy playing jazz saxophone. I have performed at various venues including Terminal Five in NYC, Chris's Jazz Cafe in Philadelphia, and the Kennedy Center in Washington D.C.
In addition, I have performed with bands such as the Princeton High School Studio Band, New Jersey All State Jazz Ensemble (first tenor sax and second alto sax), Google Jazz Band (GSharp), and Oxford University Jazz Orchestra (OUJO).
At Columbia, I play in the jazz ensemble and formerly in the Afro-Cuban and Brazilian ensembles. I also lead my own group, and in my senior year of high school, I recorded an album at Abbey Road Studios in London ๐ฌ๐ง. Take a listen here.