Travis Yamagata

Company Projects

gspread Feed Application

Issues:

Company permissions restricted product access to Google Sheets.

Solutions:

A Kubernetes-based application that enabled users to grant basic permissions to a Google Cloud service account. The application generated secure copies of spreadsheets accessible only through username and password. Credentials were stored in Vault and could be updated without requiring GitHub PRs, allowing seamless addition of new customers and Google Sheets.

Code: Github Code


Data to S2S Application

Issues:

Companies lacked engineering resources to set up server-to-server (S2S) integrations and were unable to send the required data.

Solutions:

Developed a Kubernetes-based solution coded in Python that connected to a data warehouse using provided credentials. The application pulled data files, mapped fields to the required S2S endpoint fields, and sent each row of data. Mapping configurations for customers and file details were stored on an internally hosted site, and liquid templates were used for data transformation when needed. The system ran on a cron schedule every 15 minutes to ensure the product received the most up-to-date data.

Code: Github Code


TEchnical Consulting Playbook

Issues:

Onboarding and integration were slow due to a lack of documentation and the need for a technical resource on every call.

Solutions:

Collaborating with sales, customer teams, and customers, I created a Technical Consulting playbook that provided detailed information on the solutions offered by Technical Consulting. This included processes for customer solutions like data integrations, asset management, and custom implementations. Additionally, I developed customer-facing one-sheeters to address common questions, which could be sent before calls or when interest was expressed. These efforts helped reduce time spent on initial calls and follow-ups.

Personal Projects

 

Gmail to SFTP Upload

problem:

Manually retrieving data file attachments from email and uploading them to an SFTP server was inefficient and time-consuming.

Solutions:

A simple, automated script that can be run locally on a cron job or deployed to a cloud solution. This script uses a configuration file to store email details and SFTP credentials. It automatically checks a Gmail account for unread emails containing CSV attachments that meet the criteria, downloads the files, and uploads them to the specified SFTP server for each customer.

Code: GMAIL TO SFTP Upload Code


Pomodoro App

I was exploring time management techniques to improve my productivity and came across the popular Pomodoro method. Along with wanting to experiment with the Tkinter package for building visual applications, I decided to create a basic Pomodoro app that tracks 25-minute work intervals and alternates with short breaks. This was a fun side project that not only allowed me to create a useful app but also helped me continuously improve and learn new tools outside of work.

Code: Pomodoro App Code


My Tip Calculator

While working at AppsFlyer, a key part of my role involved implementing Third-Party SDKs in applications. To do this effectively in a live production setting, having a functioning app in the App Store was essential. Having never developed an app before, I created a light version of a tip calculator to gain hands-on experience with Xcode, the app development process and integrating third-party SDKs. I maintained the app for a few years, and while I haven't updated it recently, I plan to use it as a foundation for a future app idea.