Visitor Management System - Full Stack Automation
Designed and built a full-stack visitor management system using Power Apps, Python (FastAPI), MySQL, and Power BI.
Replaced manual workflows and an external system with an automated, real-time solution featuring QR-based check-in/out and mobile HSE roll-call visibility.
Challenge
The existing visitor management process relied on an external system (Raptor) and manual workflows, resulting in limited visibility, inconsistent data, and inefficient operations.
Users were required to navigate multiple steps to access visitor lists, and the lack of automation led to frequent missed check-outs, impacting accuracy during emergency roll-call scenarios.
Results
The new system streamlined visitor operations, reducing manual steps and improving accuracy through automated check-in and QR-based checkout.
Real-time visibility significantly enhanced HSE roll-call capabilities, while the removal of an external system eliminated recurring costs and enabled full internal ownership.
5+ → 1
Manual Steps Reduced
$1,000/year
Cost Savings
100%
Real-Time Tracking
Process
Power Apps (Frontend)
Provides kiosk-based interface for visitor check-in and data entry
Python API (FastAPI)
Handles check-in/check-out logic and QR code generation
Processes all system transactions in real time
MySQL (Database)
Stores structured visitor and visit data
Maintains accurate, timestamp-based records
Python Sync (Data Pipeline)
Transfers data from MySQL to SharePoint for reporting
Enables automated updates without manual intervention
SharePoint (Cloud Layer)
Serves as a centralized, accessible data source
Allows seamless integration with Power BI
Power BI (Reporting)
Provides real-time dashboards and HSE roll-call view
Enables mobile-friendly access to active visitor data
Conclusion
This project transformed a manual, multi-step visitor process into a streamlined, automated system.
By combining Python, SQL, and Power Platform tools, the solution improved efficiency, reduced cost, and enabled real-time operational visibility, while creating a foundation for future automation and data-driven solutions.
