Lorena Schafer
Advanced Retirement Associate
Hire this person
Send a job offer directly to this candidate
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

