Prasun P, Senior Loans Administrator

Prasun P

Senior Loans Administrator

Qatar Gas Transport Company

البلد
قطر - الدوحة
التعليم
دبلوم, Certified Management Accountant (USA)
الخبرات
20 years, 9 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :20 years, 9 أشهر

Senior Loans Administrator في Qatar Gas Transport Company
  • قطر - الدوحة
  • أشغل هذه الوظيفة منذ يوليو 2015

Part of the Treasury team managing USD 10 Billion of Loans and USD 7 Billion in Derivatives

Create Financial Models for Loans and for Hedging Interest Rate Risk

Manage financial models and monitor for any discrepancy

Report to Management in case of any adverse variance

Ensure compliance with all Loan and Financing Agreements

Prepare cashflow calculation for meeting the various covenants

Preparation of budgets for Interest and debt settlement and cashflow

Prepare Certificates and calculation as required by Loan agreements

Liaise with bankers, lenders, Facility Agents and JV partners for their compliance and KYC purposes

Project dividend payable by the company, Subsidiaries and JV and prepare the necessary documents. Liaise with Legal department to ensure that the board resolutions etc. are in place

Ensure the cash waterfall is done on time for the various companies in my portfolio

Ensure debt settlement is done on time

Create MTM reports for the companies in my portfolio using the Bloomberg terminal

Handle Term Deposit in excess of USD 500 million

Key Person in the implementation of SAP TRM

Assistant General Manager - Finance في Protech Solutions
  • قطر - الدوحة
  • نوفمبر 2013 إلى يوليو 2015

•Financial Valuation of sister company for Venture Capital Funding using Excel Financial Modelling, Income Statement Forecasting and Discounted Cash Flow
•Liaise with Venture capitalists in USA, Europe and Middle East with regards to Financial models
•Assist Management in Valuing other companies that may be suitable for equity funding and Acquisition
•Create Business Plan for registration with Qatar Financial Center and Liaise with QFC team for registration
•Develop Cost control processes and track costs in order to ensure costs do not over run budgeted costs
•Review Financial Statement and analyze sales revenue, costs, expenses
•Develop detailed spreadsheets to identify trends and develop forecasts. Consolidate and analyze monthly results and budgets
•Contract negotiation with Suppliers and clients
•Adhoc reporting

Financial Planning Analyst في Al Jassim Group
  • قطر - الدوحة
  • مارس 2012 إلى أكتوبر 2013

• Reviewing all monthly/annual financial statements including profit and loss, balance sheet and associated financial statements, monthly closing of accounts, AP/AR, summaries, cash flow projections, ageing analysis report, other cost-benefit analysis and financial management reports.
• Analyzing key finance performance indicators/trends such as financial ratios and cross division comparisons including reports of financial benchmarks/ acceptable performance and comparison of actual results to budget.
• Evaluating all revenue and expenses of the company to determine their accuracy and ensuring all transactions are managed appropriately.
• Overseeing and analyzing volume performance, customer profitability/trend analysis and submitting the same to the senior management to effect speedy decisions.
• Computing operational and maintenance cost estimates.
• Negotiate with banks for facilities
• Review of the financial statements and analyse sales revenue and cost expenses for all business units
• Develop detailed spreadsheets identifying trends in revenue & cost.
• Forecast sales, cost and profitability for the companies various business units
• Ad hoc analysis of cost & profitability of the companies various products
• Analysis of monthly results and presentation of findings to top management
• Preparation and monitoring of the budgets for the business units of the company
• Investment analysis to identify weaknesses & opportunities for growth
• Conduct feasibility study of projects and present findings to top management
• Negotiate with banks, Insurance companies & other service providers for the companies various projects.
• Development of policies for the company
• Supervision of senior Accountants

Analyst / Senior Accountant في Inchcape Shipping Services WLL
  • قطر - الدوحة
  • أغسطس 2009 إلى مارس 2012

Finalization of accounting and cost accounting records
Studied and collected data with regard to cost of each service rendered to determine standards
Preparation of month end cost reports and determine variances
Reporting of variance to management and business units
Forecasting sales and cost for the division
Preparation of detailed budgets for the division
Preparation of management reports to be later used by top management.
Analysis of Government contracts to understand the effects on profitability.
Provide cost & profitability of contracts to top management to enable them in contract negotiation.
Supervise the input and handling of financial data and reports for the company's automated financial systems.
Compile and analyze financial information to prepare entries to accounts, such as general ledger accounts, and document business transactions.
Establish, maintain, and coordinate the implementation of accounting and accounting control procedures.
Monitor and review accounting and related system reports for accuracy and completeness.
Resolve accounting discrepancies.
Interact with client to clear any query that may be raised.
Experience on in-house ERP software DREAM.

Corporate Credit Manager في ICICI Bank
  • الهند - مومباي
  • أكتوبر 2008 إلى يوليو 2009

Analysis of the financial statements of the client company to determine the credit worthiness of the client.
Preparation of credit note for perusal by top management.
Presentation of the credit proposal to the committee to allow them to have an objective view of the credit worthiness of the client company.
Analysis of Client credit worthiness for Short term loans, Long term loans and Guarantees.
To interact with the Client and the Relationship Manager to have a thorough understanding of the business operation of the client.

Relationship Manager في Kotak Mahindra Bank
  • الهند - تشيناي
  • يوليو 2007 إلى أكتوبر 2008

Responsible for setting up of the NRI vertical for Chennai.
Setting up of tie-ups with shipping and IT companies for NRI referrals.
Recruitment of sufficient personal for services and acquisition of NRI clients.
Management of the existing wealth portfolio of the NRI client.
Acquisition of NRI clients.
Servicing of NRI client requirements.
Develop new and expand existing high net worth customer relationship for retail liabilities
Source new Bank Customers through external individual efforts and acquisition channels.
Ensure high levels of customer service orientation and application of bank policy
Cross selling existing bank products to customers.
Plan and conduct special sales initiative and events for prospective and existing clients.

Accountant في Imperrial Apparel Industries
  • الهند
  • مايو 2001 إلى مارس 2005

Preparation of month-end cost inventory reports
Analysis of costs to determine variances against standards
Ensuring that the journal entries are organized to report raw material accurately
Supervising the procedures involved in the monthly test counts in order to verify the accuracy of inventory balances
Verifying and analyzing the purchase price variance account
Keeping standard price cost updates as and when necessary
Advise management in minimizing the production cost of the company and maximize the revenue coming from various product lines
Preparation of budgets for the division

الخلفية التعليمية

دبلوم, Certified Management Accountant (USA)
  • في Institute of Management Accountant
  • يناير 2012
ماجستير, Finance
  • في ICFAI Business School
  • أبريل 2007
بكالوريوس, Accounting
  • في Calicut University
  • أبريل 2001

Specialties & Skills

Accounting
Microsoft Excel
Financial Analysis
MS Excel
Financial Analysis

اللغات

الانجليزية
متمرّس