[
  {
    "name": "Invoicer",
    "url": "https://invoicer.farhan.app/",
    "description": "Open-source invoicing tool.",
    "tools": [
      "Open source"
    ]
  },
  {
    "name": "London Buses",
    "url": "https://london-buses.farhan.app/",
    "description": "Open-source London bus data explorer.",
    "tools": [
      "Open source"
    ]
  },
  {
    "name": "Design System",
    "url": "https://design-system.farhan.app/",
    "description": "Open-source design system and token library.",
    "tools": [
      "Open source"
    ]
  },
  {
    "name": "Web App Blueprint",
    "url": "https://app-blueprint.farhan.app/",
    "description": "Open-source starter blueprint for web apps.",
    "tools": [
      "Open source"
    ]
  },
  {
    "name": "Revenue Projection With Indexation Model",
    "tools": [
      "Excel"
    ],
    "highlights": [
      "Revenue forecasting model handling multiple contracts and defined periods with CPI indexation triggered on anniversary dates.",
      "15-nested-condition formulas automating recognition across 6 scenarios including mid-period start/end and cross-calendar-year handling.",
      "Dual-track projections separating baseline revenue from indexation increments for granular £XXM revenue composition.",
      "Dynamic projection model enabling monthly updates for real-time financial planning."
    ]
  },
  {
    "name": "Business Performance Balanced Scorecard",
    "tools": [
      "Looker"
    ],
    "highlights": [
      "Looker dashboard consolidating 10+ financial and non-financial metrics.",
      "Integrated profitability, new business wins, incident reports, tickets, attrition, market cap, and outstanding transactions.",
      "Weighted scoring across metrics for a holistic performance view.",
      "Presented monthly to the business; outcomes linked to company-wide bonus allocation."
    ]
  },
  {
    "name": "Campaign-Level Profitability Tool",
    "tools": [
      "Excel VBA",
      "SAP",
      "Salesforce"
    ],
    "highlights": [
      "VBA solution reconciling Salesforce, programmatic trading platforms, and SAP for campaign-level profitability.",
      "Logic joining datasets on multiple criteria and allocating SAP revenue, media costs, and overheads from client to campaign level.",
      "Automated transaction enrichment and cost apportionment for granular ROI insights.",
      "Scaled into an internal Python + API product."
    ]
  },
  {
    "name": "Automated Board Reporting",
    "tools": [
      "Tableau",
      "Salesforce"
    ],
    "highlights": [
      "Tableau automating monthly board reporting, replacing manual Excel charts.",
      "Linked to Salesforce forecasts, campaign profitability, HR headcount, and overhead allocations.",
      "Month-end date selector refreshes revenue, costs, profitability, overheads, EBITDA, and margin charts.",
      "Actuals vs forecasts and trends ready for direct transfer into board packs."
    ]
  },
  {
    "name": "Weekly Salesforce Pipeline Analysis Automation",
    "tools": [
      "Excel VBA"
    ],
    "highlights": [
      "VBA tool automating weekly Salesforce pipeline analysis.",
      "Archives weekly campaign data, rolls forward prior week, prepares fresh template.",
      "Variance tables, confidence indicators, and traffic-light dashboards at client, regional, and brand levels.",
      "Charts and tables linked into Word reports for quick SLT commentary."
    ]
  },
  {
    "name": "SAP Project Code Management Tool",
    "tools": [
      "Excel VBA",
      "Workday",
      "SAP"
    ],
    "highlights": [
      "Manages 1,000+ SAP project codes across a 500+ person agency.",
      "Integrates HR (Workday), finance workflows, and project ownership matrices.",
      "Flags invalid codes, leavers on active projects, pending workflows, and incorrect approval hierarchies.",
      "Automated notifications using ownership and approval matrices."
    ]
  },
  {
    "name": "TfL Route Optimisation Program",
    "tools": [
      "MATLAB"
    ],
    "highlights": [
      "Calculates cheapest travel routes across TfL and connecting rail networks.",
      "Dijkstra's algorithm evaluating routes with zones, connections (including walking), and line-specific costs.",
      "Time-optimised mode for fastest routes with associated costs.",
      "Comprehensive datasets of stations, zones, and route matrices for accurate fare and time calculations."
    ]
  }
]