Project Overall Status November 12 to 23 2018
Project Overall Status – November 12 to 23, 2018 Overall Schedule Y • • Program is on track and making expected progress Key activities are being executed per timeline and budget Scope Y • • Analyzing resource overlap between DG 2 and DG 3 tasks Project Plan has been baselined but will need a second baseline once training activities are defined Budget G G • Executive Summary Monitoring scope and timing of Chart of Accounts, Budgeting Tool, Continuing Education, Online Admissions Application, and OBIA implementations ctc. Link Budget currently tracking under budget: • Delayed hiring • Timing of re-implementation of solutions (Continuing Education, Online Admissions Application, Budget) Status Remediation The project is tracking per schedule and under budget. Review and definition of scope for each deployment is still underway due to the rework of key solutions. Campus Solutions Open Tab - 13/45 Financial Management Human Capital Management Deployment Group 2 (DG 2) is in the Structure Phase, focused on Local Configuration and Conversion activities. DG 2 Go-Live is scheduled for October 2019. The Global Design/Configuration Framework and previous Common Process Workshops (CPW) recommendations continue to move through governance for approval. DG 3 is gearing up as 2018 winds down: Peer Review Readiness, Dec. 5 -6; Pre Kick-Off, Dec. 10 -14. Individual College DG 3 Kick-offs will be mid-January 2019 and official DG 3 Kick-Off is Jan. 28, 2019 Faculty Workload Remediation work continues to be a priority working in parallel with the L Deployment activities. The Continuing Education RFP closed Nov. 15 and work on the OAA solution is underway. Online Admissions Solution Open Tab - 14/39 Closed Tab – 1/35 Open Tab - 09/25 Closed Tab – 0/07 Package 2 postponed until Spring Quarter due to calculations issues discovered during testing, work in progress to resolve Waiting on approval of the formula from SBCTC and then can complete the development. Waiting on migration to begin UAT Incorporated into Security Redesign FDD/TDD is complete and development work in progress Begin sub-committee in Jan 2019 to review and finalize requirements OAA workgroup to begin reviewing other OAA options Risks LEGEND: C Critical H High M Moderate H ctc. Link PMO – Guided Pathways (GP) Impact to Academic Structure M ctc. Link Campus Solutions – Student Experience in 9. 2 C Clark - Global Implementation Led by SBCTC Issues H H LEGEND: H High Medium M Medium L High ctc. Link CS – Student Financials (SF) Conversion Logic – Negative Charges/Fee Code Transfers Clark – CS Conversion of Sensitive Data Low DRS Absence Management Security Audit Controls Student Billing Budget Planning Solution Continuing Education Solution Closed Tab – 2/13 RFP closed, proposals under review. Team responding to questions to shortlist vendors, schedule demos for work group. Mitigating Actions If there’s a requirement to reconfigure the Program Plan structure, there could be a scope/budget/timeline impact. Continue to monitor GP requirements gathering via future workshop. CS team has expressed concern about how students will execute transactions in 9. 2. More FLUID development may be needed or create tiles to re-direct. CS team has been working with ctc. Link Tech team. Governance at multiple levels at Clark has been implemented. Better reporting on status is helping. Clark has suggested ctc. Link use existing listservs for the pillars regarding decisions made at SBCTC. This information has been shared with ctc. Link Communications team. Low Status Update Meeting with Student Financials (SF) team, Legacy and Technical resources on Nov. 14 to discuss and review SF extract logic for conversion. Cycle #2 data – sexual orientation and gender identity are being converted into service indicators, which makes this information available to all that are validating data. CS team did try to resolve this by getting 1 security added to this. In the future, this should not be viewable during data validation or should be uploaded 1 for a small test group or during Cycle #5.
Budget Status – as of October 31, 2018 G Christy 2
Moran Technology Quality Assurance Report Recommendations as of October 2018 Status/QA# R QA 0132 Findings Agency Financial Reporting System (AFRS) CEMLI Status is a QA concern. During the Remediation Project, due to resource constraints, this work was put on-hold. Reporting to State OFM has now resurfaced and the ctc. Link Project team needs to get this work completed and operational to meet SBCTC reporting requirements to the State OFM. Y ctc. Link Responses The AFRS CEMLI is a priority for SBCTC including the ctc. Link project. Resources are allocated to complete the AFRS CEMLI work. We will continue to track this work to make sure the work is progressing. SBCTC has requested this work be complete by new Fiscal Year, July 2018. UPDATE: The team has made great progress, but has requested a separate testing environment to complete testing. The new timeline to complete testing and the migration to production is late October 2018. Y QA 0140 The new concept for Training Delivery has major benefits for the ongoing education of college administrative staff in ctc. Link business process and People. Soft functionality. QA would recommend that the revised scope of the training model be widely communicated to the stakeholders at this time given the positive expectations for the resulting outcomes. The training team is working on the new training approach for ctc. Link. We are developing a prototype of the new approach and will evaluate once it is complete. We are also looking at the overall content development scope and looking at external vendors to help build out the self-paced training. As we finalize the approach, we will work with the colleges for feedback. Y QA 0142 QA recommends that SBCTC ensure that The Burgundy Group delivers a fully documented Technical Architecture of the ctc. Link System as they have implemented it in the Amazon Web Services environment. ctc. Link Technical and ERP Support staff require this documentation. This Technical Architecture documentation has been requested at this time. QA will continue to report on this Open item until it has been received, reviewed, and accepted. The ctc. Link Technical Project Manager will work with the SBCTC Application Services Director to work with our managed services provider Burgundy to develop the ctc. Link production and project fully documented Technical Architecture. Y QA 0143 During the FLC Phase Project, the status of CEMLI delivery and testing was problematic. Many of these CEMLIs were not delivered until 2 weeks before Go-live, were not tested, and resulted in many operational errors. QA team recommends that a list of all CEMLIs be made available for review and maintained, indicating the pillar and business process related to the CEMLI, the latest status of testing, and any issues that will impact software readiness. This list should be made the responsibility of the Pillar PM with periodic reviews with the Technical Lead responsible for CEMLIs. QA team would like to review this list monthly. Deployment Group 2 implementation includes the retrofit development for all Campus CEMLIs (Customizations), The original list had not been consistently updated so the team has rebuilt the CEMLI Master document for Project and Support in parallel with the development retrofit. 3
Moran Technology Quality Assurance Report Recommendations as of October 2018 – cont’d Status/QA# Y Findings ctc. Link Responses Y QA 0144 The current status of the Training Materials is a major area of QA concern. There approximately 60 Courses to be developed for use with DG 2 and DG 3. QA recommends that a list of all planned Training Courses be made available for review and maintained, including the status of course components including Quick Reference Guides (QRGs), Step-wise Tutorials/Instructions, On. Line References materials linked to Business Processes, and Videos. QA team would like to review this list monthly. Training is a critical area within the ctc. Link project. There is a new training manager and training approach. The scope of courses, their mode of delivery, and actual content is being evaluated by the new manager. Once the scope has been finalized, the team will begin to develop the training content as well as we are preparing for a vendor to help with the selfpaced training content. Y QA 0145 11/2/2018: The schedule for development of Training Course materials required for DG 2 has now become YELLOW and probably will be RED next month until the PMO has implemented a series of corrective actions to fully recover it. There are 60 courses to be developed. The pilot course was to be completed in September and is still not completed. QA recommends that the PMO expedite bringing on qualified contractors/consultants to recover the schedule. Training is a critical area within the ctc. Link project. There is a new training manager and training approach. The scope of courses, their mode of delivery, and actual content is being evaluated by the new manager. Once the scope has been finalized, the team will begin to develop the training content as well as we are preparing for a vendor to help with the selfpaced training content. Y QA 0146 The current delay in completing the new Security framework for the ctc. Link could benefit from the colleges completing a work effort in parallel to completion of the security software. One approach could The security redesign is currently underway and is scheduled to be be to use a spreadsheet to collect information regarding business completed on time in order to utilize it in UAT. process/tasks, approval authorizations, and assign organizational roles. OCIO Investment Plan Conditions – October 2018 Condition G Y G Status 6 OCIO approval of the 3 remediation solutions: Budgeting tool, Continuing Education Application, Online Admissions Application Planned 8 Perform a post-implementation review (lessons learned) after each deployment and post on the OCIO dashboard within 30 days of go-live Planned 4
Deployment Group 2 Timeline (High Level Phases) G Overall Timeline (All Deployments) 5
Pillar Status – November 12 to 23, 2018 Campus Solutions G Accomplished this period ü Cycle 2 data validation workshop with all DG 2 colleges ü OAA workgroup prep for application experience from other People. Soft colleges and universities ü Continue work on SAP Modification ü Continue work on Student Financials 3 rd Party Billing/Invoice ü DG 3 Business Process Fit Gap session planning ü Build High Level Business Process Flow for Endto-End Testing ü Held Dual Processing overview with Clark College Planned for next period q Continue SAP CPW modification work q Continue SF remediation work q UAT material build q Cycle 2 data validation follow up with Clark College q Continued Dual Processing testing q SF conversion logic review Planned, but not completed • n/a *If status is yellow or red, describe why. Human Capital Management Y Pillar Status – as of 6/8/2018 Accomplished this period ü Completed preparing data validation materials for Conversion Cycle 2 ü Held Conversion Cycle 2 conversion kick off sessions on Nov. 14 ü Continued configuration build out in FNC environment Planned for next period q Hold first week of Conversion Cycle 2 conversion validation support Web. Ex sessions q Complete DG 3 BPFG Session Schedule q Begin GDA content development q Complete review of preliminary security matrix for “HR Core and Base User Security” q Begin review of preliminary security matrices for TAM and Faculty Workload q Continue configuration build out in FNC environment Planned, but not completed • n/a Financials Y Accomplished this period ü Held First. Link Chart of Accounts Redesign adoption kickoff planning sessions with Tacoma CC and CCs of Spokane ü Completed preparing data validation materials for Conversion Cycle 2 ü Held Conversion Cycle 2 conversion kick-off sessions on Nov. 15 ü Continued configuration build out (including Chart of Accounts) in FNC environment Planned for next period q Hold first week of Conversion Cycle 2 conversion validation support Web. Ex sessions q Complete DG 3 BPFG Session Schedule q Provide Security Redesign Matrix information to Finance ERP Support leadership for review q Begin GDA content development q Continue configuration build out (including Chart of Accounts) in FNC environment Planned, but not completed • n/a *If status is yellow or red, describe why. DG 2 implementation work progressing on schedule but team resources continue to be involved in Production support activities, which is putting stress on implementation work due dates. Delay in review materials for Security Redesign will also put strain on activities as that work extends into December. DG 2 implementation work progressing on schedule but team resources continue to be involved in Production support activities, which is putting stress on implementation work due dates 6
Workstream Status – November 12 to 23, 2018 Communications G Accomplished this period ü Presentation and supporting materials for Nov. 15 Senate Energy, Environment & Technology Committee work session ü New diagrams for training phased approach and college trainer selection/training process ü All Hands meeting presentation coordination ü Steering Committee prep Planned for next period q ctc. Link Connect blog post q All Hands presentation q Steering Committee prep q Status Report content-tracking updates based on college feedback q Start work on Communications Work Stream Schedule in PWA Organizational Change Management Accomplished this period ü Met with CPW testing team to discuss new testing proposal ü Worked with College Relations Manager to determine next steps and crossover between OCM and College Relations ü Made an offer to OCM/ Communications Specialist candidate – starting Dec. 3. Planned for next period q Meeting with CPW Testing Team q Meeting with OCM subgroup to finalize survey q Completing Roles and Alignment document Planned, but not completed • Continuous - working with communications and training on project schedule and timelines. G Technical G Testing G Accomplished this period ü Created and socialized a single environment map across all deployment groups ü Socialized the 12 -month image update schedule with identified go-live versions ü Applied updated images to CTS and CNV environments to align with image versions in Production by year-end ü Reviewed conversion program execution times to establish a baseline end-to-end duration for conversion to apply to cutover weekend. Accomplished this period ü Functional test plan in Oracle Test Manager (OTM) is complete and ready to track progress and issues. ü Met with Kastech to develop an implementation plan and timeline. ü Continued to build the UAT framework prototype. Planned for next period q Complete the application of image updates to all pillars to align with image versions in Production by year-end q Identify delivered CI’s that are candidates for inclusion into the Integration Broker pilot effort. q Map baseline of conversion program execution times to end-to-end cutover weekend activities to assess risk of completing cutover within the allotted window. q Refresh GLD environments from updated CTS environments; this will update GLD with latest changes from Production and latest Project development changes. Planned, but not completed • Finalize the FWL end to end flow used for the UAT framework prototype so it can be vetted with internal staff and college PMs. • Finalize the UAT test plan prototype in OTM. Planned, but not completed • Identify delivered CI’s that are candidates for inclusion into the Integration Broker pilot effort—reprioritized for other efforts Planned for next period q Finalize the FWL end to end flow used for the UAT framework prototype so it can be vetted with internal staff and college PMs. q Finalize the UAT test plan prototype in OTM. Training Y Accomplished this period ü Continued work on prototype of Payroll Course, including assessments and course build in Canvas ü Finalized Training Strategy/Approach Document ü Reconciliation of 9. 0 content to 9. 2 content in ctc. Link Reference Center Planned for next period q Strong push to define training scope, work assignments, activity durations, and dependencies q Build 22 Global Design Adoption (GDA) Canvas course shells q New resource onboarding Planned, but not completed • Finalize Training Scope • Contract with vendor to build self paced training scope *If status is yellow or red, describe why. • Material build time estimate still being conducted, which has impacted ability to determine scope. 7
Deployment Group 2 Self-Reported Status – November 12 to 23, 2018 Clark College G Accomplished this period ü Held 90 -minute validation overview sessions to demonstrate to validators how Clark is conducting validation, where to find information, and basic People. Soft navigation. About 30 staff attended. ü Creating data validation files for staff to validate and track their work. ü Data Validation Labs – 11 hours of labs over 3 days have been held. ü Change Action Plans with FM teams Planned for next period q Continue data validation q Continue meetings to complete Change Action Plans q Schedule CS meetings requested by project staff G Accomplished this period ü SBCTC Liaisons & Governance meeting held (1 of 2) 11/16 ü HCM & FIN Data Validation Introduction meetings attended 11/14 -15 ü Data Validation completed for “Purchasing Orders” and “Vouchers” Planned for next period q Complete one last piece of UAT Homework ECD no later than 12/7 q Completion of HCM and FIN Data Validation effort 11/16 -12/11 q Working Group charter approved ECD 12/7 q SBCTC Liaisons & Governance meeting (2 of 2) 11/27 Planned, but not completed • Completion/approval of agency work breakdown structure to graphically represent all work needed for success, ECD 12/21/18 • Meet to discuss how contracts will go into ctc. Link and how different departments might do different parts of the work (new PM will inquire with Working Group on this) ECD 12/21/18 • Submit PS query samples/requests – (new PM will inquire with Working Group on this) ECD 12/21/18 Planned, but not completed • Update Communication Plan Community Colleges of Spokane SBCTC Agency R Accomplished this period ü 1 Finance resources focused on end of month and FY Close tasks. ü 2 Initial planning meeting for Chart of Accounts Planned for next period q Identify and follow up on any outstanding CCS BPFG homework. q Review of Finance Security Roles Matrix q Create CCS Chart of Accounts Plan q Create CCS Security Redesign Planned, but not completed *If status is yellow or red, describe why. • SBCTC progress was being made on Remediation Conditions and Items, but delays and issues have cropped up. • FY Close making progress but at Risk with no book to cash detailed reconciliation report or process. • Security Redesign slipped out to February. College implementation and mapping will be time intensive impacting all departments Tacoma Community College G Accomplished this period ü Local SMEs attend ctc. Link Security redesign group, ctc. Link PM groups, ctc. Link governance groups, various ctc. Link status meetings ü Participated in Data Validation ü Attended PM Summit ü Participated in PM training (Ivy Brent) Planned for next period q Participate in Conversion Cycle 2 Data Validation q 1099 BPFG Sessions Planned, but not completed 8
ctc. Link College Remediation Status Reports – November 12 to 23, 2018 Community Colleges of Spokane R Remediation Items progress this period 1. Closing Fiscal Years a. Absence of a book-to-bank reconciliation process impacting FY 16 Close. CCS still has an $18 million dollar variance in the “book” cash balance. b. CCS FY 16 Closing Rules adjustments for Pass 11. c. PC & CAPC journal process not run since Feb. 2018. State Auditor questioning variance with Head Start grant revenue. 2. Security role redesign – Project pushed out from September 2018 to February 2019. Finance Security Roles matrix delivered to working group 11/14. CCS to review. 3. Absence management (adjunct & part time faculty) – Completion date still TBD. 4. DRS & PEBB – Completion date still TBD 5. Faculty Workload Improvements. Onsite HCM training completed on Oct. 18. Improvements to be implemented in December 2018. 6. Student third-party billing – SBCTC request to deliver now in January 2019. CCS continues to reformat invoices manually with a labor-intensive task. CCS agreed to January 2019 delivery. *If status is yellow or red, describe why. Was finally seeing SBCTC activity with CCS key remediation conditions, but over last two weeks, issues or delays seen now with all remediation items except for the FWL Package 2 which appears to be on track. No ‘complete by’ dates yet provided for all remaining remediation items. Remediation conditions were identified in December 2016. Tacoma Community College G Accomplished this period ü Reached out to local SMEs for updates on 3 HR remediation items: 29976, 20781, and 20491 Planned for next period q Receive updates on 3 HR remediation items: 29976, 20781, and 20491 q Participate in OAA redesign options ratings q See SBCTC update on 10 remediation items Project Team R Accomplished this period ü Absence Management - Completed development and testing of all the absence balance remediation fixes. We have packaged the absence balance fixes to the CEMLI SE-231 and have migrated the CEMLI to PTS for ERP to System Integration Testing (SIT). ü Third-Party Billing – Completed 9. 0 FDD/TDD and began development work effort Planned for next period q Absence Management – The Application Services migrate the project to PQA for Colleges to UAT Test q DRS - We are waiting on approval of the formula from SBCTC and then can complete the development. q Faculty Workload - Package 2 postponed until spring quarter due to calculations issues discovered during testing; work in progress to resolve q Security Role Design – Continue to finalize new role and permission list model. q Student Third-Party Billing – Complete development and begin Functional Unit Testing and then begin System Integration Testing. q Fiscal Year – Continue to work with FY team and Reporting team on end-to-end Checklist, Queries, and Reporting needed for Month End and Year End close. *If status is yellow or red, describe why. The ctc. Link project team in partnership with the FLC’s agreed upon solution plans and completion dates for most of the remaining remediation. A number of the 40 plus remaining remediation items have missed the planned completion dates due to GDR timing, policy decisions as well as impacts from AWS migration and environmental issues. 9
Deployment Group 3: Gate 1 Initiation Phase Progress - as of Nov. 23, 2018 Cascadia Lower Columbia Olympic Peninsula Pierce Resource Plan and Budget C NR C College Project Charter C C C Baselined MS-Project Schedule C C C NR C OCM Plan C C Communication Plan C C C NR C C IP C Risk Management Plan C C C IP C Data Cleansing Plan C NR C C C Legacy Business Process Mapping IP C C NR NR Supplemental Systems Assessment C C IP C C Initiation Phase Deliverables Local College Training Plan Legend NR: Not Received, deliverable not posted to c. DR IP: In Progress, draft deliverable has been posted to c. DR C: Complete, final deliverable posted to c. DR 10
Other ctc. Link Project Activities – Status as of Nov. 23, 2018 Solution Decision New Solution Status RFP Publish Physical Inventory (Asset Tracking) • Vendor Solutions being evaluated • New PS Functionality that will provide integration for asset tracking scanners directly with ctc. Link 5/21/2018 Delayed to evaluate new functionality within PS Continuing Education • • 10/15/2018 1/1/2019 Online Admissions Application • OAA Work Group to review other US College/University Solutions • Shortlist vendors for US College/University discussions • Determine best custom or third party solution / RFP if needed • WG/SC Approval 11/1/2018 1/20/2019 Budget Planning • Begin Sub-committee start up to review, finalize and approve Budgeting requirements • Review requirements against Oracle PBCS Solution / If needed, develop RFP TBD 2/20/2019 Accessibility • Continued discussions with Appsian (formerly Grey Heller) • Working with Accessibility testing vendors to test Appsian use cases against ctc. Link. N/A 1/1/2019 Guided Pathways • Steering Committee approved approach for gathering business requirements for Guided Pathways N/A Sub-Committee responding to vendor questions Shortlist vendors for Solution Demo’s Select final solution WG/SC Approval 11
- Slides: 11