Hello!
I'm
Steve Rynearson
Excel / VBA Developer
Welcome
About Me
Hello, I am Steve Rynearson,
Excel / VBA Developer.
I've spent over 10 years using Excel, VBA, SQL, R, and more to manipulate, analyze, and present data.
In addition to data analytics, I've worked on many budgeting, forecasting, financial, and accounting projects.
Don't let my inner data-nerd fool you. I'm business and results oriented. I design tools that are user-friendly and can easily communicate with non-technical users.
Basic Information
Personal Details
website: automateexcel.com
Location: Austin, TX
Email: steve@automateexcel.com
Skype: steven.rynearson
Professional Skills
I'm Good At...
Data Analytics
Organize, manipulate, validate, analyze, and present data
Financial Spreadsheets
Accounting, budgeting, forecasting, and advanced financial analysis
Data Modeling
Use historical data to project the future
Coaching
Excel and VBA training and consulting
My Skills
Technical Skill Levels
Excel
VBA
SQL
R
C#, Javascript, & More
My Experience
Work Experience
2012 to Present
Founder
Spreadsheet Boot Camp LLC / Austin, TX
- Led Excel training for many student groups at large university across the country
- Consulted organizations on spreadsheet "best practices" to reduce errors and increase transparency
- Built data-processing from ground-up to turn days-long processes into a few clicks of the mouse
- Many other misc. Excel, VBA, data, and accounting projects
2008 - 2012
Pension Actuary
AonHewitt / Chicago, IL
- Prepared annual budgeting, forecasting, and accounting analysis.
- Conducted one-off assumption studies and other data projections.
My Education
My Studies
Relevant Actuarial exams:
Probability - Law of total probability, Bayes' theorem, basic counting, common discrete and continuous distributions, univariate and multivariate distributions, order statistics, transformation of distributions, conditional expectation, variance and covariance, basic knowledge of insurance and risk management
2006 - 2011
Society of Actuaries
Accreditation Exams
Financial Mathematics - Basic interest theory, annuities, bonds, loans, cash flows, portfolios, immunization, and financial derivatives, options, hedging, investment strategies, forwards, futures, and swaps
Construction and Evaluation of Actuarial Models - Severity models, frequency models, aggregate models, construction of empirical models, construction and selection of parametric models, estimating failure time and loss, determining the acceptability of a fitted model, credibility, simulation
2004 - 2008
University of Wisconsin / Madison, WI
BBA, Majors:
- Finance
- Actuarial Science
- Economics
- Risk Management & Insurance
Graduated University of Wisconsin - Madison in 2008 with a Bachelors of Business Administration. Majored in Finance, Actuarial Science, Economics, and Risk Management & Insurance. Member of Men's Track and Field team.
Let's Get In Touch
Contact Details
Email Address
steve@automateexcel.com
Skype
steven.rynearson
Consulting Services
ESG
A portion of Spreadsheet Boot Camp LLC's profits have been invested in renewable energy projects, working towards a greener tomorrow. These projects more than offset our environmental footprint from electricity consumption and travel. We are net neutral as of 2022.