Team Size: 5
Technologies used: UiPath, C#, .NET, Angular, TypeScript, Microsoft Project, SQL Server, Git, Jira.
The client is a pan-European retail chain that sells gardening, home improvement and workshop products. The company has more than 17 000 employees, 250 stores and franchises across the whole of Europe.
The company has been partnering with a well-established outsourcing vendor for a couple of years. For diversification purposes, they chose TageSpot as a backup force to help them to migrate their internal payroll solution from an old approach using stored procedures and desktop app to a modern web application with an automated data retrieval of timesheets from Microsoft Project, Jira and other tools.
Beside successful migration, our business analyst helped to identify waste in the process, designed an automation approach of data gathering activities for payroll calculation which helps saving thousands of dollars every month. The project has been successfully completed in late 2020. Automation was not performed via code as in a usual way, but more in a Lean approach leveraging the UiPath RPA platform. This streamlined solution delivery and laid the beginning of establishing RPA practice inside the company.
Currently, our RPA consultant and C# developer are working with the company back-office on the automatization of routine business processes.
Also, we are working closely with the company's Sales&Marketing department helping them with running marketing campaigns and enhancing their analytics solution to extract more value from the gathered marketing data and discounts program. The solution is based on the architecture that is an intersection of Data Lake and Distributed Data Mesh.