Government data2025LEARN Québec · CRA Portal
CRA XML import portal with session auth and audit trail
An internal portal for processing Canada Revenue Agency XML data feeds — session authentication, bootstrap admin, SQLAlchemy-backed user management, and a clean audit trail.
The problem
CRA XML data was being processed manually with no access control, no audit trail, and no consistent import format. The team needed a governed portal that could be operated by non-technical staff.
Approach
- Python + SQLAlchemy backend with Alembic migrations and PostgreSQL
- Session-signed authentication with bootstrap admin creation for first-run setup
- XML parsing pipeline that validates, normalises, and imports CRA feed data
- Role-based access control with user management for the operations team
- Clean audit log records every import event, user action, and error
Outcome
- Manual CRA processing replaced with a governed, auditable portal
- Non-technical staff can import and review data without engineering support
- Full import history and error log accessible through the UI
Got a project that's been waiting too long?
We respond to every inquiry within one business day. No funnels — just a real conversation about whether we're a fit.