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
  • Awards by purpose Cognos report for 2015-2017 fiscal years
  • Awards by sponsor by school Cognos report for Q1 2017.
  • Code Review for OIR Compass ETL.
  • Daily GL dev nightly loading changed back to KFSDAY2.
  • ETL .

...

  • data flow overview meeting for OIR reporting team.
  • SISDEV connectivity from Informatica.
    • stunnel setup complete.
    • ODBC source setup and testing complete on etl-dev.
  • 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

  • UCLA Informatica object import UCPath.
    • Need to create shared folders. 
  • Informatica developer training proposal prep work.
    • AIRB training room requested for (3/6-3/9)
    • Received adjusted price quote for Level 1 Developer course.
    • Received customization confirmation from Informatica University.
  • 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.

...

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

...