top of page

Managing Analytics Organization for the Best in Deliverables for the Organization in Revenue and Profitability

Guidance on Some of the Business Intelligence Reporting Needed for the Best in Decision Supports Deliverables to Drive Efficiency, Revenue and Profitability (Static, Enterprise, Online and Real-time)

Business Intelligence Reporting Solutions Team has the responsibilities that include the design, development and deployment of Business Intelligence reporting applications, solutions and tools

 

The Team also provides business guidance in the use of the reporting solutions and reporting templates.

Other responsibilities include:

  • Ensuring the effective deployment of the reporting solutions

  • Administering and maintaining the reporting governance policies and procedures

  • Monitoring methodologies, standards, and practices to ensure continued efficient reporting results

  • Assist training resources in the development of appropriate training materials associated with the standards, methodologies, and practices for the reporting solutions and governance processes

  • Providing support to vertical Business Analytics in the use of the reporting templates

  • Business Activity Key Performance Indicators Reports (As of the Quarter Reported and Trend)

    • Finance Key Performance Indicators Reports

    • Marketing Key Performance Indicators Reports

    • Customer Key Performance Indicators Reports

    • Human resources Key Performance Indicators Reports

    • Sales Key Performance Indicators Reports

  • Performance Reports

    • Financial Performance Report

    • Earnings Performance Report

    • Business Unit Performance Report

    • Investment performance

    • Operational Performance Report

    • Process Performance Report

    • Technical/Technological Performance Report

    • Market Performance Report

    • Existing Product Performance Report

    • New Product Performance Report

    • Existing Business Performance Report

    • New Business Performance Report

    • Securities by book value

    • Exposure trend report

  • Exposure Risk Reports (As of the Quarter Reported and Trend)

    • Finance Key Risk Indicators Reports

    • Marketing Key Risk Indicators Reports

    • Customer Key Risk Indicators Reports

    • Human resources Key Risk Indicators Reports

    • Sales Key Risk Indicators Reports

  • Diversification Reports (As of the Quarter Reported and Trend)

    • Risk Diversification Report

    • Product Diversification Report

  • Own the deliverables of reporting solutions that include but not limited to: 

  • Pricing Reports

    • Renewal Rate change

    • Renewal Net Price Change (Rate and Exposure changes)

    • Rate Adequacy

    • New and Renewal Rate

    • Mod factor-the ratio of the ILF applied to the benchmark ILF

    • New business rate from previous year compared to current new business rate

    • Time series of average rate on in-force books

    • Percent of the Business Modeled

    • Competitor pricing

    • Medical inflation

  • Claims Reports

    • Claims Payment Pattern

    • Actual versus target:

    • Claim frequencies (number of claims per unit of exposure)

    • Severity Average Claim Sizes (Severities)

    • The Average Size of Open Claims

  • Reserving Reports

    • Calendar Year versus Accident Year

    • Paid Development Patterns

    • Reserve Development

    • Loss Reserves

      • Case Reserves

      • Incurred But Not Recorded (IBNR) Reserves

    • Loss Adjustment Expense (LAE) Reserves

    • Salvage and Subrogation

    • Projections of Ultimate Losses

  • Report on Action Plans

    • Number of resolved items that were successfully mitigated, avoided, or had their impact reduced to lower priority

    • Number of contingency plans that had to be invoked

    • Possible Risks Items that are to be moved to Action Plan List

    • New risk items since the last report

    • Risks that are becoming problems

  • Performance Attribution Reports

    • Arithmetic

    • Geometric

    • Fixed income

    • Equity

  • Risk Profile Reports (include Strategic, Market, Credit, Operational, Portfolio, Compliance, and Marketing Risks)

    • Quantity of the Risk

    • Quality of the Risk

    • Aggregate Risk

    • Direction of the Risk

    • Top 10 risk items that pose risk to plan

    • List of Customers that poses risks to company

    • Critical risk processes

    • Compliance requirements that include SOX, Money Laundering among others

  • Pricing Reports

    • Renewal Rate change

    • Renewal Net Price Change (Rate and Exposure changes)

    • Rate Adequacy

    • New and Renewal Rate

    • Mod factor-the ratio of the ILF applied to the benchmark ILF

    • New business rate from previous year compared to current new business rate

    • Time series of average rate on in-force books

    • Percent of the Business Modeled

    • Competitor pricing

    • Medical inflation

  • Claims Reports

    • Claims Payment Pattern

    • Actual versus target:

    • Claim frequencies (number of claims per unit of exposure)

    • Severity Average Claim Sizes (Severities)

    • The Average Size of Open Claims

  • Reserving Reports

    • Calendar Year versus Accident Year

    • Paid Development Patterns

    • Reserve Development

    • Loss Reserves

      • Case Reserves

      • Incurred But Not Recorded (IBNR) Reserves

    • Loss Adjustment Expense (LAE) Reserves

    • Salvage and Subrogation

    • Projections of Ultimate Losses

  • Report on Action Plans

    • Number of resolved items that were successfully mitigated, avoided, or had their impact reduced to lower priority

    • Number of contingency plans that had to be invoked

    • Possible Risks Items that are to be moved to Action Plan List

    • New risk items since the last report

    • Risks that are becoming problems

  • Performance Attribution Reports

    • Arithmetic

    • Geometric

    • Fixed income

    • Equity

  • Risk Profile Reports (include Strategic, Market, Credit, Operational, Portfolio, Compliance, and Marketing Risks)

    • Quantity of the Risk

    • Quality of the Risk

    • Aggregate Risk

    • Direction of the Risk

    • Top 10 risk items that pose risk to plan

    • List of Customers that poses risks to company

    • Critical risk processes

    • Compliance requirements that include SOX, Money Laundering among others

  • ALM Reports

    • Market risk sensitivities

    • Interest rate sensitivity

    • Equity return sensitivity

    • Earnings at risk sensitivities

    • Pre-hedged versus post-hedged value

    • A/L Mismatch

  • Capital Management Reports

    • State of the company capital

      • Current changes in the capital position of the company

        • Actual versus expected

        • Capital injection

        • Drivers of the changes in the movement in the capital component

    • Adequacy of capital

    • Risk to capital

    • Letter of credits

    • Rating Agency capital requirements

    • Regulatory capital requirements

    • Capital at Risk sensitivities

  • Portfolio Management Reports

    • State of the Company Portfolios 

      • Current changes in the portfolios

      • Current and projected growth in the portfolios

    • Asset quality

    • Report on Portfolio Concentration

  • Credit Management reports

    • Loan watch lists

      • Structurally weak loans list

      • Overdraft list

      • Loan concentration

      • Past-due and nonaccrual

      • Rating reports

      • Loan trial balances

      • Large-dollar personal loans

      • Large-dollar commercial loans

      • Securitized loans

  • Trends Reports on

    • Exposure

    • Claims Indicators that include loss severity, claim frequency, etc.

    • Renewal Business

    • New Business

    • Mix of business: new and renewal

    • Risk Concentrations by customers or customer distribution

    • Risk Concentrations by geographical location

    • Product/ Portfolio Mix

    • Competition: market share

    • Customers' pricing pressure

    • Loss of key customers

    • Percent of high-yield customers

  • Underwriting Reports

    • Price achieved versus Target price

    • Exposure

    • Exposure mix

    • Quotes accepted/ declined

    • Premium Persistency

    • Loss Ratio and Ultimate Loss Ratio

    • Loss Adjustment Expenses

    • Acquisition Cost

    • Ultimate Technical Margin

    • Price achieved versus Target price

  • Liquidity Management Reports

    • State of the company liquidity

      • Liquidity adequacy

      • Current changes in the company's liquidity

      • Ability to borrow

      • Existing liquid assets and availability for the immediate future

      • Funding concentrations

      • Funding costs

    • Earnings quality and quantity

    • Cash inflows and outflows on periodic basis

    • Liquid asset holdings by value, categories and credit ratings

    • Liquid asset holdings by value, categories and credit ratings based on the scenario analysis

    • Letters of credit

    • Distribution of assets and liabilities in terms of sector, maturity and quality

  • Rating Agency Management

    • Previous Rating Agencies' concerns

    • Current Rating Agencies' concerns about the industry

  • Operations Reports

    • Human relations reports

      • Number and percentage leaving the company

      • Vacancy rates

      • Average salary increase versus plan

      • Employee Fraud

      • Loss of Key Individuals/Teams

    • Underwriting process performance reports

    • Billings and collection reports

    • Process improvement reports

    • Information Technology

      • Systems Failure

      • Disasters, outages & disruptions

      • Help desk metrics

      • Security metrics

      • Project metrics

      • IT incidents/investigations

      • IT audit issues

  • Audit Reports

    • Number of underwriting and financial audit conducted

    • Internal Audit Score for underwriting and financial audit

    • External Audit Score for underwriting and financial audit

    • Outstanding Audit items for underwriting and financial audit

  • Legal Surveillance Reports

    • Legislative and Common Law Changes report

    • Compliance readiness report

  • Summary Report on External Changes

    • Changes in Macro economy with consequences for the company

    • Changes in Global Economy with consequences for the company

    • Changes in Political environment with consequences for the company

    • Changes in Consumer behavior with consequences for the company

    • Changes in Compliance requirements with consequences for the company

bottom of page