Exploring Data, Driving Decisions
  • About Me
  • Interactive App
  • Educational Resources

Colin Huson-Thompson

GitHub LinkedIn

Professional Vision

Driven to leverage expertise in data analytics and automation to enhance decision-making and performance. Committed to support data-driven solutions that streamline processes, delivering impactful results and operational excellence.

Summary of Qualifications

  • Proven expertise in designing and implementing analytics reporting that streamline decision-making, and drive business insights.
  • Experience in leveraging relational database systems to support business operations.

Education

Washington State University

BS: Data Analytics,
Minor: Economics, Fall 2024
Cum Laude


Work Experience

Business Support Analyst | Puget Sound Energy | Bothell, WA

12/2024 – Present

Leveraged Power BI, and Power Query (M) to develop analyses that enhance decision-making for business leaders. Full-access Salesforce administrator, optimizing data structure and integrity. Currently leading the redesign of a community website, using segmented surveys to gather stakeholder feedback and better align the platform with user needs.

Accountant | Washington Energy Services | Lynnwood, WA

12/2021 – 12/2024

Led the migration of AR, SO, and AP modules from a legacy ERP system to a modern platform. Collaborated with stakeholders to gather requirements, ensuring the system configuration aligned with both current and future business needs. Developed and delivered comprehensive training on updated processes, improving team efficiency and accuracy. Utilized Power Query (M) to clean and prepare data for migration. Developed and implemented automated reporting systems using Excel, extracting data from ERP and CRM systems. This optimized workflows, improved accuracy, eliminated manual data munging. Applied business analysis techniques such as requirements elicitation, continuous process improvement, and data modeling to ensure reporting systems aligned with stakeholder goals, enabling future pricing analysis.

Projects

Capstone Project | Washington State University for Boeing

Led development of a willingness to pay model in R to estimate price elasticity of in-cabin feature inclusions using survey data. Applied Design of Experiments and statistical modeling to validate results. Integrated findings into a corporate finance model, using Monte Carlo simulations to estimate Net Present Value and forecast market share impact, guiding data-driven pricing decisions for Boeing.


Technical Skills

Data Management, Analysis & Reporting

  • MS Power BI & Excel Expert
  • R/Python/SQL/M/DAX
  • ERP and CRM Systems
  • Data Wrangling
  • Data Mining

Advanced Analytics and Modeling

  • Design of Experiments
  • Statistical Modeling
  • Econometric Modeling
  • Financial Modeling
  • Machine Learning Methods
  • Model Evaluation

Project & Change Management

  • Lean Six Sigma Methodologies
  • Agile and Scrum Methodologies
  • Data & Process Modeling
  • Requirements Elicitation
  • Project Planning and Execution
  • Stakeholder Communications