Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

21.04.26 01:33 PM

Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

Case Study

Client: City of Winnipeg

Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

Case Study

Client: City of Winnipeg

Client Challenge

The client was struggling with disparate systems and manual processes for handling job evaluations and accessibility service applications. They conducted 3,000 job evaluations annually but relied on three separate systems for storing and managing data, resulting in inefficiencies, duplicated efforts, and lack of a unified view. Historical records needed consolidation to streamline workflows and improve transparency in decision-making.

Additionally, their accessibility service application process was complex, involving multi-step approvals and conditional workflows. The workflows were prone to errors and delays due to the limitations of their existing manual processes, impacting overall efficiency and user satisfaction.

Our Solution

Bauer Automate’s Customized Solution for the Client’s Challenge

Leveraging Documentation Tools for a Streamlined Start

We utilized tools like Scribe and Power Docu to create a minimum viable product (MVP) for documenting workflows and processes. These tools enabled quick generation of Word documents, Visio diagrams, and Excel summaries, providing a foundation for continuous improvement without delaying project timelines.

Unified Job Evaluation System

Built a centralized Power Platform solution to manage job evaluations.
Consolidated 7,000–8,000 historical records from three systems into a single, user-friendly interface.
Utilized SharePoint lists and a document set library to categorize and store related documents, ensuring compliance and accessibility for audits.

Advanced Workflow Automation

Developed 200+ step workflows for approvals and notifications.
Implemented conditional branching to handle complex scenarios, such as approval stages and status updates.
Incorporated Teams notifications and external email approvals, allowing stakeholders (e.g., Union Reps) to provide input seamlessly.

Transit Plus Accessibility Application

Created a streamlined solution for managing accessibility applications, including those for wheelchair-compatible vehicles.
Designed a multi-level approval workflow with conditional branching for user choices and approvals.
Integrated 350+ components, including database tables, workflows, and Power Apps, to ensure a comprehensive, scalable solution.

Results

100% Consolidation

of historical records into a
unified system.

350+ Solution Components

managed, ensuring scalability for

future applications.

20% Approval Time Saved

with integrated Teams and

email notifications.

35% Reduced
Processing Time

for job evaluations through

automated workflows.

40% Decrease in
Workflow Errors

with conditional branching and

automated notifications.

30% increase
in data accuracy

eliminating manual entry across

three different systems.

Summary

Unified Processes for Improved Efficiency

Consolidating historical records and workflows into a single system improved visibility, accuracy, and ease of use, enabling the client to manage evaluations and applications more effectively.

Scalable Automation for Complex Workflows

Automated multi-level workflows with conditional branching and external input capabilities streamlined approvals and reduced processing time for job evaluations and accessibility applications.

Rapid Documentation to Support Success

With tools like Scribe and Power Docu, the client achieved quick documentation of workflows and processes, setting a foundation for continuous improvement and better communication across teams.

Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

Streamlining Job Evaluation and Accessibility Services with Power Platform Solutions

Client Challenge

Our Solution