SAMANTHA MCKAY

Murray,UT

Phone: 801-***-**** Email: ad1fdb@r.postjobfree.com

LinkedIn: www.linkedin.com/in/samantha-mckay-14009bb7 GitHub: github.com/SamanthaMcKay

Summary

Dynamic professional offering unique quality control perspective with a passion for organizing and visualization large datasets to streamline operations, produce quality deliverables, and achieve organizational objectives. Articulate communicator utilizing continuous improvement leadership and strong investigative skillset to summarize key data indicators and emphasize significance through story. Leveraged robust interpersonal skills to facilitate cohesive team collaboration.

Technical Skills

Tools: Excel, VBA, Python, and SQL.

Databases: Postgres,LabWorks LIMS, LabVantage LIMS Projects

Python-API-Challenge github.com/SamanthaMcKay/Python-API-Challenge

● Extracted data to visualize the correlation between latitude and weather variables such as temperature, humidity, wind speed, and cloudiness. Filtered weather data to determine ideal vacation cities and translated ideal vacation cities to a user friendly map.

● Constructed URLs to pull data from APIs, graphed data with accompanying linear regressions and compiled data into dataframes.

● Used APIs, Python, Pandas, and MatPlotLib.

Cancer-Project github.com/SamanthaMcKay/Cancer-Project

● Worked as part of a team to organize data to assess correlations between cancer incidence and income, employment status, marital status, and lack of insurance. Created a slide deck to present findings.

● Responsibilities included: finding a suitable dataset, reorganizing and renaming columns to make the dataset more useable, plotting marital status versus rate of death from cancer, compiled individual team members code into a unified Jupyter Notebook, and compiled team members figures into the presentation.

● Used Python, Pandas, MatPlotLib, and Powerpoint. SQLAlchemy-Challenge github.com/SamanthaMcKay/SQLAlchemy-Challenge

● Used SQLAlchemy to reflect an existing database with automap. Performed various queries including the precipitation measurements for a year and the minimum, maximum and average temperature for the most active station.

● Utilized Flask to display the webpage with routes to show the precipitation data, temperature information for the most active station, and a route that takes in the start and end date a user specifies and shows the minimum, maximum and average temperature for that date range for all stations.

● Sorted data into categories, assembled summary dataframes, and drew conclusions based on trends in the data to communicate to stakeholders.

● Used Flask, MatPlotLib, Pandas, Numpy, a SQLite database and SQLAlchemy. Experience

QC Chemist II 2023

Biomedical Research Inc. Sandy,UT

Utilized critical thinking skills to prioritize testing to meeting manufacturing timelines. Communicated necessary improvements to SOPs, methodologies and reporting software to maximize understanding with teams across the company.

● Trained employees on new testing.

● Communicated key deficits in current test method for mineral content to management by compiling data, visualizing trends in LIMS database and leading the investigation into possible corrective actions to implement. QC Chemist II 2021-2023

DoTerra Inc. Pleasant Grove,UT

Generated technical reports and supplementary documentation to ensure effective record of analytical test results and conclusions. Spearheaded a team to liaison with Wellness Advocates with diagrams and demonstrations of simplified versions of analytical test methods at the DoTerra yearly convention.

● Enhanced laboratory workflows by collaborating extensively with laboratory technicians and supervisors.

● Collaborated on six sigma process improvements with a global team. QC Chemist I/II 2015-2021

Ultradent Products Inc. South Jordan,UT

Utilized LIMS databases and provided hands-on technical support to enhance overall efficacy of operations.Observed thorough investigations of OOS and PC diagnostics to determine source of discrepancy and implement corrective actions as required.

● Upheld compliance with industry regulations to enhance safety and alleviate risks.

● Devised and implemented strategic plan to consolidate compliance with COVID-19 guidelines and mitigate risk of exposure to coronavirus.

● Researched emergent technologies and techniques to boost productivity and data accuracy.

● Demonstrated innovative problem-solving skills to minimize quality costs and maximize customer satisfaction.

Education

Data Analytics Boot Camp Certificate: University of Utah, Salt Lake City, UT A 24-week intensive program focused on gaining technical programming skills in Excel, VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, and Machine Learning. Bachelor of Science in Chemistry: Southern Utah University, Cedar City, UT