Projects
Case Studies Across Verticals
EPM Development & implementations, Solution Arcitecture, Business Process Management & Transformation.
Discretionary / Non-Discretionary Spend Reporting
✔️ Delivered· Anaplan model building · multi-currency design · Dynamic Cell Access (DCA) · UX/front-end Configuration Design · Stakeholder Requirements Gathering
Problem — Prior to this solution, spend reporting was manually consolidated across regional spreadsheets in different currencies, creating delays, version control issues, and inconsistent categorization of discretionary vs. non-discretionary costs. Regional finance teams also had no ability to adjust report structure without raising a change request to the central Anaplan/IT team.
Outcome — The solution consolidated spend from multiple regional sub-models into a single governed Anaplan model, combining base-currency global reporting with preserved local-currency views through a scheduled dynamic exchange rate module, while a front-end configuration layer let business users self-service new report line items (mapped to existing GL accounts and cost centres) without model builder involvement; Dynamic Cell Access and standard role/region-based controls kept sensitive regional data appropriately segregated, and dashboards supported drill-down from global summaries to local-currency detail in one model — collectively cutting report structure change turnaround from a multi-day IT cycle to same-day self-service, improving cross-regional reporting consistency and auditability, and freeing the technical team from routine maintenance for higher-value work.
Instanced (User-Based) Hierarchy Management
✔️ Delivered· Anaplan list architecture · DataHub integration (spoke-to-hub model) · access control design · data governance · scalable multi-user model design
Problem — In standard Anaplan list structures, concurrent edits by multiple users to shared hierarchies can create conflicts, overwritten data, or the need for rigid sequential workflows. The organization needed a way for many users to manage and test their own list items — without duplicating the entire model per user, which would be unsustainable at scale.
Outcome — The solution used an instanced 'fake user' list structure to simulate isolated private workspaces for each user within a single shared Anaplan model, with granular access controls restricting list item creation and viewing to each user's own instance to prevent cross-user visibility or edits, while a spoke-to-hub integration with the organization's DataHub pushed finalized data downstream into the enterprise data warehouse in a structured, governed format that reliably fed BI reporting tools; this enabled parallel, conflict-free list management for a growing user base without the cost of duplicating models, established a governed data pipeline from individual input through to enterprise analytics, and created a reusable architectural pattern for other multi-user list management needs.
Polaris Migration & Platform Modernization
✔️ Delivered· Anaplan Polaris migration · model re-architecture · CloudWorks integration · Application Lifecycle Management (ALM) · performance optimization · Anaplan Data Orchestrator (ADO)
Problem — The existing Classic Engine model had grown in complexity and data volume over time, resulting in slower calculation performance and requiring workarounds (such as flattened hierarchies and concatenated dimensions) to manage scale. Data integrations were also largely manual, and there was no formal process for managing model versions across development, testing, and production environments — creating deployment risk.
Outcome — The migration involved reassessing the existing Classic Engine architecture and redesigning it around Polaris's native multi-dimensionality — eliminating flattened hierarchies and concatenated list workarounds — while rebuilding core calculation logic for Polaris's sparse-data handling to improve speed and scalability, automating previously manual data integrations across Anaplan, upstream ETL, the data warehouse, and downstream BI via CloudWorks, and applying ALM best practices for structured version control and synchronized deployment across environments; the result was significantly faster model calculations, elimination of manual data loads and their associated error risk, and a formal, lower-risk deployment process that improved overall platform stability.
Position-Based Workforce Cost Planning
✔️ Delivered· Anaplan workforce planning · Workday integration · scenario modeling architecture · regional cost normalization logic · stakeholder-driven forecast design
Problem — Workforce cost forecasting was previously handled through static spreadsheets that were difficult to update, lacked integration with the organization's live HR system (Workday), and made it difficult for business units to model the cost impact of future hiring or role changes without disrupting the primary forecast.
Outcome — The model was built around individual 'positions', covering both permanent employees and contractors as the core planning unit for more granular tracking of role duration, cost type, and status, integrated directly with Workday to pull real salary and benefits data by role/region as a data-driven cost baseline, with a normalization layer adjusting costs for genuine regional variances and manual override capability for key forecast drivers so business units could reflect their specific plans within a consistent methodology; a separate scenario analysis module let planners stress-test hypothetical hires and role changes without risk to the live forecast, with an approval workflow for importing validated scenarios, together improving forecast accuracy through live HR data, giving business units flexible scenario-testing capability, and streamlining the planning cycle with a controlled, auditable path from scenario to final forecast.