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

  1. Internal application developed, including design, front-end development, as well as backend and data infrastructure. 
  2. Python model capable of reconciliating expenses relating to travel into Dynamics365 system, supported by daily data feed of ECB exchange rates.
  3. 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

  1. Data infrastructure design and creation of data repository using Microsoft Dataverse.
  2. Front-end & back-end development of a low-code application using Microsoft Power app environment
  3. Creation of approval and notification workflows supporting the application via Power Automate.
  4. Establish an extract, transform, load (ETL) service for migrating data to a central data repository.
  5. Design of Power BI dashboards displaying analysis on data related to travel
  6. Python model development aimed at expense reconciliation

Front-end app design illustrations