Case Study: OSHA Training & Certification System for a Fortune 500 Oil and Gas Facility
What was breaking in the facility's OSHA training compliance before this project?
The client was operating a Fortune 500 oil and gas chemical processing facility with an outdated OSHA training management system. The legacy system could record attendance at training sessions but could not reliably flag certification gaps, manage instructor qualifications, or produce the documentation that government agencies and internal supervisory staff required during audits and incident reviews. In a volatile oil and gas chemical processing environment, an employee who has not completed required OSHA training is a liability, not just a compliance gap.
The complexity went beyond OSHA itself. The facility had to handle internal corporate training policies on top of federal OSHA requirements, including specialized training curricula, secured testing, grading, certification hard copies, continuing education credits for instructors, and classroom scheduling across multiple facility locations. The most consequential requirement was the badge management integration. An employee whose certifications had lapsed needed to be physically prevented from entering restricted areas, which meant the training database had to connect directly to the facility's access control system rather than living as a separate compliance record.
For a Fortune 500 oil and gas operator, the consequences of an OSHA finding extend beyond the citation itself. Regulatory violations affect contract eligibility with government and corporate customers, raise insurance premiums, and create reportable incidents that follow the operation through subsequent audits. A training management system that could not flag gaps before they surfaced as violations was a continuous risk multiplier for the facility.
What did PCG actually build for the OSHA training and certification environment?
PCG built a unified training management platform in Microsoft Access with VBA, sectioned into the major functional areas that trainers and administrators needed to operate independently. The interface was designed for non-technical staff, which mattered in an environment where the people using the system every day were safety professionals and training coordinators, not database administrators. Each component was built so that the OSHA documentation required by auditors was captured at the moment training happened rather than reconstructed afterward.
Every employee's certification status was tracked across the full set of OSHA-required training categories applicable to oil and gas chemical processing. Records included the date of training, the instructor, the test results, the certification expiration date, and the audit trail of recertifications. When a certification lapsed or a mandatory training session was missed, the system flagged it automatically and notified the relevant supervisors.
Instructor qualifications were tracked as a separate module, covering qualifications to teach specific courses, continuing education credits, and curriculum certifications. An instructor whose credentials had lapsed could not be scheduled for a course they were no longer qualified to teach. For OSHA compliance purposes, the qualifications of the instructor delivering the training are part of the audit record, not just the attendance of the employees receiving it.
Class schedules, classroom locations, and facility utilization were managed within the same system. Sessions were scheduled against instructor availability, classroom capacity, and the certification deadlines of the employees who needed each training. Equipment inventory required for hands-on training modules was tracked alongside the schedule.
The training database was connected directly to the facility's badge management system. Employees whose certifications were not current were automatically blocked from accessing restricted areas of the facility. The training record and the physical access control became the same operational system. An employee with lapsed training could not simply walk past a turnstile because the badge system already knew about the lapse.
The system generated automated alerts for compliance gaps, expired certifications, failed tests requiring remediation, and upcoming recertification deadlines. Mass email handled scheduling announcements and sign-off sheet distribution for attendance records. OSHA audit documentation was produced as structured queries against the live system rather than manually assembled from filing cabinets at the moment of inspection.
OSHA compliance in a Fortune 500 oil and gas environment is not primarily a documentation problem. It is an enforcement problem. The question is not whether the operator can produce a training record on demand, but whether the operator can prevent an uncertified employee from physically being in a place where regulations say they should not be. Training records that live separately from physical access control depend on human enforcement at every entry point, which means they fail eventually. Training records connected to badge access enforce themselves automatically and continuously.
The decision to build in Microsoft Access with VBA, rather than a heavier platform, was deliberate for this client. The facility had existing IT infrastructure, internal staff capable of supporting Access systems, and a requirement that the interface be operable by safety professionals without database training. A purpose-built application in Access with VBA delivered the integration and automation the facility needed at a fraction of the cost and time of a packaged enterprise EHS platform, and it integrated directly with the badge system the facility already operated.
What changed after the system went into production?
The most immediate operational change was that compliance gaps stopped requiring human discovery. The system surfaced expired certifications, missed training, and instructor credential lapses automatically, before they became OSHA violations. The facility moved from a reactive posture, where gaps were found during audits or incidents, to a continuous enforcement posture where gaps could not be ignored because the badge system would not let the employee into the restricted area until the gap was closed.
| Outcome | Result | How it was achieved |
|---|---|---|
| Training efficiency rating | 100% | Automated gap detection, scheduling against deadlines, and instructor credential validation |
| Paper filing position | Eliminated (1 FTE) | Automated documentation capture replaced manual filing of certifications and attendance records |
| OSHA audit response | Structured queries, not file searches | Live system data replaced filing cabinet retrieval during inspections and reviews |
| Restricted area access enforcement | Automatic and continuous | Badge system integration physically prevented entry by employees with lapsed certifications |
| Compliance gap detection | Real-time | Automated alerts to supervisors as gaps occurred, not after they became violations |
| Instructor credential validation | Enforced at scheduling | Lapsed instructor credentials prevented scheduling for courses no longer qualified to teach |
The strategic value of the system extended beyond the OSHA compliance posture itself. The facility's ability to demonstrate continuous training enforcement and audit-ready documentation became a credential in its own right with corporate customers, government contractors, and insurance underwriters. Operations that had previously absorbed the cost of dedicated paper-filing staff and manual gap reviews redirected that capacity toward the actual safety work the facility existed to do.
What capabilities does this kind of system provide for industrial safety operations?
The infrastructure built for this Fortune 500 oil and gas facility addresses a problem class that appears across every regulated industrial operation with OSHA training obligations. The capabilities below apply to oil and gas, chemical processing, manufacturing, mining, construction, environmental services, and any operation where worker certification is a continuous regulatory requirement and where uncertified workers in the wrong place create real liability.
Training records connected directly to badge management or facility access control. Employees whose certifications lapse are automatically prevented from entering restricted areas, removing the dependency on human enforcement at every entry point.
Expired certifications, missed mandatory training, failed tests, and upcoming recertification deadlines flagged automatically as they occur. Supervisors receive alerts in real time rather than discovering gaps during audits or after incidents.
Instructor qualifications, continuing education credits, and curriculum certifications tracked as part of the same system. Instructors with lapsed credentials cannot be scheduled for courses they are no longer qualified to teach, which protects the audit value of the training itself.
OSHA inspection responses, internal audit submissions, and corporate compliance reviews answered through structured queries against the live system. The filing cabinet retrieval that consumes staff time during every audit cycle is replaced with on-demand reporting.
Technology stack
| Component | Technology |
|---|---|
| Database and application layer | Microsoft Access with Visual Basic for Applications (VBA) |
| Access control integration | Direct integration with facility badge management system |
| Training records | Employee certification, attendance, testing, and recertification tracking |
| Instructor management | Credential, qualification, continuing education, and curriculum tracking |
| Scheduling | Class schedules, classroom utilization, equipment inventory, and instructor availability |
| Alerts and notifications | Automated gap detection with email notification to supervisors |
| Mass email | Bulk notification for scheduling and sign-off sheet distribution |
| Compliance framework | OSHA training requirements with corporate policy overlay |
Does this apply if your operation is smaller than a Fortune 500 facility?
The architecture scales down as well as up. A regional industrial operator with a single facility faces the same core problems as a Fortune 500 multi-site operation: certification gaps that go undetected, training records that live separately from access control, instructor credential validation that depends on manual review, and audit response that becomes a paper-search project. The engineering decisions on this project, particularly the badge integration and the automated gap detection layer, are directly applicable to operations of any industrial scale.
What makes this project transferable is not the size of the client. It is the problem class. Any industrial operation under OSHA jurisdiction is carrying the same enforcement risk this Fortune 500 facility was carrying before the system went live. The risk accumulates invisibly until an inspector arrives, an incident occurs, or an internal audit surfaces a pattern of gaps that have been going undetected for months. A training management system that detects and prevents those gaps continuously changes the operator's relationship with OSHA from reactive to enforced.
PCG has built industrial safety and OSHA compliance infrastructure for Fortune 500 and mid-market operators since 1995. The work documented here is one of more than 500 production applications PCG has delivered, with environmental and regulatory compliance representing approximately one-third of that volume across 31 years.
Frequently asked questions about OSHA training and certification systems
Allison has been building custom software since the early 1980s, including work as a data analyst for the U.S. Air Force before founding PCG in 1995. The OSHA training and certification system documented here is one of more than 500 custom applications PCG has delivered, with environmental and regulatory compliance representing approximately one-third of that volume across 31 years. Her direct involvement in every project is not a policy. It is how PCG operates. When you call, she answers.
Project details documented with client permission. Specific identifying details about the Fortune 500 oil and gas chemical processing facility have been generalized at client request. System capabilities and outcomes reflect the actual production deployment.
PCG founded 1995. Allison Woolbert's personal experience in software development predates PCG's founding.