Clive Malcolm
Virginia Beach,VA
Summary
Business Analytics professional with 13+ years of experience delivering data-driven solutions across finance, supply chain, inventory, and retail operations. Skilled in SQL, financial modeling, forecasting, KPI development, and business intelligence, with a proven ability to translate complex data into strategic recommendations that improve operational performance and profitability.
Overview
14
14
years of professional experience
Work History
Senior Analyst, Inventory Accounting
Family Dollar
Chesapeake, VA
01.2023 - Current
- Built and maintained enterprise inventory reporting to monitor shrink, inventory accuracy, discrepancy trends, and financial performance.
- Developed and tracked KPIs and OKRs measuring inventory health, operational efficiency, and cost performance to support executive decision-making.
- Conducted opportunity sizing, root cause analysis, and financial impact modeling to identify process improvements and drive cross-functional initiatives.
- Delivered actionable insights and strategic recommendations to senior leadership, improving inventory visibility and operational performance.
Analyst – Real Estate Strategy & Spatial Analytics
Family Dollar
Chesapeake, VA
05.2019 - 12.2022
- Developed sales forecasting models and spatial analytics supporting site selection for a network of 7,000+ stores across North America.
- Produced sales, profitability, and cannibalization forecasts to guide real estate investment and market optimization strategies.
- Partnered with Finance, Real Estate, Operations, and Asset Protection to evaluate market opportunities and optimize store deployment.
- Delivered executive reporting, forecast audits, and GIS-driven analyses that improved forecasting accuracy and supported portfolio growth.
Assortment Planning Analyst
Dollar Tree
Chesapeake, VA
03.2016 - 04.2019
- Analyzed SKU- and category-level performance to support assortment planning, product strategy, and financial decision-making.
- Built assortment plans, financial models, and seasonal performance recaps to measure business results and support category objectives.
- Partnered with IT and business stakeholders to enhance planning systems, improve reporting, and streamline operational processes.
Financial Analyst
BridgeCrest
Mesa, AZ
01.2013 - 02.2016
- Performed P&L analysis, pricing strategy, and profitability modeling to identify financial risks and business opportunities.
- Built Excel dashboards, automated reports, and financial models that improved reporting efficiency and decision-making.
- Led financial impact modeling for a portfolio optimization initiative that recommended closing 1,000 locations and reduced operating costs by 15%.
Education
Bachelor of Arts - Business Administration
Arizona State University
Tempe, AZ03.
Skills
- SQL, Excel (pivot tables, macros, VLOOKUP), Power BI, Tableau, SAS, IBM Planning Analytics, SAP, MicroStrategy, Lawson, Relex, ERP Systems (replenishment, pricing, promotions, vendor portals)
- Opportunity Sizing, Impact Modeling, KPI/OKR Development, Product Performance Reporting, Financial Modeling, Forecasting
- Cross-functional Stakeholder Partnership, Executive Presentations, IT & Product Team Alignment, Vendor Management
Timeline
Senior Analyst, Inventory Accounting
Family Dollar
01.2023 - Current
Analyst – Real Estate Strategy & Spatial Analytics
Family Dollar
05.2019 - 12.2022
Assortment Planning Analyst
Dollar Tree
03.2016 - 04.2019
Financial Analyst
BridgeCrest
01.2013 - 02.2016
Bachelor of Arts - Business Administration
Arizona State University