Managing a wages of the employee based on their work, holidays and nature of contract
Domain:
ERP, FinanceTechnology:
Microsoft .Net, Angular, SQL ServerProblem:
Inaccurate and inefficient way of wages calculationProject Overview:
Client owns a big company and it has thousands of employee. There were so many operations/tasks to be performed to manage their employee. Some of the most important operations were managing the different kind of employee (Part time or Full time), logging the working hours of the employee, calculating holidays & leave and calculating payroll based on holidays, leaves, working hours and nature of the contract (Part time or Full time). Out of all these calculating payroll was very challenging as there were so many rules and they were managing the things manually.
Challenge:
As mentioned in overview client has thousands of part time and full time employees and they had a big problem with calculating their employees’ monthly wages. Wages had to be calculated based on employee’s working hours, duration with employer, employment type (part time/full time), leave encashment and holidays of each calendar year. They were doing all these with excel sheet and it was nightmare to manually entering all these information in excel and conclude the final calculation at end of the each month.
Solution:
We developed a web application with easy interface where customer can manage their employee’s data including employment type, joining date, leaves etc. Design another module to log employee’s work timings. Also build a utility through which they can upload the holidays of each calendar year and at last design an algorithm which uses all these data and at end of the month calculates the user wages based on that. So now everything is automated starting from managing the employees’ data to calculating their wages.