Andrew Shan Email & Phone Number

Sydney, New South Wales, Australia

North Ryde, New South Wales, Australia

Tutored both Practical and SGTA classes for STAT1250: Business Statistics.

6 Month Internship under the Macquarie Co-op Program followed by an extended internship for 3 additional months to assist with the Zurich Financial Year End 2022.Reconciled Claims values from the ledger to the internal policy database and investigated any profound differences utilising TM1 and SAP.Kicked off Prophet and DCS runs to determine investment reserves and validate projectionsApportioned Investment income and tax values to flow into the Analysis of Earnings… Show more 6 Month Internship under the Macquarie Co-op Program followed by an extended internship for 3 additional months to assist with the Zurich Financial Year End 2022.Reconciled Claims values from the ledger to the internal policy database and investigated any profound differences utilising TM1 and SAP.Kicked off Prophet and DCS runs to determine investment reserves and validate projectionsApportioned Investment income and tax values to flow into the Analysis of Earnings (AoE)Conducted UAT of a new ledger system to be implemented during the OPL Part 9 merge. Show less

6 month internship in both the ALM and Individual Life Pricing & Value teamsPrepared a report outlining TAL’s liabilities and the drivers behind their trends to provide greater visibility of liabilities to the ALM team.Extended the function of an internal net claims reserve calculator used by multiple stakeholders in validating their work.Analysed the change in lapse profit for a large inforce policy book using R and SQL to inform future retention… Show more 6 month internship in both the ALM and Individual Life Pricing & Value teamsPrepared a report outlining TAL’s liabilities and the drivers behind their trends to provide greater visibility of liabilities to the ALM team.Extended the function of an internal net claims reserve calculator used by multiple stakeholders in validating their work.Analysed the change in lapse profit for a large inforce policy book using R and SQL to inform future retention planning.Provided insights of the extent of cross-subsidies across TAL’s individual product line in preparation of the implementation of the new IFRS17 Accounting Standards. Show less

Worked on projects centred in the Private Health Insurance, Workers Compensation and other General Insurance practice areas.Assisted in developing and updating actuarial models in the valuation of clients, notably taking into account the effects of COVID-19 primarily in SAS and Excel.Organised and documented interviews with major PHI providers in order to sample and understand the impact of COVID-19 on the providers in particular regarding mental health claims.Tested… Show more Worked on projects centred in the Private Health Insurance, Workers Compensation and other General Insurance practice areas.Assisted in developing and updating actuarial models in the valuation of clients, notably taking into account the effects of COVID-19 primarily in SAS and Excel.Organised and documented interviews with major PHI providers in order to sample and understand the impact of COVID-19 on the providers in particular regarding mental health claims.Tested the output of a newly developed ANZSIC matching software through SQL to identify any inconsistencies or areas for further improvement. Show less

- Assessed the Data Quality and Completeness in preparation for analysis.- Used Data Analytics skills to analyse the data based upon customer demographics, address and transactions and make a presentation.- Used Visualisations to present data insights.

- A self-run Facebook Page dedicated to helping out high school students with Mathematics of all levels. Reached over 400 followers, primarily HSC students.

Bachelor Of Actuarial Studies With Professional Practice (Honours)

Co-op Scholar - University Medal - HD WAM - Macquarie University Award for Academic Excellence - Merit List 2020 - 2024 - 2020 KPMG.

Education record

Activities and Societies: Prefect, School Social Justice Group, Leadership Program, Duke of Edinburgh Award, School Orchestras, Nationals.