Manager
Current1. SMART LINK Anomaly Detection (Apr 2023 ~ ) : Smartlink is a FMS device connected to the vehicles. To secure the accuracy and confidence level of Data, it is crucial to improve data quality collected by Smartlink. For this, I - Selected main datasets necessary for the project from entire DataLake, which includes 300 tables and 7 DBs. - Analysed and visualised the data, cross-comparing log data and summarised ones. - Defined what kind of anomalies can be observed and how can they be caused (due to network, sensor or device failure,.) - Currently in the process of creating the logic to detect and deal with those errors in advance. 2. SK Direct User Tracking (Mar 2022 ~ Mar 2023) : SK Direct is a B2C long term car rental product sold via online. The goal of the project was verifying the effect of digital marketing and enhancing the conversion rate. For this I - Built the data pipeline of Google Analytics, connecting the account to the BigQuery (GCP) - Defined and revised the script code of solutions required for data collection. (GA, AceCounter and AIQUA) - Compared and connected different kind of datasets (Ads performance reports by 4 medias, web log data, contract Data) - Established a logic to distinguish users based on web ID and customer ID, and time. - Tracked entire user journey from the very first visit to the conversion. - Analysed and compared user behaviours on website, depending on the customer segments (customer type, gender, age)3. Long term Rental Analysis (Apr 2022 ~ Aug 2022) : To identify the target customer and product, promoted data based decision making - Analysed lead-time of the contract of used car, depending on the characteristics of the vehicles. - Analysed user behaviour after cancelling the contract. - Created user profile depending on the EV models, to increase the contract of a specific model.
