1 / 26

Validata Connectivity (V-Conn)

Validata Connectivity (V-Conn). Achieve full control of the migration process, reducing risk on go-live. Agenda. 1. Challenges with T24 Migration. Validata Approach. 2. 3. Validata Methodology. V-Conn Overview. 4. 5. ABN AMRO Bank Migration Project. 6. Benefits.

penn
Download Presentation

Validata Connectivity (V-Conn)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Validata Connectivity (V-Conn) Achieve full control of the migration process, reducing risk on go-live

  2. Agenda 1 Challenges with T24 Migration Validata Approach 2 3 Validata Methodology V-Conn Overview 4 5 ABN AMRO Bank Migration Project 6 Benefits

  3. Challenges with T24 Migration Financial loss in the accounting book due to inaccurate data mapping and extract specification Implementation is extremely complex and businesscritical Data migration is not agile based and doesn't support Business-IT collaboration Maintenance of delta logs (data) while conducting multiple mocks Mapping multiple core banking legacy systems into a single platform system Unscheduled downtime to Legacy Services and semi- automated procedures Engagement from Legacy & T24, Business & IT subject matter experts (SMEs), impact time & cost to engage related resources Challenges data profiling, data quality & data governance impacting go-live timelines Migration is usually seen as one-off activity leading to a scripted approach with limited reusability, high risks, longer implementation plans No formal migration methodology or methodology integrated with the implementation & delivery methodology of T24

  4. V-Conn will migrate all records (bulk import) from the legacy to the T24 tables or to the DWH • Validata DB will be used as staging area for the static data • When doing the import, V-Conn can do the cleansing and validation of the imported data • Validata will generate a reconciliation report after the migration Big Bang Approach Phased Approach • Special adapters will be used to extract the new and modified records and mitigate them to DWH on a daily basis • This incremental migration will happen automatically through scheduled jobs • Following to the migration, a reconciliation of the migrated data in all ETL processes can be achieved Validata Approach

  5. Sample ETL Steps methodology Stage 1Extracted data and Validation Log Validata Adapter Validata Engine Source 1 Extraction Task Stage 2Transformation Data and Transformation Log TransformationEngine Transformation Task ReportingAdapter Load in T24 Task Validata Adapter Stage 3Transformation Data and Transformation Log Load Data Automatic validation of data mapping pre-requisite worksheet Data mapping templates and tables Data migration risks and mitigation plan Data migration risks and mitigation plan Data migration risks and mitigation plan Target System

  6. V-Conn Features Creates and replicates tables from the legacy systems, storing the data information accordingly and providing reporting on top of them. Data import and consolidation from heterogeneous data sources and from many different applications and platforms The migration jobs can be scheduled for single or a repetitive execution at specified date and time. Field and Data Validation for completeness, proper context, rules validation and attributes value validation Key item for archiving is to identify and understand all relationships in data Online & offline data extraction and loading from multiple applications within the same framework Scheduling & Job Sequencing Validation Data Archiving Consolidation Reporting Reconciliation Reporting Synchronization Service Data Transformation Data Extraction & Loading Data Profiling Process Control & Audit T24 Reporting Testing Prebuilt Migration Mappings forT24 Validata Mapping Schemas define the mapping and transformation rules. Generation of automated reconciliation reports CRF reporting testing and Balance sheet revaluation testing Real time synchronization of data between two systems Pre built business mapping knowledge for T24 Full audit trail and control over the migration process

  7. Validata ETL Migration Process Control and Audit Mechanism Validation and Data Cleansing Engine Report , Warnings, Rejections Report , Warnings, Rejections Validata Adapter Validata Adapter Reconciliation Engine Reconciliation Engine Mapping Schemas Mapping Schemas Mapping Schemas Mapping Schemas Validata Staging Area & Data Warehouse Business Model Legacy T24

  8. V-Conn Prebuilt Adapters A cornerstone of V-Conn architecture is its system integration and interoperability features. V-Conn design is based upon the concept of a generic core that can communicate freely and flexibly with other systems using components called adapters. Transaction Monitor Adapter 80% reduction in current time to test T24 Adapter 50% faster time to market 80% reduction in current spend on testing 30% increase in productivity Data Base Adapters Generic Adapters (CSV, xml, flat files) T24 Java API Adapter

  9. Validata Migration Project Steps • Activities • Review BRDs, FSDs & T24 Build • Design Workshop • Identify T24 Gaps • Detailed Mapping Tracker • ETL Design • Migration Versions Design • Reconciliation Design • Deliverables • Detailed Migration Requirements Document & Data Migration Sheets (DMSs) • Detailed Reconciliation Requirements Document • Migration Versions Requirements Document • Tracker with T24 Gaps • Testing Strategy • Updated Project Plan (optional, if necessary) • Activities • Review TAABS • Identify T24 modules • Scoping Workshop • Volume Analysis • Migration Approach • Reconciliation Approach • ETL activities agreed • Issues & challenges identified. • Tracker with open issues to be addressed prior to design workshops • Deliverables • Project Plan • Migration Strategy • Reconciliation Strategy • Tracker with open issues & challenges • Activities • Development • Migration testing • Functional Testing scoping and test cases preparation. • Deliverables • Updated DMSs • ETL scripts • Reconciliation scripts • Migration Versions • Unit test cases and Test Logs • Test cases for Functional Testing. • Activities • Functional Testing. • UAT. • Dress Rehearsals • Recovery Plan preparation • Go Live Plan preparation • Deliverables • Functional Test Logs • UAT Logs • Dress Rehearsals Summary Reports • Defect Logs • Recovery & Go Live Plans • Activities • Perform Data Migration • ETL Support • Auto Reconciliation • Business Reconciliation Support. • Deliverables • Auto reconciled T24 system

  10. Data Extraction Engine

  11. Data Validation Engine

  12. Data Transformation and Load Engine

  13. Reconciliation Engine

  14. Reconciliation Reports

  15. View details for task Extract and Validate Customers

  16. View details clicked for task Transform Customers Case 1 – details when there is no error

  17. Process Control Engine

  18. V-Conn IT Audit Support Key Issues • Data misfeeds • Lack of data / transaction integrity • Loss of critical data • Unencrypted sensitive information • Data variances between sources and target system • Invalid, incompleteness and inadequate interfaces and their related controls • Lack of Business / IT alignment • Non compliance to regulatory requirements

  19. V-Conn IT Audit Support Methodology • Identification of the upgrades and changes through the change management capability • Alignment of the business requirements and system design documentation to achieve effective and timely upgrade • Risk assessment and mitigation planning • Check the availability and appropriateness of business and technical operating procedures and standards • Disaster recovery and business continuity arrangements • Logical access controls • Configuration Management • Interfaces adapters • Compliance with technical security standards for T24 platform and database • Adequacy and effectiveness of the testing strategy and environment • Service level agreements • Monitoring • Legal and regulatory aspects Benefits • Proper use of IT applications and supporting systems • Increased business process efficiency and controls alignment • Check the effectiveness of business and IT risks • Check on inappropriate access granted to sensitive transactions, data and configurations • Verification of incorrect data mapping results in inaccurate processing of data or misclassification of data /accounts • Reduction of the number of manual controls and enhance reliance on automated controls Key Differentiators • Data Validation and Integrity • Transaction Integrity • Data Flow Validation • Interface Controls • Data Conversation Review

  20. Benefits Save up to 60% of the time for all migration stages Time reduction of the migration setup and preparation by 70% Up to 5 times faster creation of mappings 50% faster time to Market Avoid costs for additional archiving storage and software 30% increase in productivity 90% reduction of time and cost for establishing the connectivity to the legacy system 20% increase in project success Save up to 50% time for the reports preparation

  21. Automatic Vs Semi-Automatic Migration Roll Out -50% Roll Out C O S T $$$ Reconciliation -60% Reconciliation Test Test -75% COS T $$ Analysis -65% Analysis Development -70% Development Engagement -65% Engagement Semi- Automatic Migration Automatic Migration

  22. Validata Staging Area Data source –Static data • Transformed data • Load data • Reconcile data • Extracted data Target System Validata adapters Validata adapters Data source – Transaction data

  23. Reconciliation Diagram Reconciliation Framework Validata Staging Area Data source –Static data Reconciliation for this stage is populating report based on comparison between extracted Legacy data. Also all mismatches as per business validation rules. Stage1 – Extraction Reconciliation • Transformed data • Load data • Reconcile data • Extracted data Stage2-Transformation Reconciliation Reconciliation for this stage is populating report based on extracted transformed data. The process is using the defined business transformation rules. Stage3 – Load Reconciliation Reconciliation for this stage is populating report based on data that should be loaded against data actually loaded in T24. Target System Stage4 - Reconcile Reconciliation for this stage is populating report based extracted data from T24 against data that should have been loaded. Validata adapters Validata adapters Direct Migration • Extract • Transform • Load Data source – Transaction data

  24. Reconciliation Diagram Reconciliation Framework static Data Reconciliation for this stage will be based Data cleansing rules on Sector(Integer and in between specific range), Address( Specific Length). • Failover policy , the process can be done unattended. • Validation Rules easy to be maintained. • Extraction requires approximately 3 minutes. • Generation of the report plus excel export takes 10 minutes Stage1 – Extraction Reconciliation 500.000 Customers • Failover policy , the process can be done unattended. • Transformation business rules easy to be defined and maintained. • Transformation requires approximately 2 minutes • Generation of the report plus excel export takes 10 minutes Stage2-Transformation Reconciliation 500.000 Customer Reconciliation for this stage is populating report based on >100 business transformation rules . • Failover policy , the process can be done unattended. • The expect number of loaded data is a result of previous stage outcome. • Loading requires approximately 12 minutes • Generation of the report plus excel export takes 10 minutes Stage3 – Load Reconciliation 500.000 Customer Reconciliation for this stage is populating report based on Transformed data to be loaded in Target System against actual volume of data loaded. • Failover policy , the process can be done unattended. • Comparison ruler(field level) are easy to be created and maintained. • Extraction of the Data takes approximately 8 minutes. • Generation of the report plus excel export takes 10 minutes • Overall time is 18 minutes fully automated process. Stage4 - Reconcile 500.000 Customer Reconciliation for this stage is populating report based on Extraction of all Customer in T24 against the Customers that should have been loaded.

  25. Reconciliation Diagram Reconciliation Framework Dynamic Data Reconciliation for this stage will be based Data cleansing rules on AMMOUNT( to be above 0),ACCOUNT ( belongs in the list of migrated acc) • Failover policy , the process can be done unattended. • Validation Rules easy to be maintained. • Extraction requires approximately 3 minutes. • Generation of the report plus excel export takes 10 minutes Stage1 – Extraction Reconciliation 750.000 FUNDS.TRANSFER • Failover policy , the process can be done unattended. • Transformation business rules easy to be defined and maintained. • Transformation requires approximately 2 minutes • Generation of the report plus excel export takes 10 minutes Stage2-Transformation Reconciliation 750.000 FUNDS TRANSFER Reconciliation for this stage is populating report based on >30 business transformation rules . • Failover policy , the process can be done unattended. • The expect number of loaded data is a result of previous stage outcome. • Loading requires approximately 15 minutes • Generation of the report plus excel export takes 10 minutes Stage3 – Load Reconciliation 750.000 FUNDS.TRANSFER Reconciliation for this stage is populating report based on Transformed data to be loaded in Target System against actual volume of data loaded. • Failover policy , the process can be done unattended. • Comparison ruler(field level) are easy to be created and maintained. • Extraction of the Data takes approximately 15 minutes. • Generation of the report plus excel export takes 10 minutes • Overall time is 25 minutes fully automated process. Reconciliation for this stage is populating report based on Extraction of all Funds transfer in T24 against the Funds transfer that should have been loaded. Stage4 - Reconcile 750.000 FUNDS.TRANSFER

  26. ROI based on Reusability for Migration Projects Roll Out -60% Roll Out Reconciliation -80% Reconciliation Test -85% Test Analysis -80% Development -75% Analysis Development Engagement -85% Engagement Migration Phase 1 Migration Phase 2 *Scenario where the same legacy system across locations is used

More Related