John Matthew
Fonacier

Automated a marketing workflow using Power Automate and Zapier for file movement, archiving, and SharePoint backups. Built a Microsoft Fabric–to–HubSpot integration across dev/test/prod workspaces with medallion architecture, Power BI reporting, and n8n-driven LLM writebacks for intelligent field selection.

Built an n8n workflow that handles business-hours and holiday scheduling logic, automatically moving deferred events to the next valid business day while preserving the original time-of-day — accounting for real-world edge cases rather than naive date arithmetic.

Investigated and resolved Microsoft 365 platform constraints around shared mailbox calendar invites not surfacing in personal calendars. Designed a Power Automate-based routing solution and documented the admin-level configuration requirements for reliable automation.

Architected medallion data architectures in Microsoft Fabric (bronze/silver/gold) for clients across multiple industries. Designed a centralized metadata framework on Azure SQL Database for automated data lineage, unified documentation, and pipeline governance. Delivered coordinated implementations across distributed, cross-functional teams.

Developed reusable data-quality validation and unit-testing modules for micro-batch pipelines in Microsoft Fabric, embedding in-flight checks across accuracy, completeness, and consistency dimensions to reduce issues before they reach downstream consumers.

Integrated third-party platforms — Xero, ShiftCare, Splose, Employment Hero, and Gensolve — into Microsoft Fabric using Lakehouse, Notebooks, and Data Pipelines, consolidating data into a unified medallion architecture for a services client.

Designed and built a system to extract and operationalize HubSpot CRM data beyond what the UI easily exposes — including property history, deal/contact/company activity, notes via the Engagements API, call metadata, and a workflow-based workaround to capture AI-generated call summaries (Breeze) that have no direct public API endpoint.

Built a fully automated operations workflow for a field services client covering lead capture, crew scheduling, inspection data entry, quoting, and invoicing — replacing a 21-step manual paper-based process using Microsoft Forms, Power Automate, OneNote, Excel, and Azure Storage.

Built an AI system for a professional services firm that automatically extracts key metrics from enquiry forms and conversation transcripts, then populates CRM properties without human intervention — enabling sophisticated tracking and detailed client reporting.

Designed and maintained multi-region data integration pipelines for a consumer goods enterprise, ingesting from SFTP, SharePoint, APIs, and ADLSv2 into a Medallion / Lakehouse architecture.

Built a text classification pipeline that ingests tweets directed at government accounts, processes the text, and classifies them into two categories using Naïve Bayes, SVM, and KNN models.

IoT system that automates air conditioner operation using schedules pulled from a campus information system, with an Android interface and REST API backend.

Hardware and mobile application that tests soil sample attributes and recommends cultivatable plants based on measured values.

Automated student attendance checking using ESP8266 microcontrollers with an Android companion app for real-time logging.