Hoang Long Tran

Experience

• 

  Avery Dennison

  May 2021 - Dec 2021

  Data Analyst
• 

  The Coffee House

  Dec 2021 - May 2024

  Data Analyst / Business Intelligence

  - Analyze data to update business performance and suggest possible actions for further improvement.- Apache Superset Users Admin decentralizes view dashboard permissions for many different users in the company system.- Queries data from Google Bigquery by SQL, optimize the query and table storage for saving Google surcharge fee, create and maintain operation reports/dashboards for Operations, Delivery Operations, Commercial and E-commerce, Human Resources,... by Apache Superset, and support ad-hoc for the business teams.- Maintaining the Kariba system, which was built by Seedcom, using T-SQL for customer segmentation from brief notification content from e-commerce and user teams, showing campaigns on The Coffee House app for users. - Use Apps Script (Google Sheets) to run scheduled queries from the Google Bigquery Database to update data for Business Teams and use Python for some analysis for specific purposes.- Supports auditing of API data from MongoDB and PostgreSQL to BigQuery when something goes wrong to maintain data integrity. Show less

• 

  Marathon Education (YC W22)

  May 2023 - Sept 2023

  Teacher

  Teaching Math and Programming for students

• 

  GiaoHangNhanh (GHN)

  May 2024 - now

  Data Analytics Engineer

  - Manage and optimize processes for data acquisition, validation, mining, and engineering as well as modeling, visualization, and communication deliverables.- Using Polars and SparkSQL, SparkDataFrame for data extraction, processing, and computing metrics on ETL process. Cloud storage buckets are used on GCP (Google Cloud Platform) to store and manage data sources after the data transfer process. Scheduling for update data resources using Scheduling queries on BigQuery.- Queries data from Google Bigquery (GCP) using SQL, optimize the query and table storage for saving Google surcharge fee, create and maintain reports/dashboards. - Optimizing the process of extracting, processing, and updating data on team reports and projects. Build, develop, and maintain (or coordinate with the Data Platform and Risk management team to do) CX data models using Machine Learning models, reporting systems, data automation systems, dashboards, and performance metrics support that support key business decisions.- Oversee the design and delivery of reports and insights that analyze customer experience and performance metrics.- Ensure data accuracy and data integrity with comprehensive policies and procedures.- Implement data mining, and analysis by applying advanced data modeling, predictive modeling, and analytical techniques.Achievements: - Reduced lead time to solve ad-hoc request by average from 7 days to 1 day - Reduced lead time to update weekly report from 4.6 to 1.2 hours in total by month - %5-star evaluation increased from 75% to 90% Show less