Resume

Resume

Cybersecurity Analytics | Python Automation | Data Analysis | SQL & Jupyter | Machine Learning | Data Visualization

Summary

Experienced data analyst with a background in electrical engineering, hardware test automation, and Python development. Currently transitioning into cybersecurity analytics through the Google Cybersecurity Certificate. Applies an engineering mindset to data wrangling, automation, and visualization using Python and SQL. Builds tools for structured and unstructured data analysis with a focus on vulnerability management, log analysis, and threat detection workflows.

Skills & Knowledge

Core Competencies
Critical thinking · Problem solving · Engineering mindset · Analytical reasoning

Programming & Tools
Python · SQL (PostgreSQL, MySQL, MSSQL) · Bash · Git · JupyterLab · PyCharm · GitHub · Linux CLI · VS Code

Data Science & Analysis
pandas · NumPy · scikit-learn · TensorFlow (intro) · data wrangling · statistical analysis · API integration · ETL pipelines

Cybersecurity
Cybersecurity analytics · log analysis · vulnerability management · risk assessment · Linux system tools · CLI workflows

Visualization & Reporting
Matplotlib · Seaborn · Bokeh · Plotly · Power BI · Tableau · Excel (Power Query, Power Pivot, DAX)

Engineering & Automation
Electrical validation · Signal integrity testing · Test plan development · Waveform analysis · Lab automation with Python · Oscilloscope scripting · Hardware bring-up and debug

Mathematics & Statistics
Linear algebra · Calculus · Differential equations · Statistic

Education

  • Bachelor of Science in Electrical Engineering
    Portland State University, Portland, OR
    Graduated: August 2004

Professional Experience

  • Professional Development
    Career Break, Portland, Oregon
    Oct 2022 – Present
    Cybersecurity Transition & Technical Development
    • Pursuing the Google Cybersecurity Certificate, covering cybersecurity foundations, risk management, network security, Linux, and SQL
    • Completed supplementary coursework in Python, machine learning, deep learning, Power BI, and OpenAI API (see Certifications section)
    • Contributed to the developer community by answering Python questions on Stack Overflow
    • Edited and curated community-submitted questions and answers for clarity, accuracy, and relevance
    • Cybersecurity Portfolio
  • Contract Data Analyst III
    Space Telescope Science Institute, Baltimore, MD
    Jan 2022 – Sep 2022
    Utilized Python for data ingest automation to build new SQL tables for Hubble Advanced Products (HAP) from FITS files. Created Jupyter Notebooks for Hubble telescope observation mission data.
    Project Resources:
  • Freelance Data Analyst
    Codementor.io, Remote
    Jan 2021 – Dec 2021
    Provided on-demand mentoring, code review, and long-term coding services related to data analysis and data science in the Python ecosystem.
    Code Mentor Profile

  • Contract Data Analyst
    Intel, Hillsboro, OR
    Apr 2021 – Jun 2021
    Engaged in API usage and web scraping with Python to collect cloud service cluster pricing data, cross-referencing the data with specific Intel ICs for market value estimates.

  • Contract Data Analyst
    Intel, Hillsboro, OR
    Feb 2019 – Jul 2019
    Consolidated data from multiple XML files into a single JSON file, deployed a Flask application to serve this data, and implemented search functionality. Used NLP for text matching, tested code in Jupyter Notebooks, and cleaned unstructured text data.

  • Contract Validation Engineer
    Intel, Hillsboro, OR
    Apr 2017 – Oct 2018
    Ethernet adapter validation was a key task in the project, involving the creation of test plans, conducting tests on network cards, and automating data analysis using Python and Excel. New waveform post-processing automation was written and implemented using Python, Jupyter Lab, and Pandas, which organized test data, produced waveforms, and analyzed them. This automation was capable of handling a large volume of data, generating over 1500 waveform figures from 1.7 billion+ rows of data. Additionally, Excel tasks were automated as part of the project.

Certifications

Projects

Volunteer Work

  • Stack Overflow Volunteer Contributor
    Contributed over 6000 hours to Stack Overflow, providing custom coding solutions and enhancing the knowledge base for a global community of developers.

    profile for Trenton McKinney at Stack Overflow, Q&A for professional and enthusiast programmers