Unified policy systems and financial reporting across 5+ entities
Reduction in monthlhy procedural hours
Global pet care and insurance organization based in the US with over 4,000 employees and 6 million insured clients across 10 markets. This organization has a vast brand portfolio with varying maturity levels across its data systems, leading to its engagement with Keyrus.
The client runs weekly, monthly, and budget reporting in FP&A software to track KPIs (PIF, NBW, Expenses), relying on Excel models, data extracts and manual calculations. Keyrus was engaged to build data foundations that automate the procedures, unify company financials with policy systems and set the automation standard for all brands across the company.
Keyrus met with stakeholders and SME's to understand the processes and data available, along with key technical staff to approve the proposed architecture for the pilot brand. Once approved, Keyrus began the assessment and modelization of the manual extracts and procedures, as well as developing accommodations for soon-to-be deprecated data sources for future-proofing. Once built, Keyrus and the Finance team worked collaboratively to test and refine the solution. Effort concluded with multiple handoff sessions and side-by-side walkthroughs to empower the Finance team once the solution was approved for production use.
'Keyrus has poised our client to reduce their workload by roughly 170 hours per year from this single automation, and set architectural standards for all future brands to be onboarded into this same automation. There is no longer any question of human error within the tedious volume of Excel formula calculations. This solution's output was also built to be platform-agnostic; the solution can be re-accommodated to any connecting modern FP&A solution.
Microsoft is a leading cloud provider and renowned publisher of office software and business intelligence solutions.
25+
years of partnership
3x
certified expertise: development, data, cloud
200+
clients