Engineering Data Testing Project for a City Commercial Bank
In the second half of 2019, a city commercial bank launched the construction of its next-generation information systems, comprising two major clusters: the Core Banking Program and the Credit Program. The project faced multiple challenges, including a shortage of technical testing personnel, heavy workloads for script development, compressed project timelines, and certain systems lacking data persistence, which hindered data comparison and validation.
GienTech introduced its Data Testing Platform, combining manual and automated methods to verify data compliance, completeness, and accuracy. By categorizing and defining SQL templates, the platform enabled:
· Automated SQL script generation
· Automated test case generation
· Automated test case execution
These capabilities alleviated resource constraints, reduced manual workloads, and addressed tight delivery schedules. In addition, through client-specific customization, the platform ensured data persistence for the customer rating system’s credit reporting interface, facilitating data analysis and comparison.
· Successfully completed most SIT testing tasks for the bank’s data-related systems, reducing project manpower costs by 30% while improving both requirement analysis and execution efficiency.
· Ensured high-quality system go-live.
· Built a substantial library of reusable data validation scripts through the platform, which now serve as valuable process assets for regression testing during ongoing operations and maintenance.
