Ingeniería de Software Bancario Improves Santander Brasil’s Data Warehouse Performance by 40% with 140% Increase in Data
 
 

Ingeniería de Software Bancario Improves Santander Brasil’s Data Warehouse Performance by 40% with 140% Increase in Data

Printer View Printer View

Ingeniería de Software Bancario (Isban, or Banking Software Engineering), part of the Grupo Santander (Santander Group), is responsible for defining the IT architecture for the group’s companies, developing IT projects, maintaining and supporting systems in production. Santander Brasil, which is served by Isban, completed its integration with Banco Real this year. Banco Real accounts for 25% of Grupo Santander’s revenue.

 
 

 
 

Challenges

A word from Ingeniería de Software Bancario (Isban)

  • "With our Oracle Exadata Database Machine architecture, we increased our data volume by 140%, gained 30% in storage space with data compression, and reduced backup time by 90%." – Marcelo Miranda de Souza Pinto, CRM and Management Information Systems Superintendent, Ingeniería de Software Bancario (Isban)

  • Integrate Santander Bank’s IT technological environment with Banco Real bank—the latter of which was the third-largest private Brazilian bank in terms of assets
  • Improve IT performance to offer high-level customer service with the incorporation of Banco Real’s data volume
  • Maintain the bank’s competitiveness in the retail and wholesale markets while meeting the requests of regulatory bodies
  • Develop Banco Real’s competitive advantages in Santander’s banking systems
  • Consolidate various data warehouses and calculation engines used by the controller’s, marketing, and finance departments to further improve the service levels beyond that delivered before incorporating the new bank

Solutions

Oracle Product and Services

  • Worked with Oracle Consulting to adopt Oracle Exadata Database Machine to absorb a 140% increase in data volume for Santander Bank—including client, product, contract, transaction, insurance, and bank card information transferred from Banco Real
  • Migrated twenty environments in five departmental data warehouses in under three months to a single environment that handles daily marketing actions, verification of financial results and analyzes products, channels, and segments, reducing the demand for physical space, energy, and lowering maintenance costs
  • Reduced backup times by 90%, enabling daily backups, increasing reliability for the business, and providing more efficient system resource use
  • Achieved environmental stability and improved performance up to 260% with no additional tuning
  • Reduced the time it takes to generate the management group’s monthly reports by 83%, from 36 hours to 6 hours, and reduced the time to generate client position reports by 45%, from 9 hours to 5 hours
  • Achieved an average reduction of 30% in allocated storage and up to 90% compression in certain cases using Oracle Advanced Compression, providing for more efficient usage of storage by compressing 100 terabytes into 70 terabytes and thereby freeing extra capacity to support the company’s organic growth and infrastructure needs of future projects
  • Used Oracle Database,11g Enterprise Edition with Real Application Clusters to improve management and infrastructure monitoring, saving time and money invested in these processes
  • Won the Oracle OpenWorld 2010 success case award for Isban
  • Installed and configured Oracle Exadata Database Machine with help from Oracle Advanced Customer Support Services, especially enhanced to serve the bank’s needs, helping to achieve the objectives of high availability, scalability, and performance for an around-the-clock applications environment

Resources