Senior LIMS - SQL DBA & Systems Analyst

Thom Schumann

**** ***** **** ***, ********, Colorado 80227

303-***-**** ****.********@*******.***

SUMMARY

Experienced Programmer, Database Administrator (DBA), and Systems Analyst with 20+ years supporting laboratory data management, environmental workflows, and SQL-based systems. Extensive background designing, optimizing, and maintaining LIMS-adjacent tools, web-based data systems, and complex ETL pipelines. Strong understanding of environmental analytical data, regulatory reporting requirements, and laboratory operations. Skilled in MS SQL Server, SSRS. Crystal Reports, EDD formats, and laboratory workflow design. Adept at troubleshooting, cross-department collaboration, and translating lab needs into stable, compliant, and efficient LIMS solutions. Seeking to leverage deep laboratory data expertise to support and enhance LIMS, lead upgrade initiatives, and improve workflow reliability.

TECHNICAL SKILLS

LIMS & Laboratory Systems: Knowledge of environmental laboratory workflows, a variety of EDD formats (EQUIS, Custom, ERIMS, etc.), environmental analytical data (organics, inorganics, PFAS, VOCs) and methodologies.

Programming: C#/.NET, VB.NET, JavaScript, HTML, CSS, AJAX, XML, VBA, some AS400. Database Management: MS SQL Server (queries, stored procedures, views, jobs, optimization), SSRS, SSIS, ETL design.

Reporting Tools: Crystal Reports design, formatting, and optimization. Tools & Platforms: GitHub, Team Foundation Server, JIRA, DevExpress/DevExtreme, IIS 6/7. Web Technologies: ASP, ASP.NET. jQuery and others. Other: Microsoft Office automation, workflow analysis, cross-functional communication. RELEVANT EXPERIENCE

EnVirSys – Littleton, CO 08/2013 – Present Database / SQL / Applications Developer

• Designed and maintained a comprehensive web-based environmental data management system supporting environmental laboratory analysis and field workflows.

• Led development of SQL-driven workflows, automated processes, and ETL routines used for regulatory client reporting and sample management.

• Created, managed, and optimized Crystal Reports and custom report logic ensuring accuracy, consistency, and regulatory compliance.

• Developed and enhanced standardized Electronic Data Deliverables (EDD) formats for laboratories and clients with varying capabilities.

• Improved system reliability and data integrity through proactive database optimization, server tuning, and troubleshooting.

• Collaborated with laboratory partners to validate data structures, streamline data exchange, and ensure consistent naming conventions.

• Built automated routines for near-real-time dashboard updates with 15-minute precision, improving operational visibility.

• Supported environmental chemistry datasets, including organics, inorganics, VOC and other related workflows.

Thom Schumann

2129 South Hoyt Way, Lakewood, Colorado 80227

303-***-**** ****.********@*******.***

Harding ESE – Golden, CO 06/2009 – 08/2013 Project Database / GIS Analyst

• Supported environmental laboratory data workflows, QA/QC processes, and regulatory reporting structures.

• Validated analytical datasets for compliance with federal, state, and/or project-specific standards.

• Designed tools and database structures to improve data handling, reporting, and laboratory coordination.

WSP – Denver, CO 05/2007 – 06/2009 Software Developer

• Built and supported custom software used for environmental and laboratory data management.

• Created automation tools to reduce manual data entry, including solutions replacing spreadsheet-based processes.

Environmental Strategies Corporation – Denver, CO 03/2002 – 05/2007 Programmer / DB Analyst

• Managed SQL databases, created reporting tools, and supported environmental laboratory data validation.

• Coordinated with multiple labs to improve electronic data flow and ensure compliance with environmental regulations.

Mactec – Golden CO 09/2001 – 03/2002 Database Administrator / GIS support

• Provided data integrity for a number of environmental and civil engineering projects

• Worked with MS Access to provide updates and reports to support various projects Quanterra – Arvada CO 01/1997 – 09/2001 Laboratory QA/QC Assistant

• Documented and maintained a system for SOPs, approvals and signed documents.

• MS Access database management and reporting

Quantalex – Golden CO 01/1994 – 01/1997 Environmental Data Validator

• Provided data validation to support on-going client investigations

• Mostly supporting/validating Rocky Flats chemical data for metals and some VOCs

• Some site investigation work

ICF-Kaiser – Golden CO 02/1990 – 01/1994 Chemist

• Subcontractor to EPA NEIC

• Basic Chemistry laboratory support

• Data reviews

EDUCATION

Bachelor of Science: Biology (Chemistry minor)

Eastern Michigan University – Ypsilanti, MI 12/1990 Additional Studies toward Civil Engineering / Forestry Major Michigan Technological University – Houghton, MI

LANGUAGES

German: 4 years of study

Contact this candidate