David Pickering

David Pickering Email and Phone Number

Analytics Leader and Data Engineer | Experience in Data Engineering, Data Warehousing, DBT, Data Modeling, Analytics, and Project Management @ Mid-Ohio Food Collective
David Pickering's Location
Chagrin Falls, Ohio, United States, United States
David Pickering's Contact Details

David Pickering work email

David Pickering personal email

About David Pickering

I began my career as a trainer, moved to training trainers, became a database administrator, learned how to be a software developer, grew into data engineering, and ultimately became a data and system architect. Each time I was presented a problem, I've gone above and beyond to overcome that challenge and deliver a permanent improvement in capabilities to my organization. Along the way I completed a specialized Masters in Business Analytics. My desire now is to have a cross disciplinary career in data science building architecture to house data, engineering its journey through transactional and analytical systems, and enabled organizations to address their toughest challenges with business intelligence and data science.

David Pickering's Current Company Details
Mid-Ohio Food Collective

Mid-Ohio Food Collective

View
Analytics Leader and Data Engineer | Experience in Data Engineering, Data Warehousing, DBT, Data Modeling, Analytics, and Project Management
David Pickering Work Experience Details
  • Mid-Ohio Food Collective
    Senior Manager, Data And Insights
    Mid-Ohio Food Collective Mar 2021 - Present
    Grove City, Ohio, United States
    Transitioned data platform from custom internal tooling to modern data stack using DBT, Snowflake, and FiveTran reducing compute times by 90% and eliminating 85% of licensing and hosting costs.Coached Feeding America staff in building a modern data stack using DBT, AWS Redshift Serverless, Lambda, and GitHub Actions to access and manage USDA data as a slowly changing dimension. This resolved a technical blocker and enabled seamless integration of the data into the Meal Connect system.Founded MOFC’s analytics department to build a code-first data science approach, leveraging Posit Teams (Workbench, Connect, Package Manager) to complete over 300 custom analytics projects and produce over 90 automated analyses.Led development of the Collective Insights Platform to centralize MOFC’s analytics and operating systems, resolving access control issues and system inefficiencies. Implemented RBAC-compliant access using PHP Laravel, MySQL, Auth0, and Entra ID and leveraged AWS ECS to reduce EC2 costs by 40%.
  • Mid-Ohio Foodbank
    Contractor
    Mid-Ohio Foodbank Mar 2020 - Mar 2021
    Grove City, Ohio, United States
    Led the creation of FreshTrak:Public, a scalable reservation management system developed in response to the COVID-19 pandemic. Transformed a whiteboard conceptual model into a full system using Ruby on Rails, ReactJs, MySQL, AWS Lambda, and CloudFront. Receiving over 650k reservations across 9 food banks.Created the backend management system for creating reservation opportunities in response to COVID-19 to support increased pre-registration needs. Coded within an existing stack of PHP, MySQL, and Bootstrap and enabled users to create and publish over 1.3M reservation opportunities, ensuring scalable and efficient operations.Provided technical oversight during Feeding America’s acquisition of FreshTrak systems, ensuring a smooth transition and integration. Assisted with contract evaluation, data continuity, and system migration, maintaining uninterrupted services for MOFC and other food banks.
  • Mid-Ohio Foodbank
    Pantrytrak Program And Data Manager
    Mid-Ohio Foodbank Feb 2016 - Sep 2019
    Grove City, Oh
    Developed an ERP module to streamline scheduled deliveries using SQL Server, a PHP web app, and ensuring integration with the Macola ERP system. In use since 2016, the system facilitates the distribution of over $30 million in food annually.Provided technical support for the large-scale roll-out of the PantryTrak system, ensuring seamless integration with business operations. Managed data imports, developed ad hoc and turnkey analytics, and created system rollout tools. Since 2012, the system has been adopted at over 3.5k locations across 12 states, processing over 49.5M transactions.
  • Mid-Ohio Foodbank
    Strategic Solutions Specialist
    Mid-Ohio Foodbank Dec 2013 - Jan 2016
    Grove City, Oh
    Supports and maintains the implementation, training, and support tasks associated with critical client/public facing systems such as PantryTrak. Serves as peer mentor to AmeriCorps VISTAs, and other PantryTrak staff. Helped PantryTrak grow from usage at 150 locations to over 800.
  • Southeastern Ohio Foodbank
    Americorps Vista And Hunger Study Coordinator
    Southeastern Ohio Foodbank Nov 2012 - Nov 2013
    Logan, Oh
    Coordinated the foodbank's participation in a national research study, Hunger In America 2014, throughout their network of member agencies. Fulfill all requirements of the hunger study and coordinate data collection at over seventy pantries, and with three hundred client interviews throughout the study.Build the capacity of the organization to respond to hunger through research for strategic planning, and use focused evaluations.
  • Ohio Association Of Foodbanks
    Summer Research Fellow
    Ohio Association Of Foodbanks Jun 2012 - Aug 2012
    Collaborated with the Association and the George Voinovich School of Leadership and Public Affairs to conduct an evaluation of the Summer Weekend Meals Program. Recruited five Summer Weekend Meals Program Sponsors and built working relationships to coordinate for survey data collection, and site visits to collect data through interviews with participants and their parents. Processed survey data into a spreadsheet database, transcribed participant interviews, and transcribed and analyzed parent interviews.
  • Capital University
    Student
    Capital University Aug 2008 - May 2012
    Columbus, Ohio Area
    Double majored in Environmental Science and Spanish. Served Columbus's Spanish speaking community by teaching an English as a Second Language class through the Amistad y Vida Ministry. Served as the Vice-President of the Tri-Beta Biological Honor Society and Treasurer for the Phi Sigma Iota Foreign Language Honor Society. Four year member of the Life Sciences Organization, and inaugural member of the Experior Society.
  • Capital University
    Organic Chemistry Teaching Assistant
    Capital University May 2010 - Aug 2010
    Columbus, Ohio Area
    I worked with a team of eight faculty members and five other student TAs to operate the Summer Institute in Science and Mathematics program. My regular duties included tutoring students, and grading lab reports. I also prepared chemical demonstrations, laboratory materials, and safety information for the twenty-students I supervised in my section of the laboratory. Additionally, I conducted the experimental procedure prior to lab and recommended solutions and changes in procedure based on results.
  • Otra Cosa Volunteer Network
    Volunteer
    Otra Cosa Volunteer Network Jun 2011 - Aug 2011
    Sicchezpampa, Peru
    I worked on an Organic and Fair Trade Coffee farm. For two months I became a part of a rural low-income Peruvian family, working six days a week in exchange for rustic room and board. Through my experiences in Sicchezpampa I developed a real empathy for the community, and small coffee producers throughout the world.

David Pickering Skills

Mysql Php Html Bootstrap Cascading Style Sheets Github Tableau Highcharts Microsoft Sql Server Microsoft Excel Public Speaking Microsoft Office

David Pickering Education Details

Frequently Asked Questions about David Pickering

What company does David Pickering work for?

David Pickering works for Mid-Ohio Food Collective

What is David Pickering's role at the current company?

David Pickering's current role is Analytics Leader and Data Engineer | Experience in Data Engineering, Data Warehousing, DBT, Data Modeling, Analytics, and Project Management.

What is David Pickering's email address?

David Pickering's email address is da****@****ail.com

What is David Pickering's direct phone number?

David Pickering's direct phone number is +156767*****

What schools did David Pickering attend?

David Pickering attended The Ohio State University Fisher College Of Business, Capital University, Universidad Veritas.

What skills is David Pickering known for?

David Pickering has skills like Mysql, Php, Html, Bootstrap, Cascading Style Sheets, Github, Tableau, Highcharts, Microsoft Sql Server, Microsoft Excel, Public Speaking, Microsoft Office.

Not the David Pickering you were looking for?

  • David Pickering

    San Francisco Bay Area
    4
    intuit.com, gmail.com, gmail.com, five9.com

    5 +151053XXXXX

  • David Pickering

    Seeking To Find Or Build A Goodness Culture With Others.
    Minneapolis, Mn
    2
    impact-ps.com, gmail.com
  • David Pickering

    Portfolio Manager
    Greater Chicago Area
    2
    yahoo.com, pwcm.com

    2 +131258XXXXX

  • 6
    hotmail.com, eehealth.org, edward.org, gmail.com, iuhealth.org, stjude.org

    3 +163064XXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.