Andrew Sison
Site Reliability Engineer

Résumé

Experience


CVS Health September 2024 - Present
Senior Site Reliability Engineer
  • Created playbooks and tested new GCP disaster recovery features ensuring BigQuery operational integrity.
  • Handled various data pipeline tickets and incidents for a hybrid on-premises and cloud environment.
Filevine August 2021 - September 2024
Site Reliability Engineer II
  • Architected and modularized a unified alerting structure for multiple services allowing alerts to notify accountable teams, leading to quicker response times and a reduction in MTTR.
  • Migrated services, which send over 1 million emails a month combined, from a monolithic outgoing email repository to an outgoing email microservice, leading to a failure rate of less than 0.0001\% of emails sent.
  • Provisioned New Relic monitors, dashboards, and alerts to cover the golden signals and SLOs of various services, lowering incident MTTI from hours to minutes.
  • Handled incidents as an on-call engineer for a multi-tenant SaaS, helping fight fires and ensure software reliability for over 65,000 users across multiple shards.
  • Discovered and fixed a bug that caused hundreds of incoming email messages and invitations to fail per month by using inherited variables over new ones, and wrote tests to prevent the bug from occurring again.
Northrop Grumman January 2020 - August 2021
Software Engineer
  • Stress-tested a Qt (C++) satellite simulation client and refactored the client to use a single GUI thread in lieu of multiple threads that were causing crashes, reducing the number of crashes by $\mathtt{\sim}$80 per month per client.
  • Redesigned a satellite simulation client to have a drop-down of satellite simulations, with a tooltip feature to organize telemetry with respect to the simulation in question.
  • Using Ansible, automated and hardened deployments of tooling such as Docker, Kubernetes, Jira, and Bamboo, minimizing deployment times for internal teams from weeks to hours.
  • Leveraged Molecule to write automated unit tests of Ansible code and automated the provisioning of Docker Desktop, allowing containerized Molecule unit testing for Windows, saving at least 80 developer hours per month, quantified by the amount of bugs reported by end users.

Education


Pomona, CA California State Polytechnic University, Pomona December 2019
  • Bachelor of Science in Computer Science
  • Coursework: Big Data & Cloud Computing, Parallel Processing, Algorithms, Compilers & Interpreters, Operating Systems, Software Engineering, Computer Architecture, Programming GUIs
Norco, CA Norco College May 2017
  • Dean's Honor List: Fall 2014 - Spring 2017

Projects


Food Interpreter GCP, GitHub Actions, Go, Terraform
  • Designed a language to allow users to easily add multiple foods, dates, and times.
  • Wrote the lexer and tests in Go with proper handling of edge cases during lexical analysis.
  • Using GitHub Actions, created a CI/CD pipeline to automate testing and Terraform deployments on GCP.
Isolation Game C++, Qt
  • Integrated the GUI with the AI using C++ and Qt in collaboration with the team.
  • Used Qt slots and signals for seamless object communication, reducing boilerplate code.
  • Designed and implemented intuitive click-and-drag controls using the Qt graphics scene and view.
  • Wrote the Lexer and the Parser using JFlex and CUP and designed the grammar of the language.
  • Created a Trie Table to hold keywords and identifiers, making search and insertion O(log|k|n).
  • Provided QA by fixing lexical rules, ensuring proper tokenization, and solving grammar ambiguities.
  • Verified parsing of the input into lexemes, and wrote pattern definitions using regular expressions.
  • Led team of 2, and taught partner Git, ensuring proper version control of the project.
  • Scripted in Python, along with NumPy, Pandas, and MatPlotLib.
  • Graphed visualizations of PM levels, temperature, and humidity by using the Pandas data frame API, and reading in csv files from Purple Air’s public air quality sensors.
  • Analyzed graphs, confirming a relationship between time, PM levels, humidity, and temperature.