User Engagement Automation
Jan 2021 ~ OMRON Healthcare
Length: 1mo (at 1.0 FTE)
Software: AWS (EventBridge, Lambda, RDS, VPC)
Programming languages:
- Python (PyMySQL, Pandas, boto3, datetime, logging)
- SQL
Data: Database schema
Problem description:
Engineer a multi-service AWS solution that identifies inactive app users to target them
with email reminders
Approach & Results:
Initially, the SQL queries that retrieve various groups of inactive patients were drafted using
the information in the database schema. Next, a Python script that connects to the
database, performs a query, and outputs the result in the correct format was written.
The code was later ported into an AWS Lambda function, connecting and retrieving
information from an Amazon RDS instance and sending the answer to Salesforce. Lastly, the
Lambda functions were triggered by an Amazon EventBridge event, depending on the desired
frequency of the query. For instance, some queries are executed daily, while others are triggered
every Friday. Consequently, the system saves OMRON Healthcare the time spent on manual, repetitive
queries and eliminates the associated risk of human error.
