XINYU WANG

• Delivered a diversity of expert actuarial services including insights and best practice support for local/international clients in IFRS 17 reformation initiatives, in AXIS DataLink models conversion, valuation model update and integration, financial reporting analysis, data warehouse specification and validation, and parallel runs model office change support;
• Spearheaded development, upgrade and optimization of full-cycle GMM, VFA and Reinsurance RI validation engines for multiple business use cases, and a SAS-modeled cash flow discounting and CSM recalculation tool for report analysis;
• Led and managed communications in workshops, sprint presentations and calculation illustrations directed to stakeholders;
• Conducted actuarial audits and methodology reviews on IFRS 17 discount curves and LRC and LIC valuation roll-forwards.

• Provided expertise technical advisory to full-scale insurer regulatory compliance projects on accounting and actuarial policy gap assessments, target state system analysis, and compliant calculation models implementation, enhancement and debugging;
• Developed, maintained and improved an RI validation tool for core model calculations and financial statementnanalyses with automated functionalities for scenario output testing;
• Built actuarial calculations and slideshow presentations for a diversity client deliverables, e.g. CSM interim reporting;
• CSM interim reporting; Supported year-end Actuarial Audits including detailed testing and AXIS valuation assumptions reconciliations.

• Interpreted and specified business requirements on future policy reserve calculations for LDTI/GAAP transformation;
• Modelled the new Reserve Engine (RE) by coding data inputs, products and variables in DCS and Prophet Professional;
• Coordinated with variety of System teams for development of data process flows for RE Input Database build and integration.

Commercial Insurance Pricing

• During semi-annual rate review, built Emblem pricing models and proposed differential selections for Contents and Equipment & Tools perils, by creating SAS modeling data, analyzing a range of rating variables, and conducting model evaluation tests, including Chi Square and F statistics, inclusion/exclusion, time consistency and AIC tests;
• Updated and imported SAS premium rate tables for an array of property and casualty liabilities for the RTG rate system dislocation project.

Corporate Reserving

• Completed thorough analysis of multiple PD & Collision business lines for quarterly reserve valuation and projections, including IBNR true-up, LDF and ELR selections, methodology selection, and interpretation of deviations and trends;
• Streamlined the data structure and compilation process in Excel for the annual reporting CIFRS Disclosures project;
• Implemented an elaborate template for the General Ledger and ResQ Actuarial Data reconciliation procedure with extensive SAS and Excel data summarization.