Automation · BI · Scripting

Make the work clearer, faster, and more useful.

I use scripting, workflow automation, data, and reporting to reduce repetitive effort and give teams better information for the work in front of them.

info@mitchellstewart.ca

Core toolkit

PowerShell and Python

Power BI and SQL

Power Automate and SharePoint

Mitch Stewart - Automation

Technical scope

Automation grounded in operations.

Good automation starts with understanding the people, systems, and decisions inside a process. The result should make work easier without creating a new black box.

01

Practical automation

Replace repetitive administrative, auditing, reporting, remediation, and onboarding work with reliable PowerShell, Python, Power Automate, and Microsoft 365 solutions.

02

Operational reporting

Turn service, security, compliance, device, and business-system data into reports that help teams see trends, prioritize work, and make better decisions.

03

Data and integration

Connect systems and improve data quality with SQL, APIs, SharePoint, CRM data, Power Platform, and dependable processes for moving information between tools.

04

Maintainable solutions

Document the process, account for errors, and build solutions that support teams can understand, operate, and improve after the initial delivery.

Skills and tools

A flexible toolkit for useful outcomes.

Scripting and development

  • PowerShell
  • Python
  • SQL
  • APIs
  • VBA
  • Data transformation

Automation platforms

  • Power Automate
  • Power Platform
  • SharePoint Lists
  • Microsoft 365
  • Workflow automation
  • Remediation

Business intelligence

  • Power BI
  • Data modeling
  • Dashboard development
  • Reporting and analytics
  • CRM data
  • Operational metrics

Representative work

Projects that return time and insight.

Each project connects a technical solution to a practical improvement in service, security, visibility, or team capacity.

PowerShell · Python · Endpoint operations01

Automated client onboarding

Developed automated deployment frameworks to standardize and accelerate client onboarding, making recurring setup work more consistent and reducing manual support effort.

Faster, more repeatable onboarding

PowerShellPythonMicrosoft 365Endpoint management
Scripting · Operations · Security02

Recurring administration and remediation

Automated administrative, auditing, reporting, and remediation work across Microsoft 365 and managed devices, helping teams handle routine tasks consistently.

Less repetitive work and better consistency

PowerShellPythonIntuneMicrosoft 365
Python · Power BI · SQL03

Operational analytics and reporting

Created Python-based analytics and Power BI reports that identified recurring issues and connected operational information to useful service and management insights.

Clearer trends and better decisions

PythonPower BISQLData reporting
Power Automate · SharePoint · Power Platform04

SharePoint workflow solutions

Built SharePoint lists, approval workflows, compliance trackers, licensing monitors, and support-tracking solutions to improve visibility and reduce manual coordination.

More visible and streamlined processes

SharePointPower AutomatePower PlatformApprovals
Automation · Endpoint security · Reporting05

Device health and vulnerability reporting

Supported monitoring, patching, vulnerability tracking, and operational health across 800+ managed devices, using automation and reporting to surface follow-up work.

Better visibility across a large device estate

IntuneDefenderPowerShellPower BI
Data integration · Business platforms06

Business data connections

Connected CRM and other business-system data to reporting solutions, partnering with business teams and vendors to turn operational requirements into maintainable tools.

Trusted data for operational insight

SQLPower BICRM dataAPIs

Working approach

Build something the team can own.

01

Understand the work

Map the current process, its users, its data, and the decisions the result needs to support.

02

Build for the real environment

Choose the simplest effective tool and account for permissions, failures, handoffs, and operational ownership.

03

Measure and improve

Use reporting, documentation, and feedback to make the process clearer, more reliable, and easier to maintain.