Hi! I'm Andrew Yan.

I'm a
  • Software Engineer
  • Founder
  • Self-Starter
  • Jazz Saxophonist

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.

Software Development/Personal Projects

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.

Vimeo ๐ŸŽฌ

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.

DEVCOM-DAC ๐Ÿ‡บ๐Ÿ‡ธ

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.

E-Insights ๐Ÿ”

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.

Couriers ๐ŸŒŽ

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!

Quantime โฐ

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.

BookShlf ๐Ÿ‘จโ€๐Ÿ’ป

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.

GeoSafety ๐Ÿ”’

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 Involvements/Research

Almaworks ๐Ÿš€

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.

Columbia Cognition and Decision Lab ๐Ÿง 

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.

Mathematical Contest in Modeling (MCM) ๐Ÿงฎ

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

MathWorks Math Modeling Challenge (M3) ๐Ÿšš

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.

Hobbies

Travel ๐Ÿšž

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:


  • 5 continents
  • 25 countries
  • 34 states
  • 16 U.S. national parks

  • 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.

    Music ๐ŸŽท

    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.

    Have an idea? Let's chat!

    You can email me at andrew.yan@columbia.edu

    Talk with you soon!