Systems Analyst Capstone Project 

This module focuses on planning and process modeling for the unified IT solution. You will create key project management artifacts such as a Work Breakdown Structure (WBS), a traceability matrix, and a risk register tailored to healthcare scenarios such as data breaches and system downtime. You will also develop SWOT analyses and visualize core patient workflows, such as appointment scheduling and billing using flowcharts and UML-based diagrams. These models will be validated using real data trends and stakeholder feedback to ensure alignment with project goals and user needs.

In this module, you will work with real-world healthcare datasets to prepare, clean, and visualize patient and operational data. You’ll identify key fields in patient, appointment, and billing records, clean and format data in Excel, and verify its quality using a structured checklist. You’ll then create basic bar and line charts to highlight appointment volumes and billing trends. Finally, you’ll use an analytics platform to build interactive dashboards with filters and visualizations that help stakeholders explore patterns in patient satisfaction and wait times.

This module focuses on designing the system architecture and database schema for XYZ Health Solutions’ IT solution. You will model key system interactions using UML diagrams, such as use case and sequence diagrams, to represent patient management workflows. In parallel, you will analyze business requirements to identify core data entities, create conceptual and logical ERDs, and apply normalization through 3NF. You’ll then translate these designs and compile a detailed data dictionary to support implementation and documentation.

You will begin by reviewing and annotating test plans for completeness and alignment, using traceability matrices to ensure full requirement coverage. You’ll then design and write test cases using test-driven development (TDD) to validate system logic and behavior-driven development (BDD) scenarios using Gherkin syntax to capture realistic user interactions. Building on this, you will define a CI/CD pipeline by outlining deployment stages, stakeholder responsibilities, and coordination checkpoints with QA. You will also develop a monitoring plan by identifying system KPIs, setting alert triggers, and defining response strategies for incidents and post-mortems. These activities are designed to enhance system reliability, streamline collaboration across teams, and ensure readiness for deployment in production environments.

In this module, you will compile all project deliverables into a final presentation that outlines the complete IT solution for XYZ Health Solutions. You’ll develop a PowerPoint presentation showcasing key outputs, such as diagrams, dashboards, and reports, and submit it for peer review. This module also contains bonus lessons where you’ll shift your focus from project execution to career readiness. You’ll begin by creating your resume, cover letter, and personal portfolio to showcase your project work, including the IT solution for XYZ Health Solutions. Then, you’ll explore career paths, refine your job search strategies, and practice common interview questions.