Aciron construction crane with blue sky

Custom Database Transforms Construction Company

How Aciron does it

When a whiteboard is involved for scheduling purposes, the process will get messy. The construction team was looking for a custom database. Aciron was brought in to create a smoother, automated scheduling application. The client would use it for jobs, requests, and seasonal information. The new web application was user-friendly and covered all of the client's needs.

What we did
  • Defining Requirements
  • Prioritizing Needs
  • Creating Storyboards
  • Developing Custom Database
Technologies
  • Microsoft .NET Framework
  • Microsoft SQL Server

The challenge

A construction company that installs and services a wide range of construction specialty products noticed inefficiencies in the way resources were being scheduled for jobs. The company was using a manual scheduling process to allocate resources assigned to jobs on any given day. Forecasting and scheduling resources was challenging, and the company was experiencing issues with overall calendar organization and job visibility.

Requesting and scheduling jobs also involved a lot of paperwork. In order to improve organizational efficiency and communication, the company was looking to move away from their manual process to a custom scheduling application. The construction company had already established a collaborative partnership with Aciron Consulting on a prior custom application project and were impressed with the results, so they reached out to Aciron again for the development of the custom scheduling application.

Aciron began the project by meeting with client stakeholders, including both project managers and schedulers, to determine current pain points in their scheduling process. Schedulers were using a whiteboard with magnets to organize the company's jobs. To thoroughly understand this manual process, Aciron performed a current state assessment. Through conversations with all of the stakeholders, the Aciron team was able to get a detailed understanding of the needs and priorities of each role, and how those needs would translate into requirements for the project. Aciron provided thoughtful feedback about the current scheduling process and gave recommendations on how to automate the process using a custom scheduling application.

Aciron construction crane with blue sky

Solution - Custom Database

Our team developed a database-driven, web-based application that streamlines the client's scheduling process. The scheduling application facilitates communication between the project managers who oversee jobs and the field service managers who assign installers to each job.

The application's user interface features drag-and-drop functionality, which makes scheduling jobs easy and intuitive. The scheduling application is also integrated with the previous custom application that Aciron had built for the client, allowing a seamless experience for users. In addition, the application has given the client more insight into their scheduling process: each user has a personalized dashboard with an up-to-date job calendar that provides an at-a-glance snapshot of all scheduled jobs, as well as any unscheduled requests. Administrators can also run reports to track inefficiencies, such as cancellations and last-minute requests from project managers.

Transform

Since implementing this new, streamlined scheduling process, the client has been able to schedule jobs more efficiently. The custom application has eliminated much of the friction that frustrated both project managers and field service managers when using the manual process, and as a result, the company has improved productivity.

Let's invent the future.

Enjoy this article?

Share it with your network.