Shakir Lokhandwala, Commercial Finance Sr. Executive – E-Commerce, Modern Trade & CSD

Shakir Lokhandwala

Commercial Finance Sr. Executive – E-Commerce, Modern Trade & CSD

Mondelez International (Formerly Cadbury India Limited)

Location
India
Education
Master's degree, MBA
Experience
15 years, 9 Months

Share My Profile

Block User


Work Experience

Total years of experience :15 years, 9 Months

Commercial Finance Sr. Executive – E-Commerce, Modern Trade & CSD at Mondelez International (Formerly Cadbury India Limited)
  • India
  • My current job since September 2013

• Credit controller for E-Commerce, Modern Trade & Govt Channels.
• Handling of Overall Commercial operation of E-Commerce, Modern Trade & Govt Channels.
• Maintaining low DSO of E-Commerce, Modern Trade & Govt Channels .
• Handling & Monitoring Utilization of E-Commerce, MT & Govt Channels Credit limit Management.
• Monitoring and Handling the Receivables of E-Commerce, Govt Channels & Modern Trade Customers.
• Preparing of Profit & loss accounts for Govt Channels on Monthly basis.
• Handling & Monitoring Pricing of E-Commerce, Modern Trade & Govt Channels.
• Managing timely payouts for Claims of E-Commerce & MT Customer which includes Visibility, Promotions, OFF Invoices.
• Make necessary provision for claims on month end.
• Reconciliation of E-Commerce & MT customer on an monthly basis to ensure there are no gaps
• Assisting in drafting of Standard Operating Procedures (SOP) for better controls & risk reduction & monitoring the effective implementation of the same.
• GL certification on Black Line.
• Handling of Monthly Provision of bad debts.
• Preparing and streamline the Price change and Grammage change process for Govt Channels.
• Timely submission of documents for Price Revision/ Grammage change/ one to one replacement/ new introduction/ Case pack change/ graphic change in Canteen store Department ( Govt Channels)
• New Product launch of OREO biscuits in Govt Channel with all required documents.
• Handled the New Business launch in CPC (Govt Channel) with timely submission of Finance & Business documents.

Commercial Finance Officer at Nivea India Pvt Ltd (An affiliate of Beiersdrof)
  • India - Mumbai
  • February 2012 to May 2013

• Monitoring and Handling the Receivables of Modern Trade Customers/ Direct Key Accounts.
• Monthly Reconciliation of all Direct Key Accounts.
• Handling overall account receivable of Institutional Sales i.e. Canteen and Store Department.
• Reporting of Weekly Debtors Ageing of Modern trade Customers to Head of Finance and Brand Control.
• Managing and accounting the Claims of MT Customer which includes Visibility, Promotions, OFF Invoices and Octroi.
• Updation of TOT coordinating with Sales Team.
• Timely payout the Claims as per TOT and make necessary provision for claims on month end.
• Preparation of monthly report of Actual V/S Budgeted for Visibility and Promo Claims.
• Handling ‘C’ Forms of all the MT Customers.
• Fortnight Customer Visit as per requirement for Reconciliation.

Assitant Commercial Officer at Tata Chemicals Ltd
  • India - Mirat
  • September 2010 to February 2012

JOB PROFILE (Change in role)

• Monitoring and Reporting of Daily Sales Report of all India of all the products to Top Management on daily basis.

• Monitoring and reporting Domestic and International Debtors Age Analysis Report (Zone wise) on daily basis.

• Handling overall account receivable of Institutional & Canteen and Store Department Accounting.

• Monitoring and reporting all India Stock report on daily basis.
 Reporting total Bulk, Packed, Materials and in transit Stock available in all the Zones.
 Calculating Stock in number of days for the particular month.
 Reporting total Budgeted Production and Asking rate of the production for the month.
 Reporting Target of all India CFA’s and future Schedule production to complete the target.

• MIS on Credit Limit Utilization report on monthly basis and Analysis of Customers Credit Management System.

• SAP FICO, MM, SD Modules.(ECC 6 Version)

• Exports accounting in SAP and various Pre and Post Shipment activities.

• Handle Exports Letter of Credit.

• Keep a track on all Exports Documents to be sent to the Customer at the time of the Shipment.

• To prepare the Monthly Commercial Docket and report the same to Top Management

• To Collect the Monthly reports from all the India RCM’s and consolidate them to prepare the Commercial Docket.

• To Analysis the following reports on monthly basis report them to Top Management.

 Rent Analysis.
 Professional Fees Analysis.
 Service charges.
 Advertisement Analysis.

• To handle the whole Export Profile start from Revenue, Contribution & Profit and report the same to the Top Management on monthly basis.

• Prepare the COO report on monthly basis and handover to the concern person.

• Prepare Monthly SBUC presentation.

Sr. Executive in Accounting and finance at Intelenet Global Services
  • India - Mumbai
  • May 2008 to September 2010

Worked with Out Source Company: BEST BUY (USA & CANADA)

 To handle monthly Debit balance

• Served on a report called “Debit balance”.
• The Report includes the data of those vendors to whom the funds were wrongly transferred due to certain error or overpayment while processing the invoices.

 Responsibility
• To follow up on the refund of the wrongly paid/ over paid amount with the vendors.
• Update the amount in the report.


 Handling Electronic uploads and Appliance profile

• It’s the kind of invoice process which get upload in the excel sheet called as More4Apps.

 Responsibility
• To process the Invoice update the vendors on the same.
• At the end of day the report run in oracle to get the invoice paid.

 Handling Advertising profile.

• Advertising are those invoices which get paid through Oracle system.
• Run the Report in Oracle
• Pay off the invoices at the earliest
• Update the vendors about the payment status.


 Deputed to U.S.A(BEST BUY .Co) to work with On - Shore team members for the period of 6 Months:-

• To look entire payment processing (Cheque processing).
• To get the Cheque printed.
• To mail the Cheques to the appropriate address. (Vendors)
• Handle monthly Refunds Cheques.
• Handling of AP escalation e-mails.
• Attending Conferences with Clients
• Attending Conference Calls with Off- Shore team
• Coordinating with Off - Shore team on regular bases


 Deputed to U.S.A (BSET BUY) to Train the On - Shore Team for the period of 6 Months:-

• Trained the On - Shore team on payment processing for 2 month
• Monitored the team members for 4 months.
• Attending conference & Meetings with Clients.
• Handling of AP escalation e-mails.
• Coordinating with Off - Shore team on regular bases
• Attending Conference Calls with Off- Shore team

Education

Master's degree, MBA
  • at SIES College of Management studies
  • July 2011
Bachelor's degree, Accounts & Taxation
  • at Vartak College ( Mumbai University)
  • April 2007

Accounts & Taxation

High school or equivalent, Maths
  • at St Francis High School
  • April 2001

Specialist in Mathematics.

Specialties & Skills

Credit Control
Accounts Payable
Accounts Receivable
Commercial Credit
Finance Operations

Languages

English
Intermediate

Hobbies

  • Driving