Hi!

I'm
Steve Rynearson

Excel / VBA Developer

Hi!

I'm Jason Dawson

Ui/Ux & Print Designer

WELCOME


About Me

Hello, I am Steve Rynearson, Excel / VBA Developer.

I've spent almost 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: [email protected]

Skype: steven.rynearson

PROFESSIONAL skills


I'm Good At...

line-chart

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

2006 - 2011

Society of Actuaries

Accreditation Exams

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

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

phone

Phone number

1 (312) 469-0172

envelope-o

Email Address

skype

Skype

steven.rynearson