2012-09-07_JonesValerie

DWH Team Status Report for 09/07/2012

Prior Two Week Activity
1. High level summary of your or your team's activities that were accomplished in the prior two weeks including project status and any issues encountered. Downtime or any disruption of services should be identified.
2. Kuali Financial System
  1. Complete - Chart of Accounts and General Ledger Entries data model. Final approval of data model pending review with Accounting next week.
  2. Complete - Coding for jobs to copy KFS tables from Oracle to development SQL Server for transactional systems and KFS web services. These jobs have been exported to the UNIX development server, optimized for parallel loading and scheduled to run daily.
  3. In progress - Coding for KFS web services and Java client for all feeder and shadow systems. Completed web services include: Chart, Account, Sub Account, Object, Sub Object, and Project
  4. Entire DWH team attended first day of Talend ETL training
  5. Installed Cognos on a test Windows VM server, conducted additional benchmark testing
  6. Consultant for KFS ETL developer position approved and hired, worked on resulting amendments to contract with East Point Consulting
  7. In progress - scripts to add KFS attributes to legacy data warehouse (employee, payroll)
3. Payroll Certification
  1. Coding completed for mandated changes of NIH (DHHS) salary cap calculation. Functional testing by stakeholders (Contracts & Grants Accounting) in progress.
4. Data Warehouse Support
  1. Modified sponsored projects (RGS) jobs to add federal code needed by Payroll Certification enhancement
  2. Completed scripts for new data request from School of Medicine for bi-annual employee extract
  3. Worked with Spend Analytics consultant to provide purchasing, invoice, vendor, chart of accounts and ledger extracts for UCOP Spend Analysis project
5. Non-DWH Support
  1. Grace assisted with PPS range adjustments, fixed a problem with the PPS hierarchy with EDL, and attended eLogin training
  2. Valerie assisted with the help desk preparations for SAMS training
Next two week planned activities and deliverables
1. Install and Configure Talend Server - request for new windows VM submitted to WSG team on 8/22
2. Work with Kaz on planning for Cognos server setup
3. Meet with database team to discuss SQL Server capacity planning for KFS data warehouse
4. Extract, Transform and Load technical specifications document for chart of accounts and ledger transactions
5. Develop a proof of concept report in Cognos for KFS organizational hierarchy
6. Complete Talend developer training
7. Begin development of jobs to load KFS data warehouse staging environment
8. Begin code changes required to convert legacy Data Warehouse authorization extracts from SAMS to new KIM web services
9. Load year-end CSF file from financial system to Oracle for KFS conversion team
10. Tentative - Changes to DWH jobs to add accounts without funds to the accountfund table (for KFS conversion team)
Production support trends in terms of tickets either in JIRA or Footprints.
1. Please identify the sliver of time that is spent on new projects vs production operational support by percent time overall for your team.
2. DWH Production Support 25%, New development 75%
Staffing issues or personnel related matters
1. Staffing for FMW project
Budget requests for any new software or hardware
1. Tammy need a new PC - she is really struggling with slowness in Talend
2. PC for student - I would like Janis to assist with Talend development but she can't install Talend on her VM due to the memory restrictions. I will have her work on DWH coding for now but we should probably address this issue at some point in the future.
Training requests
1. None at this time
Things learned, suggestions for improvements or anything else you think might be important
1. None at this time