Loading...

Louis Millette

Data Engineer & Analytics Consultant

Python • SQL • Tableau • Power BI • AI & Machine Learning • AWS

ABOUT ME

Data Engineer & Analytics Consultant

8+ YEARS TURNING DATA INTO BUSINESS OUTCOMES

I build data pipelines, analytics dashboards, and predictive models that help organizations make faster, smarter decisions. From Python microservices and SQL Server ETL to Tableau, Power BI, and AI/ML — I work across the full data stack. I hold a Bachelor of Mathematics (Honours Statistics) from the University of Waterloo.

SKILLS

My core competencies

  • DATA ENGINEERING

    SQL Server, PostgreSQL, MySQL, Snowflake. Python ETL microservices, SSRS, stored procedures, Git & Bitbucket.

  • ANALYTICS & BI

    Tableau (50+ dashboards, Tableau Cloud), Power BI, Looker, R Markdown, Excel / PowerPivot, SSRS reports.

  • AI & MACHINE LEARNING

    Python (SciPy, Pandas), GLM statistical modeling, Keras, TensorFlow. Predictive models for business decisioning.

  • SOFTWARE ENGINEERING

    Python, JavaScript, PHP, C#, PowerShell, Bash. Full-stack dev, REST & SOAP APIs, Django, Flask, Jenkins CI.

PROJECTS

Selected work & personal projects

  • Rentflation
    RENTFLATION

    Inflation-adjusted rent analysis over 10 years — Python, Pandas & Tableau

  • Zillow Plugin
    ZILLOW PLUGIN

    Browser extension — VUE, AWS Lambda, JS for real estate analysis

  • Covid Prevalence
    COVID PREVALENCE

    Asymptomatic COVID-19 probability analysis using Bayesian statistics

  • Property Calculator
    PROPERTY CALCULATOR

    Property investment returns vs the S&P 500

  • Mutual Funds
    REVERSE ENGINEERING MUTUAL FUNDS

    Math behind annuities, MERs, dividends, and fund returns

  • Home Prices
    AMERICA'S HOME PRICES

    Biggest US cities' home price data visualization

  • CIBC Secret API
    CIBC'S SECRET API

    Python package for CIBC's undocumented banking API

  • Secret Santa
    SECRET SANTA PROBABILITY

    Using probability theory to determine your Secret Santa

  • UWflowbot
    UWFLOWBOT

    Bot for University of Waterloo's course review site

  • Investment Returns
    INVESTMENT RETURNS

    Why early S&P 500 returns may not matter as much

  • Investment Calculator
    INVESTMENT CALCULATOR

    Returns, taxes, dividends, MERs, and inflation calculator

  • UWtext
    UWTEXT

    Buy the cheapest textbooks, every time

  • Subletting With ML
    SUBLETTING WITH ML

    Facebook, Twilio, Python & ML to beat the housing market

  • Index Fund Returns
    INDEX FUND RETURNS

    After taxes, management fees, inflation, and dividends

  • Home-Made Annuity
    HOME-MADE ANNUITY

    Real-world annuity model built from any investment type

  • CIBC Banking Template
    CIBC BANKING TEMPLATE

    Burndown-chart bank statement via reverse-engineered API