Request Expert

Expert has developed validation plans and executed validation protocols on laboratory computer systems, laboratory information management systems, instruments and instrument data systems. He has consulted for several major pharmaceutical companies and teaches a course on chromatography data system validation at the Pittsburgh Conference and for the American Chemical Society. A known expert in computer system validation, Expert teaches courses for the American Chemical Society and the Pittsburgh Conference on this topic.


Expert is an expert at laboratory information management using data base management software. He has developed several systems which are currently in use. He teaches courses on lab information management. He has developed systems which use bar code data entry, interactive worksheets for data reduction, instrument interfacing, data acquisition and summary, real-time monitoring, and automatic reporting. He has developed systems ranging in size from a single user up to over 50 users on networks.


Expert has created validation plans and protocols for major pharmaceutical companies analytical and process instrument computer systems. He has ensured that various computerized systems perform what they have been developed to do.


Expert has spent most of his professional career developing and using lab instruments. He has developed commercial products for major instrument manufacturers including, Perkin-Elmer, Finnigan, and Spectra-Physics. He has also developed data handling systems for individual users and interfaced instruments to computers and computer networks.

Having hands-on experience collecting data from multiple instruments in real-time via RS-232, Expert has implemented systems collecting 32 channels of data into a personal computer.

Expert has spent most of his professional career developing and using chromatography data systems. He is an expert in chromatography data acquisition, analysis, and reporting. He has developed data analysis systems which are now used by several systems for moving the data from instruments to laboratory management systems. He teaches courses in data analysis and reporting. Expert has developed the algorithms for analyzing chromatography data and produced the first system for the IBM PC. He has hands on experience in summarizing and reporting chromatography data and placing the data into lab management systems.

Expert has developed several laboratory information management systems using Microsoft (MS) Access for both large and small laboratories. These systems are multi-user network systems. They include instrument interfacing, real-time monitoring and interactive laboratory worksheets for data reduction. He has expertise in the Visual Basic for Applications (VBA) language.

Expert has created several data acquisition systems and other laboratory automation applications using Visual Basic. Data is placed in databases so it can be accessed with any SQL (Structured Query Language). Data management systems in which he is familiar include MS Access, Oracle, and SQL Server. He has also implemented applications using active controls and web-based applications.

Applying his knowledge of Microsoft Access and Microsoft Excel, Expert has built laboratory data management systems. These systems acquired data automatically from lab instruments and generates graphs and summary reports of the acquired data. He teaches a course for the American Chemical Society and at the Pittsburgh Conference on this topic.

Expert has developed several hundred spreadsheet applications using MS Excel and Quattro Pro. He teaches a regular course on spreadsheets for the American Chemical Society. He is an expert with macros and their development including automation with Visual Basic.


Expert has interfaced laboratory instruments to personal computers and lab networks for the last 15 years. He has complete knowledge of communication ports, interface cards, data acquisition, data storage, data summarizing, and data reporting. He has an extensive knowledge of computer networks.


Expert is an expert at information management using database management software. He has developed several laboratory information management systems and information management systems for other businesses. His primary expertise is in using MS Access on PC networks. He also has knowledge of Oracle and SQL Server.