Marco S. Alvarado Email and Phone Number

• Completed an exploratory analysis of 2018 crime data in the San Francisco area to identify trends in high-crime neighborhoods by leveraging Microsoft SQL Server and Tableau• Utilized Google Analytics to analyze a client's acquisition KPIs (user demographics, session statistics, bounce rates), evaluated the success of their targeting strategy, and made recommendations for increased traffic and retention rates• Used Microsoft Excel and Google Sheets to create pivot tables and execute… Show more • Completed an exploratory analysis of 2018 crime data in the San Francisco area to identify trends in high-crime neighborhoods by leveraging Microsoft SQL Server and Tableau• Utilized Google Analytics to analyze a client's acquisition KPIs (user demographics, session statistics, bounce rates), evaluated the success of their targeting strategy, and made recommendations for increased traffic and retention rates• Used Microsoft Excel and Google Sheets to create pivot tables and execute functions such as VLOOKUPS to analyze and consolidate large datasets Show less

• Managed over 60 global email marketing campaigns for complex B2B and B2C products such as Google Ads, YouTube, and Google My Business often involving A/B testing via Continuum Global• Oversaw end-to-end operation lifecycles: scoping, production, QA, deployment, and data analysis• Communicated with cross-functional Product, Marketing, and Engineering teams to meet deadlines for 30+ high complexity projects

• Led ~35% of work volume within the team to implement solutions in the workers' compensation industry• Collaborated with cross-functional teams throughout all steps of the software development lifecycle to maintain workflow integrity• Designed and executed 60+ SQL queries for internal and external management to perform monthly, quarterly, and yearly analysis• Created 200+ test cases and coordinated user acceptance testing to accurately integrate software

• Assisted in transitioning user accounts from Office 365 to G-Suite, supporting 500+ employees• Diagnosed PC and Mac systems to support over 300 employee issues using the SysAid ticketing system• Maintained and organized company IT assets: on/offboarding, asset management• Developed & maintained IT policies to support business processes