Terraphase supports the Commonwealth of Pennsylvania in managing a large-scale voluntary lead testing program for drinking water in thousands of school and childcare facilities. The program follows the United States Environmental Protection Agency (USEPA) 3Ts guidance and requires efficient coordination of enrollment, sampling, communication, and reporting to ensure public health and regulatory compliance.

Scope of Services

Terraphase developed a custom Project Management Solution (PMS) using Microsoft Office 365, PowerApps, and PowerAutomate to streamline data entry, facility tracking, and workflow automation. The system enables seamless participant enrollment, sample planning, test kit coordination with a third-party analytical laboratory, and real-time data reporting through ESdat Server and SharePoint integration.

The PMS ensures secure storage and validation of all facility-specific data, including contact information, sample results, and corrective actions. It also supports stakeholder communication by delivering user-friendly result summaries and customizable notification templates. Expert-led virtual consultations guide facilities through corrective action planning and follow-up sampling as needed.

Notable Accomplishments

• Developed and implemented a fully integrated digital platform to manage thousands of school and childcare sites’ lead in drinking water data
• Automated sample tracking, data validation, and lab coordination through Microsoft 365 tools
• Delivered real-time reporting, dashboards, and stakeholder communication templates
• Provided one-on-one expert consultation and support throughout the corrective action process
• Enabled ongoing, compliant lead in water testing with efficient data management and transparency