hey there,
I read your Project Description carefully and got deep understanding of it as I had experienced of a project related to Healthcare.
I had worked on Data warehousing projects using a lot of tools like SSIS, Pentaho, Tableau, Power BI.
One project is related to Healthcare ( pharmacy stores) which includes vendors, suppliers, departments, revenue and sales etc,
And second one is related to Car Sales Company including Revenue, Total Sales, Profit, Loss.
Also built cube on SSIS, Dashboards on Tableau and Power BI, Data Integration on SSIS for Data warehouse and Data Marts.
As a Description I would tell some of the Dimensions (really few ones) used in Pharmacy stores Projects
Dimensions:
1- Customers
2- Vendors
3- Suppliers
2- Items
5- Purchase Order Header
6- Purchase Order Details (many for each PO Header)
7- Items
8- Time
As a Data warehousing and ETL developer, I am the best Person to hire for this Project. Hope to hear from you soon.
Thank You
Best Regards,
Shoaib Ahmed
Software Engineer