Any idea if I could run scripts to have consistent backup of its database ?
Yes, you can use scripts to ensure HANA database consistency. Here is an example of scripts used with VMs, you might need to adjust them for usage on physical machines.
Also is scripting supported for VEEAM to perform pre/post thawing of database for SAP HANA for bare metal RHEL servers?
Yes, VAL supports pre-freeze and post-thaw scripts with Server edition license installed.
For effective use of Agent's would there be any requirements in terms of how much compute and RAM resources must be allocated to run backups?
There is no specific requirement. Generally speaking, if your system meets minimum requirements listed in the User Guide, that should be enough. With large volumes of data a more significant amount of RAM might be required, however those cases are quite rare.
Thanks for the detailed answers, i suppose the following should be enough for me to get things started, however I am just curious tough. How would Veeam be able to validate if the script which I have come up with would be able to get the job done ? Or is this solely the responsibility of the end user or SAP themselves ?