Francesca F. Laurant

*** ***** ****** *** * Hoboken, NJ 07030

860-***-****

acqzr5@r.postjobfree.com

QUALIFICATIONS:

Experienced senior actuarial assistant with excellent project management, technical, people skills and a track-record of success

Advanced MS Office (Access, Excel, Word, PowerPoint), Programming (VBA, SAS, SQL), Outlook

Professional Certifications: passed 4 actuarial exams (P, FM, SOA MFE and CAS Exam 3)

Over six years of actuarial analysis and data management experience

WORK HISTORY:

UBS Weehawken, NJ

Consultant May 2015-Present

Performed excel analysis to identify discrepancies as UBS began using a new payroll data system

Collaborated with team members to address and coordinate data fixes

Initiated payroll report and monitored financial data (items monitored were earnings, vacation, leave pay, holidays, carry over vacation, sign on bonus and other payroll information) for UBS wealth management

Carat New York, NY

Data Analyst Feb 2015-May 2015

Performed SQL queries against data gained via digital marketing campaign

Analyzed data for campaign performance of multi-billion dollar clients

Created VBA program that automated formatting of non-standard excel files and performed prescribed calculations to provide marketing cost metrics

Student and Private Tutoring-Math, French and Sciences Sept 2011-Feb 2015

UnitedHealth Hartford, CT

Actuarial Analyst Jan 2009-Aug 2011

Interpreted dental cost trends and drivers for dental group insurance

Developed pricing bid using actuarial model for Medicare plan for multi-million dollar healthcare

companies

Updated model assumptions and automated pricing bid creation

Resolved client requests

The Hartford Hartford, CT

Actuarial Student Program April 2008-Jan 2009

Conducted catastrophe analysis; assisted in methodology change for ‘cat load’

Created state filings; automated exhibits using Excel/VBA programming

Analyzed loss development and excess loss

Produced monthly reports to calculate assessment from the states for uninsurable risks

Travelers Hartford, CT

Actuarial Analyst Jan 2005-April 2008

Updated Risk Committee report analyzing the types of risks written by business category for executives at the company for decision-making

Completed semi-annual rate adequacy for $1.4B Commercial Multi-Peril (MasterPac) book of business

Collaborated on product development initiatives with product team; Researched and compared rates against competitors

Responded to Department of Insurance’s information requests

VOLUNTEER WORK:

Hoboken Shelter, Hoboken, NJ Oct 2014-Present Helped serve dinner to homeless

Malta House of Care Foundation Hartford, CT Feb 2013 – Sept 2013

Medical volunteer assisting low income and uninsured patients

UCONN Migrant Farm Clinic Farmington, CT Summer 2013 Volunteer assisting migrant farm workers

EDUCATION:

Trinity College Hartford, CT December 2004

Bachelor of Science in Mathematics, Dean’s list, Resident Assistant, Math Teaching Assistant

LANGUAGES:

Fluent English, Native French speaker, German (Basic)

Contact this candidate