Har Kong

Data Analyst Manager

Equitable•  May 2019 - April 2021

• Develop product models in Excel using VBA for handling massive amounts of data and complicated formulas for calculation, based on actuarial and product specifications • Calculate expected policy results to validate and confirm calculations in the administrative system • Analyze data and results, investigate discrepancies, report findings to supervisor/manager and IT, and resolve issues with IT • Track all issues and problems and create status reports • Assist in individual annuity new product implementation • Assist in providing ongoing actuarial support on Individual Annuity products as company was headed into its first IPO

Actuarial QA Analyst

AXA Equitable•  March 2018 - May 2019

• Review actuarial and business to understand the requirements of the product or enhancement • Worked on multiple teams to provide data modelling and benchmarking • Developed annuity product models • Develop and modify test conditions/cases • Run test cases and compare results to in house Check system • Trace test case results to debug and analyze results • Report defects and status of the review using HP Quality Center or Lotus Notes tools and work with IT, in-house programmers and actuaries to get problems resolved • Track status and of condition review and defects and provide status report at periodic meetings • Run regressions • Work on the Production migration of illustration enhancements which occur after business hours on nights and weekends, typically beginning on Friday nights