Ty Lopez Email & Phone Number

Costa Mesa, Ca, Us

• Created and maintained visually impactful dashboards in Tableau on consumer insights and led monthly stakeholder meetings• Leveraged complex SQL queries to obtain statistically significant key performance metrics for CRM team and increased MoM performance• Constructed efficient data workflows in Alteryx and provided automation to several live reports• Collaborated with various departments to identify operational improvements and strategic decisions based on data

Orange, California, Us

•Optimized data collection procedures and automated daily, weekly, and monthly sales reports using VBA and advanced Excel functions, saving management 700+ hours of work annually.•Utilized SQL queries to extract loan funding from data warehouse; wrangled and interpreted data using Python to draw conclusions for managerial action and strategy. Additionally, linked database to customized dashboard for live data feed.•Performed statistical analysis on email and direct mail campaigns for Marketing Director on over 1 million consumers, helping to generate an additional 300+ funded loans for Q3 and Q4 of 2019.•Managed integrations project of CRM and auto-dialer network. Rebuilt CRM functionality and redesigned telephony logic to improve sales center productivity by 30%.

Whittier, Ca, Us

• Managed a hall of over 40 first-year students and made organizational decisions regarding housing.• Collaborated with Resident Directors and Advisors to plan joint programs as well as to communicate any concerns regarding the safety and security of residence halls.• First responder to the Whittier College Campus Police (crisis management).• Created monthly informational boards that promoted academics, engagement, health, and diversity.

Whittier, Ca, Us

• Analyzed economic forecasts of privatized space-markets and technologies surrounding earth’s Lagrange points alongside Professor Jack Gregg (the Founding Dean of Space University at Northrop Grumman Space Technology). • Developed official website and implemented strategy for marketing research articles to prospective clients through social media brand promotion and collected data for further optimization.

Whittier, Ca, Us

• Directed the editorial process for the weekly publication of an award-winning collegiate newspaper.• Responsible for delegating tasks to staff members and managing them, hiring assistant editors, fact checking articles for accuracy, and meeting with the editorial board for future project proposals.