Alec James McCarthy

Analyst and Poker Player working towards creating value on a larger scale


SQL HR Analytics

Data manipulation language for updating fields. Refactor SQL views with optimized design for efficient computation. Complex queries to analyze attrition. Million+ row dataset.

Python ETL and Machine Learning

Web scraping player specific data. KMeans clustering to classify pitchers based on BaseballSavant advanced metrics. PandaSQL to join data from user-selected inputs. Bayesian data analysis to evaluate hitter statistics.

SQL View GitHub Profile Python