Education and Skills
- UCLA 2017, Double Majors, B.A. in Economics & B.S. in Statistics, GRE: 324, Epic Certified
- R, SQL, Tableau, Data Mining, Machine Learning, Computational Programming, Statistical Modeling
Highlighted Working Experience
UCLA Health | Senior Data Analyst, Quality Informatics & Analytics | Oct 2018-Present
UCLA Health | Data Analyst, Quality Informatics & Analytics | Oct 2017-Sep 2018
UCLA Health | Data Analyst (Volunteer), Quality Informatics & Analytics | Dec 2016-Sep 2017
PROVE | Marketing Data Analyst (Intern) | Sep 2014-Dec 2014
- Forecast hospital ranking and performance scores of 120+ quality metrics, by synthesizing individual distribution that defines all possible clinical outcomes from sampling data
- Approximate integral of standard normal and T-distribution as p-value with basic arithmetic operation in Tableau, and calculate z-scores from user’s real-time input to compare performance of different metrics
- Predict hospital incentive payment or penalty by implementing hierarchical feed-forward algorithms from clinical outcome, to scoring methods, and to monetary calculation
- Implemented Sigmoid and polar coordinates transformation as graphical layering in visualization to pinpoint potential issue in quality metrics from millions of combination of procedure and diagnosis
- Query in SQL server to extract patient/encounter/event level data with process and outcome measures from databases, given detailed specification of clinical and operational criteria from physicians
- Optimize R codes that perform complex data mining/wrangling/transforming to achieve 70% automation
UCLA Health | Data Analyst, Quality Informatics & Analytics | Oct 2017-Sep 2018
- Developed monthly dashboards for CMOs/CNOs across all UC hospitals to improve hospital quality metrics, by comparing with national benchmarks and predictive values from risk-adjusted models
- Design data-driven visualization in Tableau to identify improvement opportunities with benchmarks, by drilling down 6 outcome measures to the combination of procedure and diagnosis at patient level
- Provide Tableau training and technical support in level of detail, table calculation, graphical layering
- Queried in SQL to extract back-end data, designed tables to store processed data with calculated features, and constructed stored procedures to facilitate automated ETL for front-end application
UCLA Health | Data Analyst (Volunteer), Quality Informatics & Analytics | Dec 2016-Sep 2017
- Built, published, and maintained several Tableau Dashboards, with interactive filters, actions, and parameter controls, and with periodically incoming data from internal and external sources
- Scraped text and images in unstructured format from websites and pdf files in R to build databases
- Extracted features from raw data by calculating standardized score and performing data transformation
PROVE | Marketing Data Analyst (Intern) | Sep 2014-Dec 2014
- Generated 3-4 leads per month, and tracked prospects activities from automated email drip programs
- Analyzed website traffic, brand strength, search volume, and conversion rate for clientele’s websites
- Scraped prospects databases in R, and imported more than 40,000 prospects to email drip programs
- Analyzed open/click/opt-out rate for series of personalized emails for marketing campaigns
Website and Channel
Personal Website: allenkei.weebly.com
Selected topics in R: Convolutional Neural Network using Keras for Image Recognition, Metropolis/Gibbs Sampling (Markov Chain Monte Carlo), Spectral Clustering and Community Detection for Network Data, Root Finding Algorithms and Mathematical Optimization, Variable Selection and Regularization for Linear Model, Game Development and Simulation, Unsupervised regression/classification
- Published 100+ blog posts to share knowledge of statistics, machine learning, and programming skills
- Uploaded 140+ tutorial videos for visualization, programming, machine learning, and statistics analysis
Selected topics in R: Convolutional Neural Network using Keras for Image Recognition, Metropolis/Gibbs Sampling (Markov Chain Monte Carlo), Spectral Clustering and Community Detection for Network Data, Root Finding Algorithms and Mathematical Optimization, Variable Selection and Regularization for Linear Model, Game Development and Simulation, Unsupervised regression/classification