Amanda (Mandy) Drake Email & Phone Number

Durham, North Carolina, United States

Key projects include:• Completed comprehensive review and update of County’s greenhouse gas inventory from 2009-2021, ensuring the accuracy of all submitted input data and validating all input parameters. • Worked cross-departmentally to compile submission materials for national SolSmart designation• Created presentations to synthesize results from various program designation applications (LEED for Cities, SolSmart).

Durham, North Carolina, United States

Conduct data management and analysis for Don't Waste Durham's reusable takeout container program, GreenToGo. (durhamgreentogo.com)Major accomplishments include: • Creating and maintaining a Tableau dashboard displaying user-friendly graphics that guide program development and improve operational efficiency. • Regularly isolating various customer lists tailored to specific goals (including program updates, reminders, and marketing campaigns), dramatically improving the team's outreach capabilities.

New York, United States

Worked with Sustainability Manager to achieve sustainability goals for both office and events. Key projects include:• Streamlined the organization’s sustainability data by identifying and cataloguing the various data sources for energy, water, and waste data. Developed a system for long term data acquisition and organization. • Created a Tableau dashboard visualizing organization’s yearly energy usage data, allowing for significantly improved analysis capabilities.• Developed an Office Waste Reduction Plan to be enacted upon return to office following the pandemic.

Durham, Nc

Worked with the Sustainability Manager to design and implement various sustainability projects within City and County government operations and in the Durham community. Major accomplishments include: • Providing effective and engaging consulting services to various local workplaces, encouraging the implementation of over 100 sustainability initiatives in more than 20 Durham organizations. • Drastically reducing the time required to generate energy use statistics for government buildings by automating most of the data compilation, calculation, and summarization process. • Developing an Excel dashboard that displays monthly energy use data for City buildings, resulting in the timely identification and resolution of energy efficiency issues in numerous facilities.

Washington D.C.

Efficiently utilized SAS in a fast-paced consulting environment to: • organize, clean, and compile data from multiple sources• translate diverse conceptual questions into the appropriate data manipulations• generate queries, tables, reports, and visualizations summarizing large, complex datasets• conduct creative data mining to produce additional insights

Master'S Degree, Analytics

Bachelor Of Science (Bs), Environmental Science, Energy & Sustainability Concentration, Mathematical Decision Sciences Minor

Energy And Sustainability

I participated in a 7-month study abroad program at the Joint Graduate School for Energy and Environment (JGSEE) in Bangkok, Thailand..

Education record

As a junior and senior in high school, I attended NCSSM, a highly selective public residential high school that focuses on the intensive.