Keegan McAuliffe
Washington
Summary
Results-oriented Data Analyst leveraging SQL and Power BI to develop impactful dashboards that drive project performance. Enhanced data accessibility and reporting accuracy through innovative data architectures and automated workflows. Proven collaborator, providing critical insights to support departmental decision-making and operational efficiency.
Overview
10
10
years of professional experience
Work History
Data Analyst (Contract)
Fairfax County Government
Fairfax
03.2026 - Current
- Developed a Power BI dashboard enabling Facility Management leadership to monitor project performance, workload distribution, and status in real time
- Designed a standardized Smartsheet data architecture with validation rules and automated workflows, improving accuracy and speed of project coordinator data entry
- Analyzed project data to identify workload trends, informing department-level decision-making.
- Supported budget forecasting and capital planning through historical and predictive data models, facilitating informed financial planning.
- Collaborated with engineering, maintenance, and sustainability teams to enhance data visibility and improve cross-departmental reporting.
LIMS Data Analyst
Milwaukee Metropolitan Sewerage District
Milwaukee
10.2022 - 08.2025
- Administered LIMS software to generate reports and manage electronic records for the Central Laboratory, improving data accessibility and accuracy
- Implemented new features and maintained Control Charts for on-demand quality assurance analysis, ensuring consistent data quality and reliability
- Developed and issued detailed lab data reports for stakeholders, supporting informed decision-making for lab management, CCO, Veolia Milwaukee, academic partners, and the public
- Utilized Power Query to convert SQL database data into tailored reports for internal and external stakeholders, enhancing data accessibility and decision-making
- Upgraded and supported Control Charts Access application for clearer, on-demand visualizations of multi-variable QA results, enabling teams to maintain and verify quality standards
- Built department-specific Power BI dashboards for effective data visualization of laboratory data
- Facilitated Power BI dashboard development by creating custom views in SQL Server Management Studio
- Compiled and uploaded monthly electronic Discharge Monitoring Report for DNR, ensuring compliance with regulatory requirements and maintaining environmental standards
- Collaborated with Field Monitoring, Industrial Waste Pre-treatment Program, and Fresh Water Resources Monitoring staff to support laboratory data operations, improving data accuracy and operational efficiency
- Provided critical data for District partnerships, including the University of Wisconsin Milwaukee COVID study, which enhanced research quality and informed local public health decisions
- Supported the Hach Water Information Management System (WIMS) program by maintaining lab data integrity and creating new lab variables, ensuring accurate and reliable data management
- Managed the MMSD Central Laboratory SharePoint page to ensure proper documentation access and appropriate permission levels, facilitating efficient information sharing and collaboration
- Troubleshot LIMS data issues for District staff, ensuring accurate data maintenance.
- Safeguarded electronic data storage and backup system integrity through proactive management practices, enhancing data security and system reliability
- Developed and implemented work instructions for LIMS processes, enhancing user adoption and ensuring compliance, which streamlined operations
- Maintained comprehensive documentation of LIMS architecture, system updates, enhancements, and user manuals, which facilitated user understanding and system utilization
LIMS Administrator
Johnsonville
Sheboygan Falls
11.2020 - 09.2022
- Configured and implemented Sample Master by tailoring the LIMS to meet the diverse needs of the Microbiology Lab, Chemistry Lab, R&D members, three Harvest Facilities, two Ready-To-Eat production facilities, and one Raw production facility, enabling seamless data integration across the company
- Maintained both the front-end Access database and the back-end SQL Server, ensuring robust data integrity and effective SQL governance, which improved data reliability and system performance
- Assessed requirements and developed new reports in Sample Master using Microsoft SQL Server Management Studio, providing data-driven solutions for improved decision-making
- Introduced new features and reporting capabilities in Sample Master, enhancing productivity and enabling data-driven decision making
- Designed and deployed work instructions to ensure uniformity in data entry processes, resulting in consistent data quality and reduced entry errors
- Conducted training sessions for multiple departments and locations, improving user proficiency with Sample Master and increasing satisfaction
- Designed Certificates of Analysis to ensure compliance with customer expectations, resulting in timely report generation
- Provided troubleshooting and technical support to colleagues, resolving data issues promptly and enhancing team productivity
- Served as a guest lecturer and representative of microbiology in a Sanitation training course, effectively communicating technical concepts and increasing participant understanding
Microbiologist II
Johnsonville
Sheboygan Falls
03.2017 - 11.2020
- Managed Listeria investigations across two facilities, utilizing microbiology and Food Safety Quality expertise to ensure compliance with safety standards
- Conducted a study evaluating the 3M Molecular Detection System's testing capability for Campylobacter spp., improving testing accuracy for turkey raw materials and finished products
- Collaborated with R&D to conduct microbiological testing, including pathogen detection and shelf-life evaluation, facilitating product development and enhancing safety
- Trained new lab members on fresh shelf life and R&D micro plating, improving team knowledge and operational readiness
Microbiologist I
Johnsonville
Sheboygan Falls
05.2016 - 03.2017
- Performed real-time PCR analysis of product samples for Campylobacter spp. and Salmonella spp., enabling faster identification and timely action to reduce contamination risk.
- Collected and analyzed environmental samples for Listeria spp., contributing to a safe production environment through proactive monitoring
- Collected and analyzed pre-operational and operational environmental swabs, ensuring hygiene protocol adherence to mitigate contamination risks
- Collected and analyzed raw materials for Fresh and RTE products, ensuring safety standard compliance and supporting product integrity
Backup Food Safety Quality Leader
Johnsonville
Sheboygan Falls
04.2018 - 09.2022
- Reviewed Sanitation, Quality, Production, and Hazard Analysis Critical Control Points records for both Ready To Eat plants to maintain compliance with food safety standards
- Led quality assurance initiatives across production teams to enhance product consistency.
- Developed and implemented quality control processes for meat products and packaging.
- Conducted operational walkthroughs using Good Manufacturing Practices to verify compliance and enhance safety and quality standards
- Trained staff on quality standards and safety regulations within manufacturing operations.
Education
B.Sc. - Molecular and Cellular Biology
University of Illinois Urbana-Champaign
Urbana, IL01-2015
Skills
- Data Analysis
- Data Visualization
- Power BI
- MS Excel
- Power Query
- Microsoft SQL Server Management Studio
- Microsoft Access
- MMSD LIMS v5
- Sample Master LIMS
- SmartSheet
- SharePoint
- Regulatory compliance
- LIMS implementation
- Training and development
- Microsoft Office
Certifications And Classes
Comp Sci 221 Database Design & Management, UW-Green Bay, Summer 2020
Timeline
Data Analyst (Contract)
Fairfax County Government
03.2026 - Current
LIMS Data Analyst
Milwaukee Metropolitan Sewerage District
10.2022 - 08.2025
LIMS Administrator
Johnsonville
11.2020 - 09.2022
Backup Food Safety Quality Leader
Johnsonville
04.2018 - 09.2022
Microbiologist II
Johnsonville
03.2017 - 11.2020
Microbiologist I
Johnsonville
05.2016 - 03.2017
B.Sc. - Molecular and Cellular Biology
University of Illinois Urbana-Champaign