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
    • Ingested Hubble Space Telescope mission data into SQL tables as part of the Hubble Advanced Products (HAP) pipeline using Python’s multiprocessing module to improve performance
    • Refactored Jupyter Notebooks to use the explicit Axes interface of Matplotlib and improve code readability and maintainability
    • Validated and structured raw data using pandas and custom data-cleaning scripts
    • Authored detailed data documentation and pipeline notes to support reproducibility across teams
    • Contributed to operational data workflows (excluding HSC_TAP), with publicly referenced work by the team

    Project Resources:

  • Freelance Data Analyst
    Codementor.io, Remote
    Jan 2021 – Dec 2021
    • Provided 1:1 guidance on Python, SQL, data cleaning, and visualization techniques
    • Reviewed and refactored client code to improve performance and modularity using OOP and best practices
    • Delivered short-term and long-term project support across topics such as ETL, API usage, and dashboard development
    • Maintained 5-star rating while helping mentees navigate technical interviews and portfolio-building
    • Code Mentor Profile
  • Contract Data Analyst
    Intel, Hillsboro, OR
    Apr 2021 – Jun 2021
    • Collected cloud service cluster pricing data using web scraping and APIs
    • Cross-referenced pricing data with Intel ICs
    • Stored and managed data using PostgreSQL, pandas, and SQLAlchemy
    • Analyzed large datasets including Amazon Redshift
  • Contract Data Analyst
    Intel, Hillsboro, OR
    Feb 2019 – Jul 2019
    • Parsed multiple XML files into JSON and joined with associated database records
    • Deployed a Flask app on Linux to serve aggregated data and implemented search features
    • Implemented TF-IDF-based NLP for unstructured text matching
    • Developed and transitioned analysis workflows from Jupyter to Python scripts
  • Contract Validation Engineer
    Intel, Hillsboro, OR
    Apr 2017 – Oct 2018 Ethernet Adapter Validation – NPO Lab
    • Created test plans and performed custom and bench testing for Ethernet network cards
    • Automated data analysis using Python and Excel
    • Authored detailed validation reports

    Waveform Post-Processing Automation

    • Built Jupyter Lab-based Python scripts for test data post-processing
    • Processed over 1.7 billion rows of waveform data per device
    • Generated 1,500+ waveform figures across multiple subplots and analysis types

    Additional Contributions

    • Automated Excel tasks using Python for data reporting

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