Secretaría General de Administración de Justicia en España Enhances Citizen Services with Near-Real-Time Business Intelligence Gleaned from 500 Databases
 
Oracle 1-800-633-0738
Find an Oracle Specialized Partner
Oracle Customer Programs
 
 

Secretaría General de Administración de Justicia en España Enhances Citizen Services with Near-Real-Time Business Intelligence Gleaned from 500 Databases

Secretaría General de Administración de Justicia en España (Spain General Secretariat for Justice Administration), part of Spain’s Ministry of Justice, is the body responsible for managing and executing the Spanish government’s justice policies. It oversees executing national law across the country’s 23 provincial offices, while coordinating funding and procurement for tribunals, magistrate courts, and prosecutor’s offices. The organization is responsible for managing staff involved in the justice system, including court clerks, public prosecutors, procedural intermediates, and administrative personnel.

Secretaría General de Administración de Justicia en España also maintains a central registry of its activities and allocates resources based on various jurisdictional needs, which fluctuate based on types of crime, crime rates, and seasonality. The organization’s IT branch, the new technologies subdirectorate, supports the registry and other centralized data as well as provincial offices and court houses across the country. It collects and archives data from all jurisdictions, providing decision-makers with the tools needed to analyze resource allocation and program efficiency.

 
 

 
 

Challenges

A word from Secretaría General de Administración de Justicia en España

  • “Oracle Business Intelligence improved the ministry’s decision-making at three levels—administrative, executive, and for IT—to achieve the same insight and efficiency as a private corporation. Since switching from SAP BusinessObjects, we’ve improved our citizen services by optimally allocating human resources and funds, analyzing the effectiveness of new IT projects and initiatives, and recommending viable legislation changes.” – Angelines Turón, director of the new technologies subdirectorate, Secretaría General de Administración de Justicia en España

  • Improve efficiency of human resources and for funds allocation by enabling the ministry to intelligently analyze data related to criminal and civil procedures from more than 23 autonomous provincial jurisdictions
  • Reduce time and resources spent generating manual, labor-intensive and nonstandardized business intelligence reports, such as staff assignments and regional criminal trends
  • Implement analysis tools that ensure data quality, reliability, and timeliness to track justice procedures as well as crime rates, types, occurrences, and trends, from civil and criminal court records nationwide
  • Integrate with the Justice Administrion’s existing e-justice systems to enable information exchange between public entities, as well as to provide a secure, efficient online system to eliminate document transit times for barristers, magistrates, lawyers, and judges
  • Provide an analytical basis for evaluating new IT projects and initiatives, administrative procedures, and supplier relationships to optimize human resources and fund allocations and to improve efficiency
  • Connect heterogeneous information stored in geographically-disparate systems to ensure coherent data analysis

Solutions

  • Achieved enterprise-class efficiency by analyzing more than 500 databases with more than 16 billion rows and 4 terabytes of data, including civil and criminal records and trends, to optimally allocate resources, such as funds, barristers, and judges to each jurisdiction
  • Implemented a system for more than 100-million authenticated, online communications and notifications annually between more than 5,000 barristers, magistrates, lawyers, and judges, avoiding the need for in-person document delivery
  • Benchmarked court performance to establish wages and bonuses proportional to staff output, and shared the analysis with judges to enable them to proactively improve their practices
  • Optimized and centralized records from all jurisdictions in Spain’s 50 provinces and made the analysis available to the ministry’s administrative, executive, and IT levels through dashboards updated every 24 hours
  • Enabled the ministry to adapt rapidly to legislative changes that affect business operations
  • Improved business efficiency by embedding Oracle Business Intelligence in all new IT projects and initiatives to evaluate their feasibility, viability, and cost effectiveness

Why Oracle

Secretaría General de Administración de Justicia en España previously employed underperforming dashboards to analyze unreliable data related to its activities.

“Together with our procurement department, we evaluated different options to replace our SAP BusinessObjects dashboards, which we found less than satisfactory. We fell in love with Oracle Business Intelligence when we ran initial tests. It provides the agility, robustness, and efficient business intelligence analysis that we need,” said Angelines Turón, director of the new technologies subdirectorate, Secretaría General de Administración de Justicia en España

Implementation Process

The new technologies subdirectorate of the Justice Administration worked with Oracle Consulting to analyze its needs and develop a standardized, administrationwide solution to replace its legacy data analysis tools, including SAP BusinessObjects and Microsoft Excel. Oracle Consulting became a trusted partner, ensuring the success of the subdirectorate’s business intelligence (BI) project during pre-implementation analysis and solution design. Oracle Consulting established the correct methodology, standardization processes, and best practices required to achieve a full scale BI solution. It also designed and built optimized-BI models in less than three months and ensured a high-quality development and implementation process through audits and periodical performance reports. 

Today, Oracle Business Intelligence and Oracle Consulting play key roles in helping the administration enhance information transparency and accessibility for more users, support intelligent decision-making processes, standardize BI solutions, ensure interoperability across different departments, and promote innovation and modernization through new technology use.

Two to eight team members from Oracle Consulting have been involved in this growing project that continues to add new elements, functions, and dashboards to help the new technologies subdirectorate further improve its efficiency.