Successful data export automation for ZenQMS customers, by leveraging Lambda, Glue workflows and S3 buckets.
Successful data export automation for ZenQMS customers, by leveraging Lambda, Glue workflows and S3 buckets.
ZenQMS
United States
Software Development
www.zenqms.com
Public
51-200 Employees
Successful data export automation for ZenQMS customers, by leveraging Lambda, Glue workflows and S3 buckets.
ZenQMS needed to provide a secure and efficient way for its customers to access and download data in CSV format. Each customer can define data set with filter that needs to be exported based on a predefined schedule. The process had to be automated to minimize manual effort, including notifications in case of failure or success. Customers will be notified once their export is ready to download.
The proposed solution involved the use of Terraform scripts to provision infrastructure. Glue Workflows were scheduled using CloudWatch Event Rules, which triggered Lambda function with configurations for each member. Glue workflows were then started for one or more members, and Glue jobs were used to submit export queries to export specific data for each member. The exported data was stored in CSV files in the respective S3 path, and it was packaged into a zip file. The Notification job then sent an email with a pre-signed URL to the S3 zip file. In case of any failure during the process, notifications were sent to the respective stakeholders.
NETSOL successfully implemented an automated data export process while managing access to specific data, effectively reducing manual efforts. This automated process helped ZenQMS to achieve and deliver improved services to their users, enhancing customer satisfaction.
Industry Vertical: Life Sciences
Business Opportunity:The customer required a GenAI-powered solution for NLP querying of data to gain visualization insights. Data was migrated from on-premises to AWS and NetSol utilized the migrated data to create visualizations.
Our Solution:
Utilizing Amazon QuickSight Q’s latest features to reduce time to meaningful insights with user-friendly self-service.
Developed dynamic dashboards that visually convey insightful results, enhancing data interpretation and decision-making.
Business Outcome
Data Insights showing real-time results.
Boosted efficiency in key metrics analysis.
Industry Vertical: Digital Media
Business Opportunity
Our solution seamlessly generates captivating images inspired by space odyssey themes using prompts and can be customized for all diverse use cases leveraging enhanced prompts.
Our Solution
Implemented a solution using Amazon SageMaker – Stable diffusion model for image generation.
Deployed the model on SageMaker for inference.
Prompts were shared by users and fed to the model.
Amazon Comprehend was used to ensure positive prompts, optimizing the image generation process.
Enhanced the prompts to generate an image in space Odyssey.
Business Outcome: Our solution seamlessly generates captivating images using prompts which can be easily enhanced.
Business Opportunity:
Developing a website Chabot solution to increase content localization for an increased customer outreach and engagement.
Our Solution
HTML pages were transformed into text, leveraging an embedding model from Amazon Bedrock service to index the data in an Amazon OpenSearch vector database.
Amazon Bedrock Claude model was used for text generation, enabling advanced capabilities in responding to user queries in different language.
Business Outcome
Improved User Engagement
Increased customer outreach
increased user retention and engagement
Positive customer satisfaction
Potential lead generation
Efficiency and Productivity
Industry Vertical: Life Sciences
Business Opportunity: The customer required automation to extract key data points from a large repository of legal documents.
Our Solution:
Leverage Amazon Textract to convert legal documents to text.
Utilized Amazon Bedrock to search and extract required data points.
Developed dynamic dashboards to enhance data interpretation.
Business Outcome
Empowered decision-making through comprehensive insight.
Boosted efficiency in key metrics analysis.
Industry Vertical: Life Sciences
Business Opportunity: Customer requested a GenAI Proof of Concept (POC) on querying medical and research data. The Solution empowered users to seamlessly retrieve pertinent information from documents through intuitive Natural Language Processing (NLP) queries.
Our Solution:
Leveraging Amazon Bedrock Knowledge base for efficient document indexing, enhancing search capabilities.
Amazon Bedrock was used for dynamic text generation and intelligent content creation.
Business Outcome:
Automated search capability with Natural Language.
Reduced time and cost for searching key info.
Industry Vertical: Aviation / Aerospace
Business Opportunity
The customer wanted to explore the potential of GenAI to enable NLP search of airline maintenance manuals allowing technicians to quickly identify the most relevant solutions and troubleshooting steps.
Our Solution
Business Outcome