Risk Management

and Regulatory
Compliance
Bank of the Philippine Island (BPI)

CHAPTER 4: Planning and

Project Management
 OBJECTIVES

Identify BPI’s data warehouse for better risk and compliance support.
Explain the importance of risk management and regulatory compliance in banking and
finance.
Create a clear project plan that defines the goals, timeline, and resources needed for the
data warehouse project.
Follow the proper development phases such as planning, designing, building, and testing to
ensure the system works effectively.
Recognize the roles of a strong project team composed of IT professionals, data
specialists, and compliance officers who will work together throughout the project.
Identify modern tools and current trends in data warehousing to improve data
management, reporting, and decision-making in banking.
 PLANNING THE WAREHOUSE

1. Introduction/ Overview
Bank of the Philippine Islands needs a centralized data warehouse to unify its
financial and operational data, ensuring accurate, timely, and transparent reporting in line
with Bangko Sentral ng Pilipinas 2026 requirements. This enables consistent analytics,
real-time risk monitoring, fraud detection, and supports its expanding digital and
“phygital” services.

2. Value and Expectations

Bank of the Philippine Islands uses Azure Synapse Analytics to centralize banking
data from core systems, digital platforms, ATMs, and customer records, enabling real-
time dashboards and improved risk and fraud detection.
Cloud data warehouses provide scalability, cost efficiency, fast deployment, and high-
performance analytics for better data management.
A unified cloud platform supports regulatory reporting, integrates data across
operations, and enables more informed, data-driven decision-making.
 PLANNING THE WAREHOUSE

3. Risk Management
Potential Risks
Bank of the Philippine Islands may face regulatory compliance, data privacy,
cybersecurity, and data migration/integration risks when using Azure Synapse
Analytics.
Mitigation Strategies
These risks can be reduced through strong data governance, strict security
controls, phased data migration, and continuous monitoring and auditing.

4. Implementation Approach
Bottom-up approach using Azure Synapse Analytics is practical and efficient
Focus on key areas first: transactions, financial reporting, risk analysis
Enables faster results and early value delivery
Allows gradual expansion into a full data warehouse system
 PLANNING THE WAREHOUSE

5. Build or Buy Decision

Hybrid approach is the most practical solution
6. Vendor Strategy
Single-vendor strategy using Azure Synapse Analytics
It simplifies integration and data governance
Leverages Azure’s built-in services for data storage, processing, and analytics
Enables efficient data warehouse management with strong security and
compliance
7. Business Requirement Driven Design
Focus on business needs, not just technology
Key reports: financial statements, loan summaries, transaction trends, risk
assessments
KPIs: loan approval times, transaction volumes, credit risk scores, customer retention
Departmental analytics: finance, risk, retail banking, digital banking
 PLANNING THE WAREHOUSE

8. Top Management Support

Executive support is critical for BPI to avoid delays, misalignment, or project failure
Strong leadership ensures coordination across departments, enforcement of
governance, and delivery of actionable insights

9. Conclusion
Implementing a data warehouse with Azure Synapse Analytics enhances decision-
making, efficiency, and compliance for Bank of the Philippine Islands
Focus on business needs, use bottom-up and hybrid approaches, and ensure
executive support
Apply strong data governance and a single-vendor strategy to reduce complexity
Leverage advanced analytics and AI for timely insights, better customer service, and
strategic growth
 DATA WAREHOUSE
PROJECT

INTRODUCTION
Data Warehouse Project of Bank of the Philippine Islands (BPI)
Using Azure Synapse Analytics
BPI uses a data warehouse to manage large banking data.
Helps in analyzing transactions and operations
Supports better and faster decision making

INTEGRATION ACROSS BANKING OPERATIONS BENEFITS OF INTEGRATION

Data from: Mas mabilis na data processing
Customer transactions Better understanding of customers
Digital banking platforms Improved financial performance analysis
Branch services Support data-driven decisions
Financial reporting
 DATA WAREHOUSE
PROJECT

COMPARISON WITH OTHER BANKS

Other banks: separate systems
Slower data analysis and reporting
BPI: integrated system + analytics
Uses mobile banking & “phygital” approach

ASSESSMENT OF READINESS
3 Key Areas:
Technical Readiness- system compatibility
Operational Readiness -trained staff & processes
Business Readiness -aligned with company goals
Result: lower risk, higher success
DATA WAREHOUSE
PROJECT
PROJECT TIMELINE OVERVIEW
Total duration: 12 months
Divided into 7 phases
Step-by-step implementation
PROJECT PHASES
Planning
Requirements Gathering
System & Data Design
Data Development
Testing & Validation
Implementation &
Deployment
Monitoring and Optimization
TIMELINE
Start: planning and data needs
Middle: system design & development
End: testing, deployment, improvement
Ensures organized workflow
DATA WAREHOUSE
PROJECT

BUDGET OVERVIEW
Total Budget: ₱23,520,000
Covers system development and
operations

BUDGET ALLOCATION
Development & Personnel (largest)
Cloud Infrastructure
Data Integration & ETL
Storage & Backup

OTHER COSTS
Security & Compliance
Training & Change Management
Maintenance & Support
Ensures long-term system use
 DEVELOPMENT PHASES

[Link]
 DEVELOPMENT PHASES

INITIATION PHASE

Define the main purpose of the project

Identify key stakeholders
Evaluate regulatory requirements from the Bangko Sentral ng
Pilipinas (BSP) and the Data Privacy Act of 2012 to ensure the
project supports compliance reporting.
Assess the feasibility of integrating data from BPI’s core banking
systems, loan management systems, credit card systems, and
digital banking platforms into a single data warehouse.
 DEVELOPMENT PHASES

PLANNING PHASE
Evaluate regulatory requirements from the Bangko Sentral ng
Pilipinas (BSP) and the Data Privacy Act of 2012 to ensure the
project supports compliance reporting.
Identify the key data sources that will feed the warehouse
Identify modern technologies to be used, such as cloud-based
data platforms, AI-driven analytics tools, and business
intelligence dashboards.
 DEVELOPMENT PHASES

EXECUTION PHASE
Design and implement the data warehouse architecture capable
of handling large volumes of banking data.
Build ETL (Extract, Transform, Load) pipelines to collect and
transform data from BPI’s internal banking systems into the
centralized warehouse.
Conduct training sessions for BPI staff, including risk analysts and
compliance officers, to ensure proper system usage.
 DEVELOPMENT PHASES

MONITORING AND CONTROLLING PHASE

Monitor project progress to ensure the system is delivered within
the approved timeline, budget, and scope.
Continuously review risk indicators, such as fraud alerts,
suspicious transactions, and credit exposure levels.
Address technical issues and incorporate stakeholder feedback
to improve system performance.
 DEVELOPMENT PHASES

CLOSING PHASE
Finalize the deployment of the BPI Data Warehouse System and
ensure that it is fully operational.
Transition the system to maintenance and support teams for
continuous monitoring and updates.
Conduct a post-implementation review to evaluate whether the
system successfully improved
 PROJECT TEAM

Risk Management Officer

- Protect the bank from losing money or getting into trouble.

Compliance Officer
- Checks if everything the bank does is legal and correct

IT Professional
- Make sure systems are secure, updated, and working properly.

Data Specialist
- Ensure data is accurate, secure, and used properly.
 PROJECT MANAGEMENT
CONSIDERATIONS

To ensure safe and reliable banking operations,

Bank of the Philippine Islands (BPI) developed
strong governance through compliance, risk
management, and internal control systems.

1. Compliance Management

2. Risk Management

3. Internal Control and Audit

 LATEST TRENDS

Advanced Data Analytics and

Risk Modelling
Environmental and
Sustainable Risk
Management
Enterprise Risk Management
 Thank You
Presented by :
GROUP 6

Ginyard International Co.