John Nicholson

Bridging the gap between operational strategy and data.

Analytics | Data Pipelines | Applied AI

About

John Nicholson

Passionate about optimization and operational efficiency, backed by 12 years of hands-on business experience. I implemented "just-in-time" (JIT) inventory management systems in over 50 locations, using data analysis to continuously optimize inventory turnover. Weekly analysis of KPIs across several hundred clients: growth, ROI, margins, inventory turnover, delivery rates, etc., to guide purchasing, sales, and client prioritization decisions.

The need to achieve operational efficiency motivated my integration of data technologies (SQL, Python) and backend infrastructures (AI MCP servers). My extensive experience made me realize that too much time is wasted on the accumulation of minor irritants that slow down the execution of tasks related to real problems. I seek to automate these irritants to advance the projects that actually matter.

I have also learned the infrastructure behind the data, from front-end to back-end. I manage my own local home server that hosts this portfolio, Docker, MCP servers, and the PostgreSQL database that powers the live dashboard in my projects section.

I am looking for a team that values operational experience just as much as modern development skills, where I can contribute from day one and grow within the company.

Technical Stack

Python Python
SQL SQL
Tableau Tableau
Excel Excel
Google Analytics Analytics
n8n n8n
AI AI
Antigravity Antigravity
Docker Docker
Linux Linux

Projects

EN • Financial Analysis + Data Visualization

💸 The AI Economics Problem

Analysis of OpenAI and Anthropic's finances — burn rates, capital raised, compute spend, and an assessment of their path to profitability.

TableauTableau ExcelExcel CrunchbaseCrunchbase Google TrendsGoogle Trends
FR • Analyse de données + Visualisation interactive

👽Avez-vous des OVNI près de chez vous ?👽

Fusion de deux bases de données (80k+ lignes), géocodage, nettoyage SQL et visualisations pour cartographier 60 ans d'observations.

PythonPython SQLSQL PandasPandas FoliumFolium PlotlyPlotly

Verified Certifications

Click any badge to view credentials

Google Google Data Analytics Professional
AI Anthropic MCP Developer
n8n n8n Workflow Automation (Level 1)

Contact

Looking to work together? Send me a message.

📍 South Shore, Montreal, QC

Connect on LinkedIn