Thomas Spanos Email & Phone Number

Hamilton, On, Ca

Toronto, Ontario, Canada

Reinsurance AdministrationData Management/ETL WorkProcess client statements and reconcile revenue and NARFocus on data quality by identifying, escalating and remediating data issuesRetention managementClient premium accountingOn boarding new clients and/or treatiesAssist claims team with claim adjudicationImprove operations control environment/assist with internal auditServe internal customers by answering queries regarding client reporting anomaliesUAT Testing/System enhancement projectsComplete control reports such as New Business report, revenue & suspense report.

Toronto, Ontario, Canada

Inforce Analysis, mortality experience studies, system expertise, volatility review, project work

Toronto, Ontario, Canada

ETL/Mapping workWrite and test code that allows ETL tool to produce loadable data New deal certificationsData AnalysisClaims mapping & testing Ad-hoc requests, analyses and map CRs

Toronto, Ontario, Canada

Service retrocession clients Administer & reconcile NAAR, premiums and claims Review data quality & governance issues Propose time saving enhancementsLoad all client reporting into LRM and explain variancesFollow up on audit issuesAssist internal auditUpdate control reports Answer inquiries from finance and actuarial teams Answer JIRA tickets and assist production team with LRM file loadingTest new code releases and propose changesDevelop, write and test new Change Requests (CRs) Assist with client novations & recaptures Develop and maintain documentation to assist with manual interventions Present reconciliation challenges to Sr. ManagementAnswer JIRA tickets and assist production team with LRM file loading Test new code releases and propose changes Develop, write and test new Change Requests (CRs) Assist with client novations & recaptures Develop and maintain documentation to assist with manual interventions Present reconciliation challenges to Sr. Management

Toronto, Ontario, Canada

ValuationConvert MS Excel based Long Latency Occupational Disease model to GGY Axis. Set up Actuarial assumptions and methods and project future CFs and actuarial liabilities. Perform monthly & quarterly costing and experience trackingUpdate and maintain Arrears and Expense valuation modelsPerform analysis and modelling for as-hoc requests from the operations department.

Toronto, Canada Area

Operations - RetrocessionUpload transactional and inforce files and verify that inforce coverages are compliant with the treaty and in line with expectations. Verify that the premiums and NAAR are consistent with prior quarters. Escalate any issues with a significant financial impact. Perform treaty compliance when new business is booked to confirm that premiums are being correctly calculated using appropriate underwriting and mortality factors. Assist in audits to ensure clients have proper controls and processes in place. Follow up with clients to ensure the timely resolution of audit issues.Verify the accuracy and validity of claims submitted by clients.Update and maintain various monthly/quarterly reports pertaining to lapses, accruals and premium variances.

Toronto, Canada Area

Economic Capital Modelling - Enterprise Risk ManagementCreated a MS Excel based application using a combination of VBA code and SQL stored procedures. The application efficiently extracted and summarized the data and results from the economic capital model. The application provided valuable insights into the tail of the model distribution for various regions and lines of business. Assisted the actuarial team with updating the model assumptions (inflation, interest, credit spread, total expenses) and methodologies. Conducted Var/TVaR analysis using Monte Carlo simulation and bootstrappingAssisted with analyses and reports related to capital allocation and RAROC. Performed modelling and distribution fitting for frequency and severity distributions using techniques such as method of moments, MLE, graphical methods and hypothesis testing.

Toronto, Canada Area

Individual Reinsurance OperationsUsed Sequence to develop code which translates client data into a form that is usable for internal users in accounting and corporate actuarial. Used SQL to run queries on translated data tables to verify that the sequence code translated data correctly.Developed unique business rules for client data files which did not originate from the TAI reinsurance system.

Toronto, Canada Area

Actuarial AuditAnalyzed relevant evidence and documentation to assist with the completion of Defined Procedures Audits, Key Risk Audits, and Sarbanes-Oxley (SOX) testing. Collected data templates, raw data, memos, reports from auditees and used them to test the effectiveness of key actuarial controls Collaborated with the Audit Director and Audit Lead to draft a summary of findings and issues to present to the client Audited many areas such as Segregated Fund Required Capital, Group Benefits Pricing, Corporate Actuarial, SOX

Montreal, Canada Area

Retail Markets- Actuarial Pricing-Segregated FundsUsed MS Excel to carry out a tracking error analysis which measures how the daily movement of the segregated fund Net Asset Value (NAV) deviates from the benchmark index (S&P 500, EAFE, etc...)Used MS Excel to perform an analysis of industry MERs and write a report summarizing how SL's Segregated Funds are priced compared to the rest of the industry