Model points to calculate actuarial cashflow and Embedded Value, Value of New Business, etc. - annual audit work; improving assets liability management model and the coding performance in Excel VBA macros - consulting work; Adjusting the data interface to download bonds data from Wind financial terminal (similar to Bloomberg).

Rewriting the VB Script recording files from SAP GUI and developing new VB Scripts to complete a lot of competitive work by an automatic approach; Checking the output from Financial Product Subledger Account (FPSL in SAP) is correct and changing the configuration in SAP FPSL; Premium Allocation Approach (PAA); general measurement model (GMM); Liability for incurred claims (LIC); Liability for remaining coverage (LRC); Contractual Service Margin (CSM).

Valuation reserve in P&C by Chain-Ladder and Bornhuetter-Ferguson method to calculate IBNR and Statutory Reserves in the audit work; Developing the user interface by Bootstrap (a front-end open source framework); Writing C# codes to display the results in ASP.NET framework; Writing Python codes to calculate cashflow; Writing Excel VBA macros to upload data to MS SQL Server; Checking the output from GIx (GI Express) model is correct and reasonable; The GI Express project acquired Game Changer award in PwC; Premium Allocation Approach (PAA); general measurement model (GMM); Liability for incurred claims (LIC); Liability for remaining coverage (LRC); Contractual Service Margin (CSM).