Andrew Franks

Andrew Franks Email and Phone Number

Material Planner @ Welch's
Waltham, MA, US
Andrew Franks's Location
Waltham, Massachusetts, United States, United States
Andrew Franks's Contact Details
About Andrew Franks

I am an analytical and detail-oriented professional with a diverse background encompassing supply chain and sustainability. Skilled in problem-solving, data analysis, and strategic planning, I have successfully managed inventory, calculated carbon footprints, and streamlined reporting processes. My expertise in Microsoft Office, Google Suite, and analytical tools such as Tableau and Excel enable me to generate valuable insights and drive informed decision-making. With an MBA and a strong foundation in environmental studies and biology, I possess a unique blend of business acumen and sustainability knowledge. I am a collaborative team player committed to delivering results and contributing to positive change in any organization.

Andrew Franks's Current Company Details
Welch's

Welch'S

View
Material Planner
Waltham, MA, US
Website:
welchs.com
Employees:
781
Andrew Franks Work Experience Details
  • Welch'S
    Material Planner
    Welch'S
    Waltham, Ma, Us
  • Anthesis Group
    Senior Consultant
    Anthesis Group Aug 2023 - Sep 2024
    London, England, Gb
  • Preserve
    Senior Supply Chain And Sales Analyst
    Preserve Mar 2023 - Aug 2023
    Waltham, Ma, Us
    • Calculate annual carbon footprint across Scopes 1, 2, & 3, and advised on reduction opportunities. Documenting process for future years.• Create, update, and document annual end of year reporting for C-level management team, Board of Directors, and shareholder newsletter.• Performing ad hoc analysis and process improvements based on current company needs. Ex: Created new Excel tool in that automatically transforms invoices exported from QuickBooks into the necessary format for client upload, saving up to minutes of manual work per day.
  • Climatepartner
    Sustainability Consultant
    Climatepartner Nov 2022 - Mar 2023
    München, Bayern, De
    • Managed multiple clients to gather carbon footprint data and calculate Scopes 1, 2, & 3 emissions according to GHG Protocol.• Built Excel tool using VBA to speed client product evaluation.• Participated in two month long onboarding and sustainability education covering carbon accounting, climate mitigation projects, GHG Protocols, and ISO Standards.
  • Preserve
    Senior Sales And Supply Chain Analyst
    Preserve Apr 2020 - Oct 2022
    Waltham, Ma, Us
    • Calculated annual carbon footprint across Scopes 1, 2, & 3, and advised on reduction opportunities.• Planned, ordered, and maintained supply and inventory of over 500 parts and finished goods across several manufacturing sites.• Built, maintained, and updated weekly, monthly, quarterly, and annual reports for C-level management team.• Managed new product development setup in all internal company systems from accounting to supply chain.• Collaborated with COO and business analyst to design, update, and clarify Excel order tracker to calculate vendor KPIs.
  • Preserve
    Supply Chain Manager
    Preserve Dec 2017 - Apr 2020
    Waltham, Ma, Us
    • Calculate annual carbon footprint across Scopes 1, 2, & 3, and advised on reduction opportunities.• Planned, ordered, and maintained supply and inventory of over 500 parts and finished goods across several manufacturing sites.• Streamlined and documented process improvements in reporting, inventory management, and purchase planning.• Managed new product development setup in all internal company systems from accounting to supply chain.• Collaborated with COO and business analyst to design, update, and clarify Excel order tracker to calculate vendor KPIs.
  • Museum Of Science
    Overnights Instructor
    Museum Of Science Oct 2017 - Oct 2020
    Boston, Ma, Us
    Prep, run, and cleanup evening drop-in activities for overnight participants.
  • The Green Line Market
    Consultant To The Ceo/Founder
    The Green Line Market Jul 2017 - Jan 2018
    Cambridge, Ma, Us
    Advising early stage sustainable ecommerce site on investment pitching, strategy, and establishing operations processes.
  • Babson College
    Mba Candidate, Business Analytics Concentration
    Babson College Aug 2015 - May 2017
    Babson Park, Ma, Us
    • Team Management and Marketing: Managed, mentored, and coached team of five undergraduates to deliver a successful consulting project on time for a farm in suburban Boston. The team developed a marketing plan based on primary and secondary research for a new hard cider business line and take advantage of multiple emerging trends in the beverage industry.• ESG Investing: Developed five novel environmental and social metrics to measure investment fund impacts for an asset management firm located in Boston, MA. Established them as a leader for measuring the external impact of equities investments.• Strategic Planning: Developed a five year strategic plan for a conservation land trust Board of Directors to revitalize and implement industry best practices. Interviewed dozens of experts in land conservation to establish benchmarks.• 2017 Patagonia Case Competition Finalist: Developed novel methods to support and improve supply chain sustainability around regenerative agriculture.• Program Evaluation: Used R Studio to analyze the reach and performance of Franklin Park Zoo summer ZooTeen program.
  • Preserve
    Mba Summer Intern
    Preserve May 2016 - Aug 2016
    Waltham, Ma, Us
    • Analyzed consumer survey data from over 800 respondents for profiles of target customer segments.• Managed shipping process for 5-10 orders weekly from manufacturer to distributor.• Created and designed engaging website material for children in conjunction with a National Wildlife Foundation partnership. (Linked below)• Found opportunities for a 10% improvement on the B Corp certification reassessment.
  • Zoo New England
    Education Specialist
    Zoo New England Oct 2011 - Jun 2015
    Boston, Massachusetts, Us
    • Improved family program success rate from 10% to 75% through new targeted, cost-efficient marketing measures.• Redesigned and implemented Zoo's homeschool program on a semester schedule. Created three years of new curriculum.• Played a pivotal role in renewing a positive relationship with the Animal Management Department by collaborating on training new program animals for educational use.• Co-managed, mentored and trained 10-15 college interns and 8-10 ZooTeens during the school year and summers.• Participated in the Fall 2014 National Network for Ocean and Climate Change Interpretation (NNOCCI) Study Circle (see projects)• Successfully designed and implemented the first annual Zoo Clue Challenge (September 2014), a multi-step scavenger hunt across the Zoo for 20 people in 5 teams.
  • Zoo New England
    Exhibit Interpreter
    Zoo New England May 2011 - Sep 2011
    Boston, Massachusetts, Us
    • Interpreted on zoo grounds to enhance visitor experience and educate zoo guests• Co-supervised college interns• Co-lead the 11 Education Department ZooTeens, including orientation, training, and serving as a reference and mentor• Planned and taught classes for schools (June) and summer camps (July-August)
  • Greater Boston Museums, Nature Centers And Environmental Organizations
    Part-Time Informal Science Education For Multiple Organizations
    Greater Boston Museums, Nature Centers And Environmental Organizations Mar 2010 - Sep 2011
    After moving back to Boston in March 2010, I worked hard to break into the informal science education field, a popular industry with few full-time positions, by volunteering or working part-time at six different organizations (up to four at one time!). This broad approach, a strong work ethic, and persistence paid off. I worked myself into a full-time job in the Boston area in ~18 months, which is less than the typical two to three years in this field. I'm happy to provide the details of which organizations I worked at from March 2010 to September 2011 upon request. Below is a generalized description of these positions:• Delivered exciting, engaging and educational public presentations for groups of 10-200 people• Developed curricula and talks on climate change, coral reefs, winter survival, and team building.• Analyzed donor databases to target potential donors for fundraiser.
  • Global Custom Commerce
    Accounting Assistant
    Global Custom Commerce Dec 2009 - Mar 2010
    Houston, Texas, Us
    • Spearheaded company-wide Green Week, bringing a spotlight to energy and material saving measures.• Saved up to 2 hours per day in time by streamlining sales analytics and metrics by combining Excel spreadsheets. Also implemented VLOOKUPs into new software integration tests, also saving hours of time per week.• Trained new cost analyst and new accounts receivables clerk in the previously mentioned spreadsheets and related job duties.
  • Aspen Center For Environmental Studies
    Summer Naturalist
    Aspen Center For Environmental Studies Jun 2009 - Aug 2009
    • Designed and led guided nature walks for the public• Developed lesson plans and taught classes for children ages 4-8.• Greeted visitors and answered phones at the Hallam Lake Nature Center.
  • Conservation Capital
    Summer Intern
    Conservation Capital Jun 2008 - Aug 2008
    • Authored a section on Park Funding Structures in a major report for the City of Houston.• Researched and wrote sections of feasibility analyses for clients that utilize land value while maintaining green space.• Trained office of five how to use GIS software for effectively mapping projects to create better maps for client reports.

Andrew Franks Skills

Public Speaking Teaching Nonprofits Microsoft Office Microsoft Excel Community Outreach Environmental Awareness Powerpoint Environmental Education Program Development Event Planning Program Management Outdoor Education Microsoft Word Team Leadership Data Analysis Nonprofit Organizations Microsoft Sql Server Research Tableau R Spss

Andrew Franks Education Details

  • Babson F.W. Olin Graduate School Of Business
    Babson F.W. Olin Graduate School Of Business
    Business And Social Innovation Intensity Track
  • Brandeis University
    Brandeis University
    Biology
  • Semester In Environmental Science At The Marine Biological Laboratory
    Semester In Environmental Science At The Marine Biological Laboratory
    Environmental Science

Frequently Asked Questions about Andrew Franks

What company does Andrew Franks work for?

Andrew Franks works for Welch's

What is Andrew Franks's role at the current company?

Andrew Franks's current role is Material Planner.

What is Andrew Franks's email address?

Andrew Franks's email address is an****@****ner.com

What schools did Andrew Franks attend?

Andrew Franks attended Babson F.w. Olin Graduate School Of Business, Brandeis University, Semester In Environmental Science At The Marine Biological Laboratory.

What skills is Andrew Franks known for?

Andrew Franks has skills like Public Speaking, Teaching, Nonprofits, Microsoft Office, Microsoft Excel, Community Outreach, Environmental Awareness, Powerpoint, Environmental Education, Program Development, Event Planning, Program Management.

Who are Andrew Franks's colleagues?

Andrew Franks's colleagues are Saul Alvarez, Randy Hoekstra, Andy Kavjian, Allison Robinson, Laila Baloshi, Kanyon Higley, Stu Sevene.

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.