Skip to main content
Lorena Schafer

Lorena Schafer

Advanced Retirement Associate

Talent
CA, USMember since November 18, 2026
ExcelAFTAPsExperience Studies
·

Hire this person

Send a job offer directly to this candidate

ExcelAFTAPsExperience Studies

About

Retirement actuarial professional with experience leading valuation teams, managing a pension and OPEB client portfolio, performing funding and accounting valuations, benefit calculations, nondiscrimination and top-heavy testing, and government filings. Additional work includes pension plan-design cost studies, experience studies, and de-risking projects. Also brings actuarial-software and data experience.

Experience

Advanced Retirement Associate - Aon

(2015 - 2017)

  • Analyzed IRS and FASB governed valuations, financial deterministic projections, and stochastic forecasting for use in actuarial opinions
  • Managed annual government reporting and regulatory compliance filings, including Form 5500s, Schedule SBs, AFTAPs, and PBGC premium filings across defined benefit plans
  • Led nondiscrimination testing, top-heavy testing, experience studies, and plan-design studies, and proposed design changes
  • Designed and mapped actuarial data and valuation models into ProVal, meeting government-regulated conversion thresholds

Experienced Retirement Associate - Aon

(2007 - 2014)

  • Led teams preparing pension and OPEB valuations for funding and accounting under PPA, ERISA, FASB 715, IAS 19, FASB 960, and FASB 106
  • Performed cyclical funding and accounting work for a cash balance plan with $800 million in assets, including benefit calculations, quarterly participant statements, and a lump-sum window
  • Managed a book of pension and OPEB clients with $1.5B in assets, improving profitability 13% and sustaining long-term client relationships
  • Produced or reviewed more than 25 benefit calculations per week for retirements, vested terminations, and QDROs, and interpreted plan documents to answer client questions
  • Performed DB/DC cost-benefit analyses, asset-liability projections, and forecasts, including design changes that lowered cost volatility
  • Ran de-risking projects, including plan terminations, early-retirement windows, and lump-sum windows

Consultant, Actuarial – P&C - Nationwide

(2025)

  • Implemented a software redesign that moved data transformation from SQL to Python so process changes could be made without weakening reliability
  • Tested and measured the effect of code changes so leaders could judge new requirements before adoption
  • Explained complex SQL and Python logic, the data lifecycle, and model results to technical and non-technical stakeholders

Senior Consultant - Infoverity U.S., Inc.

(2022 - 2025)

  • Led a pilot software conversion from on-premises infrastructure to a SaaS platform and ran client workshops on features and best practices
  • Wrote and executed test scripts for platform migration and related features, confirming functional requirements were met before release
  • Partnered with business and technical stakeholders to define functional and technical requirements for a PIM migration
  • Profiled customer and product data in SQL, Excel, and Power BI; defined requirements and data-quality rules that improved key metrics.

Financial Consultant - Actuarial - Nationwide

(2017 - 2022)

  • Built a business-intelligence reporting solution that gave stakeholders a clearer view of financial results
  • Acted as data steward across business units, finance, underwriting, and IT to gather requirements and manage the data strategy
  • Streamlined warehouse pipelines for member, policy, premium, and claim data used in financial and pricing analysis, cutting manual work and processing time
  • Set data-strategy requirements across life, accident and health, and property and casualty products so KPIs were available in time for decisions

Manager - Deloitte

(2014 - 2015)

  • Directed a 12-member team on two concurrent workstreams, setting timelines and review protocols for government task orders
  • Created and implemented standard operating procedures for benefit-calculation correction and review so results were consistent and accurate
  • Led client meetings and weekly status and KPI reporting; built onboarding and training so new team members could contribute quickly

Education

B.S. - Actuarial Science - The Ohio State University, Columbus, OH

Skills

Advanced Retirement Associate

Reviews

Related