Hey,
Here is my plan on how I would work on this:
1. Create the database if its not present already.
2. clean the data to bring it to structures format.
3. Extract the features from the ticket text.
4. Build the classification model by considering important features using ngrams or bag of words approach.
5. Categorize tickets using the model.
6. Verify the accuracy and tweak the model to improve the accuracy if needed.
7. Sending the ticket to the person responsible for each category should be handled by application.
(The description here was vague, so i do not if there is a system in place already to fetch the person in charge of each category)
8. Determining priority of ticket should be done based on the features. Not sure how you assign priority, but we can build a machine learning model and feed previous ticket and their priority levels to predict the priority of next incoming tickets.
9. Same with the estimated time.
I would go with python just because of the vast library system it has.
We can use text summarization techniques to extract keywords / annotations from text.
Let me know if you like my plan, we can jump ahead and start working on the project.
Thanks and Regards,
SG.