Mike Yu

Mike Yu

Senior Data Analyst

Contact
Professional Skills Summary

Languages: Python, SQL, SparkSQL

Platforms: AWS, Databricks, Confluence/JIRA

Tools: Airflow, PostgreSQL, JupyterLab, pandas

Work Experience

2020-04-01 to 2021-12-03

Senior Data Analyst at Ekata (a Mastercard company)

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

2019-01-01 to 2020-03-31

Data Analyst at Ekata

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

2017-11-01 to 2018-12-31

Solutions Architect at Ekata

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

2015-05-01 to 2017-10-31

Business Analyst at University of Washington

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

2012-10-01 to 2015-04-30

Business Analyst / Project Manager at Intermedix

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

2010-08-31 to 2012-09-28

Sales Specialist at Comcast Spotlight

Supported sales team with contract management and billing inquiries

Education

2006-09-15 to 2010-06-05

Knox College

Bachelor of Arts: Music (Jazz Studies)