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.”

A Healthcare Organization’s Journey to Better Care Through Data Governance

About

A leading care coordination organization and Health Home supporting nearly 30,000 individuals with intellectual and developmental disabilities (IDD). The organization connects members to essential services and operates under strict healthcare compliance, privacy, and reporting requirements. Accurate, secure, and well-governed data is fundamental to their mission and daily operations.

Services

Challenge

The organization faced data quality and reporting issues due to fragmented systems:

  • Membership data spread across Choices, Medisked, and Paycom.
  • No single source of truth for reporting.
  • Inconsistent analytics requiring manual validation.

These gaps made it difficult to maintain accuracy, meet compliance needs, and support timely decision-making.

Solution

To address these challenges, the organization partnered with ProArch to design a secure, modern data strategy built on strong governance principles.

The engagement focused on two critical goals:

  • Unifying data into a centralized platform.
  • Embedding security at every layer of the data lifecycle.
Key initiatives
  • Data Security & Privacy: Role-based access controls, row-level security (RLS), encryption, and group-based permissions restricted PHI access to only authorized users.
  • HIPAA Compliance: Governance rules mapped directly to HIPAA safeguards, ensuring auditability, retention policies, and breach-prevention protocols.
  • Data Quality: Standardized business rules and automated validation eliminated discrepancies that could compromise reporting accuracy.
  • Stewardship & Accountability: Clear data ownership roles were established to ensure ongoing protection and integrity of sensitive information.
  • Lifecycle Management: Data was classified, documented, and managed from creation through archival using Microsoft Purview, strengthening oversight of PHI and PII.
Result

By embedding security-first governance into operations, the organization:

  • Reduced compliance risk with standardized privacy and security controls.
  • Strengthened protection of PHI through encryption, access policies, and continuous monitoring.
  • Increased audit readiness with accurate, trustworthy reporting.
  • Improved efficiency by eliminating redundant validation processes.
  • Gained confidence to scale analytics in a HIPAA-compliant environment.
Read the full story

Industry

  • Care Coordination & Health Home

Challenge

  • Fragmented data causing reporting and compliance issues.

Solution

  • Unified data strategy with strong governance and security.

Result

  • Accurate reporting and a secure, scalable data foundation.

Fast Track Unlocking Value from Your Data

Connect With Us