Regulatory compliance takes accurate management of complex rules and monitoring. At PCG, we can ensure professional tracking of your obligations and improve evaluation.
Soil Remediation Tracking (Microsoft Access / Microsoft Excel)
Developed spreadsheets and databases to track soil remediation from a Superfund cleanup site. Systems tracked how much soil was taken, locations of soil, testing results, and how much remained. The calculation engine was written to project out how much soil still remained based on contamination levels on testing.
OSHA Training Monitor System (Visual Basic for Applications / Microsoft Access)
Under constant and consistent OSHA regulation and compliance with the DEP's Clean Air Act, this multinational client required an OSHA training management system designed to document, track, and record proper course verification, attendance by employees, and course completion. Reports of the employee training, updates, and progress was submitted to relevant government offices and organizational supervisory staff. By comparing scheduled mandatory training sessions with tracked attendance records, all employees could be followed via reporting functionality. Any deficiency, or gap in any employee's, or groups of employees training and attendance was immediately "flagged, reported, and appropriately addressed.
In addition, training instructor credentials were investigated, tracked as to their qualifications to teach, continuing education credits, and curriculum management class scheduling. The Phoenix Consultants Group application included mass-mailing capability for announcements, scheduling, and sign-off sheets for attendance records.
This project was one of three required by this client. Please refer to the others to develop an understanding of PCG capabilities.
EPA Emissions Monitoring System (Visual Basic for Applications / Microsoft Access / Microsoft Excel)
By working hand-in-hand with the Phoenix Consultants Group's OSHA Compliance Management application, this project specifically focused on the DEP's Clean Air Act permit application. PCG's database development design accommodated multi-user regulatory compliance databases to facilitate the filing of proper New Jersey DEP and federal DEP applications for this client's Clean Air Act permit.
Tracking thousands of fields from an Excel Spreadsheet and automating calculations to effectively monitor all devices (plant devices that were "online", such as control valves, flow adapters, pressure sensors, etc.), PCG integrated an "add-on" in Excel called Solver to run "best" and "worst-case" scenarios, Solver focused on changes in realtime flows and pressures and how those changes would affect emission statistics. By performing real-time analytic scenarios, this client could and did develop higher production efficiency while maintaining compliance with the Clean Air Act.
Great Plains Inventory Management (Visual Basic / Microsoft Access / Microsoft Excel)
Designed and implemented a custom VB application to convert current stock numbers, vendor numbers, and other core system accounting numbers to a user format for the Great Plains Accounting Software. Conversion routines were written in VB5 and access to convert the companies master file.
MSDS Automation System (Visual Basic for Applications / Microsoft Access / Microsoft Excel / Outlook)
Our challenge in this project was the adaptation of database functionality to inventory tracking of chemical products sold by multiple chemical production and shipping companies.
PCG was approached by this client wanting a "turn-key" product to match, select, and include the mandatory Material Data Safety Sheets. Components safety labels customization was required for shipping potentially hazardous materials. It was designed to track the inventory of companies that ship chemical products around the US. Each chemical must have a Material Data Saftey Sheet attached to it and a proper marker/sticker/sign that reflects how the chemical is to be eliminated or neutralized dependent upon the type of spill (ie; oil goes into a river, how do you fix it). This database printed thermal labels to allow the company to produce the proper labels to affix to packages. Additionally, location and inventory control of the stock levels of the chemicals was written into this database to facilitate the location of all products at any given time to ensure compliance with OSHA.
Marine Terminal Management System (Visual Basic / ASP / SQL Server / Microsoft Access / Microsoft Excel / Outlook)
Phoenix Consultants created and implemented their corporate-wide Marine Terminal Database System 2000 (MTDBA) for a previous client returning for advanced management and logistical help with their fleet of shipping tankers and freighters. By using an innovative incorporation of Visual Basic, MS Access, SQL Server, and ASP, we provided augmented ability to track and report objective risk assessment criteria, assisting with safety efforts and liability reduction within its shipping venues throughout the world.
Further into development, Phoenix developed a modularized Marine Terminal Survey Tracking and Implementation System (MTSTIS), using Access 97 to track and report onload/offload activity at this client's international oil shipping terminals.
Creating the international LAN-based network allowing 35 users simultaneous access to several customized Access databases located throughout the organization(s) was accomplished with the development of a straightforward and logical GUI, always considering its international application and usage. The GUI was customized to meet various national/international standards, while still accomplishing encoded calculation, weighting, and statistical analysis capability for the base application.
Continued enhancements and modifications were requested and performed during May 99-Jun 99.
The extensive database was driven by a 30-page MSAcess questionnaire, where our applications evaluated known values against input data, analyzing and projecting by weighted scales, which physical sites were at risk for an oil spill. Worldwide data transmission was accomplished with a VB program attached to a SQL Server email module to transfer data results and projected risk throughout the world. Users could update data through an Excel spreadsheet transmitted over the facilitator and imported at the end terminal; an Access database, also sent and imported; or using the web interface to directly modify their data. The application was also designed to accommodate time differences between users, and scheduled data-sending to different off-site facilitators for analyses of risk assessment.
Functionality also enabled users to retrieve unscheduled data from a single site if situations warranted an off-schedule or emergency level evaluation and inspection. Facilitators could verify the correctness of the data received, input their comments and concerns, and offer assessments to determine corrective actions. Transmitted recommendations were evaluated to ensure that all the facilities were operating up to speed. This program has been operational worldwide for 3 years. PCG wrote the original program, and performed serial enhancements until this client upgraded and requested a full rewrite of the application to bring it up to Enterprise level application.
Still operational, the MTDBA and MTSTIS systems are currently monitoring every oil shipping port in the world, to ensure oil spill factors are mitigated prior to their becoming a catastrophic problem.
Asbestos Removal Tracking (Visual Basic / SQL Server)
This system comprised of a tablet PC software that was used in a hazardous environment to ensure compliance with the removal of Asbestos from buildings. The software was a touch screen design to allow for extensive inspection of all elements of a hazardous waste removal process complete with chain of custody at each step including electronic signatures. The system was designed to sync back to a main station database with reporting capabilities, infraction reporting, supervisors/contacts and all related entities to a given area or project. The system also tracked fines, regulation infractions as well as recommended judicial enforcement actions against those who were not in compliance.
Pesticide Training License Software (SQL Server / Microsoft Access)
This software was created with an Access Database front end that hooked to a SQL Server database. The purpose of the software was to track Pesticide distributors and technicians who were required to be licensed to manufacture, store or spray pesticide chemicals and the courses they were required to take as well as licenses being up to date. The system generated licenses for those who passed the courses, class scheduling, rosters, grading, printed certifications, rejections, failures as well as lists of manufacturers that made or stored chemicals. The system was designed to track all aspects of licensing individuals in the state who handled pesticides in any way shape or form.
Custom Audio Manufacturing Website
Produce a website for an audio manufacturer of customized speaker boxes. This company produced boxes that were specifically designed for acoustical accuracy and projection based upon building specifications and sound needs.
Seal Manufacture Tracking System (Visual Basic for Applications / Microsoft Access)
The system had 2 separate databases that synchronized into one central system. A quotation data was for sales individuals in the filed to provide for inputs and monitoring of actual running engines and injection molding and compression molding machinery.
Create two separate programs with two separate databases: one for quotation data, and one for manufactured product data. These databases will include an Injection Product table, a Compression Product table, an Injection Product data entry form, a Compression Product data entry form, the ability to query the two tables using the forms, perform automatic field calculations in the forms, cut and paste data between the forms and an excel spreadsheet, generate printable Access reports, and export data to Excel.
Ground Water Monitoring & Charting System (Microsoft Excel)
This project was for a Ground Water monitory ing company for a specific location. This provided plotted charts as well as distinct data searches to determine if anomalies were occurring at groundwater monitoring stations.
Medical Records Review System
This program managed multiple query capability based on a hospital with physicians and nurses and the JCAHO standard testing systems. System tracked Medical record reviews that occurred within a hospital to ensure regulatory training compliance certifications.
Well Tracking System
This system monitored water wells for the purity of water and managed routine tracking of the wells to produce testing reports to insurance compliance with clean water standards.