1 / 36

Sanchaya - CBS Data Migration

Sanchaya - CBS Data Migration. Source: Infosys Finacle Material. Table of Content. 1. Data Migration Overview 2. Data Migration Process 3. Manual Data Capture Process 4. Data Migration Command Centre 5. Data Flow from POs to DCF 6. ROLL OUT/GO LIVE 7. CBS RESPONSIBILITIES

shayna
Download Presentation

Sanchaya - CBS Data Migration

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. Sanchaya - CBS Data Migration Source: Infosys Finacle Material

  2. Table of Content 1. Data Migration Overview 2. Data Migration Process 3. Manual Data Capture Process 4. Data Migration Command Centre 5. Data Flow from POs to DCF 6. ROLL OUT/GO LIVE 7. CBS RESPONSIBILITIES 8. Templates & Manuals

  3. What is Data Migration? Objective and Purpose Data Migration is a Process is to ensure a smooth, accurate and timely migration of data from existing Sanchay Post and Manual offices to Finacle without impacting customer service and productivity of the customer. Since Sanchay Post and Finacle are inherently different, data migration processes will be executed streamlining the source data into the way the target system reads and classifies the data. As part of migration of data from Sanchay Post or manual offices to Finacle, Centralized, Decentralized, Certificates and Discontinued products will be converted to Finacle database. For entering manual records DET/Sanchay Post shall be used. It would also be enhanced to allow entry of new products. Before actual migration, Trial and Mock migrations will be done to identify data quality issues and help DoP to cleanse the inaccurate data to streamline the process Data will be migrated on as-is basis, based on the sign-off provided by the Post Master of respective office

  4. Data Extract Transform Upload Data Cleansing & Enrichment Data Mapping Test Migration Checking Migrated Data UAT SR LIVE Infosys’ Responsibility DataMigration-Overview DoP’s Responsibility • One-to-one field mapping • Default values for Finacle mandatory fields • Map critical fields from existing system to Finacle • Upload enhancements • Build Tools Library for data extraction, Transformation, Upload • Unit testing – Logic and assumptions • • • One-to-onefieldmapping DefaultvaluesforFinacle mandatoryfields Mapcriticalfieldsfrom existingsystemtoFinacle • • BuildToolsLibraryfordata extraction,Transformation, Upload Unittesting–Logicand assumptions • UAT on converted data • Carry out day-end, month-end operation • • UATonconverteddata Carryoutday-end, month-endoperation • Uploadenhancements Data Migration Approach Extract Transform Upload Migration Approach Data Mapping Test Migration Checking MigratedData UAT SR LIVE DataCleansing &Enrichment • Checking by DM Team / Business • Identify Gaps, if any • Certification of DM • • CheckingbyDMTeam/ Business IdentifyGaps,ifany • CertificationofDM Makecorrection totoolslibrary • Identify Modules for Migration and their sources in existing system • Study Data Transfer Methods • Identify Data Cleansing Needs • Draw overall schedule • • • • IdentifyModulesfor Migrationandtheir sourcesinexisting system StudyDataTransfer Methods IdentifyDataCleansing Needs Drawoverallschedule • Simulation/Mock Run • Day operations, EOD/BOD, EOM, EOQ etc. are simulated using migrated data • Certification for the data accuracy • • • Simulation/MockRun Dayoperations,EOD/BOD, EOM,EOQetc.are simulatedusingmigrated data Certificationforthedata accuracy • Make correction to tools library • • Make correction to Data • Make correc tionto Data

  5. DATA MIGRATION PROCESS

  6. Data Pick up points at HOs on Sanchay Post 22 Circle offices • A : • NSS92 • Saving Bank • Public Provident Fund • Public Provident Fund HUF • Loan Against PPF • NSC8 - 5 / 6 years • Time Deposit • KVP • MIS • RD • SCSS • Loan against RD • Fixed Deposit CO Manual data will be picked from manual registers B CO Finacle DB CO • B : • NSC8 - 5/6 years • NSC9 • NSS87 • KVP • MSY • CTD • All discontinued Certificates • IVP • NDB • SSC • NDC • 10 Year DDC • NSAC • 12 & 10 Year NPSC • 12, 7 & 5 Year NSC • NSC I-VII ISSUE) HO HODB CO SO-SH, DH, TH A All electronic data for HO migration to be picked from HODB CO

  7. Data Pick up points at SO on Sanchay Post • C : • NSS92 • Saving Bank • Public Provident Fund • Public Provident Fund HUF • Loan Against PPF, • NSC8 - 5 / 6 years • TD • KVP • MIS • RD • SCSS • Loan against RD • Fixed Deposit 22 Circle offices CO CO Finacle DB CO • D : • NSC8 - 5/6 years • NSC9 • NSS87 • KVP • MSY • CTD • All discontinued Certificates • IVP • NDB • SSC • NDC • 10 Year DDC • NSAC • 12 & 10 Year NPSC • 12, 7 & 5 Year NSC • NSC I-VII ISSUE HO HO SOSB SBCO CO D Manual data will be picked from manual registers SO – SH, DH, TH All electronic data – Centralized & Decentralized data for SO migration to be picked from SODB SODB C CO

  8. OVERALL DATA MIGRATION PROCESS FLOW Manual Data Capture( 10-15 days prior Rollout Day) • compressed pwd protected data file to DCF • compressed pwd protected data file to DCF After completion of Manual data capture by Vendor till Rollout day DCF • DMCC for ETL Activities and generation of flat files • compressed pwd protected data file to DCF Electronic Data ( Sanchay Post data) – On Rollout/Migration Day Finacle Server

  9. Rollout Cycle – Illustration for First Office 15-20 days 10 days 7 days 3d Ideally 30 days 1d Data Entry Finish Hand holding Support - Start Final Acceptance & Office Go-Live Hand holding Support - Finish Data Entry Start Data Pickup Cut off Incremental data – to be provided by DoP* *Incremental data –The data between the cutover date and the office rollout date will be provided by DoP in the electronic format which can be migrated during the Data Migration of that particular office.

  10. Data Profiling Tool Data profiling: Data profiling is the process of examining the data available in an existing data source (e.g. a database or a file) and collecting statistics and information about that data. Prerequisites for using the tool: 1) JRE 1.7 2) Supports MS SQL Server with version from 2000, 2005 and 2008 3) Adobe reader to view the report About Tool: Data Profiler Tool is used for creating files that can be used for analyzing the quality of data based on data migration rules.

  11. Data Capture process and DPT’s role – Electronic Data

  12. Data Capture Process – Manual Data

  13. MANUAL DATA CAPTURE PROCESS

  14. Tasks for DoP Prior To Manual Data Capture 1)Segregation of un-discharged certificates and live manual accounts (account opening forms, ledgers, guard files etc.) prior to Vendor Visit. 2)Ledger Cards of discontinued schemes along with account opening forms/SS Book must be traced and kept ready. 3)Post vendor data capture sign-off, all new transactions on existing accounts, opening of new accounts, closing of accounts (including discharge of certificates) related to manual data to be captured by the respective offices using the data entry tool provided by Infosys Limited. 4)SeniorPostMaster/PostMaster to allow vendors to upload/download data over DoP network. 5)Post offices to nominate a single point of contact (SPOC) to interact with Vendor / CPMs and facilitate the data capture process. 6)Each Pilot Office SPM/PM needs to confirm manual count either by endorsing CBS Website Report or the digitization Report template that has been shared with them. 7)POs to allow vendor to scan and store scanned images or data digitized from manual records into their computer systems/ external hard drives. 8)POs to ensure that proper arrangements(sitting, power, network) have been made at least one day prior to start of Data capture activities for a particular office. 9)SPM/PM to allow vendor’s accessibility to the POs to complete data capture activities within the available time constraints. 10)Closure of MSY accounts as per SB Order No. 6/2011 11)Digitization of Silent accounts including SD accounts as per SB Order No.02/2010

  15. Overall Manual Data capture Process Flow Post Master Data Entry station (Vendor Location) A/c Opening Forms and ledgers. Data movement through Communication links/CDs SIGNOFF Scanning SO1 • Download scanned docs • DO Data entry using Data Entry Tool. • Quality Check • Generate Data files and account count reports Data Storage at DES(data entry station) HO1/SO1 Data movement through communication link/CDs HOn/SOn Central Storage Server

  16. Incremental Data Capture Process The process by which DoP will capture the data in the incremental period after the data capture activity is completed by the vendor. The training for the Data Entry Tool will be provided by vendor before the start of this process.

  17. Data Validation by DoP (Post Manual Data Capture) Data Entry HUB Post Office VIA EMAIL Post Master • Vendor to send details of data captured to post masters on periodic basis. • Post Masters to manually check correctness of data entered of critical fields DE Vendor • Return findings after inspecting Summary Report Summary Reports for Each PO • Discuss with Post Master, Reconcile data entry and obtain sign off DE Vendor PostMaster • Discussion and Sign off Obtained

  18. Data Migration Setup All Phase Rollout DCF DMCC Chennai Team Managing Data Migration Through Secured Link to DCF Secure FTP Server 2 DMCC Chennai ETL activities will happen at DM Setup box. Finacle compatible flat files for an office will be generated after E&T activities. Internet 1 Extracted DB contents (electronic and manual) along with signatures uploaded via SFTP Data Migration Setup 3 • Finacle compatible flat files will made available to Finacle Environment. • Flat files will get uploaded to Finacle database and populate respective tables 4 5 • POs will perform day-to-day operation via Finacle interface and subsequent data will be stored in Finacle’s Database (Oracle) Database PO Accessing Finacle

  19. Data Migration Command Centre

  20. Command Center-Circle office Coordination Data Migration Command Center @ Chennai For Banking Circle Offices CPM CPM CPM CPM CPM Process & Audit Team Spot Decision Team • Processes Sign off • Rollout plan signoff Operations Team • Team includes one personnel from DoP • Issue Analysis • Issue Resolution • Follow up for L2 • Branch readiness • ATM site readiness • Network readiness • DM and rollout confirmation reports DM SMEs Finacle, McCamish HELPDESK Circle Level Committee Coordination Team Process & Audit Team • Obtain Data • Validate/Correct Data • Coordinate manual Data Entry • Rollout support planning • Interaction with Regional Implementation teams Data Upload Team • Process Build • Process Audit and Adaption • MIS Reporting Zonal PMs Infosys • Data Upload • L1 Issue Resolution Coordination Team • Identify ATMs site • Users list for training • Sequencing of office for DM & Rollout • M/C configuration at offices • User roles and access rights Spot Decision Team • Issue Analysis • Issue Resolution ….22 Operations Team Data Quality Team • DM Monitoring • DM Planning • Mock Run • Production • MIS Reporting • Data Capture • Data Cleansing • Data Validation & Correction • Number of accounts

  21. 6 Solution Delivery - Hub & Spoke Model 15 SAs in each circle shall form the Core Group distributed across Regions, Divisions whose role is to monitor and carry on the data cleansing activities, ensure readiness and sequencing of offices for migration,monitor and support manual data digitization process, coordination with vendors for HHS, reconciliation related issues and resolution, migration related support, etc. CO1 CO2 CO22 ……. HOs CO11 CO3 Circle Monitoring Committee Regional Implementation Committee Directorate, PMU CO4 CO10 SOs CO9 CO – Circle Offices HO – Head Post Offices SO – Sub Post Offices CO5 CO6 CO8 Cont’d CO7

  22. Application for data migration

  23. Data Flow from POs to DCF

  24. Applications for Post Office

  25. Reconciliation Process flow Sanchay Post Extraction of Source Data. Run Recon Report Generation Programs Check Finacle Upload Completion. Run Recon Report Generation Programs Post Extraction of Source Data. Run Recon Report Generation Programs Legacy Reconciliation Reports Finacle Reconciliation Reports Transformed source data Reconciliation Tool Compare the Two Reports Resolve Discrepancies if any Generate Reconciliation reports as per agreed formats between DoP & Infosys Generate Reconciliation Reports as per agreed formats between DoP & Infosys Exception Report Signed off reports for Go-Live • Execution of reconciliation programs to generate report on Source and Target. • Feed report to comparator application, which reports any discrepancies in E, T and L layer of Data migration process. • Compare Summary report of the Sanchay Post Extraction and Finacle Load summary reports. Sign-off by the postmaster for the compared summary reports. • Extraction, Transformation and Load detailed reports will be shared for information purpose only and archived. Finacle Legacy DoP Support required

  26. CBS Data Migration Flow: Recon Report DPT Report Exception Report Recon Report Recon Report DPT Finacle Zip Files Oracle 11g Database Stage 2 Area Oracle 11g Database (Electronic +Manual Data) Stage 1 Area U1 Sanchay Post Office Database (SQL Server) F1 FTP Upload Extraction Script U2 Jasper ETL F2 Upload Script FTP Upload U3 Electronic Data Fn Extraction & Transformation Un Vendor Extraction Script Upload Flat Files DET MS Access Database DOP Manual Data Post Office (DOP) DPT : Data Profiling Tool DET : Data Entry Tool F1,F2,...,Fn : Flat Files generated by Extract Scripts FTP : File Transfer Protocol Jasper ETL : Jasper Tool for Extract, Transform & Upload DPT Table : Table generated by DPT Tool to insert erroneous records U1, U2,…,Un : Upload Flat Files ,Finacle : Core Banking Application , Stage 1 Area : This area will store the direct dump of source data ,Stage 2 Area : This area will store transformed data

  27. CBS Data Migration Flow For electronic data before migration, interest for Savings Bank type of products will be calculated in Sanchay Post by PO using Infosys provided solution. Sanchay Post Data (Electronic Data) will be checked by DPT tool and a report will be generated (DPT Report). This report should not have any discrepancy before the migration. Manual Data will be converted into Electronic form using DET tool. Both manual & Electronic data will be extracted into flat files using Extraction Scripts. These flat files will be password protected and shared through FTP for migration. Source part of Reconciliation Report will be generated on Sanchay Post database. The source data in flat files will be uploaded in Stage 1 area using Upload scripts. Stage 1 data will be extracted, transformed and loaded to Stage 2 database using Jasper ETL tool. Exception report will be generated if error is found while transforming data. These report will be shared with DOP for correcting the data. Intermediate Reconciliation report will be generated between Stage1 and Stage 2 database for internal verification. Upload Flat files will be created based on stage 2 data and will be sent to Finacle for Upload. Final reconciliation report will be generated between Sanchay Post database and Finacle and this report will be shared with DoP for sign-off. All three reconciliation reports should exactly match, both in terms of number of accounts as well as balance.

  28. ROLL OUT/GO LIVE

  29. Dependencies for Rollout Ro -15d Ro Indicates cutover date for Go Live Manual data and Signature capture electronically Prepare Rollout Plans & reviews with DoP Ro -7d Conduct user Trainings Ro -15d Installation of Hardware at CPCs Rollout to Production Data Migration Finacle - CBS Data Cleansing and enrichment of electronic data Databases Ro -15d CBS Office Desktops Availability at HOs & SOs DoP / Infosys responsibility Infosys responsibility DoPresponsibility Nominate End Users, User Champs, Sys Admins for Training Readiness of Data Center, and Network Connectivity (LAN & WAN) Ro -30d Ro-30d Ro -22d

  30. Rollout - Hand Holding Support • Activities to be performed during Hand Holding Support Entry Criteria Exit Criteria • Support Branch on the day of migration in uploading data (In case of errors) into Finacle – By Infosys Vendor • Reconciliation of migrated data with legacy data – By DoP • Perform tests to check the system’s functionalities – By DoP and Infosys Vendor • Support End user in using Finacle application on daily operations, report generations & tallying of accounts – By Infosys Vendor • Updated Rollout Plan • Network Readiness – Connectivity to DCF Established • End User Trained • CPC Ready • Sign-off on Reconciliation Reports • Sign-off on Hand Holding Support completion • Sign-off on final office acceptance (Post 7 days of trouble-free operation)

  31. RESPONSIBILITIES

  32. Responsibilities

  33. Responsibilities

  34. Migration Criteria for PO

  35. Thank You

More Related