DamstraThe customer this was delivered for.Saved $180K Annually by Eliminating Power BI and Refactoring Systems
Key results
- $180K annual cost reduction via Power BI elimination
- 3,500 to 450 stored procedure lines via refactoring
- 300+ databases converted via automation-centric ETL
Damstra faced data duplication caused by a PHP application with unsolicited permissions. Power BI usage created excessive costs of over $180K USD per month. Customers reported negative experiences across web and mobile applications. Over 300 customers relied on manual recording tools to ingest data for reporting, and the legacy Yellow Fin reporting product had limited features. The team refactored the system so the PHP application operated in a view-only state to minimize race conditions. They migrated reporting away from Power BI and Yellow Fin to Logi-composer and Snowflake, including converting Yellow Fin’s MS SQL implementation to the Snowflake DSL. A centralized Web API was built to consolidate business logic, expose public APIs for third-party integrations, and deliver new functionality. Mobile applications were rebuilt in Kotlin and Swift, and a scalable three-tier ETL process automated database conversions. The migration reduced annual server costs by $180K in annual license fees. Stored procedure logic was reduced from 3,500 lines to 450, improving maintainability and performance. ETL automation efficiently converted data across over 300 databases, reducing manual ingestion burden. The work supported improved customer experience across the platform and enabled positive changes identified pre-deployment during penetration testing.
Double Yolk