Iteration 3

Due: Nov 3, 2026

Planned scope: Pre-prod setup and development

Item	Description
Security (#22)	Baseline security setup. See Security.
Configuration file	Central configuration for environments and settings.
Presentation to stakeholder	Present progress and the design to the stakeholder.
Data model v1 (#25)	Implement data model v1 with tenant_id on every table. See D5.
Identifier normalization (#26)	Normalize identifiers so the same entity can be matched across sources.
Synthetic data and mock API (#50, #51, #52)	Synthetic Omerlo fixtures, a mock Omerlo server and a mutation script, so development does not wait for staging.
Omerlo connector (#23, #53, #54, #55, #56)	Verify staging, OAuth client, connector interface and fetchers, incremental sync runs, raw payload archive.
Storage and tenancy (#57, #58, #59)	Map payloads to source records, keep every version, enforce tenant scoping with a CI test.
Change detection (#60)	Added, modified and removed records between sync runs.
Fly.io spike (#64)	Find out how to deploy on Fly.io. See D1.
Demo to Omerlo (#67)	"Run sync twice, see what changed" demo for Omerlo's technical team (week of Oct 26).
Sponsor questions (#68)	Resolve the open product and data questions with the sponsor.
Legal and privacy (#34)	Review legal, licensing and privacy aspects. See Legal and Ethical Issues.
Societal impact and ethics (#35)	Societal impact, ethics and diversity statements. See Diversity Statement.
Business model and cost (#36)	Business model and project cost estimate. See Budget and Economic.
Rollout and user study (#40)	Rollout strategy and user study plan.

Tickets

Ticket	Title	Type	Status
#22	Establish security baseline	Task	Open
#23	Verify Omerlo staging access and API details	Spike	Open
#25	Implement data model v1 with tenant_id on every table	User story	Open
#26	Identifier normalization module	User story	Open
#34	Review legal, licensing and privacy aspects	Documentation	Open
#35	Write societal impact, ethics and diversity statements	Documentation	Open
#36	Define the business model and estimate project cost	Documentation	Open
#40	Define the rollout strategy and user study plan	Documentation	Open
#50	Generate synthetic Omerlo data fixtures	Task	Open
#51	Build a mock Omerlo server that serves the fixtures	Task	Open
#52	Add a mutation script to simulate changes between syncs	Task	Open
#53	Implement the Omerlo OAuth client credentials client	Task	Open
#54	Define the connector interface and Omerlo paginated fetchers	Task	Open
#55	Run incremental Omerlo syncs as recorded sync runs	Task	Open
#56	Archive raw payloads before transformation	Task	Open
#57	Map Omerlo payloads to normalized source records	Task	Open
#58	Store source records as versions without overwriting history	Task	Open
#59	Enforce tenant scoping in data access and prove it in CI	Task	Open
#60	Detect added, modified and removed records between sync runs	User story	Open
#64	Spike: deploy PULSE to Fly.io	Spike	Open
#67	Prepare the demo for Omerlo's technical team	Documentation	Open
#68	Resolve the open product and data questions with the sponsor	Documentation	Open

Overall summary

Velocity and contractor estimate

• Planned vs. done:
• What slipped:
• Done early:
• Contractor estimate for this iteration:

Retrospective

• What went well:
• What went wrong:
• Improvements:

Breakdown by individual

Member	Contributions (issues / PRs / commits)