Amanda Williams, Senior Actuarial Analyst

Years of Experience: 13

Education

• Graduated Reed College with a Bachelor of Arts in Mathematics

Special Areas of Expertise

• As an Actuarial Assistant with EFI Actuaries since October 2009, Ms. Williams prepares client data for actuarial valuations, drafts preliminary valuations for review and works on various special projects for the actuaries.
• As a consultant to hospitals Ms. Williams merged and reconciled data between systems as well as prepared reports analyzing performance and revenue.

Experience

Merced County Employees Retirement Association

· Prepared data for experience study analysis by reconciling data from year to year

· Prepared data for valuation

Kern County Employees Retirement Association

· Prepared data for an actuarial audit of system valuation and experience study by gathering and formatting member data

· Prepared data for valuation

Marin County Employees Retirement Association

· Prepared data for experience study analysis by reconciling data from year to year

· Prepared data for valuation

Stanislaus County Employees Retirement Association

· Prepare data charts and tables for inclusion in report

PMI Mortgage Insurance

· Performed statistical and data analysis of mortgage portfolios and economic impact

· Create databases in Access for ad hoc and recurring reporting and analysis.

San Jose Medical Center

· Prepare and manage monthly reports to analyze experience by Payer

· Prepare and manage What-If reports to project revenue for contract revisions based on previous experience.

San Leandro Medical Center

· Prepare and manage monthly reports to analyze experience by Payer

Marc Richards Consulting

· Built a standalone Access database program for tracking applicants and compaies for an executive recruiter

Trixie’s Vintage

· Created proprietary standalone database with custom user interface to manage inventory and revenues using Access

Programs and Operating Systems

· FoxPro

· Access

· Excel

· Windows

· Unix