Thornburgh Consulting

Microsoft Admin & RPA Engineering  ·  Field Report Automation

2023 – Present  ·  Southern California

Project Overview

Thornburgh Consulting came to me with a specific challenge: their field technicians were spending hours manually transcribing field notes and building individual reports from scratch. I designed and delivered an end-to-end Robotic Process Automation (RPA) system using Microsoft Power Automate that transforms structured field data into professional formatted reports automatically — while also managing their growing fleet of Windows devices through Microsoft Intune.

The RPA Challenge

Field technicians were losing significant billable time to administrative report creation. The system needed to:

  • Capture technician field notes and site data digitally in the field
  • Automate report generation with consistent professional formatting
  • Integrate with existing business systems and storage structure
  • Handle complex conditional logic for different job types and outcomes
  • Route completed reports to the correct team members automatically
  • Manage a growing fleet of remote Windows devices securely
  • Provide responsive technical support for field teams on tight schedules

The Automation Pipeline

The full pipeline runs without manual intervention from field submission to distributed report:

Field Technician
Microsoft Forms on device
Power Automate
Conditional logic processing
Word Template
Dynamic field population
SharePoint
Archiving & metadata
Auto-Distribution
Email to stakeholders

Microsoft Forms captures structured field data including photos, locations, condition notes, and job-specific details. Power Automate flows process the submission through nested conditional logic — handling different report types, business rules, and routing logic. Word Online templates generate the final documents, which are automatically stored in SharePoint and distributed to appropriate stakeholders via email.

Services Provided

  • Created end-to-end RPA solution transforming field technician data into automated professional reports
  • Maintained fleet of Windows desktop and laptop devices using Microsoft Intune
  • Built complex Power Automate workflows with nested conditionals, OR logic in Compose blocks, and business rule automation
  • Administered Microsoft 365 tenant including Exchange, SharePoint, Teams, and user provisioning
  • Developed PowerShell scripts for organizational-wide Intune and SharePoint implementations
  • Provided day-to-day Microsoft 365 administration and on-call support for field teams

Key Achievements

Advanced RPA Development

Created sophisticated Power Automate workflows with nested conditionals, complex OR logic in Compose blocks, and custom business rule automation that eliminated manual report creation entirely.

Device Fleet Management

Implemented comprehensive Intune device management for Windows laptops, tablets, and mobile devices with automated deployment, security policies, and remote troubleshooting across the field team.

PowerShell Automation

Developed complex PowerShell scripts for organization-wide implementations in Intune, SharePoint, and other Microsoft 365 services — ensuring consistent, repeatable administration.

Best Practices Training

Provided comprehensive training on RPA best practices, device management, and workflow optimization, ensuring long-term system success and strong user adoption across the field team.

Results & Impact

75%
Report Time Reduction
Zero
Manual Reports Created
100%
Consistent Formatting
24/7
Automated Processing

Business Transformation: The RPA system fundamentally changed how Thornburgh Consulting operates in the field. Technicians submit structured data once; the automation handles everything after that — formatting, archiving, and distribution. What previously consumed hours of administrative time now happens in minutes, consistently, every time.

Service Breakdown

RPA System Design & Development

  • Power Automate workflow architecture
  • Complex conditional logic implementation
  • Business rule automation
  • Microsoft 365 suite integration

Device Management & Security

  • Microsoft Intune deployment
  • Windows device fleet management
  • Security policy implementation
  • Remote troubleshooting capabilities

Microsoft 365 Administration

  • SharePoint site configuration
  • Teams collaboration setup
  • Exchange Online management
  • User provisioning and licensing

Training & Support

  • RPA best practices training
  • User adoption strategies
  • Ongoing technical support
  • System optimization and maintenance

Technologies & Solutions

Microsoft Power Automate Microsoft Forms SharePoint Online Microsoft Lists Word Online Templates Microsoft Intune Azure AD / Entra ID Defender for Endpoint PowerShell Scripting Exchange Online Microsoft Teams OneDrive for Business
← Back to Client Portfolio