Ticket Management & Customer Communication
Conceptualisation and development of a Power Apps Canvas application for the structured capture, processing and archival of internal ticket requests at a renowned Viennese theatre and musical company. The solution incorporates a fully automated, multi-stage workflow built on Power Automate, SharePoint Online and Microsoft Lists, alongside integrated automated ticket generation and distribution to both internal and external recipients.
Technologies Used
Invoice Processing Automation
Design and implementation of a fully automated data integration between a WordPress/WooCommerce online shop and the FreeFinance accounting platform. The solution handles automatic invoice generation, accurate assignment of all posting items and seamless integration into the booking journal — ensuring complete, audit-ready traceability of all transactions.
Technologies Used
Digital Course Registration with Distribution Logic
Conceptualisation and development of a Power Apps Canvas application for the digital course enrolment of an Austrian summer college. The application guides students intuitively through the entire registration process and, through an integrated rule-based distribution algorithm, ensures a fair and capacity-compliant assignment of participants to available course slots. Data is managed in Microsoft Lists and SharePoint Online; the distribution logic is implemented via Power Query and macros in Excel 365.
Technologies Used
Month-End Closing Automation
Conceptualisation and partial automation of the monthly close process for the controlling department of a mid-sized organisation. The solution automates the extraction and structured population of Excel reports from the Qlik Sense business intelligence environment, as well as the subsequent rule-based distribution of the completed reports to the relevant recipients.