Reviewed and analyzed rate filings submitted by automobile insurance companies, using Excelto create company rate indication models, and test various assumptionsAssisted in dynamic capital adequacy testing (DCAT) review for various Ontario insurance companiesProofread rate filing final reports to ensure quality prior to sending reports to companies

Used Excel and VBA to create a tool for auditing pay history of locally engaged staff in embassies around the worldAnalyzed pension plans from various countries to assist in determining total employer liabilities Improved efficiency of auditing process of locally engaged staff pay history by formatting and validating data

Researched and analyzed available data, and industry practices to ensure quality of, and further develop, a risk model used to estimate optimal security investments related to natural disasters, cyber crime, pandemics, and terror attacksUsed a combination of python, HTML, and JavaScript to verify, and complete an online tool version of the model for use by critical infrastructure stakeholdersUpdated documentation regarding the mathematical functions implemented in the tool, and created a proposal detailing key areas of future development for the tool

Researched industry leading practices to analyze and recommend cost recovery models that best fit the Agency’s transition to a customer funded organizationInitiated process of baseline costing projected service linesGathered and summarized all current Agency cost recovery practices to be used as an educational tool during the Agency’s transition periodCreated outline for a risk tool regarding Agency staffing levels