Johnathan Lou

JOHNATHAN LOU Email:-| Skype: johnathan.lou | LinkedIn: https://www.linkedin.com/in/johnathan-lou/ ● ● ● ● FEATURED SKILLS/PLATFORM EXPERIENCE (*indicates formal certification) Data Visualization/Design: Datorama*, Tableau, Google Data Studio, Axure RP Data Analysis: Google Analytics*, Adobe Analytics, MYSQL/SQL Server, Google BigQuery, RapidMiner, R, SAS, MS Excel Digital Strategy: Google Tag Manager*, Google Search Console, DoubleClick, AdWords, MOZ, Oracle Responsys, HotJar Programming: JavaScript, Google Apps Script, HTML/CSS, REST APIs RELEVANT WORK EXPERIENCE SHAW/SCOTT Primary Client Accounts: Prosper, Lululemon, Pet Supplies Plus, Princess Cruises, Joann Seattle, WA Digital Analyst Consultant, Strategy & Analytics 04/2019-Present Lead analytical and technical implementations to drive data insight, accuracy, and efficiency. Integrate web analytics, CRM, and online/offline conversion data into insights and analysis that optimize marketing strategy. Present findings to clients with impactful data visualization and storytelling. ● Increased monthly reporting efficiency by 75% leveraging advanced Excel features ● Developing inaugural data-driven scoring methodology for email content effectiveness ● Leverage client CRM databases to deliver advanced A/B validation and multi-touch attribution analysis ● Currently scoping technical requirements to onboard an automated data reporting solution in 2020 EXTRACTABLE Primary Client Accounts: McKesson, Patelco Credit Union, TCF Bank, Fidelity Bank, Matthews Asia San Francisco, CA Data Consultant, Data Analytics 09/2018-05/2019 Provide hands-on analysis and strategy expertise to generate data-driven insights and optimization recommendations. Develop business review presentations for client marketing teams and executive leaders. Areas of focus include web analytics (traffic acquisition, content engagement, goal conversion), SEO, UX heuristic reviews, social/paid media, and tagging implementation. ● Solved user abandonment issue by adjusting Google Analytics tag settings that artificially increased bounce rate ● Identified opportunity to increase conversion potential by 7x with mobile site re-design and defined conversion segments ● Applied linear regression to raw Google Analytics data revealing paid search’s influence on 78% of organic search DENTSU-AEGIS, CARAT USA San Francisco, CA | Culver City, CA Primary Client Accounts: Disney Parks and Resorts, Sony PlayStation, Adidas, Red Bull, Nokia (Microsoft Phones) Associate Director, Data Analytics Department 01/2017-01/2018 Identified opportunities to advance Carat’s analysis capabilities for existing clientele while expanding the team’s strategic influence and visibility across underexposed accounts. Supported new business pitches showcasing analytical products to potential clients. Directed recruitment, training, and management of junior/mid-level team members in multiple offices. ● Admin of 60+ dashboards in cross-channel Datorama accounts with datasets ranging between 5-20M records ● Lead 6 path-to-conversion and regression projects with Google BigQuery data mining ● Established data integrity and processing best practices across 3 major accounts to increase reporting efficiency Supervisor & Associate Analyst, Data Analytics Department JWT NORTH AMERICA, LUNCHBOX LP Analyst, Performance & Analysis Department • • EDUCATION BA, Loyola Marymount University, Psychology, Minor: Business Interactive Design Foundation (ongoing certification work in various UX disciplines) 1/2013-12/2016 Culver City, CA 01/2011-12/2012