Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

John Wade | Elance
 
176985602337900
Last Sign-in: Apr 20, 2015

John Wade

Actuarial & ERISA Applications Developer
   United States
  |   Farmington Hills, MI

Verified Freelancer

John Wade's identity has been verified.  Learn More

Overview

Minimum Hourly Rate $55

Defined benefit pension consultant with experience in managing client engagements, computing liabilities for funding and accounting valuations, computing benefit liabilities for PBGC 4010 purposes, and in developing actuarial and employee benefits-related applications in Excel.

Developed XFactors, a suite of built-in Excel functions that compute single-life and joint-life actuarial present value factors.

Developed employee benefits-based applications for the National Security Agency (NSA), the National Imagery and Mapping Agency (NIMA),...

Read More »

Portfolio

Created this application, prior to PPA, in order to calculate tables of present value...

Skills (9)

Tested
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
VBA
My Score
avg
XLL Development
ERISA
Business Process Efficiency
Funding and Accounting Actuarial Valuations
Benefits Administration

Service Description

Analysis of defined benefit pension plan provisions in order to code valuation software to produce reasonable liabilities.

Analysis of business processes in order to streamline the summarization of complex valuation output, improve the accuracy of results, and reduce the number of hours required to generate results summaries.

Develop applications to assist with pension experience studies, check pension valuation liabilities, and compute key amounts used in funding and accounting valuations.

Develop employee benefits statements

Compute PBGC 4010 benefit liabilities

Read More »

Employment

Buck Consultants
Retirement Consultant, Project Manager
2009 - 2014
Managed a variety of client engagements for Buck's Global Valuation Center, performed project planning and annual funding and accounting valuations, calculated PBGC 4010 benefit liabilities,...
Aon Consulting
Assistant Vice President - Retirement
2007 - 2008
Responsible for maintaining broad-based understanding of numerous aspects of employee benefits law. Served as resource to junior staff for guidance on particular projects. Performed GASB pension...
Buck Consultants
Retirement Consultant, Project Manager
1997 - 2007
Performed valuation project planning and annual funding and accounting valuations, developed and/or refined numerous actuarial spreadsheet applications, prepared valuation reports and Governmental...
Towers Perrin
Actuarial Analyst, Client Leader
1995 - 1997
Performed benefit calculations and annual pension valuations, prepared valuation data and Governmental filings.
Ernst & Young
Actuarial Analyst
1993 - 1995
Performed annual pension and post-retiree medical valuations, benefit calculations, processed valuation data, prepared Governmental filings
United States Air Force
Acquisition Project Officer
1988 - 1992
Managed the acquisition of defense-related hardware and software for the Defense Meteorological Satellite Program. Coordinated the efforts of contracting officers, engineers, and other project...

Education

University of Akron
Bachelor of Science in Applied Mathematics
- 1987
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

actuarial
VBA
Excel
VB.net
ERISA
XLL
pension
PBGC 4010
automation
employee benefit statements
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
jtwade2020
Type
Individual
Member Since
March 2014
Elance URL
Verifications
0
Groups
John Wade | Elance

John Wade