Hoy Quan's Email Addresses & Phone Numbers

Consultant @ AMG From 2010 to 2011 (1 year) Consultant @ yoyostore.com From 1998 to 2010 (12 years) Director of Database Marketing @ Baby Chick Productions From 2005 to 2006 (1 year) Database Analyst @ TBWA Chiat Day From 2006 to 2006 (less than a year) Business Intelligence Manager @ ScoreBig Provided analytic and marketing support for...

Consultant @ AMG From 2010 to 2011 (1 year) Consultant @ yoyostore.com From 1998 to 2010 (12 years) Director of Database Marketing @ Baby Chick Productions From 2005 to 2006 (1 year) Database Analyst @ TBWA Chiat Day From 2006 to 2006 (less than a year) Business Intelligence Manager @ ScoreBig Provided analytic and marketing support for the “below box office” ticketing agency. • Prepared inventory, pricing and KPI reports for NHL, Dodgers and internal stakeholders • Built a customer database that identifies lifetime value, digital engagement and purchase behavior• Developed an automated system to generate 100’s of list pulls for email, SEM and social marketing• Developed SQL Server ETLs and reporting processes using Tableau with Google Analytics data• Tracked and calculated ROI for multiple customer acquisition channels through integration with GA and internal accounting systems From February 2016 to May 2016 (4 months) Hollywood, CAManager, Analytics and Business Intelligence @ AXS.com Outbox AXS LLC Analytics lead of the $2 billion ticketing agency operating in 3 countries with over 400 venues. Provided analytics support to marque venues such as Staples Center and The Colosseum at Caesars Palace• Identified business requirements, prepared user stories, and managed development projects in Jira• Sourced hardware, installed OS and MS SQL 2014 on development and production SQL Servers• Coordinated development projects with the engineering team utilizing Agile methodology• Designed and implemented a CRM database from 25 million customers records identifying lifetime value, purchase seasonality, Omniture digital engagement, purchase behavior, and Experian demographics• Built a propensity model based on previous purchases to predict future purchases resulting in email open rates of 30% and six figure sales per campaign from axs.com direct website sales• Developed a comprehensive suite of reports / dashboards in SSRS and Tableau for business development and acquisition of new venues and sponsors• Performed deep dive analysis for corporate partners (Verizon, American Express, and Uber)• Designed and implemented SSIS ETL process to load approximately 1 billion transaction records from legacy Teradata system into MS SQL• Developed A/B segmentation test scenarios and back end reporting of KPIs • Integrated data cleansing and normalization processes before data loadsQA and reporting from Big Data platforms (Hadoop, Redshift) utilizing SQL/Hive/Impala• Built control and QC reports in SSRS to monitor load process and daily balancing of key metrics/totals• Prepared documentation and trained junior staff on support and maintenance From January 2014 to December 2015 (2 years) Greater Los Angeles AreaManager, Planning & Analysis @ The Walt Disney Studios Provide database and analytic support for studio direct to consumer marketing through Disney Movie Rewards. Projects included Iron Man 3, Avengers, Pirates of the Caribbean and geo targeted theatrical events. Responsible for CRM strategies that utilize member value and behavior to produce targeted marketing campaigns in the Home Entertainment Division.• Managed multiple databases including a 6.5 million member rewards and loyalty program• Wrote a library of 300+ SQL programs for analytic reports and data extracts• Implemented SQL Server Reporting Services for automatic delivery of analytical reports and file exports• Restructured email segmentation strategies resulting in 2-3x improvements in open rates• Developed models that consistently identified members with 50+% email open rates • Integrated corporate data in marketing campaigns and optimized selection procedures • Coordinated data feeds to and from external vendors• Worked with multiple business units to ensure optimal selection and targeting of marketing messages From 2011 to 2013 (2 years) Burbank, CACRM Manager @ Guitar Center Managed direct mail, email, and outbound telemarketing program for 217 stores and guitarcenter.com. Annual volume: 70 million direct mail and 250 million emails. Worked directly with the strategic planning / analytics group, marketing and IT department. Contributed to the development of a Netezza corporate data warehouse and implementation of the Unica Campaign marketing application. Implemented multiple marketing initiatives: High Value Thank You and Bounce Back Lapsed Customer Reactivation High Spend Customer Rewards “Holiday Cash” Multi Version emails Based on Customer Segmentation Developed highly targeted customer segments and offers based on strategic directions and objectives: Branding Traffic & Gross Sales Gross Margins, Increase Frequency/Visits, Increase Basket Size From 2010 to 2011 (1 year) Lead Analyst, Marketing Systems @ Hot Topic Implemented multiple loyalty and email marketing programs for online and mall based retailer across 3 brands• Develop a list preparation and segmentation application that identified RFM, open rates and product interest. Increased response and open rates by a factor of 10-15X.• Expanded an existing customer loyalty program from 600,000 to over 1,000,000 in less than 1 year and built a new program with 5+ million members. System Administrator for the HT+1 loyalty program• Oversee the infrastructure to support a loyalty management and marketing program for over 700 stores and integration with online commerce. Functions included: Deployment of 4-5 million emails per week Email marketing, list segmentation, & maintenance Reporting and analytics using SQL, SSRS and SPSS Development of program incentives and rewards Integrated Torrid Credit Card program with POS and loyalty applications Program promotion (creative development, direct mail and online) System integration with existing accounting and ecommerce systems Customer service and call center support From 2006 to 2010 (4 years) Director, Direct Marketing @ Discus Dental Designed and implemented a series of B2B Direct Marketing Initiatives that reduced cost and increased sales. Discus Dental is the world leading supplier of teeth whitening and cosmetic dental products. Brands include Zoom and Brite Smile.• Designed and implemented automated follow-up outbound call lists, and mailing program.• Expanded domestic direct mail marketing prospect pool by 50% in 3 months.• Rollout international direct marketing programs in 9 countries.• Built the company email marketing database and increased the email prospect pool by 300% in 2 months.• Managed and directed the direct marketing activities of 6 brand managers.• Designed and programmed database and infrastructure support for the marketing department.• Built user interfaces to production Sybase accounting and CRM system. From 2005 to 2005 (less than a year) Database Manager @ JOL Management JOL Mgmt published the Journal of Longevity magalog and sold products under the name of Gero Vita. It was one of the world’s largest direct retailer of health and longevity nutricutical products.• Created an extremely profitable custom CRM system by integrating data from production Oracle systems.• Managed a 4 million record in-house customer database. Prepared weekly updates, monthly change of address, merge/purge, CASS/address standardization, collection of purchase history, and PRIZM geocoding.• Developed a prospecting database with over 200 million names that was used to collect purchasing behavior and demographic data; it helped increased direct response rates by 5-10 times. • Produced reports detailing response rates, lifetime value, project cost, RFM, ROI, and other marketing metrics.• Prepared specifications and requirements all hardware and software acquisitions within the department.• Assisted in the development of the company’s online store which generated more than $1.3 million in sales during the first year of operation.• Responsible for the department budget and managed a staff of 7. From 1998 to 2005 (7 years) Manager, Marketing, Planning & Analytics @ Fandango Business Intelligence, Infrastructure Development and Strategic Planning for online Ticketing, Video Streaming, and movie merchandising.• Doubled the active email marketing universe using segmentation testing, data hygiene and reactivation strategies (creative and technical enhancements)• Built a MS SQL Server infrastructure to support list production and reporting for 1+ billion emails• Identified key segments with over 60% open rates using look alike modeling• Built a report suite in Tableau which combined email metrics, Omniture web traffic and sales attribution data. Reports identified basic open, click, unsubscribes, unique visitors, page views and revenue.• Develop a matchback reporting process which can attribute each sale to the original email or marketing channel• Built a weekly report which identifies over 50 key performance metrics and track Week Over Week changes• Assist in creative development to identify targeting messaging to specific audience and built triggers for dynamic email content• Built a list production infrastructure to support creation of hold outs/controls, multivariate testing and personalize content based on purchase history From July 2017 to July 2020 (3 years 1 month) Beverly Hills, CABusiness Intelligence Analyst @ Tradesy Report development and technical support for online peer to peer fashion marketplace.• Designed corporate data warehouse on AWS Redshift to support Tableau reports and dashboards• Tableau Online administrator, worksheet developer and user support for 200+ Tableau worksheets• Provided big data support and analytics for taxonomy team distilling 300+ million product classifications• Identified and developed 200+ metrics that accurately identify consumer activity and value• Designed and implemented a job tracking system that records and monitor Tableau Redshift ETL jobs From July 2016 to March 2017 (9 months) Santa Monica, CA