Austin Oglesby

Experience

• 

  University of California, Davis

  Jul 2019 - Mar 2022

  Graded papers for the math departmentCoordinated with professors to adjust student work load.

  • Mathematics Reader

    Sept 2019 - Mar 2022

  • Student Library Assistant

    Jul 2019 - Mar 2020
• 

  Avista

  Nov 2022 - now

  Energy Efficiency Data Analyst (Python, Excel, Tableau, Data Analysis)

  Energy Efficiency Data Analyst- Provide analytics on request to project managers to help steer program initiatives through the use of the ETL process and leveraging Python, resulting in a 50% increase in analytic output. - Crafted a Python script to search large zip files for erroneous account numbers, reducing work hours needed by 50 hours annually.- Redesigned the analytics process to include stakeholder and management interviews and a design process that turns data into a story, reducing the time between question to action by 50%.- Implemented automation through the use of R and Python scripts to assist in data validation and cleaning, resulting in over 320 work hours saved per year. - Created validation scripts and measures to ensure code output validity, recouping 20 work hours per week.- Developed a prototype to identify key low-income areas in Avista service territory using clustering techniques over 100,000 data points in Python.- Created a data cleaning algorithm using Python that cleans and normalizes customer input data for bulk system upload, saving 30+ work hours per month.- Identified productivity throttles and implemented automation measures using advanced Excel and Python, saving a minimum of 50 work hours per year.- Predict and report future revenue and tariff values via machine learning techniques to governance bodies that reduce the processing time by 30% and increase accuracy by 55%. Show less