Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Pravakar Dutta

Chartered Accountant
Assam

Summary

Chartered Accountant with 4 years of experience in Financial Planning and Analysis. Area of expertise includes Financial Modeling, Financial Analysis, Variance Analysis, Management Reporting, Revenue Forecasting, Internal Audit and Accounting.

Overview

8
8
years of professional experience
7
7
years of post-secondary education
3
3
Languages

Work History

Finance Analyst

Cisco Systems
Bangalore, Karnataka
04.2019 - Current
  • Part of CX FP&A team, managing the CX revenue portion with an annual turnover of $12B
  • Developed close partnerships with business finance partners, providing regular financial reports on a daily, weekly, monthly, quarterly, and ad hoc basis as needed
  • Assisted in forecasting, planning, and budgeting of bookings and revenue for the CX businesses by providing accurate and timely information.
  • Rolling over of monthly forecast models of BCS and AppD Revenue (two service portfolios of cisco)
  • Forecasting of unbilled deferred revenue of CX business on monthly and quarterly basis
  • Deep dive analysis of revenue by components such as Revenue from Current Month Bookings, Deferred Revenue, Unbilled Revenue etc, finding the root cause of variance against forecast and following up with revenue recognition and invoicing team to ensure meeting the monthly revenue forecast and mitigation of revenue leakage.
  • Publishing comprehensive analysis packages such as Weekly Business Review and Weekly Revenue tracker that is regularly looked by the top-level management such as SVPs, VPs, and Directors.
  • Development of analytical dashboards using MS Excel, Power Query, MS Access, SAP BO and PowerPoint.
  • Reporting of SaaS and Services’ metrics such as ACV, TCV, AOV, ARR, ATR, IQRR, New/Renew, Penetration Rate, Attach Rate, Contract Term, Remaining Performance Obligations (RPO), Backlog etc.
  • Standardization and automation of existing dashboards.

Industrial Trainee

General Electric
Bangalore
08.2017 - 08.2018
  • Responsible for Testing of Internal Control of Sales,
  • Purchase, Custom, and T&E processes
  • Designing of Risk and Control Matrix, coordinating with cross functional team to collect sample, conveying of control failure and follow up
  • Report to management about asset utilization and internal control test results and recommend changes in control and financial activities.

Article Trainee

Sanjay Hazarika & Co
08.2015 - 08.2017
  • Conducted Internal Audits for various organizations including Government Organizations, Trusts, Educational
  • Institutions, Print Media, and Pvt Ltd companies;
  • Managed tax planning and compliance for clients, handling
  • Income Tax, TDS, Service Tax (now GST), and VAT matters, including leading a TDS team with 30 clients;
  • Handled various compliances such as foreign remittance certificate (15CA/CB), ESIC, PF Compliance, utilization certificate, and net worth certificate.

Education

Chartered Accountancy - Accountancy

The Institute of CharteredAccountants of India
Guwahati
12.2013 - 05.2018

B.Com - Accounting

Gauhati University
07.2012 - 05.2015

Skills

undefined

Accomplishments

  • Received APJC High Five Award for automating and standardizing the process of reporting weekly business review by cutting the preparation time by 50%.
  • Received CFO Award for Operational Excellence for creating an analysis on Contract Term
  • Awarded with 23 connected recognitions awards from various leaders in finance for numerous reasons such as creating of new dashboards, process improvements and supporting extensively.

Timeline

Finance Analyst

Cisco Systems
04.2019 - Current

Industrial Trainee

General Electric
08.2017 - 08.2018

Article Trainee

Sanjay Hazarika & Co
08.2015 - 08.2017

Chartered Accountancy - Accountancy

The Institute of CharteredAccountants of India
12.2013 - 05.2018

B.Com - Accounting

Gauhati University
07.2012 - 05.2015
Pravakar DuttaChartered Accountant