Digitalising QA & Data Integrity in Aseptic Manufacturing
Supported audit trail review, data flow risk assessments, and digital QA tooling to strengthen data integrity across aseptic manufacturing sites.
Client
Global pharmaceutical company
Industry
Pharma / QA
Role
QA Data Scientist
Timeframe
2022-2024
Location
Copenhagen, Denmark
Published
Jun 1, 2024
Context
Auditability and data integrity are mission-critical in aseptic manufacturing. The organisation needed consistent audit trail review, clearer data flows between systems, and fewer spreadsheet-driven QA processes. Multiple sites, varied system maturity, and strict validation standards made execution difficult.
Initiatives
- Audit Trail Review (Phase 1 & 2): scoped GxP-relevant systems, aligned risk-based review frequency, and created templates and SOP-aligned guidance. Built overviews so QA and management could track completion, open findings, and support needs across sites.
- Data flow risk assessments: mapped how data moved between systems, identified integrity gaps, and prioritised mitigations that fed into future digital solutions.
- Digital QA tools: delivered Power Apps and Power Automate flows for QA workflows, plus ServiceNow dashboards for QA oversight of incidents, changes, and configuration on GxP systems.
- Reporting & visibility: built Power BI/Tableau views of quality KPIs so oversight moved from email summaries to live dashboards.
- Governance & lifecycle: outlined a pragmatic development lifecycle (idea → analysis → build → test → release → operate) that keeps Agile iterations aligned with validation expectations; refreshed SharePoint IA to make digital QA work and governance discoverable.
Impact
- Harmonised, risk-based ATR practices with clear ownership between QA, IT, and system managers.
- Reduced manual QA admin through structured apps and automated routing/reminders.
- Better inspection readiness via consistent evidence and dashboards instead of scattered files.
- Reusable patterns for Agile-but-compliant delivery on Power Platform and ServiceNow.
Related work and writing
Replaced scattered timesheets and manual payroll processes with a single source of truth. Consultants log hours in one system, managers approve in real-time, and exports are audit-ready by default.
Replaced cash handling at the company canteen with NFC tap-to-buy. Employees tap badges, purchases sync to payroll, and the canteen eliminated cash entirely.
How a three-person dev team at a Copenhagen consultancy decided what to build, what to buy, and what to hybridise, and why those decisions weren't really about preferences.
The steps I use to go from a sentence-long idea to a scoped, buildable MVP with realistic trade-offs.