Imweb Corp, 2022. 04 ~ 2022. 12
Project Summary
Imweb is a Software as a Service of e-Commerce for enterprise and individual. It makes a customer to build a website without any programming for free. It also provides e-commerce features about products, payment, transportation, etc.
C-team was interested in some metrics such as cohort retention, monthly recurring revenue and customer churn rate, etc. I led the data cube team with a mission that was to build Cloud based Data Analytics Platform for providing members with various data and some analytics tools. We had started from scratch.
Obviously, it was not enough to contain all components of data analytics platform. Because I try to apply a few components only that if it solves the problem at that time. This platform made us understand a little of our business situation.
Role
- Cloud Data Analytics Platform Development and Maintenance
- Key Performance Indicator Visualization
- Customer Churn Rate Prediction
- Service Availability & Latency Monitoring with 150M logs by day
Tech Stack
- Ingestion: AWS Glue, AWS DMS
- Storage: Amazon Aurora, Amazon S3, Redshift
- Processing: Amazon Athena, Amazon Kinesis, Python Pandas, Jenkins, PyCaret
- Service: Google sheets, Tableau, Apache Superset, Redash, AWS Lambda, AWS Fargate
Results
-
Subscription & Monthly Recurring Revenue Visualization
-
Churn Rate Prediction
-
Service Availability & Latency Monitoring