
Keaton R
Data Analyst
Habilidades

Conheça meus serviços

Portfólio
Experiência profissional
Company
Período integral • 3 yrs 1 mo
Data Analyst (Boise Cascade)
Oct 2025 - Present • 7 mos
• Designed and delivered Power BI reporting and audit solutions that replaced an existing third-party environmental reporting platform, improving reporting workflows and contributing to substantial operational cost savings. • Built a centralized semantic model integrating 25+ operational and commodity data tables using Power Query transformations and star schema modeling to support KPI reporting, operational reporting, audit workflows, and environmental performance analysis. • Developed an interactive Power BI audit tool with advanced filtering, drilldowns, contextual report page tooltips, and location-level reporting workflows to streamline data validation, improve audit visibility, and support stakeholder analysis of missing or inconsistent billing data. • Collaborated with stakeholders to improve KPI visibility, automate recurring reporting processes, and streamline access to operational and environmental performance data through Power BI and SQL-based reporting solutions. • Maintained and enhanced an Azure-hosted Python data transformation application using Pandas and NumPy to automate spreadsheet standardization, improve data consistency, and streamline operational reporting workflows.
Data Analyst (Intern, Boise Cascade)
May 2025 - Sep 2025 • 4 mos
• Developed an internal Power BI model exploration tool that generated interactive hierarchical visualizations of DAX measure relationships to improve reporting analysis, measure tracing, and model navigation workflows. • Built a SQL-based schema exploration utility that analyzed database metadata, table structures, and relationship mappings to identify likely table matches and support data discovery and reporting development processes. • Designed and implemented a SharePoint, Power Automate, and Microsoft Forms workflow to greatly simplify external audit submission processes through branching logic, automated data collection, and integrated list-based workflows.
Technical Support (Idaho Transportation Department)
Mar 2023 - May 2025 • 2 yrs 2 mos
• Developed an Excel/VBA onboarding automation system that streamlined account setup workflows through automated field population, standardized data formatting, password generation, workflow utilities, and preformatted Outlook email automation. • Designed and built a PowerShell-based remote support utility that centralized system administration commands, remote management workflows, and troubleshooting capabilities to improve operational support efficiency and supplement declining enterprise management tooling. • Supported and troubleshooted 300+ enterprise applications while managing Active Directory account administration, permission updates, and user access workflows for county and headquarters users. • Created and maintained extensive SharePoint and OneNote knowledge base documentation to improve troubleshooting consistency, operational support workflows, and internal knowledge sharing processes.