CAREERS
    CONTACT US
    sbi_logo_positif240x240px_cropped
    Back to achievements

    From Excel to HR Agility with Pigment

    • Practice
    EPM HR Planning
    • Team

    1 Project Manager
    1 Business Expert
    1 Solution Architect
    1 Solution Modeler

    • Technical environment
    Efficiency
    Manual processes eliminated
    Scalability
    Platform ready for FP&A extension
    Collaboration
    Structured dashboards across UAE, UK & US
    CHALLENGES

    This global, leading cosmetics brand faced growing HR planning complexity, with around 250 employees across the UAE, UK, and US.

    • Manual, Excel-based processes: HR reporting relied on spreadsheets, making consolidation, planning, and reporting challenging and time-consuming.
    • Limited scalability: The absence of a modern planning platform prevented effective collaboration across global entities.
    • Lack of visibility: Resources cost forecasting, headcount planning, and expense analysis were difficult to track and consolidate consistently.
    • Growing organizational needs: A fast-evolving organization required a solution to support accuracy and timeliness for better decision-making.
    SOLUTION

    SBI implemented Pigment, a modern planning and reporting platform, enabling the company to move from manual spreadsheets to collaborative, data-driven planning.

    • Employee-based headcount planning: Structured forecasting of hires, leavers, FTEs, and position details across departments and regions.
    • Cost planning: Country-specific gross-to-net calculations tailored to local rules (UAE, UK, US), integrating benefits, taxes, bonuses, and employer contributions.
    • Integrated architecture: Seamless data flows from BambooHR (native connector), Microsoft Dynamics 365 (via Microsoft Fabric and API), and manual Excel inputs.
    • Unified reporting: Dashboards and financial reports with drill-down by entity, department, and cost center, enabling version comparison and variance analysis.
    BENEFITS
    • Consolidated planning: A single platform for headcount, costs, and HR reporting, replacing fragmented Excel files.
    • Enhanced accuracy and timeliness: Automated cost calculation for each allowance type, with the option for manual adjustments for any exceptions.
    • Multi-country support: Cost calculation logic adapted to UAE, UK, and US specificities, with support for multiple currencies.
    • Scalability: A foundation ready to extend to other functions such as FP&A, enabling enterprise-wide planning capabilities.