Lead - Financial Modelling

Role & responsibilities:

Build, modify, audit and operate Microsoft Excel based Financial, Economic and Quantitative Models to support:

- Business, operational and financial decision making

- Techno-commercial feasibility studies for new projects or business diversification and business expansion projects

- Cost-benefit analysis for multiple options of business ventures and business investments

- Optimization of Capital Mix decisions (Debt, Equity, Working Capital, Fixed Capital etc.)

- Simulation analysis for different forecasting scenarios with respect to Macroeconomic factors, Market Environment and Industry specific Market Factors, internal technical and operational parameters and factors, business volumes or output

- Forecasting of Financial Statements (P&L A/C, Balance Sheet, Cash Flow / Fund Flow Statements etc.) and support Budgetary Control process

- Build excels based quantitative and financial models for Upstream, Midstream and Downstream Oil & Gas Businesses following the conditions and the logic as stipulated in the relevant commercial agreements and arrangements related to:

1. Cash Waterfall Sequencing (Revenue, Opex., Taxes, Transfer to designated reserve accounts, Cost Recovery, Financing Charges, Profit Distribution etc.)

2. Funding of the Project and repayment of Debt Financing / Advance through Cost Recovery Mechanism

3. Computation of financing cost and payment of financing cost

4. Computation of various forms of taxes, depreciation schedules etc. (based on Contractual arrangements as well as relevant statutory provisions)

5. Distribution of Surplus funds at various stages to various stakeholders such as Service Providers, Govt. Agencies, Financiers, Shareholders etc. as per the agreement.

- Provide relevant support to track, forecast and report on the progress of the payments and calculations relating to Cost Recovery and Compensation.

- Using the model, determine and advice on the likelihood of a shortfall in internal rate of return (IRR) related to the project.

- Integration of Excel Models, as a Business and Financial Analyst, and not as an IT Database Specialist, with Corporate Data Warehouses and data from Transaction Processing and Business Intelligence Systems (ERP and BI Systems).

- Design, build and implement other financial & business models as may be directed by Senior Management.

- Identify key financial and non-financial risks and recommend actions for mitigating those risk.

- Apply appropriate sensitivity and scenario analysis to support model outcomes and decisions.

- Financial & Commercial Due Diligence on new deals and new projects.

- Developing, reviewing and negotiating financial and commercial terms and conditions in agreements.

- Financial and cost management of new projects.

- Supporting vendor, partner, customer negotiations as a financial and commercial specialist.

- Supporting Management review and approvals of new projects from financial and commercial perspectives.