Trenton McKinney

• Build new SQL tables for Hubble Advanced Products • Create Jupyter Notebooks for Hubble telescope observation mission data • https://www.cosmos.esa.int/web/hst/archive-contents • https://catalogs.mast.stsci.edu/hsc/ • https://www.youtube.com/watch?v=DAMZE9zTWQ8&ab_channel=STScIMAST • https://www.youtube.com/user/STScIMAST/featured • Contract through Latitude Inc. (http://www.latitudeinc.net/)

• Parse text information from multiple XML files into a single JSON file. Flatten JSON file with pandas and join it with associated data from a database. • Deploy a Flask application on Linux to serve the aggregated data and write python methods to make it searchable by various parameters. • NLP (TF-IDF) was used to match the unstructured text contents of various fields. • Code was tested in Jupyter Notebooks then converted to standard python files. • Python o Data Analytics o MySQL & PostgreSQL o Call APIs for data acquisition o Natural Language Processing (NLP) o Jupyter Lab Notebooks o Visualizations – Matplotlib, Bokeh o Unstructured Data Cleaning – Text o Automation of data cleaning & manual processes • Contract: UST Global

- I have performed contract work for various companies, including Intel, as a hardware test engineer. - This has involved using python to automate the measurement process for collecting data from electronics components such as RF transmitters and CPUs. - Automation vastly increases the efficiency and throughput of measurements. - In addition to implementing automated data collection, I have used the python ecosystem of modules for data analysis and visualization.