Andrew's Portfolio

About Me

I'm Andrew Paternostro, a senior at Columbia University studying computer science and economics. I've interned at MarketAxess, TD Securities, and Manhattan Venture Partners, gaining experience in software engineering, research, and exploring new technologies. I love to build, and coding for me is a creative outlet. My passion began in high school with woodshop, metalworking, and computer hardware projects. Those early experiences taught me the value of design and problem-solving and continue to guide how I approach software today. Outside of technology, I enjoy snowboarding, rock climbing, and discovering new music.

Experiences & Education

Education

Expected Grad 2026

Columbia University

Pursuing a Bachelor's degree in Computer Science and Economics.

Relevant Coursework

Advanced Programming
Artificial Intelligence
Computer Science Theory
Data Structures and Algorithms
Econometrics
Intro to Programming in Java

Involvement

ColorStack Community
CodePath Fellow
Society of Hispanic Professional Engineers
AKPsi
Columbia Venture Partners
Association of Latino Professionals For America (ALPFA)

Experience

Jun 2025 – Aug 2025

Software Engineer Intern

MarketAxess

Instrumented five backend services with OpenTelemetry and created extensive technical documentation to guide implementation. Contributed to a new ETF trading feature and presented the functionality to global management.

Aug 2024 – Present

Mentor & Member

HeadStart Fellowship

Mentor Aug 2024 – Aug 2025

Guided students interested in technology through recruitment and career development, focusing on resume reviews, interview preparation, and networking approaches.

Member Aug 2024 – Present

Actively participate in a pre-professional collegiate community of ~400 students, contributing to events and networking.

Sep 2024 – Dec 2024

Fellow

Columbia Product Management Fellowship

Explored product development concepts through weekly workshops and discussions, collaborating with peers to ideate, develop an MVP, and present a final pitch to industry professionals.

Jun 2024 – Jul 2024

Summer Analyst

TD Securities

Conducted research on M&A and ECM deals, including a $250M healthcare transaction and a $150M AI cloud storage company. Synthesized large datasets and financial models into pitch materials and firm-wide research reports.

May 2023 – Aug 2023

Data Analytics Intern

Manhattan Venture Partners

Performed quantitative analyses on a $100M portfolio using scenario modeling, ratio calculations, and competitive benchmarking. Delivered data-driven insights on companies like SpaceX and Twitter, shaping investment pitches and expanding opportunities for private AI investments.

Projects & Skills

Music Popularity Predictor

Built a machine learning model using 18,000+ songs from Spotify's API and public datasets that predicts song popularity from audio features, achieving ~35% higher accuracy than published benchmarks. Designed a full-stack web app (React + Flask) capable of handling songs as input and displaying real-time popularity predictions.

Python JavaScript HTML/CSS React Flask Pandas scikit-learn Machine Learning

Code

LED Stock Ticker Display with Data Visualization

Engineered a Wi-Fi–connected LED matrix that displays real-time stock prices using Python and microcontrollers. Currently developing a supplemental Plotly/Dash platform to track the displayed stock data for historical analysis.

Python Plotly/Dash IoT

Technical Skills

Languages and tools I have worked extensively with across professional, academic, and personal settings.

Java

Python

C++

MySQL

JavaScript

HTML

CSS

React

Docker

Tech Lab Highlights

These photos are snapshots of some of the projects I've built in makerspaces using wood, metal, or electronics.