Customer
The Customer is a trading unit of the parent holding company (which includes more than 40 metal, steel and machinery producers across the world) in Kazakhstan.
As part of the Company’s corporate SharePoint portal evolution and introduction of HRM-functionality the decision was made to develop reporting system with the ability to download detailed employee data.
Service development goal was to provide users with the ability to generate reports using various filters and data views.
Module specifics:
- A large number of reports;
- Inability to implement required data aggregation using standard SharePoint tools;
- Calculated fields in reports depending on certain rules and conditions.
The following reports were implemented within project scope:
- Labor book log
- Employees on probation
- Sick leaves
- Employee’ documents
- Salary changes
- Work trips
- Health insurance
- Job locations
- Vacations
- Trainings passed
- Employment contracts
- Employee’ marital status
- General monthly report
- Schedule of positions and salaries
- Leave balance
Development specifics:
- Module is based on SQL Server Reporting Services Platform;
- A special web service performing server-based searches was developed to fill reports with data. Upon report opening Reporting Services platform calls certain web service methods passing report parameters to them. Methods collect and aggregate the data and return it using xml;
- Client part of the system uses this data to create reports for end users.