Customer has about 2,000 sales outlets (owed and partner-based) across all Russia and more than 600 sales consultants specialized on certain brands.

Previously, managers scheduled consultants manually in Excel and sent resulting schedules to consultants once in a month.

Service development goal was to automate work schedules creation (based on previous months’ data) and distribution.

Main challenges of system development included the following:

• Setting up work schedules access rights based on user position, department, region and certain brands knowledge.
• Possibility to automatically prepare schedule based on past months information. Each consultant can work in different retail outlets according to specific schedule. He/she can have sick leaves, vacations and compensatory leaves and replace employees in other outlets – all this information is taken into account when constructing a schedule.
• In parallel with a consultant’s work schedule, a load schedule for each outlet is created. It is possible to manage data from any of these schedules.
• Automatic data check in case of any changes. For example, it should not be possible to assign a consultant to work in different outlets at the same time.
• Ability to lock schedules from changes for individual consultants;
• System performance is a critical requirement.
• Data on consultants from different departments was stored in different locations using different formats.