Success Story
Data engineering
Healthcare
Now we are working on a clinical study data synchronization portal requested by a clinical trial company for exporting data from their internal eClinical source system to sponsor platforms. The solution is designed to:
- automate transfer of patient visit data by synchronizing it across two systems,
- and reduce human-made errors by avoiding the need for double data entry,
which, in its turn, allows
a medical research company
to accelerate clinical research timeline
a pharmaceutical company
to bring new medications to the market faster
Project details
Country:
United States of America
Industry:
Healthcare (clinical trials)
Expertise used:
Data engineering
Team composition:
- Data Engineer
- Frontend Developer
- Project Manager
- QA Engineer
- UI/UX Designer
Service provided:
- Software and data architecture
- API integration
- UI/UX design
- MVP building
- Manual QA
Project background
The customer is a clinical trial company that conducts research on the effectiveness and safety of study drugs. They collect patient visit details gathered from feedback, questionnaires, and various clinical assessments, which are then manually entered into two data systems for further research, reporting, and trial outcome analysis usage.
These data source and target systems are for initial data capture and for comprehensive data management and regulatory reporting, accordingly. The whole process is required by the client’s sponsor, a pharmaceutical company, for regulatory compliance purposes.
Challenge
However, there is an issue with manual double data entry, which creates inefficiencies in the workflow, results in increased workload, a risk of human error, and delayed data processing. That’s why an automated data synchronization solution is needed to streamline the clinical trial data input process and enhance overall productivity in managing the said data.
Tech stack
Python
AWS
Discovery phase results
- We have defined the appropriate AWS architecture for data storage and computation;
- Infrastructure has been developed to display aggregated visit data, enhancing productivity and debugging capabilities;
- Our software design is scalable and allows easy additional providers integration in future.
Solution in progress
We offer the capability to export data automatically to provider’s site along with corresponding information in a few clicks up to 30 minutes of data being available in the data source system as expected. The solution will cover the following functionalities:
- User authentication: User will be able to securely log in to the system using designated login credentials;
- Real-time data reflection: Upon entry of study/visit information in the data source system, it seamlessly reflects within our portal, ensuring real-time data synchronization;
- Comprehensive study/visit overview: User has access to a comprehensive list of all studies/visits, accompanied by their respective statuses.
- Configuration: Study configuration involves entering configuration details directly into the database. Mapping information is added to ensure only necessary data is copied to the data target system;
- Automated data copying: Once configuration is done and a “Ready for Export” status for a visit is set, validated data from the data source system is automatically copied to the data target system in a few clicks up to 30 minutes as expected;
- Integrity preservation: Visits are copied post-configuration to uphold the integrity of previously synchronized historical data, ensuring data consistency and accuracy.
- Status tracking: User can conveniently monitor each visit status, which can be categorized as follows:
- Exported:Data has been successfully exported.
- Failed: The data migration process is not done.
- In Progress: Data is transferring to target system.
- Not Ready for Export: Data entry is not finished or verified.
- Ready for Export: Visit data is entered and validated.
Clinical trial data for synchronization
- Vital signs and physical measurements;
- Study-specific clinical data;
- Screening and consent data;
- Patient responses and questionnaires.
Data synchronization portal benefits
Increased efficiency
By eliminating the need for manual data entry, significant time savings and a reduction in human errors are anticipated. This streamlined process allows research teams to focus more on critical tasks related to delivering high-quality research results and improving their effectiveness.
Improved data accuracy
Automation minimizes the risk of data entry errors, ensuring the integrity and accuracy of information transferred between systems. This accuracy is crucial for maintaining the quality and reliability of clinical research data, ultimately leading to more robust study outcomes and conclusions.
Faster study timelines
Researchers will have access to updated study data, enabling them to make timely decisions and adjustments as needed. Expecteddata transfer to provider’s sites up to 30 min of availability in thesource system expedites the research process, from data collection to analysis.
Better resource utilization
By cutting manual data entry and transfer workload, the client will be able to allocate resources more efficiently. Researchers and coordinators can redirect their efforts towards higher-value tasks, such as patient recruitment, protocol development, and data interpretation.
Scalability and flexibility
The solution being implemented is designed to accommodate future growth and changes in research needs. It will be possible to integrate new sponsor provider systems, expand study portfolios, and adapt to evolving data management requirements upon the client’s request in the future.
Who can be interested?
Our portal is suitable for clinical research organizations, pharmaceutical companies, healthcare providers, biotech companies, and other medical institutions, seeking to achieve faster and more accurate data management, interoperability, governance, and streamline the overall workflow.
Learn our clients’ experience
GreenM brings both deep expertise and a highly effective development team to every project they work on. In my time working with GreenM at NRCHealth, they not only delivered every project to spec and on time, but also elevated the level of our whole engineering department with their organizational and architectural best practices.
Alex Gallichotte
BI Department Lead, Fair
Great communication, fantastic partner, really smart about data and health data in particular. Senior Management are some of the best technical people I’ve ever worked with in more than 13 years. They consistently exceed expectations.
Nathan Seaman
VP of Product, Human API
GreenM team has a lot of experience with AWS. They have deployed several solutions. Their knowledge is up to date and I’d highly recommend them to anyone who needs to build BI/analytics leveraging AWS.
Leonid Nekhymchuk
Chief Technical Officer, VisiQuate Inc.
We have worked with Alexey and the team at GreenM on many projects and have consistently been impressed with the quality of their work. They hire very highly skilled individuals and strive to understand not just our immediate needs but the underlying issues and how we can improve the process.
Daniel Sherer
Chief Technical Officer, MedASTUTE Consulting, LLC
I’ve leveraged technical help from GreenM on numerous consulting projects from basic AWS setup and administration to implementing complex design using serverless managed AWS services for rapid development of scalable solutions to clients. GreenM has always delivered on-time and is a great partner to collaborate with.
BJ Choi
SVP Engineering, Quantive Radianse
GreenM is Starschema’s key partner from 2021. GreenM provided its services at a time when the market was looking for the most talented resources who are not only experienced but can also quickly manage the constantly changing technology world. GreenM quickly adapted to the Starschema working culture and high standards, and delivered technical professionals who could blend in easily. GreenM is a highly recommended partner for supporting the growth of any technical company with highly skilled and motivated professionals.
Istvan Kovacs
Delivery Lead, Starschema Ltd.
More case studies
We created a property auction product from scratch with only client's idea. Its goal was to streamline the property buying and selling process, make it intuitive, scalable, and transparent to all users.
MVP development
Real estate
- 200 req/sec can be handled by new bidding website
- 4 mos took to get MVP out + first agents enrolled
- up to 1,000 users can use the site concurrently
We crafted TreviseAI, a customer feedback analysis tool, which helps to transform reviews into actions, get customized responses, monitor critical sentiment shifts, and discover actionable insights.
AdTech
AI transformation
eCommerce
Healthcare
- It took us 2 months to release the MVP version
- 5 teammates were involved in the process
- 3,000 characters may be processed at a time
We conducted a Tableau implementation audit for the AdTech company to identify and resolve bottlenecks in their tool performance. The goal was to enhance the speed and efficiency of their Tableau dashboards and reports.
AdTech
BI & data analytics
Tech consulting
- It took us 80 hours to issue the report
- 3 data experts were assigned to audit Tableau
- Tool was enhanced by 50% due to our suggestions
View all case studies
We inform you that this site uses own, technical and third parties cookies to make sure our web page is user-friendly and to guarantee a high functionality of the webpage. By continuing to browse this website, you declare to accept the use of cookies.
Accept Privacy policy
Copyright © 2024 GreenM, Inc. All rights reserved.