Joel Proctor Catching Black Swans @ AIM Personal projects and whimsical thoughts.

About

Summary


Joel brings almost a decade of experience leveraging data & analytics to drive business growth and improve operational inefficiencies. Joel has led teams of scientists & engineers, built end-to-end machine learning pipelines and developed algorithms to improve marketing and sales effectiveness - one classification model significantly reduced customer churn likelihood, increasing average revenue per sales representative by ~$400k. More recently at Brightloom, Joel developed a generalizable machine learning application and experimentation platform, offering data science-as-a-service to major fast-food and fast-casual restaurants. Additional projects include a logistics reporting solution at Lululemon, optimized marketing campaign spend by channel for Funko, a recommendation engine for the Pursuit Collection, and data governance policies and procedures for Bluetooth SIG.

Core Tech


Programming / Scripting:
  • Python: pandas, numpy, pandapy, dask, glob, scikit, hpf, seaborn, matplotlib, etc.
  • SQL, MySQL, PostgreSQL
  • DAX, Power Query, MDX
  • R: limited working knowledge. efforts of late have been focused on deepening python understanding
Tools:
  • Azure Suite: cosmos, cognitive services, machine learning studio, functions, devops, catalog, data lake storage, blob, etc.
  • AWS Suite: sagemaker, glue, s3, redshift, ec2
  • Model Management: databricks, ml flow
  • Report Development: power bi, tableau
Project Delivery:
  • Jira, Confluence, Git/GitLab/Bitbucket, Airtable, Smartsheets, et al
Primary Industries:
  • Retail: sales / demand forecasting, recommendation engine development, supply / inventory management, cltv prediction, customer segmentation
  • Finance: risk assessment, timeseries forecasting, dynamic portfolio management, valuation modeling
  • Logistics: route optimization, pricing strategy, resource strategy
  • Marketing: cac optimization, content strategy

Projects

rfm

create scoring mechanism via purchasing behavior to group customers into actionable cohorts.

GitHub

google trends

pull google trends data and format in standard R dataframe. Isolate breakout trends, search terms and trend score values for easy processing.

GitHub

ohlc manipulation

basic functions for manipulating stock prices. data is in standard dataframe format

GitHub

gender mapping

infer gender based on name.

GitHub

state shift probability model

determine probability & magnitude of of stock price swings

GitHub

arima

pull data from target sql db, perform forecast (pdq values hardcoded) and writeback forecasted values to target db.

GitHub

xgboost

binary classifier.

GitHub

Skills

Bio

Jul 2020 - Principal Consultant @ AIM Consulting
Jul 2019 - Jul 2020 Lead Consultant @ AIM Consulting
Aug 2018 - Jul 2019 Sr. Consultant @ AIM Consulting
July 2017 - Aug 2018 Analyst @ Funko
June 2016 - Founder @ Impact Group
May 2015 - June 2016 Founding Team @ Convoy
Oct 2014 - May 2015 Founder @ InstaFreight
Nov 2011 - Oct 2014 Marketing Analyst @ SoftTail Spirits
Nov 2010 - Nov 2013 Ops Manager / Pricing Analyst @ Pac-Modal Transportation