{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":169,"n_cols":5,"rows_kept":169,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,4],[3,0,3,4],[1,2,1,4]]}
["LIC Of India"]
[null,"Bidder's Name:"]
["Ref: LIC/CO/IT-SD/EFEAP-NEXT/CDC-ETL/24-25/01 Dated: 10-05-2024"]
["TECHNICAL SPECIFICATION FOR Procurement and Implementation of Change Data Capture (CDC) and Extract Transform Load (ETL) Solution (Annexure-17)"]
["SL.No","General Specifications","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The proposed solution should Analyze, design, develop, implement and maintain end-to-end CDC-ETL Solution",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[2.0,"The proposed solution should Study the existing Data Sources to arrive at the comprehensive CDC-ETL Solution for LIC",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[3.0,"The bidder shall provide a detailed SRS, FRS document and project implementation plans, subject to approval by LIC before proceeding",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[4.0,"The proposed solution should implement near real time Change data Capture process",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[5.0,"The proposed solution should Establish a Staging Area/Landing Zone for captured data",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[6.0,"The proposed solution should Deploy Extract, Transform, and Load pipeline for data transformation",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[7.0,"The proposed solution should deploy real time pipelines for streaming data.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[8.0,"The proposed solution should Integrate CDC-captured data with Staging Area and further transform and load it into target OLAP and Reporting systems",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[9.0,"The proposed solution should implement and and Integrate ETL pipeline for various projects",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[10.0,"The proposed solution should be customizable as per the scope and objective of RFP and business needs of LIC.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[11.0,"The bidder, in coordination with the OEM must make a detailed study of LIC infrastructure and requirements relating to the solution and prepare a detailed plan document/road map.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[12.0,"The design and implementation plan of the proposed solution should be validated by both bidder and OEM.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[13.0,"The proposed solution should integrate with new Data Technology like Data Lake",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[14.0,"The bidder shall provide a OEM approved roadmap/plan for product support for next 7 years",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[15.0,"Source code of all the customization, scripts etc should be delivered to LIC by the Bidder at a periodicity to be decided by LIC.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[16.0,"Automated periodic reconciliation and re-sync the gap in target system",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[17.0,"Data Requirements for implementation of IFRS 17/IND-AS 117 will have to handled",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
["SL No.","MAF Submittion","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"MAF is to be submitted for proposed paid softwares/Tools being proposed by bidder for CDC-ETL solution.",null,"Annexure-19 (Manufactors's Authorization Form) of RFP"]
["SL No.","Data Architecture and infrastructure","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The proposed solution should be able to handle data for CDC from approx 140+ core insurance system/data instances where data size of each instance ranges from 500GB to 2.5 TB and binlogs generated is approx 10 GB per day per instance.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The proposed solution should be able to handle data for CDC from few ODS system/data instances .",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The proposed solution should be able to integrate with the databases(OLTP/OLAP) of source systems/data instances ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The proposed solution should have one staging Area/Landing Zone setup. This setup will be required to consolidate the data extracted by CDC tools from source systems for further consumption and transformation by ETL tool.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The data retention period at Sraging area/Landing zone to be considered is 15 days for Core Insurance Solution data and 7 days for ODS data.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The proposed solution should be compatible with target systems having databases like Oracle, MySQL and Vertica.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"The bidder shall provision and implement the transport pipeline for transferring data after extraction by CDC tool from source systems to Staging area or till consumption by ETL tool.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"The bidder should make provision and implement the capability to transport data from source to target using Publish-subscribe(messaging), Event Streaming and replication methodologies.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[9.0,"The bidder shall design and build the real time pipelines for streaming the data events to an event broker that will be consumed by different subscribers such as the business domain services.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
["SL No.","Proposed Infrastructure requirements","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The Proposed solution is to be deployed in on-premise Private cloud of LIC.  However it should have capability to be deployed in Public cloud environment also.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The proposed solution should be implemented in High Availability mode.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The proposed solution should have Development, UAT and Production environment.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The proposed solution should be with DR provisioning and robust BCP plan.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The bidder shall provide a detailed Hardware and Software sizing for all  components of the proposed solution taking into account an YoY increase of 15%.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"Network will be provided by LIC. Network Bandwidth Requirement Estimation is to be provided by the bidder.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0," The proposed solution should be integrated with other security/infrastructure solutions implemented in LIC.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"The Proposed solution should support Cloud native application and also Micro services environment.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Change data Capture (CDC) Requirements","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The proposed tool shaoul have all the standard features of an enterprise CDC tool",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The proposed CDC tool should have been implemented in at least two organisations in India.",null,"PO/Letter/email from the organisations containing details about implementation.","Mention details"]
[3.0,"The proposed solution should Integrate with heterogeneous source and target databases like Oracle, MongoDB, Mysql, DB2, Postgre SQL, big data, Hadoop, Teradata, vertica etc",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The proposed solution should Capture all data changes with low delay/ near real-time. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The proposed solution should have pre-built connectors or data pipelines for major commercial databases like Mysql, Oracle and Vertica etc",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The proposed solution should Capture all data changes at source systems which are required for the target systems.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"The proposed solution should Capture the data with minimum delay with an upper limit of 1 second per transaction. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"The proposed solution should transfer One lakh transactions from source system within maximum of 5 seconds.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[9.0,"The proposed solution should not increase CPU usage in source systems due to CDC tool processes.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[10.0,"The proposed solution should not require any changes in source Data model and structure",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[11.0,"The proposed solution should capture  all DDL and DML commands (Insert, Update, Delete etc), structure changes, metadata of the source database. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[12.0,"The proposed solution should capture/extract entire data from tables in the source databases in bulk for first time usage and shopuld also be flexible with time to time requirements",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[13.0,"The proposed solution should Capture the data from database logs of production as well as replication database at any given point of time",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[14.0,"The proposed solution should have the capability to expose/consume APIs",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[15.0,"The proposed solution should be scalable to handle new data requirements",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[16.0,"The proposed solution should provide the reconciliation mechanism with Data monitoring ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[17.0,"The proposed solution should should be capable of Integrating and interoperating with different OS across source/target systems like Windows and Linux Operating System",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[18.0,"The proposed solution should Integrate with LIC’s Active Directory, email, SMS, Biometric (2FA) Solutions for different activities related to sending mail, SMS and biometric access",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[19.0,"The proposed solution should support for no-code or low-code interfaces",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[20.0,"The proposed solution should have pre-built connectors or data pipelines for major commercial databases like Mysql, Oracle and Vertica",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[21.0,"Support for various data types including BLOB, CLOB and NCLOB.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[22.0,"Support for Structured, semi-structured and unstructured data for change data capture.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[23.0,"Data sanity checks, automated reject processing, validations and reconciliation of data should be available as part of CDC  solution to ensure the integrity of data",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[24.0,"GUI Based Dashboard for centrally monitoring the CDC progress.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[25.0,"Centralized Data Sanity Check, validation and Reconcilication mechanism for all Change Data Capture Transactions.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[26.0,"The proposed solution should have an in-built mechanism to resolve / handle Conflicts in transactions while effecting changes to Target system",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[27.0,"The proposed CDC tool should provide automatic and manual ability to configure database schema mappings between source and targets.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[28.0,"The proposed CDC tool should provide simple transformations such as data-type conversions, string manipulations and simple calculations example date conversion.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[29.0,"The proposed CDC tool should have support for JSON, XML and similar technologies. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Setting up of Staging Area/Landing Zone","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should plan and design the architecture and sizing of staging area considering the architecture of source databases.",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[2.0,"The proposed solution should have the staging area as preferably centralized or zone wise segregated setup consolidating all source location databases",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[3.0,"The proposed staging area architecture must support RDBMS, text based or xml based or JSON based storage of data",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The data structure of the proposed staging area should be similar to source database with identifiers for individual row wise data for all insert, update and deletes",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The proposed staging area architecture should support the provision for holding data for a particular time and also wiping data after transformation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The proposed staging area should have minimum following features:\na. Consolidation of data\nb. Alignment of data from various source databases and maintenance of relationship between various source systems.\nc. Staging area should support independent scheduling and multiple targets.\nd. Data cleansing.\ne. Aggregation\nf. Data archiving\n",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","ETL (Extract, Transform and Load) Requirements","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The proposed tool should have all the standard features of an enterprise ETL tool",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The proposed ETL tool should have been implemented in at least two organisations in India.",null,"PO/Letter/email from the organisations containing details about implementation.","Mention details"]
[3.0,"The proposed solution should Implement in High Availability mode with high performance",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The proposed solution should have features of bulk loading and caching, ingestion of data in batches, incremental additions, streaming and real time feeds.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The proposed solution should provide Dev, UAT and Production environment",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The proposed solution should customize the tool to meet specific data transfer requirements from the Core Insurance Solution to DW, ODS, COMIS, IND-AS and potential future applications",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"The proposed solution should have inbuilt connectors to various databases on both public and private cloud like Mysql, Oracle, MS-SQL, Postgre Sql, Hadoop, Vertica, AWS, Google Cloud, Azure  and other commercial databases",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"The proposed solution should support following \na. Files, FTP, ODBC/JDBC, XML, CSV,JSON.\nb. Microsoft Excel.\nc. Webservices, Messaging Solutions.\nd. Structured and unstructured data",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[9.0,"The proposed solution should support API integration (Both Consuming Other Application APIs and Exposing ETL APIs) ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[10.0,"The proposed solution should Support no code/low code development",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[11.0,"The proposed solution must have end-to-end automation capabilities including job scheduling and process orchestration to streamline the data management process",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[12.0,"The proposed solution should perform minimum but not limited to following activities on data:\na. Data Cleansing\nb. Combining data from various sources\nc. Conversion\nd. Lookup\ne. Joining the data\nf. Splitting the data\ng. Filtering\nh. Ranking \ni. Sorting\nj. Grouping\nk. Looping\nl. Inserting data",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[13.0,"The proposed solution should perform minimum Workflows but not limited to:-\na. Create workflows as per the requirements of various integrations.\nb. Support script based and graphical user interface for workflow creation.\nc. Log the execution of workflow with minimum timelines.\nd. Mechanism to re-run failed workflows.                                                         e. Provision to incorporate additional data points/objects in source system to target ETL workflow.\n",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[14.0,"The proposed solution should perform logging of job execution, error handling and notifications to ensure data quality and reliability",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[15.0,"The proposed solution should have escalation mechanism for various issues and errors during different stages of ETL process.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[16.0,"The proposed solution should be scalable and configurable as per the requirments of LIC",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[17.0,"The proposed solution should support load balancing for data transformation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[18.0,"The proposed solution should have data lineage, audit trail  and diagnostic for all data before and after transformation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[19.0,"The proposed solution should support distributed computing, in-memory processing, multithreading and parallel processing for bulk load and large data sets to achieve enhanced performance",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[20.0,"The proposed solution should have optimization features like query optimization and memory management to enhance performance",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[21.0,"The proposed solution should include data encryption, access controls and compliance capabilities (GDPR, HIPPA)",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[22.0,"The ETL solution should auto resume from checkpoint without manual intervention.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[23.0,"Central real time Alerting and monitoring utility should be part of the solution.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[24.0,"Risk Analysis of each and every ETL process is to be made available by the bidder.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[25.0,"Data valume analysis for a specified duration like real time, dailiy, weekly, monthly, quarterly etc should  be available for transformed data on the dashboard.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[26.0,"There should be provision to monitor, log and assess the progress of each transformation job.\nJob design (s) should be re-usable.\nThere should be a provision to organize individual transformations as user defined operators. Provision should be there in framework to tie these operators to data structures and organize the entire process as a single job.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[27.0,"The proposed solution should have escalation mechanism.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[28.0,"The proposed solution should have capabilities to scale as per future requirements",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[29.0,"The proposed solution should include data encryption, access controls and compliance certificates",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[30.0,"The proposed ETL Tool should support Metadata based Integration without the need to write individual jobs. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[31.0,"ETL tool should incorporate advanced matching algorithms.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[32.0,"ETL tool should include advanced profiling capabilities .",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Software Licensing","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The Bidder needs to provide licenses for:\na. CDC Tool\nb. ETL Tool\nc. Data Transfer tool.\nd. Any other Software required for end-to-end implementation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The bidder is required to select an appropriate suite of software tools, presenting a comparative analysis of their features.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"Bidder must ensure that proposed/used software/tools are not locked with the selected bidder and LIC should be able to use these software/tools independent of the status of the contract with the selected bidder",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The bidder shall provide Premier 24x7 support from the OEM for the licensed components.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The software and tools proposed should be able to integrate seamlessly with various in scope applications, tools/software used in these applications and its underlying dependencies.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The proposed tools should be able to scale out both vertically and horizontally without any aditional cost.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Project Implementation and Project Management","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should develop a comprehensive project plan outlining milestones, deliverables, and timelines",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[2.0,"The bidder shpould Design and implement the CDC and ETL solutions to accommodate future data growth and increased processing demands. ",null,"Proposal Document","Mention Page Number of Proposal Document for reference."]
[3.0,"The bidder should implement the project in a phased manner and should finalise a scheduled implementation plan",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The bidder should ensure appropriate resources will be deployed at LIC’s premise for timely implementation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The bidder should provide a dedicated project manager to oversee all project activities, ensuring timely completion and adherence to budget.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"The bidder shall provide architects for the solutions proposed and OEM engineers for timely and successful implementation of the project",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"The bidder should conduct performance testing to validate system capacity and identify potential bottlenecks",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"The bidder shall submit regular progress reports to LIC, including detailed information on project status, risks, and mitigation strategies",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[9.0,"The Bidder sshall ensure implementation and upgrade rollback mechanism should be in place as approved by LIC",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[10.0,"The bidder shall verify that the post-implementation production functionality meets approved requirements and provide the evidence to support this verification to LIC. Any post-implementation defects shall be identified, corrected, and closed. LIC retains formal and final authority to accept and approve the vendor’s deliverables",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Managed Services","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should provide adequate SMEs (Subject Matter Experts) for both CDC and ETL are to be provided during both implementation and maintenance phase",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The bidder should provide appropriate Onsite BAU support for maintenance after pilot implementation",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The bidder should establish incident response, problem resolution and regular maintenance of proposed solution",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Monitoring and post implementation support","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should provide and implement all future upgrades or version upgrades of the proposed solution during contract period without any cost",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The bidder should regularly monitor system performance and resource utilization, implementing optimization strategies to ensure efficient data processing and scalability",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The bidder should conduct performance testing to validate system capacity and identify potential bottlenecks",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The bidder shall submit regular progress reports to LIC, including detailed information on project status, risks, and mitigation strategies",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The bidder should ensure that rollback mechanism is in place as approved by LIC",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["Slno","Monitoring Dashboard for CDC and ETL","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"Real time data flow to dashboard for both CDC and ETL tools.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"Health Moniotring of the proposed solution",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"Moniotring of all data sources",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"End to end Performance monitoring for both the tools",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"Controlling threshhold breaches",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"Email Alert Facility",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"Data reconciliation for each and every data movement for both CDC and ETL tools.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Security and compliance","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should resolve any vulnerability found in the CDC-ETL solution as and when identified by LIC as well as Hardware/Software OEMs. Patches made available by the OEMs should be applied immediately. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The bidder should ensure that he proposed solution should comply with all IS Audit Requirements of LIC as well as other Regulatory Requirements which will be shared once the Bidder is on-boarded",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The bidder should ensure that the proposed solution should be able to integrate with existing hardware/software/database in LIC after upgradation. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[4.0,"The bidder should Implement robust security measures, including data encryption, access control, and audit logging, to protect data privacy and integrity throughout the data lifecycle",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[5.0,"The bidder should demonstrate compliance with relevant industry regulations and LIC’s internal security policies",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[6.0,"All vulnerabilities should be closed by vendor immediately or with-in 15 days of reporting the same to bidder.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[7.0,"LIC shall conduct information security audit including VA-PT for the application and underlying infrastructure through third Party firms at regular intervals. The bidder has to support in all aspects of conducting security audits, which may include physical verification of infrastructure. The bidder shall close any gaps emanating from such audits as part of regular activities.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[8.0,"Patches made available by the OEMs should be applied immediately by the vendor. ",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[9.0,"The bidder should ensure the software/agent software deployed on Source systems should not affect the performance, software upgrades, patching of OS or Database, in any way. If the host database requires the removal of third party vendor software prior to patching/upgrades, it shall be the responsibility of the vendor  to uninstall the third party software prior to upgrades/Patching and re-install and configure post upgrades/patching.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[10.0,"The bidder should ensure that rollback mechanism is in place as approved by LIC",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
["SL No.","Documentation and Training","Compliance (Yes/No)","Documentary Evidence ( Also state  the Software  Proposed where applicable ) ","Link to Submitted Document for Immediate Reference"]
[1.0,"The bidder should develop comprehensive documentation for the entire proposed solution/software including the CDC and ETL tools. The documentation should contain but not limited to installation, configuration, operation, and maintenance procedures.",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[2.0,"The bidder should  provide comprehensive training sessions for LIC’s IT staff on operating and maintaining the tools, ensuring efficient data management and utilization",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[3.0,"The bidder should offer ongoing support and resources for learning and development related to the tools and data management best practices",null,"Proposal Document/Reference Document","Mention Page Number of Proposal Document for reference and link/Document name of the reference document."]
[]
[]
[]
[]
[null,"Signature of Vendor/Vendor's Representative",null,"Date:","dd-mm-yyyy"]