Skip to main content
Preparation and
Planning
(Month 1)
• Report Objects Prioritization
• Program prioritization
• Hardware install
• IT Resource /Professional services staffing
• Procure software
• Data Modelling
ETL (Month 1
• ETL Requirement Analysis
• ETL Design
• ETL Development
• ETL Testing
Initial Wave
(Month 2-3)
• Metadata Framework Configuration
• Data Governance setup
• Report catalogue reduction – group 1
• Training and Education
• Design Cognos Workspace
Second Sprint
Build
(Month 4-10)
• Report catalogue reduction – group 2
• Incremental deployments
• Data Library build
• Workspace deploy: (Dashboards, Alert, Reports, Scorecards)
• Head count savings in effect
• Training and Education
Ongoing Build
(Operational)
(11 months+)
• Target new data sources
• Report catalogue reduction – group 3
• New requirements
• Head count savings continue
• Continue Workspace build and rollouts
• Part of regular “operations” process and prioritization
Proposed Timelines
Implementation Plan
1
Privileged and All Rights Reserved
1.Digital
Services
Enterprise & Mobility
Microservices
Design Engineering
Digital Strategy
Intelligent Process
Automation
1.Data &
Analytics
Data Science
Enterprise Data
Warehouse &
Business Reporting
Big Data
Advanced Analytics
Data Engineering
Artificial Intelligence
& Machine Learning
Deep Learning
1.Cloud
Cloud Migration
CloudDevelopment
CloudStrategy
CloudOptimization
Infrastructure
Engineering
1.IT Consulting
Agile
DevOps
Core Modernization
System Integration
Quality Engineering
and Assurance
Team Structure & Governance Model
Onsite
Integration architect
Developer
Business analyst
SolutionArchitect
Client Partner
Program Manager
NIB
IT Manager
Project Lead
Business users
Solution Architect
SMEs
Product Owner
Monthly
Review
Weekly
Review
Daily
standups
Steering
Committee
(Strategic)
Project
Delivery
(Operational)
PMO
(Tactical)
Offshore
Delivery Director
Project/Delivery
Manager
Tech leads
Developers
Testers
Business analyst
Scrum master
Communication Offshore / Near-shore Onsite NIB
BI
Data Management In-
House, hence full control of
data
Data Presentation over
cloud provides BI on the go
Most Cost effective with
better TCO
Easy Lift & Shift Migration to
Azure BI
Leverage existing
infrastructure - MS SQL
server and in-house team
Data Management In-
House, hence full control of
data
Data Presentation over
cloud provides BI on the go
Most Cost effective with
better TCO
Easy Lift & Shift Migration to
Azure BI
Leverage existing
infrastructure - MS SQL
server and in-house team
Data Management In-
House, hence full control of
data
Data Presentation over
cloud provides BI on the go
Most Cost effective with
better TCO
Easy Lift & Shift Migration to
Azure BI
Leverage existing
infrastructure - MS SQL
server and in-house team
1. Self Service BI -
Interactivity
2. Data Consolidation in
DWH – Single Source of
truth
3. Visualization – Enhanced
Dashboarding
4. Mobility – BI on the go
5. MS Office Integration –
Multi Consumption Mode
Data Integration Approach For DW/DM & Reporting
IDENTIFY DESIGN
TRANSFORMAT
ION
VALIDATION LOAD Reporting
Understand the available
data sources
Data analysis
Work on the Entity
Relationship between
different entities
KEY ACTIVITIES
Data Normalization across
systems.
Work on creation and
design of Target .
Design Dimension models.
Identify the Data Mapping
and Transformation Rules
across different source
instances.
Extract the data from
the source systems
Apply the
transformation rules
identified
Import the
transformed data into
Staging Area
Validation of Dataset in
Staging/landing Area
Validate the data in DM
Refine the Dataset
Import of data from
Staging/landing Area
into Data warehouse
/Data Mart Instance
Validation of Data on
Target Instance
OUTCOME
Ensure completeness
and correctness of data
Availability of Clean,
Business confirmed
data in Staging Area
Transformed Data
available on Staging
Data Mapping and
Transformation Rules
Reconciliation and error
handling mechanism
Identify data integration
needs
Prepare Detailed
development Plan
TEAM
RESPONSIBILITIES
Providing access to all the
Data Sources to capture
relevant Data
Validate the Data Model
Identify the attributes to
be captured for a
particular entity
Provide Business Rule/
Validation Rules
Help fix bad data
Provide data comparison
parameters to eliminate
the redundant data
Validate the dataset in
landing/staging
Provide Review
comments (if
applicable)
Validate the dataset in
DataMart
Build agreed
dashboard and
individual report
Dashboard and Reports
Validate the report
during UAT and
provide sign off.
Copyright Birlasoft 2019 6
12/14/2022
Project Manager
Solution
Architect T24Leads Sr. Technical
Consultants(Eficaz)
Technical
consultants
Developers
Sr. Technical
Consultants (DWH)
Technical
consultants
Developers
Sr. Technical
Consultant(ETL)
Technical
Consultant
Developers
Sr. TechnicalConsultants
(BusinessIntelligence)
Technical
Consultant
Developers
Sprint Development Plan
Go-Live Starting N Months
High Level
Plan
Project Initiation
Requirement Analysis
Design and Build
Track 1
Date
Date
Date
Date
Date
Date
Date Date
Testing
Go Live
Training & Support
ETL
UAT Test &
Deploy
Go-LIVE!
Reporting / Dashboard UAT Test & Deploy
Go-LIVE!
Training & Support
Delta Migration
Sprint 8
Sprint 7
Sprint 6
Sprint 5
Sprint 4
Sprint 3
Sprint 1 Sprint 2
Track 2
Track 3
Track 4
Track 5
Track 6
Date
Sprint 9
==>
==>
DW/ETL/Reporting & Analytics
Testing
Data Analytics Assessment & Recommendations - Program Roadmap
Requirement Analysis, Design & Pilot T24/Loan/BMC UAT/Production
Phase 1: Month 1 to Month 3 Phase 2: Month 4 to Month 6 Phase 3: Month 7 to Month 10
• Detail Requirement Gathering
• Analysis & Design
• Prepare BP and Specification document
• Platform Piloting
• Documentation
• Data Integration Build & Unit Testing
• Data Model Build and Unit Testing
• Reports, KPIs, & Dashboard
• Data ETL
• UAT
• Deployment
• Data Integration Build & Unit
Testing
• Data Model Build and Unit
Testing
• Reports, KPIs, & Dashboard
• SIP
• Data Migration
• UAT
• Deployment
BI Solution Architect –
Business Analysts
BI Developer
Core Team
Key
Activities
* Timelines are indicative
** This is for the Core Team and Flex Team will be determined on a need basis
Development Team
Testers
Implementation Team
BI Project Manager
Business Users & IT Analysts
NIB Team
* Timelines are indicative
8
** Post Phase 1, scope for phase 2 and phase 3 will be finalized
Alerts prompting for
Agency routing
Next Step
Recom. Engine
Queue Checks Best Action Inhouse
Agency
Triggers Agency route
Manage Performance
Due Diligence check on
data Landscape
Simone reports errors in
recommendations
Exploration-
Requirements
Analysis
Design & Build Confirms proposed or
Overrides action
Auto alerts, real time
update on cases
Reviews Agency
recommendations
for cases
Simone analyses his
EOD and EOM
performance
Simone works with KCB
Business teams to
adjust workflows
What Next ?
January-2023 Date Date
Exploration-Requirements & Design Sprint Development UAT
Go-Live, Training
& Support
▶ Backlog of epics, user stories
▶ Detailed use cases
▶ Functional requirements
▶ Technical requirements
▶ Data migration mapping
▶ System Design Document
▶ Interface Specs & Contracts
▶ Security Model
▶ Rollback plan
▶ Working Technical
environment
▶ Delivery schedule
▶ Identify data sources/format
▶ Business process mapping
▶ Identify Roles & Access
▶ Scope of work, Dependencies
and interfaces
▶ Understanding recovery
functions, workflows and rules.
▶ External agency functions
▶ Data design, mapping and
detailing of ETL procedures
▶ Configure Service Cloud and
Service Console
▶ Setup Data Model
▶ Model resources and
operations/methods
▶ Publish Interactive Console
▶ Auth design
Deliverables
Sprint 9
Activities
▶ Working unit and integration tested software
▶ Code compliant with KCB coding standards
▶ Delivery of the required operations manual
▶ Development and deployment of production monitors for the code written.
▶ Code reviews will be executed with both the suppliers’ senior developers (first) as well a
final review with KCB IT resources (last).
▶ Support UAT
▶ Fix Defects
▶ Defect Management
▶ Implement Test
Automation framework
▶ Automated tests
▶ Regression Testing
▶ Daily UAT Status
report
▶ Daily defect Log
▶ Troubleshooting, issue
triage and resolution
▶ Problem ticket
resolution
▶ Training catalogs-
module wise
▶ Knowledge transition to KCB
IT support
▶ Delivery of expedited
changes
▶ Operational manuals
▶ Training material
▶ Workshop for KCB
Acceptance Criteria
▶ KCB approved requirements in
Confluence, JIRA
▶ KCB approved design
▶ KCB approved schedule
▶ Deliverables built, unit and integration tested per acceptance criteria
▶ Code reviewed and approved by KCB IT
▶ UAT test cases execution
▶ Resolution of defects
▶ Deployment Support
▶ Post Impl. Support
Service Configuration
Data Migration Scripts
System integration
Delta Data
Migration
In-house Recovery
Reporting & Dashboard integration
Build
API/ETL
Integration
Service
Requests
Cust. Self
Serve
Date Date Date Date Date Date
Sprint 2 Sprint 3 Sprint 4 Sprint 5 Sprint 6 Sprint 7
Date
Sprint 1
Workflows & Assignments Build Custom codes
Training module creation, documentation and training
System Management
Sprint 8
rough-work.pptx