Roles & 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:

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

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

- Computation of financing cost and payment of financing cost

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

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

- 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

Qualifications:

- A college degree in Accounting or Finance or Business Management and.

- An MBA with a specialization in Finance or a professional accounting or finance qualification like CA,

CPA, CFA

KEY INTERFACE:

- Senior Management

- CFO/Head of Finance & Accounts

- Corporate Finance & Accounts

- Project Head (Technical) and Project Technical & Operations Team

- Legal & Commercial Department

- Business Development Department

- Age : 35+ Years

- 9-15 years of relevant specialist experience as a Senior Financial Modeler, additional generic experience in financial controllership and accounting functions is desirable.

- Prior experience in large Upstream oil and gas industry companies or in a reputed investment bank or a Big 4 Consulting Organization will be highly desirable

- Strong problem solving and decision-making skills, with ability to evaluate alternatives and provide recommendations on key business issues.

- Deep and advanced Excel modelling skills. Proficiency in VBA (added advantage)

- Statistical Analysis Tools like SAAS etc additional advantage

- Must be a good team player with positive energy.

- Well-developed written and oral communication skills. & Good attention to details

- Fluency in English, orally and in writing, is a must and other languages such as French will be an asset.