Amanda Delgadillo

Microbiologist | Data Analyst

Thanks for stopping by.

Data analyst with a certificate in Data Science and Data Visualization from UC San Diego Extended Studies and 5+ years of laboratory experience, including 6 months of laboratory work with NASA/CalTech and 1.5 years of managerial experience as a shift leader at Fulgent Genetics.

Highly motivated to put my skills to use in a new work environment.

Python

CSS3

HTML5

Bootstrap

Git

More about Me


Takes initiative to lead when needed; demonstrated by my experience overseeing a team of lab personnel and ensuring maintenance of quality assurance. Great team player and able to work well with others. These skills were used extensively through my Data Science program where I collaborated with my classmates, and in my career where I regularly communicated with salespersons, scientists, and clients.

With my versatile background as a laboratory scientist I know the importance of working diligently with an eye for details, thinking critically about complex topics, and being able to adapt to dynamic situations - skills necessary for a successful data analyst. Highly motivated to put my skills to use in a new work environment.

Technologies I use:

Python, SQL, Tableau, ETL, Bootstrap

Recent Projects

These are just a few of the projects I have collaborated on.

CAPSTONE PROJECT: Affordable Housing in San Diego

The purpose and goal of this project is to determine where is San Diego would residents benefit the most from low-moderate income housing broken down by zipcode. We used a K-means model to analyze several different categories. The categories that we chose to focus on are accessibility to transit, food(markets), hospitals, and parks. To get this data we obtained census flat files for the population, income, and living percentages, performed web-scraping for the hospital information, utilized the San Diego transit geoJSON data, as well as used Google's PlacesAPI for the markets and parks. We preprocessed the all data, compiled, trained, and evaluated the data to get our results.

Code GitHub Page

The Truth Is Out There

The purpose of this challenge was to filter a dataset, compile the information in a table and display the results on a webpage using javaScript. Our example dataset for this project is consists of many accounts of UFO sightings. To summarize, our result is a neatly organized webpage with data that can be easily filtered. Although the design is simple it serves its purpose and allows us to filter through a large dataset.

Code GitHub Page

Bikesharing

Using Tableau I was able to create story that depicts the usage of a bike sharing service in New York City, with the purpose of potentially expanding the service to Des Moines. In this report I identified the days and times in which the service is most in use and I show how this data differs between subscribers and customers of all genders. I also show how long the bikes are typically checked out for. Lastly, I identified the areas of the city in which the bike trips typically start and end.

Code Tableau Story

Biodiversity Dashboard

The purpose of this project was to utilize plotly to create different types of charts to display biodiversity among a dataset of swabbed samples. Using plotly I created a gauge chart, horizontal bar graph, and a bubble chart. I also created a drop down menu to select for different test subject IDs to view demographic informaiton. Lastly, all elements are displayed on a dashboard.

Code GitHub Page

Credit Risk Analysis

The purpose of this challenge was to use resampling methods to alter an unbalanced dataset with the goal of creating a more reliable machine learning model. The purpose of this challenge was to use resampling methods to alter an unbalanced dataset with the goal of creating a more reliable machine learning model.

Code

World Weather Analysis

The purpose of this challenge was to make API requests to retrieve information and create maps with multiple layers and markers using gmaps. Approximately 1,600 cities were randomly generated - numpy was used to create 2,000 pairs of coordinates and matched to the nearest city using citipy. Weather information was gathered from openweathermap.org utilizing a Weather API key.

Code

Education

University of California, San Diego

Certificate, Data Analytics and Visualization | May 2022 - November 2022

California State University, Northridge

Microbiology, B.S. | 2015 - 2020

I'm available for work.

Interested in exploring new ways to improve on my skills. I am always open to new opportunites!

Contact Me