Arup Dutta, Senior Executive Controlling

Arup Dutta

Senior Executive Controlling

Wacker Metroark Chemicals Private Limited

Location
India - Kolkata
Education
Master's degree, Finance
Experience
6 years, 3 Months

Share My Profile

Block User


Work Experience

Total years of experience :6 years, 3 Months

Senior Executive Controlling at Wacker Metroark Chemicals Private Limited
  • India - Kolkata
  • July 2015 to March 2018

Treasury-:

 Manage relationships with banks and Financial houses.
 Preparing of budgeted cash management for the year.
 Monthly rolling forecast of cash budget.
 Maintaining liquidity for day to day Working Capital Management for efficient running of business.
 Negotiating with the bank for different rates for investments and on discounting of bills against inland LC.
 Forecast of daily cash requirement and executing daily financing decisions.
 Managing all aspects of in house investment.
 Manage long-term and short-term investment strategies.
 Direct, monitor and trade investment portfolios in the Fixed Income sector.
 Analyze and reporting of the foreign exchange exposure to the C.F.O.
 Trading on Foreign Exchange (Spot Deal with the AD category banks or agents).
 Monitor and review of EEFC-Account.
 Natural hedging of foreign currency.
 Hedging through Forward booking and Vanilla option for hedging of currency.
 Buyer’s Credit.
 Investment in Capital Market.
 Letter of Credit Discounting and Issuing.
 Opening and closing of Escrow Account for the investment purpose.
 Opening and Closing of Current Account for various operations as required by the company.
 Submission of documentation from time to time for RBI reporting as well as for Local Banks.
 Coordinate and obtaining short term loan as packing credit for the short term working capital.
 Calculation of Interest on short term loan.
 Cash Pooling.
 Cash Management.
1. Payable Management.
2. Receivable Management.
3. Short term Investment Management.
 Negotiating with the bankers for charges.
 Successfully negotiated with the bank for discounting of Inland Letter of Credit.
 Review of documents for Bank Guarantees from Customer.
 Coordinated with the bank for opening of Bank Guarantee.
 MIS on Treasury as per management requirement.
 Preparing documentation for A1 and A2 payments.
 Preparing of documents for getting short term packing credit.
 Preparing and submitting documentation to the bank as per the RBI guidelines for foreign exchange.
 Closure and opening of Bank Accounts.
 Treasury Accounting.
 Assists in Monthly closure of books.
 Issue of Bank Guarantee.
 Assisting in Audit.
 Circulating reports on various currency fluctuations against INR as per the management requirement.
 Scheduling payment to Foreign Vendors in both A1 and A2 category and Domestic payments.

Accounts Receivable-:

 Coordinating with the CSR in order to have sufficient in flow of funds from the customer.
 Responsible for inflow of funds from customers from the sale proceeds.
 Balance confirmation from debtors for auditors.
 Debtors ageing.
 MIS on Debtors on monthly basis.

Accounts Payables-:

 Balance confirmation for creditors from and to auditors.

Reporting-:

Directly to the CFO of India Operation and to the Group Treasury Head.
MIS preparation for Management on Debtors and on Forex (INR against Reserve Currency Bucket).

Additional responsibilities and objectives fulfilled-:

 Analyzed and proposed the management for currency swap for billing in the Local currency for purchase of materials from the Group companies.
 Overdue collections from Debtors were reduced to less than 10% from the total debtors.
 Investment in short term has been increased from previous years.
 Implementation of net banking and cheque printing from the system.

Senior Executive Finance and Accounts at Srei Infrastructure Finance Limited
  • India - Kolkata
  • August 2014 to July 2015

Treasury-:

 Maintain relationships with the financial institutions.
 Cash Management for the year.
 Monitor and review of cash pooling.
 Monitor and review of interest payable to Financial Institution.
 Interest calculation of overdraft on day to day basis.
 Review of service fees charged by the bank.
 Responsible for managing teams.
 Responsible for managing outsource.
 Daily reporting on forex.
 Opening and closing of Escrow Account for the investment purpose.
 Closure and opening of Bank Accounts.
 Monthly cash reporting to the Group Treasury.
Accounts Receivable-:

 Responsible for Customer Reconciliation and providing NDC to customers.
 Raising of Debit note and Credit note where necessary.
 Processing of bills.
 Keep tracking of bills receivable from customer.
 Responsible of receipt entries for the money receipt from the customers.
 Following on the customers for delayed payments.
 Reporting to the Finance Controller on Month wise receipt from the Customer.

Executive- Finance at Jain Infraprojects Limited
  • India
  • January 2012 to July 2014

Key Accountabilities:


 Preparing the documents for the ILC (Inland Letter Of Credit).
 Sap super user.
 Responsible for reconciliation of G/L and Accounts Payable.
 Responsible for handling of cash book for head office.
 Preparing MIS for various reporting to the Management on monthly basis and yearly basis.
 Tax operation-:
 Co-ordination with Accounts & Finance & Operation Team for procuring the data of Consumption of Consumables, labour and other direct Overhead for the purpose of deduction to be claimed against VAT payable.
 Preparation of Data for filing VAT & CST Return
 Arrangement of C form and WAYBill for our Rajasthan operation and Bihar operations.
 Preparation of MIS in respect of state wise Tax generated and updating of case status.
 Banking Operations-:
 Responsible for BRS in SAP and also in Tally.
 Keeping tracks of Cheques.
 Responsible for keeping up to date bank accounts.
 Keeping tracks of different interest rates in bank for Investment Purposes.
 Liasioning with bank.
 Treasury Operations-:
 Preparing documents for Letter of Credit.
 Issuing bank Guarantee and amendments.
 Preparing proposal for Working Capital Loan and Term Loan.
 Negotiating with the banks on rates for investment.
 Coordinating with the banks for investing in the Commercial Papers.

Education

Master's degree, Finance
  • at George College- Department of Management Studies
  • January 2012

2012 Master of Business Administration in Finance from WBUT, Kolkata.

Bachelor's degree,
  • at Calcutta University
  • January 2008

2008 B.Com (Hons) from Calcutta University, Kolkata.

High school or equivalent,
  • at ST. Thomas Boy's School
  • January 2005

2005 12th from ST. Thomas Boy's School, C.I.S.C.E. and Kolkata.

High school or equivalent,
  • at ST. Thomas Boy's School
  • January 2003

2003 10th from ST. Thomas Boy's School, C.I.S.C.E. and Kolkata.

Bayt Tests

IQ Test
IQ Test
Score 70%

Specialties & Skills

MBA Finance
Accounts Payable
Banking
General Ledger
ACCOUNTS PAYABLE
BANKING
BANKING OPERATIONS
FINANCE
Balance sheet

Languages

Bengali
Expert
Hindi
Intermediate
English
Intermediate

Training and Certifications

SAP-FICO (Training)
Training Institute:
Imark Technologies
Date Attended:
January 2013
Duration:
160 hours
Working Capital management (Training)
Training Institute:
SGI Pvt Ltd
Date Attended:
January 2011
Duration:
320 hours

Hobbies

  • Gardening
    I have been able to plant a few species of rose plants and a mango tree. Despite of the natural effects they are been able to survive and were able to bear fruits.