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

On Prem to Cloud First: Nonprofit Eliminates MSP Dependency with Microsoft Intune and Microsoft 365

About the Client

A Central New York nonprofit relied on MSP-hosted infrastructure for email, files, identity, and its core line-of-business applications, creating slow turnaround times, limited visibility, and heavy on-prem dependency.

ProArch delivered a cloud-first roadmap using Microsoft 365, Microsoft Intune, and Microsoft Entra ID to modernize identity, endpoints, and application access without disrupting day-to-day operations.

Services

  • Microsoft Intune Endpoint Management Implementation
  • Microsoft 365 Migration
  • Cloud Identity Modernization with Microsoft Entra ID
  • Managed SOC Services
  • Datacenter Exit Planning and Execution
Challenge

Infrastructure Controlled by MSP with Limited Visibility

Every day, the 80 employees of a nonprofit human services agency in Central New York started work by asking someone else’s infrastructure for permission.

With limited visibility, growing delays, and no real control over their own systems, leadership reached a breaking point and reached out to ProArch to find a better way forward.

  • MSP-controlled infrastructure: Email, files, Active Directory, and the LOB application lived in a private datacenter owned and controlled by the MSP limiting transparency.
  • On-prem dependency for day-to-day IT: ~100 Windows endpoints were domain-joined, so policies, patching, provisioning, and support relied on connectivity to the MSP network.
  • Slow operations driven by onsite device imaging, MSP managed patching, network dependent security policies, and VPN based remote support.
  • Remote work constraints: Access and manageability were bound to the corporate network limiting secure productivity from any location.
Solution

A Phased Cloud-First Migration for Non-Profits

ProArch started with an environmental assessment and laid out a clear architectural goal: eliminate every dependency on the MSP's datacenter and rebuild the organization's IT foundation in the cloud.

As organizations face increasing uncertainty in the tech landscape, it’s crucial to look for solutions that not only meet current needs but also set you up for future success.

— Jim Spingardo, Dir. Cloud Strategy & AI Enablement

The migration happened in three structured phases, designed so that staff never felt the transition.

Phase 1: Taking Back Control of the IT Infrastructure

ProArch migrated all servers in a single 10–12-hour window, applying DNS and network changes, running system acceptance tests, and bringing services back online.

Phase 2: Migrating to Microsoft 365

Over eight weeks, each on-premises server workload was removed and replaced with a cloud equivalent

  • On-premises Exchange → Exchange Online. Mailboxes migrated with no disruption to daily operations.
  • Windows File Servers → SharePoint Online and OneDrive for Business, preserving the familiar mapped-drive experience staff relied on.
  • Active Directory → Microsoft Entra ID via Entra Connect sync, then full cloud identity. On-prem domain controllers fully decommissioned.
  • Primary LOB application → migrated from a Citrix session in the MSP’s facility to a cloud-based SaaS solution accessible from any browser.

Phase 3: Modernizing Endpoint Management with Microsoft Intune

ProArch moved all device management to Microsoft Intune, eliminating their last on-premises infrastructure

  • New Windows devices enrolled directly into Intune via Entra join no imaging, no on-site setup required.
  • Security baselines, software deployments, Wi-Fi profiles, and application policies were delivered via Intune configuration profiles. Policies applied to the device regardless of network location.
  • BitLocker encryption, screen lock, and OS version compliance enforced automatically. Non-compliant devices blocked from organizational resources via Conditional Access.
  • ProArch’s team gained full Intune remote management: push apps, push patches, wipe or reset devices, and read device logs entirely over the internet from anywhere, to any enrolled device.
Outcomes

With Microsoft 365, Microsoft Entra ID, and Microsoft Intune as the foundation, the organization now has an IT model designed for mobility secure by default, cloud-managed, and scalable as the organization grows.

  • Replaced Citrix with a cloud SaaS LOB application removing infrastructure complexity, licensing costs, and vendor lock-in.
  • Microsoft Intune Endpoint Management enabled end-point management including remote provisioning, patching, and proactive support without onsite visits cutting response times and operational overhead.
  • Identity modernized with Microsoft Entra join and Conditional Access, removing domain controllers and VPNs while enforcing compliance-based access from any location.
  • All server-based workloads eliminated through Exchange Online, SharePoint Online, and OneDrive improving reliability, scalability, and end-user access to collaboration tools.
  • Direct internet connectivity at every site improved application performance and removed dependency on an MSP-managed network.
  • IT operating model transformed from reactive and onsite to fully remote and proactive, with a scalable security foundation including MFA, Intune compliance baselines, and ProArch’s 24/7 managed SOC services.
Read the Full Story

Dealing with MSP lock-in or an on-prem environment that can’t support remote work?

Talk to Our Experts

Industry

  • Non-Profit

Challenge

  • An MSP-controlled, on-premises environment left the organization with limited visibility, slow operations, and complete dependency for everyday IT.

Solution

  • A phased migration approach begins with gaining control of the on-premises environment, followed by migrating to Microsoft 365, and then modernizing endpoint management using Microsoft Intune.

Result

  • Modernized IT through a cloud-first model with Microsoft cloud services, delivering greater independence, flexibility, and control.

Fast Track Unlocking Value from Your Data

Connect With Us