Ethan Chan Email & Phone Number

United States

Salt Lake City, Utah, United States

Salt Lake City, Utah, United States

Salt Lake City, Utah, United States

• Developed and maintained structured data queries in SQL to generate critical insights that help to inform key decisions on media buying and advertising plans for clients worth up to $1 billion
• Created automated reporting tools across 6+ unique platforms that share key advertising performance metrics with clients, resulting in the reduction of required labor hours by 12.5% daily
• Supported a proposal for a $2 million nonprofit organization through extensive analysis on their website’s user behavior flow and organic marketing performance metrics with the goal of increasing company net worth by.

San Francisco, California, United States

Lehi, Utah, United States

• Performed statistical and data analysis including regression & Principal Component Analysis to better identify valuable segments in Lendio’s current customer base, which has the potential to increase revenue by $5-7m.
• Created a dynamic tool in Tableau that allows the sales & marketing teams to quickly identify prime targets for revenue, lowering customer acquisition costs
• Presented analysis & findings to the CEO, CFO, and other high-level executives within Lendio

Provo, Utah, United States

• Developed a reporting flow and centralized visualization tool in Tableau that takes and presents data across all key platforms used by BYU University Communications, saving ~8 hours of weekly labor
• Pioneered the Data Analyst role and all current reporting tools within University Communications to drive critical insights as well as support management decision making on various campaign objectives
• Streamlined the reporting of KPIs across 5+ platforms consisting of over 100 social media posts, emails, and news articles monthly with an average reach of over 100k to obtain actionable insights for key stakeholders

Springville, Utah, United States

• Worked closely with the COO & Managing Directors of three key Business Units within ATL to assess and revise their business strategy, and delivered recommendations on potential partnerships & acquisitions to key.
• Conducted in-depth research on 30+ companies’ financial reports, market entry strategies, and consumer and product trends in the medical device market to inform key business decisions

• Ensured timely and accurate processing of over 750 transactions of sales, purchasing and inventory activity weekly
• Oversaw job postings, hiring, employment documentation and onboarding training for over 100 student employees
• Spearheaded development and implementation of new projects to accommodate new COVID-19 policies, which will impact the food safety & consumption for over 30K students
• Managed and supervised a small team of 3 members over 18 months, ensuring 100% timely implementation and execution of daily, monthly, semesterly & yearly tasks

Singapore

• Cultivated critical teamwork and problem-solving skills through daily 10+ hour intensive physical trainings on firearms, explosives, and construction/breaching of wartime obstacles across different team compositions
• Showcased adaptability and diligence by building a shelter with installed plumbing and electricity with only a 1-month long civil engineering course
• Achieved multiple awards including a competitive silver award in the Individual Physical Proficiency Test, an award given to the more physically fit and resilient soldiers, and the marksman award in the Advanced.