I have 8 Years of Experience in SQL, SSIS, SSRS and SSAS Technology. handled multiple project in DataWarehouse Design and Development , Data Migration, automation through SSIS, SSRS & Power BI Report Development, OLAP Cube Development and DW Design.
As per project Requirement, It doesn't seems to be exact DW Design and Loading. It seems to load file into Db and create SSRS Report on that with email subscription.