TRAN TRUNG HIEU

🧑‍💼 Key Clients:

👉 CellphoneS, VitaDairy, MaiSon retails, VIB

✅SQL:

• Designed and implemented complex and automated ETL pipelines, processing data from multiple sources to ensure analytics readiness.
• Developed SQL queries and configured scheduled queries in BigQuery to support periodic data processing for real-time dashboards and internal reports. Optimized queries to reduce costs, improve response time, and minimize scanned data volume in BigQuery.
• Performed data migration across environments or data platforms.
• Managed IAM security and access control for users, projects, and datasets within the Google Cloud ecosystem.
• Monitored and controlled BigQuery usage costs to ensure operational efficiency and accurate budget forecasting.

✅Visualization:

• Built interactive dashboards in Looker Studio using blended data sources and customized charts.
• Designed role-based dashboards for digital teams, staff, and management to support decision-making.

✅GMP (Google Analytics, Google Tag Manager):

• Built tracking systems using GTM and sGTM hosted on Google Cloud to improve data reliability and bypass AdBlockers.
• Designed event naming and parameter structures for web and app with the dev team.
• Configured GA4 (events, conversions, audiences) and integrated with Ads, BigQuery, Looker Studio.
• Debugged and validated tracking across platforms using DebugView, Tag Assistant, and browser tools.
• Ensured accurate and privacy-compliant data collection across multiple user journeys.

✅Working with teams and clients:

• Led a 5-member Data Analytics team, managing client-facing projects end-to-end.
• Delivered training sessions on Google Analytics, SQL, and dashboard tools.
• Collaborated directly with clients to define KPIs, tracking plans, and data solutions.

🧑‍💼 Key Clients::
👉 Vietnam Airlines, CellphoneS, Vinamilk, Vingroup (VinFast, Vinpearl, VinWonders, VinMec).

• Implemented and managed Google Analytics 4 (GA4) and Google Tag Manager (GTM) for both web and app platforms.
• Set up custom events, conversions, and enhanced eCommerce tracking to monitor user behavior and business KPIs.
• Integrated GA4 data with Google BigQuery, developed SQL queries to analyze user journeys and campaign performance.
• Built interactive dashboards using Looker Studio, enabling real-time reporting for marketing and management teams.
• Worked closely with product and marketing teams to derive actionable insights and optimize campaign ROI and user experience

• ReactJS, Flutter developer