Data Analyst

• Jul 2022 - Present

Data Designer

• Jun 2021 - Jun 2022

• Consult with internal customers to author problem statements within the organization that are solved using data analysis and critical thinking • Lead the design and development of dashboards using Tableau to visualize data for the appropriate stakeholders • Employ a solid understanding of relational database structures and practices to write SQL scripts for querying data and generating aggregate tables and views • Perform data acquisition and data wrangling techniques to prepare data for analysis • Work with other to solve complex data problems • Experience connecting to many different data sources and the ability to handle large data sets Show less

Enterprise Data Office Intern

• May 2020 - Jun 2020

• Improved Nationwide’s graph database for contract tracing related to the COVID-19 pandemic by calling the Cisco API to retrieve historical data to find a complete history of possible employee contacts during Nationwide’s shift to return to office • Tested the connection and documentation from Paxata to AWS S3 • Gained experience and knowledge working in a professional data environment • Improved Nationwide’s graph database for contract tracing related to the COVID-19 pandemic by calling the Cisco API to retrieve historical data to find a complete history of possible employee contacts during Nationwide’s shift to return to office • Tested the connection and documentation from Paxata to AWS S3 • Gained experience and knowledge working in a professional data environment

Digital Marketing Intern

• May 2019 - Aug 2019

• Developed operational metrics aligned to customer experience and operational efficiency to convey the contributions of Marketing Technology across the Marketing organization • Operationalized Nationwide’s portfolio of domains using descriptive analytics and data insights • Identified over $100,000 in annual savings for domain names no longer required by Nationwide • Built Excel workbooks using calculation techniques such as IF statements, AND statements, COUNTIF, VLOOKUP, and Concatenate • Formatted workbooks using Conditional Formatting, Merge, Sort, Tables, and Filter • Used Pivot Tables to gather insights about the data • Built custom reports for Nationwide’s 2020 Marketing Planning initiative • Ran financial reporting on Marketing departmental expenses, including expense consolidation and forecasted full year expenses • Established weekly leadership agenda to identify new work that had come into the Marketing Technology pipeline Show less