Michael Liu

Curious, detail-oriented software engineer with experience upskilling individuals and fostering collaboration. Passionate about creating holistic solutions through data-first design and writing consistent, maintainable code.

Skills

  • Languages:

    • Javascript/Typescript
    • MySQL
    • PHP
    • Python
    • HTML
    • CSS/Less/Sass
  • Frameworks/Tools:

    • Git
    • React
    • Redux/Redux-Saga
    • Webpack
    • Babel
    • ESLint
    • Next
    • Node
    • Fivetran
    • DBT
    • Snowflake
    • Tableau
    • Cypress
    • Jest
    • AWS (
      • DMS
      • Redshift
      • DynamoDB
      • S3
      • Lambda
      • Batch
      )
  • Other:

    • Agile Software Development
    • Mentorship/Sponsorship
    • Refactoring
    • Software Architecture
    • Technical Project Management
    • Technical Writing
    • Speedcubing

Experiences

Sherpa CRM

Saint Louis, MOAug 2017Present
  • Software Engineering Manager

    Oct 2021Present
    • Managed 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 2019Sep 2021
    • Optimized 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 2017Aug 2019
    • Implemented 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

We Are Alexander

Saint Louis, MOMay 2014Jul 2017
  • Full Stack Web Developer

    Sep 2014Jul 2017
    • Developed 10 microsites for 6 national brands to increase brand internet presence

      • Built in Ruby using the Sinatra framework and deployed to Heroku
      • Collaborated with designers to create mobile-friendly websites and designs
      • Updated Adobe Experience Manager templates and content
    • Developed new features for an event tracking application for the internal experiential team

      • Built in Ruby on Rails and deployed to Heroku
    • Developed an international company's corporate social responsibility site

      • Created user journeys, wireframes, and ux design
    • Implemented brand identity and content changes in Adobe Experience Manager for 5 national brands

    • Set up AWS Elastic Beanstalk to support WordPress for the company website

    • Collaborated with 3rd party vendors to create and update content in 3 iOS applications

  • Digital Intern

    May 2014Sep 2014
    • Collaborated with multi-disciplinary team to pitch rebranding campaign based on new strategic direction for national account and created digital concept designs

    • Contributed to discussion about content-centered design best practices

    • Responded to clients' requests regarding updates in timely and efficient manner

    • Improved user experience for branded digital applications and websites

    • Applied troubleshooting processes to fix existing code and content on brand web pages

Education

Washington University in St. Louis, 2014
B.S. in Computer Science
Minor in Psychology

Certifications

  • AWS Certified Software Solutions Architect - Associate (2021)
  • AWS Certified Cloud Practitioner (2021)