Data Legacy Completed legacy import ticket after creating the scripts and pre and post testing of the data. Analytics 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 Operations & Maintenance Prepare SOP for SAS users. Perform server upgrade and migration activities. & Perform server performance monitoring and evaluation. Maintenance 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 Feed Issues Investigate issue of multiple C_BioSense_FacilityIDs for one MFT record. Onboarding Internal Technical Support testing of AMC AD User Stories. Support Legacy Data Send out legacy communications surrounding Quality Assurance to 10 sites. Analytics 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.
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.
WeeklyGovernanceReport07282017.docx