IT 625 Final Project Case Study: Medical Informatics Background Medical Informatics, a leading health services company, embarked on a new product development project. Medical Informatics needs to expand its clinical data warehouse (CDW) to ingest third-party data feeds from wellness vendor and onsite clinic data to incorporate this information to downstream employer group analytics and reporting processes. This expansion will also be used to develop new activity reports to message value on these products. The nature of the companys business is that it operates in an extremely competitive environment that necessitates fast delivery to market so as to prevent competitor companies from gaining dominant market share with similar competitive products. Therefore, the key success factors of the project were time to market and quality. Cost of delivery was not a major concern. Scope The scope of the project was to create a modular software package to handle wellness vendor data to ensure appropriate preventative care is being tracked for members, including the systems changes, the vendor wellness database tables, and wellness vendor reporting. The project was divided into modules consisting of: wellness DB tables, promote tables, and wellness vendor reporting. A project manager was appointed, but has since left due to personal reasons. Time Scales The launch date was set as December 21, 2017. The product had to be ready for launch on this date, as all the marketing material would reflect this date and the launch had to precede the launch of similar products from competitors. The project kickoff was May 5, 2017. The tasks that had been completed prior to May 5, 2017 were the business case compilation and approval and the project team establishment.

Forecasting: Assuming the project issues persist, provide a detailed prediction of future performance in terms of timeliness and costs. The following ideas could be considered: 1. Assumptions that guide the forecasting 2. Projected end date of the project (schedule variance) 3. Cost to complete the project (cost variance) 4. Forecasted overrun at completion (estimates at completion)

Need help with Schedule Variance, cost variance, estimates at completion.

Southern New Hampshire University Issues Actionee Action Impact (1-10) Due Date/ Status 6.1 9 JC Changes to requirements requested by the users are causing delays in project delivery Currently behind schedule with some tasks, but should be able to catch up without affecting the scheduled delivery Agree final requirements with the users Work overtime 6.2 9 JC date 6.3 8 JC Agree date with Legal Dept. Get final policy document wording from legal department Make sure Testers are available for required testing dates 6.4 8 JC Agree resources and dates for testing with user departments 7 No List of Scope Change Requests Description No official change requests to date Date Impact Client Approval 7.1 8 8.1 8.2 8.3 8.4 8.5 8.6 Major Activities for Next Period Complete programming Complete and get approval for project charter Start system testing Start planning for user acceptance test (compile test plan) Fix errors and omissions identified during testing Compile and agree implementation plan 8 Budget Tracking Task/Phase Planned Cost (Baseline) 441,650 Actual Cost to Date 230,892 Remaining Cost 210,758 Estimate at Completion 529,980 Percent Variance Wellness Vendor 20% Key Milestones Date Status 05/05/2017 Complete Project Kick-Off Meeting Work Effort Overall Project Status: Behind Complete: 24% Project Overview: The reporting analytics team needs to expand the data warehouse to ingest third party data feeds from wellness vendors. This information will be incorporated downstream to employer group analytics and reporting processes. This expansion will also be used to develop new activity reports to message value on these products. 07/31/2017 Complete Business Requirements Documented/Approved Module Implementation Module 2 Implementation Module 3 Implementation End to end Testing Move to Production Project Closure 08/31/2017 Complete 9/30/2017 Complete 10/23/2017 Issues 11/09/2017 11/27/2017 On Track 12/31/2017 On Track Issues / Risks Accomplishments this period / Next Steps Issues: Accomplishments: Additional Contractor Onboarding - complete Risks: Project Manager has left the project. Project milestones are slated to be Next Steps: behind after this week's status update. Assign Project Manger ASAP No updates at this time. New PM to be assigned. Cost Detail Analysis Update Total Approved Approved Spend 24% Complete Remaining Spend Type Total Updated Spend Spend % of Approved Hours Estimated Hours-To-Date Spend-To-Date % Spend Spend % Remaining Capital Expenditures 277,988 $50,446 18% 2,342 53 $54,458 20% $ 223,531 80% Operating Experise $ 163,662 $225 140 1,542 48 $3,825 2% $ 759,837 98% Executive Project Status Summary Project Overview: Business Reinvestment Updated Expected Completion Date: N/A Wellness Vendor Project Project Manager: TBD Project Owner: Business Owner Project Sponsor: Sr. VP Operations IS Manager: N/A Original Expected Completion Date: 12/21/2017 Southern New Hampshire University Issues Actionee Action Impact (1-10) Due Date/ Status 6.1 9 JC Changes to requirements requested by the users are causing delays in project delivery Currently behind schedule with some tasks, but should be able to catch up without affecting the scheduled delivery Agree final requirements with the users Work overtime 6.2 9 JC date 6.3 8 JC Agree date with Legal Dept. Get final policy document wording from legal department Make sure Testers are available for required testing dates 6.4 8 JC Agree resources and dates for testing with user departments 7 No List of Scope Change Requests Description No official change requests to date Date Impact Client Approval 7.1 8 8.1 8.2 8.3 8.4 8.5 8.6 Major Activities for Next Period Complete programming Complete and get approval for project charter Start system testing Start planning for user acceptance test (compile test plan) Fix errors and omissions identified during testing Compile and agree implementation plan 8 Budget Tracking Task/Phase Planned Cost (Baseline) 441,650 Actual Cost to Date 230,892 Remaining Cost 210,758 Estimate at Completion 529,980 Percent Variance Wellness Vendor 20% Key Milestones Date Status 05/05/2017 Complete Project Kick-Off Meeting Work Effort Overall Project Status: Behind Complete: 24% Project Overview: The reporting analytics team needs to expand the data warehouse to ingest third party data feeds from wellness vendors. This information will be incorporated downstream to employer group analytics and reporting processes. This expansion will also be used to develop new activity reports to message value on these products. 07/31/2017 Complete Business Requirements Documented/Approved Module Implementation Module 2 Implementation Module 3 Implementation End to end Testing Move to Production Project Closure 08/31/2017 Complete 9/30/2017 Complete 10/23/2017 Issues 11/09/2017 11/27/2017 On Track 12/31/2017 On Track Issues / Risks Accomplishments this period / Next Steps Issues: Accomplishments: Additional Contractor Onboarding - complete Risks: Project Manager has left the project. Project milestones are slated to be Next Steps: behind after this week's status update. Assign Project Manger ASAP No updates at this time. New PM to be assigned. Cost Detail Analysis Update Total Approved Approved Spend 24% Complete Remaining Spend Type Total Updated Spend Spend % of Approved Hours Estimated Hours-To-Date Spend-To-Date % Spend Spend % Remaining Capital Expenditures 277,988 $50,446 18% 2,342 53 $54,458 20% $ 223,531 80% Operating Experise $ 163,662 $225 140 1,542 48 $3,825 2% $ 759,837 98% Executive Project Status Summary Project Overview: Business Reinvestment Updated Expected Completion Date: N/A Wellness Vendor Project Project Manager: TBD Project Owner: Business Owner Project Sponsor: Sr. VP Operations IS Manager: N/A Original Expected Completion Date: 12/21/2017