1 / 23

Table of Contents

Table of Contents. Purpose and Prerequisites Data Migration Data Flow Data Migration Process Flow Data Migration Process Description Roles and Responsibilities Premium Collection after Data Migration Roll-outs PLI Data Cleansing Data Mapping McCamish Modules.

laasya
Download Presentation

Table of Contents

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. Table of Contents Purpose and Prerequisites Data Migration Data Flow Data Migration Process Flow Data Migration Process Description Roles and Responsibilities Premium Collection after Data Migration Roll-outs PLI Data Cleansing Data Mapping McCamish Modules

  2. Purpose, Inputs and Output for Data Migration Process

  3. Data Migration Data Flow

  4. Data Migration Process Flow Sign-off on DM Plan -Finalise DM Process -DM Training -LAN/WAN Readiness Data Mapping (Source System v/s Target System)--------------------------- DM Team - Infosys Share scripts of Data Cleansing rules with NIC/PLI --------------------------- Infosys PLI to run scripts and share the discrepancy report with the circles • --------------------------- • IP (PLI) Data Cleansing & Enrichment --------------------------- Sys Admin – IP (PLI) Data is clean or not? Sign-off from IP (PLI) • ----------------------- • PMU – IP (PLI) To next phase DB – Converted and Cleansed data of all HOs NO YES

  5. Data Profiling Report Data Migration Process Flow…Contd. Transfer PLI/RPLI DB from NIC------------------------- DM Team - Infosys From previous phase Extract Data------------------------- DM Team - Infosys • Pre-staging Area Data Validation & Correction ------------------------- Circle Officer – Infosys & IP (PLI) Transform Source Data into format as reqd. by Target System--------------------------- DM Team - Infosys Target Schema Tables (Stage 2 Area) Stage 1 Area Reconciliation------------------------- DM Team - Infosys Data Upload------------------------- Upload Team - Infosys Reconciliation Report Sign-off-------------- PMU – IP (PLI) • Reconciliation Report McCamish Staging Area

  6. Data Migration Process Flow…Contd. Trial Run ------------------------ DM Team - Infosys From previous phase One-time activity for the selected offices Sign-off-------------- PMU – IP (PLI) SIT Report System Integration Testing --------------------------- DM Team - Infosys UAT Report Mock Run ------------------------ DM Team - Infosys User Acceptance Testing --------------------------- Zonal PMs – Infosys & End User IP (PLI) YES Bug Fixing • Is SIT successful? NO Bug Fixing • Is UAT successful? NO DataUploading - Final ------------------------ DM Team - Infosys YES End McCamish Tables

  7. Sharing of PLI/RPLI Data cleansing scripts to NIC by Infosys .NIC will share the discrepancy reports to Circle offices after executing the scripts • Data will be cleansed and enriched with the help of Data Enrichment Cleansing Rules by DoP • The cleansed DB will be transferred to the pre staging area Data Migration Process Description

  8. Data Migration Process Description…Contd.

  9. Roles and Responsibilities

  10. Premium Collection after Data Migration roll-outs (Till entire circle gets migrated)

  11. PLI – Data Cleansing

  12. Data Discrepancy Report

  13. Data Discrepancy Report

  14. Data Issues • Policy Status not known or is incorrect in system • Pay Mode is Null • Medical is Null or is Invalid • DO Code is Null • Spouse DOB is Null (YS) • Invalid Gender • Invalid Category • Difference between DOB and DOA is more than 45 years (CWLA Policies) . • Policies with loan amount less than 1000.

  15. Data Cleansing • Infosys provided data cleansing scripts to DoP to generate policy wise data discrepancy report for Pilot offices • DoP to get those scripts run and share discrepancy report with respective offices • To run these scripts, appropriate access to database is required • Cleansing is to be done manually mostly by referring to case files and/or related ledger / table • Refer to data cleansing rules for more details in share point

  16. Data Mapping

  17. PLI Schema

  18. PLI Schema

  19. PLI Schema

  20. PLI Schema

  21. McCamish Modules • PMACS - Agency Management and compensation System • NBF – New Business Fulfillment • VPAS – Customer, Policy, Billing and other financial details

More Related