6/16 - 6/30
ETL:
Worked with Janine, Kevin to clarify requirements for OTHER_ATTR_NM,PMT_MTHD_DESC,PRJDIR_CNT_NBR.
Started mapping the Award dimension table. Completed 98 columns out of 129.
Misc.:
Attended 1-on-1 weekly status meeting
Attended KFS upgrade and Award dimension meeting
Attended Award dimension – specs meeting
Attended KFS Upgrade for Decision Support meeting
Attended Weekly KFS Decision Support Meeting
Attended Weekly KFS Decision Support Technical Status
Next plan:
Continue with the Award dimension table
KFS upgrade related activities
Informatica admin related activities
6/12 - 6/15
ETL:
On my first day back from vacation, I was asked to fix daily_oltp failure on dev. Completed. It has been running nightly without any issue.
...
Closed the following jiras:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UAT:
Test failed, reported to Analytix to fix the following jiras:
...
Continue
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
UATs
Continue with this activity.
1/3 - 1/12
ETL
Completed, verified SBS, Outbound month-end.
Completed https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx). Unit test is in progress.
UATs:
Following jiras are completed, ready for deploy:
(KFS_F_TEM_ACCTNG)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1443
(KFS_F_DSBRMNT_VCHR)Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1436
Training
...
Complete testing to be ready for deploy https://jira.oit.uci.edu/projects/KFSDW/issues/KFSDW-1496 (Modify Balance ETL for all ITD balances to remove SFG 2xxxxx).
As soon as migration completes on the production informatica server and to prepare for the next month-end, I need to work with Jarrod to verify, test the following jiras to ensure that his aps send triggers to the appropriate locations:
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1550
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1549
Jira Legacy server OIT JIRA serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1579
UATs
Continue with this activities.