Assistant Manager Payroll

Quyen Pham

979-***-**** Stafford, TX ***** ********@*****.***

EDUCATION

College of Natural Science and Mathematics, University of Houston, Houston, Texas

Bachelor of Science in Financial Mathematics May 2018

Minor in Risk Management and Insurance

ACTUARIAL EXAMS

Passed P Exam September 2018

Passed FM Exam February 2019

Completed VEE in Economics & Corporate Finance

SKILLS

Fluent in English and Vietnamese

Knowledgeable in Microsoft Excel, Access, Word, PowerPoint, R, and SQL

EXPERIENCE

American General Life Insurance Company January 2019 – Present

Actuary Associate

Lead actuary on new products testing.

Lead actuary on MCS conversion project.

Coordinate and assign training and testing scenarios to offshore team.

Understand insurance data and product knowledge of UL, GUL, Term, Index UL.

Provide technical specifications and business requirements for new products and features to be implemented in the Illustration software and web applications.

Develop software test plans while working with the Product, Pricing and Distribution Teams by using complex functions and macros in Excel.

Conduct user acceptance testing to ensure that developed system satisfied the needs of business clients as specified in the functional requirements.

Design, develop, and implement user acceptance testing protocols as the final phase of applications development.

Work with Pricing, IT/Ops, Distribution, Customer Care on actuarial and illustration issues.

Troubleshoot, report, communicate and explain concisely values discrepancies across software components.

Ensure accuracy of calculations and all values on all systems - Illustration and reprojection software and life policy administration systems.

Veterans Sourcing Group May 2018 – December 2018

Actuary Associate – Contractor for AIG

In-force illustration support training and backlog elimination.

Develop software test plans to test life insurance products on company illustration platform.

Acquainted with actuarial pricing of life insurance products.

Understand existing and new insurance products and verify any complex logic with pricing actuaries.

Troubleshoot, communicate and follow up software bugs using departmental bug tracking application.

Design, develop and implement comparison programs that valuate and project the behavior of life insurance products using matrix and Visual Basic for Excel.

QualiCom Investment, LLC June 2016 – April 2018

Assistant Manager

Assist manager with techniques and administrative support, directing, organizing, budgeting, payroll, staffing and planning.

Process checking and savings account deposits; conduct several audits on a weekly basis.

Use Spreadsheet for data extraction to run payroll.

Use pivot tables, macros in MS Excel

Provide administrative support with a high volume, customer-oriented setting.

Manage and update the company’s website.

Bambu Desserts and Drinks February 2014 – June 2016

Payroll Assistant

Managed and handled up to $2500 in cash and credit card payments daily

Train all new hires on POS system for time entry and order entry.

Use data extraction is spreadsheet to run payroll.

Confirm weekly hours for each employee for weekly payroll distribution.

Create weekly work schedules to ensure proper shift coverage.

Issue payroll checks

HONORS, AWARDS, PROFESSIONAL AFFILIATIONS

Insurance Council of Texas Scholarship Spring 2018

Dean’s List: Spring 2016, Fall 2016, Fall 2017

Transfer Excellent Scholarship Fall 2014

Member, Gamma Iota Sigma 2017 – Present

Contact this candidate