top of page

Tram Nguyen CV

Experience

May 2022 - Present

Data Intelligence Analyst

Havas Edge

Carlsbad, CA

  • Streamlined data onboarding for 30+ clients, improving operational workflows and client retention through enhanced cross-functional alignment.

  • Automated ETL pipelines for data ingestion, transformation, and delivery from S3, SFTP, APIs, and GCS, enabling faster, standardized, analysis-ready datasets for attribution modeling and reporting.

  • Implemented web analytics tools, increasing tracking accuracy by 25%, resolving technical issues, and ensuring continuous ad performance monitoring.

  • Developed Market Matching Shiny app, allowing non-technical users to explore control markets and define test-control pairs, improving analysis accessibility and user adoption.

  • Developing an AI-powered agent with Copilot Studio to streamline cross-functional knowledge sharing. The agent leverages the Analytics team’s Stack Overflow knowledge base and integrates with Dataverse for real-time updates. It provides accurate responses, incorporates web search as a fallback, and includes feedback mechanisms to enhance insights and operational efficiency.

​

KEY SKILLS: R Programming Language, SQL, ASW S3, Google Analytics, Google Tag Management, Trade Desk, API Integration, Data Onboarding, ETL Automation, Shiny Apps, Attribution Modeling, Data Transformation, Data Viz, Cross-Functional Collaboration, Copilot Studio

September 2020 - May 2021

Graduate Teaching Assistant

Claremont Graduate University

Claremont,CA

  • Provided hands-on instruction in Relational Database Management Systems (RDBMS) concepts and SQL queries using Microsoft SQL Server, supporting student comprehension and technical proficiency.

  • Conducted quality assurance on student assignments, reviewing SQL code and evaluating relational database structures for accuracy and efficiency.

  • Facilitated learning support for over 40 students by hosting virtual office hours, monitoring student progress, and offering personalized feedback to improve understanding and technical skills.

  • Collaborated with professors weekly to analyze student progress reports, refining teaching strategies to enhance the learning experience and maximize student success.​

​

KEY SKILLS: SQL, Relational Database Management Systems (RDBMS), Microsoft SQL Server, Code Review, Quality Assurance, Academic Support, Technical Tutoring, Student Engagement, Data-Driven Instruction, Progress Analysis

September 2020 - December 2020

Practicum Data Analyst

Kite Pharma

Remote

  • Executed end-to-end data analysis involving data understanding, preparation, and modeling using tools such as Python, SPSS, and Tableau Prep. Ensured data integrity and readiness for analysis, enabling accurate and insightful reporting.

  • Applied advanced statistical methods including Pearson’s and Spearman’s correlation analysis, as well as time series modeling, to identify relationships and trends between key variables.

  • Delivered data-driven insights by answering client queries and presenting findings that sparked client interest in future R&D initiatives, showcasing analytical rigor and effective communication.

​

KEY SKILLS: Data Analysis, Statistical Modeling, Python, SPSS, Tableau Prep, Data Visualization, Correlation Analysis, Time Series Analysis, Client Engagement, Research & Development (R&D) Insights

January 2018 - May 2018

Practicum Marketing Consultant

LEGOLAND California Resort

Carlsbad, CA

  • Collaborated on a Senior Experience Project as part of a five-member team to design a comprehensive recruitment marketing plan aimed at enhancing future hiring strategies at LEGOLAND California Resort.

  • Conducted primary research by collecting data from over 300 students across multiple local colleges. Leveraged Excel for data analysis, uncovering key insights to inform strategic recommendations.

  • Strengthened project management skills by coordinating with team members, adhering to deadlines, and delivering a final presentation to resort stakeholders.​

​

KEY SKILLS: Market Research, Data Collection, Data Analysis (Excel), Recruitment Marketing, Project Management, Cross-Functional Collaboration, Strategic Planning

Professional skillset

Programming Languages: R, SQL, Python, JavaScript, HTML

ETL Development

API Integration with Supermetrics

Google Analytics

Google Tag Manager

Market Matching & Causal Impact Analysis

API Integration with Supermetrics

Data Viz: PowerBI, Shiny Apps, Tableau

Data Transformation & Automation

Cross-Functional Collaboration

Education

Master of Science in Information Technology - Data Science

Claremont Graduate University / Claremont, CA

Bachelor of Science in International Business and Marketing

California State University San Marcos / San Marcos, CA

Certifications

Full Stack Web Development - UCSD Extended Studies

Data Engineering Nanodegree - Udacity

Google Data Analytics Professional Certificate - Coursera

bottom of page