Digital Marketing Data

Mai Han Tran

773-***-**** **********@*****.*** www.linkedin.com/in/hanmtran https://hanmtran.wordpress.com/

EDUCATION

The University of Texas, Dallas Expected Graduation: May 2021 Master of Science, Business Analytics GPA: 3.7

California State University, Fullerton Graduation: June 2017 Bachelor of Arts, Business Administration GPA: 3.7

SUMMARY OF QUALIFICATIONS

• Software and Tools: Advanced Microsoft Excel, R, Python, SAS, SPSS, Google Analytics, MySQL, Tableau, Power BI, Google Data Studio, Facebook Analytics Tool, Salesforce, WordPress, JIRA, and Asana

• Technical Skills: Data wrangling, data mining, data visualization, statistical modeling, predictive analytics, web analytics, and machine learning

• Soft skills: Communication, problem solving, project management, and cross-functional team collaboration

• Language: Fluent in English and Vietnamese

PROFESSIONAL EXPERIENCE

Wavemaker, Ho Chi Minh City, Vietnam

Digital Planner July 2018 – June 2019

• Extracted, cleaned, and analyzed user data using SQL which improved campaign performance by 15-20%

• Performed customer segmentation, conducted content analysis, and built prediction models on ad click-through- rate using Python to identify opportunity for growth and marketing investment

• Streamlined reporting process by leveraging Excel Macros and generated interactive dashboard via Tableau, which reduced reporting time by 572 hours annually

• Researched and evaluated data from industry reports, reviewed market landscape, and studied competition to provide innovative solutions to better serve client’s needs

• Led multiple projects simultaneously, facilitated discussion, and served as point of contact between clients, internal team, and upper management

Penhall Technologies, Anaheim, CA, USA

Digital Marketing Analyst May 2017 – June 2018

• Implemented sales operation procedure across 7 call centers via VBA-User Form and conducted match-back analysis to measure return on advertising investment

• Assessed web data via Google Analytics and multiple sources to provide holistic idea on website traffic and provided specific recommendations to enhance online presence and lead generation

• Built visualization dashboard to provide insights into channel performance and conversion pipelines across 40+ office locations using Salesforce and Google Ads data

• Worked with cross functional teams to revamp office network across 40+ locations to improve online UX

ACADEMIC PROJECT

• Health and Wellness Study - Performed K-means clustering via Python and built 3 regression models via SAS to identify target audience and provide go-to-market strategies and suitable marketing solutions

• Deposit Subscription Project– Analyzed 40k records and developed multiple tree-based models using Python to predict the number of deposit subscriptions for a banking institution

• Molly Maid’s Business Database Creation - Implemented and optimized database structure and performed normalization by using SQL query commands in MySQL to ensure data integrity and increase performance

• Analysis of Boston Crime – Conducted analysis across 2 million records and 17 variables to discover patterns in level of crimes across multiple districts in Boston by using R and Tableau

LEADERSHIP EXPERIENCE

• Vice Chair, Association for Inter-Cultural Awareness June 2016 – August 2017

• Team Leader, Google Online Marketing Challenge June 2016 – January 2017

• Campus Tour Guide, New Students and Parents Program March 2014 – August 2014

Contact this candidate