John Taylor Email & Phone Number

Experienced Technical Application Consultant with a demonstrated history of working in the defined benefits industry. Skilled in Visual Basic for Applications (VBA), Microsoft Office and a strong actuarial background. Information technology professional with a Bachelor of Science in Mathematics and a Master of Science - MS focused in Education from University of New Haven.

Listed skills include Visual Basic For Applications, Microsoft Excel, Actuarial Science, Microsoft Office, and 15 others.

• 

  Senior Technical Applications Consultant

  Usi Consulting Group

  Mar 2012 - Present - Glastonbury, Ct

  Technical Applications Consultant:-Build complex benefit calculation systems to handle all situations including early/normal/late retirements, Required Minimum Distributions, and QDROs. Ensuring benefit calculations follow the provisions of the Plan Document and the IRS regulations.-Maintain and develop new tools for a proprietary actuarial tool add-in for the department. This includes deriving the mathematical formulas and programming these into generic functions.-Build and maintain Access databases to be used by the department as a means of recordkeeping for clients.-Develop new tools to help increase efficiency in the department. This includes work flow improvements, recordkeeping efficiencies, valuation report improvements, batch calculators, among others.Actuarial Analyst:-Perform actuarial valuations of defined benefit pension plans-Complete multiple plan terminations, including IRS filings, PBGC filings, participant notices and election forms, and experience with the missing participant program and calculations.-Complete GASB and FASB disclosures and government filings including IRS Form 5500, 8955-SSA, and PBGC with appropriate schedules and attachments.-Experience with ProVal