Data Analytics Legacy Completed legacy import ticket after creating the scripts and pre and post testing of the data. Completed processing of site legacy data. Investigated possibility of onboarding new site. Produced Weekly Legacy Conversion Status One Pager. Issued meeting notes for the Legacy Weekly Check-in with ADM. Completed processing of several sites’ data into ESSENCE. Data Quality Updated the Insert_XX_Processed stored procedures four authorized columns (Procedure_Code, Diagnosis_Type, Diagnosis_Code, Chief_Complaint_Code) data types for all sites on STAGE-ARCHIVE. Completed Staging indices. Performed QA for legacy cites. Initiated zip code region mapping for legacy sites. Investigated new defect surrounding temperature unit field. Identified defects discovered during the Legacy conversion process then coordinated with developers to fix and deploy updated code as well as update damaged records where applicable. Completed copying the zip code tables to the DATAMART.ESSENCE Training and JIRA/Service Desk Assigned incoming customer tickets to appropriate teams. Resolved issues regarding multiple JIRA projects. Server Upgrade Sent out communications surrounding BioTerminal switch. Plans for Next Week (across the project) Category Key Accomplishments and Plans Requirements Master Facility Table (MFT) UI No work planned due to testing AMC AD. AMC Active Directory Perform testing of AD User Stories in Integrationtest environment. AMC Enhancements Create document for UI standards for all AMC. System & Maintenance Operations & Maintenance Prepare SOP for SAS users. Perform server upgrade and migration activities. Perform server performance monitoring and evaluation. Perform server cost monitoring. Finalize revisions to GIT guidance documentation and finalize the document. AMC Active Directory Develop more test cases for AMC database. Perform AMC AD migration planning and initial implementation. Data Onboarding Feed Issues Investigate issue of multiple C_BioSense_FacilityIDs for one MFT record. Technical Support Internal Support testing of AMC AD User Stories. Data Analytics Legacy Send out legacy communications surrounding Quality Assurance to 10 sites. Complete sFTP conversions for 6 sites. Data Quality Test and implement semicolon logic. Investigate requirements for site region mapping and design process for mapping other regions. Perform semicolon wrapping change request activities. Investigate PHINMS Legacy issue reported by site. Research if there are zip code changes in the US that need to be applied to the zip code tables. Provide zip code update for legacy site.
Investigate issues surrounding temperature unit field. Investigate potential concatenation approaches. Provide support for C_Patient_Class testing. Other Create a summary slide for C_Patient_Class findings and update. Provide Agenda deck for Thursday’s NSSP Platform Working Group Meeting. Training & JIRA/Service Desk Initiate planning for Help Desk Evaluation. Initiate planning for JIRA ADM meeting. Server Upgrade Initiate planning for communications for AD migration. New/Significant Project Issues/Risks/Scope Changes for Current Sprint Type ID Description Mitigation/Action Taken Status Owner Risk R012 Amazon infrastructure issues may affect BioSense Platform infrastructure. Monitor Amazon performance and prioritize and respond to issues as determined by the project team. Monitor Mike Coletta Risk R013 The development, testing, and staging environment AMC applications are not independent systems. Existing connections between each may lead to issues when new development is implemented The team will work to identify a long term solution to separate the applications (AMC & ESSENCE) in each environment. In the short term, they will create and adhere to SOPs and checklists for releasing new builds in each environment Monitor Mike Coletta Risk R014 High volume of project and support tasks is limiting resources available for Onboarding New Onboarding team member has been hired. Team is supporting Onboarding needs as new staff is learning the role. Monitor Mike Coletta Risk R015 We need to secure (SSL/Certificates) Active Directory and Ldap. All critical operations such as encoded password, enable, and disabled accounts cannot be done on an unsecured connection. Will need help from system admin to secure (SSL/Certificates) active directory-ldap on test domain controller. Monitor/Research Mike Coletta Risk R016 Server Transition SQL directives unclear. May need to perform MFT fixes/Reprocessing again on the new Archive server Server Transition SQL directives unclear. May need to perform MFT fixes/Reprocessing again on the new Archive server Monitor/Research Mike Coletta System Maintenance, Updates and Outages Date(s) Time(s) of Outages/Updates/Patches Estimated Downtime Reason Expected or Unexpected Thursday, July 27th, 2017 8:00 AM to 5:00 PM 9 hrs. SAS, RStudio Pro, Adminer, and BioTerminal Patching Expected Production ESSENCE Restarts