Limited Reality

Systems integrated

46 systems across finance, property management, franchise operations, cannabis and construction. The systems someone can name are the fastest way to tell whether they have done the work before — so here they all are.

The first section is enterprise practice: fifteen years of financial systems work, most of it inside a multi-brand private equity portfolio. The second is platforms built and operated independently, where the integration detail is mine to describe fully.

Enterprise practice

Systems integrated in professional engagements. Vendor names only — no client identities, architecture or code.

SystemDepthWhat was built
QuickBooks OnlineExtensiveMulti-entity P&L consolidation across a ~90-location franchise network, with per-entity OAuth authorisation
Dynamics 365 Business CentralSubstantialERP integration and financial consolidation inputs; led a company-wide migration
Sage IntacctFocusedFinancial system integration
PaycorSubstantialEmployee, pay-item, pay-rate, punch and pay-period extraction; commission and bonus calculation feeding labour cost into P&L
StripeFocusedPayment processing and reconciliation
PlaidFocusedBank feed ingestion
YardiSubstantialNightly backup acquisition over SFTP, restore to local SQL Server including compressed and encrypted backups, then incremental replication to cloud Postgres. Ownership cascade built on the investor module
EntrataSubstantialREST extraction across leads, customers, AR codes, payments and transactions, with idempotent upsert on a schedule
Microsoft Dataverse / Power PlatformExtensiveRead/write integration against model-driven apps for incident reporting, claims, litigation, franchise management and marketing spend
METRCFocusedCannabis seed-to-sale state compliance integration with a sandbox-first proof path
MyTimeSubstantialBooking and utilisation data across two brands
Juniper SquareFocusedInvestor-management reconciliation against the ERP investor module
DocuSignFocusedE-signature write-back in the investor and deal lifecycle
EgnyteFocusedDocument repository scanned for investor tax documents feeding automated matching
YextSubstantialReview and reputation data as a governed executive measure with per-location row-level security
FreshserviceFocusedITSM webhook sync into internal platforms
Azure DevOpsSubstantialWork-item and revision extraction with watermarks, plus write-back from a custom interface
Google, Meta & TikTok AdsSubstantialPer-location marketing spend ingestion and channel-mix reporting reconciled to a total-spend headline
Azure Synapse AnalyticsExtensiveProduction PySpark runtime for recurring analytics; Delta tables with idempotent MERGE and medallion layering that applications read directly
Power BIExtensiveExecutive reporting, plus semantic-model governance — metadata coverage, naming and relationship remediation — so an app and a report agree on a definition
Azure Data Lake Storage Gen2SubstantialParquet landing zone for POS, payroll and ad-platform extracts, including cross-cloud sync from S3
Databricks & SnowflakeFocusedEvaluated and used in limited scope
Microsoft Entra IDExtensiveWorkforce SSO across the application estate, multi-tenant where brands hold separate directories, with group-based authorisation and directory-sourced access provisioning
Azure Key VaultExtensiveCentral secret custody using managed and workload identity, so no long-lived credentials sit in the deployment platform
Azure AI FoundrySubstantialModel provider for three production assistants, with model allowlisting, per-scope spend caps and a per-turn token and cost ledger

Platforms built and operated

Own products, grouped by the layer each system sits in.

Payment & bank rails

Where money actually moves.

SystemWhat it doesWhere
StripeCustomer and vendor payments in the portal, replacing manual invoice chasing · Tenant payments, stored methods, autopay · Checkout and payment attemptsPitt Landscape, 8th South Management, HJ Bullion
PaycorPayroll bridge with commission and bonus calculationEnterprise integration practice

General ledger

Where it has to be recorded correctly.

SystemWhat it doesWhere
QuickBooks OnlineBidirectional contact and accounting sync · Entity sync — customers, vendors, accounts, classes · Customers, items, tax codes, sales receipts · Multi-entity franchise P&L consolidationPitt Landscape, 8th South Management, HJ Bullion, Enterprise integration practice
QuickBooks GLJournal entries and general ledger lines mirrored daily8th South Management
Dynamics 365 Business CentralCompany-wide ERP migrationEnterprise integration practice

Operational systems

Where the work gets done.

SystemWhat it doesWhere
Microsoft GraphMail and directoryPitt Landscape, 8th South Management
CallRailCall tracking attributed to leads and contacts · Inbound call attributionPitt Landscape, 8th South Management
LMNCost codes and labour hours in by webhook, driving schedule generationPitt Landscape
Microsoft DataverseProject records written from the platformPitt Landscape
Microsoft PlannerCrew schedules generated from a master templatePitt Landscape
Google Business ProfileAutomated posting behind four duplicate-prevention layersPitt Landscape
Google AdsQualified offline conversions uploaded for closed-loop attributionPitt Landscape
Azure OpenAIContent generation and dynamic translation, behind deterministic gatesPitt Landscape
TwilioSMS to tenants and applicants8th South Management
Web PushBrowser notifications8th South Management
Google Device AccessSmart device state and event history per property8th South Management
Tenant screeningApplicant screening reports8th South Management
Metals spot feedSpot prices and daily closes every four hoursHJ Bullion
ShopifyCatalog and cost basis migrationHJ Bullion
PCGSCertification verification — NGC had no equivalent availableHJ Bullion
YardiExtraction pipeline and investor module integrationEnterprise integration practice
EntrataExtraction pipeline to a replicated databaseEnterprise integration practice

Reporting

What the executive team reads.

SystemWhat it doesWhere
Power BIOperations and sales semantic model · Executive reporting across brandsPitt Landscape, Enterprise integration practice
Google Search ConsoleSearch performance ingestionPitt Landscape

Identity & secrets

Who is allowed to see it.

SystemWhat it doesWhere
Azure Entra IDStaff SSO across five roles · Staff authentication · Identity management across brands · AuthenticationPitt Landscape, 8th South Management, Enterprise integration practice, Chargeline
WebAuthn / passkeysPasswordless authenticationPitt Landscape
Identity verificationApplicant identity checks8th South Management
Azure Key VaultSecrets under managed identityHJ Bullion
Vercel OIDCKeyless cloud authenticationHJ Bullion

Running something not on this list? Tell me what it is.