Oracle Customer Success—Ministry of Labor and Social Affairs

Qatar Ministry of Labor and Social Affairs Builds Highly Efficient Business Intelligence Platform to Support Ambitious Labor Market Policies

MOLSA needed a comprehensive, reliable, cost-effective, and up-to-date system for its labor market observation initiative. The Oracle Engineered Systems platform helps decision makers plan and organize the Qatari labor market by combining a high performing data warehouse with a wide spectrum of business intelligence tasks—from predictive analysis to near real-time strategic and tactical decision support.

— Mona Al-Fadhli, Project Manager and Assistant Director, IT Department, Ministry of Labor and Social Affairs

The Ministry of Labor and Social Affairs (MOLSA) builds and develops Qatar’s labor market by efficiently utilizing the national productive workforce and bringing in skilled expatriate resources. The ministry provides advanced labor market services and leads the field of comprehensive social welfare and development for all segments of Qatari society. MOLSA is currently sponsoring a 5-year nationwide plan for labor market observation. The project’s scope includes analyzing the development of Qatari citizens’ qualifications and recommending where citizens should be employed. The labor market observation plan continues until 2016 and is part of the 2030 Qatar National Vision which serves as the country’s roadmap to the future.

Business Challenge

Address high demand for specialized manpower by consolidating employment data from various public sector organizations and creating a single source of truth for analyzing employment trends and designing targeted labor market policies
Build more efficient business intelligence tools to help identify economic challenges related to unemployment, re-employment of downsized workers, the increased need for career guidance and counseling, and other labor market challenges

Identify upcoming manpower requirements of Qatari enterprises and public sector organizations, compare the outcomes of Qatar’s educational system with labor market needs, and guide Qatari graduates to prepare for job readiness
Ensure user satisfaction and buy-in with regard to the new platform by enabling labor policy makers to access queries and reports within an agreed service level of two seconds-despite integrating data from multiple source systems in real time

Launched a nationwide project for labor market observation using Oracle Data Integrator to collect labor statistics, unemployment data, and other labor market related information from various public sector organizations and rapidly consolidate data via extract-transform-load (ETL) processes
Established a single source of truth on Oracle Exadata Database Machine to store and analyze labor market information, enabling labor policy decision-makers to base strategies on real data and enact policies to address skill shortages

Used Oracle Business Intelligence Foundation Suite to deliver intelligence dashboards, ad-hoc analyses, scorecards, and predictive analytics to MOLSA users, providing them with personalized views according to business needs
Enabled users and stakeholders to access labor market reports from 10 source systems within a guaranteed service level of two seconds, using Oracle Exalytics In-Memory Machine’s extreme performance for analytical workloads
Used Oracle Real Application Clusters to ensure high availability of labor market data for queries and analysis, and to create an easily scalable computing environment to meet scheduled growth as further information sources are identified
Reduced database administration efforts by using Oracle Diagnostics Pack and Oracle Tuning Pack to automatically diagnose and optimize database performance
Leveraged the end-to-end integration of Oracle’s engineered systems to ensure that quantitative and qualitative information on skill shortages and labor supply and demand trends are efficiently collected, analyzed and disseminated—thus supporting MOLSA’s ambitious labor market policies and programs
Minimized licensing costs with Oracle Exadata’s pay-as-you-grow licensing model based on the number of multi-core processors that can run Oracle software
Minimized deployment time by working with Oracle Advanced Customer Support (ACS) to install and configure Oracle Exalytics In-Memory Machine and Oracle Exadata Database Machine for data warehousing—meeting MOLSA’s service level commitments and ensuring a successful go-live

Why They Chose Oracle

“Oracle Data Integrator is the perfect ETL tool to achieve the complex task of extracting labor data from heterogeneous sources and organizations, transforming the different formats of those data, and loading them into Oracle Exadata to rapidly generate labor market analytics,” said Amina Ahmed Abdullah, Senior Business Intelligence Developer, Ministry of Labor and Social Affairs.

MOLSA has been using Oracle products and services for many years and we have very knowledgeable Oracle staff in-house. We chose Oracle Exadata and Oracle Exalytics because they are designed to work together, drastically boosting performance and reducing deployment times. The availability of Oracle ACS engineers to provide knowledge transfer sessions and performance-tuning workshops—supporting our staff in gaining engineered systems expertise—was also a key factor in our decision.

— Ahmad Mohamed Taher, Technical Team Leader, Ministry of Labor and Social Affairs

Execution

“We have established a single source of truth on Oracle Exadata to store and analyze labor market information. This way, we enable the ministry’s labor policy decision-makers to base strategies on real data and enact policies to successfully address skill shortages,” said Fahad Azhary, Oracle Exadata Database Machine administrator, Ministry of Labor and Social Affairs.

“We used Oracle Business Intelligence Foundation Suite to deliver intelligence dashboards, ad-hoc analyses, scorecards, and predictive analytics to MOLSA users and provide them with personalized views according to their respective business needs,” said Sara Sultan Al-Mohanedi, senior business intelligence developer, Ministry of Labor and Social Affairs.

About Ministry of Labor and Social Affairs

Headquarters

Doha, Qatar

Ministry of Labor and Social Affairs

Partners

Oracle Platinum Partner Mannai Trading Company, together with Oracle Advanced Customer Support, staged several workshops with MOLSA. Mannai demonstrated that by using Oracle Exalytics the ministry would be capable of meeting the required service level for accessing business intelligence reports and dashboards, and also conducted several training workshops with the ministry’s key users. Mannai implemented the solution to specification, and continues to support it.