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.

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.

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.

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.

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.

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.

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.

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.