Sherpa CRM
Saint Louis, MOAug 2017 - PresentSoftware Engineering Manager
Oct 2021 - PresentManaged a team of 3 engineers and was responsible for their mentorship, growth, and job satisfaction
- Held biweekly 1-1s to discuss concerns and opportunities
- Served as a line of communication between the team and our VP of Engineering
Interviewed potential engineering candidates to assess technical skills and cultural fit in order to grow the development team by 50%
Delivered a "contact consent" feature for our EU customers to manage GDPR preferences
- Designed a more microservice-y approach to decouple contact consent from our database
- Delegated tasks and features to the appropriate engineers inside and outside of the team
- Migrated existing custom customer data into the appropriate standardized fields
Technical Lead
Sep 2019 - Sep 2021Optimized query performance by 50-95% for customers with millions of data records
- Examined EXPLAIN plans to identify poorly indexed tables
- Extracted common table expressions consolidate shared queries and increase performance
Rearchitected the web client data flow to normalize Redux state
- Wrote tickets to distribute the work amongst members of the frontend engineering team
- Reduced duplicated data stored in the global store by 10%
Mentored 2 frontend engineers and an intern directly to establish coding best practices
- Reviewed code changes to discuss potential optimizations and code-maintainability improvements
- Led biweekly frontend "guild" meetings to promote development of planning skills, coding best practices, and cross-team collaboration
Collaborated with the product team and other sr. engineers to redesign database tables to normalize data model
- Designed workflow diagrams to identify loopholes
- Discussed, clarified, and documented unclear domain-specific terminology
Planned and upgraded React from v15 to v16 to take advantage of hooks and other more modern libraries
- Upgraded Webpack from v3 to v5 to impove build speed by 30%
- Implemented Husky to run ESLint and basic code quality checks on staged file
Software Engineer
Aug 2017 - Aug 2019Implemented a customizable, shareable, scheduleable reporting engine to modernize analytics for our customers
- Designed a rudimentary system to generate SQL statements through Javascript to standardize SQL statements
- Implemented d3 charting to display data visualizations both on the web and in pdf exports
Established documentation of team coding styles and best practices in Confluence
- Documented onboarding process for setting up a local development environment
- Created a repository of useful libraries, applications, and learning tools for new developers
Collaborating with vendors to build a data warehouse to run cross-company data analysis
- Maintained ETL code for AWS Database Migration Servce, Batch jobs, and Lambdas to consolidate data from MySQL to S3 to Redshift
- Constructued OLAP data models to facilitate data analysis in Redshift and Tableau
- Implemented a Tableau embed and built custom dashboards for internal and external use