Case Studies
ISO 9000 documentation and regulatory compliance database for multi-site oil manufacturing
A multi-site oil manufacturing operation needed to consolidate ISO 9000 quality documentation across 25 facilities into a single regulatory compliance database. PCG built a centralized system that managed 50,000+ document records across the operation, replacing spreadsheets and disconnected SharePoint folders with one platform that produced audit-ready output for ISO recertification cycles and internal quality reviews.
OSHA training and certification system for a Fortune 500 oil and gas facility
A Fortune 500 oil and gas operator needed a custom OSHA training and certification platform with badge integration, automated recertification triggers, and real-time training compliance reporting across multiple facilities. PCG built the system, achieving a 100 percent training compliance efficiency rating and removing the manual reconciliation work that had absorbed safety staff time across the operation.
EPA Title V air quality management system for a Fortune 100 oil refinery
A Fortune 100 oil refinery needed a custom application to support an EPA Title V Clean Air Act permit application for an emissions upgrade. The system handled tens of thousands of emissions calculations, worst-case and best-case scenario modeling, complete audit trail documentation, and regulatory reporting to DEP and EPA. The permit was approved. The same system became the facility's compliance tracking platform after approval.
Soil remediation tracking system for an EPA Superfund cleanup site
An EPA Superfund cleanup operation needed to track contaminated soil from excavation through transport, treatment, and final disposal across an active multi-year remediation. PCG built a system covering source-to-destination chain of custody, forward projection of remaining contaminated soil volumes, and regulatory reporting to EPA Superfund program officers. The system became the canonical record of what the cleanup actually moved and where it ended up.
Ground water monitoring and charting system for environmental compliance
An environmental compliance company needed time-series ground water monitoring with charting, anomaly detection, and regulatory reporting across multiple monitored sites. PCG built a system that captured well-by-well sample data, charted contaminant trends over time, flagged threshold exceedances automatically, and produced the regulatory output the operation submitted to state environmental agencies.
Pest control central reporting engine for multi-office compliance
A pest control operation running across multiple offices needed central reporting of FIFRA-regulated pesticide application records, applicator licensing tracking, and consolidated compliance output across the full multi-office footprint. PCG built a central reporting engine that consolidated office-level data into one operational view, removing the manual reconciliation work between offices that had become a structural drag on the operation.
Insect trap management system for vineyard invasive species compliance
A commercial vineyard operating under USDA APHIS Spotted Lanternfly compliance requirements needed an insect trap management system covering trap placement, inspection cycles, capture data, and regulatory reporting. PCG built a system that documented every trap location across the vineyard, tracked inspection-by-inspection capture data, and produced the regulatory output APHIS field officers expected during compliance review.
Pesticide licensing compliance system for a state government regulatory program
A state government regulatory program responsible for licensing pesticide manufacturers, distributors, and applicators needed to consolidate four separate Microsoft Access databases into one centralized SQL Server platform. PCG executed the multi-database merge with zero data loss, met state government IT security requirements at server and database tiers, integrated specialty printer support for license issuance, and unified payment, renewal accounting, and regulatory records on one system.
Material Safety Data Sheet (MSDS/SDS) management system for chemical production and shipping compliance
A chemical production and shipping company handling highly toxic and hazardous chemicals needed a turnkey MSDS and SDS management system covering chemical inventory, batch-level tracking, manifest production, transportation labels, and storage signage from a single database. PCG built the system in Visual Basic 6 with Microsoft Access, supporting multiple chemical production and shipping clients with their own package deployment requirements from one architecture.
Secure, scalable fueling system for a top-5 U.S. metro fleet
A major U.S. city's legacy fueling system was crashing daily, logging transactions inaccurately, and transmitting unencrypted vehicle whitelists across cellular connections. PCG rebuilt the platform from the ground up in .NET Core with a proprietary compression-encryption protocol, ruggedized hardware integration across 65 sites, and real-time centralized monitoring across 50+ city departments.
End-to-end scheduling, credentialing, and payroll system for a multi-facility physician staffing company
A physician staffing firm managing 100+ contracted doctors across 30+ hospitals was running on spreadsheets and a basic scheduling app that could not handle credentialing, compliance, or variable-contract payroll at scale. PCG built a full staffing lifecycle platform covering scheduling, credentialing, physician self-service time entry, contract-based payroll, and automated facility invoicing.
Ground support equipment (GSE) management system for airport operations
Airport ground operations teams were tracking a complex multi-terminal fleet of tugs, belt loaders, air starters, and GPUs on whiteboards and spreadsheets. Missed maintenance cycles were causing breakdowns. Inventory discrepancies were routine. PCG built a modular GSE management platform with real-time equipment status, usage-based maintenance triggers, parts inventory control, and personnel certification tracking.
Industries PCG has built production software for
The 12 case studies above represent a fraction of 31 years of documented work. PCG has delivered custom software in industries where a failure is not an inconvenience but a regulatory event, a safety incident, or an operational shutdown.
What these projects have in common
Every project on this page started with an operation that was running on software it had outgrown. The Fortune 100 refinery's emissions calculations were spread across spreadsheets that could not survive a Title V permit review. The state pesticide program ran across four databases that no longer agreed with each other. The chemical shipping company's MSDS, manifests, and labels referenced the same chemicals with different data. The airport's ground team had no real-time view of their own equipment. The city's fueling system was crashing. In every case, the problem had been accumulating for a long time before a decision was made to fix it.
PCG was not called in as a vendor to deliver a product. The work started with understanding exactly what the existing system did, where it was failing, and what the operation actually needed. That diagnostic work is the part most software projects skip. It is also the part that determines whether a deployment goes smoothly or produces a second round of problems six months later.
Most of the platforms documented here were built on .NET Core with SQL Server, hosted and supported by PCG after deployment. Some legacy systems were preserved in Visual Basic 6 with Microsoft Access where the architecture made operational sense and migration would have introduced unnecessary disruption. Each client owns their source code. None of them were sold a platform and then left to figure out the rest.
All metrics cited on this page are drawn from PCG's internal project documentation. Specific identifying details about clients have been generalized at client request where applicable. PCG founded 1995. Allison Woolbert's personal experience in software development predates PCG's founding.