Large hospital data system migration and upgrade working directly with the head of business intelligence and technology. We help with the data migration for their internal finance system INFOR. Translating the old transaction data into the new platform using ssis and Microsoft SQL management studios provided data load transfer as a one-time load as well as incremental load that was performed on a nightly refresh. There were multiple pre-existing reporting that has to be prepared based off of the new data schema. Multiple different data formats that has to be consolidated using different methodologies as well. We create a multiple power bi rapport data sources from the data warehouse for ingestion on the new reporting and data systems