Keith C. Email & Phone Number

Hong Kong

Hong Kong Sar

• Working in and managing the production of economic assumption of different asset classes used for regular reportingand ad-hoc requests by Prudential’s local business units (BUs)• Providing guidance to BUs in resolving their economic assumption related technical challenges• Review the asset modelling methodology and optimizing the modelling process in python• Managing projects on asset modeling tool automation, development, enhancement (to python), and testing• Developing… Show more • Working in and managing the production of economic assumption of different asset classes used for regular reportingand ad-hoc requests by Prudential’s local business units (BUs)• Providing guidance to BUs in resolving their economic assumption related technical challenges• Review the asset modelling methodology and optimizing the modelling process in python• Managing projects on asset modeling tool automation, development, enhancement (to python), and testing• Developing and refining of asset modelling approaches, and presenting them to the stakeholders and management• Managing, coaching and support junior staffs on the work and administrative matters. Show less

Hong Kong Sar

Hong Kong, Hong Kong Sar

• Participated in the IFRS 17 data extract, transform and load (ETL) system function design and testing• Used the Power Query to test the ETL system functionality and comparing with that from delivery team• Assisted in the end-to-end model design to produce IFRS 17 related output using Prophet DCS• Assisted in the Group Internal Economic Capital Assessment (GIECA) on the lite model calibration for risk factor manually and in batch using python• Researched on IFRS 17 related… Show more • Participated in the IFRS 17 data extract, transform and load (ETL) system function design and testing• Used the Power Query to test the ETL system functionality and comparing with that from delivery team• Assisted in the end-to-end model design to produce IFRS 17 related output using Prophet DCS• Assisted in the Group Internal Economic Capital Assessment (GIECA) on the lite model calibration for risk factor manually and in batch using python• Researched on IFRS 17 related topic and presenting the findings to other coworkers Show less

Toronto, Ontario, Canada

Assisted audit team with reviewing assumption and methodology used to in the financial statement• Performed individual analysis on group health benefits pricing and renewal rate for the client• Conducted and presenting group life annuity pricing analysis for the client through reports• Participated in merger & acquisition (M&A) due diligence valuation and cost projections• Performed regular health care trend analysis and group health cost projection• Performed in asset… Show more Assisted audit team with reviewing assumption and methodology used to in the financial statement• Performed individual analysis on group health benefits pricing and renewal rate for the client• Conducted and presenting group life annuity pricing analysis for the client through reports• Participated in merger & acquisition (M&A) due diligence valuation and cost projections• Performed regular health care trend analysis and group health cost projection• Performed in asset liability modelling (ALM) to optimize investment strategy for the asset portfolio Show less

Toronto, Ontario, Canada

Toronto, Canada Area

Toronto, Canada Area

-Prepared and reconciling client raw data for claim analysis -Assisted consultants preparing post-employment benefit valuation using ProVal -Assisted consultants performing group health plan price analysis, renewal analysis and preparing draft deliverables -Assisted consultants redesigning client’s group health and benefit plans and preparing draft deliverables -Compared different health and benefits plans from different carriers with each other as well as with industry… Show more -Prepared and reconciling client raw data for claim analysis -Assisted consultants preparing post-employment benefit valuation using ProVal -Assisted consultants performing group health plan price analysis, renewal analysis and preparing draft deliverables -Assisted consultants redesigning client’s group health and benefit plans and preparing draft deliverables -Compared different health and benefits plans from different carriers with each other as well as with industry benchmarks Show less

Toronto, Canada Area

- Prepared and reconciled client raw data for pension plan actuarial valuation- Assisted analysts with production of year-end accounting disclosure for pension plans.- Assisted consultants preparing pension valuation and presenting the results to the clients- Prepared and analyzed participant data extracted from retirement database- Prepared benefit calculations, employer benefit statements and annual government forms

Toronto, Canada Area

• Assisted senior analyst preparing filing exhibits to Financial Superintendent Commission of Ontario• Updated and simulated the pricing algorithm using SAS and Radar• Updated pricing calculator with new pricing algorithm• Researched industrial trend for new product and presented findings and recommendation to the team

Toronto, Canada Area

- Reconciled raw data using excel with the loss triangles in the AA's report.- Applied age-to-age factor and various projection methods to calculate and select ultimates.- Assisted senior actuaries identifying the trends and outliers in the loss triangles.- Assisting manager on peer reviewing on AA's report the clients.- Assisted audit team with the verification on the notes to financial statement.- Performed minimum capital testing / branch adequacy of assets testing under… Show more - Reconciled raw data using excel with the loss triangles in the AA's report.- Applied age-to-age factor and various projection methods to calculate and select ultimates.- Assisted senior actuaries identifying the trends and outliers in the loss triangles.- Assisting manager on peer reviewing on AA's report the clients.- Assisted audit team with the verification on the notes to financial statement.- Performed minimum capital testing / branch adequacy of assets testing under newly published 2015 guidelines. Show less

Ottawa, Canada Area

- Developed sanity test plan for the Eperformance products, and ran through tests manually on each release initially- Automated the test cases in the test plan and diagnosed and reported any found issues after running them every time- Provided technical support when an issue was reported by a client through telephone or online portal- Done coding in C#, .Net Development ,LINQ, JQuery, SQL and working with Windows products such as CRM, Visual Studio, IIS, SharePoint ,SQL Database and… Show more - Developed sanity test plan for the Eperformance products, and ran through tests manually on each release initially- Automated the test cases in the test plan and diagnosed and reported any found issues after running them every time- Provided technical support when an issue was reported by a client through telephone or online portal- Done coding in C#, .Net Development ,LINQ, JQuery, SQL and working with Windows products such as CRM, Visual Studio, IIS, SharePoint ,SQL Database and Team Foundation Server (TFS)- Developed software design specification (DS) for a new feature based on the discussion between the business analyst (BA) and the client- Worked comfortably on the features for every project individually or with other teammate- Developed test cases of the feature for the quality assurance (QA) to test- Fixed the bugs reported by the QA or the clients and documented every bugs and features for future reference- Done research on the new technology to be implemented in the product in order to improve the performance of the software Show less

• Created sanity test plans using various software testing strategies including black-box testing, white-box testing and so on and also tested the newly added features.• Responsible to monitor, install and upgrade the newly-built template• Worked with senior software developer to solve the aroused issues during the template install and upgrade• Fixed bugs found by SV team and replied to them after submitting the solution• Documented every bug ticket and its fix for future… Show more • Created sanity test plans using various software testing strategies including black-box testing, white-box testing and so on and also tested the newly added features.• Responsible to monitor, install and upgrade the newly-built template• Worked with senior software developer to solve the aroused issues during the template install and upgrade• Fixed bugs found by SV team and replied to them after submitting the solution• Documented every bug ticket and its fix for future reference• Worked with Support team to debug the issues reported by the customers. • Familiar and comfortable to work in Agile environment (Scrum team) • Done coding in Java, JavaScript, Ajax, JSP and JSF to develop web UI and applications • Done coding in SQL and worked with Postgres and LDAP database to provide authentication and authorization services• Cooperated with another colleague to develop a automation tests in Java for web UI sanity testing• Took courses related to programming with JSF, EJB 3.0 and JPA using JBoss 5.0 Show less

Bachelor Of Science (B.Sc.), Actuarial Science

Activities and Societies: University of Toronto Actuarial Science Club Actuarial Science Specialist Economics Major Computer Science Minor

Bachelor, Telecommunication Engineering

• Current CGPA 9.3/12 • Graduation year 2010 • Dean’s Honor List • In-course Scholarship Award