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.