IT Systems Audit Dashboard

A comprehensive IT Systems Audit & Risk Assessment Dashboard built to simulate Deloitte ITDA CEC Analyst responsibilities.
This project demonstrates skills in SQL, risk analysis, access monitoring, anomaly detection, and compliance reporting using a full-stack application.

---

🚀 Project Overview

The IT Audit Dashboard enables organizations to:

• Monitor user access logs in real time
• Detect suspicious login attempts & violations
• Track privilege escalations
• Identify Segregation of Duties (SoD) conflicts
• Generate compliance scores and executive-level insights

This project is designed as a portfolio showcase for IT Audit, Risk & Compliance Analyst roles.

---

🛠️ Tech Stack

• Frontend: React (Interactive UI with responsive design)
• Backend: FastAPI (RESTful APIs, AI integration)
• Database: MongoDB (Audit logs, user data, risk metrics)
• Other: Python, Yarn, Node.js

---

📊 Key Features

• Real-time Access Monitoring – track logins, locations, and risk levels
• Violation Detection – highlight failed logins, suspicious activity, SoD conflicts
• SQL Query Engine – execute pre-built queries for audit analysis
• Risk Scoring – AI-powered anomaly detection with compliance percentage
• Executive Reporting – dashboard metrics for quick decision making

---

📂 Project Structure

. ├── backend/ # FastAPI backend, models, APIs ├── frontend/ # React frontend ├── tests/ # Test files ├── backend_test.py # Backend test script ├── test_result.md # Test results summary ├── README.md # Project documentation └── yarn.lock # Dependency lock file

---

🎯 Business Value

This dashboard helps IT Audit & Risk professionals:

• Automate compliance checks
• Identify high-risk users
• Streamline ITGC & ITAC testing
• Provide clear reporting for executives

---

📌 How to Use

1. Clone the repository
2. Install dependencies (yarn install for frontend, pip install -r requirements.txt for backend)
3. Start backend: uvicorn main:app --reload
4. Start frontend: yarn start
5. Access dashboard on http://localhost:3000

---

🔗 About

This project was created as part of my Data & IT Audit portfolio to showcase expertise in:

• SQL analysis
• Risk & compliance monitoring
• Dashboard design (Frontend + Backend)

---