David Guzman Email and Phone Number

• Partnered with Marketing to design and develop various strategic planning/analysis to help make business decisions.• Leveraged both Tableau and Snowflake data assets to create self-service Dashboards.• Composed various SQLs that consolidated various data assets to support ad-hoc reporting needs. • Served as the team lead for all Brand Media analysis, including presenting findings to both Marketing and Leadership.• Collaborated with Data Engineering to help create foundational data assets, which would be used by both Marketing and Product. • Worked with various Marketing agencies to provide Marketing insight on how to proceed with marketing expenditures.• Serve as the team’s SME in data platforms, SQL, and Tableau.

• Coordinate cross functional teams to address campaigns and help devise solutions to ensure all ad sales are met in-full.• Served as a Project Lead to help transition all analytical assets into our new cloud-based data environment. Served as a spokesperson for our department during the business transition from an on-prem data platform to a cloud-based environment.• Participate in leadership discussions regarding ad revenue streams and devise new tactics to further support the growth of the business.• Leverage Tableau to create automated dashboards to facilitate financial dialogue during Leadership meetings. • Develop new advance data capabilities using our two data platforms, AWS and IBM Netezza, to discover new insights for our clients.• Served as the team’s SME in data platforms, Tableau, and SQL.• Enrich the team’s technical skillset by coordinating internal learning sessions and workshops.• Develop client-ready presentations, dynamic dashboards, and reports that provide key insights on KPI performance, utilizing visualization and storytelling techniques and best practices. • Provide direct support to internal sales partner team, and manage project priority and scope of requests with moderate oversight from Manager Analytics.

• Develop automated reports using BI tools connected to the Hadoop environment. These reports are intended to replace manual reporting done by analyst. • Develop interactive Tableau dashboards that can help business analyst discover insights to statistical changes.• Provide OEM analysis using two distinct data sets heavily used at Kelley.• Maintain a Data Dictionary that profiles metrics contained in our two distinct data sets and/or developed during dashboard building.• Partner with Sales and other departments to define products that can assist them in their daily activities. • Define analytical processes and workflow to balance business demand and worker capacity.

• Cleansed and filtered raw data sets using Datameer tool.• Identified a connection between two distinct data sets heavily used in the field of analytics at Kelly.• Developed a user friendly template implementing this connection in order to combine both data sets. • Presented findings of applying both data sets to fellow employees, managers, and directors. • Satisfied OEM requests using MicroStrategy and Datameer tools.

• Managed mortgage loan applications prepared by license mortgage bankers.• Communicated with applicants and obtained required information to complete transactions.• Closed mortgage loans within 4 days using the security program Encompass©.

• Participated in student-parent discussion panels encouraging minors from disadvantaged neighborhoods to attend college and pursue careers in the Mathematics field.• Developed a blog describing my experiences as a minority student from a poor community pursuing a college degree.• Coordinated English and Spanish discussion sessions regarding college life and education.

• Verified each member’s desired major and streamlined course schedules for on-time graduation. • Arranged universal study hours and consulted tutors for fellow brothers struggling in course material.• Allocated career-building resources for various fraternity departments.• Organized resume workshops and job panels with the UCI Career Center to facilitate brothers’ future endeavors.

• Attend weekly manager meetings with League coordinator.• Notify players about upcoming games and coordinate payment plans for registration fee.• Maintain and take team equipment to game site.

• Directed stage rehearsal for over 900 performers, including competitive dance teams from around the nation.• Enlisted translators to facilitate verbal communication with performance leaders from East Asia and South America.• Resolved directive conflicts that arose during performance time.• Directed competition leaders to assigned performance time slots, and verified event inventory with local companies.• Coordinated a $1,000 fundraiser for the Watts Tutoring Program in Los Angeles, CA.