Dear Sir,
I can build a tool to populate all data from POS API to Mysql database and config for run as scheduler in the future. Also, will build the data BI for you base on Pentaho BI tool, it's a opensource.
I have built this system in my old company so i have experiences on this kind of project.
Hope to have a change to work long term with you.
Best regards
Thanh Truong.