• Data inconsistencies across LOBs

• Manual Excel operations causing errors and delays

• Fragmented system integration across legacy platforms

• Inaccurate premium/claims computations due to manual logic

• Limited data governance and lineage

• Slow reporting turnaround time impacting business functions

Exponentia.ai implemented a scalable and flexible data platform on Databricks featuring:

• ETL pipelines ingesting historical + incremental loads from AWS S3

• Medallion architecture with Bronze, Silver & Gold layers

• Delta Lake storage optimization for performance

• Unity Catalog for permissioning, lineage and schema evolution

• Lakeview dashboards tailored to each business function

Key Highlights

• 6 interactive dashboards: Revenue, Claims, Medical, Bordeaux, One View, Receivable & Payable

• Automated premium, claims & loss ratio calculations

• Real-time governed data accessible across departments

• Partitioning and caching improved query performance significantly

‍

• Centralized repository replacing 1000+ Excel files

• Reporting cycles reduced from days → minutes

• Improved audit readiness and data reliability

• Scalable architecture ready for AI, streaming & API integrations

• Enhanced collaboration and operational efficiency