Business Analyst Home Depot

Donald L. Bywaters Jr. 678-***-****

**** ******** ** **, ********, GA 30144 **************@*****.***

Professional Profile

A self-motivated, detail-oriented business professional with more than fifteen years of diverse experience in National Accounts, Category Management, Business Analytics, and Merchandising.

Summary of Qualifications

●Category Management

●Project Management

●Data Visualization and Statistical Analysis

●Inventory Analysis

●Data Mining

●Merchandising / Planograms

●Forecasting

●National Accounts

●Brand Management

●Business Development

●Strategic Thinking

●Customer Service

●PowerPoint Presentations

●Business Reporting

Professional Experience

The Home Depot

November 2022 – May 2024

Senior Business Analyst – Home Services

Lead all phases of a project's life cycle including defining the business need, establishing criteria and business requirements, understanding the impact to the business and designing and rolling out the project.

Serve as a subject matter expert and perform research and/or analysis within assigned projects or category of business.

Establish and report on metrics of assigned projects or categories to gauge business value

Achievements:

2023 – Homer Award

The Ames Companies

March 2017 – June 2022

Retail Business Analyst

Responsibilities

Inventory analysis

Evaluated Weekly In-stock Trends

Year over year Brand Trends

Develop product/planogram clusters based on product design, sales, and type of soil

Collaborated with team members and cross-functional teams to ensure projects completed efficiently to meet deadlines.

Collaborate with sales team to develop reports, presentations, and scorecards for internal and external clients.

Achievements:

2018 – Appointed Home Depot Planogram Captain for LHTD280

2019 – Named Home Depot Category Captain for LHT (long handle tools) D28O

Philips Lighting, Kennesaw, GA

July 2016 – February 2017

Marketing Analyst II (Contractor)

Responsibilities:

Evaluated product placement based on space to sales analysis

Analyzed product productivity using on dollar sales per point of distribution and units/trays per week per store

Participated with cross functional teams to update/revise planograms for Home Depot Gold Standards Project

Lewis Hyman Inc., Atlanta, GA

April 2015 – December 2015

Category Manager

Responsibilities:

Oversaw 4 product categories totaling $47 million for Home Depot, Lowe’s, and Menards

Collaborated with 5 Strategic Business Managers to identify opportunities within the retail division

Produced benchmarks to measure the performance of new items. Monitored the progress for 120 days in order to develop business decisions for long term product placement

Assisted in the development of newly developed ecommerce business which included reports, benchmarks, and strategies

Implemented Category Management procedures

Designed POS reporting system for the 3 major retail accounts as well as ecommerce

Improved product assortments thru space to sales analysis and/or GMROI

Executed adjustments to floor plans by means of product performance, adjacencies, and locations

Quikrete – Pavestone, Atlanta, GA

April 2006 – April 2015

Home Depot – National Account Business Analyst

Achievements:

2007 – Named Home Depot Category Captain for D28O

2010 – Received Pavestone Employee of the Year Award

2012 – Appointed Home Depot Planogram Captain for all D280

Responsibilities:

Assisted with strategies and analysis that help facilitate account revenue growth from yearly sales of $185 million in 2006 to $251 million in 2014

Facilitated weekly meetings/calls with Home Depot Global Merchant to strategize new goals and review sale metrics

Planogram captain – Oversaw production of 1900+ Home Depot stores, 6 different subclasses, 1100+ planograms

Integrated product into Item Data Management for stores, ecommerce, and special order

Created scorecard for Pavestone National Operations Division to monitor and assess division’s ability to meet customer service expectations in relation to complete and timely delivery of products. Continuously maintain the accuracy and validity of the data as provided to Operations Executives and managers.

Built from scratch business analysis policies and procedures that are still in use company wide

Pivotal in launching ecommerce – Rumble Stone Kit program on HD.com via Commerce Hub. Generate weekly reports that show sustained growth of close to $1 million in second year of business

Assisted Regional and District Managers to identify sales strengths and opportunities in their territory/stores through fact-based analysis

Managed HD Inventory to generate sufficient stock levels for new product integration, national sale events, and store exception orders to ensure inventory levels are acceptable based on COR/CAR’s target effective index.

Scotts Miracle-Gro, Atlanta, GA

January 2005 – April 2006

Home Depot – Business Analyst (Fertilizer and Seed)

Responsibilities:

●Worked on 3 categories totaling $180 million in Home Depot retail sales

●Presented Home Depot weekly sales trends to executive team

●Participated in cross functional team to communicate events and strategies

●Perform market research to identify emerging trends and possible threats

●Explored opportunities to strengthen sales for Home Depot and Scotts through planograms analysis and product performance

●Manage SKU maintenance for almost 100 items in 174 markets in internal system and HD IBM system

Newell Rubbermaid – Goody Division, Atlanta, GA

March 2003 – January 2005

Category Manager

Responsibilities:

●Key point of contact for the Target National Account - $28 million in sales for 2004

●Participated and collaborated on account presentations with sales team members

●Built account specific product assortment based on account’s strategy and target market

●Examined product mix performance and make necessary adjustments to improve productivity

●Analyzed competitors’ performance within the category, markets, and regions

●Provided category expertise and insight to internal customers for brand, product and promotional planning

●Created and coordinated exit strategies and/or returns procedures when necessary

Education

Florida Atlantic University, Boca Raton, FL

Bachelor of Science, Business Management – Magna Cum Laude

May 2000

Software Knowledge

●Advanced Knowledge in Microsoft Access, Excel, PowerPoint and Word

●IRI Syndicated Data

●JDA Space Planning

●JD Edwards

●Showcase Reporting

●Salesforce

●Tableau

●Tableau Prep builder

●IDM (HD Item Data Management)

●Hyperion/Essbase

●Data Alchemy

●SAP

●Salesforce

●AS-400

●Data Mining

●Vendor Drill

References available upon request.

Contact this candidate