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
SAP Business Objects
MS Access
Hyperion
Oracle Essbase
PowerPoint
Financial Analysis
Forecasting
Financial Modelling
Salesforce
Power Query
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