Finance Business Partner – FP&A, Professional Services, Outside Sales & Marketing
Home depot
Total years of experience :7 years, 1 Months
• Leadership & Ownership: Promoted to manage Home Depots 3 largest portfolios totaling $6.7B; budgeting (bottom up), forecasting, strategic planning supporting SLT (4 directors and 2 VPs)
• Strategy & Collaboration: Collaborated with Sales and Marketing to develop and implement strategies, significantly boosting sales and margins. Enhanced overall strategic initiatives, including launching a distribution center and diverse pricing tactics, further increasing sales and margins.
• Financial Management: Led semi-annual budgeting and weekly forecasts for 4 business units, aligning with sales goals; maintained budget compliance by developing financial models and reports detailing variances from last year and projections.
• Month End Close: Managed monthly accruals and month-end closes in coordination with Accounting teams
• Data & Analytics: Regularly provided SLT with key business insights through expertly crafted dashboards (tableau), highlighting sales metrics, targets, profitability analysis, and more, enabling informed strategic decisions. Played a crucial role in reporting, encompassing revenue, margin analysis, and KPI evaluations.
• Technical Prowess: Enhanced and automated reporting processes to ensure swift responses to ad hoc requests utilizing tools such as Microsoft Excel, PowerPoint, GBQ, Tableau, Python
• Process Improvement & Best Practices: Continually refined financial planning procedures while simultaneously identifying areas of process streamlining, complexity reduction, and data accuracy
• Budget Forecast: Led and built bottom-up budget process for the portfolios $250M Sales, 30 Commercial/National Account Managers. Devised and implemented an advance forecasting model (OLAP), leading the forecast process for MRO and Outside Sales. Conducted weekly reviews with senior managers to ensure accuracy and alignment (mix/rate analysis, margin analysis, regional profitability)
• Strategic Finance Management: Led and completed a comprehensive business case analysis for the outside sales portfolio, analyzing the US and Canadian markets. Determined the optimal number of accounts an Account Manager should manage leading to a margin increase of 1200 bps
• Collaboration & Strategy: Collaborated with category owners to provide strategic recommendations on pricing and promotions for SKUs and product categories targeting specific regions and customer professions.
• Process Improvement & Technical Prowess: Automated financial models using Tableau, SAP, Google Big Query (GBQ), and SQL to facilitate real-time decision-making and increase sales opportunities.
• Sales Growth & Profitability: Enhanced sales growth and profitability across 6 key categories including Hot Dogs, Sausages, Lunch Kits, Canned Meats and more.
• Budget & Forecast Management: Oversaw the forecast and budget process for six categories (3 budget cycles, 60M Kg, $120M GP), aligning financial strategies with company targets.
• Financial Analysis & Support: Provided comprehensive financial analysis supporting commercial teams, including consumer pricing, sales mix analysis, and profitability analysis for product initiatives.
• Product Costing & Launch: Led the costing and launch of 15 products, coordinating with manufacturing facilities and leading supply chain, pricing, and promotions strategies.
• Strategy Capital Expenditure & ROI: Successfully managed 3 Capital Expenditure Requests totaling $10 million, creating RONA models and conducting sensitivity analyses, securing CEO approval.
• Forecasting & Budgeting: Developed and managed intricate forecasting/budgeting models for retail expenses across 190+ stores.
• Journal Entries & Accruals: Responsible for monthly journal entries involving Opex accruals and adjustments.
• P&L Analysis: Provided detailed P&L analysis, identifying top and bottom performers across all channels.
• Variance Analysis & Reporting: Conducted variance analysis on financial results, comparing against plan and previous year, and ofered in-depth explanations of key drivers and material variances.
• Financial Systems Expertise: Utilized various financial systems including Oracle, Hyperion, Essbase, and People Soft for financial management and reporting.
Finance, Economics,
URL removed due to policy violation. Please contact support for further information.