Broadway Direct Logo
CASE STUDY: SOLUTION CONSULTING

Data Consistency Solution for better decision making and increased profitability

Established in 1992, Arco construction is the 7th largest design/build general contractor in the US. ARCO offers the strength and presence of a national builder with the personalized attention of a small company. With more than 4,000 successful projects spanning 48 states, they have developed the industry-specific expertise it takes to provide the best, most cost-effective, single-source solutions and add value to every project.

Building a workflow in ARCOST

There was a data consistency issue where backup copies of the data were being used instead of original data. This issue allowed users to enter codes in whichever way they wanted resulting in bad reporting and internal confusion.

Our Solutions

We built the approval workflow in the ARCOST application. If any of the users added a code to some item, it must be first approved by the admin before it gets applied to the original data. This seemingly trivial feature made a huge difference in data consistency, eliminating errors and hence reducing business costs

Case Studies

?

Creating a document management system

Employees were used to mainly using excel spreadsheets to match or keep track of the codes. Now the challenge with spreadsheets is they are hard to manage over entire projects, especially the projects that run over a span of time. Spreadsheets involve a certain level of programming (formulae) which tend to be complicated and are likely to crash if the data size is huge. So, over a period of 1 project typically that runs for 6 months, 12 months, 18 months; people struggled in maintaining an accurate database securely. If a spreadsheet got corrupt, the entire database of the project would be lost. Basically, the business lacked a reliable tool to handle and process a huge amount of data.

Our Solutions

We added a version control and source control for spreadsheets. A document management feature was implemented where instead of a user going to the ARCOST downloading one of these special spreadsheets, they could integrate it to the SharePoint. This involved learning business-specific terminology and rules related to programming before crafting a solution for them.

project mockup

PRTG Hosted Monitoring System

No monitoring of the systems for downtime and bandwidth usage.

Our Solutions

We set up a PRTG Hosted Monitoring Solution including the configuration of the PRTG host and remote monitoring device.  Also, created custom scripts to assist in determining the status of various integration services, reporting services, and applications.

Technology Stack

Snowflake Logo
.Net Core
Microsoft SQL Server Logo
Microservices Logo
Tableau Logo
Azure Logo
.NET MVC logo
C# logo
MS Power BI Logo
Rackspace Logo

Like what you see?
Start A Project.