Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Languages
Personal Information
Timeline
Generic

Nadimpalli Prudhvi Raju

Summary

To work with leading organization and to use my analytical thinking to the best of my ability combined with perseverance to contribute to organization’s growth and goal, as well as to attain my professional goal.

Overview

6
6
years of professional experience

Work History

Finance Department - Treasury Executive

Aurobindo Pharma Limited
09.2018 - Current

- Fund & Working Capital Management/Compliance -:

  • Effective utilization of funds available to meet the working capital needs, by forecasting the cash outflows, in order to maintain sufficient liquidity.
  • Borrowing credit facilities, i.e., fund-based/non-fund-based, depending on the requirements for the purpose of maintaining liquidity in order to meet the cash outflows forecasted by proper allocation of funds, considering the cost of capital, debt-equity mix, net working capital, financial ratios, etc.
  • For the purpose of availing the credit facilities under a multiple banking arrangement, negotiating the terms and conditions relating to sanctioned limits, including sub-limits, interest rates, various charges, documentation, forward contract exposure, financial covenants, and data to be submitted, etc. To be disclosed in the sanction letter upon finalization.
  • Stock statements are submitted to the various banks every month for the purpose of calculating drawing power, taking into consideration data relating to stocks, debtors, creditors, etc. By reducing the margin specified in order to comply with the sanction letter, by mentioning the secured and unsecured borrowings, both fund-based and non-fund-based.
  • Preparation of the Unhedged Foreign Currency Report submitted to the bank on a quarterly basis, matching with the financials and certified by the auditors, enables the banks to create a provision for the unhedged part of the transaction exposures as part of complying with the terms of the sanction letter.

- MIS/Financial Reporting -:

  • Accounting MIS reports are to be sent to the accounts department on a monthly basis, i.e., loans outstanding as of month-end, provision to be created for interest on various borrowings and supplier credit availed, and adjustment of prepaid interest on bills discounting to the interest accrued for the month.
  • Preparation of MTM reports for provision to be created for notional profit/loss for marking the forward contracts entered to the market value as of the month-end and forward contracts canceled during the month as a part of accounting MIS in our Oracle ERP accounting books.
  • Monthly finance cost workings with borrowings-wise segregation in Excel format on a monthly basis, in reconciliation with our books, by report generated from our Oracle ERP, for the purpose of trend-wise analysis, comparing with the previous months.
  • Preparation of quarterly MIS board notes to be submitted for the purpose of inclusion in the agenda to be discussed in the board meeting by incorporating data related to investment in foreign and domestic subsidiaries in the form of i) equity, ii) loans, iii) CCD, iv) OCD, forex board notes mentioning the exchange fluctuation bifurcation between receivables, payables, and working capital, loan OS at the end of the quarter, % finance cost out of O/S debt workings, aging analysis for receivables, payables, loans, forward contracts, etc.
  • Daily reporting in a specifically designed format to the top management, incorporating all the import, export, and treasury-related transactions for the respective day, i.e. Export and domestic collections, multiple import payments, gross and net debt after considering the EFFC and INR balances, forward contracts outstanding as of the end of that day, etc. For the purpose of monitoring the daily operations and comparing them with the previous days, months, quarters, and years mentioned in the same report, we aim to track and make decisions accordingly.
  • Reporting of the parity statement on a daily basis, arriving at gross and net parity across all the major currencies in which trading is done, i.e. Forward, Spot, TOM, and Cash Deal Contracts incorporate the data relating to export receivables, EEFC balances, import payables, loans outstanding, and forward contracts hedged against these exposures as part of risk management in order to mitigate financial risks.
  • Submission of data to the Company Secretarial team for contributing to the preparation of the Due Diligence report on a half-yearly basis, disclosing the data relating to the treasury operations, i.e. Loans outstanding, sanctioned facilities details, details of receivables, payables, loan outstanding, EEFC balances, and forward contracts hedged as of the respective half-yearly end.
  • Yearly presentation of data to the taxation team internally relating to the list of bank accounts in operation, loans taken during the year, loans repaid during the year, etc. As a part of the income tax audit for Form 3CD.

- Bank Account Management -:

  • Submission of all documents, including the board resolution, constitutional documents, KYC forms of the company, and operating signatories, etc. Relating to current account opening in various banks, i.e., opening of current accounts for availing the sanctioned credit facilities, opening of a current account in the nature of Compulsory Convertible Debentures (CCD) for the infusion of funds in the form of CCD, exchange earners foreign currency (EEFC) for the purpose of repayment of export credit loans availed, payments in foreign currency, receiving export proceeds remittance, etc.
  • For effective streamlining of online payments, such as vendor payments, statutory payments, regulatory payments, or intra-company and inter-group company fund transfers, as part of fund allocation, routing through the existing accounts requires the submission of necessary documents to avail various corporate net banking facilities offered, followed by login management for the initiation and authorization of transactions done online in a fast, secure, and transparent way, complying with all the applicable rules and regulations.
  • Email indemnity for email instructions relating to the operation of existing accounts for the purpose of processing transactions routed in compliance with all the terms and conditions, indemnifying the customer by the bank.
  • Submission of documents and KYC to the banks for the purpose of periodical KYC review compliance of existing bank accounts in a timely manner, enabling the organization to comply with all the regulatory aspects as applicable, and also maintaining a cordial banking relationship.

- Accounting-:

  • Accounting entries to be passed on a monthly basis for interest on loan borrowings for both outstanding and repayment during the month, loan repayments made during the month, fund transfer from Aurobindo to its subsidiary companies, intercompany bank accounts, and bank charges.
  • Accounting entries are to be passed in our Oracle ERP accounting books before the close of the monthly accounting period, ensuring proper compliance with IND AS, contributing to the line items in the financial statements, such as finance costs, borrowings as a part of financial liabilities, investments, etc.

- Other Supporting Services -:

  • Daily updating of the closing balance of bank accounts in the form of EEFC, INR account balance, and O/S borrowings balances, and their repayments in Microsoft Excel.
  • Submission of required documents and their KYC for the issuance of prepaid cards and their possession as a part of internal control.
  • Monthly reconciliation of forward contact confirmations received from banks for forward contracts entered as a part of hedging strategies for risk management, with our internal forward contact data, and submitting to the bank after taking approval from the head of the department.
  • Preparation of the import payment schedule due until the respective month-end by segregating it on a weekly basis for the purpose of hedging through import forward contracts to mitigate the risks related to foreign exchange fluctuations.
  • Sharing of necessary data within the department, intimating the mode of operation as per the board resolution of the respective bank account for the payables team for making inland and foreign letter of credit payments, customs duty, regulatory, statutory payments, and bills acceptance against LC established/amended and bill lodgment for the receivables team.
  • Obtaining data from others departments enabling the treasury team for financial management by forecasting the cash outflow as per the due date of the payments related to trade finance and others and export and domestic collections to be received in order to calculate the working capital gap and avail the credit facilities in order to cover the working capital gap

Education

MBA Finance -

IGNOU University
01-2024

M.COM -

Andhra University
01-2017

CA Inter (IPCC) -

Institute of Chartered Accountants of India

Skills

  • Microsoft Office
  • Oracle ERP

Hobbies and Interests

  • Playing Cricket
  • Hanging out with friends & family

Languages

  • English
  • Hindi
  • Telugu

Personal Information

  • Father's Name: N V S Gajapathi Raju
  • Mother's Name: N V Lakshmi Kumari
  • Date of Birth: 06/30/91
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Married

Timeline

Finance Department - Treasury Executive

Aurobindo Pharma Limited
09.2018 - Current

MBA Finance -

IGNOU University

M.COM -

Andhra University

CA Inter (IPCC) -

Institute of Chartered Accountants of India
Nadimpalli Prudhvi Raju