Systems Analyst Capstone Project

Overview

Demonstrate your job-ready skills in this portfolio-worthy capstone course, where you’ll apply your systems analysis, data management, and project management skills to design and evaluate real-world business systems. During this project, you’ll apply systems analysis methodologies to streamline business processes, data management, and system integration. Through hands-on labs, you’ll use requirements gathering techniques, create process models using UML diagrams, design relational databases, and build interactive dashboards using Tableau or Cognos. As you work, you’ll demonstrate your end-to-end systems analysis skills in stakeholder management, data security, and meeting compliance requirements. Plus, you’ll apply your knowledge to business requirements documentation, process modelling, and deployment using CI/CD pipelines. By the end of the course, you'll have a comprehensive capstone project that demonstrates your systems analyst expertise in addressing real organizational challenges in business process improvement. Enroll today to complete a capstone project that gives you valuable practical experience you can talk about in interviews!

Syllabus

Module 1: Project Initiation and Requirements Gathering

In this module, you will initiate the capstone project by creating key foundational documents such as the project charter, stakeholder register, and stakeholder engagement plan tailored to a healthcare setting. You will identify and engage stakeholders across patient, clinical, administrative, and IT roles using structured interviews and engagement strategies. You’ll gather, document, and validate both functional and nonfunctional requirements using tools such as BRD, SRS, and use case diagrams. You will also create a requirements traceability matrix to ensure alignment with business goals, and model processes to identify inefficiencies in areas such as patient records, scheduling, and billing.

Module 2: Project Planning and Process Modeling

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.

Module 3: Data Preparation and Visualization

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.

Module 4: System and Database Design

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.

Module 5: System Testing and Deployment Strategies

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.

Module 6: Final Submission, Evaluation, and Career Guidance

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.