×
Mike Yu

Mike Yu

Senior Data Analyst


Background


About

About

7+ years using Python and SQL to extract meaningful insights from data and distill results for leadership. Leverages technical and customer-facing experience to create strong partnerships with stakeholders and deliver actionable conclusions.

Work Experience

Work Experience

  • Senior Data Analyst

    Apr, 2020 - Dec, 20211 year 8 months

    • Senior member on project to design and implement data evaluation methodology responsible for guiding $7M/year in data buying decisions

    • Responsible for maintaining and improving Ekata’s data quality process to ensure products were consistently backed by accurate data

    • Worked on data engineer tickets such as using Airflow to automate data loads

    • Led Scrum ceremonies (stand up, etc.) and managed Jira metrics for a team of seven

    • Mentored new team members on Ekata’s Graph schema and how to use Spark SQL

    • Created self-serve Databricks notebooks to teach Ekata’s schema and common Spark SQL idioms

  • Data Analyst

    Jan, 2019 - Mar, 20201 year 3 months

    • Combined systems knowledge, SQL, and programming abilities to model the impact on downstream product performance based on changes to our data ingestion pipeline

    • Wrote a Jenkins integration to enable version control on Databricks notebooks

    • Took the initiative to create a take-home interview assignment to test candidates on their analytical skills, presentation abilities, and creativity

  • Solutions Architect

    Nov, 2017 - Dec, 20181 year 2 months

    • Created tailored API recommendations for customers to demonstrate positive ROI by decreasing e-commerce fraud and increasing approval rates

    • Introduced Jupyter notebooks to the team as a replacement to Excel. This enabled rapid scaling of team output through code automation. It also paved the way for moving beyond rules-based recommendations to machine learning solutions and resulted in closing deals with increasingly sophisticated customers

    • Automated work by developing a Python module of analytical tools for the team

  • Business Analyst

    May, 2015 - Oct, 20172 years 6 months

    • Project manager for a custom implementation of JD Edwards (Oracle), responsible for managing $300M/year in grant funding

    • Generated reports for budget analysts using SQL and UW’s Enterprise Data Warehouse

  • Business Analyst / Project Manager

    Oct, 2012 - Apr, 20152 years 7 months

    • PM of Nuclear energy customers for professional services projects for a crisis management platform

    • Lead Business Analyst for a $5M, multi-year project with the state of California that involved frequent onsite discovery sessions with business process modeling

  • Sales Specialist

    Aug, 2010 - Sep, 20122 years

    • Supported sales team with contract management and billing inquiries

Skills

Skills

  • Languages

    Python

    SQL

    SparkSQL

  • Platforms

    AWS

    Databricks

    Confluence/JIRA

  • Tools

    Airflow

    PostgreSQL

    JupyterLab

    pandas

Education

Education

  • Music (Jazz Studies), Bachelor of Arts, Knox College

    Sep, 2006 - Jun, 2010