← Back to the portfolio

SIM Card Management System

SIM Card Management System is an internal business application built to replace fragmented spreadsheet-based management with a centralized workflow. I worked on the application during my software development internship, completing Phase 1 and building Phase 2. The system includes user and permission management, SIM and USB records, subscriptions, service providers, OTP handling, branches, VPN connections, device status, quotas, reporting, and automated email notifications for internet-line renewals. I also worked through issues such as soft-deleted entities being excluded from searches and improved existing systems as requirements changed. The application is hosted locally for internal use because it handles private company data.

Project .NET · Business Software

2Development phases

A project by Youssef Ehab Alsayed

Tools

C# ASP.NET Core MVC Entity Framework Core SQL Server Bootstrap HTML/CSS Git

Screenshots

Dashboard: active SIM and USB counts, weekly assignment activity, and employee directory (sample data)
Dashboard: active SIM and USB counts, weekly assignment activity, and employee directory (sample data)
Assignment flow: choose an employee or visitor, then a SIM and/or USB modem, with provider quota shown before activating the subscription
Assignment flow: choose an employee or visitor, then a SIM and/or USB modem, with provider quota shown before activating the subscription
Reports: filterable Excel exports for subscriptions, employees, devices, status history, branches, and VPN connections
Reports: filterable Excel exports for subscriptions, employees, devices, status history, branches, and VPN connections
Permissions: group-based, per-action access control (details hidden for security)
Permissions: group-based, per-action access control (details hidden for security)