Establishment of Advanced Analytics and Data Mining Platform for Social Security Institution

Project Title  17

Establishment of Advanced Analytics and Data Mining Platform for Social Security Institution

Name of legal entity

Country

Name of client

Origin of funding

Dates 

(start-end)

Name of consortium 

members, if any

BYS Grup

Türkiye

Central Bank of the Republic of Turkey

National (Republic of Türkiye)

COMPLETED

01.12. 2013 –

14.11. 2019

BYS Grup

Detailed description of project

Type and scope of services provided

 

The purpose of the assignment is to establish an analytics and data mining platform for Social Security Institution in Türkiye (SGK) to maintain the pension, health insurance, social security, audit, actuarial, health/public finance, medicine sector, hospitals related data handling operations and other statistical calculations, modelling, algorithms for the reform of the individually operated IT systems and providing SAS Licences to SSI. 

Conducting a workshop study throughout inspection practices with segmentation analysis for detection of anomalies in unregistered employment issues in Turkey. 

Carrying out an assignment under the advanced training of Risk Assessment manual which provides to the staff in order to make reports by using data mining process and data analysis on SAS software. 

The following trainings were conducted to SSI staff (Directorate for Actuary and Funds, Directorate General of Service Delivery, Directorate for Guidance and Inspection, Directorate General of Pension Services, Directorate General of Universal Health Insurance and Risk Analysis Departments): 

 

  1. SAS Enterprise Guide – Querying and Reporting  
  1. SAS Enterprise Guide – Advanced Task and Queries  
  1. SAS Enterprise Guide – ANOVA, Regression and Logistic Regression  
  1. SAS Enterprise Miner – Applied Analytics Using SAS Miner 
  1. SAS Programming, I 
  1. SAS Programming, II 
  1. SAS Admin User Training 
  • Identification of System requirements for Databases (ORACLE) 
  • Current Situation Analysis 
  • Identification of Target Groups 
  • Determination of Data Sources Review of Legislation, Strategic Plan and other existing documents  
  • Preparation of installation guideline  
  • Installation Requirement Analysis 
  • Identification of Software Standards, Programming Language, Development Tools  
  • Identification of Data Transfer Architecture (ETL) 
  • Formation of System Architecture and Design Document including technical recommendations 
  • Identification of New and Additional Software Needs 
  • Preparation of Management Process Document 
  • Development of SAS database and server architectures, 
  • Identification of user profiling  
  • Administration of the management console 
  • Installation and maintenance of SAS Office Analytics, Data Quality products 
  • Technical assistance and support services 
  • Trainings of Actuarial, Health, Insurance, M&E, Pension, Risk Analysis Departments  

     

Name/profile of main staff provided

Permanent staff

Number of months worked on the  
project

2 Senior Statistician  

Yes 

12 Months 

3 Senior Trainers  

Yes 

12 Months 

 

 

 

2 Junior Trainers 

Yes 

12 Months 

2 Senior Modelling Experts  

No 

3 Months 

1 Computer Engineer 

Yes 

6 Months