10/10/2016 - 10/21/2016
Completed
- Troubleshooting/fixing new development by Analytix for KFS data mart additions.
- PO
- Disbursement
- KFS PO subject area loading merged with daily loading workflow and deployed to production.
- Sponsor category code reconciliation for SPA reports.
- KC Negotiations module dimensional model Cognos Framework design.
- Sample Cognos reports design as POC for OR functional staff.
- Informatica PowerExchange for LDAP price quote request and purchase justification.
- Re-negotiated original price from $36k down to $21.6k
- D_DATE dimension holiday column update process completed using staff holiday list compiled by Allison.
In Progress
- SPA award count logic adjustment to exclude administration cycles.
- SPA monthly/quarterly reports design.
- Based on review of the sprocs, ETL adjustments are required for the daily OR loading.
- New Cognos reports design.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
- Troubleshooting ETL performance issues from etl0 to solar.
- Continuing to experience semaphore timeouts from Solar.
Planned
- Informatica SRAQ.
- Need to schedule meetings with security team.
9/26/2016 - 10/7/2016
Completed
...