Developed a secure executive car booking system with SAML authentication, automated VP-ready reports, and real-time tracking, initially in Drupal and later rebuilt in Microsoft Power Apps with Power BI reporting after Drupal team support ended. Replaced paper and Excel workflows, cutting booking and reporting time by 60% while improving accuracy, security, and ease of use.
Project Overview
Challenges & Solutions
Challenges
Executive car booking was managed via paper forms and Excel sheets, causing delays, errors, and lack of visibility
No centralized system for booking requests, driver assignments, or trip tracking
Manual reporting process required reformatting before sharing with leadership
Needed an intuitive interface for non-technical executive assistants and administrative staff
Required strict security controls for executive travel information
Loss of Drupal team support necessitated a redevelopment in a supported, maintainable platform
Solutions
Initially developed a secure, web-based executive car booking system in Drupal to replace paper and Excel processes
Integrated SAML-based SSO for secure authentication and role-based access
Built an automated reporting module to generate VP-ready reports in the exact required format without manual editing
Enabled one-click report sharing via email directly from the application
Created workflows for booking requests, driver assignments, and confirmations with real-time status updates
When Drupal team support ended, redeveloped the entire system in Microsoft Power Apps with reporting transitioned to Power BI
Partnered with stakeholders, including executive assistants and facilities managers, to design a streamlined user interface for both versions
Worked with privacy and cybersecurity teams to ensure compliance with data handling for sensitive executive travel information