Project Balance has developed several data warehouses for finance departments and reinsurance companies. These data warehouses extract and transform data from multiple sources into well-organized warehouse structures. Project Balance advocates including a data management component as part of a data warehouse system, that applies business rules to data moved into a data warehouse. Data that does not pass business rules are identified as suspicious or rejection exceptions and are flagged in the data management application for business users to resolve. We have experience developing detailed reports and dashboards with this financial data that are refreshed from source systems on an automated basis.
Insurance/Reinsurance
Project Balance has worked in the insurance and reinsurance sector since 2014 and our team has deep expertise from prior roles supporting actuaries with data-driven tools used for decision-making. We have supported data processing, end-of-month financial process as well as database performance optimization for insurance companies. On the reinsurance side, we have very specialized knowledge about property and casualty facultative and treaty reinsurance products and have developed data warehouses for these departments driving business reporting for underwriters, claims specialists, operations, and executive management.
Finance
Project Balance provides data warehouse and visualization services to finance departments helping them to move from Excel workbooks to online data displays with daily or hourly data refresh. We lead our clients through a requirements process that identifies all of the source data, documents definitions and data types as well as refresh frequency and other attributes. We then design a data warehouse that systematically pulls data from source systems to the data warehouse. Generally, the data is moved using SSIS (Microsoft) or Talend (Open Source) Extract, Transform, Load (ETL) scripts into a staging set of tables where the system inspects the data for quality parameters and tags data that does not meet specification. The data is then moved to a production warehouse where it’s displayed in ease-to-understand tables and graphs. Visualizations that may take a finance department days to generate are displayed on-demand, helping to improve program management, planning, and overall spending.
Arch Reinsurance Case Study
Project Balance conducted a requirements gathering workshop to understand and document Arch’s business needs, source data, data flow, business rules and display output for automating the identified critical reports…
