Learn Data Skills
Beta
Trenton McKinney

Trenton McKinney

Consultant - Data Science / Analytics with Python

McKinney Tech Group, LLC | Portland OR

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Analytics ninja, mastering the art of extracting insights from chaos.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

notebook

Introduction to Deep Learning in Python

course

Data Manipulation with pandas

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Intermediate Python
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

Space Telescope Science Institute | Jan 2022 - Sep 2022

Data Analyst

• Build new SQL tables for Hubble Advanced Products • Create Jupyter Notebooks for Hubble telescope observation mission data • I am super excited to make my small contribution towards expanding the frontiers of humankinds’ scientific knowledge at Space Telescope Science Institute. • 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/)
Show More

Codementor | Jan 2021 - Jan 2022

Data Science / Analytics - Pandas - Python - Visualization

• Live and Long Term Mentoring / Freelance Projects / Code Review

Intel Corporation | Apr 2021 - Jun 2021

Data Analyst

• Web scraping and API use to collect cloud service cluster pricing data, and cross reference to Intel ICs. • Store tables in PostgreSQL using pandas with sqlalchemy. • Contract through Aditi

Intel Corporation | Feb 2019 - Jul 2019

Data Analyst

• 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. • Unstructured Text Data Cleaning. • Contract through UST Global

Intel Corporation | Apr 2017 - Oct 2018

Validation Engineer

• Ethernet Networking Division (ND) • Ethernet adapter validation - NPO Lab • Produce test plans for the thorough validation of Ethernet network cards. • Test network cards with a combination of custom automation and bench testing. • Implement automation to the data analysis process with Python and Excel. • Summarize test results with an electrical validation report. • Wrote and implemented new waveform post-processing automation with python, Jupyter Lab and Pandas to: ► Organize data generated by testing to ascertain the completeness of test coverage as defined by the test plan. ► Produce waveforms and waveform analysis from the raw waveform test points. ► One test of 3 DUTs produces 1.7B+ rows of data which is used to generate 1500+ waveform figures. ► Figures are either individual waveforms or groups of waveforms ► Individual waveform measurement figures are divided into four subplots, and out of spec data are masked.: (1) full waveform (3) ringing (4) steady state. ► Combined figures to include: (1) startup of all test points plotted to verify sequencing (2) test points and slew rate (3) DUT and test point to name a few combinations. • Automation of Excel with Python • Contract through Kelly Services

Microsoft | Aug 2014 - Nov 2014

Test Engineer

• Perceptive Pixel by Microsoft • Functional verification of HIDs, PIR sensors, cameras and NFC devices within Perceptive Pixel (aka Surface Hub). • Test plan/procedures development & results presentation • Contracted through Oxford Global Resources

Rohde & Schwarz | Apr 2014 - Jun 2014

Test Engineer

• Automated functional verification of the Rohde & Schwarz CMW500 with python. • Regression Testing • Contracted through Everest Consultants, Inc.

Summit Semiconductor | Nov 2013 - Mar 2014

RF Test Engineer

• Implemented automation with python scripting, which increased hardware test throughput of wireless transmitter (RF) gain control characterization. • Increased data allowed for the modeling of the device with linear regression. • Contracted through Protingent Staffing

Intel Corporation | Oct 2012 - Jun 2013

Signal Integrity Test Engineer

• S-Parameter analysis and TDR using Agilient VNA and PLTS. • High-speed IO (PCIe, GbE & SATA) Signal Integrity compliance testing • Create filters in Tektronix SDLA software to de-embed PCIe TX fixtures for eye diagram analysis. • Eye Diagram Analysis in Tektronix DPOJET software. • Report/Presentation generation of testing/measurement results: Excel & PowerPoint. • Python Coding for Instrumentation Control: 6x36 Agilent RF Matrix & Tek MSO72004C for automated PCIe TX (eye diagram) measurements - turned a 20 minute process into a 3 minute process. • Agilent ParBERT 81250, AVMC (voltage) & Medusa (thermal) automation with Python scripts • PCIe Gen2 Card Electromechanical Spec & Digital Far-End Loopback testing & Python automation. • Final PCIe gen2 DFELB measurement scripts save up to 4 days of measurement time compared to previous methodology. • Contracted through Randstad Technologies

WaveConnex | Jul 2012 - Oct 2012

Signal Integrity Test Engineer

• Characterizing the radiation pattern of 60GHz carrier wave for proprietary transceiver chip using Rohde & Schwarz 67GHz Spectrum Analyzer • Analyze spectral power density vs frequency of wireless signal • IC Characterization - BER & TDR Testing: Agilent JBERT & Tek DSA8300 • Test platform automation: stepper-motor control with Arduino Uno, EasyDriver Stepper Motor Driver and LabView 12 Interface

My Education

Take a look at my formal education

Nanodegree, Data AnalystUdacity | 2018
Bachelor of Science in Electrical EngineeringPortland State University

About Me

Trenton McKinney

With a B.S. Electrical Engineering and over 11 years of experience in electrical hardware testing, hardware test automation, and data analytics, I possess a solid quantitative background that fuels my curiosity, critical thinking, and problem-solving

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free