Even though I come from a development background, I had to work as a support team member for some time for one of the project. It's quite common in IT industry that depending upon the project need your role will change accordingly even if it doesn't match with your skills set.
There were many repeated tasks on daily basis which we have to do. Like - sending reports to business teams, reprocess exceptions, close alerts, process stuck orders etc. I did not like this repeated work and thought of automating few things. I observed the pattern for few tasks was like -
- Connect to DB
- Execute a query to DB
- Export the output to CSV file
- Execute existing Jmeter script which reads data from CSV file and invokes API/Service