Andrew Keyes Email & Phone Number

Remote

In my role as a Data Analyst, I significantly advanced our project management, data analysis, and reporting capabilities through the strategic implementation of automated workflows and database optimization. By developing custom automation processes using JavaScript in Google Apps Script, I enhanced operational efficiency across multiple projects, benefiting both our team and a range of high-profile clients including VMware, X The Moonshot Factory, and LinkedIn. My efforts in transitioning to SQL for database management not only streamlined data handling but also improved data accuracy and accessibility, playing a pivotal role in our successful integration with Google Suite.Critical achievements include:- Designing and implementing tailored automation scripts that reduced project delivery times by 30%, allowing our team to focus on more strategic tasks.- Leading the development of a new SQL-based database structure, which enhanced data analysis capabilities and supported more informed decision-making.- Collaborating closely with cross-functional teams to ensure seamless integration of automated processes, improving project workflow and team productivity.My work has directly contributed to elevating the quality of service delivered to clients such as Realtor.com, Optimizely, Upwork, Dropbox Sign, and National Women's Soccer League, reinforcing our commitment to excellence and innovation in project delivery.

As a contractor, I leveraged online trend analysis and social sentiment tracking to significantly enhance our clients' marketing strategies. Notably, I pioneered a benchmarking methodology that transformed Just Drive Media's reporting and insight generation processes, leading to a new standard in success measurement for client projects. This innovation resulted in measurable improvements in campaign effectiveness and client satisfaction.Key components involved juggling the management of multiple client projects:- Developing a detailed project management system using Notion to prioritize client objectives and streamline reporting workflows.- Conducting in-depth social and media data analysis to uncover emerging trends and inform strategic decisions, directly contributing to the discovery of untapped market opportunities.- Crafting clear, insightful presentations that communicate complex findings in an accessible manner, enabling clients to act on data-driven insights quickly.

During my internship as a Social Media Analyst, I utilized analytical tools to drive our clients' social media presence, achieving notable improvements in brand engagement and alignment. My responsibilities included:- Developing boolean queries for comprehensive 24/7 monitoring of brand-related social media activity, enabling more targeted marketing strategies and immediate response to brand mentions.- Creating dynamic dashboards that visualized social media trends and performance metrics, which facilitated data-driven decision-making and strategy adjustments.- Leading cross-functional teams in refining brand messaging, significantly improving message coherence across platforms and contributing to a more unified brand image.

Stockton, California, United States

Collect stimuli across multiple domains to create an understanding and maintain a high output. Precisely procure and relinquish product to fulfil standard workflow operations.

Riverbank, California, United States

Ensure safety regulations are met by diligently looking over the store and parking lot. Interpersonal communication, task management, and organizational skills flourished in assisting customers with loading products.

Modesto, California, United States

Help management with new-hire training and arrangement of staff. Understand the entire business workflow: from product coming in to waste going out. Upkept a high standard of consistent customer communication.

Bachelor Of Arts - Ba, Experimental Psychology, Senior

Activities and Societies: Dean's List x2Research with multiple data types, tests, participants, and topics. Research Report.

Associate Of Arts - Aa, Psychology, Sophomore

Activities and Societies: Cross Country and Track and Field, Dean's List x2Research and data analysis with an Institutional Grade.