Skip to content

Selected Work

Case studies & systems built to solve real operational problems.

A cross-section of applications, reporting systems and infrastructure work delivered for professional-services and property-management organizations. Each project below links to a full case study covering the problem, the approach and the outcome.

TaskDesk — screenshot
TaskDesk
Email and meetings turned into tracked tasks, time and billing records

A production desktop application with an Android companion, built in Python on PostgreSQL, that turns client email and meeting transcripts into tracked tasks and logged time, with AI decisions kept reviewable.

Desktop AppPythonPostgreSQL
Fiscal Desk — screenshot
Fiscal Desk
Invoicing, disbursements and bank reconciliation

A production application, built in Python on PostgreSQL, that issues numbered invoices from reviewed time and disbursements and reconciles bank transactions against their supporting documents.

Financial SystemsPostgreSQLDocument Generation
Legal Reporting & Analytics on Elite 3E
SSRS reporting for three law firms

SQL Server and SSRS reporting against Elite 3E data: built from scratch at two firms and rewritten from the ground up for a third firm’s migration, across roughly 339 reports.

SSRSSQL ServerElite 3E
SSRS Vantage — Report Server Management Tool
One application for report moves, exports and backups

A custom .NET desktop application that replaced manual steps and VBScripts for promoting, exporting, backing up and comparing SSRS reports, and for reviewing schedules and subscriptions.

.NETSSRSAdministration
SharePoint Intranets & Microsoft 365 Platforms
Intranets, governance and workflow for legal and property management

Intranet portals on SharePoint Online covering more than 100 site collections, with information architecture, permissions, governance and workflow automation.

SharePoint OnlinePower AutomateSPFx
JFK Law LLP — SCC Decision Monitor
Hourly legal publication monitoring and triage

A production internal monitoring workflow that checks Supreme Court of Canada publications every hour and alerts legal users when configured matter-specific criteria are matched.

SharePoint OnlinePower AutomateRSS
Escala Residences — Water Sensor Automation
Leak alerts routed into service requests within seconds

A production workflow that parses water-leak sensor alerts, creates pre-populated service requests in the existing property-management queue, and closes requests automatically when sensors return to normal.

Microsoft 365Power AutomateProperty Management
FileDesk — Safe File Consolidation
A deterministic engine with an advisory-only local model

An active build that consolidates files from many drives. Hashes decide duplicates, a local language model only suggests, and nothing is removed without a verified match, a recorded plan and an explicit commit.

PythonSQLiteLocal LLM
RTH Utility SQL Analyzer
Early design: a reporting knowledge base for SSRS estates

An exploratory workbench, in early design, for cataloguing SSRS reports, dataset SQL and schema dependencies so related reports can be compared on evidence.

SQL ServerSSRSExploratory
Infrastructure, Remote Management & Resilience
Remote administration, backup and recovery planning

Practical infrastructure work covering remote administration, database platforms, backup workflows, monitoring and resilient access to distributed systems.

InfrastructureMonitoringBackup & Recovery
Automation & Systems Administration Toolkit — screenshot
Automation & Systems Administration Toolkit
PowerShell, SQL and Python tools for operational support

A curated, filterable library of scripts and tools for administration, migration, diagnostics, reporting and repeatable operational support.

PowerShellSQLPython