Case Studies Accurate, Controlled Test Data for Credit Card Testing

Edit This Case Study Record

	Accurate, Controlled Test Data for Credit Card Testing

Accurate, Controlled Test Data for Credit Card Testing

Technology Category	Application Infrastructure & Middleware - Data Exchange & Integration Application Infrastructure & Middleware - Database Management & Storage Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation Quality Assurance
Services	Software Design & Engineering Services System Integration
Challenge	QA leadership for this organization wanted to eliminate a potential breach of sensitive customer information, such as social security and credit card account numbers, during their testing process. For this reason, they decided to evaluate the use of synthetic test data. They needed test data in a variety of formats for testing multiple systems and databases, including ASCII, EBCDIC, Parquet, JSON, and AVRO. The database environments include DB2, Oracle, SQL Server, Postgres, MySQL and Snowflake.\n\nPreviously, the QA team pulled data from production and manually scrubbed it to remove sensitive information and to create appropriate data combinations for testing. Now their goal is to automate the process of provisioning secure, synthetic test data with full control over data volume and variation with an ability to output the data in the multiple file formats described above. The QA team was introduced to GenRocket by one of the company’s system integration partners and decided to evaluate GenRocket’s Test Data Automation capabilities as part of a formal Proof of Concept (POC). Read More
About Customer	A major financial services company, managing billions of dollars in assets, provides a variety of services including consumer and commercial banking, credit cards, auto loans and savings accounts. Their credit card business alone represents millions of cardholders transacting billions of dollars in annual purchase volume.\n\nThe credit card market has become the largest U.S. consumer lending market and continues to expand by every measure of growth. Credit card providers are under intense competitive pressure to deliver new and innovative products in the form of loyalty and reward programs, balance transfers, cash advances and other perks. This places a big demand on developers and testers to manage a continuous pipeline of software enhancements and revisions. These applications interface with multiple systems as they execute a massive volume of credit transactions and manage user accounts. As part of a regulated industry, QA organizations are keenly focused on the accuracy and security of their information systems. The financial services company profiled in this case study provides an example of the rigorous testing and data provisioning requirements that must be followed when testing financial application software. Read More
Solution	The GenRocket Test Data Automation platform is a perfect match for these requirements. Its component architecture allows testers to define data structures, select the required data generators for each field, and match them with data receivers for the desired output format.\n\nThe GenRocket platform allows testers to import any data model using a database schema or Data Definition Language (DDL) to automate the process of provisioning synthetic test data. This ensures test data is generated with the correct data structure and parent/child/sibling relationships between data tables.\n\nGenRocket has more than 250 data generators including 7 different data generators just for credit cards. Generators have parameters that can be configured to accurately control the data values that are generated. They are part of a Test Data Scenario that controls the quantity of test data that is to be generated. To support a wide variety of output formats, GenRocket has more than 50 data receivers including two new receivers created for this POC – IBM EBCDIC and Parquet file formats. Any receiver can be paired with any combination of generators to provide flexibility over the data values used for testing and consistency of data used across multiple environments. GenRocket worked with the QA team at this financial services company to automate the process of importing the data model, configuring the data generators, controlling the record counts, and generating test data on-demand and in the desired output format. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Exchange & Integration

Application Infrastructure & Middleware - Database Management & Storage

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Quality Assurance

Services

Software Design & Engineering Services

System Integration

Challenge

QA leadership for this organization wanted to eliminate a potential breach of sensitive customer information, such as social security and credit card account numbers, during their testing process. For this reason, they decided to evaluate the use of synthetic test data. They needed test data in a variety of formats for testing multiple systems and databases, including ASCII, EBCDIC, Parquet, JSON, and AVRO. The database environments include DB2, Oracle, SQL Server, Postgres, MySQL and Snowflake.\n\nPreviously, the QA team pulled data from production and manually scrubbed it to remove sensitive information and to create appropriate data combinations for testing. Now their goal is to automate the process of provisioning secure, synthetic test data with full control over data volume and variation with an ability to output the data in the multiple file formats described above. The QA team was introduced to GenRocket by one of the company’s system integration partners and decided to evaluate GenRocket’s Test Data Automation capabilities as part of a formal Proof of Concept (POC).

About Customer

A major financial services company, managing billions of dollars in assets, provides a variety of services including consumer and commercial banking, credit cards, auto loans and savings accounts. Their credit card business alone represents millions of cardholders transacting billions of dollars in annual purchase volume.\n\nThe credit card market has become the largest U.S. consumer lending market and continues to expand by every measure of growth. Credit card providers are under intense competitive pressure to deliver new and innovative products in the form of loyalty and reward programs, balance transfers, cash advances and other perks. This places a big demand on developers and testers to manage a continuous pipeline of software enhancements and revisions. These applications interface with multiple systems as they execute a massive volume of credit transactions and manage user accounts. As part of a regulated industry, QA organizations are keenly focused on the accuracy and security of their information systems. The financial services company profiled in this case study provides an example of the rigorous testing and data provisioning requirements that must be followed when testing financial application software.

Solution

The GenRocket Test Data Automation platform is a perfect match for these requirements. Its component architecture allows testers to define data structures, select the required data generators for each field, and match them with data receivers for the desired output format.\n\nThe GenRocket platform allows testers to import any data model using a database schema or Data Definition Language (DDL) to automate the process of provisioning synthetic test data. This ensures test data is generated with the correct data structure and parent/child/sibling relationships between data tables.\n\nGenRocket has more than 250 data generators including 7 different data generators just for credit cards. Generators have parameters that can be configured to accurately control the data values that are generated. They are part of a Test Data Scenario that controls the quantity of test data that is to be generated. To support a wide variety of output formats, GenRocket has more than 50 data receivers including two new receivers created for this POC – IBM EBCDIC and Parquet file formats. Any receiver can be paired with any combination of generators to provide flexibility over the data values used for testing and consistency of data used across multiple environments. GenRocket worked with the QA team at this financial services company to automate the process of importing the data model, configuring the data generators, controlling the record counts, and generating test data on-demand and in the desired output format.

Impact #1	This level of control, flexibility, security and efficiency of test data provisioning was not possible prior to GenRocket.
Impact #2	The POC was highly successful, demonstrating the effectiveness of GenRocket’s Test Data Automation.
Impact #3	The implementation of GenRocket’s Test Data Automation promises to bring a new level of data quality and test coverage to any QA process.

Impact #1

This level of control, flexibility, security and efficiency of test data provisioning was not possible prior to GenRocket.

Impact #2

The POC was highly successful, demonstrating the effectiveness of GenRocket’s Test Data Automation.

Impact #3

The implementation of GenRocket’s Test Data Automation promises to bring a new level of data quality and test coverage to any QA process.

Download PDF Version

Overview

Accurate, Controlled Test Data for Credit Card Testing

Operational Impact