Expert in Lab Automation, LIMS, Validation & Data Analysis
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.
Expert may consult nationally and internationally, and is also local to the following cities: San Jose, California - San Francisco, California - Sacramento, California - Oakland, California - Stockton, California - Fremont, California - Modesto, California - Salinas, California - Santa Rosa, California - Hayward, California
|Year: 1978||Degree: PhD||Subject: Computer Applications in Chemistry||Institution: University of California, Santa Cruz|
|Year: 1975||Degree: MS||Subject: Organic/Biochemistry||Institution: University of Minnesota|
|Year: 1971||Degree: BS||Subject: Chemistry||Institution: UCLA|
|Years: 1986 to Present||Employer: Undisclosed||Title: Consultant, Laboratory Automation Expert||Department:||Responsibilities:|
|Years: 1986 to Present||Employer: Undisclosed||Title: President||Department:||Responsibilities:|
|Years: 1981 to 1986||Employer: Nelson Analytical||Title: Software Development||Department:||Responsibilities:|
|Years: 1980 to 1981||Employer: Spectra-Physics||Title: Software Developer||Department:||Responsibilities:|
|Training / Seminars|
|For the last 15 years, Expert has been giving short courses and training for the American Chemical Society and at the Pittsburgh Conference (PittCon). His most current course topics are "Validation of Chromatography Data Systems" and "Laboratory Data Management on a Personal Computer." The validation course can easily be extended to the validation of any computer system in a regulated environment. Additionally, Expert has taught courses on chromatography data handling and instrument interfacing.|
| Expert has experience locating vendors of: chromatography data handling systems (integrators),
laboratory information management systems (LIMS)and computer equipment (PC and other).
He has access to data bases with listings for chromatography data handling system vendors and LIMS vendors.