I. Executive summary
Pharmalys successfully planned and executed the controlled manual migration of approximately 7,000 Trial Master File (TMF) documents from a legacy Electronic Trial Master File (eTMF) system to our new eTMF platform. The work was delivered within three months through defined ownership, structured metadata mapping, staged upload, continuous quality control, reconciliation, and documented issue remediation. The project was completed without disrupting ongoing clinical trial activities, while maintaining regulatory compliance, document integrity, metadata accuracy, and audit trail requirements.
II. Background
The project concerned the end-to-end transfer of the electronic Trial Master File for one of our studies. The sponsor decided to transition from its legacy eTMF system to our modern, cloud-based eTMF platform to improve operational efficiency, enhance TMF quality management, and support future growth of the clinical trial portfolio.
Source documents were extracted from the legacy eTMF and made available through the source provider’s SharePoint. They were then transferred to the controlled Pharmalys SharePoint environment before being indexed, mapped, and uploaded manually into our fully validated eTMF.
III. Project objectives
The primary objectives were to:
- Transfer approximately 7,000 TMF documents from the source system to the target eTMF.
- Maintain document integrity and completeness.
- Ensure metadata accuracy and consistency.
- Preserve compliance with GCP, ALCOA+, and TMF reference model principles.
- Achieve project completion within the allocated 12-week timeframe.
IV. Migration approach
Phase 1: Assessment and Planning
At first, a comprehensive migration assessment was conducted to:
- Complete an inventory of all documents and associated metadata.
- Map source and target TMF structures.
- Identify data quality gaps and initiate remediation activities where required.
- Define migration strategy, roles, timelines and deliverables.
Phase 2: Migration Execution
1. Controlled retrieval: Documents were retrieved from the source provider’s SharePoint repository and transferred to the designated clinical electronic unit folder in Pharmalys SharePoint.
2. Pre-migration QC: The team reconciled the received files against the source eTMF to confirm document counts and check completeness. Documents were reviewed for legibility, file format, naming conventions, version accuracy, and date consistency before migration.
3. Indexing and metadata mapping: Each document was assigned to the appropriate target eTMF artifact and filing location. Required metadata were assigned in alignment with the DIA TMF Reference Model and target system requirements.
4. Document upload and filing: Documents were uploaded to the target eTMF in a controlled sequence and filed using the approved metadata structure to ensure consistency and traceability.
Phase 3: Reconciliation
- Post-upload QC and reconciliation: Following upload, documents were verified to confirm successful migration, correct filing locations, metadata accuracy, and document accessibility. Any discrepancies identified during quality control were corrected and re-verified prior to final approval.
- Closure and reporting: Trackers, issue logs, QC evidence, and the migration report were retained to demonstrate completion and inspection readiness.
V. Governance and team model
- The Clinical Trials Technologies Team Lead (CTTTL) owned the migration strategy, system access, study configuration, QC oversight, and inspection readiness controls.
- The Clinical Project Manager (CPM) monitored progress, coordinated resources, and supported QC and issue remediation activities.
- Clinical Research Associates (CRAs) supported document transfer reviews.
- The Clinical Operations and Technologies Assistant (COTA) and the Clinical Operations Assistant (COA) performed uploading, metadata entry, tracker maintenance, discrepancy escalation, and correction of QC observations.
This distribution of responsibilities created clear accountability across preparation, execution, review, and resolution.
VI. Quality and risk controls
Quality control was integrated into every stage. Pre-migration checks established the completeness and usability of the received document set.
Post-upload review verified document readability, artifact placement, and metadata accuracy in the target system. Discrepancies – including missing files, duplicates, incorrect mapping, metadata errors, and readability issues – were logged, remediated, and re-checked.
Role-based access, controlled extraction, source-to-target reconciliation, documented escalation, and retention of QC evidence reduced risks to integrity, completeness, and traceability.
VII. Key outcomes
- Approximately 7,000 documents migrated from the source eTMF to the target eTMF.
- Migration delivered within the required three-month period.
- Documents processed through a defined source-to-target workflow with controlled retrieval, mapping, upload, reconciliation, and remediation.
- Clear evidence trail maintained through trackers, issue logs, QC records, and the migration report.
- Target eTMF prepared to support ongoing study operations and inspection readiness.
VIII. The challenges
The project faced several key challenges that required close coordination and proactive risk management. Dependence on the source eTMF provider for the timely and complete extraction of legacy content posed a risk to the migration schedule, making regular reconciliation of exported files against the source inventory essential.
Metadata mapping was another challenge, as differences between the source and target eTMF structures required careful alignment of document classifications, metadata fields, and filing conventions to ensure accurate migration and retrieval.
The legacy TMF also contained data quality issues, including incomplete metadata, duplicate records, and inconsistent filing practices, which required remediation prior to migration to maintain data integrity.
Finally, extensive quality review activities were required to confirm the completeness, accuracy, and integrity of approximately 7,000 migrated documents while maintaining uninterrupted access to TMF content and preserving inspection readiness throughout the transition.
IX. Lessons learned
The project generated several valuable lessons that will value future TMF migration initiatives:
- Front-load reconciliation activities: Verifying the inventory, completeness, accuracy, and usability of source documents before migration significantly helped reduce downstream rework and prevented quality issues from being transferred to the target eTMF.
- Standardise mapping decisions: Establishing agreed artifact classifications, metadata rules and filing conventions at project initiation improved consistency, accelerated decision-making, and minimised reclassification efforts.
- Address data quality issues proactively: Conducting an early TMF inventory and metadata assessment helped identify incomplete metadata, duplicate records, and filing inconsistencies before they impacted migration activities.
- Run quality control activities in parallel with migration: Continuous QC and batch-level reconciliation enabled issues to be detected and resolved while migration was still in progress, reducing risk to project timelines and avoiding large-scale corrective actions at project close out.
- Maintain a single source of truth: A controlled migration tracker linking source documents, target locations, metadata assignments, QC status, reconciliation results, and remediation actions strengthened traceability and supported inspection readiness.
- Allocate sufficient resources for validation and reconciliation: These activities often require more effort than anticipated and should be adequately planned to avoid bottlenecks during critical project phases.
- Define escalation routes and governance early: Clear ownership, regular progress reviews, and established communication channels facilitated the rapid resolution of extraction, access, mapping, and quality issues.
- Build contingency into the project schedule: Allowing time for unexpected delays related to data extraction, remediation, or resource availability improves overall project resilience and delivery confidence.
- Promote strong cross-functional collaboration: Close partnership between TMF team, Clinical Operations, Quality, and external providers is essential for maintaining project momentum and achieving timely decision-making.
The successful completion of this project demonstrated that early planning, standardised metadata governance, continuous quality control, robust reconciliation processes, and strong stakeholder collaboration are critical to delivering a compliant, accurate, and inspection-ready TMF migration.
X. Conclusion
The successful migration of around 7,000 TMF documents within a three-month timeframe demonstrated that complex eTMF transformations can be delivered efficiently when supported by robust planning, data quality management, strong governance, and effective stakeholder collaboration. The project not only ensured continuity of compliant TMF management but also positioned the organisation for greater operational efficiency and future scalability within its clinical trial ecosystem.
Looking to optimise your TMF operations?
Pharmalys supports teams with expertise across clinical operations, eTMF management, quality and compliance. If you are planning an eTMF migration or looking to strengthen TMF processes, find out how Pharmalys can support your clinical trial operations today or contact us here.
