William Reagor
Chicago
Summary
Results-driven Associate Analyst at Allstate Investments, with expertise in SQL, performance attribution, and quantitative modeling. Successfully managed cross-functional model development, enhancing operational efficiency, and delivering actionable insights. Proven ability to collaborate effectively with stakeholders, driving model development that optimized investment strategies and supported multi-million-dollar trades.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Associate Analyst
Allstate Investments
Chicago
02.2025 - Current
- Managed cross-functional product development and new product introduction for quantitative models across multiple asset classes.
- Refined ambiguous VP goal into actionable product roadmap by interviewing stakeholders and prioritizing features, then launched a model and provided support post-launch.
- Spearheaded model development projects, managing timelines, deliverables, and cross-functional collaboration from development to completion.
- Conducted in-depth multi-level performance attribution across entire multi-million dollar Allstate portfolio and underlying nodes to inform stakeholder decision making, and responded to time-sensitive portfolio manager inquiries thoroughly and accurately.
- Supported and enhanced existing quantitative models and associated applications, ensuring they meet evolving business needs and remain robust and accurate.
Quantitative Specialist
Allstate Investments
Chicago
09.2022 - 02.2025
- Owned the development of fundamental and quantitative models across the entire municipal bond asset class.
- Drove collaboration between data analysts, portfolio managers, and IT to build sophisticated quantitative models for multi-million dollar trades across multiple asset classes.
- Developed performance attribution model to measure portfolio manager success and provide critical insights used to optimize investment strategies.
- Enhanced operational transparency and efficiency by automating distribution of key metrics and data visualizations aimed at informing senior managers and shareholders.
- Demonstrated technical proficiency in SQL through the writing, and debugging of complex stored procedures for efficient and accurate data processing, alongside ensuring seamless data migration from development to production environments and resolving ad hoc issues to maintain system reliability.
Education
Master of Science - Economics
Texas A&M University
College Station, TX08.2025
Bachelor of Science - Economics
Texas A&M University
College Station, TX08.2025
Skills
- Microsoft SQL Server
- Microsoft Excel
- DAX and VBA functions
- Python libraries (Pandas, NumPy, Matplotlib)
- Microsoft Power BI
- Tableau
- R-Studio
- SAS
- Statistical modeling
- Data cleansing and visualization
- Data mapping and analysis
Certification
SAS Certified Associate: Programming Fundamentals Using SAS 9.4, SAS Global Certification Program, SAS, 08/01/22
Technical Skills
High-level data mapping, writing and editing stored procedures, PROC SQL, OLS regression, statistical analysis, data cleansing, data visualization, Time Series Forecasting, OLS regression, statistical functions, data cleansing, data visualization, Pandas, Numpy, Matplotlib, Pyodbe, basic econometric functions, data visualization, DAX, data visualization, Data visualization, VBA, Xlookup, data visualization
Timeline
Associate Analyst
Allstate Investments
02.2025 - Current
Quantitative Specialist
Allstate Investments
09.2022 - 02.2025
Master of Science - Economics
Texas A&M University
Bachelor of Science - Economics
Texas A&M University
Similar Profiles
Joanna PorzeckaJoanna Porzecka
LOAN SERVICING MANAGER at ALLSTATE INVESTMENTS, LLCLOAN SERVICING MANAGER at ALLSTATE INVESTMENTS, LLC
Prajwal M BPrajwal M B
Lead Consultant at Allstate India Private Limited (Allstate India)Lead Consultant at Allstate India Private Limited (Allstate India)
JONORA SEARLESJONORA SEARLES
Healthcare Land Developer at JES Investments LLC / MDE Investments LLCHealthcare Land Developer at JES Investments LLC / MDE Investments LLC
Blake Hamilton CurrieBlake Hamilton Currie
Substitute Teacher at Chicago Public Schools CPSSubstitute Teacher at Chicago Public Schools CPS
Annette LankingAnnette Lanking
Site & Event Operations Associate at Hyatt RegencySite & Event Operations Associate at Hyatt Regency