Cost Allocation Rules Engine Modernization

Customer Challenge

A local insurance company required a modernized data environment to automate their month-end and year-end close processes.

Innovative Solution

Illumination Works is utilizing an artificial intelligence method called well-formed formula to create metadata structures and build a cost allocation rules engine. This solution provides insurance business analysts and developers with a consistent and straightforward way to manage complex business rules and improve reporting. For this effort, our team is creating a transaction data landing, prioritizing conflict resolution rules, and developing a rules results-based audit process.

Benefits/Outcomes

  • Increased flexibility to adjust cost allocation methods
  • Rapid identification on imbalance causes
    and remedy
  • Easy to maintain month-end and year-end close processes (add new, modify, or remove rules) 
  • Unifies rules and processes to a single location
  • Allows for advanced ‘what if’ distribution rules scenarios
  • Replacing 400+ ETL jobs

Toolbox

  • Rules engine best practices
  • Data process automation
  • Agile methodology
  • Limited scope/strict master data management (MDM)

Related Case Studies You May Like

Edge Data Management & Analytics (Navy)

Edge Data Management & Analytics (Navy)

Expert Talk: Data Mesh – The Journey of Publishing Data by Domain

Expert Talk: Data Mesh – The Journey of Publishing Data by Domain

Data Science & Architecture Assessment (Marketing)

Data Science & Architecture Assessment (Marketing)

Automating Data Rights Understanding (Air Force)

Automating Data Rights Understanding (Air Force)

Text Analytics of PDF Technical Documents (Air Force)

Text Analytics of PDF Technical Documents (Air Force)

Deep Learning on Raw Google Analytics Data (Retail)

Deep Learning on Raw Google Analytics Data (Retail)

Automated Data Cleansing with Machine Learning (Navy)

Automated Data Cleansing with Machine Learning (Navy)

Automated Data Capture and Prediction (Air Force, SBIR)

Automated Data Capture and Prediction (Air Force, SBIR)

Contract Conversion & Analytics (Air Force)

Contract Conversion & Analytics (Air Force)

Database Tuning & Optimization (Retail)

Database Tuning & Optimization (Retail)

Decision Support for Cyber Hygiene (Air Force)

Decision Support for Cyber Hygiene (Air Force)

Azure Data Integration Hub Modernization

Azure Data Integration Hub Modernization

Data Warehousing & Business Intelligence

Data Warehousing & Business Intelligence

Big Data Engineering for Improved Analytics (Retail)

Big Data Engineering for Improved Analytics (Retail)

Cost Allocation Rules Engine Modernization (Insurance)

Cost Allocation Rules Engine Modernization (Insurance)

Predictive Analytics for the Aircraft Digital Thread (Air Force)

Predictive Analytics for the Aircraft Digital Thread (Air Force)

On-Demand Maintenance Analytics for Logistics (Air Force)

On-Demand Maintenance Analytics for Logistics (Air Force)

User-Centric Predictive Insights with Machine Learning (Air Force)

User-Centric Predictive Insights with Machine Learning (Air Force)

Machine Learning & NLP for Decision Support (Healthcare)

Machine Learning & NLP for Decision Support (Healthcare)

Sensor Data Analysis for Predictive CBM+ (Retail)

Sensor Data Analysis for Predictive CBM+ (Retail)

Data Cleansing and Migration (Energy)

Data Cleansing and Migration (Energy)

Application Modernization (Healthcare)

Application Modernization (Healthcare)

Large-Scale Data Integration (Air Force)

Large-Scale Data Integration (Air Force)

Data Science Big Data Ingestion (Energy)

Data Science Big Data Ingestion (Energy)

Transformation to Modern Analytics Framework (Energy)

Transformation to Modern Analytics Framework (Energy)

Agile Big Data Analytics Framework (Retail)

Agile Big Data Analytics Framework (Retail)

Big Data Hadoop Administration (Retail)

Big Data Hadoop Administration (Retail)

Modern Data Ingestion Framework (Insurance)

Modern Data Ingestion Framework (Insurance)

Performance Tuning & Best Practices (Retail)

Performance Tuning & Best Practices (Retail)

Engines Forecast Reporting Tool (Air Force)

Engines Forecast Reporting Tool (Air Force)

Data Quality & Lineage Mapping (Retail)

Interested In Working With Us?