Andrew Graves
Vista,CA
Summary
Well rounded Data Analyst with robust background in quantitative analysis and proven record of delivering actionable insights. Successfully developed models to optimize financial decision-making and improve risk management processes. Demonstrated strong analytical skills and advanced proficiency in programming languages relevant to data analysis.
Overview
5
5
years of professional experience
Work History
Quantitative Analyst
Calpine Energy Solutions
San Diego, CA
09.2022 - 04.2025
- Applied statistical analysis to develop complex regression models for capacity products, outperforming existing internal forecasts by 20%.
- Managed hedge reporting for $10MM portfolio, meeting monthly with Regional Sales VPs to present financial performance and respective variance drivers.
- Built Power BI reports tracking power prices by product, giving sales additional market insights and new visualizations used securing new addenda.
- Improved hedge reporting models by automating ETL processes using VBA and SQL, which increased model data accuracy and reduced reporting process for team by roughly 20%.
- Created analytics dashboard via Python and SQL, tracking KPIs for open market orders and eliciting a 15% increase in open order conversion based on actionable insight.
- Collaborated with IT teams to facilitate business knowledge and outcomes, leading data accuracy and logic testing, leading to new automated reporting for analytics and structuring teams.
Business Analyst
Calpine Energy Solutions
San Diego, CA
07.2020 - 09.2022
- Used VS Code to develop a GUI in Python using PyQt, resolving redundant ad hoc reporting requests by automating reporting from data gathering to email generation with results.
- Created SQL queries to assist with ad-hoc data requests, data framework validation and requirements building in UAT, and understanding how to incorporate SQL/SPROC in both VBA and Python
- Developed automation using VBA to improve efficiency managing certain ad-hoc requests, replacing data reprocessing and text file creation reduced overall completion time by 75%
- Improved analysts independent issue diagnosis and resolution capabilities by creating a comprehensive knowledge space in Confluence, which reduced the amount of (related) issues users reported by 40%
- Built summary tables detailing metrics in request, using Python and SQL connecting to Microsoft db
- Introduced automation for data gathering and structuring, reducing to-date team labor cost for Billing by $25,000
Education
Bachelor of Science - Business Administration: Finance
Portland State University
Portland, OR12-2018
Online Certification - Data Analysis with Python
FreeCodeCamp
04-2022
Online Certification - Visual Basic For Applications
California State Polytechnic University, Pomona
Pomona, CA04-2018
Skills
- Time Series Analysis
- Statistical Modeling
- Factor Analysis
- Optimization Techniques
- Financial Analysis
- Financial Modelling
- VBA
- Python for Data Analysis
- SQL
- Power BI
Languages
English
Native or Bilingual
Timeline
Quantitative Analyst
Calpine Energy Solutions
09.2022 - 04.2025
Business Analyst
Calpine Energy Solutions
07.2020 - 09.2022
Bachelor of Science - Business Administration: Finance
Portland State University
Online Certification - Data Analysis with Python
FreeCodeCamp
Online Certification - Visual Basic For Applications
California State Polytechnic University, Pomona