{ "me": { "name": "Farhan Munim", "handle": "farhan.app", "location": "London, UK", "contact": "hello@farhan.app" }, "resources": [ { "label": "Website", "url": "https://farhan.app/", "type": "site" }, { "label": "LinkedIn", "url": "https://www.linkedin.com/in/farhanmunim/", "type": "social" }, { "label": "GitHub", "url": "https://github.com/farhanmunim", "type": "social" }, { "label": "YouTube", "url": "https://www.youtube.com/@farhan-app", "type": "social" }, { "label": "Buy Me a Coffee", "url": "https://buymeacoffee.com/farhan.app", "type": "support" }, { "label": "PayPal", "url": "https://www.paypal.com/paypalme/farhanmunim", "type": "support" } ], "projects": [ { "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." ] } ], "work": [ { "role": "Commercial Finance Analyst", "company": "Stagecoach London", "current": true, "highlights": [ "Ownership of revenue streams, acting as the primary finance contact for revenue performance.", "Financial pricing and commercial evaluation of new route tenders, applying commercial judgement, scenario modelling, and risk assessment.", "Weekly TfL claims, monthly revenue forecasts, and period-end journals and accruals.", "Period-end P&L and performance reviews with depot management and managing directors.", "Supporting contract variations, service changes, and renewals; maintaining a central contracts and pricing database.", "Automating revenue and performance reporting through VBA." ] }, { "role": "Finance Analyst", "company": "SEGA Sports Interactive", "current": false, "highlights": [ "Consolidating KPIs into monthly management decks and enriching P&Ls with variance analysis.", "Developing forecasts, cash and amortized P&Ls, budgets, and scenario-based medium-term plans.", "Leading cost tracking across business areas, identifying risks and opportunities.", "Modelling royalties, analysing FX rate impacts, and assessing language profitability.", "Automating P&L templates incorporating studio costs, revenue, licensing, marketing, and development services.", "Supporting FP&A processes including greenlight evaluation for new products." ] }, { "role": "FP&A Analyst", "company": "Shell Energy Limejump", "current": false, "highlights": [ "Produced monthly board management decks aggregating Looker and other sources.", "Partnered with P&L owners on actuals and forecast trajectories.", "Led the balanced scorecard incorporating financial and non-financial KPIs for performance and bonus allocation.", "Executed R&D business casing for £2.5m in development costs.", "Built customer lifetime valuation models for business development.", "Variance analysis to evaluate financial performance and identify drivers." ] }, { "role": "FP&A Analyst", "company": "Mediacom", "current": false, "highlights": [] }, { "role": "Systems Accountant", "company": "Publicis Group", "current": false, "highlights": [] } ], "services": [ "Web development (code and no-code including WordPress)", "BI and Data (advanced Excel, VBA automation, Tableau dashboards)", "Property (management and compliance)" ] }