Jackie Sequeira
Squamish,BC
Summary
Analytical Merchandise Planner with seven years retail experience at MEC. Experienced in Supply Chain, Logistics, Allocations, and Customer Service. Uses collaborative approach and efficient decision-making leading to high-quality outcomes, including reducing large inventory overages to less than 10% over plan. Optimizes inventory and minimizes risk for retail partners by recommending strategic buying and promotional strategies. Extremely strong in Excel, data analysis, and presenting.
Overview
13
13
years of professional experience
Work History
Merchandise Planner
Mountain Equipment Company (Coop)
04.2021 - Current
- Identify ongoing opportunities and risks within a $75M hardgoods portfolio by actioning regular data review, reforecasting, and historical data blending to extrapolate trends
- Use executive financial targets to build future year's growth plans for replenishment and booked buying categories. Review plans regularly to ensure relevancy and communicate any risks and plan impacts to managing director
- Lead monthly business review meeting to discuss past performance and future risks with stakeholders to drive actionable outcomes
- Lead launch of new reporting data warehouse to drive more detailed reporting by adding retail KPI metrics, while reducing weekly processing time for team
- Created a strong relationship with cross functional team, including merchants and allocations, to strategize inventory management and business needs for short and long term success
- Working in Open To Buy to guide portfolio management decisions in next six months
- Scenario planning to gauge impact of delays or opportunities, especially in the current economically challenging environment
- Build, share, and report weekly KPIs to executive team
- SKU level inventory planning to estimate sell out of old product and optimize future buy quantity
- Maintained a regular check in with new members of Planning team for peer learning and troubleshooting
Assistant Inventory Manager
Mountain Equipment Company (Coop)
05.2020 - 04.2021
- Translate merchant’s sales forecast and inventory manager’s buying plan to multiple distribution centres and size curves
- Assisted with inventory planning and communicated with vendors to manage Snowsports buy
- Setting up store presentation levels for optimum product display and near-future forecasted sales
- Worked with EDI user acceptance project to help find and solve potential issues before system goes into production
- Problem solving with vendors and internal teams to resolve issues and optimal product display
Inventory Analyst
Mountain Equipment Company (Coop)
02.2019 - 03.2020
- Using historical sales information and cross-functional planning to maximize sales opportunities across Canada. Analyzed inventory for over 6000 SKUs, for items up to $7000
- Worked with merchant and planners to assess inventory. Recommended strategies informed by recent and long term inventory and financial information
- Represented team in cross-functional meetings to improve business practices and communication
- Final link to stores in a large brand launches and store openings ensuring the right product was ready on time
- Developed a close relationship with stores to improve work practices and advocate for store’s needs with business partners
- Summarized successes and opportunities for improvement of large product launches, promotions, and store openings
- Weekly reporting on internal supply chain and store performance to business partners
- Coordinated training to onboard new staff
Supply Chain Coordinator
Mountain Equipment Company (Coop)
08.2018 - 02.2019
- Day to day oversight of tasks allow for seamless transition of product from vendor to distribution centre
- Developed strong relationships with vendors to resolve issues relating to quantity, pricing, logistics, and compliance
- Coordinated vendor returns
Service Centre, Warranties and Returns
Mountain Equipment Company (Coop)
08.2017 - 08.2018
- Worked with coop members to solve issues relating to order fulfillment and product warranties to reach a mutually agreeable solution
- Processing member’s orders
Assistant Head Routesetter
The Hive Bouldering Gym
02.2017 - 08.2017
- Managing up to six routesetters to service 300+ users/day
- Routesetting and leading crew in daily work for appropriate distribution of routes
- Used accident reports to guide working practices
- Created health and safety summary documents
- Integrate customer feedback to find areas of improvement
- Supervised maintenance checks of wall and equipment
Head Competition Routesetter
Mountaineering Council of Scotland
05.2013 - 12.2016
- Coordinated with host wall to prepare efficient work plan
- Balance competition requirements with regular business needs to reduce impact on other facility users
- Management of crew during event preparation and all on-the-day routesetting related issues
Head Routesetter and Maintenance Manager
The Climbing Academy
09.2011 - 12.2016
- Scheduled route setting and maintenance for up to eight staff in daily and competition work
- Created tracking document to predict and manage workflow, manage employee productivity, and improve best practices
- Performance managed staff and volunteers for quality product
- Planned budget to ensure supplies would be available as needed, and for special opportunities
- Coordinated with contractors for centre’s repairs and maintenance
- Completed weekly and quarterly safety and maintenance checks
- Performed safety inspections and created reports for Forestry Commission of Scotland
- Worked with local schools and government to develop children’s climbing, performed inspections, and reported on current status
Education
Anthropology BA, Hons -
McMaster University
Procurement module -
Supply Chain Canada
01.2019
Skills
- Highly skilled in Excel including Power Pivot and Power Query
- Experienced in building and managing budgets
- JustEnough MFP
- ASR/AWR
- Power BI
- Reporting
- Budgeting
- Data analysis
Timeline
Merchandise Planner
Mountain Equipment Company (Coop)
04.2021 - Current
Assistant Inventory Manager
Mountain Equipment Company (Coop)
05.2020 - 04.2021
Inventory Analyst
Mountain Equipment Company (Coop)
02.2019 - 03.2020
Supply Chain Coordinator
Mountain Equipment Company (Coop)
08.2018 - 02.2019
Service Centre, Warranties and Returns
Mountain Equipment Company (Coop)
08.2017 - 08.2018
Assistant Head Routesetter
The Hive Bouldering Gym
02.2017 - 08.2017
Head Competition Routesetter
Mountaineering Council of Scotland
05.2013 - 12.2016
Head Routesetter and Maintenance Manager
The Climbing Academy
09.2011 - 12.2016
Anthropology BA, Hons -
McMaster University
Procurement module -
Supply Chain Canada
Similar Profiles
Ainsley MacdonaldAinsley Macdonald
Advisor at Mountain Equipment CoopAdvisor at Mountain Equipment Coop
Catherine FugulinCatherine Fugulin
Store Coordinator and Workforce Scheduler at Mountain Equipment CompanyStore Coordinator and Workforce Scheduler at Mountain Equipment Company
Brian CameronBrian Cameron
Store Advisor at Mountain Equipment CompanyStore Advisor at Mountain Equipment Company