Data Mining: Best practices to re-use data

Abstract: Test data play an important role for any automation suite especially in large automation assignments. Reuse of existing data is most challenging part of the test data management activities. In case of parallel execution of automation scripts there are chances of dead locks and conflicts. To avoid these dead locks and conflicts data mining approach can be used which utilizes the master and client tables’ mechanism. In this approach automated test script executes stored procedure (SP) for data mining and that data would be used for test suite execution.

Audience take-away:

    • Any number of machines can access this Stored Procedure
    • All requests will be placed in Queue and served data sequentially.
    • Limited effort required to implement this solution.
Download Pdf

Speaker's Profile


Subramanyam Tata,
Manager - Quality Assurance,

Subramanyam Tata is a Manager (Quality Assurance) having 12 years’ experience and working for Sapient.  He has extensive experience in the Banking, Financial, Trading and Energy Services domains and has been involved in end-to-end quality assurance life cycle including manual and automation testing.  He has good working experience of HP Suite (Quick Test, Quality Center), Microsoft Suite (Coded UI, Load Test), Oracle Suite (OpenScript, Oracle Load Test).  He has experience in various software test methodologies, automation test architecture/design on client-server and web based applications, specialized in automation testing framework design and Recovery System using various Technologies.


Abhilasha Vyas ,
Sr. QA Manager,

Abhilasha Vyasworks with Sapient, playing the role of Sapient Global Markets QA Capability Lead and has 10+ years of experience. She has a dedicated exposure to Banking/ Finance domain of 5+ years. She has rich experience of designing functional and automation test strategies for complex Banking/Finance applications and has designed a gamut of automation solutions around functional automation, data comparators etc. both for custom implementations and Pre built packages. Additionally, as a part of her profile; she collaborates with multiple teams to create standards/ best practices in manual & automation QA areas, provides SME support for critical cases/challenging project situations, manages and conducts QA training programs (for manual and automation testers).