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.
• 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.