| Underwriters to fill out the BEIGE sections only | |
| Programme Name | {{issue.summary}} |
| Date Created | {{now.format(“dd/MM/yyyy”)}} |
| Underwriter | {{issue.customfield_10588}} |
| Capacity Provider | {{issue.customfield_10293}} |
| Submission name | {{issue.customfield_10545}}_ {{now.format(“yyyyMMdd”)}} |
| Path to data files | <Path to Excel files> |
| YOA | {{issue.customfield_10192}} |
| Deal Type | {{issue.customfield_10166}} |
| Submission Type | {{issue.customfield_10294}} |
| Cleansing Due Date | {{issue.customfield_10588}} |
| Modelling Due Date | {{issue.customfield_10149}} |
| Quote Due Date | {{issue.customfield_10162}} |
| Reinsurance Programme Details | |
| Is there Lloyd’s exposure? | |
| If Yes, is it the whole portfolio? | |
| If Yes, is it certain sections, and which sections? | |
| Are there some lloyds policies mixed up within sections with non lloyds policies? | |
| Does this portfolio include binders? If so, how are they identified? | |
| Does this include Tech E&O? | |
| If yes, in policy line or as coverage area? | |
| Expected BDX premium and aggregate limit (by Original Section) | |
| What is the currency of the original submission? | |
| Forecasting details (by Section) if available | |
| Forecasting KPIs (including Tech E&O if applicable) by Section if available. Eg. Forecasted Premium, Forecasted Policy Count, Forecasted Aggregate Limit How should the quota share be recorded or calculated? Comments |
|
| List the section names and their sheet names in the raw data, including RBE and DA: | ||
| Section name | Risk Bearing Entity | Delegated Authority |
| section1 | CapacityProvider1 (Do not abbreviate the name, we require the full name, i.e. BICI should be ‘British Caribbean Insurance Company’ ) | MGA1 (Do not abbreviate the name, we require the full name, i.e. BICI should be ‘British Caribbean Insurance Company’ ) |
Modelling & Analysis
Modelling team to fill out the PURPLE sections below only
| Task | Value |
| Analysis performed by | |
| Today’s date | |
| Were there documents accompanying the portfolio that outline any constraints that need to be taken into account when cleaning the submission and have these been read? | |
| Provide analysis on the following: | |
| Sections | |
| Limits | |
| Attachments | |
| Exclusions | |
| Microsegment breakdown |
Data Analysis
Data Handlers to fill out all the GREEN sections below, only
| Task | Value |
| Analysis performed by | <Data Handlers Name> |
| Today’s Date | <date> |
| Were there documents accompanying the portfolio that outline any constraints that need to be taken into account when cleaning the submission and have these been read? | |
| Provide links to all of the relevant documents mentioned above. In absence of these documents, post a link to the box folder that was checked for them. | <Link(s) here> |
| In-Force Name Policy Bordereau checks:
Do any of the following exist? |
|
| Company Names | Yes/No |
| Company URL’s | Yes/No |
| Revenues | Yes/No |
| Tech E&O | Yes/No
If the UW has indicated two sections: yyz and yow and if there is tech e&o in both sections, then the sections would look like: |
| Industry | Yes/No |
| Inception Date | Yes/No |
| Expiration Date | Yes/No |
| Attachment | Yes/No |
| Premium | Yes/No |
| Limit | Yes/No |
| 100% Limit | Yes/No |
| Policy ID (something that maps to claims listing which is also requested) | Yes/No |
| Coverage area splits and more granular information like broker, zip code, etc. always welcome | Yes/No |
| Claims | |
| Are Ground-Up Claims listings included? | Yes/No |
| If Claims exist, insert the Claims Jira ticket and assign the ticket to yourself for completion | Type: None, Partial (>100k), or Full
<Create & Insert Jira ticket url from this board > Format: <cedant>_<YYYYMMDD>_claims |
| Company Names | Yes/No |
| Policy ID (something that can map to the policy bdx) | Yes/No |
| Loss reserve information (incurred loss+ alae at the minimum or more granular) | Yes/No |
| Claims status (open, closed) | Yes/No |
| Loss description | Yes/No |
| Loss Triangles | |
| Are loss triangles present? | |
| Are Ransomware triangles split out? | |
| Underlying Primary Policy Wording | |
| Modelling Outputs | |
| Treaty Performance (if applicable) | |
| Insert Sublimit table as Markdown, below: | |
| <Markdown text goes here> | |
Pre Enrichment & Ingestion Analysis – Data Review
| Task | Value |
| Analysis performed by | <Data Handlers Name> + <Peer reviewers name> |
| Today’s Date | date |
| If Tech E&O section names exist, insert them here as well as in the Jira ticket | <i.e. siriuspointcorvus_20230725-cyber> |
| Have Github and Google Cloud naming conventions been followed? | Yes/No |
| Is the column mapping correct (sublimit mapping) | Yes/No |
| Deductibles | Yes/No |
| Waiting times | Yes/No |
| Have basic checks been done in raw v standardised submission comparison? | Yes/No |
| Identify the rules responsible for biggest change and provide the rational here: | Yes/No |
| Optional Comments | |
Post Enrichment & Ingestion Analysis – QA
| Task | Value |
| Analysis performed by | |
| Today’s Date | |
| What is the total limit? | |
| What is the Total premium/subject base? | |
| Provide a breakdown by peril | |
| Quality control checklist: | |
| Spot check top risks | Yes/No |
| Is the premium correct? | Yes/No |
| How did it compare to last year? | |
| Do the forecasting portfolio growth parameters v growth output look acceptable? (sum of premium and policy count by section and peril) | |
| Are the limit bands correct? | Yes/No |
| How did it compare to last year? | |
| Are the retention bands correct? | Yes/No |
| Do quota shares look ok? | Yes/No |
| Does the primary/excess split make sense, based off the policy listing? | |
| Does the microsegment breakdown look reasonable based on: | Yes/No |
|
|
|
|
|
|
|
|
| Is Enrichment rate as expected? | |
| Have the following attributes of the product been fully checked and verified: | |
| Have the Exclusions been excluded and sub-limits been sub-limited by section when compared to last year? | |
| Endorsements (Standalone / Add on) | |
| Insert screenshot(s) of Dashboard results below: | |
FINAL QA SIGN OFF BEFORE MODELLING
| QA reviewer | QA Reviewer’s name |
| Today’s date | <date> |
Final modelling Signoff
| Task | Value |
| Final Modelling results produced by | <Modellers Name> |
| Date | <date> |
| Insert screenshot(s) or links to Modelled results below: | |
