Nam Mai TRAN

Data Engineering: - Developed and maintained new dbt models transforming data from datalake into datawarehouse and datamart, with unit and custom tests to ensure data quality - Refactorized existing dbt models through partitioning, clustering, and incremental load to cut processing costs and monitored dbt pipelines using Elementary - Coordinated with SAP, Salesforce, Anaplan stakeholders to develop data products in BigQuery to support new sales & finance analytics use case - Developed DAGs to orchestrate data ingestion, and transformation workflows via Composer/Airflow - Migrated 100% of the datawarehouse and datamart in Oracle On-Premise to Google Cloud Platform, respecting datamesh architecture - Automated BI refresh workflows by integrating Qlik & Power BI dashboard reloads into Airflow pipelines via custom Airflow operators - Provisioned the infrastructure resources in Google Cloud Platform using Terraform - Developed CI/CD pipelines for Power BI, enabling Git-based versioning and automated deployment of semantic models across multi-environment workspaces - Leverage AI-assisted development tools (Claude Code, Gemini) to generate and optimize dbt models, troubleshoot pipeline issues, automate repetitive coding tasks, and accelerate technical documentation Business Intelligence: - Designed scalable dimensional data models (star schema) to enable self-service analytics - Owned KPI logic and business definitions, aligning stakeholders on metric definitions to ensure consistency across reporting layers and use cases - Developed and delivered 12 Sales and Finance dataviz applications (Qlik & Power BI) enabling self-service analytics for 500+ frequent users across 33 markets - Defined and applied dataviz standards across UI/UX, semantic layer consistency, and dashboard design best practices - Resolved critical incident / escalation across B2B Business Intelligence platforms (Support Level 2 & 3) Technical Leadership: - Led technical initiatives within BI team by providing guidance on best practices, code review, managing backlog and cross-functional collaboration - Mentored junior engineers and analyst in the team, assumed ownership of project deliveries, acted as the technical referent for B2B Sales stakeholders

• Gathered requirements, define KPIs, and translate business questions into prototypes • Developed dashboards in Qlik Sense, Power BI, and Looker, implementing optimized star and snowflake data models • Created complex DAX and Set Analysis expressions, and implemented row/column-level security to ensure role-specific insights • Developed ETL workflows using Alteryx to integrate multi-source datasets from SAP, Salesforce, and SFTP, creating a centralized Gold data layer for analytics