John Nicholson

Hi, I'm John!

Bridging the gap between operational strategy and data.

Analytics | Data Pipelines | Applied AI

About

Passionate about optimizing performance and operational efficiency through data analysis, backed by 12 years of hands-on business experience. I implemented just-in-time (JIT) inventory management systems across more than 50 locations, utilizing historical data analysis to continuously optimize inventory turnover. Conducted weekly KPI analysis for several hundred clients, including growth, ROI, margins, inventory turnover, and delivery rates, to drive purchasing, sales, and client prioritization decisions.

Today, I am scaling and automating this field expertise by connecting AI tools directly to operational data. Designing and deploying complete pipelines Example: PostgreSQL → MCP server → AI interface → live dashboard. The result: natural language analysis, automated processes, faster decisions, and insights that update in real-time, no matter where you are or what device you are using.

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

I'm 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