Page Comparison

1/30/2017 - 2/10/2017

Completed

• New awards by purpose Cognos report complete.
• Code review for all PURAP TEM objects for production deployment.
• UCLA Informatica object import for UCPath. 
  • Shared folders created for all source, target, and transformations. 
• Informatica developer training prep work complete.
  • Confirmed for 3/6-3/9 @AIRB1020
• Presentation slides prep work for OIR DW information session.
• JIRA's 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-1596

• Service-now incidents completed:
• INC0141357
•  INC0145432
• REQ0012856
• REQ0012926

In Progress

• Additional fact table creation for KC Negotiation star.
• Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
• 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. 
• Zena Agent install on etl-dev.
  • Waiting on firewall exceptions to be completed by the security team.

Planned

• Informatica SRAQ.

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
  server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1573

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

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

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

• Service-now incidents completed:
• INC0139201
• INC0139206
• INC0140907
• INC0140906
• INC0140557
• INC0142722

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.

...