Andrew Marcotte

Experience

• 

  American Campus Communities

  Oct 2018 - Jan 2019

  Leasing Assistant

  • Oversaw leasing process for future residents including tours of the model showroom, creating lease files, and follow-up calls • Utilized administrative skills such as managing applicant metrics, engaging in marketing campaigns, and customer interactions

• 

  Cresa Boston

  Jul 2019 - Dec 2019

  Project Management Co-op

  • Maintained multi-million dollar tenant improvement project budgets in Excel, regularly visited job sites, and served as an intermediary between clients and vendors.• Guided vendor onboarding and oversight process. Developed RFP packages including upfit proposals consistent with client goals and leveling documents for client deliverables. Coordinated vendor installations to align with project schedule.• Participated in weekly meetings with senior level management and clients to strategize projects and document progression for 7 tenant improvement projects valued at over $25.5MM.• Increased efficiency by expediting expense reporting using raw data in Excel to properly allocate employee reimbursements. Show less

• 

  Boston Consulting Group (BCG)

  Jan 2021 - Jul 2021

  Global Specialty Businesses Finance & Analysis Co-op

  • Facilitated full-time employee and project reporting file maintenance by running weekly Excel reports with advanced formulas to identify employee office transfers, LOAs, terminations, and bill rate updates, then leveraging Oracle software to ensure internal financial records were properly updated.• Created a biweekly overtime report in Excel for six US offices to validate employee overtime pay.• Verified employee records by communicating with global finance and HR teams to cross-check platforms including Workday.• Streamlined timesheet submittals by creating an Alteryx workflow and Tableau visualization stemming from a raw set of timesheet data that reminded employees to submit weekly timesheets, forecasted to increase global billable revenue by $10MM+ annually. Show less

• 

  Cresa Boston

  Nov 2021 - Jun 2022

  Project Management Advisor

  • Returned to support former team on an interim basis upon graduation while exploring full-time career path within chosen discipline.

• 

  Stax - a global strategy consulting firm

  Jul 2022 - Jul 2023

  Associate Consultant

  Stax is a global strategy consulting firm serving corporate and private equity clients across a broad range of industries. The firm partners with clients to provide data-driven, actionable insights designed to drive growth, enhance profits, increase value, and make better investment decisions.