Trenton McKinney

Retired Personal Website

This is my retired personal website, which has be left as a comparison. I am no longer updating this site and the links have not been updated. Please visit my Updated Site.

Data Analyst | Data Scientist | Python, Pandas, Data Visualization | Hardware Test Automation

Bachelor of Science Electrical Engineering - Portland State University, Portland, Oregon

I am a seasoned professional with a Bachelor of Science in Electrical Engineering and over 12 years of experience in electrical hardware testing, hardware test automation, and data analytics. My career has been driven by a relentless curiosity, a strong foundation in critical thinking, and an unwavering commitment to problem-solving. These skills have enabled me to excel in providing timely, effective solutions using Python for tasks ranging from data collection and wrangling to analysis and visualization.

My engineering mindset fuels my dedication to stay abreast of the ever-evolving landscape of data science and analytics. I am passionate about tackling challenging problems, delivering data-driven insights, and continually broadening my skill set and knowledge base.

In essence, I bring to the table a unique blend of technical acumen, problem-solving expertise, and a fervent zeal for knowledge enhancement. My proficiency in leveraging the Python data science software ecosystem positions me ideally to deliver exceptional outcomes in data analysis, visualization, and effective storytelling.

Knowledge

• Critical Thinking and Problem Solving
• Python
• Data Science & Analytics
• Scikit-Learn
• Data Munging
• Jupyter Lab
• PyCharm
• Pandas
• Numpy
• Visualization: Matplotlib, Seaborn, Bokeh, Plotly
• SQL: PostgreSQL, MSSQL
• ETL
• Electrical Hardware Testing
• Electrical Engineering Lab Test Equipment
• Hardware Test Automation with Python

Links

• What's a Data Scientist
• Data Scientist vs Data Engineer
• Creating Effective StackOverflow Questions

GitHub Repositories

• Stack Overflow
• DataCamp
• UDACITY
• OOP
• Automate Excel with Python
• WordCloud using NLTK

For Fun

• How to Create a Pivot Table in Excel with the Python win32com Module
• Portland OR Temperature Visualization
• OCR Image Processing with PyTesseract & CV2

Projects & Notebooks

• DataCamp: Working with the OpenAI API
• DataCamp: Case Study: School Budgeting with Machine Learning in Python
• DataCamp: Introduction to Deep Learning in Python
• DataCamp: Unsupervised Learning in Python
• DataCamp: Supervised Learning with scikit-learn
• DataCamp: Statistical Thinking in Python II
• DataCamp: Introduction to Network Analysis in Python
• DataCamp: Interactive Data Visualization with Bokeh
• DataCamp: Introduction to Data Visualization in Python
• DataCamp: Introduction to Relational Databases in SQL (Postgre)
• DataCamp: Joining Data in SQL
• DataCamp: Statistical Thinking in Python I
• DataCamp: Fraud Detection with Python
• DataCamp: Merging DataFrames with pandas
• DataCamp: Intro to Databases in Python
• DataCamp: Intro to Python for Finance
• DataCamp: Manipulating DataFrames with pandas
• DataCamp: pandas DataFrames
• UDACITY R Project: Prosper Peer to Peer Lending Data-set Exploration
• UDACITY Python Analysis: Titanic Survivability Parameters
• UDACITY Python Analysis: Open Street Map: Portland

Certifications

• Data Visualization in Power BI
• Introduction to DAX in Power BI
• Introduction to Power BI
• Working with the OpenAI API
• Data Scientist with Python
• Case Study: School Budgeting with Machine Learning in Python
• Introduction to Deep Learning in Python
• Unsupervised Learning in Python
• Introduction to Shell
• Conda Essentials
• Supervised Learning with scikit-learn
• Statistical Thinking in Python (Part 2)
• Introduction to Network Analysis in Python
• Interactive Data Visualization with Bokeh
• Introduction to Data Visualization in Python
• Introduction to Relational Databases in SQL
• Joining Data in SQL
• Statistical Thinking in Python (Part 1)
• Fraud Detection with Python
• Intro to SQL for Data Science
• Merging DataFrames with pandas
• Python Programmer Track
• Introduction to Databases in Python
• Manipulating DataFrames with pandas
• Intro to Python for Finance
• pandas Foundations
• Cleaning Data in Python
• Udacity Data Analyst Nanodegree
• Introduction to Big Data
• Importing Data in Python 2
• Importing Data in Python 1
• Python Data Science Toolbox 2
• Python Data Science Toolbox 1
• Intermediate Python for Data Science
• Intro to Python
• Machine Learning
• DAT206x: Analyzing and Visualizing Data with Excel
• Using Python to Access Web Data
• Using Databases with Python
• Python Data Structures
• Getting Started with Python