ProArch Logo

Lewis Services Achieves 90% Efficiency Gains

With ProArch’s Dataware Data Platform

Lewis Services

About Lewis

Lewis Services is one of North America’s largest vegetation management companies. With over 4,000 staff members and 200 customers across the country, Lewis plays a critical role in the US energy infrastructure.

 

Solutions Used

 

 

Situation: Painful Invoice Processes & Time-Consuming Timesheets

Without a centralized system, Lewis’s payroll processing and customer invoicing were challenging, slow, and manual. To put it in perspective, the company processed 86,000 spreadsheets for payroll each year. This required nearly 45 full-time employees to complete, and the General Foreman had to enter the same data four times.

“The general foremen were being pulled in so many directions that it was causing inefficiencies in operations,” says Huntley Hedrick, VP of IT at Lewis.

Weekends of time-consuming work made for unhappy employees, payroll delays, slow revenue realization, and poor customer experiences.

 

Solution: Data Platform & Custom Application

Using ProArch’s Dataware Data Platform, the team integrated the HR and ERP systems into a data warehouse and then developed a custom application called “Tiempo.”

The data modeling in the background simultaneously calculates payroll and invoices based on customized rules by location, job type, pay rate, employee, and start/end time. 

 

Results: A Game-Changer All Around

  • Lewis has experienced a 90% reduction in the overall effort with a clear, streamlined process for time entry, timesheet creation, and approval.
  • Advanced reporting capabilities using data from different systems.
  • Before, Lewis experienced a high volume of invoice adjustments. Now, it is a 3% adjustment rate.
  • Customers have a better experience, and Lewis can realize revenue faster.
  • Lewis owns the tool so they can avoid future costly and complex ERP upgrades and customization.

For the general foremen, Tiempo has been transformational. Hedrick added, “What I’ve observed with the rollout of Tiempo has been greater than anything that I’ve ever seen in my career with how accepted it’s been in such a short amount of time.”

How a Data Center Technology Provider Turned Hidden Data Risks into a Microsoft Purview Roadmap

Overview

A leading data center infrastructure and technology provider designs, builds, owns, and operates advanced facilities for AI, cloud, and enterprise workloads.

As its data environment expanded across devices, applications, cloud services, Microsoft 365, and on-premises repositories, the organization needed better visibility into where sensitive information was stored, how it was being used, and which risks required immediate attention.

Services

Challenge

Sensitive information had become distributed across the organization’s growing data estate, making it difficult to understand where business-critical data resided and how it moved through the environment.

The organization needed to

  • Identify existing and hidden data security risks.
  • Discover privacy data, personal identifiers, intellectual property, and other sensitive information.
  • Locate sensitive and stale data across Microsoft 365 repositories.
  • Detect unusual or suspicious activity involving sensitive information.
  • Prioritize the risks requiring attention.
  • Map those risks to the appropriate Microsoft Purview capabilities.
Solution

ProArch delivered a structured Microsoft Data Security Engagement, deploying a targeted set of Microsoft Purview capabilities within the client’s environment.

The engagement demonstrated how the platform could improve sensitive data discovery, surface security risks, and guide prioritized remediation.

  • Automated Sensitive Data Discovery
    ProArch worked with the organization to define the sensitive information types most relevant to its business. Automated discovery capabilities were then enabled to identify sensitive information across Microsoft 365 repositories, surface stale data, and monitor unusual activity involving protected information.
  • Evidence-Based Risk Prioritization
    The Data Security Check gave stakeholders a clearer, fact-based view of the organization’s data security posture. Rather than relying on assumptions, the organization could identify which risks were most significant and determine where mitigation efforts should begin.
  • Microsoft Purview Roadmap
    ProArch mapped the identified risks to relevant Microsoft Purview products and services. The resulting recommendations established practical next steps for strengthening data protection and compliance.

Additional options—including Compliance Manager, on-premises data scanning, and Windows endpoint risk discovery—were identified as potential ways to extend protection across the organization’s broader data estate.

Outcomes
  • Improved sensitive-data visibility
    The organization gained a clearer view of where sensitive data resides and how it is used across Microsoft 365 repositories.
  • Surfaced hidden data risks
    The engagement revealed previously obscured data security exposures and unusual activity involving protected information.
  • Enabled evidence-based prioritization
    Stakeholders could focus mitigation efforts on the risks with the greatest potential business impact.
  • Clarified the Microsoft Purview path
    Identified risks were mapped to specific Microsoft Purview capabilities, creating practical next steps for protection and compliance.
  • Established a foundation for broader protection
    The roadmap gives the organization a structured way to extend protection to additional endpoints and on-premises data sources as needed.
Read the Full Story

Turn Hidden Data Risks into a Microsoft Purview Roadmap

Discover where sensitive information resides, understand the risks around it, and establish a practical plan for stronger data protection.

Explore ProArch Data Security Services

Industry

  • Data Center Infrastructure and Technology

Challenge

  • Limited visibility into sensitive data across Microsoft 365 and the broader data environment made it difficult to identify and prioritize security risks.

Solution

  • ProArch deployed targeted Microsoft Purview capabilities to discover sensitive data, surface hidden risks, and create a prioritized data security roadmap.

Result

  • The organization gained improved data visibility, evidence-based risk prioritization, and clear next steps for strengthening data protection and compliance.

Fast Track Unlocking Value from Your Data

Connect With Us