About the Customer
A leading global bank, ranked among the top 5 in the United States by market capitalization and among the top 10 banks worldwide. With a market cap of more than $250 billion as of 2024, the bank is recognized for its robust financial services portfolio and commitment to innovation, serving millions of customers globally.
The Challenge
The bank faced challenges while migrating legacy data warehouses to the cloud. Their data included Customer PII (Personally Identifiable Information), which was not well-documented, making it difficult to comply with regulations and security policies.
Data was required for various testing scenarios, from smoke testing to functional and load testing, to validate the migrated code and support modernized applications built on the cloud.
Developers couldn’t directly access production data due to access control restrictions,and the company was required to identify and tokenize PII data before it could be moved and used in the lower environments. The process of obtaining PII approvals and de-identifying data was slow and costly, and was taking six weeks to prepare approximately 40 tables. Scaling this to 7,000+ tables would require 100 full-time staff, which was not feasible.
The Solution
| 90% Efficiency in Scaling | 85% Time Savings | Zero Regulatory Bottlenecks | Workload of 100 FTEs Reduced |
|---|---|---|---|
| Delivered results for hundreds of tables in just minutes and hours, optimizing resources. | Saved time on de-identifying and preparing data. | Bypassed the need for PII approvals, enabling immediate turnaround times. | Immediate cost savings by reducing reliance on a large pool of analysts. |
Kingfisher provided a fast, efficient, and compliant solution to the bank’s challenges:
-
Rapid Synthetic Data Generation:
- Generated meaningful, production–like synthetic data without exposing sensitive PII, enabling the migration and testing processes to proceed without delays.
-
No PII Approvals Required:
- By eliminating the need to work with production data, the process bypassed the lengthy PII approval workflows, saving significant time and effort.
-
Support for Varied Testing Needs:
- Delivered synthetic data tailored for smoke testing, functional testing, and load testing, ensuring the quality of the migrated systems and modernized applications.
- Enabled fast and efficient testing of the migrated data warehouses, supporting the move to the cloud.
-
Efficient Scaling:
- Delivered results for thousands of tables in hours and minutes, avoiding the need to engage critical business analysts or tie up resources. (put efficiency of 90%).
-
Comprehensive Testing Support:
- Provided data suitable for all testing scenarios, ensuring the quality and reliability of the migrated systems.
Conclusion
By leveraging Kingfisher, the financial institution overcame regulatory, resource, and timeline challenges in their data migration initiative. The tool’s ability to generate compliant, production-like synthetic data enabled rapid testing and development while saving 85% of the time and avoiding costly resource investments.
