Drew Mooney

Experience

• 

  St. Mary's College of Maryland

  Aug 2007 - May 2009

  Teaching Assistant

  • Acted as a teaching assistant in several classes ranging from introductory calculus to advanced abstract mathematics• Ran review sessions and graded homework• Helped facilitate group work in class• Lectured in place of the professor when needed

• 

  NIST

  May 2009 - Aug 2009

  Summer Undergraduate Research Fellow

  • Developed and compared a computer model of a multi-floor building fire with a similar experimental setup to determine if the simulation accurately predicted the experiment• Conducted research and developed computer simulations to determine the effect of different properties on the thermoplastic spread rate of a polypropylene plastic melt

• 

  Guardian Protection Services

  Nov 2009 - Feb 2010

  Small Business Consultant

  • Provided security and risk assessments to small businesses• Developed leads daily and followed up with business owners• Sold alarm systems and monitoring agreements to small businesses and offices

• 

  Epic

  Mar 2010 - Jul 2011

  Quality Assurance

  • Developed testing plans to ensure the highest possible levels of software functionality and usability• Collaborated with software developers on the design, development and testing of complex, long-term projects• Managed internal team projects

• 

  Spring Metrics

  Aug 2011 - Jun 2014

  Client Success Manager

  • Designed and implemented strategies that achieved a 96+% retention rate in a SaaS model• Worked closely with sales team to uncover business needs and present solutions to all levels• Worked with customers to design and refine promotions that increased revenue and conversion rate• Provided outstanding support to customers by listening, understanding and solving problems• Hired, trained, and led a second Client Success Associate

• 

  Leadpages

  Jul 2014 - Jan 2018

  • Created a custom intraday reporting system that ties together several external applications (Zendesk, Slack, Zopim, Toggl, Google Sheets, etc) and provides real-time feedback and reporting for all channels. Used this custom system to analyze and manage intraday coverage and make real-time adjustments• Collected, analyzed, and reported performance statistics and made recommendations for improvement• Proactively scheduled activities such as training, meetings, and overtime• Created short and long-term forecast and staffing plans to ensure adequate coverage• Maximized efficiency and occupancy to meet SLA and Utilization goals• Created a feedback system to capture and analyze business intelligence and share feedback with management Show less

  • Business Intelligence Analyst

    Feb 2016 - Jan 2018

  • Workforce Analyst

    Jul 2015 - Feb 2016

  • Technical Support Specialist

    Jul 2014 - Jun 2015
• 

  Target

  Jan 2018 - Jul 2020

  • Used SQL and regression to develop a predictive dashboard for store Inbound Trailer operations, enabling 5,000 team members to optimize staffing hours and reduce costs each week.• Used SQL and Excel to create financial impact models, providing leaders with visibility into the effects that different COVID19 social distancing options would have on Target store performance.• Mentored 3 analysts and led group training sessions for Target’s internal Data Analysis Learning Program. • Acted as the Agile Lead for 5 analysts & engineers to develop reporting & analytical tools to support replenishment processes at all Target stores.• Used SQL and data visualization to develop a suite of dashboards used by 2,000 team members to improve backroom accuracy and trailer operations.• Spearheaded the creation of a Data Quality program, implemented an automated suite of checks for critical reports, and drove adoption of best practices across multiple teams.

  • Lead Data Analyst

    Oct 2019 - Jul 2020

  • Senior Business Insights Partner

    Jan 2018 - Oct 2019
• 

  Alto Pharmacy

  Aug 2020 - Aug 2021

  Data Analyst, Operations

  • Used time-series forecasting to optimize staffing plans to increase on-time delivery performance from 93% to 98%.• Created forecasts, labor plans and cost models to enable staffing & hiring for a national fulfillment network.• Used SQL, spreadsheets, dbt and R to build dashboards & provide analysis to improve pharmacy operational productivity.

• 

  DIRECTV

  Aug 2021 - Jan 2022

  Principal, Advanced Analytics

  • Led the Test & Learn program for Marketing Measurement performance.• Measured digital channel experiments (overall performance and driver significance) through matched-market incrementality testing with R scripts to find optimal market groups given budgeting and operational constraints.

• 

  Sonder Inc.

  Jan 2022 - Jul 2024

  • Led a global team of 7 Data Analysts & 4 Analytics Engineers.• Improved team engagement in areas of Accomplishment (+15%), Goal Setting (+23%), Recognition (+30%) and Workload (+27%).• Created coaching & development programs for team members, resulting in enhanced skill development and career progression for the team.• Successfully recruited, hired and onboarded new team members, contributing to the growth and effectiveness of the Analytics team.• Strengthened partnerships with various cross-functional teams to prioritize new opportunities and build the long-term Analytics vision & roadmap. Show less • Developed data models in dbt and performed data analysis in SQL and R to create Tableau dashboards & provide actionable recommendations which helped the Guest Service team reduce Handle Times by 64%.• Developed SQL pipelines to power automated ML reviews that enabled the Trust & Safety team to reduce Booking Review costs by 62%.• Fostered a team culture of learning & development by mentoring 5 analysts, onboarding new tools & systems, and creating a custom analysis platform using R Shiny. Show less

  • Analytics Manager

    Apr 2023 - Jul 2024

  • Staff Data Analyst, Operations

    Jan 2022 - Apr 2023
• 

  Data Analyst Coaching

  Mar 2024 - now

  Founder & Head Coach

  I help Data Analysts break into the Senior+ level through tailored 1:1 coaching.

• 

  HubSpot

  Jul 2024 - now

  Staff Data Analyst, Analytics Enablement