Validata SAS | ALM for Banking and Finance

Validata Connectivity (V-Conn)

V-Conn is a Business Intelligence and Data Integration platform containing five data processing products , Data Profiler, Data Validation, Enterprise Meta management, business objects library, Graphical Mapping environment, Reconciliation and Audit.

An Integrated user interface parallel processing tool for EVTL, Data Management and Data Quality Framework.

Whatever the specific nature of any data migration, the ultimate aim is to improve corporate performance and deliver competitive advantage. The migration of existing data from disparate systems is often complex and invariably there are significant time pressures in doing this. No organization can be offline for days, so finding a fast, effective and resilient method of doing this is extremely important for the business as well as the project.

V-Conn makes reconciliation simple by providing a portfolio of pre-defined reconciliation reports for every migration step i.e. Extraction, Transformation and Loading. Additionally, it is bundled with a number of financial reconciliation reports. In case where additional reports are necessary, the tool comes with a reconciliation engine and reconciliation report writer that enables business and IT to define new reports as necessary, simply, without coding and thus dramatically reducing time and money comparing to traditional solutions such as custom made reconciliation programs and manual reconciliation.

	Advantages and Benefits: Overall the benefits to the client include:
		Enabling the business to have full control of the migration process at all times, reducing risk on go-live
		Full auditability and clear visibility of the errors and exceptions as they occur within the migration process enabling the organization to focus on issue resolution immediately
		Structured data resulting in a faster data migration with higher data quality
		Consistent and standardized processes for end-to-end automated migration reducing costs and time, improving Business-IT collaboration and incorporating proven best practices.
		Re-usable, pre-built mapping rules and reconciliation reports for T24

	Product capabilities:
		Support legacy migrations and upgrades for all T24 versions (from G12 and on)
		Perform full Extraction, Transformation, Loading, Validation and Reconciliation of financial and static data for your Temenos T24™ implementation or upgrade
		Support Synchronization with external sources
		Import financial and static data from flat files
		Masking and Scrambling of sensitive data
		Support Data Profiling, Governance and Archiving
		Provide Audit and Process Control to ensure that compliance standards and regulations are met
		Provide pre-built templates with mapping rules
		Provide accurate Consolidation and Reconciliation reports
		Schedule migration jobs for a single or a repetitive execution at specified date and time.
		Seamlessly recreate your entire banking business model, enabling you to integrate and migrate data from multiple sources (applications, databases and file types) , maintaining all the data relationships and links
		Utilize business skills and not technical skills to perform data migration through its intuitive user interfaces.

Data Migration Approaches
Having an appropriate methodology in place is a critical factor for every project’s success. In terms of selecting an appropriate methodology for use with data migration, it should be integrated with the overall methodology for implementing the target business application. As such, migration is a component of the broader project, and planning for data migration activities should occur as early as possible in the implementation lifecycle.

V-Conn adopts the following migration approaches depending on the business goals, measured risks, migration volumes and technical infrastructure:

Big Bang Migration
Following this approach, migration and reconciliation of all bank branches and modules happens in one weekend. V-Conn is used both for migration processing and for building the technical and financial reconciliation reports. It can also be used as a platform for building an archiving solution for the legacy system historical data taking advantage of the relational information between legacy and TEMENOS T24™ objects established during data transformation. The time needed for the migration of the full volumes is a challenge when following the Big Bang approach, usually because of poor hardware performance.

Because of its flexibility V-Conn offers a variety of approaches to mitigate performance risks. For example, it can be used to migrate static data in advance, and the delta and financial data during the migration weekend.

Phased Migration
There are different factors that can make the Big Bang approach problematic – there could be issues with training of the employees, data volumes can be too large to be migrated in one weekend, or the long time needed for the full implementation of the system. In such cases, V-Conn supports a ‘progressive’ (phased) migration approach, where migration of data happens in several runs over several weekends without interrupting the bank’s workday operations. Using V-Conn as a staging area allows the migration of the next portion of data, and migrating only the delta for the data already existing, i.e. only additions or amendments accumulated since the last migration.

Phased migration consists of two different approaches:

1. Branch-based migration – migration is done branch-by-branch; all modules for a single branch are migrated over one weekend.
2. Module-based migration – migration per product is done for all branches in a single weekend. In this case, V-Conn’s staging area plays an important role for the delta migration of the modules migrated during the previous weekend(s).