Case Studies

    Real work.
    Documented clearly.

    Every engagement starts with a problem worth solving — and ends with a system that holds. Here's what that looks like in practice.

    Featured Case
    EnterpriseAzure Data FactoryData EngineeringDelivery Standards

    Building an Azure Data Factory Delivery Foundation

    New pipelines became faster to author and easier to review. Environment promotions stopped being a manual guessing exercise, and onboarding shifted from weeks of tribal knowledge to a repeatable path grounded in the shared patterns.

    Reusable
    Pipeline patterns
    Standardized
    Environment promotion
    Faster
    Engineer onboarding
    Materially improved
    Delivery consistency

    The Problem

    A cross-functional data team was building Azure Data Factory pipelines without shared standards. Every new pipeline was authored differently, environments drifted, and small changes required re-learning how the previous engineer had wired things up. Onboarding new engineers took weeks and defects surfaced late.

    The Approach

    I established a reusable delivery foundation for the team: standardized pipeline patterns, parameterization conventions, environment-aware linked services, and a source-controlled repo structure with a defined promotion path across environments. I paired with engineers on the first migrations so the patterns were understood in practice, not just documented.

    More Engagements

    More work. More industries.

    HealthcareEHRIntegrationC#SQL Server

    Healthcare EHR Integration — TouchWorks & IntelleChartPro

    The Problem

    Clinical workflows depended on two Electronic Health Record systems that didn't share data cleanly. Staff were re-keying information, reconciling mismatched records, and building manual workarounds — introducing risk and slowing patient-facing work.

    The Approach

    I designed and implemented integration services between TouchWorks and IntelleChartPro, mapping data models across systems and building reliable, observable data flows. The work included clear ownership boundaries between systems, defensive handling for partial data, and a tested path for recovery when upstream systems misbehaved.

    The Outcome

    Clinical data moved between systems reliably, reducing duplicate entry and the reconciliation burden on staff. Downstream reporting and patient workflows became meaningfully more trustworthy because the source of truth was clear at every step.

    Outcomes
    Reduced
    Duplicate data entry
    Automated
    Cross-system reconciliation
    Improved
    Clinical data reliability
    2 EHRs
    Systems integrated
    HealthcareRemote IntakeRapid DeliveryAngular

    Remote Patient Intake During COVID-19

    The Problem

    When in-person intake became unsafe overnight, the provider needed a way to capture patient information remotely without disrupting downstream clinical systems. Existing paper and in-office workflows assumed the patient and staff were in the same room.

    The Approach

    I helped deliver a remote patient intake workflow on a compressed timeline: a web-facing intake experience, backend services to validate and route submissions, and integrations that landed the data cleanly in the systems clinicians already used. Scope was ruthlessly prioritized to what actually enabled care to continue.

    The Outcome

    Patients could complete intake safely from home, staff received structured information ahead of visits, and the provider maintained continuity of care through a period when most workflows were being reinvented in real time.

    Outcomes
    Eliminated
    In-person intake dependency
    Compressed
    Delivery timeline
    Maintained
    Care continuity
    Preserved
    Downstream systems
    EnterpriseSQL ServerAzure DevOpsSource ControlDeployment Automation

    Database Source Control & Deployment Automation

    The Problem

    Application code was in source control and shipped through a pipeline, but database changes were still hand-applied. Environments drifted, deployments required a specific person to be on the call, and rollbacks were an anxiety event rather than a routine.

    The Approach

    I brought the database under source control alongside the application, defined a repeatable schema change and deployment process, and wired it into the existing Azure DevOps pipelines. Every environment reached the same state through the same automated path, with a clear review trail for schema changes.

    The Outcome

    Schema drift went away. Deployments stopped depending on a single person's presence, and the team could trust that what shipped to production had already been proven through the earlier environments.

    Outcomes
    Reduced
    Manual deploy steps
    Eliminated
    Environment drift
    Removed
    Deployment key-person risk
    Full
    Schema change auditability

    Want the Frameworks?

    Read the thinking behind the work.

    The blog unpacks the systems, frameworks, and principles that drive every engagement — written clearly, for free.