WIXLIB

RFP for Consultant Services for DatawarehouseRe-Tender-1-SMA Reports, DSB Returns and various other adhoc reports ofCredit Monitoring Department.RM Process and other adhoc data requirements of RiskManagement DepartmentRBS reports, Industry wise Exposure, Disbursement data and otherdata requirements of C&IC DepartmentDICGC Half Yearly Reports and other data requirements pertainingto Finance Department.Audit Automation Project of I & A dept3.1.4 Bank is in the process of implementing Fraud Risk Management (FRM) solutionby Fraud Risk Management Department (FRMD) and Early Warning Signal(EWS) solution by Credit Monitoring Department (CRMD).3.1.5 The detailed information with documentation available on our records withrespect to Datawarehouse products, modules , architecture, tools, data size &YoY / QoQ growth , MDM, data sources , inventory list, business functions etcwill be shared with the selected bidder.3.2Need of Next Generation Data-warehouse3.2.1 We are generating and storing huge volume of data at DWH that mainly containscustomers’ demographic & transactional data and financial accounting data of theBank. With the huge growth in the internet based enterprises and availability ofmany social networks there is huge volume of data available outside the bank thatremains un-tapped for analysis. Bank can no longer focus only on delivering bestproducts or service; but also requires to examine behavior & in-sights of customers(both existing customers and hidden customers) to deliver tangible businessvalues to them and increase the profitability.3.2.2 Bank requires a modern data-warehouse strategy to address both enterprise dataand big data management that act at the speed of business, offering real-timeinsights that can be applied to massive volumes of data. Bank needs to leverageits Data warehouse, using data mining and advanced analytics techniques, forgenerating actionable insights, manage risk and to drive profitable growth. Ourexisting Oracle Data Miner tool has limited features & functionality for analytics.3.2.3 Advanced Risk modeling of modern data-warehouse would help the bank tomake better credit risk decisions and monitor their portfolios for early identificationof potential problems, detect financial crime and predict operational losses.3.2.4 The modern data-warehouse having easy deployment, simplified user interface,minimal coding requirements would reduce the dependency on requirement ofdata scientists and IT experts support. This will address the shortage of in-housetalent in these areas. Confidential & ProprietaryPage 8 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-13.2.5 Regulators are moving fast from their existing data upload processes toAutomated Data Flow to pull required data points directly (STP) from bank’ssource data servers. The more emphasis is given on no manual intervention ingetting the data and ensure data authenticity. Banks can reduce highly manualtasks by streamlining data extraction from source systems and standardizing dataaggregation and reporting. Financial Analytical modules like Ind-As, OperationalRisk, Market Risk , fraud detection & Prevention etc need to be implemented bythe bank in near future to comply with regulatory requirements.3.2.6 New and evolving analytical processing technologies are available in the marketthat make it possible to have –a) New systems that handle a wide variety of data from banking data to weband social media data. Improved analytical capabilities including event,predictive and text analytics, using various tools/technology like AI, ML etc.b) Operational business intelligence that improves business agility byenabling automated real-time actions and intraday decision making.c) Faster hardware ranging from faster multi-core processors and largememory spaces, to compact drives and virtual data storage for handling hotand cold data.3.2.7In view of above , Bank intends to engage Consultant services for Datawarehouse to study our existing DWH setup, review gap analysis for dataavailability & quality vis-a-vis our requirements for advanced Dashboard,Analytics, increase the level of automation using artificial intelligence, cognitiveanalytics and machine learning in backend process especially risk management,compliance management and fraud controls to bring in greater efficiency andreduce fraud and security risk etc. and recommend most suitable & cost-effectivenext generation Data-warehouse solution as per the latest industry standards.3.2.8 Consortiuma) The bidder may have a tie-up with other consultancy services providing firmas consortium partner for providing an end-to-end services as required underthis RFP.b) Bidder can have maximum one consortium partner.c) Bidder should have a back-to-back agreement with consortium partner duringthe currency of contract to ensure that end-to-end consultancy servicesproposed as per this RFP is provided as a turnkey services.d) Consortium partner should not participate in a capacity as a Bidder or as aconsortium partner for more than one Bidder under this RFP.e) Consortium partner of the selected bidder shall not be eligible to participate insubsequent RFP for System Integrator to implement next-gen solutions underthis RFP project. Confidential & ProprietaryPage 9 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1f) Bank will enter into the contract with the selected Bidder only and not with anyconsortium partner / third party of the selected Bidder.g) Selected Bidder will be the one point contact to provide end-to-end servicesas required under this RFP and responsible throughout the contract period.3.3Broad Scope of Work3.3.1 Bank is now intend to engage services of suitable , reputed Consultant firm forData-warehouse to study our existing DWH Applications , Hardware, Networkinfrastructure Setup , review gap / analysis for data availability & quality visa-avis our requirements for having next-generation DWH solutions as per latestindustry standards consisting advanced Dashboard, Frauds and Analytics &Prevention, Forecasts & Predictions, Artificial Intelligence (AI) , Machine Learning(ML) , Robotic Process Automation (RPA) , Decision Support systems (DSS) andBusiness Intelligence (BI), Data Protection , Information Security , Report / MIS& Monitoring Tools etc and recommend most suitable & cost-effective solutionsand provide PMO services on End-to-End basis from understanding the BOIrequirements, preparing a business case with program cost and benefits,creating a scope document, creating a framework for onboarding systemintegrator, and managing the onboarding of the system integrator / vendor tillimplementation of the proposed solutions as approved by the Bank as per thescope of this RFP, but not limited to –a) Assess the current SOW , Hardware , Applications, Network , InformationSecurity setup of Data-warehouse in all respectb) Examine data quality issues / gaps like accuracy , consistency, integrity,validity, completeness etc. and suggest the ways to enrich the data fordeep analysisc) Define the requirements to have NextGen Datawarehoused) Define requirements of capturing additional data fields at applicationlevel, further customization scope and capabilities as per therequirements of the Banke) Define to enrich existing BI dashboard for various business dimensionsf) Define , assist & monitor in developing / implementing Frauds andAnalytics & Prevention, Forecasts & Predictions, Artificial Intelligence(AI) , Machine Learning (ML) , Robotic Process Automation (RPA) ,Decision Support systems (DSS) and Business Intelligence (BI), Data /Information Security , various Risk Reports / inter-active Dashboard forearly identification of potential problems, detect financial crime andpredict operational losses along with the required upgrades /infrastructure of Hardware , Network , Applications sizing / licenses/setupg) Increase the level of automation using Artificial Intelligence (AI),Cognitive Analytics and Machine Learning in backend processes.h) Define a roadmap with actionable targets in different dimensions to beachieved over a period of time in various phases. Confidential & ProprietaryPage 10 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1i)Define most suitable & cost-effective next generation Data-warehousesolution as per the latest industry standards covering Bank’srequirements.j) Define efficient solution for creating foundational data storage to meetanalytical and strategic MIS needs, customize Data Repository. Provideanalytical Use Cases especially for 360 degree view of customers andidentification of risks from transactions, Data portability including on webpresence with secure, encrypted and containerized application platform.k) Define scope of work for technical , functional , commercials, otherclauses(like termination, limitation of liabilities, indemnity clause ,Service Level Agreement etc.) / requirements(facility management,24*7support, onsite skilled resources etc.) of RFP for proposed nextgeneration Data-warehouse solution (Hardware , Network , Applications,support Services etc.) as approved by the Bankl) Conduct technical evaluation of Bids and selection of System Integratorfor implementation of proposed next-generation Data-warehousesolution on the criterion approved by the Bank (Hardware, Network,Applications, support Services etc.).m) PMO services for implementation phases of next generation Datawarehouse solution (Hardware, Network, Applications, support Servicesetc.).OEM consultation and onsite availability for ownership and integrityof the solution.n) Functional specifications as mentioned in PART-53.3.2 Consultant will be required to make discussions / meetings / presentations/ demos/ workshops / trainings to different groups of Business users / committees /technical teams as and when required by the Bank at its (Bank’s) Mumbai andCBD Belapur (Navi Mumbai) Offices.3.4Eligibility Criteria (As on the date of commencement of inspection/Sale ofRFP i.e. 27/05/2020)3.4.1 Eligibility Criteria for the Bidder –a) Bidder must be a registered company in India as per Companies Act 1956 / 2013and in existence in business in India at least for the last 5 years from RFP date.(The Certificate of Incorporation issued by Registrar of Companies alongwith the copies of Memorandum and Articles of Association are requiredto be submitted along with the technical bid.)(In case Bidder is a novated / separated entity, the Registration /Existence Period / Experience / Purchase Orders etc if any in the nameof its earlier companies will not be considered for eligibility andTechnical Parameter Marks.) Confidential & ProprietaryPage 11 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1b) The Bidder must have minimum annual Turnover of Rs.50 Crores from IndianOperations (not inclusive of turnover of associate companies) for each of the lastthree (3) financial years (FY 2016-17, 2017-18, 2018-19).c) The Bidder should have net profits (after tax) from Indian Operations duringeach of the last three financial years (FY 2016-17, 2017-18, 2018-19)(Certified / Audited Balance Sheets and P&L statements for last 3 yearsshould be submitted in support of the turnover and profitability. Acertificate of Statutory Auditor certifying Turnover and Net Profit (afterTax) for all three years must also be submitted.)d) The Auditor/ Firm/ Company/LLP or its group company / subsidiary company /holding company /affiliate /associate company / partner of bidder should nothave been black listed and/ or banned and / or barred and / or disqualifiedand /or prohibited by SEBI and /or RBI and /or NCLT and / or NCLAT and /or any court of law and / or quasi-judicial authority and / or any other statutoryand / or regulatory authority.(A self-declaration letter by the Bidder, on the Company’s letterheadshould be submitted along with technical bid.)e) The Bidder should have an office registered in India and support office inMumbai.(List of registered office / support offices with full details of Name, Address/ Telephone Numbers with escalation matrix should be attached.)f) Bidder should be in consultancy services in India / outside India as mentionedbelow, for last five years from RFP date independently having proven expertisein the field of offering the consultancy relating to –Mandatory in 03 areas in India for the Bidder : (1) Banking and FinancialServices (2) Enterprise Data warehousing & CRM implementation (3) DataMining & AnalyticsAndMandatory Atleast in Eight areas out of following 11 areas in India / outsideIndia for the Bidder and / or Consortium Partner : (1) Frauds and Analytics &Prevention (2) Forecasts & Predictions, (3) Artificial Intelligence (AI) (4) MachineLearning (ML) (5) Robotic Process Automation (RPA) (6) Decision SupportSystems (DSS) (7) Business Intelligence (BI) (8) Data Protection (9) InformationSecurity (10) Hardware Infrastructure sizing (11) Network sizing. Confidential & ProprietaryPage 12 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1g) Bidder should have during last 10 years from RFP date, provided or providingfollowing consultancy services in areas as per the scope of this RFP in atleastin one Public / Private Sector Bank / Financial Services in India / outside Indiaas mentioned below, having at least 1 Crore and above active Customer baseand a business mix (Deposits & Advances) of minimum INR 1 Lakh crore for FY2018-19.Mandatory in 03 areas in India for the Bidder: (1) Banking and FinancialServices (2) Enterprise Data warehousing & CRM implementation (3) DataMining & Analytics.AndMandatory Atleast in Eight areas out of following 11 areas in India / outsideIndia for the Bidder and / or Consortium Partner : (1) Frauds and Analytics& Prevention (2) Forecasts & Predictions, (3) Artificial Intelligence (AI) (4)Machine Learning (ML) (5) Robotic Process Automation (RPA) (6) DecisionSupport Systems (DSS) (7) Business Intelligence (BI) (8) Data Protection (9)Information Security (10) Hardware Infrastructure sizing (11) Network sizing .(Bidder should submit proof of consultancy along with Purchase Ordersand letter / E-mails (**) from user organization mentioning successfulconsultancy in above mentioned areas for Datawarehouse, their customerbase & business mix. POCs done will not be treated as experience of theBidder.)(** E-mail through corporate mail of the user organization from head oftheir department authorized to send email. Bank may use its channels /visit / clarifications from the bidder / user organisation to ensure authorityof such emails.)(Bidder may submit their client's Annual Report / Balance Sheet publishedon client's website instead of client's letter, as a proof of client's customerbase & business mix. The submitted documents should clearly spell-outfulfillment of the eligibility criteria requirements.)h) The bidder should have capability to execute the work under this RFP in Indiaas mentioned below, with respect to expertise in terms of (i) Skilled manpower,(ii) Experience & past performance, relating to –Mandatory in following 14 areas in India :For the Bidder : (1) Banking and Financial Services (2) Enterprise Datawarehousing & CRM implementation (3) Data Mining & AnalyticsFor the Bidder and / or Consortium Partner : (4) Frauds and Analytics &Prevention (5) Forecasts & Predictions, (6) Artificial Intelligence (AI) (7) MachineLearning (ML) (8) Robotic Process Automation (RPA) (9) Decision Support Confidential & ProprietaryPage 13 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1Systems (DSS) (10) Business Intelligence (BI) (11) Data Protection (12)Information Security (13) Hardware Infrastructure sizing (14) Network sizing.(The experience certificates, list of manpower with area of their expertiseto be provided.)i) The bidder should have in-house capability in India as mentioned below, to takeup assignment on their own but not through any associates relating to –Mandatory in following 14 areas in India :For the Bidder : (1) Banking and Financial Services (2) Enterprise Datawarehousing & CRM implementation (3) Data Mining & AnalyticsFor the Bidder and / or Consortium Partner : (4) Frauds and Analytics &Prevention (5) Forecasts & Predictions, (6) Artificial Intelligence (AI) (7) MachineLearning (ML) (8) Robotic Process Automation (RPA) (9) Decision SupportSystems (DSS) (10) Business Intelligence (BI) (11) Data Protection (12)Information Security (13) Hardware Infrastructure sizing (14) Network sizing.However, over and above their own staff on roll, Bidder may engagesubject matter experts to handle project related work and such expertsshould be available till completion of the consultancy contract.(Provide self-declaration letter)j) TEAM LEADERs on-site should have minimum 10 years’ of experience inconsultancy services and successfully lead & completed minimum 1 consultancyproject in the Bank / Financial Services in India for –Mandatory in following 14 areas in India :For the Bidder : (1) Banking and Financial Services (2) Enterprise Datawarehousing & CRM implementation (3) Data Mining & AnalyticsFor the Bidder and / or Consortium Partner : (4) Frauds and Analytics &Prevention (5) Forecasts & Predictions, (6) Artificial Intelligence (AI) (7) MachineLearning (ML) (8) Robotic Process Automation (RPA) (9) Decision SupportSystems (DSS) (10) Business Intelligence (BI) (11) Data Protection (12)Information Security (13) Hardware Infrastructure sizing (14) Network sizing.(CV of Team Leaders with testimony / reference letters)k) Minimum 75% of the key persons proposed to be deployed on-site should haveminimum 2 years consultancy experience in India for –Mandatory in following 14 areas in India :For the Bidder : (1) Banking and Financial Services (2) Enterprise Datawarehousing & CRM implementation (3) Data Mining & Analytics Confidential & ProprietaryPage 14 of 100

RFP for Consultant Services for DatawarehouseRe-Tender-1For the Bidder and / or Consortium Partner : (4) Frauds and Analytics &Prevention (5) Forecasts & Predictions, (6) Artificial Intelligence (AI) (7) MachineLearning (ML) (8) Robotic Process Automation (RPA) (9) Decision SupportSystems (DSS) (10) Business Intelligence (BI) (11) Data Protection (12)Information Security (13) Hardware Infrastructure sizing (14) Network sizing.(CV of key persons with testimony / reference letters)l) The Bidder should not be in the business of software , hardware solution provider/ product OEM (Provide Self-Declaration letter)(The

Capture , Master Data Management , Meta Data Management , Data Quality, Business Intelligence Tool, Performance Monitoring Tool , XBRL (eXtensible Business Reporting Language),Data Mining Tool solutions. 3.1.3 DWH is using Oracle Exadata platform, EDW-OCRM, SAP Business Objects, OFSAA, Oracle Data Miner, PL-SQL for its day-to-day operations.