locked
develop an application to calculate the SLA deadline of a captured complaint based on the configured RRS feed

  • Question

  • develop an application to calculate the SLA deadline of a captured complaint based on the configured working hours. When a complaint is captured it should have a maximum time to get resolved. Some low priority complaints can have 24 hours but some high priority complaints can have 4 hours to be resolved. All hours are business hours. For this reason you are expected to develop a database structure to store operating hours and business closures such as weekends, national and religious holidays. If a complaint is captured just before a national holiday, since we are counting for business hours only it should skip the non working hours during the national holiday. The requirements are as follows: 1) The application should be a web based application using a SQL server database for configuration of working days, hours and business closures such as national holidays. 2) Application input screen should have the following fields a. Complaint priority type, drop down b. Case capture date and time (eg. 12 Nov 2006, 15:23) 3) Application should output the following: a. The expected case resolution time considering the configured business hours 4) To save time you should NOT build a configuration screens but instead have database tables for a. Configuring weekends b. Configuring working hours c. Configuring other business closures because of national holidays, special events etc d. Please be aware that business closures can be full day as well as couple of hours during a specific day

    Journey Man

    Tuesday, February 28, 2017 5:09 PM