Business process automation
Developed production workflows for onboarding, invoicing, reporting, and IT intake at Aalis Management Consulting.
An estimated 1,200+ staff-hours returned annually across the automation programme.
The problem
Recurring administrative work—from onboarding and invoicing to monthly status reports—needed dependable, repeatable processes.
What I built and owned
Built production workflows with Power Automate, Microsoft Graph API, and PowerShell. Approval steps and draft-only outputs keep people in control of consequential decisions.
Seven inbox folders. One daily brief.
The executive briefing flow reads seven email folders in parallel, keeps the fields needed for review, and assembles an HTML digest. It replaced a sequential version of the process.
Parallel processing, focused output
- 017 email folders
- 02Parallel collection
- 03HTML digest
A single brief for the CEO
Prepare the invoice. Keep a person in control.
The workflow brings together the invoice PDF, monthly status report, and hours report, then creates an unsent draft through Microsoft Graph. A person reviews the email before sending.
Draft-only output
- 01Invoice + reports
- 02Prepare email
- 03Unsent Graph draft
Human review before sending
A repeatable monthly reporting cycle.
Three coordinated flows handle report intake, aggregation, and reminders for missing submissions. Each stage has a clear responsibility in the monthly reporting process.
Separate stages, one reporting cycle
- 01Report intake
- 02Aggregate reports
- 03Missing-report nudge
Three coordinated Power Automate flows
From approved template to reviewed offer.
The HR generator selects from eight templates, routes the offer through an approval loop, and produces the final PDF. The process keeps approval separate from preparation.
Approval stays explicit
- 018 offer templates
- 02Approval loop
- 03Final PDF
Review built into the workflow
One front door. A clear path for urgent issues.
A Microsoft Form creates a SharePoint request, notifies Teams, and feeds a daily digest. Requests marked as security concerns are automatically escalated to Urgent.
Security concerns receive urgent priority
- 01Microsoft Form
- 02SharePoint request
- 03Teams + digest
Security concern → Urgent
Project context
This work was carried out at Aalis Management Consulting. Production systems and organizational data are private.