Page Comparison

11/721/2016 - 1112/182/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:

• 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:
  • INC0128157
  • INC0127686

...

• 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.
• 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:
  • INC0128157
  • INC0127686

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.
• Continuing to encounter various issues with incorrect unique indexes on tables for TEM.
  • KFS_D_TEM_EXPENSE
  • KFS_D_TEM_PERDIEM 
• 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.
• Various Informatica support for developers/new hires.

Planned

• Informatica SRAQ.
• Need to schedule meetings with security team.

...