Scott Ellsworth Portfolio

SCOTT ELLSWORTH PORTFOLIO

Hi, I’m Scott Ellsworth, a U.S. Air Force veteran with over 13 years of professional experience, including the last 3 years in financial data analytics. My work has spanned from ensuring risk mitigation during cyber security incidents to forecasting prepaid portfolio balances using time series forecasting machine learning models like Prophet, ARIMA, and SARIMA. I’ve utilized Python extensively for data compiling and cleaning, and I’m passionate about leveraging analytics to drive actionable insights.

Currently, I’m pursuing an M.Sc. in Business Analytics at Carnegie Mellon University’s Tepper School of Business. My academic work focuses on financial operations and advanced data analytics techniques, including projects on peer-to-peer lending, classification, regression, and strategy optimization. I’m proficient in using tools like SQL, Tableau, Tableau Prep, and R for creating data warehouses, interactive visualizations, performing Extract, Transform, Load (ETL), and advanced statistical analysis.

Explore my portfolio to see how I’ve applied these skills in real-world projects, and let’s connect to discuss how I can contribute to your team!

Professional Level Projects

Tableau Interactive Dashboard

Explore an interactive dashboard visualizing global temperature trends. To watch a walkthrough of the dashboard, click “Source Code” and select “View raw” on the GitHub page to download the file.

Source Code

SQL Data Warehouse

This project highlights my expertise in the full ETL (Extract, Transform, Load) process using Tableau Prep and SQL, with a focus on designing, querying, and optimizing a data warehouse for complex analysis.

Source Code

P2P Loan Prediction Model

In this project, I developed classification and regression machine learning models to enhance the performance of a peer-to-peer (P2P) loan investment portfolio on LendingClub. The models predict loan outcomes, helping to optimize investment decisions.

Source Code

Skills

Python

Proficient in Python for a wide range of data science applications, including data analysis, statistical modeling, and machine learning.

SQL

Experienced in designing, querying, and managing large-scale data warehouses, with a focus on performance optimization and advanced analytics.

Tableau

Skilled in creating dynamic, interactive Tableau dashboards that translate complex data into insightful visual stories.

Machine Learning

Experienced in developing and fine-tuning machine learning models to solve classification, regression, and clustering problems, with a focus on real-world applications.

R

Proficient in using R for statistical analysis, data visualization, and model development across various analytical tasks.

Tableau Prep

Skilled in using Tableau Prep for effective data extraction, transformation, and loading (ETL), ensuring clean and ready-to-analyze data pipelines.

Data Visualization

Proficient in designing clear, compelling data visualizations that communicate insights and drive informed decision-making.

Statistics

Skilled in applying statistical analysis and modeling techniques to uncover trends, test hypotheses, and support data-driven insights.