11/21/2016 - 12/2/2016
Completed
- Disbursement data mart development objects code reviewed and deployed to production.
- Encountering discrepancies between the table DDL (unique indexes) and the functional specs.
- JIRA issues completed:
- Negotiations star schema demo and Cognos training sessions for OR.
- SPA award count logic adjustment to exclude administration cycles and add two additional measures.
- SPA quarterly report design with new award count logic and additional measures.
- SPA On Time Proposal Submissions by Dept.
- Low proposal totals (counts and dollar amounts) troubleshooting.
- Issue due to timestamps in source proposal records integrated from KC to SPA system.
- SFTP transfer to Informatica server for zot codes file testing completed.
- Service-now incidents completed:
In Progress
- Clinical trials Cognos report for OR.
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- Issue found with KFS source records with duplicate FDOC_LINE_NBRs for the KFS_F_TEM_ACCTNG fact table.
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1543KFSI-13867 - Missing dimension table found KFS_D_TEM_PROFILE
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-
1521 - Service-now incidents completed:
In Progress
- SPA award count logic adjustment to exclude administration cycles and add two additional measures.
- Award history table.
- SPA quarterly report design with new award count logic and additional measures.
1441
- TEM data mart development code review and deployment prep work.
- Possible issue with incorrect SIDs in the PO fact tables.
- 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
- Additional fact table creation for KC Negotiation star.
- Informatica SRAQ.
- Need to schedule meetings with security team.
...
11/7/2016 - 11/18/2016
Completed
- ODI Technical Training (11/15-11/17)
- Disbursement data mart development objects code reviewed and deployed to production.
- Encountering discrepancies between the table DDL (unique indexes) and the functional specs.
- Troubleshooting ETL performance issues from etl0 to solar.
- Resolved after Solar databases migrated to new SSD data center appliance.
- UCI Informatica environment overview for Barathi.
- Informatica LDAP connector purchase approved and PO submitted.
- JIRA issues completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1543 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1521 - Service-now incidents completed:
...