Page Comparison

Anh’s Status 8/29/2016 - 9/8/2016

ETL development:

Completed reversing changes, closed this jira https://services.adcom.uci.edu/jira/browse/KFSDW-1460

Month-end activities:  Outbound SMS tonight, SBS aging on 7^th.

UATs: 

https://services.adcom.uci.edu/jira/browse/KFSDW-1416 KFS_D_CRDT_MEMO_ITM:  Analytix is investigating error encountered during UAT “Invalid object name 'KFS_D_CRDT_MEMO_ITM'”

https://services.adcom.uci.edu/jira/browse/KFSDW-1417 KFS_F_CRDT_MEMO_ITM: UAT is in progress

https://services.adcom.uci.edu/jira/browse/KFSDW-1418 waiting for Analytix's unit test query

https://jira.oit.uci.edu/browse/KFSDW-1361 KFS_F_DSBRMNT_ITM: BadRecCount = 2 and JoinedRecCount = 3 for the first test query (dss_kfs.KFS_D_DSBRMNT_UCI_BNK).  Analytix is investigating.

https://jira.oit.uci.edu/browse/KFSDW-1362 KFS_F_DSBRMNT_ITM_ACCTNG: Encountered “Error converting data type nvarchar to numeric”.  Informed Analytix to investigate

https://jira.oit.uci.edu/browse/KFSDW-1394 KFS_F_PREQ_ITM: missing the name of the wf/session, unit test query.  Analytix said to provide soon.

DW annual passwords needing change:  Coordinated with teams including Tom B. who will make changes on their sides to get ready to make changes on 9/16 for proper, dssoper, dwhoper, ppsoper on PROD.

Attended weekly DSS mtg

Attended weekly Analytix mtg

Anh’s Status 8/15/2016 - 8/26/2016

Labor Ledger model task

https://services.adcom.uci.edu/jira/browse/KFSDW-1460: Done adding additional requirement to KBM.  It’s now ready for test.

...

1) Completed fixing staging krns job

2) Pager duty this week. 

3)  Completed

     Completed setting up to schedule this job to run nightly.

4)  Emailed ddls scripts to Analytix per their request to create tables below:

...

6)  Need to schedule syncInvoiceNumberSundryDebtors to run on production

Anh’s Status 3/28/2015 – 4/10/2015

...

1)  Fixed uciSmsGIFeed.  ods_kfs.UCI_SMS_FEED_DETAIL_T table now has all records for Feb. data with batch date ’06-MAR-15’, matching Oracle side:  31,647 records, debit amount total is $3,647,165,482.52. 

...

5)  Analytix:  Provided our versions of our DBs that they asked.  They confirmed access to talenddev server.  Attended weekly status meeting this Friday morning.  They're going to send me a list of sqlsver tables so I can send them DDLs to them to create these tables.

6)  uciSmsGIFeed:  The job loaded month-end data this month without problem.  FYI -  Following day, this was the 2nd time this month that Jarrod reran, regenerated the trigger.  The job ran fine 2nd time. 

7)  Completed

• Not complete yet section: 

  1)  Staging krns job loaded all tables but Talend sent false notification.  I need to debug this job.
  2)  Export all talend jobs on new server
  3)  ACCOUNT_CG_PRPSL_NBR not being populated in dss_kfs.KFS_D_ACCOUNT

...

5)  SBSO: 

6) Pager duty next week. 

Anh’s Status 3/16/2015 – 3/27/2015

...