My Professional Projects

DSIS CNAS : Provision Of Services Component (08/2022-Present)

General Directorate of National Social Security Fund

This module involves constructing a decision support system to monitor the evolution of expenditures and costs, with 211 indicators collected to analyze the functional domain of service.


Tasks:
  • Develop and design OLAP cube using SSAS to support business analytics and improve decision-making.
  • Create interactive reports using Power BI to provide insights into key performance indicators (KPIs). Setup Power BI Report Server, SSRS, and Oracle Providers to meet the project requirements.
  • Create project backlogs, and user stories with Azure DevOps for sprint planning and execution.
  • Develop technical support documents for bug resolution and task-specific procedures (Up to 20 Validated documents)
Education Building

DSIS CNAS : Revenue And Recovery Component (12/2022 - 08/2023)

General Directorate of National Social Security Fund

This module involves building a decision support system to track the evolution of contributions and assess financial balance using more than 190 indicators collected to enhance decision-making.


Tasks:
  • Develop ETL processes using ORACLE for data extraction, transformation, and loading. Design and implement data cleansing, validation, and transformation logic to ensure data quality.
  • Create and schedule SSIS packages to automate data integration tasks and ensure timely data updates.
  • Configure monitoring and data security mechanisms utilizing Zabbix tool and automatic OLAP backup procedures.
  • Handle backups for vital CNAS databases using DORADO HUAWEI and DELL technologies.
Education Building

My Side Projects

In addition to my professional work, I enjoy taking on side projects that allow me to explore new skills, technologies, and creative solutions. These projects showcase my passion for continuous learning and innovation. If you find any of these initiatives interesting and would like to contribute, I’d be thrilled to collaborate and work together. Dive in to see some of the exciting and diverse initiatives I’ve been working on lately.