...
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 Sponsored Projects legacy data warehouse java code 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 MySQLlegacy data warehouse converted to an Informatica ETL process.
- Made adjustments to the KFS daily staging workflow to suspend/notify if loading errors are encountered.
In Progress
- Validating sponsored projects Informatica data loads against results from DWH portal.
- 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.
...