Nabojoyti Deb

  • London

Financial Modelling Analyst

Summary

A skilled finance professional with broad knowledge of financial modelling and with proven ability to deliver value added analyses, is seeking a challenging position where extensive experience will be utilised and further developed.

Work History

Work History
Dec 2014 - Present

Financial Modelling Analyst

L&Q Group

Duties:

   Financial Model development

  • Build and maintain complex financial models, with detailed cashflow, income statement and balance sheet.
  • Development of investment appraisal and valuation models (Includes DCF, NPV, IRR, JV funding structure etc.).
  • Auditing and improving existing financial models to facilitate accurate and improved calculation time.

   Business Planning, Strategy & Capacity Development

  • Consolidation of subsidiary accounts, intercompany adjustments and long term forecasting.
  • Financial stress testing, sensitivity analysis and evaluation of multiple scenarios.
  • Generate ideas for new strategy for the group, and function as part of a specialist team dedicated to maximizing financial capacity within a defined control framework; with an emphasis on financial planning, capital development, asset management and project activity.

   Strategic Reporting & Analysis

  • Prepare clear and concise presentation of financial analysis including metrics, for executive Group and Group Board finance papers.
  • Maintaining, improving and reporting of the group business plan and ensuring timely submission of regulatory returns.

   M&A Research & Analysis

  • M&A modelling – Auditing financials, forecasting based on publicly available information, valuation models, scenario testing, divestiture/carve-out strategy and planning.

   Market Research

  • Perform sector research and financial analysis, supporting senior business partners engaged in discussion with the GLA and government policy makers.
  • Ongoing market research assessing impact on Group, as well as the sector as a whole.

    Achievements:

  • Developed an M&A database with a focus on identifying potential suitable partners.
  • Created a competitor benchmarking model and identified value creation opportunities for the group.
  • Improved the business plan reporting by simplifying key messages through improved visualisation and use of analytics.

 

Oct 2013 - Dec 2014

Interim Management Accountant

City University London

Duties:

Business Partnering, Budgeting & Forecasting

  • Business partnering with non-financial stakeholders to deliver consolidated budgets, forecasts, and 5-year plan in line with the overall group strategy.
  • Meeting with senior stakeholders (e.g. Heads of Departments, COO, BDMs) to deliver interpretation of financial performance, headcount and other analysis in non-technical accounting terms.

Reporting, Analysis & Project Accounting

  • Production of profit and loss and various KPI reports with detailed income, non-staff expenditure, headcount and various analyses with commentary to deliver performance updates and to enable management decision-making.
  • Providing insightful, value-added and relevant financial information for control of expenditure, budgeting, forecasting and for business decision-making.
  • Project accounting, implementing financial processes in line with internal policies and developing associated financial reporting requirements.
  • Year-end accounting – Accrual, prepayments, deferred income calculation, final P&L and KPI reporting.

 Process Improvements & Modelling

  • Building, developing and maintaining complex financial and operational models for budgeting and forecasting.
  • Leading on process improvements and creating efficiencies within the team.

Achievements:

  • Annual staff award winner for outstanding contribution to finance for innovation and sharing expertise across the team to improve reporting and analysis.
  • Developed VBA based model to budget, forecast, and create upload data for ERP system; improving on previous methodology by reducing time taken to create data from hours to seconds.
  • Improved staff headcount and cost forecasting by improving staffing models.
  • Utilized VBA/macro to automate monthly report production; reducing time taken to create monthly reports from days to minutes.
  • Developed a new cost allocation model enabling effective assessment of individual program.