Juan Buitrago

Data Analyst II

Relay

May 2024 - Current (2 years 1 month)

Business Intelligence Analyst

OSL Retail Services

Oct 2023 - Apr 2024 (7 months)

• Business Intelligence lead for our client, Exchange, the largest military government retailer in the US • Worked with the VP of Sales & the Managing Director to build out a detailed 1.5-month roadmap for the dashboard launch & delivered 1 week ahead of schedule to 30+ users within client group • Defined data requirements across 10+ sources, led the development of ETL workflows & implemented rigorous validation processes, achieving a 97% data accuracy rate • Built & maintained project management tracker while deploying dashboards for sales, labour, productivity, inventory & commissions replacing 30+ hours of manual report pulling every week

C

Analytics Consultant

Cundari Co

Jul 2023 - Dec 2023 (6 months)

• Led end-to-end deployment of dashboards for 5 clients, including Speedy Auto Service, Speedy Glass & Ontario Science Centre • Worked directly with clients to gather business requirements & accurately scope timelines, cost & platform requirements • Built and launched all dashboards on Looker Studio with a 60% reduction in time to deployment by the 3rd dashboard • Assisted in putting together pricing proposals & project deliverables to sell BI as a service

Operations Analyst

OSL Retail Services

Jan 2023 - Oct 2023 (10 months)

• Led analytics within the Bell door-to-door sales program managing 1200+ agents across Canada using DOMO, Salesforce & ADP to track KPIs • Played an integral part in the 6-month transition from manual excel reporting to real-time dashboards using a data visualization tool called DOMO; improved reporting accuracy by 23% while removing 20+ hours spent running reports every week • Built, implemented & managed a monthly sales target setting/forecasting process taking into account the channel, region, agent tenure, headcount & past performance; improved target accuracy by 7% and replaced 30+ hours of work for Directors every month • Analyzed and presented a revamped Performance Management System taking into account agent performance quartiling,

F

Junior Analyst

Framework Venture Partners

May 2022 - Sep 2022 (5 months)

• Sourced and evaluated companies against Framework’s investment thesis across numerous industries including fintech, edtech & AI • Assisted in building reports & dashboards in CRM (Salesforce) while monitoring data quality • Conducted initial due diligence on 7 potential investments, including market research and analysis, financial modelling, unit economics and team evaluation • Contacted 500+ start-ups, met with 100+ founders and built relationships with 20+ VCs

L

Boost Program Founder

LOI League of Innovators

Jan 2022 - Dec 2022 (1 year)

Boost Residency is 12-months, designed and focused on supporting young entrepreneurs who are building scaling startups in Canada. Board of directors includes Ryan Holmes, Manny Padda, Michele Romanow. Accepted into cohort with Prep'd Fresh.

K

Strategic Advisor

KitchenFuel

Nov 2020 - Jun 2023 (2 years 8 months)

• B2B SAAS platform for the meal prep industry; co-founded through Prep’d Fresh • Built the initial GTM strategy and crafted the 2-year product roadmap with dev team • Managed sales operations from prospecting through demos to close, converting at 36% rate • Transitioned to a strategic advisor, providing feedback on operations, product & fundraising • In this span, 3 new platform versions have been launched and 15 clients have been signed (500% ARR growth)

Sales Analyst

Newell Brands

Jan 2020 - Jun 2021 (1 year 6 months)

• Led the analytics department across Canada for 2 separate business units ($250M) at public CPG company; presented quarterly & yearly business reviews to Executives (S&M, Finance) • Worked cross-functionally to clean up data sources & set workflows to maintain data quality; improved reporting accuracy by 21% • Created customer business intelligence reports via Excel, PowerBI to support sales team in tracking KPIs and analyzing current business trends including Vendor Performance Scorecards, YTD/MTD/WTD POS analysis and promotional activity trackers (ROI/Lift %) • Built visual dashboards via PowerBI & Tableau to support sales & marketing with pitch decks • Worked with Director of Sales to understand business inefficiencies such as Lost Sal

P

Founder

Prepd Fresh

Jan 2018 - Jul 2023 (5 years 7 months)

• Founded a healthy, ready-to-eat meal delivery service targeted at busy moms • Drove an efficient sales engine bootstrapping to $550K+ revenue since inception (averaged 141% YoY growth) • Landed a partnership with the largest restaurant group in Hamilton to become sole food provider delivering 35,000+ meals to 1,700+ families across Southern Ontario since March 2020 • Employed 31 people managing end-to-end process including sales, operations, marketing, finances, customer acquisition & user experience • Built weekly analytics reports & dashboards using Looker & Excel to track sales funnels, finances, cashflow, user data, website data & cohort analysis • Led the negotiation and sale of the Prep'd Fresh customer base to HealthyNow in July 20

Finance Intern

Mosaic North America

Sep 2017 - Aug 2018 (1 year)

• Analyzed and closed out over $1 Million in outstanding Purchase Orders (PO’s) at year-end using innate problem-solving skills and received a recognition note from GM for leading the project and driving results. • Completed Trial Balance variance analysis for Controller group on a weekly basis • Collaboratively worked with project accounting team to manage 100’s of ongoing activations and created over 1000 new projects

Brand Ambassador

Mosaic North America

Feb 2017 - Aug 2018 (1 year 7 months)

Created exciting and memorable brand experiences for consumers. Sampled multiple brands, such as Sprite, Nescafe and Jackson-Triggs while enhancing consumer interactions, driving awareness of the product and generating shareable content. Represented the Brands in a professional and respectful manner.

M

Assembly Worker

Modatek Systems

Jun 2016 - Jun 2017 (1 year 1 month)

Produced components by assembling parts and subassemblies. Maintained safe and clean working environment by complying with procedures, rules, and regulations. Contributed to team effort by accomplishing related results as needed.

Y

Swim Instructor & Lifeguard

YMCA of Greater Toronto

Sep 2013 - Aug 2015 (2 years)

Demonstrated initiative and organization skills in planning, coordinating and teaching learn-to- swim and water safety courses. Effectively created a safe environment for swimmers and taught over 150 kids proper swimming techniques. Energetically interacted with customers in a positive manner to create welcome surroundings. Recognized and responded effectively in emergencies in accordance with facility emergency action plans. Developed problem solving skills to ensure proper action taken when required. Administered first aid and CPR as required.

About

Detail

Timeline

Résumé