DWH Team Status Report for 02/08/2013
DWH KFS Decision Support JIRA Tasks - Status Chart
Prior Two Week Activity
Kuali Financial System
Completed
- PURAP model
- Specs for highest priority reports delivered to General Accounting for sign off
- Feeder System Validation Report
- ETL specs for Capital Asset tables
- Met with Caryn Bender for Workflow & Access reporting requirements
- Met with Linda Sizemore to finalize requirements for open receivables exception reports
In Progress
- Scripts to add KFS attributes to legacy data warehouse (employee, payroll, fs). Coding is complete - currently testing each time COA is re-loaded.
- Code review of ETL jobs delivered from consultant
- Report prioritization
- Report Specs for capital asset module reports
- ETL development for PURAP
- ETL specifications for PURAP
- Requirements gathering for Accounts Payable and PURAP modules
- Development of scripts to migrate open receivables transactions from legacy DWH to KFS DWH
- Hardware setup for Cognos production servers
- Report design guide document
Reports to Be Developed with Prioritization:
| Legacy System | Undecided | AP | KFS | SC | 12/1/2012 | 1/1/2013 | 4/1/2013 | 7/1/2013 | 10/1/2013 | 12/1/2013 | 4/1/2014 | Grand Total |
| DRS | 1 | 1 | ||||||||||
| EQS | 1 | 1 | 1 | 3 | ||||||||
| FS | 3 | 1 | 2 | 9 | 16 | 14 | 1 | 6 | 52 | |||
| PAL | 0 | 0 | 1 | 1 | 0 | 2 | ||||||
| PPP | 1 | 1 | ||||||||||
| UCAP | 3 | 1 | 1 | 1 | 1 | 4 | 4 | 1 | 16 | |||
| UCFS | 0 | 0 | ||||||||||
| UCOP | 1 | 1 | ||||||||||
| UCPO | 1 | 0 | 1 | 2 | ||||||||
| Grand Total | 8 | 1 | 2 | 1 | 2 | 3 | 10 | 21 | 19 | 1 | 9 | 78 |
Payroll Certification
Code changes completed for DHHS enhancement. We are currently testing the code changes and verifying the data.
Data Warehouse Support
DWH is operating well as usual, Grace is acting as primary DWH production support.
Recent support tasks include:
- Modify employee query for EROS to include separated employees
- Annual University Hills Report
- Automated Extracts for spend analysis
Next two week planned activities and deliverables
- Continue working on approval for high priority reports
- Data Model for Authorization/Workflow module (KIM)
- Finalize requirements for Purchasing department
- Report specs approval for Capital Asset and PURAP
- Report development for highest priority reports
- Talend Server load testing (Windows vs. UNIX)
Production support trends in terms of tickets either in JIRA or Footprints.
DWH Production Support 10%, New development 90% (except Grace)
Staffing issues or personnel related matters
We are limited in resources for the migration of Payroll Certification to KFS. Proposed solution is to postpone conversion after KFS go-live. The system can use the current version of the fund table in DWH until conversion is done.
Due to a delay in approvals of report specifications, we are severely behind schedule for report development. As a result, Durendal will assist with Cognos report development.
Budget requests for any new software or hardware
Training requests
Charles needs Cognos training. We can probably re-use the Cognos self-paced training that Kevin Chung recently finished.
Things learned, suggestions for improvements or anything else you think might be important
None at this time