9/21/2015 - 10/2/2015
Completed
- Awards by Campus Area report data discrepancy review request from Office of Research.
- Found records that were added through the SPA system at the very end of the fiscal year.
- Kuali Coeus proposal workflow sample data for David Tieu/OR team review.
- Sponsored Projects DWH page review.
- Identified the SQL Server processes/logic that populates and outputs data files that are loaded to the dwhm_fs.rgs* tables in MySQL.
In Progress
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
- Cognos security permissions review for Office of Research related reports.
- Sponsored Projects DWH java code review to identify source tables/fields and any additional report logic.
Planned
- Sponsored Projects DWH Informatica ETL process design.
- Source data directly from source DB and create a SQL Server table structure that will be used in a cognos framework package.
9/7/2015 - 9/18/2015
Completed
- Awards by Campus Area report data discrepancy review request from Office of Research.
- Found records that were added through the SPA system at the very end of the fiscal year.
- Kuali Coeus proposal workflow sample data for David Tieu/OR team review.
- Sponsored Projects DWH page review.
- Identified the SQL Server processes/logic that populates and outputs data files that are loaded to the dwhm_fs.rgs* tables in MySQL.
In Progress
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
- Cognos security permissions review for Office of Research related reports.
- Sponsored Projects DWH java code review to identify source tables/fields and any additional report logic.
Planned
- Sponsored Projects DWH Informatica ETL process design.
- Source data directly from source DB and create a SQL Server table structure that will be used in a cognos framework package.
8/24/2015 - 9/4/2015
Completed
...