Successful data export automation for ZenQMS customers, by leveraging Lambda, Glue workflows and S3 buckets.
Streamlining Data Export Process for Improved Customer Satisfaction
Streamlining Data Export Process for Improved Customer Satisfaction
Successful data export automation for ZenQMS customers, by leveraging Lambda, Glue workflows and S3 buckets.
Company Name
ZenQMS
Location
United States
Industry
Software Development
Website
www.zenqms.com
Status
Public
Size
51-200 Employees
Streamlining Data Export Process for Improved Customer Satisfaction
Problem Statement
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.
Proposed Solution Architecture
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.
Outcomes of Project & Success Metrics
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.
