Clive Malcolm
Hampton,US
Summary
Detail oriented professional with a proven track record of leveraging data-driven insights to drive strategic decision-making and enhance business performance. Possessing extensive experience in analyzing complex data sets, developing actionable insights, and implementing innovative solutions to optimize customer engagement and maximize profitability.
Overview
8
8
years of professional experience
Work History
Assortment Planning
Dollar Tree
Chesapeake, Virginia
04.2023 - 05.2024
- Develop and maintain assortment plans for the Category while investigating top and bottom performing products on a weekly basis and providing recommendations to the Category team
- Align item plans to category strategies, merchandise plans and open-to-buy, assessing trade-offs from inclusion of new items, providing merchandise financial planning recommendations
- Analyze actual business performance relative to plans and trends, reporting variances to plan
- Prepare reports required for analysis including recap of seasonal financial performances
- Propose action plans to capitalize on opportunities and mitigate risks
- Perform analysis of SKU and historical product performance to assist the Category Merchants with the development of the assortment
- Conducts in-depth SKU level pricing and profitability analyses
- Managed monthly P&L reports
- Enhanced store Volume grade group process by creating metrics that is specific to the assortment season to timeframe
- Led the three categories assortment analysis breakdown by urbanicity to improve assortment productive across eight thousand stores
- Created end of season excel report that tracks assortment sell through percentage and productive for each seasonal assortment
- Facilitated conversation about store profitability by urbanicity
- Presented recommendations to executive leadership that led to one thousand stores being close that lowered the company operating cost by 15%
- Developed strategic initiatives and collaborate with cross functional merchandise business partners to drive category performance
- Coordinated with management to gather, review and testing data to identify opportunities and solve problems for under preforming categories
- Led the category merchant teams in defining targets for the their assortment by urbanicity and price point
- Develop creative solutions to help business meet deadlines and obligations
- Trained cross functional business partners how to define assortment for their target consumer
- Created pricing models by zone to capture value of proposition that drives ROI to customer and business
Allocation Analyst
Dollar Tree
Chesapeake, Virginia
02.2022 - 04.2023
- Facilitated conversation for store volume grades by urbanicity.
- Presented recommendations to merchant partner for seasonal allocation strategy.
- Developed weekly tracker to track inventory flow by DC.
- Led MAP meeting with cross functional business partners to ensure alignment on product allocation.
- Analyzed weekly sales report to gain insight on top items
- Develop creative solutions to help business meet deadlines and obligations.
- Trained cross functional business partners how to analyze volume grades
- Manage over 700 fashion SKUs
Financial Analyst
BridgeCrest
Mesa, AZ
08.2016 - 01.2022
- Develop reports to track quarterly performance.
- Optimized action plans to examine feasibility of deals and prepare a plan of action based on financial analysis.
- Created excel report for my team to simplify preforming cost analysis which led to providing better recommendation to leadership to use for strategic decisions.
- Created and manage quarterly P&L reports to present to leadership.
- Facilitate monthly meetings with team to analyze sales and market trends.
- Develop automated report to forecast weekly sales.
- Collect and analyze data from industry and provide recommendation to gain market shares
Education
Bachelor of Arts, Business Admin -
Arizona State University
05.2015
Skills
- Analyzing and interpreting data
- Writing SQL Queries
- Financial Planning SAS Software
- Collaborative work
- Leveraging data analysis
- Microsoft excel
Timeline
Assortment Planning
Dollar Tree
04.2023 - 05.2024
Allocation Analyst
Dollar Tree
02.2022 - 04.2023
Financial Analyst
BridgeCrest
08.2016 - 01.2022
Bachelor of Arts, Business Admin -
Arizona State University
Similar Profiles
Ronin AndersonRonin Anderson
General Maintenance Technician at Family Dollar/dollar TreeGeneral Maintenance Technician at Family Dollar/dollar Tree
Darlene CadoreDarlene Cadore
Regional Human Resources Manager at Dollar Tree-Family DollarRegional Human Resources Manager at Dollar Tree-Family Dollar
Alexis JenkinsAlexis Jenkins
Assistant Manager at Family Dollar/ Dollar TreeAssistant Manager at Family Dollar/ Dollar Tree
Jadon EdwardsJadon Edwards
Bulk Order Filler at Dollar Tree and Family Dollar Distribution CenterBulk Order Filler at Dollar Tree and Family Dollar Distribution Center
Lynise WatkinsLynise Watkins
Team Leader at Securitas Security Services USATeam Leader at Securitas Security Services USA