Hi,
With more than 5 years of extensive experience in database design and development, my experience ranging from startups to big organization like O2 ireland, jaguar land rover etc with distinction in SQL , SQL server and Mysql.
I have done a similar sort of project for a start up having their data in flat files with billion rows of sales data.
I design a database in MySQL ,transformed, append data using Talend (an ETL tool) and SQL to migrate and automate the flow of data in mysql database. I have given you high level summary of my past experience.
Now for your scenario, my approach will be:
1)Design optimized database schema (If not exist)
2) Feed Excel data into talend (an open source ETL tool)
3) Make transformation and data sorting in Talend .
4) Load data in Mysql.
5)AUTOMATE flow for proper ingestion of data in mysql DB using talend.
My second approach will be.
1)1)Design optimized database schema (If not exist)
2) Load excel data in SQL staging table,
3) Transform and sort the data using SQL.
4) Load data into target tables.
5) Automate process .
I am new to freelance but I have a lot of experience in designing building such solution.
If you like my approach , you can give me a test dataset and I can provide you with solution.
Thanks