Menu

Hi There!

My name is Patrick Old. I'm a data engineer based in San Francisco, CA

About

More About Me

I discovered my passion for data science through research I completed in oceanographic physics at the University of Washington. Since then, I have been working in industry at companies such as Nike, LinkedIn, and Pave to bring world-class data products to life.

What I Can Do For You

Data Engineering. Data Science. Software Development.
I am a technology generalist specializing in data engineering.

My Work Experience

April 2023 - Present

Pave

Data Engineering
Check Out This Product I Led

- Led the development of multi-million dollar data products that are core to the business using Python, SQL, dbt & Google Cloud.
- Created throughput metrics to identify issues related to data dropout in the dbt pipeline.
- Created metrics dashboards to identify data quantity and quality issues related to product releases and updates.

November 2021 - March 2023

LinkedIn

Data Engineering

- Independently led and completed a 10-month project to migrate logic from Hive to Spark using Spark Scala and Spark SQL in a daily ETL pipeline using technologies similar to Airflow. This project impacts sales operations internationally on hundreds of millions of dollars in revenue to help identify the best sales representative for a given sales opportunity. Results include saving hundreds of hours per year of manual effort across 5 teams at LinkedIn, removing frequent incidental data loss in the pipeline, and improving the runtime of the ETL pipeline significantly.
- Partnered closely with business teams to provide enhancements to ETL pipelines using Spark SQL, Spark Scala and Python.
- Independently addressed on-call issues, often leading triaging efforts across several teams operating internationally.
- Improved team's on-call processes via tutorials using Jupyter Notebook and SQL.
- Created documentation to guide decisions made at the data organization level on which technologies to use to create a new data pipeline.

August 2019 - October 2021

Nike

Data Science, Data Engineering, and Software Development
- Developed machine learning and artificial intelligence models using natural language processing and classification algorithms with Python, Pandas, TensorFlow, scikit-learn, and Jupyter Notebook.
- Developed numerous extract, transform, load (ETL) pipelines using Python, SQL, Airflow, Snowflake and AWS.
- Developed Flask web applications (Python, JavaScript) and deployed via AWS EC2 for implementation of production-grade machine learning models.
- Developed scripts in Java and Python for geospatial software and geospatial data science.

October 2015 - June 2019

University of Washington

Data Scientist - Climate Model Researcher
Publication

Led research analytics for a three and half year project to analyze variabilities and inconsistincies in the world's best climate models. Analysis was performed using Python. Work was funded by NASA and the NSF.

October 2018 - March 2019

Instructor

Created two new undergraduate data science courses focusing on beginning and intermediate data science techniques in the field of oceanography. Courses were taught in Python, with a focus on the basics of numpy and pandas.

Side Work

Projects

In UC Berkeley's Master of Information and Data Science (MIDS) program, I analyzed Bay Wheels bikeshare data to drive business growth.
Analysis with SQL, Python, BigQuery, Jupyter Notebook. Link

HTML5 Icon

In UC Berkeley's Master of Information and Data Science (MIDS) program, my team and I extensively analyzed the relationship between mobility and the number of COVID-19 cases per capita in each US state.
Analysis in R. Link

HTML5 Icon

At the University of Washington I created and taught undergraduate
classes (Github) on how to create things like this.
Content included Python, numpy, matplotlib and more.
Data Source: World Ocean Atlas 2018

HTML5 Icon

Now I use deep neural networks and machine learning to help bring ideas to life. Test out the following digit recognizer as an example (Github), which uses a convolutional neural network I built in Tensorflow (99.3% accurate on MNIST dataset). UI Credit: Benson Ruan

Hand Written Digit Recognition
Draw a Digit Below

Journal

Latest From The Blog.

I love to talk about life, work ethic, and professional philosophies.

Habit Creation During the Pandemic

During a time when we are spending more time than ever at home, our habits here are more important than ever. Here, I discuss books that have helped shape what I think of as some of the best habits in my life. Post.

Work Ethic

The Fascinating Truth of Studying Oceanography

Through my studies in oceanography at UW, I personally came to define oceanography as the study of the physical, biological, chemical, and geological factors of the ocean and how these components interact. And when you are talking about doing this with something that covers ~75% of the globe, it’s quite hard to do that by hand. Post.

Career
5

Blog posts

10000

Cups of Coffee

25

Projects Completed

Say Hello.

Please use the links below to get in touch.