William Sherlock

LinkedIn Github

Skills

Languages: Python, SQL, R, Bash

Software: Git, SQLite, PostgreSQL, Docker

Libraries: FastAPI, Pandas, Matplotlib, SQLAlchemy, Pydantic, Polars

Experience

• Created multiple internal software libraries using Python to automate data transfer from external sources, implementing best practices in testing, documentation, and packaging.
• Designed a database for preclinical studies of cancer therapies, involving the modeling of complex relational data, such as tumor model lineage, and the creation of defined vocabularies.
• Implemented a containerized PostgreSQL database from that data model.
• Defined common metrics as hierarchical views within the database for downstream consumers.
• Built multiple web applications for scientists to explore, visualize, and export data.
• Mentored one co-op student and one summer intern on software development projects.

• Analyzed and compared the effects of interferon stimulation on the nascent transcriptome in B-cells for members of 7 different human populations and other primate species.
• Used Python and R to perform differential gene expression analysis and visualize results.
• Ran bioinformatics pipelines on a computer cluster using nextflow and slurm.
• Received funding from the Biological Sciences Initiative for the school years 2020 to 2022.
• Received a funded UROP assistantship for the summer of 2021.

• Used machine-learning software to classify and segment regions of stained tissue sections.
• Developed and deployed python scripts to automate the graphing of pharmacology study data.

Education

University of Colorado Boulder

Bachelor of Arts, Molecular, Cellular, and Developmental Biology

Minor in Applied Mathematics