Examination system

• Designed and built a comprehensive database from the ground up using Microsoft SQL Server, tailored specifically for the ITI Examination System.

• Crafted an intricate Entity-Relationship Diagram (ERD) and database mapping to meticulously model our database structure.

• Implemented robust system functionalities including stored procedures, functions, views, and set up 3 differentiated accounts with specific permissions to ensure data security and integrity.

• Developed a state-of-the-art data warehouse leveraging SSIS (SQL Server Integration Services) for efficient data integration and SSAS (SQL Server Analysis Services) for powerful multidimensional data analysis.

• Utilized SSRS (SQL Server Reporting Services) and Power BI to generate dynamic, insightful reports and dashboards, offering a deep dive into the data for informed decision-making.