11/20/2017 - 12/1/2017
Completed
- Informatica core addition pricing negotiation.
- Purchase by 12/15/17 - License: $57,420 / Maintenance: $12,632 / Total First Year: $70,052
- Dev OR-DEV-DB server migration.
- All dev Informatica connection objects updated with new hostname.
- KC clinical trial staging loading ETL design.
- Informatica connectivity issue with Oracle 12c database instance TICKTEST.
- Updated the connect string to use ODBC DSN name in lieu of direct connect.
- Work estimate for Pinnacle (new telephone billing system) data integration task.
- KR COI application workflow project meeting.
- COI team needs a daily report (Cognos) of awards with the current conflict of interest disclosure form submission info.
- Temporary schedule change for KFS7 Tst workflows.
- Daily OLTP dev workflow troubleshooting for missing web services tables.
- Issue being caused by conflict with both the dev and tst workflow writing to the same database instance (Nebula).
- New UCPath/KFS consultant (Sujith Gadagottu) onboarding.
- Service-now incidents completed:
In Progress
- Waiting for confirmation on STG_LOAD_GEC_ERROR_CHECK_D_FUND_OVERDRAFT session removal from ODS workflows.
- Reviewing Cognos 11 Dev.
- All Office of Research content re-imported with most recent developed reports.
- Regression testing all OR reports.
- Reviewing the revamped UI and new features.
Planned
- Subaward dimensional model design.
- KC Proposal dimensional model design.
- SPA awards dimensional model design (On-hold for KR launch).
11/6/2017 - 11/17/2017
Completed
...
- Informatica Advanced Edition upgrade completed on production.
- All existing Oracle ODBC connections converted to native.
- KFS cost sharing workflow failure troubleshooting.
- Issue with bulk load on tables with indexes.
- All Informatica MySQL connection objects created as *_test to point to new DB server.
- New Cognos dashboard reports completed.
- Aggregated sponsored funding
- School to dept drill-through
- Clinical trials vs. Non clinical trials
- Office of Research annual reports review.
- Numerous changes needed to existing reports around report content and formatting.
- Deployment completed:
- Service-now incidents completed:
In Progress
- OR Cognos dashboard design version 2.
- Initial planning phases of KC Clinical Trials and Subaward dimensional models.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
...
- Discussion with POM on refining KFS workflow overnight support.
- Adjusted the Ops escalation instructions to call primary support if job isn't restarted within 15 minutes.
- Activity by department and quarter Cognos report completed.
- KFS daily dev workflow schedule changed to resolve failures caused by KFSDAY2 schema refresh.
- Dev schedule updated to run at 12:05am (confirmation from Kevin Chung).
- KFS daily workflow enhanced to minimize missteps in POM ops support.
- Updated all sessions to abort upon failure to minimize ops failure notification time.
- Updated timer logic to run LD sessions in the event the workflow is started after 2:35am.
- Working with admissions to establish Informatica connections to the sisedw database.
- Testing Informatica connection to the new MySQL dev database (voyager).
- Service-now incidents completed:
In Progress
- OR Cognos dashboard design version 2.
- Initial planning phases of KC Clinical Trials and Subaward dimensional models.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
...
- Informatica Advanced Edition upgrade completed on Dev.
- Native Oracle driver included with our AE purchase as agreed upon.
- Troubleshooting slow write performance on AWS hosted DBs resolved.
- Converted existing SIS related connection objects to use the native Oracle connector.
- Write performance seems to be drastically faster with Oracle native based on a few small load tests.
- New MySQL DB (Voyager) connection testing.
- Informatica World 2017 conference attendance in San Francisco (5/15-5/18).
- Service-now incidents completed:
In Progress
- Activity by department Cognos report design/publish.
- OR Cognos dashboard design version 2.
- Initial planning phases of KC Clinical Trials and Subaward dimensional models.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
...
- Cognos Dashboard initial draft design completed.
- KFS nightly workflow scheduling and monitoring migration to Zena and Operations group complete.
- All OBDC DSNs/Informatica connections changed to use the new production SPA application database.
- New employee (Khader Abdul) onboarding.
- Access requests/general troubleshooting
- UCI Informatica environment overview session
- New Secret Server group (Informatica Admins) created for Informatica support requests.
- Informatica Advanced Edition purchase finalized. Received software/license keys.
- Awards by Agency (Physical Sciences) Cognos report for OR.
- Office of Research Data Summit event with Stanford.
- Trip planning for Informatica World 2017.
- Service-now incidents completed:
In Progress
- Troubleshooting slow write performance on AWS hosted DBs.
- Researching on how row-by-row processing is done by Informatica when using generic ODBC driver.
- OR Cognos dashboard design version 2.
- Initial planning phases of KC Clinical Trials and Subaward dimensional models.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
...
- Informatica KSAMS roles with elevated privileges creation as well as removal of old role complete.
- Technical Issue with Informatica sessions going into wait mode.
- Issue being caused by long running LDAP sessions and exceeding the max processes allowed in the dev domain.
- Technical discussion on Informatica file transfer method for the KFS data integration process.
- Order document for Informatica AE upgrade finalized.
- Discussions with Informatica sales rep and licensing specialist to clarify Metadata Manager connector licensing.
- MDX includes one connector to a RDBMS of choice (Oracle).
- Need to purchase one additional (SQL Server) to see all data lineage for our KFS mapping.
- Attended the Amazon Web Services Education Data Event.
- Service-now incidents completed:
In Progress
- Cognos Dashboard initial draft design based on feedback from Barbara on requested changes.
- Convert LD_LDGR_ENTR_T table dynamic loading to a native Informatica mapping to minimize impact on KFS nightly loading time.
- Initial planning phases of KC Clinical Trials and Subaward dimensional models.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KFS nightly workflow scheduling and monitoring migration to Zena and Operations group.
- All prep work completed and ready to deploy Zena Informatica schedule!
- Planning for a Thursday (4/27) deployment.
...
- Informatica KSAMS roles with elevated privileges creation as well as removal of old role complete.
- Office of Research Cognos Dashboard proof of concept design complete.
- Initial design include proposal/award activity totals with interactive prompts.
- Drill-through reports requested for next draft.
- Labor ledger loading with benefits load testing from KFSCURRENT complete.
- Complete load with historical records (~24m) takes an additional 157 minutes.
- Nightly KFS loading technical discussion with DWH team to discuss alternative methods to handle the additional processing time with the labor ledger.
- Need to separate out the LD_LDGR_ENTR_T table from the dynamic staging and convert to native Informatica. Reduces load time by ~2hrs.
- Kuali Research Kickoff meeting at Office of Research.
- OR dev database migration connectivity re-testing due to IP address/firewall rule changes.
- Onboarding/orientation for new student intern (Anthony Nguyen).
- Onboarding/orientation for KFS Informatica Consultant (Saurav Chakraborty).
- Service-now incidents completed:
In Progress
- Convert LD_LDGR_ENTR_T table dynamic loading to a native Informatica mapping to minimize impact on KFS nightly loading time.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KFS nightly workflow scheduling and monitoring migration to Zena and Operations group.
- SSH keypair configuration on etl-dev and etl0 in progress.
...
- Complete SPA reports inventory analysis complete for SPA Award dimensional model.
- Final pricing for Informatica Advanced Edition complete.
- $36,600 for edition upgrade. Down from initial $50k pricing.
- Performance testing requested by Ellucian of Informatica for SIS to locally hosted Oracle DB complete.
- No performance issues when writing to KFSDEV.
- Severe performance issues on Ellucian cloud hosted servers.
- Bio Science dept Talend dashboard demo with Office of Research.
- New development SPA database migration completed.
- All Informatica/Cognos connections as well as ODBC DSNs updated to new host.
- Firewall rules now in place for all informatica servers and workstation.
- Onboarding prep work for student intern/Anthony Nguyen complete.
- Service-now incidents completed:
In Progress
- Informatica KSAMS roles with elevated privileges creation.
- 2 new roles created.
- Existing privileges migration
- Users (complete)
- Folders (complete)
- Connection (in progress)
- Current User role users need to be transitioned to new Developer role.
- Removal of current User role needs to be requested after PRD deployment is complete.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KFS nightly workflow scheduling and monitoring migration to Zena and Operations group.
- Workflow execution testing through SSH from Zena host successful on both etl-dev and etl0.
- Currently waiting for WSG to grant Informatica server access to qaoper.
...
- Informatica Developer Training (3/6-3/9).
- Half-year Activity by School and Year Cognos report design completed and published.
- New development SPA database migration.
- All Informatica/Cognos connections updated and tested.
- Aiding the Middleware team in configuring/troubleshooting Informatica connectivity to LDAP update only servers.
- Connectivity failures on port 700 and 701 identified as firewall and resolved.
- 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-1621 - Service-now incidents completed:
In Progress
- Working on new Informatica KSAMS roles with elevated privileges
- 2 new roles created.
- Current User role users need to be transitioned to new Developer role.
- Removal of current User role needs to be requested after PRD deployment is complete.
- Negotiating pricing for Informatica Advanced Edition as well as core capacity addition.
- New production SPA database migration.
- All Informatica/Cognos connections as well as ODBC DSNs need to be updated.
- Firewall rules for production need to be adjusted.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KC proposal dimension daily loading mapping design.
- 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.
- Zena Agent install on etl-dev.
- Mike Story currently testing workflow execution from Zena host.
...
- Additional fact table for KC Negotiation star completed.
- Informatica workflow updated.
- Cognos framework package updated with new star schema grouping updated.
- OR data warehouse related tables migrated to Solar for OIR to access.
- Common award dimension feasibility analysis.
- SPA/KFS GAP analysis.
- Accounting will have Janine create a separate award dimension.
- Will revisit at a later date.
- Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
- Connectivity issue to ldap-dev resolved. Issue related to TLS setting in addition to port setting on the Informatica connection object.
- 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-1611 - Service-now incidents completed:
In Progress
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- Informatica session statistics auditing capability survey for COMPASS workflows.
- Designing POCs for several different design approaches.
- KC proposal dimension daily loading mapping design.
- 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.
...
- 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:
In Progress
- Additional fact table creation for KC Negotiation star.
- Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
- Also migrating/testing connectivity to new ldap-dev server.
- 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.
...
- 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:
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.
...