crdb

Expression for Interest for the Implementation of Enterprise Data Warehouse and Business Intelligence Solution

WhatsApp
Twitter
Email
LinkedIn
Instagram

CRDB BANK

INVITATION FOR EXPRESSION OF INTEREST (EOI) FOR THE
IMPLEMENTATION OF ENTERPRISE DATA WAREHOUSE AND
BUSINESS INTELLIGENCE SOLUTION

1 CRDB Bank Pie is an African bank and leading financial service provider in Tanzania with current presence in Tanzania and Burundi, East Africa. The Bank was established in 1996 and was listed on the Dar-es-salaam stock Exchange (DSE) IN June 2019.

2. CRDB Bank PLC is keen on embarking on a Data Analytics journey to gain an advantage over its competitors in terms of innovation, products time to market, user delight and cost of service. Current modality of data processing has main focus on reporting needs and captures data for end of day reports/credit – debits/assets – liabilities etc. This approach has a disadvantage of missing important insights I patterns from data. In this regard, the Bank has set aside funds for its operations towards it s CAPEX and it is intended that part of these fund will be applied for the implementation of this project.

3. CRDB Bank PLC is now inviting Seated Tenders from “all eligible, competent and experienced firms to apply for the Expression of Interest for the implementation of Enterprise Data Warehouse and Business Intelligence Solution. Below are the high level requirements for the’ expected solution: –

  • Data Warehouse, Data Integration, Data Marts and Data Stores
  • Use case driven and scalable Data Warehouse
  • Data Visualization and Data Modelling
  • Data Archival and backup Sandboxes for innovation, research and development purpose
  • Ensuring Data Quality & Data Reconciliation
  • Data Governance including Data Dictionary and Data Lineage
  • Business Intelligence Tools, real time reporting, analytics and self-service (query generator)
  • Machine learning’ support
  • Compliance to Global standards and CRDB Bank PLC Internal policies
  • Framework for regulatory reporting
  • Data protection, Data security, Data privacy
  • Real time Data ingestion with spontaneous reconcil iation
  • Log Storage/ Archive

In your EOI Proposal, the following items must be

  • included for each proposed option: –
  • The Specifications for PROD, DEV, UAT and DR environments
  • Architecture Diagram
  • Process/Data Flow Diagram
  • Proposed software specification and features of each software product
  • Any other relevant artefacts
  • Cost model (How the licensing will be done)
  • Implementation Team structure (without actual profiles)
  • Performance benchmark
  • Tentative Project Timeline

Critical Functional Requirements

  • Capable of ingesting data from any source system in automated manner
  • currently implemented in the Bank.
  • There should be no limitation on the type, format and size of data ingested.
  • GUI based framework to configure sources to DWH.
  • Ingestion subsystem should allow configuring ingestion processes from
  • single I multiple source system, single I multiple files, single I multiple
  • operational input files.
  • Tools used for Data Ingestion should be platform and database independent and should be compatible to ingest and replicate data on
    parallel processing.
  • Data sanity checks, automated reject processing, validations and reconciliation of data should be avai lable as part of data ingestion
    solution to ensure the integrity of data.
  • ETL jobs should have checkpoints, resumed capabi lities and parallel read and write
  • Ingestion subsystem should generate audit and diagnostic logs
  • An alerting report and monitoring uti lity should be avai lable as part of t he solution.
  • Trigger mechanisms in identifying any structural changes at source/change data capture capabilities.
  • Trigger mechanisms in identifying any structural changes at source/change data capture capabilities.
  • Proposed solution should be able to capture Metadata changes at source level completely.
  • Solution should be able to handle DDL change without manual reorg/ runstat.
  • The solution must be platform independent.

The proposed solution should further ensure the following are considered without failure: –

  • Data Processing Framework
  • Data Visualization
  • Regulatory Reporting
  • Disaster Recovery
  • Audit and Log Management
  • Data Encryption
  • Data Archival and Backup
  • Monitoring and Dashboards
  • Data Governance
  • Data Masking
  • Business Intelligence Tool
  • Analytical Capabilities
  • Data Quality
  • Security and Compliance
  • Authentication and Identity Management

4 Tendering will be conducted according to CRDB Bank Pie Procurement Policies and Procedures. Only shortl isted Vendors will be eligible for invitation the Request for Proposal (RFP) stage.

5 Other selection criteria shall be as follows: –

A. Legal compllance

  • Submission of all registrations from relevant authority
  • Submission of valid business, Certificate of Incorporation or extract from registrar
  • Submission of TIN, VAT (for registered), valid Tax clearance certificate
  • Current physical location with valid lease agreement
  • Submission of certified litigation history certificate

B. Company capabllltles, competence and ellglblllty

  • Show evidence of at least FIVE (5) years’ experience in the relevant field
  • Submission of CV and copies of certificates for key personnel and technical staff
  • Submit at least THREE (3) years of latest AUDITED financial statements
  • Demonstrate capabilities in terms of equipment, skills and technology

6 For any clarification you may contact office of t he secretary, CRDB Bahk Pie Tender Committee, situated at 1st Floor, CRDB Head Office, along Azikiwe Street. Office Accommodation Scheme Building, opposite New Post Office from 08:00am to l6:00 hrs Monday to Friday except on public holidays.

7 All Tenders in one original, duly fi lled in, and enclosed in plain envelopes must be delivered to the Tender Box on the 1st Floor. CRDB Head Office, along Azikiwe Street, Office Accommodation Scheme Building, Opposite New Post Office, P. 0. Box 268, Dar es Salaam before 1500 hours’ local time on 19th August, 2019. All Tenders clearly marked with the appropriated Tender Name and Number should be addressed to t he Managing Director, CRDB Bank Pie, P. 0 . Box 268, Dar es Salaam.

8 Tenders will be opened in public on the same date at 1500 hours and in the presence of Tenderer’s representative who chooses to attend the opening at CRDB Bank Pie Head Office, First Floor DAGS Meeting Room.

9. Late Tenders, a portion of Tenders, Electronic Tenders, Tenders not received, and not opened and not read out in public at the Tender opening ceremony shall not be accepted for evaluation irrespective of t he circumstances. Any application not received, not opened and not read out in public Tender opening ceremony shall not be considered for evaluation irrespective of t he circumstances. Telegraph, Telex, Telefax, Email and late bid will b& rejected.

The Managing Director
CRDB Bank Pie
P.O. Box 268
Dar es Salaam. Tanzania

WhatsApp
Twitter
Email
LinkedIn
Instagram

Related