Mi-TRAC Next Phase - Gantt Chart Data

Project Timeline Summary

PhaseStartEndDurationKey Milestone
Phase 1Week 1 Day 1Week 2 Day 38 daysDemo 1: Data Import
Phase 2Week 2 Day 4Week 5 Day 517 daysDemo 2: RBAC + Resident Access
Phase 3Week 6 Day 1Week 7 Day 510 daysDemo 3: ILP Generator

Total Duration: 7 weeks (35 working days)

Visual Timeline (All Phases)

gantt
    title Mi-TRAC Next Phase - Full Timeline
    dateFormat  YYYY-MM-DD
    excludes    weekends

    section Phase 1
    Schema Design           :p1_schema, 2025-01-06, 2d
    DB Tables & Migrations  :p1_tables, after p1_schema, 2d
    Excel Parser            :p1_parser, 2025-01-09, 2d
    Form Extractor          :p1_extract, after p1_parser, 2d
    Excel Importer          :p1_import, 2025-01-13, 2d
    Admin Endpoints         :p1_endpoints, after p1_import, 1d
    Demo 1                  :milestone, p1_demo, 2025-01-15, 0d

    section Phase 2
    Users & Mappings        :p2_users, 2025-01-16, 2d
    RBAC Foundation         :p2_rbac, after p2_users, 5d
    Multi-Dept Support      :p2_dept, 2025-01-27, 4d
    Dynamic UI              :p2_ui, 2025-01-27, 5d
    Resident Dashboard      :p2_resident, 2025-02-03, 4d
    Testing                 :p2_test, after p2_resident, 1d
    Demo 2                  :milestone, p2_demo, 2025-02-07, 0d

    section Phase 3
    Trajectory & AI         :p3_traj, 2025-02-10, 5d
    ILP Template            :p3_template, 2025-02-13, 2d
    Word Generator          :p3_word, 2025-02-17, 4d
    Integration             :p3_int, after p3_word, 2d
    Demo 3                  :milestone, p3_demo, 2025-02-21, 0d

Detailed Task Schedule

PHASE 1: OB-GYN Data Foundation (Week 1 - Week 2 Day 3)

Note: Phase 1 is pure data import. User/identity tables are created in Phase 2 with RBAC.

Task IDTask NameStartEndDurationDependenciesDeliverable
1.1.1Schema DesignW1D1W1D22d-Design doc
1.1.2Departments TableW1D2W1D20.5d1.1.1Migration
1.1.3Form Definitions TableW1D2W1D31d1.1.1Migration
1.1.4Evaluation Responses TableW1D3W1D30.5d1.1.3Migration
1.1.5Run MigrationsW1D4W1D40.5d1.1.2-1.1.4DB ready
1.2.1Excel ParserW1D4W1D51d-Python module
1.2.2Form Definition ExtractorW1D5W2D11.5d1.2.1Python module
1.2.3Excel ImporterW2D1W2D21.5d1.1.4, 1.2.2Python module
1.3.1Excel Upload EndpointW2D2W2D20.5d1.2.3API endpoint
1.3.2Data Verification EndpointW2D3W2D30.5d1.3.1API endpoint
1.3.3Integration TestingW2D3W2D30.5d1.3.1, 1.3.2Test suite
DEMO 1Phase 1 DemoW2D3W2D3-All Phase 1Checkpoint
gantt
    title Phase 1: OB-GYN Data Foundation
    dateFormat  YYYY-MM-DD
    excludes    weekends

    section Schema Design
    Schema Design Document      :1_1_1, 2025-01-06, 2d

    section Database Tables
    Departments Table           :1_1_2, 2025-01-07, 1d
    Form Definitions Table      :1_1_3, 2025-01-07, 2d
    Evaluation Responses Table  :1_1_4, after 1_1_3, 1d
    Run Migrations              :1_1_5, after 1_1_4, 1d

    section Import Pipeline
    Excel Parser                :1_2_1, 2025-01-09, 2d
    Form Definition Extractor   :1_2_2, after 1_2_1, 2d
    Excel Importer              :1_2_3, 2025-01-13, 2d

    section Admin Verification
    Excel Upload Endpoint       :1_3_1, after 1_2_3, 1d
    Data Verification Endpoint  :1_3_2, 2025-01-15, 1d
    Integration Testing         :1_3_3, 2025-01-15, 1d
    DEMO 1                      :milestone, demo1, 2025-01-15, 0d

PHASE 2: RBAC + Multi-Dept + Resident Access (Week 2 Day 4 - Week 5)

Note: Includes Epic 2.0 for User & Identity Foundation (users table, learner mappings).

Task IDTask NameStartEndDurationDependenciesDeliverable
Epic 2.0: User & Identity Foundation
2.0.1Users TableW2D4W2D40.5dPhase 1Migration
2.0.2Learner Mappings TableW2D4W2D50.5d2.0.1Migration
2.0.3CSV Mapping ImporterW2D5W2D50.5d2.0.2Python module
2.0.4CSV Upload EndpointW2D5W3D10.5d2.0.3API endpoint
Epic 2.1: RBAC Foundation
2.1.1Role Permissions MatrixW3D1W3D10.5d2.0.1Doc
2.1.2Roles ImplementationW3D1W3D21d2.1.1Code
2.1.3Auth Middleware RefactorW3D2W3D42d2.1.2Middleware
2.1.4Role DecoratorW3D4W3D40.5d2.1.3Decorator
2.1.5Data Filtering LayerW3D4W3D51.5d2.1.4, 2.0.2Query layer
Epic 2.2: Multi-Department Support
2.2.1Department ParameterW4D1W4D11d2.1.5API updates
2.2.2Department SwitcherW4D2W4D21d2.2.1UI component
2.2.3EM Data MigrationW4D3W4D42dPhase 1Migration
2.2.4Seed OB-GYN DepartmentW4D1W4D10.5dPhase 1Seed data
Epic 2.3: Dynamic UI
2.3.1Dynamic Form Definitions APIW4D1W4D10.5dPhase 1API
2.3.2Frontend Dynamic ColumnsW4D1W4D32.5d2.3.1JS updates
2.3.3Dynamic ReportsW4D3W4D41.5d2.3.2UI updates
2.3.4Answer Type HandlingW4D4W4D51d2.3.2JS updates
2.3.5Form Type SelectorW4D5W5D11d2.3.2UI component
2.3.6Comments DisplayW5D1W5D10.5d2.3.4UI component
Epic 2.4: Resident Self-Service
2.4.1Resident Login FlowW5D1W5D10.5d2.1.3Auth flow
2.4.2Personal Data APIW5D1W5D21.5d2.1.5, 2.0.2API endpoint
2.4.3Resident DashboardW5D2W5D42.5d2.4.2UI page
2.4.4No-Data HandlingW5D4W5D40.5d2.4.3Error handling
2.XIntegration & TestingW5D5W5D51dAll Phase 2Test suite
DEMO 2Phase 2 DemoW5D5W5D5-All Phase 2Checkpoint
gantt
    title Phase 2: RBAC + Multi-Dept + Resident Access
    dateFormat  YYYY-MM-DD
    excludes    weekends

    section Epic 2.0 Users
    Users Table                 :2_0_1, 2025-01-16, 1d
    Learner Mappings Table      :2_0_2, after 2_0_1, 1d
    CSV Mapping Importer        :2_0_3, after 2_0_2, 1d
    CSV Upload Endpoint         :2_0_4, after 2_0_3, 1d

    section Epic 2.1 RBAC
    Role Permissions Matrix     :2_1_1, 2025-01-20, 1d
    Roles Implementation        :2_1_2, after 2_1_1, 1d
    Auth Middleware Refactor    :2_1_3, after 2_1_2, 2d
    Role Decorator              :2_1_4, after 2_1_3, 1d
    Data Filtering Layer        :2_1_5, after 2_1_4, 2d

    section Epic 2.2 Multi-Dept
    Department Parameter        :2_2_1, 2025-01-27, 1d
    Department Switcher         :2_2_2, after 2_2_1, 1d
    EM Data Migration           :2_2_3, 2025-01-29, 2d
    Seed OB-GYN Department      :2_2_4, 2025-01-27, 1d

    section Epic 2.3 Dynamic UI
    Dynamic Form Definitions API :2_3_1, 2025-01-27, 1d
    Frontend Dynamic Columns    :2_3_2, after 2_3_1, 3d
    Dynamic Reports             :2_3_3, after 2_3_2, 2d
    Answer Type Handling        :2_3_4, 2025-01-30, 2d
    Form Type Selector          :2_3_5, 2025-01-31, 2d
    Comments Display            :2_3_6, 2025-02-03, 1d

    section Epic 2.4 Resident
    Resident Login Flow         :2_4_1, 2025-02-03, 1d
    Personal Data API           :2_4_2, after 2_4_1, 2d
    Resident Dashboard          :2_4_3, after 2_4_2, 3d
    No-Data Handling            :2_4_4, after 2_4_3, 1d
    Integration Testing         :2_x, after 2_4_4, 1d
    DEMO 2                      :milestone, demo2, 2025-02-07, 0d

PHASE 3: ILP Generator (Weeks 6-7)

Task IDTask NameStartEndDurationDependenciesDeliverable
3.1.1Trajectory Data APIW6D1W6D10.5dPhase 2API endpoint
3.1.2Trajectory VisualizationW6D1W6D21.5d3.1.1Chart component
3.1.3Expected Level DataW6D2W6D20.5d-Config/data
3.1.4Expected Level ComparisonW6D2W6D31d3.1.2, 3.1.3UI overlay
3.1.5AI Comments AdaptationW6D3W6D41.5dPhase 1Python module
3.1.6Comment Summaries ViewW6D4W6D51d3.1.5UI component
3.2.1ILP Schema DesignW6D4W6D51d-Design doc
3.2.2Reflection Prompts TableW6D5W6D50.5d-Migration
3.2.3Seed PromptsW7D1W7D10.5d3.2.2Seed data
3.2.4Data Pre-population ServiceW7D1W7D21.5d3.1.6, 3.2.3Python module
3.2.5Word Doc GeneratorW7D1W7D32.5d3.2.1Python module
3.2.6ILP Download EndpointW7D3W7D30.5d3.2.4, 3.2.5API endpoint
3.2.7Download Button UIW7D4W7D40.5d3.2.6UI button
3.2.8Integration TestingW7D4W7D51dAll Phase 3Test suite
DEMO 3Final DemoW7D5W7D5-All Phase 3COMPLETE
gantt
    title Phase 3: ILP Generator
    dateFormat  YYYY-MM-DD
    excludes    weekends

    section Epic 3.1 Dashboard
    Trajectory Data API         :3_1_1, 2025-02-10, 1d
    Trajectory Visualization    :3_1_2, after 3_1_1, 2d
    Expected Level Data         :3_1_3, 2025-02-11, 1d
    Expected Level Comparison   :3_1_4, after 3_1_2, 1d
    AI Comments Adaptation      :3_1_5, 2025-02-12, 2d
    Comment Summaries View      :3_1_6, after 3_1_5, 1d

    section Epic 3.2 ILP
    ILP Schema Design           :3_2_1, 2025-02-13, 2d
    Reflection Prompts Table    :3_2_2, 2025-02-14, 1d
    Seed Prompts                :3_2_3, 2025-02-17, 1d
    Data Pre-population Service :3_2_4, after 3_2_3, 2d
    Word Doc Generator          :3_2_5, 2025-02-17, 3d
    ILP Download Endpoint       :3_2_6, after 3_2_5, 1d
    Download Button UI          :3_2_7, after 3_2_6, 1d
    Integration Testing         :3_2_8, after 3_2_7, 1d
    DEMO 3 (FINAL)              :milestone, demo3, 2025-02-21, 0d

Milestone Summary

MilestoneDateWhat’s DemonstratedStakeholders
Demo 1Week 2 Day 3OB-GYN data imported, admin verification worksTech Lead, PM
Demo 2End of Week 5PD and Resident login with proper access, form toggleTech Lead, PM, OB-GYN PD
Demo 3End of Week 7Full ILP flow - trajectory, summaries, Word downloadAll stakeholders

Critical Path

The critical path determines the minimum project duration:

1.1.1 Schema Design2d 1.1.3 Form Definitions1d 1.2.3 Excel Importer1.5d 2.0.1 Users Table0.5d 2.1.3 Auth Middleware2d 2.1.5 Data Filtering1.5d 2.4.2 Personal Data API1.5d 2.4.3 Resident Dashboard2.5d 3.1.2 Trajectory Viz1.5d 3.2.4 Data Pre-pop1.5d 3.2.6 ILP Download0.5d

Critical Path Duration: ~17 days Buffer: ~18 days (total 35 days)

Resource Loading

WeekPrimary FocusHoursParallel Tasks
Week 1Schema + Migrations40hNone
Week 2Import Pipeline + Users Foundation40hUser tables start mid-week
Week 3RBAC Foundation40hNone
Week 4Dynamic UI + Multi-Dept40hEM Migration (can parallel)
Week 5Resident Dashboard40hTesting
Week 6Trajectory + AI Comments40hILP Schema Design
Week 7Word Generator + Integration40hTesting

Total Estimated Hours: 280 hours (7 weeks x 40 hours)

Import Format for Project Tools

CSV Format (for import to Asana, Monday, etc.)

Task ID,Task Name,Phase,Start Week,Start Day,End Week,End Day,Duration (days),Dependencies,Assignee,Status
1.1.1,Schema Design,Phase 1,1,1,1,2,2,,Unassigned,Not Started
1.1.2,Departments Table,Phase 1,1,2,1,2,0.5,1.1.1,Unassigned,Not Started
1.1.3,Form Definitions Table,Phase 1,1,2,1,3,1,1.1.1,Unassigned,Not Started
1.1.4,Evaluation Responses Table,Phase 1,1,3,1,3,0.5,1.1.3,Unassigned,Not Started
1.1.5,Run Migrations,Phase 1,1,4,1,4,0.5,1.1.2|1.1.3|1.1.4,Unassigned,Not Started
1.2.1,Excel Parser,Phase 1,1,4,1,5,1,,Unassigned,Not Started
1.2.2,Form Definition Extractor,Phase 1,1,5,2,1,1.5,1.2.1,Unassigned,Not Started
1.2.3,Excel Importer,Phase 1,2,1,2,2,1.5,1.1.4|1.2.2,Unassigned,Not Started
1.3.1,Excel Upload Endpoint,Phase 1,2,2,2,2,0.5,1.2.3,Unassigned,Not Started
1.3.2,Data Verification Endpoint,Phase 1,2,3,2,3,0.5,1.3.1,Unassigned,Not Started
1.3.3,Integration Testing,Phase 1,2,3,2,3,0.5,1.3.1|1.3.2,Unassigned,Not Started
DEMO 1,Phase 1 Demo,Phase 1,2,3,2,3,0,1.3.3,Unassigned,Not Started
2.0.1,Users Table,Phase 2,2,4,2,4,0.5,DEMO 1,Unassigned,Not Started
2.0.2,Learner Mappings Table,Phase 2,2,4,2,5,0.5,2.0.1,Unassigned,Not Started
2.0.3,CSV Mapping Importer,Phase 2,2,5,2,5,0.5,2.0.2,Unassigned,Not Started
2.0.4,CSV Upload Endpoint,Phase 2,2,5,3,1,0.5,2.0.3,Unassigned,Not Started
2.1.1,Role Permissions Matrix,Phase 2,3,1,3,1,0.5,2.0.1,Unassigned,Not Started
2.1.2,Roles Implementation,Phase 2,3,1,3,2,1,2.1.1,Unassigned,Not Started
2.1.3,Auth Middleware Refactor,Phase 2,3,2,3,4,2,2.1.2,Unassigned,Not Started
2.1.4,Role Decorator,Phase 2,3,4,3,4,0.5,2.1.3,Unassigned,Not Started
2.1.5,Data Filtering Layer,Phase 2,3,4,3,5,1.5,2.1.4|2.0.2,Unassigned,Not Started
2.2.1,Department Parameter,Phase 2,4,1,4,1,1,2.1.5,Unassigned,Not Started
2.2.2,Department Switcher,Phase 2,4,2,4,2,1,2.2.1,Unassigned,Not Started
2.2.3,EM Data Migration,Phase 2,4,3,4,4,2,DEMO 1,Unassigned,Not Started
2.2.4,Seed OB-GYN Department,Phase 2,4,1,4,1,0.5,DEMO 1,Unassigned,Not Started
2.3.1,Dynamic Form Definitions API,Phase 2,4,1,4,1,0.5,DEMO 1,Unassigned,Not Started
2.3.2,Frontend Dynamic Columns,Phase 2,4,1,4,3,2.5,2.3.1,Unassigned,Not Started
2.3.3,Dynamic Reports,Phase 2,4,3,4,4,1.5,2.3.2,Unassigned,Not Started
2.3.4,Answer Type Handling,Phase 2,4,4,4,5,1,2.3.2,Unassigned,Not Started
2.3.5,Form Type Selector,Phase 2,4,5,5,1,1,2.3.2,Unassigned,Not Started
2.3.6,Comments Display,Phase 2,5,1,5,1,0.5,2.3.4,Unassigned,Not Started
2.4.1,Resident Login Flow,Phase 2,5,1,5,1,0.5,2.1.3,Unassigned,Not Started
2.4.2,Personal Data API,Phase 2,5,1,5,2,1.5,2.1.5|2.0.2,Unassigned,Not Started
2.4.3,Resident Dashboard,Phase 2,5,2,5,4,2.5,2.4.2,Unassigned,Not Started
2.4.4,No-Data Handling,Phase 2,5,4,5,4,0.5,2.4.3,Unassigned,Not Started
2.X,Phase 2 Integration Testing,Phase 2,5,5,5,5,1,2.4.4,Unassigned,Not Started
DEMO 2,Phase 2 Demo,Phase 2,5,5,5,5,0,2.X,Unassigned,Not Started
3.1.1,Trajectory Data API,Phase 3,6,1,6,1,0.5,DEMO 2,Unassigned,Not Started
3.1.2,Trajectory Visualization,Phase 3,6,1,6,2,1.5,3.1.1,Unassigned,Not Started
3.1.3,Expected Level Data,Phase 3,6,2,6,2,0.5,,Unassigned,Not Started
3.1.4,Expected Level Comparison,Phase 3,6,2,6,3,1,3.1.2|3.1.3,Unassigned,Not Started
3.1.5,AI Comments Adaptation,Phase 3,6,3,6,4,1.5,DEMO 1,Unassigned,Not Started
3.1.6,Comment Summaries View,Phase 3,6,4,6,5,1,3.1.5,Unassigned,Not Started
3.2.1,ILP Schema Design,Phase 3,6,4,6,5,1,,Unassigned,Not Started
3.2.2,Reflection Prompts Table,Phase 3,6,5,6,5,0.5,,Unassigned,Not Started
3.2.3,Seed Prompts,Phase 3,7,1,7,1,0.5,3.2.2,Unassigned,Not Started
3.2.4,Data Pre-population Service,Phase 3,7,1,7,2,1.5,3.1.6|3.2.3,Unassigned,Not Started
3.2.5,Word Doc Generator,Phase 3,7,1,7,3,2.5,3.2.1,Unassigned,Not Started
3.2.6,ILP Download Endpoint,Phase 3,7,3,7,3,0.5,3.2.4|3.2.5,Unassigned,Not Started
3.2.7,Download Button UI,Phase 3,7,4,7,4,0.5,3.2.6,Unassigned,Not Started
3.2.8,Integration Testing,Phase 3,7,4,7,5,1,3.2.7,Unassigned,Not Started
DEMO 3,Final Demo,Phase 3,7,5,7,5,0,3.2.8,Unassigned,Not Started

Notes for Presentation

Key Talking Points

  1. Phased Approach: Each phase delivers tangible value with demo checkpoint
  2. Foundation First: Phase 1 schema supports all future departments, not just OB-GYN
  3. Identity in Phase 2: Users and learner mappings are part of RBAC, not data import
  4. RBAC Enables Expansion: Once Phase 2 is done, adding new departments is much easier
  5. Research Integration: Phase 3 ILP directly supports grant deliverables (AIM 1 & 2)

Risk Buffers Built In

  • Each phase has ~20% buffer time
  • Critical path is ~17 days, total schedule is 35 days
  • Parallel tasks identified where possible

Dependencies on External Teams

PhaseExternal DependencyWhen Needed
Phase 2OB-GYN learner-email mapping CSVWeek 2 Day 4
Phase 3Reflection prompts from research teamWeek 6 Day 1
Phase 3Expected level data from research teamWeek 6 Day 1
Phase 3ILP template review from research teamWeek 7 Day 3