
Data Analyst
State Farm




May, 2023 - Present
- Currently engineering a SAS/DB2 to Python/AWS Redshift migration pipeline for 20+ terabytes of on-premises data reporting using Python, SQL, and Power BI, improving scalability and dramatically reducing reporting time likely by over 75%.
- Reduced query runtime by >40% using SQL optimizations and AWS Spice, allowing reports to be available and ready on-demand in AWS Quicksight.
- Automated and modernized repetitive tasks using PowerShell and Python scripting, eliminating errors on repetitive tasks, and saving hours of manual work.