•Lead team of four to deliver the organization and user onboarding experience and authentication mechanism for the embedded Sisu experience inside of Looker, which was part of a critical company initiative and our partnership with Google. I worked with stakeholders inside and outside of the company to design the onboarding experience and built out a SSO flow for the extension by developing an OAuth2 Authorization server.
•For Sisu’s dashboard and visualizations features, I developed the data models in PostgreSQL and built the APIs to power the React app. When metrics showed users were experiencing slow page loads, I imple- mented tracing using OpenTelemetry in our application to root cause and solve these performance issues.
•Optimized database queries that were slowing down key APIs serving the Sisu application by investigating the PostgreSQL query planner and applying remediation based on those findings, which involved adding indexes and using database triggers to denormalize expensive aggregation operations, leading to a median endpoint latency improvement of 30% and improving some query executions by over 300X.
