Travel Management App
Utilizing Microsoft Power Apps environment, I created an internal travel management system that streamlined booking processes and communication between the traveler and the travel booker and facilitated automated reconciliation of expenses for booked tickets. The travel system is supported by extensive Power BI analysis of collected data to provide actionable insights for optimizing business travel experiences for employees.
Key Deliverables
- Internal application developed, including design, front-end development, as well as backend and data infrastructure.
- Python model capable of reconciliating expenses relating to travel into Dynamics365 system, supported by daily data feed of ECB exchange rates.
- Extensive Power BI analyses to deliver actionable insights and support Finance and Operation teams with daily operations
90%
Decrease in time needed to reconcile expenses into Dynamics365
28%
Increase in efficiency of the entire travel booking process, from the initial travel request to final ticket booking
+1200
Travels successfully requested through the system
Key Phases
- Data infrastructure design and creation of data repository using Microsoft Dataverse.
- Front-end & back-end development of a low-code application using Microsoft Power app environment
- Creation of approval and notification workflows supporting the application via Power Automate.
- Establish an extract, transform, load (ETL) service for migrating data to a central data repository.
- Design of Power BI dashboards displaying analysis on data related to travel
- Python model development aimed at expense reconciliation