Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

1/16/2017 - 1/27/2017

Completed

    • UCLC Training
      • Sexual Harassment Prevention
      • Cyber Security Awareness
  • Code Review for OIR Compass ETL.

 

  • JIRA's completed
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1573
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1579
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1580
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1587
  • Service-now incidents completed:

In Progress

  • Clinical trials Cognos report for OR (On hold) 
    • Need additional fields in the proposal ODS table.
    • ETL and Cognos framework package needs to be adjusted.
  • New OR dev and prod database migration.
    • All Informatica/Cognos connections need to be changed.
    • Firewall rules for production.
    • Connectivity testing for production. 
  • TEM data mart development code review and deployment prep work.
  • Zena Agent install on etl-dev.
    • Waiting on firewall exceptions to be completed by the security team.

Planned

  • Additional fact table creation for KC Negotiation star.
  • Informatica SRAQ.


1/3/2017 - 1/13/2017

Completed

  • KC/SPA Proposals Half-Year report.
    • Due date:  1/13/17
    • Activity by school and month Cognos report completed (1/9).
    • Activity by sponsor and quarter Cognos report completed (1/13).
    • KC null dept code list reconciliation.
  • New OR dev and database migration.
    • Firewall rules addition
    • Connectivity testing complete
  • Informatica LDAP connector setup on dev server.

 

  • JIRA's completed
    • Jira Legacy
      serverOIT JIRA
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId252346bd-c418-34af-94a0-0709b2108812
      keyKFSDW-1573
  • Service-now incidents completed:

In Progress

  • Informatica developer training proposal prep work.
    • AIRB training room requested for (3/6-3/9)
    • Received adjusted price quote for Level 1 Developer course.
  • SISDEV connectivity from Informatica.
    • Need stunnel setup 
    • ODBC source setup and testing.
  • Clinical trials Cognos report for OR (On hold) 
    • Need additional fields in the proposal ODS table.
    • ETL and Cognos framework package needs to be adjusted.
  • New OR dev and prod database migration.
    • All Informatica/Cognos connections need to be changed.
    • Firewall rules for production.
    • Connectivity testing for production. 
  • TEM data mart development code review and deployment prep work.
  • Zena Agent install on etl-dev.
    • Waiting on firewall exceptions to be completed by the security team.

Planned

  • Additional fact table creation for KC Negotiation star.
  • Informatica SRAQ.
    • Need to schedule meetings with security team.


12/19/2016 - 12/23/2016

Completed

...