Global Payment Processing Provider
Cutting report time in half with data warehouse optimisation and automation
the challenge
A global payment processing provider engaged Dufrain to review and optimise its on-premise data warehouse in preparation for a future cloud migration.
The existing warehouse had grown organically without supporting documentation, leading to knowledge gaps, inefficiencies, and long reporting delays — with some reports taking over 20 hours to run.
The client also wanted to modernise their manual, resource-heavy reporting process and introduce a new automated reporting suite that could speed up delivery and enable their team to focus on business insight.
data services
Data Engineering, BI & Analytics
the solution
Dufrain launched two parallel workstreams:
1. Optimise the current warehouse and complete an in-progress data cube
2. Redesign and automate the reporting suite using Power BI
Key activities included:
- Conducting a top-down review of warehouse risks
- Mapping current architecture and creating full documentation
- Reviewing and optimising inefficient stored procedures
- Streamlining SSIS packages and decommissioning outdated scheduling steps
- Redeveloping reports in Power BI and automating where possible
- Running training workshops and supporting the internal team
- Providing weekly project updates to ensure full stakeholder visibility
the outcome
Stored Procedure Optimisation
• Significant time savings — some processes cut by 7 hours
• Reporting time halved overall
Improved Reporting
• Reports were redesigned into user-friendly Power BI dashboards
• Automation drastically reduced manual effort
• Business insights delivered faster and more consistently
SSIS Package Simplification
• Decommissioned a complex scheduler and improved process flow
• Introduced guides for easier issue resolution and future development
Risk DB Mapping
• Current-state risk environment fully documented and ready for Snowflake replication
Documentation & Training
• End-to-end documentation provided
• Client team upskilled on new tools and reporting processes
Efficiency Gains
• Team resources reallocated to higher-value tasks
• The data warehouse runs more smoothly and efficiently
• Shifted the team focus from admin to analytics
All set to make your data AI-ready?
In one conversation, we’ll explore your challenges, share ideas, and leave you with clear next steps – questions to spark internal discussions and practical ways to progress your data and AI journey with confidence.
Let’s talk
Victoria Whittaker
Head of Business Development